Reconciling foreign-currency card charges

A software subscription bills you $147.00. The receipt says $147.00. The card statement says €135.60. Both documents are correct, they describe the same purchase, and no amount-matching rule will ever put them together.

Foreign-currency charges are a small share of most card programmes and a large share of the reconciliation exceptions. The reason is structural, and once you see it the handling becomes straightforward.

One purchase, two amounts, three dates

A foreign charge produces two figures. The transaction amount is what the merchant billed in their currency — the number printed on the receipt. The billed amount is what the card issuer charged your account after conversion, in your account currency.

Between them sits the exchange rate the issuer applied, plus — depending on the card — a foreign transaction fee, which may be folded into the rate or shown as a separate line.

There are also three dates in play: when you bought, when the merchant submitted the charge, and when it settled. The conversion uses a rate from the processing date, not the purchase date. For a stable currency pair the difference is noise. Across a volatile week it is not, and it is why the same $100 subscription is €91.40 one month and €93.10 the next.

Why exact matching fails

Most matching logic compares merchant, date, and amount. On a domestic charge that works. On a foreign charge the amounts differ by the conversion, so a strict comparison rejects a pair that is obviously correct to any human looking at it.

Loosening the amount tolerance is the wrong fix. A tolerance wide enough to absorb currency conversion — several percent — is also wide enough to match the wrong transaction when a cardholder bought from the same merchant twice in a week. You trade a visible failure for an invisible one.

The right fix is to match on the currency the receipt is actually denominated in. If the statement carries the original amount and currency alongside the billed amount — Amex exports typically include this as foreign spend detail — matching a $147.00 receipt against the $147.00 transaction amount is exact again, and the conversion stops being a matching problem at all.

Which number goes in the ledger

The billed amount. Your accounts are kept in your functional currency, and the amount your card account was actually charged is the amount that leaves the business. The conversion has already happened; you are not re-translating it.

Keep the original amount and currency as supporting detail on the transaction. You will want them when someone asks why the same annual subscription cost a different figure this year, and when reconciling against a supplier statement denominated in their currency.

For VAT, foreign spend usually follows a different route entirely — reverse charge, an EU acquisition, or non-recoverable foreign VAT. A US supplier charging no VAT is not a zero-rated Dutch supply, and treating it as one produces a return that does not reconcile.

What to do about the fee

Foreign transaction fees are a real cost and worth seeing separately. Where the issuer itemises them, code them to bank charges rather than burying them in the expense category — otherwise the true cost of international spend is spread invisibly across every category you buy in.

Where the fee is folded into the exchange rate, it cannot be separated after the fact. In that case the comparison worth making is periodic rather than per-charge: the issuer’s effective rate against the mid-market rate for the same period, across your total foreign spend. That number is often the clearest argument for changing how the company pays international suppliers.

A workable routine

Capture the receipt in its original currency and do not convert it by hand — manual conversion introduces a third number that agrees with neither of the other two.

Match on the original amount where your data carries it, and on merchant plus date where it does not. Post the billed amount. Keep the original amount, currency, and rate attached to the transaction. Review the effective rate once a quarter rather than once a charge.

Rexa reads foreign spend detail from the card feed, so a receipt in dollars matches against the dollar figure while the euro amount is what flows to the ledger. The original amount, currency, and applied rate stay on the transaction for whoever asks later.

General information, not tax or accounting advice. Currency translation and VAT treatment of foreign purchases depend on your circumstances — confirm with your accountant.

American Express and Amex are trademarks of American Express Company. Rexa is not affiliated with, endorsed by, or in partnership with American Express.