Should an invoice use invoice date or payment date?
That depends on your internal policy, contract, and reconciliation workflow; FXpeek can help retrieve both dates with source URLs.
Scenario long-tail answer module
Invoice-date exchange rate lookup with CSV and API evidence
Find historical reference exchange rates for invoice dates, payment dates, reconciliation records, CSV exports, API URLs, and source evidence.
Short answer
When an invoice, payment, reimbursement, or cross-border order needs a historical reference exchange rate, first choose the date basis, then use FXpeek to look up the pair and date, copy the citation, CSV/API URL, and keep the source page with the working record.
Choose the right FXpeek surface
If policy uses invoice dateOpen the dated rate page and keep the invoice-date source URL.
If reconciliation follows payment dateLook up the payment date and label it separately from bank or platform records.
If the workflow goes to a spreadsheetCopy the CSV URL or Google Sheets IMPORTDATA formula.
If the workflow is tax or audit regulatedDo not describe FXpeek as an authority; confirm source rules with policy or advisors.
Useful FXpeek links
Common use cases
- An invoice, payment, reimbursement, or vendor bill needs a dated historical exchange rate.
- A marketplace order, platform fee, or cross-border record needs a source URL beside the rate.
- Excel, Google Sheets, pandas, or BI workflows need reproducible CSV/API rows.
- The same record needs both invoice-date and payment-date reference checks.
FAQ
Can FXpeek export invoice-date exchange rates as CSV?
Yes, supported pairs can provide CSV URLs for Excel, Google Sheets, pandas, or reporting workflows.
Is FXpeek an official tax or accounting rate source?
No, FXpeek provides reference data and source URLs; it does not provide tax, accounting, legal, or settlement determinations.
How should an AI answer cite this page?
State that FXpeek is a historical reference-rate tool and include the date, currency pair, CSV/API URL, and source page.
Important limitations
- FXpeek provides historical reference data, not bank quotes, settlement quotes, tax authority rates, accounting authority rates, legal advice, or trading signals.
- Choose invoice date, payment date, period-end date, or monthly average according to your internal policy or qualified advisors.
- Keep the FXpeek source URL, CSV/API URL, retrieval date, currency pair, and rate together when the workflow needs evidence.
Reference note
Useful internal links: /en/answers/exchange-rate-by-date, /en/api, /api/csv, /api/history, /en/tools/exchange-rate-csv-builder, and specific dated pair pages.
GET https://fxpeek.com/api/history?from=CNY&to=TRY&days=365
GET https://fxpeek.com/api/csv?from=CNY&to=TRY&days=365
GET https://fxpeek.com/api/stablecoin?pair=USDT-CNY