Designing a chart of accounts in Business Central

How the chart of accounts in Business Central is built

Open Chart of Accounts and each line is a G/L account. It has a number, a name and an Income/Balance setting. That setting says whether it belongs to the income statement or the balance sheet. Income statement accounts clear to retained earnings at year end. Balance sheet accounts carry their balance forward.

The Account Type field gives the list its shape. Posting accounts receive entries. Heading accounts are titles. Begin-Total and End-Total accounts wrap a range and add it up. Total accounts sum whatever range you enter in the Totaling field. Then the Indent Chart of Accounts action indents everything between each begin and end pair.

Numbering your Business Central chart of accounts

Use numbers of one length and group them in ranges: assets, liabilities, equity, revenue, cost of goods sold, operating expenses and other items. Leave gaps between accounts, so you can insert a new one in the right place later. Account numbers sort as text. So mixed lengths give an order that surprises people.

Resist the urge to put departments, locations or product lines into the number. In Business Central, dimensions do that job. They tag each entry and let one travel expense account serve every department. Companies that move from a segmented chart often cut the number of accounts a lot once the segments become dimensions.

Account categories and financial reports

Every posting account has an Account Category, such as Assets, Income or Expense. You can also add an Account Subcategory on the G/L Account Categories page. These categories feed the standard balance sheet and income statement. So a wrongly categorized account lands in the wrong part of the statement, even when the numbers are right.

After you change categories, use the action on the G/L Account Categories page that generates the financial reports again. For statements in your own format, build row and column definitions in Financial Reports. Rows can total by account range or by category. Design the chart and the statement layout together, and you save rework later.

Linking your Business Central chart of accounts to posting groups

Users rarely choose a G/L account on a sales or purchase document. Posting groups do it for them. Customer and vendor posting groups point to receivables and payables accounts. Inventory posting setup points to stock accounts. General posting setup maps each business and product group pair to revenue, cost and discount accounts.

For accounts that subledgers control, such as receivables, payables and inventory, clear the Direct Posting field. Then nobody can journal to them by hand and break reconciliation. On expense accounts, fill in the general product posting group and tax group. They then default on purchase invoice lines, so users have less to enter.

Loading the chart of accounts in Business Central

A new company created with a setup template comes with a sample chart you can adapt. To bring your own, prepare it in Excel and import it through a configuration package that includes the G/L Account table. For smaller changes, use Edit in Excel on the Chart of Accounts page. Run the indent action afterward.

Once you are live, block accounts you no longer use instead of deleting them. Accounts with entries in open years cannot simply be removed. Also limit who may create accounts, and ask for a reason each time. If you rebuild a chart during a migration, our consultants can help map old accounts to new ones and dimensions.

Business Central chart of accounts questions

Can I import my existing chart of accounts?

Yes. Put the account number, name, type, income or balance setting and category into an Excel sheet. Then import it with a configuration package. The package checks the data before it applies it, so errors such as a missing category show up first. That makes it safe to load a full chart in one go.

How long should account numbers be?

Business Central allows up to twenty characters. But short numeric codes of one fixed length are easier to read, key and sort. Four to six digits is common. What matters most is that every account uses the same length. Then your reports sort in the order your finance team expects, with no surprises.

Can I renumber accounts after going live?

You can rename an account number, and Business Central updates the related records. On a large database this takes time, so test it in a sandbox copy first. Treat it as a planned project, not a quick edit. Also tell your auditors and anyone who keeps reports or Excel files tied to the old numbers.

Do multiple companies have to share one chart?

No. Each company has its own chart. But using the same chart across companies makes consolidation and intercompany postings much simpler. Where charts differ, the consolidation setup maps each subsidiary account to an account in the consolidated company. So plan the Business Central chart of accounts once for the whole group.

Why can I not post directly to my receivables account?

The Direct Posting field is probably cleared on that account, which is good practice. Receivables should change only through customer transactions, so the subledger and the general ledger always agree. So post through the customer instead. If you truly need a manual entry, use a different account for it.

Guides that pair with your Business Central chart of accounts

Your Business Central chart of accounts is one half of the finance design. These pages explain the other half, which is dimensions. They also cover the closing and reporting work that depends on both. Read them together, so your accounts, your tags and your statements all fit in one plan. For the product detail, see Set up the chart of accounts on Microsoft Learn.