Built with purposeWhat it helps you decide
- Consolidated revenue and margin by quarter
- Contribution of each entity to the group total
- Size and trend of intercompany eliminations
- Which entity is dragging group margin down
← All example reportsINTERACTIVE REPORT / INVENTED FIGURES
Group consolidation
What does the group actually make, once intercompany is removed?
Explore the live filters below ↓
Swipe sideways to explore the full report canvas and filters.
Group consolidation
Example report, invented dataOverviewBy entityEliminations
Group revenue
€4.15M
+11% YoY
Group margin
15.8%
+1.1pp
Entities consolidated
3
2 countries
Eliminations
€526K
intercompany
Consolidated revenue by quarter
Revenue share by entity
DATA RELATIONSHIP / GROUP REVENUEFrom entities to one view
Entity A€1.91M
Entity B€1.37M
Entity C€869K
CONSOLIDATED VIEW€4.15MInvented figures
Entities
| Entity | Revenue | Margin % | Eliminations |
|---|---|---|---|
| Entity A | 1,909,200 | 19.2% | 240,800 |
| Entity B | 1,367,400 | 21.4% | 163,400 |
| Entity C | 868,600 | 12.8% | 122,120 |
What would feed it
- Accounting exports per entity
- Intercompany mapping sheet
- Bank statements
Who it could help
- Groups with two or more legal entities
- Owners who need one consolidated P&L
- Boards that review results quarterly
BUILT AROUND YOUR BUSINESS
Your report would start with your decision.
These invented examples show possibilities. Your data model, measures and workflow would be scoped together.