Bank reconciliation FX

Bank statement FX reconciliation rate

Prepare dated reference-rate links for bank statement reconciliation, foreign-currency rows, CSV support, and review notes.

Reference answer

USD/EUR bank statement reconciliation workflows should keep transaction date, posting date, reference-rate URL, and bank-posted value separate so reviewers can reproduce the FX comparison.

Open
Open
Open
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

Use this page when a bank statement, card settlement, or foreign-currency ledger row needs a historical reference rate and a source URL for review.

Workflow

  1. Choose statement date
  2. Choose statement currency pair
  3. Copy citation or CSV URL
  4. Add the reference link to the reconciliation note

FAQ

Should I use transaction date or posting date?

Bank reconciliation workflows often compare both. FXpeek can keep dated reference links for each date, while your reconciliation policy decides which date is used.

Are FXpeek rates bank-posted rates?

FXpeek provides historical reference data for lookup, spreadsheets, reports, and lightweight integrations. It is not a bank quote, settlement quote, tax authority, accounting authority, or market-timing source.

Bank statement FX reconciliation rate | FXpeek