Review your chart of accounts

See a list of all your ledger accounts

Export your ledger accounts to a excel spreadsheet

Sort and filter the list to find the a ledger account.

When you first set up your company in Sage Accounting, we create a set of ledger accounts based on your type of business: Sole trader, limited company or limited liability partnership (LLP). Also known as your Chart of accounts.

We use ledger accounts to group your transactions so you can see how your business is performing.

Each has Category and Group that determines how transactions are reported on your financial reports; the Profit and Loss and the Balance Sheet.

All your ledger accounts are shown in the Chart of accounts list.

Watch a video

Find a ledger account

From Settings, then Chart of Accounts.

Use the Search box to filter the list by a by name or number.

Sort the list by Category, choose from the drop-down and select Search.

Export your chart of accounts

Send the list of ledger accounts to a excel spreadsheet.

To save time setting up a new chart of accounts in a new business, consider exporting the existing chart of accounts to a spreadsheet, make the required changes and import back into Sage Accounting. You can only do this when no transactions have been entered in Sage Accounting. See Import a chart of accounts file

The export shows the nominal code, ledger name, control account, category, tax rate and its visibility.

  1. From Settings, then Chart of Accounts.
  2. From the New Ledger Account drop-down, select Export Accounts.
  3. Once the export has finished, you'll see a notification in the reports folder on the top menu.

Import your chart of accounts

Use our CSV file template to import your existing chart of accounts. Useful if you're coming from another system and want to use the same ledger accounts.

You can only do this when no transactions have been entered in Sage Accounting.

See Import a chart of accounts file

Make changes to your ledger accounts

Create as many new ledger accounts as you need or change existing ones to suit your business.

For example, if you're running a gardening business, you might want to change Product Sales to Gardening Sales.

See how to create or edit a ledger account

Print a list of ledger accounts

  1. From Reporting, choose Chart of Accounts under Advanced Reports.
  2. By default, the report shows a list of all categories. To view a list of categories for only one type select the Type drop-down list and then select it.

The Chart of Accounts is a list of all categories used by your business.