Somewhere in most multi-entity finance teams' month-end routine sits a spreadsheet nobody's proud of. Trial balances get exported entity by entity, pasted into a master tab, intercompany balances get manually zeroed out, and currency gets converted with a formula someone built three years ago that nobody fully trusts anymore.
The frustrating part: Business Central has a native consolidation engine built specifically to eliminate this. Most companies running multiple entities on BC simply never turned it on properly — often because it was configured quickly during implementation and nobody's gone back to fix it since.
Here's what proper multi-entity consolidation setup actually looks like, and where it typically breaks.
How Consolidation Actually Works in BC
Business Central handles consolidation through a dedicated consolidation company — a separate company database that pulls in financial data from each of your subsidiary or business unit companies and combines it into one set of consolidated statements.
Each subsidiary is registered as a Business Unit inside the consolidation company, with a defined consolidation method — typically full consolidation for wholly or majority-owned entities. From there, running a consolidation pulls G/L balances from each business unit into the consolidation company automatically, rather than requiring anyone to manually re-key numbers.
When this is set up correctly, closing consolidated financials becomes a matter of hours, not days. When it isn't, the manual spreadsheet workaround creeps back in — and once that habit forms, most teams never go back to fix the root cause.
Where the Setup Typically Breaks
1. Chart of Accounts Misalignment
Consolidation depends on every subsidiary's Chart of Accounts mapping cleanly to the consolidation company's chart. If Entity A calls an account "Office Supplies" and Entity B calls the equivalent account "General Office Expense," the consolidation engine has no way to know they're the same line item unless someone explicitly maps them.
This is the single most common reason consolidation stalls. Entities that were acquired, or that grew up independently before standardizing on BC, often carry charts of accounts that were never rationalized against each other. The fix isn't glamorous — it's a disciplined mapping exercise, done once, done properly, rather than patched around every month-end.
2. Intercompany Eliminations Left Manual
Transactions between related entities — one subsidiary invoicing another, intercompany loans, shared service allocations — need to be eliminated at consolidation, or your consolidated revenue and expenses will be artificially inflated.
BC supports intercompany elimination through dedicated elimination accounts and, where Intercompany Postings functionality is properly configured, can automate much of this instead of relying on someone manually journaling out intercompany balances every period. Companies that skip this configuration end up doing elimination entries by hand — a process that's slow and genuinely easy to get wrong, especially as transaction volume grows.
3. Currency Translation Set Up as an Afterthought
For companies with entities operating in multiple currencies, translation method matters. BC supports both the current rate method and other translation approaches depending on the nature of each subsidiary, and getting this wrong doesn't just create a rounding error — it can meaningfully distort consolidated equity and retained earnings over time.
This needs to be decided deliberately at setup, aligned with how your auditors expect currency translation to be handled, not defaulted to whatever the system assumed during a rushed implementation.
4. Dimensions Not Carried Through Consistently
If you want to slice consolidated results by business line, region, or project across entities, your Dimensions need to be used consistently across every business unit — not just within each entity individually. A dimension called "Region" in one entity and "Territory" in another means your consolidated reporting can't cleanly segment by that dimension without manual rework.
What Good Consolidation Setup Delivers
Done properly, a CFO or Controller should be able to run consolidation, review eliminations, and produce consolidated financial statements without touching a spreadsheet — and without needing to manually verify that intercompany balances actually zeroed out.
That's not a theoretical outcome. It's what the native functionality is built to do. The gap between that and "we still consolidate in Excel" is almost always a configuration gap, not a platform limitation — the same pattern that shows up across most Business Central performance and reporting complaints.
Where to Start
Before assuming your organization has simply outgrown native consolidation, it's worth auditing three things: whether your subsidiaries' charts of accounts actually map cleanly to your consolidation company, whether intercompany eliminations are automated or still manual, and whether currency translation was configured deliberately or left at a default.
Most companies find the fix is narrower — and faster — than they expected.