Operating worksheet and calculator

Payout Currency Reconciliation Calculator

AI-assisted editorial guide and tool · Published November 20, 2026

Use this calculator to reproduce a currency conversion already documented by a payment provider or to check an explicitly labeled assumption. It does not supply an exchange rate or recommend when to exchange money. Enter the rate as destination-currency units for one source-currency unit. All fees and the bank receipt must be expressed in the destination currency.

Enter your assumptions

The starting values are a hypothetical worked example, not your property data. Calculations run in your browser; entries are not submitted or saved after a reload. Use one consistent currency where money is involved.

Reconciliation only. The rate is user-entered; displayed rounding may differ from a provider or currency’s minor-unit rules.

Name both currencies in your records

Record the source and destination currency codes beside the saved calculation. A number alone does not identify whether the rate should be multiplied or divided. This calculator always multiplies the source amount by destination units per source unit. Convert an inverse quote before entering it, using the provider’s documented rate rather than a guessed current rate.

Trace the actual conversion

Identify which institution performed the conversion and which fees appear separately. A platform, intermediary and receiving bank can each have a different role. Enter only fees expressed in the destination currency. If a fee was deducted from the source amount first, either use the net source amount with an explanation or reconcile that fee separately; do not deduct it twice.

Worked example

A source payout of 1,000 multiplied by a rate of 1.10 produces 1,100 destination units. Subtracting five destination units of fees gives an expected bank amount of 1,095. A bank receipt of 1,095 leaves zero difference. These are illustrative numbers, not an available exchange quote or a forecast of future conversion costs.

Handle refunds and rounding

A negative source amount can represent a refund or reversal and produces a negative converted amount at a positive rate. The rate itself must be greater than zero. Results display two decimal places while calculations retain precision internally. Some currencies and providers use different minor-unit conventions; reconcile the provider’s actual rounding rather than assuming every currency uses two decimal places.

Investigate an unexplained difference

Check value dates, fee currency, rate direction and whether several transfers were combined in one bank entry. Keep the original provider and bank records with any explanation. A remaining difference is not by itself proof of an error or unauthorized charge. Refer accounting or tax conversion-method questions to the responsible adviser; this tool only applies the entered arithmetic.

Grab A Time To Speak To See If We Can Help!

Step 1 of 2: Enter your contact details. Next, choose a time for your call.

Having trouble? Use our on-site scheduling page.