Import chart of accounts

If you have a new company, with no transactions or records, you can import your chart of accounts from a CSV file. This can save you time rather than amending each ledger account individually.

For more videos like this, see here.

How it works

If you import your chart of accounts, it removes all ledger accounts and replaces them with the ledger accounts in your import file.

You can update the nominal code and ledger name of the Control Accounts if you include them in your import file. If you don’t include these, the system creates them automatically as these are mandatory accounts.


To import your chart of accounts, you must structure the information in a particular way and must be in a Comma Separated Value (CSV) file format.

To view this format, you can download the following example CSV templates:

Sole Trader

The maximum file size you can import is 0.5MB. To ensure your CSV file imports successfully follow the import rules for the correct format.

Import rules

To ensure your information imports successfully, row 1 must contain a valid column heading in your CSV file. Use the same heading as seen in the Field name column below:

Column Field name Rules
A NOMINAL CODE Can contain up to 8 numeric characters, each code must be unique.
B LEDGER NAME Max length 200 characters.
C CONTROL ACCOUNT If populated must contain a valid control account name, these ledger accounts can be updated with different numbers/names but should not be removed.
If you select the control accounts of either BANK_CURRENT or BANK_CASH with the category as BANK you will create a bank account found in the Banking section.
D CATEGORY Must be a valid category:

  • BANK
E TAX RATE Must be a valid VAT Rate:
UK – Standard, Lower, Zero, Exempt, No VAT

Import chart of accounts

Once the CSV file is in the correct format, you can import your chart of accounts:

  1. Go to Settings, then Chart of Accounts.
  2. Click New Ledger Account arrow, then select Import Accounts.
  3. Within the import, window click + Upload Data File.
  4. Browse to and select the CSV file, then click Open.
  5. Click Ok.
If any issues appear when trying to import your data file, an error message appears to give details on why the import failed.
Related Article