You are here: Help Topics > Engagement Management > File Preparation > QuickBooks Online

Importing from QuickBooks Online

To import accounting data from QuickBooks Online into Working Papers, you must use the QuickBooks Export Utility to export the QuickBooks Online data in .cwq file format, then import this file into Working Papers.

You can download the QuickBooks Export Utility installation package from MyCaseWare, under Support Downloads.

Microsoft .NET Framework 4.0 and the QuickBooks Export Utility must be installed on your system.

For a complete list of the supported versions of QuickBooks, see Supported Accounting Software.

  1. Log into QuickBooks Online and open the company file you want to import into Working Papers. Make sure that your QuickBooks account has full access to the file.
  2. Launch the QuickBooks Export Utility.

  3. In the QuickBooks Version field, select QuickBooks Online.
  4. ​In the Export Path field, enter the file path or click Browse to select a location for the export files.
  5. Specify the last transaction date and accrual method.
  6. Click Export. The utility will connect to QuickBooks Online and create the .cwq format export file.
  7. Note: If the export attempt results in a "This page cannot be displayed" error, open the Windows Control Panel, click Programs and Features | Windows Features, and drill down to Internet Information services | World Wide Web Services | Common HTTP Features. Make sure that WebDAV Publishing is deselected and all other HTTP features are selected, then click OK and reattempt the export.

  8. Import the .cwq file into Working Papers:
    1. ​In Working Papers, click Engagement | Import | Accounting Software.
    2. In the Import From field, select QuickBooks.
    3. In the Version field, select QuickBooks Online.
    4. Complete the other fields as required, then click OK.

The QuickBooks file's data is imported into your Working Papers engagement.