How to set up multi-entity consolidation
Consolidating several entities by hand each month is slow and error-prone. Here is how to structure it so the roll-up is repeatable and correct.
Why consolidation gets messy
Consolidation is more than adding entity totals together. You have to align charts of accounts, eliminate transactions between entities, translate foreign currencies, and handle any minority ownership. Done in a spreadsheet each month, every one of those steps is a chance for an error that is hard to trace later.
The consolidation steps
- 1Align each entity to a common chart of accounts or a shared mapping.
- 2Close each entity on its own so you consolidate final, not draft, numbers.
- 3Translate foreign-currency entities to the reporting currency at the correct rates.
- 4Eliminate intercompany balances and transactions so nothing is double-counted.
- 5Roll the entities up into consolidated statements.
- 6Reconcile the consolidated result and document the eliminations for the audit trail.
The adjustments that matter most
| Adjustment | Why it is needed |
|---|---|
| Intercompany elimination | Removes sales, loans, and balances between your own entities |
| Currency translation | Converts foreign entities to the reporting currency consistently |
| COA mapping | Lines up different account structures onto one reporting layout |
| Minority interest | Splits out the share of an entity you do not fully own |
How Fintra runs consolidation
- Multi-entity consolidation rolls entities into one view against a shared chart of accounts.
- Multi-currency accounting translates foreign entities and handles FX revaluation.
- Each entity closes on its own readiness score before it rolls into the group close.
- Eliminations and the consolidated result carry a full audit trail for review.
Frequently asked questions
What is multi-entity consolidation?
It is combining the financials of several legal entities into one consolidated set of statements. It requires aligning charts of accounts, translating currencies, and eliminating transactions between the entities so the group result reflects only activity with the outside world.
Why can I not just add my entities together?
Because entities often trade with each other. Summing them double-counts intercompany sales, expenses, and balances. Consolidation eliminates those internal transactions, translates foreign currencies to one reporting currency, and accounts for partial ownership, none of which a simple sum handles.
How do I handle foreign-currency entities in consolidation?
Translate each foreign entity into the reporting currency using the appropriate rates - generally period-end rates for balance sheet items and average rates for income statement items - and record the translation adjustment. Doing this consistently every period is what keeps the consolidated equity accurate.
How long should a multi-entity close take?
It depends on entity count and automation, but running entity closes in parallel and consolidating once each is ready keeps total time close to the slowest single entity plus consolidation. Done manually in spreadsheets it often stretches much longer, because each entity is handled sequentially.
Stay in the loop
One practical finance briefing a week - new guides, checklists, and benchmarks.
Consolidate entities without the spreadsheet
Fintra rolls entities up with eliminations and FX handled. Free to start, no card required.
Talk to us