Import from QuickBooks desktop

You can import data from QuickBooks desktop by exporting it as a file, generating a zip file using the Caseware Cloud Import Utility, then importing it into your engagement.

Note: Accounts with zero balances do not automatically import into Caseware Cloud apps with the exception of IDEA. To include zero-balance accounts, you must manually add and assign them to the designated groups.

Export data from Quickbooks

Before you start, make sure that you complete the necessary prerequisite steps based on your QuickBooks version:

QuickBooks Canada / UK / Australia:

  • Install an applicable version of QuickBooks on your workstation.

  • Install the QuickBooks Export Utility on your workstation. You can download it from MyCaseware on the Support Downloads page.

  • In QuickBooks, you must permit the QuickBooks Export Utility access to the file. On the ribbon, click Edit | Preferences... | Integrated Applications | Company Preferences and deselect Don't allow any applications to access this company file.

QuickBooks USA:

  • Install an applicable version of QuickBooks on your workstation.

After completing the prerequisites, you can export data from QuickBooks Canada / UK / Australia or QuickBooks US.

To export data from QuickBooks Canada / UK / Australia:

  1. Log in to your QuickBooks desktop account, then open the company file that you want to import into Caseware Cloud.

  2. Open the QuickBooks Export Utility.

    1. In the QuickBooks Version drop-down, select your QuickBooks version.

    2. ​In the Export Path field, select Browse….

    3. The Browse For Folder dialog opens.

    4. Navigate to the where you want to create the export file, then select OK.

    • Select Specify last transaction date and enter the applicable date.

    • In the Accounting method drop-down, select the applicable accrual method.

    The QuickBooks Export Utility

  3. Select Export.

The accounting data from the QuickBooks Desktop file is exported to a file in the specified location.

To export data from QuickBooks US:

  1. Log in to your QuickBooks desktop account, then open the company file that you want to import.

  2. On the ribbon, select File | Utilities | Copy Company File for QuickBooks Online....

    If prompted to close any open windows, select OK.

  3. In the Save Exported Company file to... dialog, navigate to the location on your workstation where you want to create the QuickBooks Online file and select Save.

  4. Select OK.

The accounting data from the QuickBooks Desktop file is exported to a file in the specified location.

Generate the import file for Quickbooks

After exporting your data from QuickBooks, you can now generate the import file by using the Caseware Cloud Import Utility.

To generate the import file for Quickbooks:

  1. Download the Caseware Cloud Import Utility.

  2. Caseware Cloud Import Utility(.exe)

  3. Open the Utility, select Other Data Source and select Next.

  4. In the Import From and Version drop-downs, select QuickBooks and the version you're importing from.

    Note: For a list of versions we support, see Supported third party accounting packages.

  5. In Import Path, select Browse and navigate to the folder containing the collection of files you exported from QuickBooks using the Caseware QuickBooks Export Utility.

    • Select Client ID File is automatically filled with the name of the client ID file.

    • File extension is automatically filled with the correct file extension for the file. (The file extension options vary based on the version you previously selected.)

    • In the Accounting year drop-down, select the year for which you want to import data.

    The Cloud Import Utility

  6. Determine the remaining settings for the import.

    The settings vary based on the version you previously selected.

  7. Select Next, then Finish.

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

Import the data into your engagement

After you generate the zip file using the Caseware Cloud Import Utility, you can import the data into your engagement.

To import the data into your engagement:

  1. Open your Caseware Cloud engagement file. When you first open the engagement, the Engagement properties popup appears. Set Year end date to be the same as the data you are about to import.

    The year-end date is the last element of the name of the zip file you generated in Generate the import file for Quickbooks. For example, for the file named SUNBRIDGE FARMS LTD. Mastercard Mark 8386 2022-09-30.zip, the year-end date is September 30, 2022.

  2. On the Data page, go to the Import tab and 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 Desktop Accounting Software from the list of data sources, then select Next.

    If the option is not visible, you can use the search box to find it.

  6. At the Upload stage of the import wizard, select or drag-drop the zip file you generated using the Caseware Cloud Import Utility, then select Next.

  7. At the Configure Data stage of the import wizard:

    • Reporting period is automatically filled with the reporting period of the data.

    • Start Date is automatically filled with the start date of the data.

    • End Date is automatically filled with the end date of the data.

  8. In Select dataset type, choose the type of dataset you are importing. Select Trial balance if you are importing a trial balance and General ledger if you are importing transactions.

  9. If you selected Trial balance, you can select the Import the last 5 years of TB option to import up to five years of trial balance data if it is available in the zip file you generated.

To view the imported financial data, go to your engagement's Data 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.

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

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