Import the trial balance from a CSV or Excel file (new method)

Hinweis: The new workflow for importing a trial balance form CSV or Excel is only available if it has been enabled in your product. See Import the trial balance from a CSV or Excel file (old method) to learn how to assign accounts from the old version of the page.

If the accounting software package you have is not supported by any of our import utilities, you can export your client data to a CSV (comma-separated value) or Excel file and then perform the import using this file. The format of the file can be either .xlsx or .csv.

After you upload the file, you need to assign the data fields in the file to predefined target fields in the Trial balance dataset, to complete the import. For descriptions of the fields in the Trial balance dataset, see Trial balance described.

To import client data from an Excel or CSV file:

  1. From the Data page, select the Import tab.

  2. Select Accounting Software or Structured File.

  3. If this is the first time you’re importing data into the engagement, select New Data Source. If you’ve previously imported data, select Add data.

  4. If your engagement is consolidated and has internal subsidiary entities, select which entity you want to import data for from the list.

  5. Select either the CSV File Import or Excel File Import option, then select Next.

  6. In the Add new dataset dialog, browse or drag the CSV or Excel file to the file upload area.

  7. If you uploaded a CSV file, the Select Delimiter dialog displays. Select the Delimiter used in the file, and then select Continue.

  8. On the Datasets page, select Configure.

  9. From the Dataset type drop-down menu, select Trial balance.

  10. Wählen Sie Weiter.

  11. If planning balances are enabled in your product, select whether you are importing the Final trial balance or a Planning trial balance and then select Next.

  12. On the Assign Fields page, you can:

    • Use the drop-downs to manually assign a field to each column in the imported file

  13. Select Include zero-balance accounts if you want to include accounts with a balance of zero in the import.

  14. Select Done.

If you want to reassign the fields later, you can select Options () | Reassign fields on the Datasets page.

Reimport the trial balance

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.

Hinweis: 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.

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