SE
SmartEngagement
Working Papers
CaseWare Working Papers
Analytics
CaseWare Cloud Analytics
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  Cloud Provided by Client Requests
SE
SmartEngagement
Working Papers
CaseWare Working Papers
Analytics
CaseWare Cloud Analytics
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  Cloud Provided by Client Requests

Import a client's financial data to an engagement file

This feature is only available with products on the CaseWare Cloud Engagements platform. Available products include OnPoint PCR, and CaseWare ReviewCompTax.

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. You can currently import from the following software products:

  • Xero

  • QuickBooks Online

  • Exact Online

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. From the top menu, select Trial Balance.

  3. On the trial balance page, choose a trial balance grouping structure from the drop-down menu at the top of the page.

    The following options are available:

    • Financial
    • Tax Code
    • Chart of Accounts
  4. Under Import from the following platforms, select Xero.

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

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

  6. Enter your Xero account information and select Login.

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

  8. 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.

  9. Select Import.

To import client data from QuickBooks:

  1. From the top menu, select Trial Balance.

  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.

To import client data from Exact Online:

  1. From the top menu, select Trial Balance.

  2. On the trial balance page, choose a trial balance grouping structure from the drop-down menu at the top of the page.

    The following options are available:

    • Financial
    • Tax Code
    • Chart of Accounts
  3. Under Import from the following platforms, select Exact.

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

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

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

  6. 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.

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

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.

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

  1. From the top menu, select Trial Balance.

  2. On the trial balance page, choose a trial balance grouping structure from the drop-down menu at the top of the page.

    The following options are available:

    • Financial
    • Tax Code
    • Chart of Accounts
  3. Under Import from, select Excel or CSV. 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.

    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.

Your imported client data populates the trial balance.

Troubleshooting

Problem

You follow all the steps to import data from online accounting software, but the process finishes and no data is imported.

Solution

If the year end date in the engagement and the source data file do not match, the trial balance is not imported. Open the engagement properties and ensure that the year end date is correct.

The engagement properties pop-up.

Was this helpful?

Yes
No
This content is exclusively related to Se,rct,pcr and has been filtered out. Select the PRODUCTS dropdown in the top navigation to modify your filter settings.

Stay Connected

Subscribe to receive updates on the latest articles and news for CaseWare products.

Your download will start immediately after you subscribe.

Please enter a valid email.
No thanks, I just want the file.