Platform · financial core

Consolidation computed, not assembled

The reliable indicator that a consolidation is being assembled rather than computed is the intercompany plug — the journal that makes the elimination balance because the two sides never matched. It only ever grows, and removing it means identifying intercompany at posting rather than reconciling it monthly.

Their QuickBooksas filed
1000 · Cash412,880.14
1200 · Accounts receivable286,401.00
2010 · Accounts payable(94,220.55)
4000 · Revenue(1,842,110.00)
6000 · Operating expense1,237,049.41
Trial balance0.00
erp.io shadow ledgercomputed
1000 · Cash412,880.14
1200 · Accounts receivable286,401.00
2010 · Accounts payable(94,220.55)
4000 · Revenue(1,842,110.00)
6000 · Operating expense1,237,049.41
Trial balance0.00

184 consecutive days tied · variance $0.00

Elimination on a rule, not a journalUnmatched intercompany gates the closeDrill from consolidated to transaction

What it does

Six things, specifically.

Entity as a first-class dimension

Not a separate company file. Every transaction carries its entity, so per-entity and consolidated views are the same query with a different scope.

Intercompany identified at posting

Marked as intercompany when it is created, with its counterparty entity, rather than inferred at consolidation from account codes and hope.

Elimination on a rule

Matched pairs eliminate automatically. Unmatched intercompany becomes a gated exception before consolidation rather than a plug afterwards.

Currency translation

Functional and reporting currency handled distinctly, with cumulative translation adjustment posting to equity rather than being absorbed somewhere convenient.

Partial ownership

Minority interest and proportional consolidation, with equity-method investments carried as a single line rather than a full roll-up.

Drill-through

From a consolidated line to the contributing entity to the transaction. A consolidated figure that cannot be traced is a number a board will not trust twice.

Why the plug appears

In most mid-market groups intercompany activity is recorded informally — a management fee posted in the parent, a recharge entered in the subsidiary next month at a slightly different amount, a cost shared without anyone recording the other side. At consolidation the two sides do not net, and the difference gets plugged.

That is not carelessness; it is what happens when intercompany is a category you recognise afterwards rather than a property recorded at the time. The fix is structural: mark it when it is posted, with its counterparty, so the matching is arithmetic rather than archaeology.

The intercompany plug is the most reliable sign a consolidation is being assembled rather than computed. Nobody plans it and it never shrinks.

One chart, or a mapped chart — but decide

The highest-value decision in a multi-entity implementation is whether entities share a chart of accounts or keep their own with a mapping. Both work. The failure mode is not choosing, because charts then drift apart and mapping happens ad hoc at consolidation, so no two months are comparable.

For most groups we recommend a shared chart with entity as a dimension, and local statutory differences handled by mapping at the reporting layer. More work in month one, and it removes a recurring reconciliation permanently.

Closing entities at different speeds

Entities close on their own schedule with their own checklists, rolling into a consolidated close where intercompany elimination is a gated task. The group view is not produced until elimination passes, and what is blocking it is visible rather than being something the group controller has to go and find out.

Limits

Where this does not help.

Deep local statutory filing

We handle multi-currency and multi-entity structure. Statutory filing requirements across many jurisdictions is two decades of accumulated work we have not done, and it points to NetSuite.

Above roughly 25 entities

Comfortable below that. Larger groups, particularly with many jurisdictions, are better served elsewhere and we will say so at the assessment.

It cannot fix undocumented history

Prior-period intercompany that was never recorded on both sides cannot be retrospectively matched with integrity. We can establish a clean starting point and will label what is derived.

Questions

What people ask.

How many entities does it handle?
Up to around twenty-five comfortably. Beyond that, especially with many statutory jurisdictions, NetSuite is the more sensible answer.
Do entities need the same chart of accounts?
No, but decide deliberately. We recommend a shared chart with entity as a dimension for most groups, with statutory differences mapped at reporting.
What happens to unmatched intercompany?
It gates the consolidation. The period does not roll up until it is resolved or explicitly waived by a named person, and the waiver is logged.
Can entities have different functional currencies?
Yes, with translation to a reporting currency and cumulative translation adjustment posted to equity rather than absorbed into a catch-all.
Does it handle joint ventures?
Yes — proportional consolidation and equity method, plus partner allocations. This is a common requirement for construction and property groups.

Stop plugging the elimination.

Send your entity list and current process, and we will show you what computed consolidation looks like.