Common Mistakes in Financial Consolidation

Consolidation errors are particularly problematic because many of them don’t produce an obvious signal. A balance sheet that balances, a P&L that adds up, a cash flow that reconciles — none of these confirm the underlying numbers are correct. The most consequential consolidation mistakes are the ones that produce plausible-looking results while the figures inside are wrong.

These are the consolidation-specific mistakes that appear most often in practice — distinct from general reporting errors, and specific to the multi-entity close process.

Running Eliminations on Unreconciled Intercompany Balances

Intercompany eliminations can only be correct if both sides of each transaction agree before the elimination runs. When Sub A records a $50,000 receivable from Sub B and Sub B records a $48,000 payable to Sub A, the elimination produces a $2,000 residual — a balance that appears on the consolidated balance sheet with no external counterpart. It isn’t eliminated because there’s nothing to match it against.

This is the most common source of small, unexplained balances in consolidated statements — the kind that accumulate quietly across periods until the total becomes material enough that someone has to spend a week tracing them back.

Common causes of the mismatchOne entity records the transaction in a different period. FX timing differences produce slightly different amounts when each entity translates at its own spot rate. One entity nets a charge differently. A transaction is recorded in the wrong entity entirely.

✅ How to avoid it: Require all entities to submit an intercompany schedule alongside their trial balance — listing every intercompany balance by counterparty. Run a matching report before eliminations are posted. Any unmatched balance is a blocker, not a footnote. Agree a single set of exchange rates for intercompany transactions before period start to eliminate rate-driven mismatches.

Applying the Wrong Exchange Rate to the Wrong Line Items

IAS 21 requires different rates for different items: assets and liabilities at the closing rate, income and expenses at the average rate for the period, opening equity at historical rates. Using a single rate across all items — or applying the closing rate to P&L items — produces a translation that balances only by generating a CTA of the wrong size, absorbed into equity without scrutiny.

🚩 The specific error that’s hardest to spot: Using the closing rate for both balance sheet and P&L. The consolidated statements still balance — the CTA absorbs the difference. But the translated P&L figure is wrong, and the CTA is the wrong amount. The error sits inside a number (CTA) that most reviewers don’t interrogate closely.

A second, more operational error: not locking exchange rates at the start of the period. If different entities pull rates on different days — or one entity uses a bank rate while another uses a central bank rate — intercompany balances that should match exactly in the group presentation currency will differ, producing the unmatched intercompany balance described above.

✅ How to avoid it: Publish a group rate table at the start of each period — closing rate and average rate for each currency pair — and require all entities to use these rates. Apply IAS 21 rate types by line item category, not uniformly. Reconcile the CTA movement each period: opening CTA plus current period translation difference should equal closing CTA. Any unexplained variance in this reconciliation points to a rate error.

Unmaintained Chart of Accounts Mapping

Every entity has its own chart of accounts in its accounting software. The consolidation maps each entity’s accounts to a common group structure — the group COA — so that like items aggregate correctly. This mapping is set up once and then maintained over time as entities add, retire, or reclassify accounts.

In practice, maintenance is where the mapping breaks. An entity adds a new expense account mid-year. No one updates the group mapping. The new account either flows into an incorrect group line, lands in a catch-all “other” bucket, or — worst case — doesn’t flow through at all. In each scenario, the group figures for the affected period are wrong by an amount that may not be obvious from the consolidated P&L.

ExampleSub C adds account 6150 “Cloud Infrastructure” mid-year, previously bundled under 6100 “IT Costs.” The group mapping for 6150 is never created. The $40,000 of cloud costs posted to 6150 for the remainder of the year don’t appear in the consolidated P&L. Operating expenses are understated by $40,000. The balance sheet still balances — the $40,000 sits as an unexplained retained earnings difference.

✅ How to avoid it: Require entities to notify the group finance team before adding any new account code, not after. Run an unmapped account report as part of the close checklist — any trial balance account with no group mapping is flagged before consolidation runs. Review the catch-all “other” lines each period for unexpected balances that signal a mapping gap.

