Historical Exchange Rate Converter
A foreign receipt has to be booked at the rate that applied on the day of the transaction - not the rate today. This converter looks up the European Central Bank's official daily reference rate for the exact date you enter, going back to 4 January 1999, and shows you which publication date the rate came from so the figure is auditable.
The date on the receipt - not today.
Nothing converted yet
Where the rates come from
Every figure here is a European Central Bank euro foreign exchange reference rate, retrieved through the free, open-source Frankfurter API. The ECB publishes these once per TARGET business day, based on a concertation procedure between central banks at around 14:15 CET, and they are the rates European tax authorities and auditors recognise for converting foreign-currency transactions.
They are reference rates, which is an important distinction: they are not the rate your bank or card issuer actually charged you. If your accounting policy is to book the amount your bank really debited, use the bank statement figure. The ECB rate is what you use when you need a neutral, officially published rate for the transaction date - which is the normal requirement for expense claims, VAT returns and foreign receipts.
Coverage is the roughly 30 currencies in the ECB's daily list. Currencies the ECB doesn't publish simply have no official rate to look up, and this tool says so rather than substituting a different source and calling it official.
अक्सर पूछे जाने वाले प्रश्न
Why do I need the exchange rate on a specific date for accounting rather than today's rate?
Because the expense happened on that date. Under IAS 21 and essentially every national bookkeeping rule, a foreign-currency transaction is recorded using the spot rate at the date of the transaction. If you paid 42.50 USD for a taxi in March and convert it at September's rate, the amount in your books is simply wrong - and the gap is not rounding, it is often several percent. This tool exists so you can book each receipt at its own day's rate instead.
Wie finde ich den Wechselkurs an einem bestimmten Tag (EZB)?
Datum eingeben, Währungspaar wählen, fertig. Der Rechner holt den amtlichen EZB-Referenzkurs (Euro-Referenzkurs) für genau diesen Tag, zurück bis zum 4. Januar 1999. Wichtig für die Buchhaltung: Die EZB veröffentlicht an Wochenenden und TARGET-Feiertagen keinen Kurs. Fällt Ihr Belegdatum auf so einen Tag, wird der Kurs des letzten Veröffentlichungstages davor verwendet - und das Tool zeigt Ihnen beide Daten getrennt an, damit der Beleg prüfbar bleibt.
My receipt is dated a Saturday. Which rate does it use?
The rate from the last publication day before it, usually the Friday - and the tool shows you both dates side by side with an explicit warning, rather than quietly pretending Saturday had a rate. The ECB publishes nothing on weekends or TARGET closing days, and using the preceding publication day is the standard convention tax authorities expect. Record both the transaction date and the rate date in your books and the entry is defensible.
Can I convert a whole pile of receipts at once?
Yes - switch to the 'Whole expense list' tab and paste one receipt per line as date, amount, description. Every line is priced at its own transaction date, and the CSV you download has separate columns for the transaction date and the ECB publication date whose rate was applied, so the weekend substitutions are visible to whoever reviews it. Distinct dates are looked up once and reused, so forty receipts spread over five days cost five lookups.
Does this work with the site's receipt and invoice OCR tools?
That's exactly the pairing it's built for. Run a stack of foreign receipts through the Receipt OCR or Invoice OCR tool to pull out the date and total, or through Bulk Receipt to Expense Report for a whole batch, then paste the resulting date-and-amount rows straight into the expense-list tab here. You get one CSV with the original currency amount, the rate, the rate date and the converted amount - ready for your bookkeeping software.
How far back does it go, and what about currencies that no longer exist?
Back to 4 January 1999, the euro's first trading day - there is no ECB euro reference rate before that, and the tool refuses earlier dates rather than inventing one. Legacy currencies replaced by the euro (Deutsche Mark, French franc, Italian lira) aren't in the ECB's daily list, since they were converted at fixed irrevocable rates rather than floating ones, so they aren't offered here.