Import the trial balance from an engagement file

You can import the trial balance from another engagement file if the Engagement File import option is enabled in your product.

Engagement File import option on the Data page.

Note that:

  • To import from an engagement file that belongs to a different Cloud app, you must have access to that app and the entity that the file belongs to. To learn more, see Set staff access levels

  • Period data between the source and destination engagements are automatically mapped. For example, the Current Year data column from the source engagement is automatically imported to the Current Year column in the destination engagement

  • Once the data is imported, the year-end date for the destination engagement is automatically set to match the year-end date of the source engagement

  • Annotations and issues are not imported

  • Importing from a consolidation engagement imports the parent entity data only into the destination engagement

  • If the source and destination groupings don't match or partially match, unassigned accounts will populate in the Assign Accounts tab and you must manually assign them. To learn more, see Assign accounts to groups in the Data page

After you complete the import, you can reimport the trial balance data at any point in time by going to the Data page, and selecting Import, then one of the available options:

  • Reimport Trial Balance - Select this method to reimport the data with the original import method that you used. For example, if you previously used Xero to import the trial balance data, the Xero import method displays when you attempt a reimport.

  • Reimport from different source - Select this method to reimport the data with a different import method. For example, if you previously used Xero, but now want to import the trial balance data from a CSV file.

When you reimport the data, accounts from the new data are matched to the old data using the account name and number. Balances for matching accounts are overwritten with the new data. Accounts that only exist in the old data and not the new data are deleted.

Note: If you reimport the data from a different source and there are accounts in the existing data that are not in the new data, the balance of these existing accounts is set to 0.

Note: In engagement files created from carry forward, account balances from prior years are not overwritten or deleted by the new data from reimport.

To import the trial balance from another engagement file:

  1. In the Data page, go to the Import tab and select Engagement File.

    A confirmation dialog displays prompting you to confirm the import action because you can't change the reporting period once the import is complete.

    Once you confirm the import, the Engagement Search dialog opens showing a list of the available engagements in the entity.

    Engagement Search dialog.

  2. From the list, select the engagement that you want to import the trial balance from.

    Note that you can only select one engagement.

    Tip: To select an engagement that belongs to a different entity, select the Search all entities check box.

  3. Select CONFIRM.

    The Accounts and group tabs populate with the trial balance data.