Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Integrate with Quickbooks

Export client data to QuickBooks

You can export the following types of data from
Workpapers CS
 into QuickBooks Pro, Premier, or Enterprise versions currently supported by Intuit.
The following information gives details on exporting setup information and transaction data from
Workpapers CS
 via the Export Client Data Wizard.

Information available for export to QuickBooks

You can export the following types of transactions and setup information from
Workpapers CS
 to import into QuickBooks.
  • Transaction types:
    • Bank reconciliation adjustments
    • Checks (payee and accounts payable)
    • Deposits
    • Journal entries (adjusting, reclassifying, prior-period, recurring, and payroll)
    • Payments (regular and accounts payable)
  • Setup information:
    • Bank account information
    • Chart of Accounts
    • Employee information
    • Vendor information

Specify export options

Before you export client data into QuickBooks, you can select the application from which to export client data and specify the types of data to exclude from the export.
  1. Select
    Setup
    ,
    Clients
    , then the
    Integration
     tab.
  2. Select the client from the client list, then
    Edit
    .
  3. Select
    QuickBooks
     from the
    Export to program
     dropdown, then the ellipsis.
  4. In the
    Export Client Data - Options
     window, mark all checkboxes that apply. You can choose to exclude inactive items, select which details to include, and specify the default reference to use for checks and liabilities.
  5. Select
    OK
    , then
    Enter
     to save the client record.

Select the export method in the application

Use the QuickBooks Data utility
  1. Select
    File
    ,
    Export
    ,
    Client Data
     to open the Export Client Data Wizard.
  2. Select the client you want to export data from, then
    QuickBooks
     as the export type.
  3. Select
    Export via the QuickBooks Data Utility (QBgenxfer file)
     for the
    Type of file to create
    . Enter or go to the location where you save the client's QuickBooks data.
  4. Specify the data range for the client data export. To display transactions already exported to QuickBooks, mark the
    Include previously exported transactions
     checkbox.
  5. Select
    Next
    .
Export data directly to Quickbooks
If your firm runs
Workpapers CS
 in the Virtual Office CS, software as a service, or other terminal server environment, the option to export data directly to a QBW file isn't available. To transfer the export file from
Workpapers CS
 to QuickBooks, you or your client must have the CS QuickBooks Data Utility v.15.0 or later installed.
To export data directly to a QBW file:
  • QuickBooks must be installed on the computer where the import is processed.
  • The company database must be open in QuickBooks during the export process. The data files in QuickBooks aren't altered in any way during the export process.
  1. Select
    File
    ,
    Export
    , then
    Client Data
     to open the Export Client Data Wizard.
  2. On the
    Source Data
     screen, select the client you want to import data from, then select
    QuickBooks
     as the export type.
  3. In the
    Type of file to create
     field, select
    Export directly to QuickBooks (.QBW file)
    . In the
    File Location
     field, enter or go to the location where you want to save the client's QuickBooks data, and select the QBW file you want to store the export data in.
  4. Specify the date range for the export. To see the transactions that have already been exported to QuickBooks, mark the
    Include previously exported transactions
     checkbox. Select
    Next
    .

Map QuickBooks data to items

Use the following mapping screens to map export items in
Workpapers CS
 that correspond to items in QuickBooks. To skip the data-mapping screens that don't require input from you, mark the
Skip optional mapping tabs
 checkbox on the Source Data screen.
  • Bank Accounts
    : Map each
    Workpapers CS
     bank account to a corresponding QuickBooks bank type account, then select
    Next
    .
  • Chart of Accounts
    : Map each account in the Chart of Accounts to a corresponding account in the QuickBooks Chart of Accounts, then select
    Next
    .
  • Segment Codes
    : Map each
    Workpapers CS
     segment to a corresponding class in QuickBooks, then select
    Next
    .
  • Employees
    : Map each
    Workpapers CS
     employee to a corresponding employee in QuickBooks, then select
    Next
    .
  • Vendors
    : Map each
    Workpapers CS
     vendor to a corresponding vendor in QuickBooks, then select
    Next
    .

Select transactions and finalize the export

  1. On the
    Transactions
     screen, select the transactions to include in the export file, then
    Next
    .
  2. On the
    Export Complete
     screen, check any errors encountered during the export. You can print them and, if necessary, take the appropriate actions to correct any exceptions or failures.
  3. Select
    Finish
    .
  4. If you exported directly to the QBW file, the export is complete. If you used QuickBooks Data Utility, you can now import the file into QuickBooks.

This article applies to:

  • Product: Workpapers CS
  • Subject: Clients, Export