Managing multi-currency consolidation across entities

Most finance teams don't notice multi-currency consolidation is broken until close week — when the group P&L doesn't tie out, and someone spends two days tracing the gap back to a single subsidiary's exchange rate.

Where spreadsheet consolidation breaks down

A spreadsheet model can hold up for a year or two after your first international subsidiary. It stops working once you have more than a handful of entities, more than one reporting currency, or any regularity to intercompany transactions. At that point, three problems show up consistently:

Inconsistent revaluation timing. If one subsidiary revalues monthly and another quarterly, the group number is comparing figures from different points in the FX cycle — and nobody notices until the variance shows up in board reporting.

Manual intercompany elimination. Eliminating intercompany balances by hand across multiple currencies means someone is manually converting, matching, and clearing entries every close — a process that scales in effort exactly as fast as your entity count.

No single source of truth for rates. Different teams pulling exchange rates from different places (a bank feed here, an internal rate there) means your consolidated numbers are only as consistent as everyone's spreadsheet discipline.

What an ERP-native approach gets right

One rate table, applied consistently. Exchange rates are set once at the group level and applied uniformly across every subsidiary, every period — removing the "whose rate is correct" argument entirely.

Automated revaluation and elimination. Currency revaluation and intercompany elimination run as a scheduled process, not a manual reconciliation exercise, so the group P&L reflects the same accounting period consistently across entities.

Drill-down from group to entity. When a number looks off, you can trace it back to the originating transaction and entity in a few clicks, instead of reopening five different subsidiary workbooks.

Getting there without a disruptive rebuild

You don't need to migrate everything at once. Most groups start by consolidating the entities causing the most pain — usually the ones with the highest transaction volume or the most currency exposure — and expand from there. The goal isn't a perfect system on day one; it's a close that gets measurably faster and more reliable with each cycle.