Import from QuickBooks desktop (Export from QB)

You can import data from QuickBooks desktop (Export from EB) by using the Export Module, then importing the file to your engagement.

Note: Accounts with zero balances are not automatically imported into Caseware Cloud apps. If you want to include zero-balance accounts, you must manually add and assign them to the appropriate financial groups.
Zero-balance accounts are imported into IDEA files.

Before you start, make sure that you create an export file from QuickBooks using the Export Module.

To import the exported data to your engagement:

  1. Download the Caseware Cloud Import Utility.

    2. Caseware Cloud Import Utility(.exe)

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

  3. In the Import From and Version drop-downs, select QuickBooks (Export from QB).

    Note: Refer to Supported third party accounting packages for the list of supported versions. If you find outdated versions in the list, report the issue to Caseware for investigation.

  4. Browse to the Import Path of the client file you want to import.

  5. At QuickBooks Exported Text Files, browse and select the Chart of Accounts file.

  6. Select Next, then Finish.

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

  8. In your engagement file, go to the Data page. The Data page opens to the Datasets tab.

  • If you’ve previously imported data, select Add data.

  • If your engagement is consolidated and has internal subsidiary entities, select which entity you want to import data for from the list.

  1. Under IMPORT FROM DATA CONNECTOR, select QuickBooks Desktop from the list of data sources, then select Next.

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

  2. Select or drag-drop the zip file you've saved in Step 7.

To view the imported data, click View data next to the dataset you imported.

A new page appears displaying the data.

By default, all the columns in your dataset display. Click Columns to deselect those you want to hide.

Click Filters to filter the data displayed in the dataset.

For more information, refer to View the client's general and subledger data.