Import account balances and the chart of accounts from QuickBooks

Before you begin

Specify import options

Select
Setup
,
Clients
, then select the
Integration
tab.
Select the client from the client list, then select
Edit
.
Select QuickBooks from the Import source dropdown list, then select the ellipsis.
Select your options in the
Import Client Data Options
window.
Select
OK
to return to the Clients screen.

Import account balances and map the chart of accounts

If you run
Workpapers CS
on a computer running the
Windows 10
(or later) operating system, on which the
User Account Control
feature is enabled, open QuickBooks, but don't open the client database yet.
If you have the QuickBooks application installed and the company data file open during the import, the QuickBooks - Application Certificate window opens automatically in QuickBooks:
Select
Yes, always; allow access to the data even if QuickBooks is not running
.
Select the
Allow this application to access personal data such as Social Security Numbers and customer credit card information
checkbox, then proceed with the import.
In
Workpapers CS
, select
File
,
Import
, then select
Client Data
.
Select the client you need, then select
QuickBooks Account Balances
as the source.
Go to the file location, then select either the QuickBooks company file or the file created by the CS QuickBooks Data Utility.
Enter a range of dates for which to import account balances from your QuickBooks client data.
The application places the balances that are calculated for the specified date range in the current GL period in Accounting CS.
If you run
Workpapers CS
on a computer running the Windows 10 (or later) operating system, and the User Account Control feature is enabled, return to QuickBooks and open the client database that you want to import. Return to
Workpapers CS
, then select
Next
.
Map the chart of accounts to the proper items in
Workpapers CS
. For each account that is listed in the
QuickBooks Number & Name
column, select a corresponding account in the
Number & Description
column.
After you finish mapping the QuickBooks data, the application displays the Data Analysis screen, which gives you the chance to print and/or preview diagnostic reports about the data that will be imported. Review the diagnostic reports and correct any information as needed. The application doesn't actually transfer the data to
Workpapers CS
until you select
Finish
.
Check any errors encountered during the import that are listed on the completion screen of the Import Client Data wizard. Print them and if necessary, take the proper actions to correct any exceptions or failures.