Multi-company Business Central: intercompany and consolidation done right
Business Central handles multiple legal entities well, but only if the structure is designed up front. Most multi-company pain we see, like slow closes, manual eliminations and reports that don't agree, traces back to a handful of early decisions.
1. Decide what a "company" really is
Not every entity needs its own Business Central company. Separate companies make sense for separate legal entities, tax registrations, or currencies. For divisions, locations or product lines within one legal entity, dimensions are usually the better tool. They're simpler to maintain and easier to report across.
Getting this wrong in either direction is expensive: too few companies and you can't produce clean statutory reporting; too many and you multiply setup, maintenance and intercompany work.
2. Share one chart of accounts
Consolidation is far easier when every company uses the same chart of accounts, or at least maps cleanly to a common one. Agree on it before configuring the first company. Local statutory needs can usually be handled with additional accounts or dimensions, not a different structure.
3. Standardize dimensions across companies
Dimensions such as department, region, project or product line are what make Business Central reporting powerful. Use the same dimension codes and values in every company so management reporting rolls up without translation tables or spreadsheet mapping.
4. Use intercompany properly
Business Central's intercompany functionality lets one company send transactions, like sales and purchase documents or journal entries, to another, where they're reviewed and posted. Set up correctly, it means:
- Each intercompany transaction is entered once, not keyed twice
- Intercompany balances agree by design, which makes eliminations straightforward
- There's an audit trail between the two sides of every transaction
The setup work is in the details: intercompany partners, intercompany account mapping, dimension mapping, and clear ownership of who reviews the inbox in each company.
5. Plan consolidation from day one
Business Central's consolidation features combine subsidiary results into a consolidated company, including currency translation for foreign subsidiaries and elimination of intercompany balances. Decide early:
- How often you consolidate (monthly is typical)
- Which exchange rates apply to balance sheet and income statement accounts
- How eliminations are handled and who reviews them
- Whether partially owned entities need special treatment
6. Multi-currency is a design decision
If any entity operates in a different currency, plan currency handling deliberately: functional currency per company, an additional reporting currency if needed, and exchange rate maintenance. Retrofitting currency handling after go-live is one of the more painful fixes we're asked to make.
The test: can your CFO see consolidated, eliminated results within a few days of month-end, without spreadsheets? If not, the structure, not the people, is usually the problem.
Already live with a structure that isn't working?
It can be fixed. Common improvements include standardizing dimensions, introducing proper intercompany posting, cleaning up account mapping and automating consolidation. The right sequence depends on your close calendar and audit cycle, so it's worth an assessment before changing anything.