| | Import your Chart of accounts |
| Description | You can only import your ledger accounts once. To import your ledger accounts, you must: - Have a new Accounting business with no transactions or records
- Save your ledger accounts in a spreadsheet as a comma-separated value (CSV) format
- Use the template file Sage provides to make sure your file has the correct column headings and cell formats
The ledger accounts imported from the CSV file will replace all the standard ledger accounts created in Sage Accounting by default. Make sure you import all the ledger accounts you need. You can manually add individual ledger accounts later, but you can’t import them again. |
| Resolution | ▼ Download the CSV template file Each CSV file contains a list of ledger accounts and the required columns for Nominal Code, Ledger name, Control account, Category and Tax rate. Download the CSV file that’s suitable for your business type. - From Settings, then Business Settings, select Chart of Accounts.
- From the New Ledger Account dropdown arrow, select Import Accounts.
- Download one of the following CSV template files:
▼ Prepare the CSV file Add your ledger accounts to the template file you’ve downloaded or amend an existing file to match the template. - Make sure the column headings match the format used in the template file.
- Remove any columns in your CSV file that aren’t 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 Sage Accounting. You can’t used your own categories.
- Tax rate - Each ledger account must have a VAT Rate associated with it. This sets the VAT rate used by default when the ledger account is selected on a transaction.
The maximum file size you can import is 0.5MB. ▼ Import your chart of accounts - From Settings, then Business Settings, select Chart of Accounts.
- From the New Ledger Account dropdown arrow, select Import Accounts.
 NOTE: You won't see the Import option if you have already created transactions. - Choose the Upload Data File link.
- Browse to your CSV file and then select Open.
- Select OK.
Common errors ▼ Not a valid column heading This indicates that the CSV file contains an invalid column heading. The column headings must be in the following format:
Column A = NOMINAL CODE
Column B = LEDGER NAME
Column C = CONTROL ACCOUNT
Column D = CATEGORY
Column E = TAX RATE To resolve this, you must ensure the column headings are correct and try the import again. ▼ Nominal code must be unique This indicates there’s a duplicated a nominal code within the CSV file. To resolve this, you must check for duplicates in the CSV file and change the code in the indicated cell to a unique nominal code, then try the import again. ▼ Not a number Your data isn't using the number formatting. To resolve this, change the format in the indicated cell and try the import again. ▼ Must be a valid category One more ledger accounts don't have a valid category. The categories must be one of the following: - SALES
- OTHER_INCOME
- DIRECT_EXPENSES
- OVERHEADS
- DEPRECIATION
- CURRENT_ASSETS
- FIXED_ASSETS
- BANK
- CURRENT_LIABILITY
- FUTURE_LIABILITY
- EQUITY
The category you choose determines where the ledger account appears in your management reports. To resolve this, you must use a valid category in the indicated cell and try the import again. ▼ Nominal code already taken This occurs when you’ve used a nominal code reserved for a control account, but haven’t added the required control account text to this or another ledger account. To resolve this, either: - Change the nominal code used for this ledger account, or
- Complete the Control Account column with the appropriate text
|
|