Exporting to Xero

The Export to Xero functionality is used to export receipts, payments and journal entries to Xero, saving you from having to enter transactions in two different systems. To export transactions to Xero, follow these instructions:

1. Open the Export to Xero Form

From the main menu, choose Accounts>Export to Xero

2. Review the Transactions to be Exported

The Export to Xero form will be displayed. This form shows a list of all office account transactions that have not yet been exported to Xero. Review the transactions to be exported. You can view the details of a transaction by double clicking on that transaction.

2.1. If there are Transactions you Don't Want to Export .....

In some cases you might not want to export all transactions. The most likely reason for this would be that you have already manually entered some past transactions into Xero so exporting those transactions would cause duplicate entries in Xero. If you want to stop particular transactions from being exported, select those transactions then click Change Status.

The Change Status form will be displayed. Select Excluded as the New Status and click Change Status. You will be asked if you're sure you want to change the status. Click Yes.

The selected transactions will be removed from the list of transactions to export. Note you can view any transactions that are on hold by selecting Hold as the Error Status in the Search Bar and clicking Search. If you want to export any of the transactions that are on hold, select those transactions, click Change Status and change the status back to Not Exported.

3. Export the Transactions to Xero

After you have reviewed the transactions and placed any transactions that shouldn't be exported on hold, click Send All Unexported Journal to Xero. Note that this will send all unexported journals to Xero, not just the selected rows.

A web browser will be opened and you will be taken to Xero's authorisation page. If you are not already logged in to Xero, you will be asked to log in. Enter your Xero login details and click Login.

You will be taken to the Xero authorisation page. If you have more than one organisation set up in Xero, select the organisation you want to use. Then click Authorise.

Xero will display an authorisation code. Copy this code and paste it into the Migration Manager window that asks for the Xero pin code. Click OK in Migration Manager.

The journals will be exported to Xero. This may take some time, depending on the number of journals you are exporting. When the process is finished, you will be given a message showing the results of the export.

4. Troubleshooting

If a journal can't be exported to Xero, it will be shown in the list of transactions with a status of Error.

To view the details of the error, double click on the row. The journal details form will be displayed. The details of the error will be shown in the Message box.

In this example, the error reported by Xero is "The specified bank account details does not match a known bank account." This indicates that the bank account general ledger code in Migration Manager doesn't match any of the bank account codes in Xero. Take any corrective actions needed - in this example you would either create the bank account in Xero (if it doesn't exist), or ensure that the bank account general ledger code in Migration Manager is correct (see Preparing to Export to Xero).

5. Viewing the Exported Transactions in Migration Manager

To see a list of transactions that have been exported in Migration Manager, change the Export Status in the search bar of the Export Xero form to Success, optionally selected a date range, and click Search. The exported transactions will be displayed. You can view the details of a transaction by double clicking on it.

6. Viewing the Exported Transactions in Xero

The exported transactions can be viewed in Xero by logging in to Xero and running a Detailed Account Transaction Report