Import a chart of accounts (COA)

Written By Ascend knowledge base (Administrator)

Updated at November 22nd, 2023

Use our QuickBooks integration to use a new or existing Quickbooks account directly with Ascend. Before you get started, you'll need to set up a Quickbooks account.

After your account is set up, and the chart of accounts (COA) is updated, you can add that information to Ascend.

Ascend's retail accountant team also offers Bookkeeping services for Ascend retailers. Learn more here.

Export COA from Quickbooks

  1. From the QuickBooks application, select the File menu > Utilities > Export > Lists to IIF Files. The Export dialog box is displayed.
  2. Select the Chart of Accounts option.
  3. Click OK. The Export dialog box is displayed.
  4. Navigate to your Desktop or other preferred location for storing files.
  5. Assign the file an easily recognizable name, e.g. chart.iif.
  6. Click Save. A dialog box confirming the export of data is displayed.
  7. Click OK.

Import COA into Ascend

Make sure the file you exported from Quickbooks is available on a computer with Ascend.

  1. In Ascend, navigate to File > Import > QuickBooks Chart of Accounts.
  2. Find and highlight the file you exported from Quickbooks.
  3. Select Open.
  4. The file is imported into Ascend.

If this chart is replacing a previously imported chart, your existing mapping will stay intact as long as your new chart contains the same account numbers used with the existing mapping.

Import Class List into Ascend

Make sure the file you exported from Quickbooks is available on a computer with Ascend.

  1. In Ascend, navigate to File > Import > Quickbooks Class List.
  2. Find and highlight the file you exported from Quickbooks.
  3. Select Open.
  4. The file is imported into Ascend.

If this Class List is replacing a previously imported list, your existing class assignment will be lost. You must re-assign the class in Options > Quickbooks.

Screenshot of Options window with Quickbooks selected. The dropdown next to Class is highlighted and it says "(None)"

KB22-094