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.