MIDAS Knowledge Base

MIDAS is capable of exporting invoices from your booking system to Xero accounting software.

Invoices are exported in a specially formatted CSV (Comma Separated Values) file which may then be directly imported into Xero.

To export invoices from MIDAS:

If you do not have access to this page, please check with your organization's internal MIDAS administrator who will be able to grant additional permissions as necessary.

1. On the export page, select the "Invoices" tab
2. Next, select the type of invoices you wish export (Regular, Deposit, Cancellation, or Credit Notes)
3. Select "CSV File (Xero)" in the format drop-down
4. An additional Xero-specific "Account Code" field is shown. Enter the Xero Account code you wish to use for the invoices you'll be importing into Xero.
5. Click Export
6. You'll be prompted to save the generated CSV file to your device

To import your invoices into Xero:

1. In Xero, go to "Business" menu and select "Invoices" (for importing invoices) or "Sales overview" (for importing credit notes).
2. Click "Import".
3. Click "Browse" and then find and select the CSV file you've just saved from MIDAS.
4. The exported data from your MIDAS system will also include client contact address details for each invoice. If you wish to update Xero with the latest client data from your MIDAS system, select "Yes" to the question "Would you like to update contact address details?", otherwise, select "No".
5. For the question "Is the UnitAmount field tax inclusive or exclusive?", make sure you select "Tax Exclusive".
6. Click "Import".
7. You'll be presented with a brief summary of your import, and if looks good, select "Complete Import".

For more information, please refer to Xero's own documentation:

• Import customer invoices
• Import customer credit notes

Important things to note:

• Unfortunately, Xero won't import invoices without an invoice date or a due date. Therefore, any unsent invoices in your MIDAS system, will be excluded from the data exported in MIDAS when exporting for Xero.
• You'll need to ensure that the curency code setting in your MIDAS system matches the currency setting in your Xero account. You can check your currency code setting in MIDAS via MIDAS Admin Options → Manage MIDAS → Invoicing → Currency Code. If multi-currency isn't enabled in your Xero account, you will only be able to import invoices which match the same currency setting as both your MIDAS and Xero systems.