Group Consolidation Model

The problem

Each subsidiary closes in its own ERP and sends a trial balance. The group team maps them in Excel, chases intercompany differences by email, and rebuilds the consolidation each month. One late entity holds up the board pack, and nobody can trace a group number back to the account it came from.

What we build

A Power BI model that takes each entity's trial balance as it is, maps it once to group reporting lines, matches and eliminates intercompany balances, applies ownership and non-controlling interest, translates foreign-currency entities, and produces consolidated statements that reconcile back to every account. The mapping table is the only manual input; eliminations are generated in the model, not typed in. A new year's files flow through without rebuilding anything.

What you receive

• Group mapping file, owned by your team
• The Power BI consolidation model
• Consolidated P&L, balance sheet and cash flow
• Intercompany mismatch report
• Reconciliation to each entity's trial balance
• Team training and handover notes

What we need from you

Trial balances for each entity (any ERP export), the ownership structure, and the intercompany account codes. For the free prototype, a sample or anonymised version of two or three entities is enough.

How it runs

1. 1 · Understand
2. 2 · Map
3. 3 · Build
4. 4 · Validate
5. 5 · Train & hand over