Import trial balance data directly from IRIS KashFlow

Product subscription required: IRIS Elements Accounts Production Professional or IRIS Elements Accounts Production Enterprise.

If subscribed to IRIS Elements Accounts Production Essentials, trial balance data can only be imported from manually created CSV files or must be manually entered.

Trial balance data from IRIS KashFlow can be imported directly into IRIS Elements Accounts Production using IRIS KashFlow Connect, without first downloading the data to a CSV file.

You must be connected to IRIS KashFlow Connect before importing. You can connect from Integrations, or by linking the client from the Client connection manager widget on the client's dashboard.

1. From the Clients menu, select Clients list.
2. Change the client list view to either Active clients or a custom view that includes all relevant clients and select the client you need.

If any of the entries are greyed out and you cannot select them, this is a restricted item — the parent client record has been set to Private and you do not have access. If you believe this is a mistake, contact your IRIS Elements administrator. Users who have Administrator level permissions are able to view all public and private client records, even those where they are not named as assigned users.

3. From the Accounts production widget on the Dashboard, select the required accounting period.

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

4. In the Source Data tab, select Import.
5. If trial balance data has already been imported for this period, select Yes upload new CSV to overwrite the existing data.
6. In the Import trial balance dialog, for Import type, select Bookkeeping Application (API).
7. From the Bookkeeping source drop-down, select KashFlow Connect.
8. If IRIS KashFlow Connect is not already connected, enter your details and select Connect.
9. Select the client you want to connect and select Start mapping.
10. In the Mapping summary dialog, review the total and unmapped posting counts, then select Continue.
11. On the Import mapping page, check that all KashFlow account codes are mapped to the correct IRIS accounts.
    • To resolve unmapped postings, select the Unmapped tab and map each account code to the correct IRIS account.
    • To save progress and return later, select Save & exit. To resume, go to the Source Data tab and select Import.
12. To complete the import, select Complete import.