Chart of Accounts and Chart Master COA
The Chart of Accounts import replaces or extends your account structure from a spreadsheet. Accounts are organised into classes, groups and account names, and everything in the system posts to one of them — which makes this the first import of any migration.
Where to find it
Go to Setup > Import Export > Chart of Accounts. A default chart ships with the system; edit it, or replace it entirely here.
Format Data
| Level | What it is |
|---|---|
| Class | The top level — assets, liabilities, income, expenses. |
| Group | The grouping within a class, such as current assets or fixed assets. |
| Account | The GL code and name transactions actually post to. |
Options
| Option | Effect |
|---|---|
| COA with auto ID | The system allocates account codes for you. |
| COA with Non-auto ID | Keeps the account numbers in your file. Choose this when migrating, so your accountant's existing numbering survives. |
Replacing the chart of accounts after transactions exist is not a routine operation — the postings behind them reference the old codes. Settle the chart during onboarding, before anything is posted.
After importing
Re-check System and GL Setup. The default accounts each module posts to point at specific codes, and replacing the chart can leave them pointing at accounts that no longer exist.
Errors and exports
If rows fail, the system returns your file with a Memo column added, naming the problem on each bad row — fix those rows and upload again. Every module supports export as well as import, so you can pull current data out in the same format.
The rules common to all imports — never rename headers, dates in Y/m/d, codes must already exist, test a few rows first — are set out in Importing Your Data.
Related pages
- System and GL Setup — must be re-checked afterwards
- Setup Wizard — where the chart is first chosen
- Journal Entry Import — posts to these accounts
- Importing Your Data — shared rules and import order