Import a chart of accounts from a spreadsheet

Before you begin

You can use the import option to add new accounts to a client's chart or update existing ones.
The spreadsheet file you import needs to be in .XLS or .XLSX format.
For non-segmented clients that have accounts with subcodes, you'll need to format the spreadsheet column as text.
Make sure the spreadsheet is closed, remains closed during the entire import process, and is not password protected.
The maximum amount limit is 999,999,999.99 when importing balances into the chart of accounts.

Sample spreadsheets

Chart of Accounts (with current-year and prior-year balances)
Chart of Accounts (with type and tax code)

Map spreadsheet columns

Mark the checkbox in the Omit Row column for any column headings or rows of data that shouldn't be imported. The application won't validate or import data in that row.
Select a column heading in the grid and then choose the applicable mapping item from the
Column [X]
field.
Repeat step 2 for all applicable columns.
Select
Next
.

Map account classification codes

Choose import options

Choose the Chart of Accounts import option:
Append to existing chart:
The application adds new accounts and their balances to the existing chart of accounts.
If the spreadsheet includes data for any existing accounts, the application updates data for those accounts with the new information.
Zero existing balances and import new balances:
The application adds new accounts and their balances to the chart of accounts.
If the spreadsheet includes data for an existing account, the application zeroes the balances for that account for the selected dates, and imports only the balances in the spreadsheet file.
If the spreadsheet does not include data for an existing account, the application zeroes the balances for that account.
Choose the balance report option:
Current period balances:
The application imports the balances from the spreadsheet directly into the period selected for the balance column.
Year-do-date balances:
The application calculates current-period activity based on existing prior-period balances and creates a journal entry with the net change for the period.
Select
Import
to begin the data import.

Review import diagnostics

Select
Back
if you need to make changes to any of the previous mapping and option screens.
Mark the checkbox next to an item and then select
Preview Selected
or
Print Selected
to get the diagnostic report for it.
Select
Finish
when you're satisfied with the data you'll import.

Review the diagnostic messages.
You can select
Print
for a report of the import results.
Select
Close
to close the spreadsheet import wizard.