Foreign currency bank accounts fail to reconcile for one main reason: people try to reconcile them in the wrong currency.
Reconcile a foreign currency bank account in the account's own currency first, exactly as you would a home currency account: statement balance plus or minus timing items equals the ledger balance in that currency. Only then deal with translation, revaluing the closing balance at the period-end rate and posting the exchange difference. Never let exchange differences sit inside the reconciliation itself.
A euro account should be reconciled in euros, a dollar account in dollars. The bank statement is in that currency, and the ledger should record every transaction in that currency as well as in your home (functional) currency. If you reconcile the home currency amounts, every rate difference shows up as an unexplained item and the reconciliation never closes cleanly.
Check that your ledger holds the bank account in its own currency. Most accounting systems support this; spreadsheets need a currency amount column as well as a home currency column.
Follow the normal bank reconciliation steps using currency amounts only:
Statement closing balance (currency)
+ Deposits in transit
− Unpresented payments
+/− Other timing items
= Ledger balance (currency)
Match transactions on currency amount and date. Common reconciling items are the same as in any account. See bank reconciliation reconciling items.
A foreign currency bank balance is a monetary item, so under most frameworks it is translated at the closing rate at the period end. Calculate:
Revalued home balance = currency balance × closing rate
Exchange difference = revalued home balance − current home balance in the ledger
In Excel, with the currency balance in B2, the closing rate (home currency per one unit of foreign currency) in B3 and the ledger home balance in B4:
=ROUND(B2*B3,2)-B4
A positive result is a gain to post, a negative one a loss. Check the rate direction before posting: a rate quoted the other way round (foreign currency per one unit of home currency) means dividing, not multiplying.
Post the difference to an exchange gains and losses account, not to the bank reconciliation. Use a documented rate source and keep a copy of the rate used.
After revaluation, the ledger home currency balance should equal the currency balance at the closing rate. A quick test:
=ROUND(B2*B3-B5,2)
where B5 is the ledger home balance after the revaluation journal. It should return zero.
When money moves from a home currency account to a foreign currency account, two amounts matter: what left one account and what arrived in the other. Record each side in its own currency. The difference between the rate you booked and the rate the bank applied is a realised exchange difference, posted when the transfer happens. Use a transfer clearing account if the two sides post on different days, and check it clears. See clearing account reconciliation.
International payments often arrive short because intermediary banks deduct fees. Record the receipt at the full invoice amount against the customer, and the shortfall as a bank charge, so the customer account clears and the cost is visible. If shortfalls are frequent, agree payment terms that make the payer cover the fees.
Receipts and payments against foreign currency invoices give rise to realised gains and losses when the rate at payment differs from the rate at invoice. Open receivables and payables in foreign currency are revalued at the period end in the same way as the bank balance. Keep these separate from the bank revaluation in your exchange account analysis so you can see where the movements come from.
Foreign currency translation follows your accounting framework, such as IAS 21 under IFRS, Section 30 of FRS 102 in the UK, or ASC 830 under US GAAP. Check the current standard for how exchange differences should be presented and which rates to use.
AI software that matches your bank statement to your ledger on your own computer and builds the reconciliation statement. $1,997 once-off; see it on the built-in example first.
The Bank Reconciliation Template reconciles up to five bank accounts across eight transaction categories, with an allocation check that confirms every transaction is coded before the reconciliation counts as clean. Excel, no macros, one-time price.
No. Reconcile it in the account's own currency, then revalue the balance at the closing rate and post the exchange difference separately.
Use a consistent, documented source, such as your bank's published rate or a central bank reference rate, and keep a record of the rate used each period.
Usually because the period-end revaluation journal hasn't been posted, or was calculated with the rate inverted.
Last updated 04 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.