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.

   

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.

To learn more, see Import engagement data from CaseWare Working Papers to CaseWare ReviewCompTax.

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 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 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 upload dialog, drag and drop an Excel file or a CSV file into the gray upload area, browse for the file on your local device storage or select the file from the engagement if you have already uploaded it.

   

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.

   

5. Select Import.

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 selecting Reimport Trial Balance. Note that when select Reimport Trial Balance, you are presented with the same import method you have used when you imported. For example, if you have used Xero to previously import the trial balance data, then Xero import method displays when you attempt a reimport of the data.