Free calculator
Invoice FX reconciliation calculator
To reconcile a foreign-currency invoice, value it at the rate it was booked at, then split the gap between that figure and the amount that reached your account into the rate movement to the settlement date, the fees deducted and whatever is left unexplained. Enter the invoice, both rates, the fees and the amount received to see each part in your book currency.
The example invoice, fees and rates are illustrative, not market rates for those dates. Results are arithmetic from your entries, not accounting advice, and nothing on this page records or moves money.
Invoice and settlement
The figures filled in are an example, and its rates are round example rates rather than market rates for those dates. Replace them with your invoice, your books and your bank statement.
Fees deducted
List the charges you can see on the remittance advice or bank statement. A fee taken in USD came off before conversion; a fee in EUR came off after it. Leave out anything you are not sure of, so it shows up in the remainder instead.
Reconciliation in EUR
EUR 11,198.35 arrived against an invoice worth EUR 11,500.00 at the invoice-date rate, a difference of -EUR 301.65: -EUR 187.50 rate movement, -EUR 30.47 fees and -EUR 83.68 unexplained.
- Unexplained remainder-0.74% of the value at the settlement-date rate. EUR 83.68 less arrived than the settlement-date rate and the listed fees explain. A conversion margin below the settlement-date rate, a charge that is not listed, a short payment or a rate for a different date can each cause this.
- -EUR 83.68
- Difference from the invoice-date valueEUR 11,198.35 received against EUR 11,500.00 (-2.62%).
- -EUR 301.65
- Fees listedUSD 20.00 taken before conversion and EUR 12.50 after it, valued in EUR.
- EUR 30.47
| Step | EUR |
|---|---|
| Value at the invoice-date rateUSD 12,500.00 × 0.92 | EUR 11,500.00 |
| Rate movement to the settlement dateEUR 11,312.50 at 0.905 − EUR 11,500.00 at 0.92 | -EUR 187.50 |
| Intermediary bank feeUSD 20.00 taken before conversion, valued at the rate applied: 1 USD = about 0.898305 EUR | -EUR 17.97 |
| Receiving bank feeCharged in EUR after conversion | -EUR 12.50 |
| Unexplained remainderReceived − (value at the settlement-date rate − fees) | -EUR 83.68 |
| Amount received | EUR 11,198.35 |
Rates compared
The payment achieved 1 USD = 0.895868 EUR after all fees, against 1 USD = 0.92 EUR on the invoice date.
- Invoice-date rateAs entered, for Mon 14 Sep 2026.
- 1 USD = 0.92 EUR
- Settlement-date rateThe value of 1 USD in EUR changed by -1.63% over 29 days.
- 1 USD = 0.905 EUR
- Effective rate achievedAmount received ÷ invoice amount, after every fee.
- 1 USD = 0.895868 EUR
- Rate applied to the converted amount(Amount received + fees in EUR) ÷ (invoice amount − fees in USD), which assumes every fee is listed.
- 1 USD = about 0.898305 EUR
How the FX reconciliation is calculated
The calculator starts from what the invoice was worth in your book currency when it was booked and works down to what arrived. Every figure is in your book currency except the invoice amount and any fee charged in the invoice currency.
- Value at the invoice-date rate: E0 = A × r0
- Value at the settlement-date rate: E1 = A × r1
- Rate movement: M = E1 − E0
- Rate applied to the converted amount: x = (S + Fh) ÷ (A − Fi)
- Fees in your book currency: F = Fh + Fi × x
- Unexplained remainder: U = S − (E1 − F)
- Total difference: D = S − E0 = M − F + U
- Effective rate achieved: S ÷ A
A is the invoice amount, r0 the rate the invoice was booked at, r1 a reference rate for the settlement date and S the amount received. Fi is the fees taken in the invoice currency before conversion, such as an intermediary bank charge on a wire, and Fh the fees taken in your book currency afterwards. Rates are units of your book currency per unit of the invoice currency. If you quote them the other way round, the tool divides by the rate instead of multiplying.
A fee taken before conversion never reached the conversion, so it is valued at the rate the bank applied to the rest of the payment. With that valuation the remainder works out to A × (x − r1), the gap between the rate the payment got and the settlement-date reference rate, across the whole invoice. When every fee is listed, what is left is the conversion margin plus any short or over payment.
Without a settlement-date rate the rate movement cannot be separated from the rest, so the tool reports S − (E0 − F) as a single combined figure.
The arithmetic uses exact decimals and rounds only for display, to each currency's usual number of decimal places. The steps in the results table are rounded as a running balance so they add up exactly to the amount received, which can move a single step by one cent compared with rounding it on its own.
Worked example: a USD 12,500 invoice settled in EUR
Example only. The invoice, the fees and both rates are illustrative figures, not market rates for those dates. They are the tool's starting values, so the figures here match the tool until you change an input.
A business that keeps its books in EUR invoiced a client USD 12,500.00 on Mon 14 Sep 2026 and booked it at 1 USD = 0.92 EUR. The payment arrived on Tue 13 Oct 2026, 29 days later, as EUR 11,198.35. The payer's confirmation showed an intermediary bank fee of USD 20.00, and the bank statement a receiving bank fee of EUR 12.50. The reference rate for the settlement date was 1 USD = 0.905 EUR.
- Invoice-date value: USD 12,500.00 × 0.92 = EUR 11,500.00.
- Settlement-date value: USD 12,500.00 × 0.905 = EUR 11,312.50, so the rate movement is -EUR 187.50 (USD lost 1.63% of its EUR value over 29 days).
- Rate applied: (EUR 11,198.35 + EUR 12.50) ÷ (USD 12,500.00 − USD 20.00) = EUR 11,210.85 ÷ USD 12,480.00, which is 1 USD = about 0.898305 EUR.
- Fees: the USD 20.00 fee at that rate is EUR 17.97, and with the EUR 12.50 receiving fee the fees come to EUR 30.47.
- Remainder: EUR 11,198.35 − (EUR 11,312.50 − EUR 30.47) = EUR 11,198.35 − EUR 11,282.03 = -EUR 83.68. That is -0.74% of the settlement-date value, the same as the rate applied being 0.74% below the reference rate.
- Check: -EUR 187.50 rate movement, -EUR 30.47 fees and -EUR 83.68 remainder add up to -EUR 301.65, which is EUR 11,198.35 − EUR 11,500.00.
- Effective rate achieved: EUR 11,198.35 ÷ USD 12,500.00 gives 1 USD = 0.895868 EUR after every fee.
| Step | How it is worked out | EUR |
|---|---|---|
| Value at the invoice-date rate | USD 12,500.00 × 0.92 | EUR 11,500.00 |
| Rate movement to the settlement date | EUR 11,312.50 at 0.905 − EUR 11,500.00 at 0.92 | -EUR 187.50 |
| Intermediary bank fee | USD 20.00 taken before conversion, valued at the rate applied: 1 USD = about 0.898305 EUR | -EUR 17.97 |
| Receiving bank fee | Charged in EUR after conversion | -EUR 12.50 |
| Unexplained remainder | Received − (value at the settlement-date rate − fees) | -EUR 83.68 |
| Amount received | EUR 11,198.35 | |
Clear the settlement-date rate and the tool can no longer separate the two parts. It then shows the same EUR 30.47 in fees and -EUR 271.18 for the rate movement and everything else combined.
Where to look when the remainder is not zero
A remainder means the rate movement and the fees you listed do not explain the whole difference. These are the places to check.
- The conversion margin. Banks and payment providers convert at their own customer rate, which can include a margin over a mid-market reference rate. The rate applied in the results is the rate the payment actually got, so compare it with any rate your provider quoted.
- A charge you have not listed. On an international wire, intermediary banks can deduct charges along the way, and the statement may show only the net amount. The payer's payment confirmation or the remittance advice can show what was sent.
- A short payment, a partial payment or an overpayment. Compare the amount the client sent, in the invoice currency, with the invoice total.
- A rate for the wrong day or quoted the wrong way round. The day the money converted can differ from the day it was sent or the day it shows on the statement. A rate typed in the opposite direction to the one selected produces a large remainder.
- A fee entered twice, or one that belongs to a different payment.
Choices to make before you book the difference
- Which invoice-date rate to use. Use the rate the receivable was recorded at in your books, whether that came from your accounting software's daily rate, a monthly rate set by policy or the invoice itself. The reconciliation only matches your ledger if this figure does.
- Which settlement-date rate to use. A published reference rate, such as a central bank or mid-market rate, separates the market's movement from your provider's margin. If you enter your bank's own conversion rate instead, the remainder shrinks towards zero and the margin is counted as rate movement.
- Which way the rates are quoted. Pick the direction your source uses, for example EUR per 1 USD or USD per 1 EUR, and enter both rates in that direction.
- Which fees to list. List the charges you can evidence from a statement or confirmation. Anything you leave out stays visible in the remainder instead of being absorbed into the fees. The tool takes up to 10 fee lines.
- How small a remainder you will accept. Decide on a tolerance below which a remainder is treated as a bank or rounding difference, and who signs off anything larger.
- How to book it. Whether the rate movement and the remainder are recorded as a realized exchange gain or loss, whether bank charges go to their own expense account and how a short payment is followed up are decisions for your accountant. They depend on your accounting framework, your policies and possibly tax rules, and this page does not say what any accounting standard requires.
Assumptions and limitations
- The results are calculations from the figures you enter. They are not accounting, tax or audit advice, and they do not decide how anything is booked.
- One invoice and one payment. Several invoices paid together, several payments against one invoice and refunds are not modeled. For a partial payment, enter the part of the invoice that payment was meant to settle as the invoice amount.
- The payment is assumed to arrive in your book currency. If it lands in a foreign-currency account and is converted later, that conversion is a separate step to reconcile.
- Fees in the invoice currency are treated as taken before conversion and fees in your book currency as taken after it. The rate applied assumes every fee is listed, so an unlisted fee shows up as a lower rate and a larger remainder.
- The only rate this page can supply is Frankfurter's latest blended mid-market reference rate, rounded to six significant figures. Frankfurter dates a blended rate by its newest source, which can be the next day in UTC, so the tool offers the rate for an invoice or settlement date from the rate's date to the day it was fetched, as the latest rate published by then. There is no rate history here, so rates for other dates have to come from your books, your bank or a historical rate source. A reference rate is not a quote from Hanko or a bank.
- The example figures, including both starting rates, are illustrative and are not market rates for the dates shown.
- Listing a currency does not mean Hanko can invoice or receive payments in it. Invoices can be issued in USD, EUR, GBP, CAD, AUD, AED, SGD or INR.
- Amounts, dates and fee descriptions stay in your browser. They are not added to the page address or sent to analytics. With analytics consent, the page records that a reconciliation was produced and the two currency codes selected.
How Hanko records invoice payments
This calculator is separate from a Hanko workspace, and nothing you enter here is saved. In Hanko itself, invoice payments and records work like this.
- Hanko marks a stablecoin invoice payment as paid after its server confirms the transfer on the blockchain, not when the payer says it was sent.
- An invoice can show the business's own bank account details for a manual transfer; those payments are recorded in Hanko by marking the invoice paid.
- Hanko does not integrate with QuickBooks, Xero, NetSuite or SAP. Records can be exported as CSV.
- On Pro, invoices, payables, payouts and contacts export as CSV (up to 50,000 rows per type, with spreadsheet formulas neutralised). Invoices, proposals and agreements download as PDF, and CRM records export as CSV.
The payment reconciliation feature page describes which payments update an invoice on their own, and plan prices are on the pricing page.
Related tools, templates and guides
Tools
- Currency converter for business paymentsConvert an amount between currencies at a dated reference rate when planning an invoice or payment.
- International invoice fee estimatorEstimate processor fees, fixed charges and FX spread on an overseas invoice, and the amount left after them.
- USDC vs wire transfer calculatorCompare estimated card, wire and USDC costs for collecting a US dollar invoice using fees you enter, and find the invoice amount where the stablecoin route and a wire cost the same.
Guides
- Payment reconciliation for client invoicesStablecoin payments made from the invoice update its status. Transfers to bank details on the invoice are recorded by marking it paid.
- How to Reconcile Crypto Payments in Your BooksA practical, step-by-step guide to matching on-chain payments to invoices without spreadsheets and screenshots.
Keep each invoice and its payment in one record
Sign up or sign in to issue invoices in Hanko and record payments against them (a new account sets up its workspace first). Invoices can be issued in USD, EUR, GBP, CAD, AUD, AED, SGD or INR. Hanko does not integrate with QuickBooks, Xero, NetSuite or SAP. Records can be exported as CSV. The figures from this reconciliation are not carried over.