Almost every multi-entity consolidation hits the same wall: the intercompany accounts do not tie. Entity A shows a $48,200 receivable from Entity B; Entity B shows a $46,900 payable to Entity A. On paper the two should be equal and opposite. They almost never are. Before you can eliminate the balance cleanly, you have to understand why it differs — and resist the urge to plug it.

The usual suspects

Timing differences

The most common cause. Entity A books an intercompany invoice on the last day of the month; Entity B does not record it until it arrives a few days later, in the next period. At period end, one side is recorded and the other is not. The balance is not wrong — it is just not yet recorded on both sides. Timing differences resolve themselves over time, but you need to identify them so you do not chase a "discrepancy" that is really a cut-off item.

Foreign exchange

If entities operate in different currencies, an intercompany balance is recorded in each entity's functional currency and translated for consolidation. Different transaction dates, different rates, and rounding mean the two translated balances will rarely match exactly. The FX difference is real and belongs somewhere specific — not netted silently into zero.

Missing or one-sided entries

Sometimes one entity simply never recorded its half. A management fee was billed but the receiving entity never accrued the expense; a cash transfer was recorded by the sender but not the receiver. These are genuine errors that need a correcting entry, not a plug. They are also the reason automatic netting is dangerous: it would erase the evidence that an entry is missing.

Coding and account differences

One entity records an intercompany charge to "Management fees," the other codes it to "Professional services." Or a balance with a party outside the consolidation group is sitting in an account named "Intercompany." Misclassified items make the two sides look like they disagree when the underlying economics actually match — or worse, make unrelated balances look intercompany when they are not.

Markups and unrealized profit

When one entity sells to another at a markup, the receivable and payable for the cash side may tie, but the inventory still carries profit the group has not earned externally. That is not a reconciliation error — it is unrealized profit that needs its own elimination. Confusing the two leads people to "fix" a balance that was never broken.

A practical reconciliation workflow

You do not need a heroic month-end fire drill. You need a repeatable routine:

List every intercompany account, both sides. Pull each entity's intercompany receivables, payables, revenue, and expense, and pair them by counterparty. You cannot reconcile what you have not laid side by side.
Compute the gap per pair. For each counterparty pair, show both balances and the difference. A pair that ties to zero needs no further work.
Categorize each difference. Tag every gap as timing, FX, missing entry, coding, or markup. Categorization tells you who needs to do what.
Fix at the source where you can. Missing and miscoded entries should be corrected in the originating entity's books, not patched in the worksheet, so the fix carries into future periods.
Document what remains. Timing and FX differences that are legitimately open at period end should be noted with an explanation, so the residual is understood rather than mysterious.
Then, and only then, eliminate. Once each difference is explained, confirm the elimination with its rationale attached. The eliminated balance now reflects a decision you can defend.

Where ConsoliView helps

ConsoliView pulls each entity's books from QuickBooks Online read-only and lays the two sides of every intercompany relationship next to each other, with the difference computed for you. When a pair does not tie, ConsoliView flags the gap instead of forcing it to zero, so timing, FX, missing-entry, and coding issues surface where you can act on them. You decide how to resolve each one, confirm the elimination, and ConsoliView records the decision — giving you a reconciliation trail that survives scrutiny and a consolidation that actually ties.

ConsoliView is a consolidation preparation aid — not an audit, not a GAAP-conformity opinion or guarantee, and not a substitute for a CPA or auditor. You review and confirm every elimination and resolve every reconciling difference using your own professional judgment.