What the calculator compares
The calculator answers one question: what does the same original amount convert to under two different rates, and how big is the gap? The inputs are the original amount and currency — what the employee actually spent, before any conversion — the settlement currency the comparison is expressed in, rate A with its policy moment, rate B with its policy moment, and the rounding precision applied before the difference is taken.
Rates are entered as units of settlement currency per one unit of the original currency. The moments are labelled, not hard-coded, so the same comparison works for transaction date versus reimbursement date, submission versus approval, or claim date versus a month-end reporting rate. The output shows the amount converted at rate A, the amount converted at rate B, and the difference — labelled from the paying entity's perspective.
The formula, in the open
Converted at A = original amount × rate A, rounded to the chosen precision.
Converted at B = original amount × rate B, rounded to the chosen precision.
FX difference = converted at B − converted at A.
A positive difference means the claim converts to more settlement currency at moment B than at moment A: if the company reimburses at B, it pays out more than the claim was worth at A. A negative difference means the opposite. Whether either constitutes an accounting gain or loss depends on your accounting treatment — the calculator reports the operational movement and leaves classification to your accountants.
Entering rates the right way around
This calculator expects rates quoted as settlement currency per one unit of the original currency — if the employee spent in currency X and you settle in currency Y, the rate is how many Y one X buys.
Published rates often come the other way, as base currency to foreign currency. If the rate you have is quoted in the opposite direction, invert it (divide 1 by the published rate) before entering it. A quick sanity check catches most mistakes: multiply your original amount by the rate you entered and ask whether the result is plausibly what the receipt is worth in your settlement currency. Consistency matters more than convention — both rates must be quoted in the same direction, from the same kind of source, or the difference measures your data rather than the market.
Rounding is part of the policy
On one claim, rounding to 2 versus 4 decimal places moves the result by fractions of a cent. Across hundreds of claims a month, rounding at a different step than your accounting system does produces a steady stream of one-cent reconciliation differences.
Round in the same place your books do: if the accounting system rounds each converted amount to 2 decimals before summing, the comparison should too. Round half away from zero unless your system documents otherwise, and write the convention down. Keep the rate at full published precision and round only converted amounts — rounding the rate itself compounds the error by the size of the amount.
Using the calculator to choose a policy moment
The more valuable use of the tool is prospective: before writing “expenses are converted at the rate on date X” into policy, test what each candidate moment would have done to real claims. Candidate moments differ in what they optimise for and what they cost.
Run a handful of representative claims through two candidate moments at historical rates, and the abstract policy debate becomes a concrete number. Most teams discover the difference is small in calm markets and material in volatile ones — the honest basis for choosing where to fix the rate.
| Policy moment | What it optimizes | The trade-off |
|---|---|---|
| Transaction date | Fidelity to what the spend was worth when it happened | A rate per receipt date — more lookups, more rates to document |
| Submission date | One rate per claim, fixed while the claim is still the employee’s | Small drift between spend and submission lands on the employee |
| Approval date | Rate matches the moment the company accepted the cost | Approval timing varies by queue, so identical claims can convert differently |
| Reimbursement date | Matches the cash that actually moves | The amount is unknown until payment, so nobody can predict what a claim settles for |
Documenting the rate source
A converted amount without a documented source is an assertion. Whatever moment your policy fixes, record where the rate came from, quoted in which direction, retrieved when.
The European Central Bank publishes euro foreign exchange reference rates, usually updated around 16:00 CET every working day except TARGET closing days, and states they are published for information purposes only. The U.S. IRS, for translating foreign currency into U.S. dollars for tax purposes, instructs taxpayers to use the exchange rate prevailing when the item is received, paid, or accrued. The practical rule: pick one source per currency pair, use it consistently, and store the rate and retrieval date with the claim.
Reading the result at volume
One claim's FX difference is arithmetic. A portfolio of them is information.
Consistently one-signed differences mean the gap between your two policy moments is long enough for rate drift to accumulate — shortening the submission-to-payment cycle shrinks the exposure more reliably than any rate policy. Differences concentrated in one currency usually mean one volatile corridor. Differences that never reconcile to the books usually mean the calculator and the accounting system round at different steps, or one side is using an inverted or stale rate.
Export the result as CSV to attach the comparison to a claim, a policy proposal, or a reconciliation ticket.
Worked example (illustrative only)
An employee spends 1,000.00 units of a foreign currency. At the transaction date the rate to the settlement currency is 0.9210; by the reimbursement date it is 0.9350. Converted at A: 921.00. Converted at B: 935.00. Difference: +14.00 in settlement currency — the company reimburses 14.00 more than the claim was worth on the day the money was spent.
About this guide
The calculation method is stated in full above, and every number in the result comes from user input — no rates are fetched. Source descriptions are limited to what the cited ECB and IRS pages verifiably state, each URL verified to resolve before citation.
Operational tool and guidance for finance teams. Not accounting, tax, or legal advice. Accounting treatment of exchange differences and the rates acceptable for tax translation depend on your jurisdiction and applicable standards — confirm with your accounting or tax adviser.