Skip to content
Microsoft Solutions Partner · Vancouver, BC
Contact usFree consultation
Articles

How to Consolidate Multi-Company Financials in Microsoft Dynamics 365 Business Central

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.

Play the video on YouTube
How to Consolidate Multi-Company Financials in Microsoft Dynamics-gem365.ca

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 sitHow their data is brought in
Same Business Central environmentRead directly by company name — no export and no import step.
Separate environment / Azure AD tenantImported into Cross-Tenant GL Staging from Excel or using API connections.
Master Chart of AccountsDefined once by the parent company in Excel and used across the group.

Edit Table

How does GEM365’s consolidation solution work?-gem365.ca

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.

Screenshot 2026 07 05 153935-gem365.ca
What do you get?-gem365.ca

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.

Is it built on standard Business Central?-gem365.ca

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.

Simplifying IT solutions
for a complex world.
Platform partnerships
Book a demo

Complete this form and we will be in touch with you.

We hope to see you soon!

Please enable JavaScript in your browser to complete this form.
Simplifying IT solutions
for a complex world.
Platform partnerships
Gem365

Reliable Partner

When it comes to optimizing your business with Microsoft Enterprise Solutions, the choice of a partner is crucial. At GEM365, we go beyond standard solutions, offering personalized and cutting-edge services that cater to your business’s unique requirements.