Importing From QuickBooks (Older Versions)
The import method for older versions of QuickBooks depends on the specific year or version number.
For a complete list of all supported QuickBooks versions, see Supported Accounting Software.
Importing from QuickBooks versions below 2006 (US) or 2008 (Can/AUS/UK) but above 6.0
Prerequisites
A saved QuickBooks file in .qbw or .qba format
If Protection is activated, the File permission "Import" is required to perform this operation.
-
In QuickBooks, open the client file you want to import.
-
On the Engagement tab, in the Data group, click Import | Accounting Software.
-
From the Import From drop-down, select QuickBooks. In the Version field, select the version that you want to import.
-
In the Import Path, type or select the exact path where the QuickBooks file resides or use Browse to locate the file manually.
-
Under Import Components, choose to import either:
- The Trial Balance (Opening Entries) or,
- The General Ledger Detail.
-
To import client information, click Import Client Information. This information will be displayed in the Engagement Properties dialog.
-
Complete the remaining fields of the dialog. >>Quick Reference
- Click OK to begin importing.
Note: During the import you will be asked whether to update the current engagement properties or not. Be aware that the imported information 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.
Importing from QuickBooks 4.0, 5.0, or 6.0
If you are using QuickBooks version 4.0, 5.0, or 6.0, you will need to create an export file from QuickBooks using the Export Module, then import that file into Working Papers using the QuickBooks (Export From QB) option.
Creating an Export File from QuickBooks
Procedure
Creating an export file in QuickBooks v 6.0 (Canada)
- With the QuickBooks client file open, click File | Export | Working Papers.
- 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.
- In the QuickBooks Filefield, enter the name of the QuickBooks company file, or click Browse to locate the file manually.
- In the Export File field, enter the export file path or click the Browse button to save it in a specific directory. You can change the base file name, but you must keep .txt as its extension.
- Click the Export button to process the export.
Creating an export file in QuickBooks v 4.0 or 5.0
- With the QuickBooks client file open, click File | Export | IIF.
- In the Export dialog, select Chart of Accountants, and then click OK.
Results
The export file can be imported into Working Papers.
Importing the Export File into Working Papers
Prerequisites
- If Protection is activated, the File permission "Import" is required to perform this operation.
Procedure
-
Open the client file in which you want to import.
-
On the Engagement tab, in the Data group, click Import | Accounting Software.
-
In the Import From box, select QuickBooks (Export from QB) and in the Version box select the default version 4.0.
-
In the Import Path field, type the exact path where the file you want to import resides or use Browse to locate the file manually.
The QuickBooks version 4 or 5 text files will have the extension .iif while version 6 (Canada) export files will have the extension .txt.
- In the QuickBooks Exported Text File field, ensure that the name of export file you want to import is displayed.
- Click OK to process the import.
Note: During the import you will be asked whether to update the current engagement properties or not. Be aware that the imported information may not line up exactly with the Engagement Properties in Working Papers. Unless you know that the fields line up, answer no.
Results
Accounting data is imported into the client file.