Forgetting the Ongoing Depreciation Adjustment After an Asset Transfer

When one entity sells a fixed asset to another at a profit, the gain is eliminated in the period of transfer — this entry is well understood and usually correctly applied. What’s commonly missed is the annual depreciation adjustment that must follow in every subsequent period until the asset is fully depreciated or sold externally.

After the transfer, the buying entity depreciates the asset at its purchase price (which includes the intercompany profit). The group’s cost basis is lower — the original net book value in the selling entity. Each year, the buying entity’s depreciation charge overstates group depreciation by the profit spread over the remaining useful life. This excess must be reversed at every consolidation close.

🚩 Why it’s commonly missed: The original gain elimination is posted in year one and documented. The depreciation reversal required in years two, three, and four is a carry-forward adjustment with no trigger in the current period — it only exists because something happened in a prior period. When the person who did the original entry leaves, the institutional knowledge of the ongoing adjustment often goes with them.

✅ How to avoid it: Maintain a fixed asset transfer register — a schedule of all intercompany asset transfers, the original gain eliminated, the remaining useful life, and the annual depreciation reversal required. This register is reviewed at every consolidation close and the reversal entries are posted from it. The register should be part of the consolidation working papers, not one person’s memory.

Eliminating 100% of Intercompany Profit in a Partially-Owned Subsidiary

Where a subsidiary is partially owned — say 75% by the parent and 25% by minority shareholders — intercompany profit eliminations should be partial, not full. The group eliminates its 75% share of any unrealised profit. The NCI’s 25% share remains in the consolidated accounts, because from the minority shareholders’ perspective, the transaction was real.

Eliminating 100% of the intercompany profit in a partially-owned subsidiary overstates the elimination and understates the NCI’s equity. The consolidated figures balance — the error is absorbed across the NCI equity line and retained earnings — but the NCI balance is wrong, and so is the reported profit attributable to the parent.

✅ How to avoid it: When posting unrealised profit eliminations for transactions involving partially-owned subsidiaries, apply the parent’s ownership percentage — not 100%. Document each elimination with the applicable ownership percentage so the calculation can be reviewed independently. Where ownership percentages have changed during the period (due to an acquisition or disposal), use the weighted average percentage for the period, not the year-end figure.

Carrying Goodwill Without Annual Impairment Testing

Goodwill arising on acquisition is recognised on the consolidated balance sheet and remains there until it is impaired or the subsidiary is disposed of. Under IFRS, goodwill must be tested for impairment at least annually — and more frequently where there are indicators that its carrying value may not be recoverable.

In practice, the impairment test is often performed diligently in the year of acquisition — because the auditors focus on it — and then carried forward with minimal reassessment in subsequent years. If the subsidiary’s performance has deteriorated, or the market assumptions underpinning the original valuation have changed materially, the goodwill may be overstated. Carrying impaired goodwill overstates group assets and understates losses.

Indicators that impairment testing needs more than a tick-boxSubsidiary revenue declining for two or more consecutive periods. Market conditions in the subsidiary’s sector have deteriorated significantly. The original acquisition business case assumptions are no longer being met. The subsidiary’s management has revised its long-term forecasts materially downward.

✅ How to avoid it: Build the goodwill impairment test into the annual consolidation close as a required workpaper — not a discretionary item triggered by auditor request. For each cash-generating unit (CGU) carrying goodwill, compare the recoverable amount (higher of value-in-use and fair value less costs of disposal) to the carrying amount. Document the assumptions and sense-check them against current trading. Where indicators of impairment exist, engage an independent valuer if internal estimates are not robust enough to defend.

Several of these mistakes — unreconciled intercompany balances, unmaintained COA mapping, forgotten carry-forward adjustments — are structurally harder to make in a dedicated consolidation platform than in a spreadsheet. BrizoConsol flags unmatched intercompany balances before eliminations run, maintains group COA mapping with unmapped account alerts, and holds the consolidation working papers in one place across periods. Learn more or see it in action →