If your group has grown through acquisition, expansion, or simply setting up new trading entities, you'll know the pain of pulling together a single view of performance at month end. Spreadsheets get emailed between finance teams, exchange rates get applied inconsistently, and eliminations are done by hand and prayer. Microsoft Dynamics 365 Business Central was built with this problem in mind, and its multi-company and intercompany functionality can turn a week of consolidation work into a same-day job.

What multi-company actually means in Business Central

In Business Central, each legal entity in your group sits as a separate "company" within the same environment. Each company keeps its own chart of accounts, its own ledgers, and its own set of users and permissions, so statutory reporting and local compliance stay intact. What changes is that these companies can talk to each other and roll up into a single group view, rather than existing as isolated silos that only meet in a spreadsheet.

This matters for finance directors because it separates two things that often get conflated: keeping entities legally and financially distinct, and being able to see the group as a whole. Business Central lets you do both without duplicating effort.

Setting it up

A multi-company setup typically involves three building blocks:

Company creation. Each subsidiary or trading entity is set up as its own company within the tenant, usually mirroring the structure you already have in your group accounts.

A consistent chart of accounts. Group reporting only works if every company maps to the same account structure, or at least a structure that can be translated cleanly. This is normally agreed and templated before rollout, so new entities inherit it automatically.

Intercompany setup. Business Central's Intercompany module links companies so that a transaction entered in one automatically creates the corresponding entry in the other, whether that's a recharge, a stock transfer, or a management fee. Partner companies are registered, mapping tables are configured between charts of accounts, and dimensions (cost centre, department, project) are aligned so consolidated reports actually mean something.

None of this needs to happen overnight. Most groups roll out entity by entity, getting the core company live first and adding intercompany links as new subsidiaries come online.

Where it earns its keep

Group reporting. Finance directors get a consolidated profit and loss and balance sheet without waiting on individual entities to submit numbers. Combined with Power BI, this can be live rather than a monthly snapshot.

Shared services. If you run a central finance, HR, or IT function that recharges costs to operating companies, intercompany transactions automate what would otherwise be a manual recharge spreadsheet, complete with an audit trail.

Intercompany trading. Groups that buy and sell between their own entities, common in manufacturing and distribution, can post a sales order in one company and have the matching purchase order created in the other automatically, keeping both sets of books in step.

A worked example

Take a fictional UK group, Hartley Fittings Group, with three entities: Hartley Fittings Manufacturing (based in Leeds), Hartley Fittings Distribution (based in Bristol), and a small central services company, Hartley Group Services, that handles finance and IT for both.

Before Business Central, month end meant each entity exporting its trial balance, emailing it to group finance, and someone manually eliminating the intercompany recharges and stock transfers between Manufacturing and Distribution. This routinely took four to five working days and relied on one person's spreadsheet macro.

With multi-company and intercompany set up, Manufacturing posts a stock transfer to Distribution and the corresponding purchase entry appears automatically. Hartley Group Services' monthly recharge to both operating companies posts itself based on a pre-agreed allocation. At month end, group finance opens a consolidated report that reflects live data from all three companies, already net of intercompany balances. The close drops from days to hours, and the finance director gets a same-day answer instead of a week-old one.

Getting the foundations right

The time savings are real, but they depend on the setup being done properly at the outset: a clean chart of accounts, sensible dimension structures, and intercompany mapping that reflects how the group actually trades. Get this wrong and you end up automating a mess rather than removing one.

If your group is weighing up a multi-entity implementation, or you've inherited a Business Central setup that isn't quite pulling its weight on group reporting, speak to Creative Computing. We've spent years helping UK groups get their financial reporting under control, and we can talk through what a multi-company setup would look like for your business.

‍