Sage Business Cloud Help

Accounting

Select different service

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.

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.

Templates

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
Partnership
Limited

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:

  • SALES
  • OTHER_INCOME
  • DIRECT_EXPENSES
  • OVERHEADS
  • DEPRECIATION
  • CURRENT_ASSETS
  • FIXED_ASSETS
  • BANK
  • CURRENT_LIABILITY
  • FUTURE_LIABILITY
  • EQUITY
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 go to 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

Did you find this helpful?

Still need help?

Ask the Sage City community. Sage City is the place to ask questions, share tips and ideas, get practical advice and all the breaking news. Alternatively, find out other ways of getting in touch.

Visit Sage City