Import a client's trial balance in the Data page

To populate the trial balance, you’ll have to import the financial data to your engagement file. In some cases, you can import this data directly from another accounting software package using the native import utility (for online accounting software) or a desktop utility import we provide.

Import from online accounting software

You can import your trial balance directly from online accounting software.

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.

Import from Exact Online

To import client data from Exact Online:

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

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

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

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

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

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

  6. Select Import.

When you import your trial balance from online accounting software, the accounts and groupings are automatically mapped.

Import from CaseWare Working Papers

Note: Importing financial data from Working Papers is only supported by CaseWare ReviewCompTax.

You can import your client’s financial data from Working Papers and have it transferred to your CaseWare RCT engagement. The steps to carry out this task differ based on whether or not you have disabled your Working Papers license. To learn more, see Import engagement data from Working Papers to CaseWare RCT.

Import from third-party desktop accounting software

To import client data from third-party desktop accounting software, use one of our free tools. The tool you need depends on the accounting software you're using.

CaseWare Cloud Import Utility

Along with CaseWare Working Papers, the CaseWare Cloud Import Utility supports most desktop accounting software. For a complete list, see Supported third-party desktop accounting software.

To format client data using the Cloud Import Utility:

  1. Download the utility.

  2. Open the Utility. Select Other Data Source, then select Next.

    Note: Do not select the Existing File option as it's irrelevant to Cloud users. For more information, see the platform's list of known issues.

  3. In the Import From and Version fields, specify the accounting software you're exporting from.

  4. Browse for the Import Path of the client file you want to import. If multiple client files are located in this folder, you will need to specify which file you want to import in the Select Client ID File field.

  5. Select Next. You will see a prompt with the output folder you'll need to open to access your new file. Select Finish to perform the conversion.

The generated output file can be uploaded into a variety of CaseWare Cloud products.

CaseWare Transformer

AuditXML 3.x (Beta) accounting software requires CaseWare Transformer.

Download CaseWare Transformer: 

Import from QuickBooks Desktop

This section describes the process to import from Quickbooks desktop for the Canadian market.

To import from QuickBooks Desktop:

  1. Click the below link to download the CaseWare Cloud Import Utility.

  2. Open the Utility. Select Other Data Source, then select Next.

    Note: Do not select the Existing File option as it's irrelevant to Cloud users. For more information, see the platform's list of known issues.

  3. In the Import From drop-down, choose QuickBooks.

  4. In the Version drop-down, select QuickBooks Online.

  5. At Import Path, browse and select the exported client file.

  6. Select the desired settings for the import (Fiscal Year End, Period Date Sequence).

  7. Select Next, then Finish.

  8. Save the generated zip file using the displayed prompt.

  9. In your engagement file, go to the Import tab at the Data page and select Desktop Accounting Software.

    If you want to import transactional data as well, select the Import available transactional data check box.

  10. Select or drag-drop the zip file you've saved in Step 8.

    The data is imported to the engagement file and becomes available in the Accounts tab.

Import the client's trial balance data from Excel/CSV

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) file and then perform the import using this file. The format of the file can be either Excel or .csv.

To import client data from Excel/CSV file:

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

  2. Select Excel or CSV from the available options.

  3. In the import dialog, use one of the following methods to import the trial balance:

    • drag and drop an Excel or a CSV file into the upload area in the gray dashed box.
    • browse for a file on your local device.
    • select the file from the engagement if you have already uploaded it.

    The upload dialog for Excel and CSV files.

  4. Map the columns in the import file by choosing the field that best matches the data from the Import as drop-down menu. If you don’t want to import a column, select Do not import to exclude it.

    Mapping columns using import data.

  5. Select Import.

  6. Your imported client data populates in the Accounts and group views in the Data page.

You can also reimport the trial balance data at any point in time by going to the Data page, and selecting Import, then Reimport Trial Balance. When you select Reimport Trial Balance, you are presented 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.