When intercompany balances will not eliminate at consolidation

A frequent failure in financial reporting is intercompany balances that do not match when the consolidated statements are built. One unit books a charge the other has not recorded, or records it differently, so eliminations leave a residue. It surfaces as an unexplained difference and is fixed at source.

How it starts

The trouble rarely begins in the consolidation team. It begins weeks earlier, in a business unit ledger.

A shared service centre bills a sister entity for IT support. The selling unit posts a receivable and revenue on the day the invoice goes out. The buying unit's payables team waits for an approved invoice before recording anything, and that approval sits in someone's inbox. At period close, one side of the transaction exists and the other does not.

Other versions are just as common. The two units use different exchange rates for the same cross-border charge. One side codes the entry to a trading partner field and the other leaves it blank. A management fee gets accrued by the parent but treated as a cost allocation by the subsidiary, so it lands in a different account family. A manual journal voucher corrects a balance in one ledger without anyone telling the counterparty.

None of these feel like errors to the person posting them. Each team follows its own rules correctly. The problem only exists when the two ledgers meet.

How it gets spotted

The first sign is usually a line in the consolidation workbook labelled something like "intercompany difference" or "unreconciled elimination". Eliminations are designed to net to nothing. When they do not, the leftover amount has to go somewhere, and it often gets parked in a suspense account or a plug.

Experienced reviewers notice it in other places too. Group revenue looks slightly higher than the sum of external sales. Consolidated cash flow shows movements between entities that should have cancelled out. The board pack and the statutory accounts disagree by an amount nobody can name.

Auditors find it when they try to trace consolidated figures back to general ledger balances and hit an adjustment that has no supporting entry in either unit's books. That is the most expensive way to discover it, because it arrives late and with questions attached.

The quieter signal is behavioural. If the consolidation team spends the final days before a filing emailing business unit accountants for explanations, the mismatch is structural. It is being cleared by hand each period and will return next time.

How it gets fixed

The short-term fix is a matching exercise. Pull the intercompany balances from each entity by trading partner, pair them, and chase every unmatched item to its origin. Agree which side is right. Post the correcting entry in the unit ledger, not as a top-side adjustment in consolidation, so the books stay traceable.

The lasting fix happens upstream. A few changes tend to hold:

• Agree a single cut-off rule for intercompany charges, so both sides recognise a transaction in the same period.
• Set one exchange rate source for intercompany settlement and use it on both sides.
• Make the trading partner field mandatory on any account that can carry intercompany activity.
• Run a counterparty confirmation before the hard close, so disagreements surface while there is still time to correct them locally.
• Give someone ownership of each intercompany relationship. Without an owner, the difference belongs to everyone and gets resolved by nobody.

Where volume is high, a netting and settlement routine between entities removes much of the open balance before it can drift. Some groups move to a model where the seller's entry automatically creates the buyer's mirror entry. That works well when ledgers sit on one platform and poorly when they do not.

Resist the temptation to raise the tolerance threshold for unmatched balances. It makes the workbook look clean while the underlying cause keeps running.

Questions to ask the people who run it

The documented close procedure and the real one often diverge most in this area. These questions tend to expose the gap:

• When a counterparty disputes a charge, who decides which side adjusts, and how is that recorded?
• Where does the unexplained difference go today if it cannot be cleared in time?
• Which intercompany charges are booked from an invoice and which from an accrual?
• Do both sides pull exchange rates from the same table, at the same moment?
• How many manual journals touch intercompany accounts after the units have closed?
• Is anyone checking that management consolidation and legal consolidation eliminate the same balances?
• What gets fixed in the spreadsheet that never makes it back into a ledger?

Listen for workarounds people describe as normal. A recurring plug that "always comes out about right" is the clearest marker that the root cause has never been addressed.

What to watch when changing the process

Redesigning the close calendar or moving entities onto a new ledger can make this failure worse before it gets better. Mapping changes shift which accounts count as intercompany, and old trading partner codes may not carry across. Test eliminations on historical data first, with business unit accountants in the room, before the new structure goes live for a real reporting period.

APQC's Process Classification Framework® (PCF) is an open standard developed by APQC, a nonprofit that promotes benchmarking and best practices worldwide. To download the full PCF or to view definitions and measures, please visit www.apqc.org/pcf.