To reconcile multi currency payments, compare the invoice at the exchange rate you booked with the amount that actually reached your bank in your own currency. Split the difference into three parts: the movement in the exchange rate, the conversion spread or fee, and any bank charges. Book each part, and the receivable clears to zero.
Which exchange rates touch one foreign currency payment?
A foreign currency payment touches at least three exchange rates. The invoice rate is the one you used when you booked the sale. The settlement rate is the market rate on the day the money converts. The bank or provider rate is what you were actually given, which includes their margin. Each gap between them needs a home.
Take a business whose books are kept in US dollars, its home currency, that invoices a customer in euros. On the invoice date, the ledger records the receivable in dollars at that day's rate. Weeks later the customer pays in euros. Somewhere between the customer's bank and yours, the euros become dollars at a rate that is almost never the invoice rate.
- The invoice rate fixes the dollar value of the receivable in your books.
- The settlement-day market rate tells you what the euros were worth when they were paid. The difference from the invoice rate is a currency gain or loss.
- The applied conversion rate is what your bank, payment provider or the customer's bank used. The difference from the market rate is the cost of converting.
Which party converts matters. If the customer pays euros into a euro account you hold, no conversion happens yet, and you reconcile that account in euros. If the euros are converted on the way into a dollar account, the conversion cost lands on you, inside the rate.
Conversion fees hidden in the currency spread
A conversion fee is often not a separate line. Many banks and payment providers build it into the rate they apply, so the cost appears as a worse rate rather than a fee. To see it, compare the rate you got with a reference market rate for the same day and time.
The spread is the gap between the market rate and the applied rate, multiplied by the foreign amount. On a 10,000 euro payment, a rate 0.0058 dollars worse than the market costs 58 dollars. That number can be larger than the visible wire fee.
Whether to book the spread separately is a policy choice. Some businesses put the whole difference between invoice value and dollars received into one foreign exchange gain or loss account. Others split the spread into a conversion fee account so the cost of converting is visible and can be compared between providers. Splitting takes a reference rate for each payment; if you cannot get one reliably, one account with a clear policy is better than an inconsistent split.
Online sellers face this at scale, because each marketplace or processor converts sales on its own terms. The issues specific to that are in ecommerce reconciliation across channels.
Realized currency gain or loss at settlement, worked
A realized currency gain or loss is the difference between what a foreign currency receivable was booked at and what it was worth when it was paid. It is realized because the payment has happened. It belongs in the period of payment, in a gain or loss account, not in sales.
Here is a worked example. Every figure, including the exchange rates, is illustrative.
The invoice. On March 3 the business invoices a customer 10,000.00 euros. The rate used in the books that day is 1.0850 dollars per euro. Accounts receivable is recorded at 10,850.00 dollars.
The payment. On April 2 the customer pays 10,000.00 euros. The euros are converted into the business's dollar account. The bank statement shows a credit of 10,730.00 dollars.
Breaking down the 120.00 shortfall:
| Component | Calculation | Amount (USD) |
|---|---|---|
| Receivable at invoice rate | 10,000 × 1.0850 | 10,850.00 |
| Value at April 2 market rate | 10,000 × 1.0800 | 10,800.00 |
| Rate movement (realized loss) | 10,850.00 − 10,800.00 | 50.00 |
| Value at rate applied by the bank | 10,000 × 1.0742 | 10,742.00 |
| Conversion spread | 10,800.00 − 10,742.00 | 58.00 |
| Incoming wire fee | Per bank statement | 12.00 |
| Bank credit | 10,742.00 − 12.00 | 10,730.00 |
The entry:
| Account | Debit | Credit |
|---|---|---|
| Operating bank (USD) | 10,730.00 | |
| Realized foreign exchange loss | 50.00 | |
| Currency conversion fees | 58.00 | |
| Bank charges | 12.00 | |
| Accounts receivable | 10,850.00 |
The receivable for that invoice is now zero. If the business does not split out the spread, the 50.00 and 58.00 go together as a 108.00 realized loss.
Accounting software usually does part of this for you. Intuit's help article on home currency adjustments in QuickBooks Online describes adjustments on receivable and payable accounts as unrealized gains or losses, and those on bank accounts as realized gains or losses. When you record a payment at its actual rate, the software calculates the realized amount. It does not know about the spread unless you record it.
Tying a foreign currency receipt to the home currency bank line
On the bank reconciliation, a foreign currency receipt is matched at the amount the bank actually credited in the account's own currency. For a dollar account that is the dollar figure on the statement, never the invoice value and never the foreign amount. The gains, losses and fees explain why the receivable differs, not why the bank does.
This keeps the bank reconciliation simple. The statement shows 10,730.00. The ledger's bank account shows 10,730.00. They match. All of the currency work happens on the receivable side of the entry.
If the business holds an account in the foreign currency itself, reconcile that account in the foreign currency. A euro account statement shows euros, so match euro amounts. Converting the account to dollars for reporting is a separate step done after the euro reconciliation is complete.
When the payment arrives as part of a batch, for example a processor payout that combines sales in several currencies, ask the processor for a breakdown by original currency. A single dollar deposit with no detail cannot be split into rate movement and fees for each sale. In that case, book the total difference as one currency account and note the limitation in the file.
Unrealized currency revaluation is a separate month-end step
Unrealized currency revaluation restates open foreign currency balances, such as unpaid invoices or a euro bank account, at the month-end rate. Nothing has been paid, so the gain or loss is unrealized. It is a reporting adjustment and should not be confused with settling a payment.
The two steps answer different questions. Settlement asks what a paid invoice really brought in. Revaluation asks what an unpaid invoice or a foreign balance is worth today. A receivable can be revalued at the end of March and then settled in April. The April realized gain or loss is then measured against the revalued figure or the original figure depending on how your software and policy handle reversals, so check the method once and apply it every month.
For month-end, a short sequence works:
- Record every payment received in the month at its actual rate.
- Book conversion spreads and fees.
- Reconcile each bank account in its own currency.
- Revalue open foreign currency receivables, payables and foreign bank balances at the month-end rate.
- Review the realized and unrealized accounts separately.
Foreign currency bank accounts get a fuller treatment, with a worked revaluation, in the guide to reconciling a foreign currency bank account.
Foreign currency supplier payments and the purchase side
Foreign currency supplier payments work the same way in reverse. The bill is booked at the rate on the bill date, the payment leaves at the rate on the payment date, and the difference is a realized gain or loss. The conversion spread now costs you on the way out, raising the dollars spent.
Payables add one wrinkle. Before paying a foreign currency bill, the business should already have matched it to the purchase order and the receiving record. That match is done in the bill's currency, so a currency difference never looks like a price difference. The process is set out in three-way match for accounts payable.
A supplier who invoices in their own currency but whom you pay from a dollar account will show the amount leaving in dollars. Check the foreign amount the supplier received against the bill. If the supplier's bank took a fee and the supplier received less than the bill, they may ask you to cover the gap, and the bill stays open for that amount.
What goes wrong when payment exchange rates are typed by hand?
Exchange rates typed by hand go wrong in a few predictable ways: the rate is entered inverted, rounded too far, or taken from the wrong day. Each error flows straight into the realized gain or loss account, where it looks like a currency movement instead of a mistake.
How each error shows up:
- Inverted rate. Entering 0.9217 euros per dollar where the field expects dollars per euro turns a 10,000 euro receipt into about 9,217 dollars. The gain or loss account then takes a loss of about 1,633 dollars, some 15 percent of the receivable. Any large, odd-looking amount in that account is worth checking for this first.
- Over-rounding. Using 1.08 instead of 1.0742 on 10,000 euros misstates the receipt by 58 dollars. Small per payment, large over a year.
- Wrong date. Using the invoice date rate on the payment means no gain or loss is recorded, and the bank line will not match the ledger.
The control is simple: record the payment at the dollar amount the bank credited and let the rate be derived from it. The bank's figure is a fact; a typed rate is a copy of one.
For an auditor, the realized gain or loss account is a good place to look for these problems, by comparing each large entry with the bank statement and a reference rate. Wider testing of the cash side is in audit procedures for bank reconciliation. PreciseBankFlow helps with the bank half of the job: it checks that each statement foots and matches statement lines against your ledger, so a payment booked at the wrong dollar amount appears as an exception.