Review or import Chart of Accounts
This is step 1 of 7 to set up your clients with Sage Accounting.
On this page learn how to:
- Review standard Chart of Accounts
- Import Chart of Accounts
Review standard Chart of Accounts
When you first set up your client's company in Sage Accounting, we'll create a Chart of Accounts based on your client's type of business.
All the ledger accounts are shown in the Chart of Accounts list.
Access these from Settings then Chart of Accounts.
Import Chart of Accounts
Before you begin you must:
-
have a new Accounting business with no transactions or records
-
have your chart of accounts file saved in comma separated value (CSV) format
-
use the same column headings and formatting as in the chart of accounts CSV template file
Step 1: Download the CSV template file
Each CSV file contains a standard list of ledger accounts and the required columns for Nominal Code, Ledger name, Control account, Category and Tax rate.
Download the CSV file that is suitable for your client's business type
Step 2: Prepare your import file
If you already have a list of ledger accounts exported from another system:
- Change the column headings to match the format used in the template file.
- Remove any columns in your CSV file that are not used in the template file.
- Make sure the data format used in each column matches the format used in the template file.
- Category - Each ledger account must belong to a one of the categories already set up in Partner Edition. You cannot use your own categories.
-
Tax rate - Each ledger account must have a Tax Rate associated with it.
If you don't have your ledger accounts in a CSV file already, simply amend the template file with the required ledger account names and nominal codes. Make sure you use the correct Category and Tax Rate for each one.
The maximum file size you can import is 0.5MB.
Control accounts
Control ledger accounts are required and used by default for certain transactions. They must be present in every ledger account list. You can't remove them but you can change the Nominal Code or Display Name.
Column headings and required formats
Use the table from column headings guide to ensure the file format is correct. Remember the file's column headings must match those in the table.
| Column | Column Heading | Notes |
|---|---|---|
| A | NOMINAL CODE | Can contain up to 8 numbers and 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 | Use one of the following categories
|
| E | TAX RATE |
Use one of the following tax rates:
|
Step 3: Import the chart of accounts file
- From Settings, select Chart of Accounts.
- From the New Ledger Account drop-down arrow, select Import Accounts.
- Select the Upload Data File link.
- Browse to your CSV file and then select Open.
- Select OK.
Common errors
If your file cannot be imported, we'll tell you what the problems are and which rows are affected.