Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Integrate with Quickbooks

Quickbooks frequently asked questions

Refer to the following common questions and troubleshooting information about the QuickBooks import process into the application.

General

Generally, the current and 2 prior years of QuickBooks are supported for integration with the applications. The following versions of QuickBooks are currently supported:
  • 2023
  • 2022
  • 2021
  • 2020
This includes the following editions of QuickBooks:
  • Pro
  • Premier (Including Accountant's Edition)
  • Enterprise
No. The subsequent import will bring over only the items that weren't included in the 1st import.
No. The import wizard remembers the mapping settings for the client after the 1st successful import. If you need to change a previously used mappings, you can unmark the
Skip data mapping screens
 checkbox or select
Clear All Mappings
.
  • Journal entries
    : subtype, journal, posting period, reference, date, description, distribution GL accounts, distribution descriptions and distribution amounts.
  • Checks
    : journal, posting period, distribution GL accounts, distribution descriptions and distribution amounts.
  • Deposits
    : bank account, journal, posting period, reference, date, description, distribution accounts, distribution descriptions, and distribution amounts.
  • Payroll checks
    : bank account, journal, and posting period.

Troubleshooting

  • Verify that the Payroll (After-the-fact) service is enabled on the client in Accounting CS.
  • On the
    Integration
     tab of the
    Clients
     screen, verify that the
    Employees
     and
    Payroll checks
     checkboxes are cleared in the Do not import section.
  • In QuickBooks, verify that the payroll checks have a date, a reference number, and are not marked as
    Print later
     or any combination of these.
  • Verify in both applications that the checks are assigned to an active bank account with an active GL account.
  • Verify that the application security certificate in QuickBooks has the
    Allow this application to access personal data such as Social Security Numbers and customer credit card information
     checkbox marked.
If SUTA/SUI is not set up properly in QuickBooks, it won't import into Accounting CS. The state unemployment payroll item description in QuickBooks must contain the words "Unemployment Company" in that order and with no special characters to import successfully into the employer SUI in Accounting CS.

This article applies to:

  • Product: Workpapers CS