Payment reconciliation

Free Foreign Currency Receipt Variance Calculator

Check a cross-currency receipt against an explicitly entered reference rate. Use a confirmed gross amount for the same invoice portion, not an unexplained net payout. The result does not identify an accounting gain, loss, fee or unpaid balance by itself.

Preparing your calculator with today’s date…

Calculation notes

How the result is calculated

Reference settlement equivalent = foreign amount × entered settlement-units-per-foreign-unit rate, rounded once to two decimal places. Signed difference = confirmed gross settlement receipt − reference equivalent. The rate must be positive and accepts up to six decimals; amounts accept two. Currency codes must differ. No live quote, spread, fee, tax conversion rule, realized gain/loss or payment-status decision is supplied.

Formulas and examples reviewed October 2, 2026. Illustrative figures; no tax or contractual determination.

A receipt below the entered reference equivalent

EUR 1,000 at an entered USD 1.10 per EUR gives USD 1,100 reference equivalent. A confirmed USD 1,080 gross receipt differs by USD −20. Inspect actual conversion and allocation evidence before assigning a cause.

Keep precision and direction explicit

EUR 100 at entered USD 1.234567 per EUR gives USD 123.46 after final rounding. A USD 123.46 gross receipt matches that reference, but evidence still has to establish the actual payment and invoice portion.

Questions about this calculation

Is the entered rate a live market rate?

No. Supply and retain the actual reference and direction. The tool does not retrieve rates or decide which rate your accounts must use.

Can I use a net processor payout?

Use a reconciled gross receipt for the same transaction or invoice portion. A net payout may include fees and other transactions and needs separate evidence.

How to use it

1

Enter the foreign invoice currency and the amount covered by this comparison.

2

Choose the settlement currency and enter settlement units per one foreign unit, up to six decimal places.

3

Enter the confirmed gross receipt and investigate its signed difference from the rounded reference equivalent.

Related workflows

Move from the quick answer into the rest of the invoice system.