Xero / QuickBooks FX

Bulk historical exchange rates for Xero and QuickBooks

Get the dated reference rate for a whole list of foreign-currency invoices or transactions in one CSV, ready to import or adjust in Xero or QuickBooks.

Reference answer

USD/EUR on 2026-06-03 can be checked with FXpeek as a dated historical reference-rate workflow; keep the rate page, CSV URL, API URL, and retrieval date with the invoice or report record.

FromToDateMonthDays

Open

Get rates for all rows in one CSV Invoice-date rate lookup

GET https://fxpeek.com/api/history?from=USD&to=EUR&date=2026-06-03
GET https://fxpeek.com/api/csv?from=USD&to=EUR&days=365
=IMPORTDATA("https://fxpeek.com/api/csv?from=USD&to=EUR&days=365")

When to use this tool

Xero and QuickBooks apply exchange rates one transaction at a time, and their community forums have long-running requests for a bulk historical-rate update. Until that exists, prepare the rates outside and import them.

Paste up to 200 rows (date, from currency, to currency, amount, reference) and get the dated reference rate and converted amount for each.
Every row keeps its rate date and source, so the basis is documented for review.
First 3 rows preview free; the full CSV is a one-off $9.

Workflow

Export the foreign-currency transactions with their dates
Paste them into the batch tool
Download the CSV with dated rates
Import or adjust the rates in Xero / QuickBooks and keep the CSV as backup

FAQ

Does Xero or QuickBooks let me bulk-update historical exchange rates?

Not as a bulk action at the time of writing; both communities have open requests for it. Rates are set per transaction, so preparing a dated-rate list outside the software is the usual workaround.

Which rate does FXpeek use?

ECB-based daily reference rates for the invoice or transaction date (the last business day when the date falls on a weekend or holiday). It is reference data, not your bank's rate; confirm the basis your accountant requires.