Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

If properly licensed, you can use Accountant's Assistant or Trial Balance CS to import client data from Intuit's QuickBooks Pro (including the Premier Accountant and Enterprise editions for versions currently supported by Intuit). Note that if the company file in QuickBooks does not contain an active payroll subscription, balances resulting from payroll checks or payroll liability checks are excluded from the import.

Accountant's Assistant: From the CSA main menu, choose Utilities > Accountant's Assistant > QuickBooks Pro - Account Balances Only. (Accountant's Assistant is included with the Client Bookkeeping Solution Master License.)

OR

Trial Balance CS: From the CSA main menu, choose Utilities > Import > QuickBooks Pro Account Balances.

• You can import directly from the client's .QBW file if you have the QuickBooks application installed and the company data file open during the import. The QuickBooks - Application Certificate dialog opens automatically in QuickBooks. Click the Yes, always; allow access to the data even if QuickBooks is not running option. Mark the Allow this application to access personal data such as Social Security Numbers and customer credit card information checkbox and then proceed with the import.
• As an alternative, either you or your client can create an export file using the CS QuickBooks Data Utility, and then you can import that file into CSA. (You would use this option, for example, if you are running CSA in a Virtual Office CS or other Terminal Server environment where the QuickBooks application is not accessible.)

Special information

• You can choose to import account balances only from QuickBooks Pro, without transaction details. Only net changes of accounts are imported from QuickBooks Pro when you choose this import. (When you close the current period to the next year (from File > Select Period to Process), be sure to click the Yes button when you are prompted to carry forward balance sheet account balances.)
• You can enter a range of dates to import account balances from your QuickBooks Pro client data. The balances calculated for the specified date range will be placed in the current GL period in CSA.
• For a GL client: To enable the ability to record new entries in the Tasks > Transaction Entry window without overwriting existing balances in the Chart of Accounts, mark the Create journal entry with account balances checkbox on the QuickBooks Pro Date Range dialog. This option creates a journal entry transaction and posts transactions during the import process.
• For a Trial Balance CS client: Also see Importing QuickBooks Pro Account Balances for the first time

Related topics

QuickBooks Pro [Utilities menu, Accountant's Assistant]

QuickBooks Retrieve Options dialog

QuickBooks Pro Date Range dialog

QuickBooks Pro: Assign Classes dialog (for locations/departments)

QuickBooks Pro: Chart of Accounts Assignment dialog

QuickBooks Pro: Chart of Accounts Mask Options dialog

Using the CS QuickBooks Data Utility

Transferring transactions from CSA to QuickBooks

Was this article helpful?

Yes No

Submit