Every Chart of Accounts starts clean. Someone designed it carefully during implementation, mapped it to a logical structure, and it made sense. Then two years pass. A new product line launches and gets its own account instead of a dimension. Someone adds a one-off account for a grant that expired eighteen months ago. A departing controller's pet project account never gets cleaned up because nobody's sure if it's still in use.
None of this happens through negligence. It happens through completely reasonable, individually justified decisions that nobody ever steps back to review as a whole. And at some point — usually quietly, usually without anyone declaring it — the Chart of Accounts stops being a clean financial structure and starts being an archaeological record of every decision the finance team has made since go-live.
Here's how to know when a review is actually overdue, and how to run one without breaking anything you rely on for historical reporting.
The Signs a Review Is Overdue
A few patterns show up consistently in Charts of Accounts that need attention. None of them alone is damning, but seeing several together is a reliable signal.
- Account count has grown faster than the business. If your Chart of Accounts has doubled in size over a period where revenue or headcount grew by 20%, something other than genuine business complexity is driving that growth.
- Reconciliations take longer than they used to, with no clear reason why — often because there's more noise in the trial balance to sort through, not because the underlying business got more complicated.
- Multiple accounts exist for functionally identical purposes, usually because someone didn't realize a suitable account already existed and created a new one instead of using — or asking about — what was already there.
- Nobody on the current team can confidently explain what half the accounts are for. This is the clearest signal of all. Institutional knowledge about "why this account exists" tends to leave with the person who created it.
- You're using account codes to capture information that Dimensions should be capturing — department, location, project, product line — which inflates the chart with accounts that are really just dimension values in disguise.
Why This Happens Specifically in Business Central
BC's flexibility is part of the problem here, ironically. Creating a new G/L account is fast and doesn't require much justification, while properly using Dimensions to capture the same distinction takes more upfront thought. Under deadline pressure, the path of least resistance is almost always "just add an account" rather than "set up a dimension properly."
This compounds over time because each new account, once created, tends to stay forever. Nobody wants to be the person who deletes an account and accidentally breaks a saved report or a prior-year comparison, so the chart only grows. Multiply that hesitation across several years and multiple finance team members, and you get exactly the kind of sprawling, half-understood chart most companies are quietly sitting on.
How to Run the Review Without Breaking Anything
1. Pull Actual Usage Data First
Before deciding anything is dormant, check the G/L Entry table for actual posting activity per account over the last 24 months. An account with zero postings in two years is a strong candidate for consolidation. An account that gets one posting a year might still be legitimate — check before assuming.
2. Separate "Delete" from "Consolidate" from "Leave Alone"
Never delete an account with historical postings — doing so breaks prior-period reports and can create real problems for auditors. Instead, dormant accounts with history should be marked inactive so they can't receive new postings, while their historical data stays intact and reportable. True duplicates — two accounts serving an identical purpose — are candidates for consolidation, which requires remapping historical entries, not deletion.
3. Distinguish Genuine Accounts from Disguised Dimensions
Any account that exists purely to capture a department, location, or project distinction is a candidate to be replaced by proper Dimension usage going forward. This doesn't mean rewriting history — it means stopping the pattern from continuing, and building a plan to migrate reporting toward the Dimension-based structure over time.
4. Get Sign-Off Before Changing Anything Live
A Chart of Accounts review touches how every department's numbers get reported. Changes should be reviewed with whoever relies on those reports — FP&A, department heads, anyone pulling numbers for board reporting — before anything goes live, not after someone notices their usual report looks different.
What a Clean Chart Actually Buys You
The payoff isn't cosmetic. A rationalized Chart of Accounts makes reconciliation faster because there's less noise to sort through at close. It makes onboarding new finance staff faster because the structure is actually self-explanatory again. And it makes every report built on top of it — budget vs. actual, departmental P&Ls, board decks — more trustworthy, because the numbers rolling up into them aren't scattered across a dozen near-duplicate accounts nobody fully understands anymore.
When to Actually Do This
There's no perfect calendar trigger, but a few moments are natural windows: after a system upgrade, before a major reporting change, following an acquisition that merged two charts together, or simply when a new Controller or CFO comes in and wants to understand what they've inherited. If none of those apply and it's simply been several years since anyone looked closely — that's reason enough on its own.