Consolidating multiple Business Central companies in one model

Running more than one Business Central company is common in group structures, but consolidating reporting across them is where the pain starts. Mismatched CoA's, manual intercompany txs, and no single view of group performance. Solving this is a data architecture decision, not a reporting one.

Plenty of businesses run more than one Business Central company: separate legal entities, acquisitions that kept their own setup, or divisions split for good operational reasons. Reporting on each is straightforward. Reporting on all of them as one business is where it gets hard, and it is one of the most common things we are asked to fix. The good news is that it is a solved problem, as long as you do the unglamorous work first.

Why multi-company reporting is hard.

The difficulty is rarely the joining together. It is that the companies do not match. They may use different charts of accounts, so the same cost sits under different codes. They may use dimensions differently, so a region or a department means one thing in one company and something else in another. They may trade in different currencies. And they may trade with each other, which means some of the revenue and cost is internal and has to be removed before the consolidated numbers make sense. Stack the data up without dealing with these and you get a total that is confidently wrong.

Get the dimensions to line up first.

The first and most important job is mapping. Decide on one consolidated chart of accounts and map each company's accounts to it, so like sits with like. Do the same for the dimensions that matter, region, department, product group, so they mean the same thing everywhere. This is careful, sometimes tedious work, and it is the part that decides whether the consolidation is trustworthy. Get it right once, build it into the model, and every report downstream inherits it. Skip it, and no amount of clever reporting will rescue the numbers.

Currency and intercompany.

Two things need real care. Currency, where amounts in different currencies must be converted to a single reporting currency on a consistent and defensible basis, so the totals mean something and stand up to scrutiny. And intercompany trading, where sales and costs between your own companies have to be identified and removed, or you will count the same money twice and overstate the group. Both are well-understood problems with established approaches, and both are easy to get subtly wrong, which is exactly why they reward doing deliberately rather than by hand each period.

One model, many companies.

With the mapping, currency and intercompany handled, the rest is the part people imagined was hard and is not. The companies' data is brought together into one model, with a company dimension so you can report the group as a whole or drill into any single entity. One set of definitions, one refresh, one trusted view, and the ability to slice it by company whenever you need to. From there, the consolidated board pack stops being a monthly assembly job and becomes a report that simply runs.

So this week, check one thing: do your companies share a chart of accounts and consistent dimensions, or not. If they do, consolidation is mostly mechanical. If they do not, that mapping is the first job, and it is the foundation everything else rests on. Building consolidated reporting across multiple Business Central companies is everyday data platform and Power BI work for us. The entities can stay separate where they need to. The reporting does not have to.