Multi-Currency Bank Reconciliation: FX Gains, Losses, and Best Practice

Multi-currency bank reconciliation is a single-currency reconciliation with one extra step: at every match, you reconcile both the foreign-currency amount and the reporting-currency amount, and any difference goes to FX gain/loss. The process becomes hard at scale because exchange rates change between transaction date, settlement date, and reporting date — and because intercompany transfers cross currencies. Here's how to do it cleanly without distorting your financials.

The three rates you need to track

1. Transaction date rate — the rate when you originally booked the transaction in your reporting currency.
2. Settlement / clearance date rate — the rate when the bank actually settled the transaction (often 1–3 days later for wires, longer for international transfers).
3. Reporting date rate — the rate at month-end / period-end, used to revalue the foreign-currency cash balance for financial statements.

The difference between transaction-date and settlement-date rates produces a realised FX gain or loss. The difference between the prior period-end rate and the current period-end rate (on the still-held cash balance) produces an unrealised FX gain or loss.

The multi-currency reconciliation process

1. Reconcile in foreign currency first. Match every bank transaction in its native currency. The foreign-currency bank balance must equal the foreign-currency book balance — no FX involved at this stage.
2. Translate the reconciled balance to reporting currency at period-end rate. This is your foreign-currency cash position in your home currency for financial reporting.
3. Calculate FX gain/loss. Compare the translated balance to the sum of historical-rate translations in your books. The difference is the unrealised FX gain or loss for the period.
4. Post the FX adjustment journal. Debit / credit the foreign-currency cash account, offset to FX Gain (Loss) on the income statement.

Intercompany transfers: the trickiest part

When your US entity sends $10,000 to your UK subsidiary, the UK entity receives roughly £8,000 (depending on rate). Two reconciliations have to agree:

• US entity: bank shows -$10,000; books show -$10,000 to intercompany receivable.
• UK entity: bank shows +£8,000; books show +£8,000 to intercompany payable, translated to ~$10,000 less FX spread and wire fees.

The wire fee and FX spread (typically 1–3% of the amount) is a real cost — book it as Bank Fees / FX Spread expense on the sending entity. Don't let it sit unrecorded; it'll resurface as an unreconciled difference.

Common multi-currency reconciliation mistakes

1. Booking the foreign-currency transaction at your home-currency-equivalent rate from your accounting system instead of the bank's actual rate. Always use the bank's rate (printed on the statement or available in their portal).
2. Forgetting to revalue the cash balance at period-end. Your foreign-currency cash will drift out of sync with the home-currency reporting balance.
3. Treating wire fees as an FX loss. Wire fees are bank fees; FX gains/losses are pure rate movements. Book them separately.
4. Reconciling in the home currency. Always reconcile in the bank's native currency first, then translate.

Tooling: what handles multi-currency well

Xero and QuickBooks Online Advanced both handle multi-currency reasonably for single-entity businesses. NetSuite and Sage Intacct lead at the multi-entity level. For specialist multi-currency reconciliation across many accounts and entities, BankReconPro handles native-currency matching, period-end revaluation, and per-currency exception reports in one workspace.