Import data from online accounting software

You can import your client's data directly from online accounting software into a CaseWare Cloud Suite engagement.

Note: Accounts with zero balances are not automatically imported. If you want to include zero-balance accounts, you must manually add them and assign them to the designated groups.

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: In engagement files created from carry forward, account balances from prior years are not overwritten or deleted by the new data from reimport.

Import from Xero

To import client data from Xero:

  1. Ensure that you have the Editor role or equivalent privileges. To connect to the Xero file, ensure that you have a valid Xero account and that you've been assigned the Standard user or Auditor role on the file. For more on users and roles in Xero Online, see their help materials.

  2. Go to the Data page and select Import from the left navigation panel.

  3. Under Import from the following platforms, select Xero.

    A new window is displayed prompting you to log in to your Xero account.

  4. In the Xero Accounting Import dialog, select Login.

  5. Enter your Xero account information and select Login.

  6. Select your client organization in Xero and select Allow access for 30 mins.

  7. In your engagement, select the check box beside the correct client file. If your client file includes transactional data, you can import that data by selecting the option.

    The Xero Accounting Import dialog with a client file chosen and the Import Transactional Data option selected.

  8. Select Import.

Import from QuickBooks Online

To import client data from QuickBooks:

  1. Go to the Data page and select Import from the left navigation panel.

  2. Under Import from the following platforms, select QuickBooks.

  3. In the QuickBooks Online Import dialog, select Login.

  4. Enter your QuickBooks Online account information and select Login.

  5. Complete the credentials that display and select Connect.

  6. In the QuickBooks Online Import dialog, select the client file.

  7. Select the year-end you wish to import - select the prior period if required. Be sure that this is the same year-end as the RCT engagement file.

  8. Select Import.