QuickBooks FAQ

Frequently Asked Questions

• Some accounts that have balances in my QuickBooks file are not imported correctly
• I have a version of QuickBooks that is not supported by Working Papers

General Information

• The General Ledger Detail import from QuickBooks version 8 excludes any GL transactions classified as Estimate type.
• The General Ledger Detail import automatically filters any entries beyond the year-end date of the importing year.
• QuickBooks balances are imported on an accrual rather than cash basis.
• If your computer is part of a network environment, copying the export files onto a location on your local machine prior to importing speeds up the import procedure.
• When importing any file with accounts that are less than 4 digits long, Working Papers automatically pads the account number up to 4 digits by adding leading zeros to the account number.
• If you import a QuickBooks Canada 2008 or later file (the .cwq file generated from the QuickBooks Export Utility), then renumber an account, only the modified account number remains after re-importing the same QuickBooks file. A duplicate account is not made. However, for QuickBooks 2007 (Canada) imports, both the original account number (with no balances) and the modified account number remain after you re-import the same file.
• The import includes tax codes when available.
• If you are importing the general ledger, the Journal Description field has been extended to include the name information (which can represent the name of a vendor, customer, employee, etc, or other details) in addition to the memo information. The name precedes the memo with ':' as a separator.
• When importing, the prior year balance for each account number, the amount is expressed separately for each period, e.g., P1, P2, … P12.
• Working Papers generates the acno for accounts from the account ID if a QuickBooks account being imported has no acno. In order not to clash with existing QuickBooks accounts' acnos that exist in the file, the generated acno must be in the range 000 to 999 or 001000 to 9999999. To ensure this happens, Working Papers automatically pads any acno imported from QuickBooks with leading zeros (if less than 4 digits) to fall within the range from 0000 to 99999.
• If you are doing a QuickBooks import as part of setting up a new file, the engagement properties information is imported automatically.

Frequently Asked Questions

• Some accounts that have balances in my QuickBooks file are not imported correctly

  Specifying 'Name and description' for your reporting method in QuickBooks with a long description, can cause some characters may be truncated. Set your reporting to 'Name only' in your preferences as a workaround.

  The QuickBooks setting for Report might affect the export and import. If you notice the values of some accounts are not imported correctly, please go to the QuickBooks menu Edit | Preference | Report & Graph | Company Preference Tab. Select Name only for "REPORTS - SHOW ACCOUNTS BY" and export again.

• I have a version of QuickBooks that is not supported by Working Papers

  Follow the export procedures and import the file as an ASCII text file. Select Variable Length as the Record Type and specify Tab as the type of delimiter separating the fields in the ASCII text file. For more information, see here.