Historical exchange rates: reproduce a conversion without inventing a payment

“The equipment cost £18,000” may be a conversion of a dollar invoice, a budget estimate or an actual sterling payment. Before checking the arithmetic, identify which statement the evidence is meant to support. A historical reference rate can reproduce a benchmark conversion. It cannot, by itself, show what a buyer paid.

Choose the rate that belongs to the claim

The European Central Bank’s reference-rate page offers euro-based rates and historical downloads. It normally updates on working days, excluding TARGET closing days. These are informational reference rates, and the ECB discourages their use for transaction purposes.

The European Commission’s InforEuro service instead supplies monthly accounting rates for its stated budget-related use. A monthly accounting rate and a daily reference rate answer different questions. Neither becomes the right choice merely because it makes a disputed amount match.

For a document that names a particular conversion rule, check that rule first. If the rule is missing, state your analytical assumption instead of presenting it as the author’s method. This article concerns evidence reconstruction, not the selection of a required tax or accounting treatment.

Let the units show which way to divide

The ECB table quotes currencies against the euro. Its exchange-rate overview also distinguishes these reference observations from rates at which actual transactions occurred. Copy both the value and its units; a number such as 1.20 without a base currency is incomplete evidence.

Fictional calculation: suppose an invented same-date reference table says EUR 1 equals USD 1.20 and GBP 0.90. A fictional invoice is USD 24,000. These figures teach the arithmetic; they are not historical ECB observations.

USD 24,000 × (EUR 1 / USD 1.20) × (GBP 0.90 / EUR 1)
= GBP 18,000

Implied reference cross-rate: GBP 0.75 per USD 1
Reverse check: GBP 18,000 × (USD 1.20 / GBP 0.90)
= USD 24,000

The dollars cancel at the first step and euros cancel at the second. That is a useful check on an easy spreadsheet mistake: multiplying USD 24,000 directly by 0.90 treats the dollar amount as though it were euros and gives an unsupported GBP 21,600.

Keep full available precision during the calculation and round the final reported amount according to your stated method. The reverse check helps catch direction errors; it does not validate the source rates or prove a payment.

Four dates can hide inside one conversion

Separate the invoice date, the rate’s observation date, any settlement date and your download date. A file retrieved today can contain a rate from years ago. Conversely, today’s value on a live converter is not evidence for an older invoice.

If your chosen series has no observation on the required day, preserve that gap. For an illustrative comparison you might explicitly use the previous available business-day rate, but label both dates and call this a convention you selected. If a contract or reporting rule specifies another method, your convenient substitute does not establish compliance with it.

For a cross-rate, use both component rates from the same observation date and compatible series. A Friday dollar rate divided into a Monday sterling rate creates a calculation, but it does not reproduce a same-day reference cross-rate. Do not quietly fill a missing currency or day with a value from a different converter.

Leave an audit trail beside the formula

Download and preserve the source table. On a working copy, record the currency codes, base currency, rate units, observation date, source series and retrieval timestamp. Keep any missing-date convention beside the derived result. The CSV import checks help keep dates, decimal separators and identifying columns from changing unnoticed during import.

Attach this short calculation note to the report’s evidence table:

Original amount and currency:
Claim: reference equivalent / accounting conversion / actual payment
Rate source, series and base currency:
Observation date(s), retrieval date and saved file:
Formula with units; rounding or missing-day convention:
Result and unresolved payment evidence:

For the fictional example, the finding is: “USD 24,000 converts to GBP 18,000 using the stated same-date reference inputs. The material reviewed does not establish the amount settled in sterling.” If the investigation instead concerns whether a government award amount represents cash received, the contract-amount guide addresses that separate question. Correct currency arithmetic cannot repair a misidentified amount field.