Ehsan
Multi-company financial consolidation in Microsoft Dynamics 365 Business Central combines the general ledgers of every company in a group into one real-time view — per-company columns, a consolidated total, intercompany eliminations, and live dashboards — without exporting to spreadsheets or re-keying data.
What is financial consolidation in Business Central?
Financial consolidation combines the separate books of every company in a group into a single, group-level financial picture: group revenue, group profit, and a combined balance sheet. In Microsoft Dynamics 365 Business Central, each company keeps its own ledger, and consolidation brings those ledgers together so leadership can see the whole group as one entity.
See it on your own group structure
Get in touch with GEM365 to guide you through the process and get consultation for free.
Why is multi-company consolidation hard for holding groups?
For most holding groups, the individual companies are fully digital and up to date, but the group view is not. Producing it usually means exporting each company’s trial balance, assembling the figures in a master spreadsheet, reconciling, and fixing whatever broke since last month. The result is slow, error-prone, and always a step behind the live data.
The difficulty grows when companies sit in different Business Central environments, or even in separate Azure AD tenants — a common situation in groups built through acquisition.
How does GEM365’s consolidation solution work?
GEM365’s Financial Consolidation extension runs natively inside Business Central and reads each company’s general ledger to produce the group result on demand. How the data is brought in depends on where each company lives:
Where your companies sit | How their data is brought in |
Same Business Central environment | Read directly by company name — no export and no import step. |
Separate environment / Azure AD tenant | Imported into Cross-Tenant GL Staging from Excel or using API connections. |
Master Chart of Accounts | Defined once by the parent company in Excel and used across the group. |
What do you get?
A Holding Group Consolidation page — every company side by side, account by account, with a Consolidated total column and intercompany elimination.
On-demand statements — balance sheet, income statement, or both, for any period and fiscal year.
A live dashboard — revenue vs expenses, net profit, assets vs liabilities, and an income-statement breakdown, visualised for leadership.
Is it built on standard Business Central?
Yes. It is a native AL extension that runs inside the Business Central you already license. There is no external middleware and no separate consolidation platform to learn, license, or maintain. Because the data is read live at the moment you run a consolidation, the group result always reflects the current state of the books rather than a periodic snapshot.
Table of Contents
Read more
- How to Consolidate Multi-Company Financials in Microsoft Dynamics 365 Business Central
- Top Dynamics 365 Sales Features: Transform Sales Performance
- Microsoft 365 vs Office 365: Key Differences Explained
- Business Central Cloud vs On Premises: Which to Choose
- Forbes Reveals the Best Cloud ERP: Here’s Why Business Central Wins
How to Consolidate Multi-Company Financials in Microsoft Dynamics 365 Business Central
Top Dynamics 365 Sales Features: Transform Sales Performance
Forbes Reveals the Best Cloud ERP: Here’s Why Business Central Wins
How the Microsoft Power Apps Platform Transforms Manual Processes
F.A.Q
Can Business Central consolidate companies across different Azure AD tenants?
Yes. Companies in the same environment are read directly by name, while companies in a separate environment or Azure AD tenant are brought in through a controlled staging import.
Do I need to re-import the chart of accounts every period?
No. The master chart of accounts only needs re-importing when the group account structure changes. Routine periods only require current ledger data.
Does consolidation change how each company posts?
No. Each company keeps its own books. The solution reads them for consolidation without altering daily operations.
Is the consolidated data auditable?
Yes. Every consolidated figure traces back to a specific company and its general ledger, so the group result stands up to review and audit.
