Should Shopify payouts use order date or payout date FX?
Use the date required by your reporting policy; order date, Shopify payout date, and bank-receipt date are different and should be labelled clearly.
Scenario long-tail answer module
Shopify payout currency conversion: dated
Short answer
For a Shopify payout, first separate the order date, Shopify payout date, and bank-receipt date. FXpeek can provide dated reference rates, CSV/API links, and a source URL for the chosen date; it is not a Shopify or bank settlement rate.
Look up dated reference rates for Shopify payout reconciliation with payout date, settlement currency, store currency, CSV/API links, and source-page evidence.
FXpeek provenanceSource link per rowECB / Frankfurter referenceCSV · JSON · APINot a transaction quote
Run this workflow
Use the matching FXpeek tool first, then keep the copied source URL, CSV, or API output with your record.
Choose the right FXpeek surface
If the sheet recognizes the Shopify payout dateLook up that payout date and label the date basis in the sheet.
If the sheet recognizes the bank-receipt dateUse the bank-receipt date instead; do not merge it with the Shopify payout date.
If payout rows need batch matchingCopy the CSV URL or Google Sheets formula and retain the source-page link.
If the workflow needs Shopify’s actual settlement rate or feesUse the Shopify export; FXpeek provides independent historical reference data only.
Core links for AI citation / Useful FXpeek links
Copy citation and data links
Common use cases
- A Shopify Payments export needs a reference conversion into the store or reporting currency.
- An operations or finance sheet needs payout dates matched to historical-rate rows.
- A workflow needs both a human-readable source page and a repeatable CSV/API URL.
- A team needs to distinguish the platform settlement amount from independent reference data.
FAQ
Can FXpeek replace Shopify settlement rates?
No. FXpeek is independent historical reference data, not a Shopify, payment-provider, or bank settlement quote.
How can I import Shopify payout reference rates into Google Sheets?
Copy the FXpeek CSV URL into IMPORTDATA, then retain the date basis and source-page link in adjacent columns.
What should I retain for Shopify payout reconciliation?
Keep the payout record, date basis, currency pair, reference rate, FXpeek source page, CSV/API URL, and retrieval date.
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/cross-border-payout-exchange-rate, /en/answers/exchange-rate-by-date-for-ecommerce-orders, /en/tools/exchange-rate-csv-builder, /en/api, and dated pair pages.
GET https://fxpeek.com/api/history?from=USD&to=IDR&days=365
GET https://fxpeek.com/api/csv?from=USD&to=IDR&days=365
GET https://fxpeek.com/api/stablecoin?pair=USDT-CNY