Consolidation in Business Central

A group of companies running Business Central usually needs to produce consolidated financial statements showing the group as a single economic entity. BC ships native consolidation functionality — a way to pull subsidiary G/L data into a parent company, translate it into the parent's currency, and produce consolidated trial balances and reports.

Architecture. Each subsidiary is its own BC company. A separate consolidation company is created — empty of operational data, used purely as the destination for consolidated G/L. Subsidiaries are configured as Business Units in the consolidation company, defining how each subsidiary's data is imported.

Business Unit card. Per subsidiary:

• Company Name — the BC company holding subsidiary data.
• Consolidation Method — Purchase, Pooling of Interests, Equity, Proportional. Most are Purchase for fully-owned subsidiaries.
• Consolidation % — for proportional or partial ownership.
• Currency Code — subsidiary's local currency.
• Exchange Rate translations — which rate (closing, average, historical) applies to which account category.
• G/L Account Mapping — how subsidiary chart of accounts maps into the consolidation chart of accounts (if charts differ).

Two import paths.

1. Database — direct read from another BC company in the same tenant. Faster, no file movement.
2. File — subsidiary exports a Consolidation XML file; consolidation company imports it. Used when subsidiaries are on separate tenants or different BC versions.

Running consolidation. The Import Consolidation from Database or ... from File action on the consolidation company:

1. Reads subsidiary G/L entries for the period.
2. Applies currency translation per account-rate rule.
3. Maps each account into the consolidation chart of accounts.
4. Posts G/L entries in the consolidation company tagged with Business Unit Code.

The consolidation company's trial balance is now the sum of subsidiaries.

Currency translation. Each G/L account in the consolidation chart specifies which type of rate to apply:

• Closing Rate — for balance sheet accounts (assets, liabilities).
• Average Rate — for P&L accounts.
• Historical Rate — for equity accounts that should not retranslate (share capital).

The translation differences accumulate to a Cumulative Translation Adjustment (CTA) account on equity — a standard IFRS / US GAAP presentation requirement.

Eliminations. Intercompany transactions (subsidiary A sells to subsidiary B) need elimination — otherwise consolidated revenue and cost are double-counted. BC's consolidation doesn't auto-eliminate; you post elimination journals in the consolidation company. Common eliminations:

• Intercompany sales / purchases — reverse each side.
• Intercompany AR / AP — net to zero.
• Intercompany loans — eliminate principal and interest.
• Unrealised intercompany profit in inventory — defer until the inventory is sold externally.

Elimination journals are repeated every period; a documented template makes them manageable.

Minority interest (non-controlling interest). For partially-owned subsidiaries (e.g. parent owns 75%), the minority's 25% share of net income belongs to a separate equity line. The Consolidation % setting handles consolidation percentage but the NCI journal entries are manual elimination work.

What BC consolidation does NOT do.

• Automatic intercompany elimination — manual journals required.
• Investment in subsidiary elimination — manual.
• Goodwill calculation — manual.
• Full statement of cash flows at group level — manual (BC has cash flow at company level only).
• IFRS consolidated disclosures (segment reporting, etc.) — Power BI / Excel.

For groups with these complexity needs, dedicated consolidation tools (OneStream, Tagetik, BPC, or Microsoft Financial Reporting) are layered on top of BC.

Multi-currency consolidated reporting. A consolidated trial balance in USD is straightforward — but a French parent reporting in EUR with US subsidiaries needs USD → EUR translation in addition to subsidiary local currency. BC handles both layers as long as the rate setup is configured.

Common pitfalls.

• Chart-of-accounts mismatch. Subsidiaries with different charts → consolidation accounts mismatched. Either harmonise charts or maintain mapping tables rigorously.
• Missing elimination journals. Group revenue overstated. Reconciliation between intercompany AR and AP catches this — they must net to zero per period.
• CTA account not configured. Translation differences post wrong; balance sheet doesn't balance.
• Re-running consolidation overwrites manual entries. It does — re-import deletes prior consolidation entries for the business unit. Eliminations must be re-applied or kept distinct (use a separate "Elimination" business unit).
• Currency rates not refreshed. Old rates used; results wrong.

Reporting cadence. Most groups consolidate monthly, with a full reconciliation at quarter end and audit-quality consolidation at year end. The first consolidated close in BC always reveals chart-of-accounts and rate setup issues; build buffer time into the close calendar.