QuickBooks (Export from QuickBooks)

Accounting Index

Working Papers imports the full trial balance from a QuickBooks text file. General Ledger Detail is not imported.

To create a QuickBooks v 6 (Canada) export file:

  1. While in the QuickBooks client file, access the File menu, click Export, and then Working Papers.

  2. In the export dialog, select the year-end date that you want to use in your Working Papers file. The starting and ending dates can be anywhere up to one year apart.

  3. In the QuickBooks File box, enter the name of the QuickBooks company file or click Browse to locate the file manually.

  4. In the Export File box, enter the export file path or click the Browse button to save it in a specific directory. QuickBooks will automatically name the file CaseWare.txt. You can change the base file name, but you must keep ".txt" as its extension.

  5. Click the Export button to process the export.

QuickBooks files that are needed:

File name Information imported

????????.TXT

Trial Balance

To create a QuickBooks v 4 or 5 export file:

  1. While in the QuickBooks client file, access the File menu, click Export, then IIF.

  2. In the Export dialog, select Chart of Accountants, and then click OK.

QuickBooks files that are needed:

File name Information imported

????????.IIF

Trial Balance

To import the export file into Working Papers:

  1. On the File menu, select Import, and then Accounting Software.

  2. In the Import From box, select QuickBooks (Export from QB).

  3. In the Version box select the version of QuickBooks you used to create the export file.

  4. In the Import Path box, type or select the exact path where the QuickBooks text file resides. Click the Browse button to locate the directory where you saved your export file and click OK. Version 4 or 5 files will have the extension .iif. Version 6 (Canada) export files will have the extension .txt.

  5. In the QuickBooks Exported Text File box, ensure that the name of export file you want to import is displayed. (e.g. CaseWare.txt)

  6. Click OK to process the import.

  7. During the import you will be asked whether to update the current engagement properties or not. Be aware that the information in QuickBooks may not line up exactly with the engagement properties in Working Papers. Unless you know that the fields line up, answer no.

    If you are doing a QuickBooks import as part of setting up a new file, the engagement properties information is imported automatically.

Notes

Related Topic