Management Reporting | Consolidation
Group reporting with the eliminations already done.
Multi-entity consolidation with currency translation, intercompany eliminations and minority interest handled inside the report rather than in a spreadsheet afterwards. Each entity keeps its own books in its own currency and the group position rolls up from them, so the consolidation is reproducible rather than reconstructed.
What the system does
Capability, input, output.
| Capability | Input | Output |
|---|---|---|
| Roll-up | Entity ledgers | The group position, computed rather than keyed |
| Translation | Entities in other currencies | Translated on the applicable basis, with the effect shown separately |
| Eliminations | Intercompany balances and transactions | Matched and eliminated, with what did not match reported rather than forced |
| Minority interest | Partly owned entities | Computed by ownership and presented separately |
| Entity drill-down | Any consolidated figure | The contributing entities, then the transactions |
| Reproducibility | A prior consolidation | Re-runnable, producing the same result, with the workings retained |
| Partial groups | A subset of entities | Sub-consolidations for a region or a sub-group, on the same basis |
-
Roll-up
- Input
- Entity ledgers
- Output
- The group position, computed rather than keyed
-
Translation
- Input
- Entities in other currencies
- Output
- Translated on the applicable basis, with the effect shown separately
-
Eliminations
- Input
- Intercompany balances and transactions
- Output
- Matched and eliminated, with what did not match reported rather than forced
-
Minority interest
- Input
- Partly owned entities
- Output
- Computed by ownership and presented separately
-
Entity drill-down
- Input
- Any consolidated figure
- Output
- The contributing entities, then the transactions
-
Reproducibility
- Input
- A prior consolidation
- Output
- Re-runnable, producing the same result, with the workings retained
-
Partial groups
- Input
- A subset of entities
- Output
- Sub-consolidations for a region or a sub-group, on the same basis
Consolidation Reports FAQ
What buyers ask.
What usually goes wrong with consolidation in a spreadsheet?
The eliminations. They are carried forward month to month, and when an intercompany balance does not agree, the difference gets plugged rather than investigated. Six months later nobody can say what the plug represents.
What happens when intercompany balances do not match?
They are reported as a difference rather than forced to zero. A mismatch is real information, usually a timing difference or a transaction booked on one side only, and hiding it is how it survives to year end.
Which framework does it present under?
US GAAP for a US group, and the framework follows the country rather than being assumed, because a group reporting under the wrong framework is a factual error rather than a formatting preference.
Can we consolidate a sub-group?
Yes. Region or sub-group consolidations run on the same basis as the full group, which matters when a regional holding entity has its own reporting obligations.
Is a prior consolidation reproducible?
Yes, and this is the point of doing it in the system. Re-running a prior period produces the same result with the workings retained, which a spreadsheet whose inputs have moved cannot do.
See your group position roll up.
Connect your entities, free. Translation, eliminations and minority interest compute from the books you already keep.