Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Integrate with Quickbooks

Export IIF file to QuickBooks results in duplicate accounts

Your client has a QuickBooks chart of accounts set up with subaccounts. When you import the chart of accounts IIF file into QuickBooks, you there are subaccounts duplicated. This issue can occur if the account description used in the Accounting CS Chart of Accounts doesn't match the naming guidelines required for QuickBooks integration. In the Accounting CS Chart of Accounts, any account that corresponds to a QuickBooks subaccount will need to match specific naming guidelines for the account description.
Notice how the QuickBooks parent account converts into Accounting CS with the exact same description used within QuickBooks. In contrast, both the QuickBooks parent account's description AND subaccount's description are used on the corresponding Accounting CS account. If the naming guidelines are not followed exactly, the import into QuickBooks may result in duplicate accounts or subaccounts being added as new (parent) accounts.
To resolve this issue, use the following steps.
  1. Within the QuickBooks client data, verify the description of the parent account and subaccount. Be sure to verify the exact account descriptions, as we’ll need to enter these into the Accounting CS Chart of Accounts. Once you have found the parent account and subaccount within QuickBooks, proceed to step 2.
  2. In the Accounting CS client data, go to
    Setup
     then
    Chart of Accounts
    .
  3. Select the Accounting CS Account that corresponds to the QuickBooks subaccount by left-clicking on it in the account list.
  4. Left-click the
    Edit
     button. This will let you to modify the Accounting CS account description.
  5. Modify the Accounting CS account description so that it matches the format previously displayed: the Accounting CS account description needs to match this format exactly:
    <QuickBooks Parent Account Description>:<QuickBooks Subaccount Description>
    . Don't enter any spaces before or after the colon.
  6. Left-click the
    Enter
     button to save your changes.

This article applies to:

  • Product: Accounting CS

Related content

Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close