Import trial balances direct from Xero

Product subscription required: IRIS Elements Accounts Production Professional

If you subscribe to IRIS Elements Accounts Production Essentials, you can only import from manually created CSV files or must manually enter your trial balance data.

You can import your trial balance data direct from Xero™ without downloading the data to a CSV file first.

You must have multi-factor authentication switched on for the IRIS Elements account used to perform the import from Xero.

1. From the Clients menu, select Clients list.
2. From the Accounts production widget on the Dashboard, select the required accounting period. Ideally, select the latest / newest period.

   If a relevant account period does not exist, you must create and set up one first.

3. In the Source Data tab, select Import.
4. If data has been previously imported, choose whether to upload new data (Yes upload new data). Doing this overwrites any existing trial balance data.
5. Select the Bookkeeping Application (API) import type.
6. From the Bookkeeping source drop-down, select Xero.
7. If a Xero integration has not been setup already, select Connect.
   1. When prompted, enter the integration account's email address, password, and 6-digit authentication code.
   2. Confirm the access permissions.
   3. When the connection has been setup correctly, you are returned to the Import trial balance dialog.
8. Select Start mapping.
9. Once the data has been analysed, select Continue.
10. After import, check the data has been imported as expected. Errors are highlighted that must be resolved:
    • Missing accounts or descriptions
    • Unknown Directors
    • Unknown Partners

    You can choose to Save & exit without resolving the highlighted problems and complete the process later — when you return to the Source Data tab, select Resume import to complete the import.

11. When all highlighted problems have been resolved, select Complete import.