+1 480 485 7373
Microsoft Teams
Begin with the statements, then work backwards
The chart exists to produce financial statements, management reports and tax returns. Before touching a single account number, collect the reports the business actually uses: the income statement and balance sheet the owners see, the lender's covenant package, the departmental profit report and any schedules the tax preparer asks for. Every line on those reports needs a home, and nothing else does.
Companies moving from older systems often arrive with segmented account numbers, where one string encodes the natural account, the department and the location. Carrying that pattern straight into Business Central multiplies accounts, because each combination becomes its own record. The better pattern is one natural account for rent, for instance, with department and location recorded as dimensions on every entry.
Why designing a short chart of accounts in Business Central pays off
A short chart pays off beyond tidiness. Posting groups are simpler to maintain, users pick the right account more often, financial reports need fewer rows, and opening a new location becomes one new dimension value instead of dozens of new accounts.
Each account also carries an Income/Balance setting and an account category with an optional subcategory. The category drives how Business Central groups accounts in its built-in statements and reports. So filling it in carefully is part of designing a chart of accounts in Business Central, not an afterthought.
The account types Business Central uses
Rules that keep a chart usable for years
- ✓Leave gaps in the numbering so new accounts fit inside their group without renumbering anything
- ✓Use one natural account per type of cost or revenue, and put department, location and project in dimensions
- ✓Switch off Direct Posting on receivables, payables and inventory accounts so they only change through sub-ledgers
- ✓Give every posting account a category and subcategory so built-in statements and financial reports group correctly
- ✓Write a one-line note on when to use each account, and block retired accounts instead of deleting them
- ✓Fix the number width once, keep it the same across the chart, and document it for whoever adds accounts later
Example: collapsing a segmented chart into accounts and dimensions
Segmented numbers from the old system
Example: a services firm arrives with rent split into separate accounts for each office and each department, so one expense shows up as many accounts.
- ✓Rent, Phoenix office, consulting team
- ✓Rent, Phoenix office, admin team
- ✓Rent, Denver office, consulting team
- ✓A new account for every new office
One account and two dimensions
The same firm in Business Central posts all rent to one natural account and tags each entry with an Office value and a Department value.
- ✓Rent expense as a single posting account
- ✓Office dimension with Phoenix and Denver
- ✓Department dimension with Consulting and Admin
- ✓A new office becomes one new value
History still ties out
During migration each old segmented account maps to the new account plus its dimension values, so balances and any history brought across still report by office and department.
- ✓Mapping table kept with the migration files
- ✓Old and new trial balances compared before go-live
- ✓Old numbers listed for people who still search by them
The build order that avoids rework
- 1
Agree the dimension design first
Designing a chart of accounts in Business Central starts here. Decide which two dimensions will be global and which others you need, because that choice changes how many accounts you create. If department is a dimension, the chart no longer needs departmental accounts at all.
- 2
Draft the list and numbering
Build the list in a spreadsheet with number, name, account type, income or balance, category and the direct posting setting. Have the controller and the outside accountant mark it up before you import anything.
- 3
Import and indent
Load the accounts through a configuration package or Excel, then run the Indent Chart of Accounts action so headings and totals line up. Check that every Total and End-Total covers exactly the accounts it should.
- 4
Point the posting groups at the new accounts
General posting setup and the customer, vendor, inventory, bank and fixed asset posting groups all reference G/L accounts. Fill them in only once the chart is final, then test by posting one sale, one purchase and one inventory adjustment.
- 5
Rebuild the financial reports
Recreate the income statement, balance sheet and management packs as financial reports using account ranges and dimension filters. Then tie them to the old system's trial balance for the migration period before go-live.
Chart of accounts questions from controllers
How many accounts should a mid-sized company have in Business Central?
There is no correct number, but it is usually far fewer than a segmented legacy chart. The test is whether every posting account appears on a report someone uses, and no dimension could replace it. If two accounts differ only by department, location or project, they should normally be one account with a dimension. Keep separate accounts where the statements, a lender or the tax return genuinely need them.
Can we change the chart of accounts after go-live?
Yes, you can add, rename and block accounts at any time. Renumbering an account that already has entries is possible but needs care, since posting groups, financial reports and integrations may refer to it. Blocking a retired account keeps its history while stopping new postings. Larger restructures are easier at a fiscal year boundary so comparisons stay clean.
Should we keep the sample chart that comes with Business Central?
Use it as a reference rather than your final chart. The sample accounts show the structure and posting group links Business Central expects, which is useful when you start. They rarely match your statements or your accountant's preferences, so most companies build their own list and import it. When designing a chart of accounts in Business Central, starting from your own reports keeps it smaller and more familiar to your team.
More questions on designing a chart of accounts in Business Central
Where do departments and locations go if not in the account number?
They go into dimensions. Each entry can carry values such as Department, Location or Project, and those values filter reports, budgets and analysis views. You can make two dimensions global so their values sit directly on every ledger entry for quick filtering. Our dimensions guide covers that setup in detail.
Does the chart of accounts affect Power BI reporting?
Yes, a clean chart makes Power BI reports simpler to build and easier to trust. Account categories and consistent totals give the report model a stable structure to group by. Dimensions supply the slicing by department or location without extra mapping tables. A cluttered chart pushes those mappings into the report instead, where they drift over time.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.