Skip to content

Daily ECB midpointFrankfurter / ECBFree to use

CurrencyCentral

SMB FX Playbook

Fixing Multi-Currency Invoice Reconciliation

7 min read · Updated September 2026

Multi-currency invoices drift because you record the sale or the bill on one date and the cash moves on another. The foreign amount can match exactly while the home-currency totals do not.

That gap is an exchange difference, a fee, or both. If you bury it in revenue or in cost, the margin report lies. The fix is a repeatable match in the invoice currency, then a separate line for the rate change. CurrencyCentral does not keep your ledger and does not issue the invoices.

Key takeaways

  • Book the invoice at the rate on the day you recognize it. Book the cash at the rate on the day it moves.
  • Reconcile the foreign amount first. The home-currency plug is the second step.
  • A short payment in foreign currency is a fee or a dispute. It is not an exchange loss.
  • Revalue unpaid foreign invoices at month-end so old rates do not pile into a later month.
  • Keep the rate, the date, and the amount received on the invoice file.

Why do the books drift even when the client paid in full?

You measured two different things with one invoice number. On the invoice date you recorded a home-currency value for a foreign amount. On the payment date the bank, the card, or the client converted at another rate. The foreign currency can be fully paid. The home-currency receivable or payable still will not clear to the cent.

The drift grows with time and with the size of the invoice. A large bill on long terms can move enough to change the month. Each partial payment needs its own rate. If you wait for the last cent, the final FX figure mixes several settlements.

Billing in the client's currency creates this receivable on purpose. The commercial reasons sit in how to invoice international clients in their currency. Reconciliation is how you live with that choice after the invoice goes out.

What rate belongs on the invoice date?

Use the spot rate on the day you recognize the revenue or the expense. That rate sets the opening receivable or payable in home currency. Write the rate and the date on the invoice record. "About the same as last time" is not a rate.

Accountants commonly follow ASC 830 under US GAAP and IAS 21 under IFRS. Both measure a foreign-currency transaction at the spot rate on the transaction date. Your accountant chooses the framework and the rate source. This page is the operating habit, not a technical memo.

Use one source for booking rates. If operations uses a reference print and the bank feed uses the bank's rate, the two will differ even on day one. Pick the booking source in writing. Record the bank's actual rate later, when cash moves.

If you show the client a home-currency figure, label it as a note. The amount due is the foreign amount. A second number that looks official creates a dispute and a second balance.

What should happen on the payment date?

Match cash to the invoice in the foreign currency first. If the invoice was 8,000 euros and 8,000 euros arrived, the foreign receivable is clear. Do that match before you look at home currency.

Record the cash at the rate the money actually converted. If the cash arrived in foreign currency and you have not converted yet, use the rate your policy names for that day. The gap between the booked invoice and the home-currency cash is the realized exchange gain or loss.

Put that gap in its own account. Leave revenue and leave the cost of a purchase at the invoice-date amounts. The later rate move is not a change in the price you charged or the price you were billed.

If you convert days after the cash arrives, you have two events. The receipt into the foreign balance is one. The later conversion is the other. Split them or the gain and loss will not tie to the bank lines.

Why does month-end move when nobody paid?

Open foreign invoices are still exposed. Under the same accounting frameworks, unpaid foreign receivables and payables are remeasured using the rate at the balance-sheet date. The change since the last booked rate is an unrealized gain or loss. It hits earnings before the cash arrives.

If you skip that revaluation, the balance sheet keeps a stale rate. The month the client pays then absorbs every move since the invoice date. Earlier months look calmer than they were.

Mark unrealized and realized apart. When cash arrives, clear the unrealized amount and record the realized difference against the cash. A single FX bucket cannot show open risk and finished risk at the same time.

Revalue monetary items, meaning amounts you will receive or pay in foreign currency. An invoice you have not issued is not a receivable yet. Ask the accountant when a line feels unclear. Guessing creates a second drift.

How do fees and short pays fit the same match?

A correspondent bank can deduct a charge, so the foreign amount received is less than the invoice. Book that shortfall as a fee or a collection difference. Do not call it an exchange loss. If you need the fee in home currency, convert it at the settlement rate.

Credit notes follow the invoice currency. Apply the credit in foreign currency, then update the home-currency balance at the credit date. Netting a home-currency credit against a foreign invoice with no rate hides both the discount and the FX.

Card deposits need the remittance advice. Gross sales, refunds, fees, and the conversion can sit inside one payout. Booking only the home-currency deposit will never clear the open invoices.

What habit keeps the file clean?

Give each currency an open-item list. Show the invoice number, the foreign amount still open, the booking rate, and the due date. A paid row adds the foreign amount received, the settlement rate and date, any fee, and the home-currency gain or loss.

Reconcile that list to the foreign balance. The account and the open invoices should explain each other. A difference is timing, a fee, or a booking error. Find which one before you post a plug.

Weekly is enough for a modest volume. Month-end is late to discover a missing remittance. One person owns the FX account. A second person looks when the gain or loss is large for your invoices. Write that threshold next to your payment approvals.

When you price the next bill in the client's currency, keep the rate record you will need later. Reconciliation fails if a courtesy home-currency note is posted as a second amount due.

Where is the invoicing guide?

Read how to invoice international clients in their currency before you choose the currency on the bill. That choice creates the foreign receivable this page then reconciles. CurrencyCentral does not clear invoices or post the exchange difference for you.

When many contractor invoices clear against one debit, see Batch Payments: Paying Multiple Overseas Contractors Fast.

Frequently asked questions

Should the exchange gain or loss change sales?

No. Keep the sale at the invoice-date measurement. Put the later rate change in an exchange gain or loss account. Your margin then stays comparable from month to month.

What if we only track home currency in the accounting file?

You cannot prove the client paid the foreign invoice. Store the foreign amount even if the ledger entry is in home currency. A side list is fine if the software cannot hold both.

Is a revaluation the same as a hedge?

No. A revaluation updates the books to a current rate. It does not set the cash you will receive. You still match the invoice to the money that arrived.

Who picks ASC 830 or IAS 21?

Your accountant, from the framework you already report under. Either way, date the rate at booking, date the rate at cash, and keep fees out of the FX line.

Does CurrencyCentral reconcile multi-currency invoices?

No. CurrencyCentral publishes guides on invoicing and FX for small firms. It does not act as your ledger, your payment processor, or your accountant.