Five entities. One of them earns 60% more on every dollar of revenue.
You cannot see that from five sets of accounts sitting side by side. This page walks through a group consolidation built across five territories: a single dashboard with entity drill-down, intercompany flows held on their own lines rather than buried in the totals, and a nine-year three-statement model underneath.
This is a deliverable, not a download. A consolidation is defined by the group it consolidates — the entities, the currencies, the intercompany trading — so there is no meaningful blank version. Every figure below comes from a real, fully worked example.
- Experienced finance professionals
- Multi-entity · multi-currency
- Three statements · 9-year horizon
- Intercompany made explicit
- No lock-in
A group view, an entity view, and the three statements holding both together.
Groups usually have plenty of entity-level reporting and no group-level answer. This is what closes that gap.
Consolidated dashboard
Group revenue, gross margin, EBITDA and PAT on a trailing twelve-month basis, with revenue and EBITDA composition by entity, ten-year trend, and the liquidity and leverage ratios — current ratio, debt to equity, interest coverage, ROCE and ROE — on one page.
Entity drill-down
The same dashboard for any single entity, selected from a dropdown. Same metrics, same layout, so a subsidiary can be read against the group without reconciling two different formats — including working capital days and forecast-versus-actual by month.
Intercompany, on its own lines
Intercompany sales and cost of sales, management and service charges, commissions, and the intercompany receivable and payable balances each held separately — so the group can see performance with internal trading in, and external revenue with it out.
Two dashboards on top. A full three-statement model underneath.
Consolidated P&L
Revenue split by channel — domestic, export, product line, intercompany — through cost of sales, direct and administrative expenses, EBITDA, EBIT, non-operating items and PAT. Nine years across, actuals and forecast on one continuous row.
Consolidated balance sheet
Non-current and current assets, equity, and liabilities split between bank facilities, invoice discounting, trade and intercompany payables. Every section carries a check row, and the sheet ties across all nine years.
Consolidated cash flow
Operating, investing and financing, with working capital movements broken out so a year driven by an inventory release is visibly different from a year driven by trading. Reconciles opening to closing cash, every year.
Built once. Then it refreshes with each entity's monthly export.
Build time depends almost entirely on how consistent the entity data and intercompany balances are to begin with.
Map every chart of accounts
Each entity keeps its own chart of accounts and local reporting obligations. We map each one to a single set of group categories, so no territory is asked to restructure its books to suit the model.
Reconcile intercompany
Match intercompany receivables against payables and intercompany sales against purchases, entity pair by entity pair, and resolve the differences. This is usually the longest step and always the most valuable.
Consolidate and translate
Aggregate to group, apply eliminations, and translate to one presentation currency with exchange differences held separately rather than absorbed into operating results.
Report and forecast
Group dashboard, entity drill-down, and the three statements — with a forecast horizon extending past the actuals so the board is looking forward rather than only back.
Honest qualification. No fluff.
This build fits if:
- You operate two or more entities and there is no single group view anyone trusts.
- Entities trade with each other, and the intercompany balances do not currently agree.
- You report in more than one currency and want translation handled explicitly.
- A board, a bank, or a prospective buyer has asked for consolidated statements.
- You suspect one territory is subsidising another but cannot prove it.
- Each entity closes its own books competently and nobody owns the join.
This is not the right fit if:
- You want a spreadsheet to run yourself — the mapping and reconciliation is the work.
- You operate a single entity; a standard reporting pack will serve you better.
- Entity books are months behind — that needs fixing before consolidation means anything.
- You need statutory group accounts filed and audited, which is an auditor's engagement.
- You already run a consolidation system and need it administered rather than built.
See this built on your own entities.
A short call to look at how many entities are involved, what your close process looks like today, and whether intercompany balances currently agree. That last question usually tells us most of what we need to know.
No obligation. No sales sequence.
This model is a deliverable. These are downloads.
Free Excel tools you can pick up and run yourself, no setup required.
Questions about the model, answered honestly.
Can I download this consolidation model as a template?
How do you handle different charts of accounts across entities?
How is intercompany trading treated?
Does it handle multiple currencies?
How long does a consolidation build take?
How do we get started?
Building the model is the easy half. Making the entities agree is the work.
Every group consolidation we have built has surfaced intercompany balances that did not match, mappings nobody had agreed, or a territory whose real contribution was not what the group assumed. EasePro's Portfolio & Group Reporting Services cover the build and the reconciliation that has to happen first — and the ongoing group reporting cycle once it is running.
Founders from global advisory firms, supported by an in-house trained team of finance professionals. Big Four-grade depth with our own standards for accuracy and data security.