Import account details
You can import account details from a Microsoft® Excel® or CSV file (typically, the same file you use to import your trial balance). The import file must meet the following criteria:
The account codes must be in Column A and the account descriptions in Column B.
Row 1 is assumed to contain the column header and is not imported.
Data must be on Sheet 1 of a Microsoft Excel workbook.
Account codes must be unique.
Additional notes regarding the import file include:
Importing a trial balance file that excludes accounts with zero balances will not work. You must obtain all accounts in the chart of accounts.
Additional data (for example, amounts for different entities) in the file are ignored.
If an error occurs during import, edit the import file, save it then repeat the import process.
To import account details:
On the main menu bar, select
Configuration
, then
Chart of Accounts
.
In the grid, select the
Name
link for the chart of accounts you want to import.
Select the import icon in the upper right corner.
Navigate to where the file you want to import is located. Select the file then select
Open
to import the file.
Select
Save
on the toolbar.