Multi-Entity & Intercompany Consolidation in Business Central

For a single company, closing the books is a routine. For a group — multiple entities, plants or legal companies under one owner — it becomes a monthly ordeal of exporting trial balances, matching intercompany balances in spreadsheets, converting currencies by hand, and hoping nothing was missed. Microsoft Dynamics 365 Business Central is built to take that pain out of group finance. Here's how multi-entity and intercompany consolidation actually works in Business Central, and what a clean group close looks like.

Why multi-entity consolidation is hard

• Each entity keeps its own books, often with its own chart of accounts.
• Intercompany transactions — one entity selling to another — must be recorded on both sides and then eliminated at group level.
• Entities may operate in different currencies that have to be translated into the group's reporting currency.
• Everyone must close on the same numbers, at the same cut-off, without version drift.

Done in Excel, every one of these is a manual, error-prone step. Done in an ERP, most are automated and auditable.

How Business Central handles it

A dedicated consolidation company

Business Central lets you set up a consolidation company that pulls in figures from each subsidiary (its business units). Each subsidiary's data can be imported directly from another Business Central company or from a file — so no one is rekeying trial balances.

Mapping different charts of accounts

Subsidiaries don't need an identical chart of accounts. Each account is mapped to a consolidation account, so entities with different account structures still roll up correctly into one group view.

Consolidation percentages

You can consolidate an entity at a set percentage of ownership — useful for partially owned subsidiaries and joint ventures.

Multi-currency translation

Business Central translates each entity's figures into the group's reporting currency using the method you choose — for example, closing rate for balance-sheet accounts and average rate for the P&L — and records the translation differences automatically.

Intercompany postings

For groups that trade internally, the intercompany (IC) feature lets entities send transactions to each other using IC partner codes and a shared IC chart of accounts, so a sale in one company appears as a matching purchase in the other — ready to be reconciled and eliminated.

Eliminations

Intercompany balances and transactions are eliminated at the consolidation level, so the group accounts don't double-count internal activity.

What a clean group close looks like

With this in place, a month-end that used to take a week of spreadsheet work becomes a sequence: each entity closes its own books, the consolidation company imports and translates the figures, intercompany balances reconcile against IC partner data, eliminations run, and the group statements are ready — with a full audit trail of where every number came from. Layer Power BI on top and leadership sees consolidated performance in near real time, not three weeks later.

Common pitfalls (and how to avoid them)

• Inconsistent account mapping between entities — fix it with a governed consolidation-account structure.
• Intercompany balances that don't match — enforce IC postings instead of manual journals.
• Currency differences booked by hand — let Business Central's translation handle them.
• Entities closing on different cut-offs — standardise a single group calendar.

Getting it right

Multi-entity consolidation is one of the highest-value things an ERP does — but it rewards careful setup: a clean consolidation structure, disciplined intercompany processes, and the right currency and elimination rules. That's where implementation experience pays for itself. Nexvoria implements and optimises multi-entity Business Central for Indian groups and manufacturers. If your group close still runs on spreadsheets, a short operations review will show you exactly where the time and risk are hiding.

Frequently Asked Questions

Can Business Central consolidate companies with different charts of accounts?

Yes. Each account is mapped to a consolidation account, so entities with different structures still roll up into one group view.

Does it handle multiple currencies?

Yes. Business Central translates entities into the reporting currency using configurable methods and records translation differences automatically.

Can it consolidate partially owned subsidiaries?

Yes, using consolidation percentages to reflect the ownership share.

Does it work if a subsidiary is not on Business Central?

Yes. A subsidiary's data can be imported from a file, so entities on other systems can still be consolidated.

Enterprise ERP Architecture · Business Intelligence