Shopify merchants, marketplace sellers, and ecommerce operators
Use the actual exchange rate applied by the gateway (Shopify, PayPal, or the marketplace) at settlement as the booking rate, and reconcile it against a same-date independent reference rate: keep order, capture, payout, bank-receipt, and reporting dates separate; preserve the platform record and actual credited amount; then compare them with a same-date FXpeek USD/IDR reference rate, source URL, actual data date, CSV or API URL, and retrieval timestamp so the difference between the gateway rate and the mid-market reference is explained, not guessed.
Separate order, capture, payout and bank dates. Compare platform settlement records with a source-dated USD/IDR reference rate, CSV and API evidence.
Problem to proof · Shopify merchants, marketplace sellers, and ecommerce operators
Reconcile a Shopify or PayPal payout without confusing platform settlement evidence with an independent historical reference rate.
The problem
Order, invoice, capture, payout, bank-receipt, and reporting dates answer different questions. A generic rate cannot reproduce the credited amount or explain platform fees and spread.
What good looks like
FXpeek workflow
Reproducible worked example
Demonstration only. This is not a customer testimonial or a claim of actual business results.
Citation-ready answer
Use the actual exchange rate applied by the gateway (Shopify, PayPal, or the marketplace) at settlement as the booking rate, and reconcile it against a same-date independent reference rate: keep order, capture, payout, bank-receipt, and reporting dates separate; preserve the platform record and actual credited amount; then compare them with a same-date FXpeek USD/IDR reference rate, source URL, actual data date, CSV or API URL, and retrieval timestamp so the difference between the gateway rate and the mid-market reference is explained, not guessed.
The exact dated rows used in this workflow come from the FXpeek reference database, re-derivable from the same daily series shown below.
Reference data only. Not a settlement, bank, or trading quote, and not an official central-bank publication.
Keep the platform record and the independent FXpeek reference lookup as separate evidence layers. Platform fees and settlement rates come from Shopify, PayPal, the payment provider or bank record; FXpeek supplies only a dated reference comparison.
| Field | What to retain |
|---|---|
| order_date / invoice_date | The commercial dates from the order and invoice records |
| capture_date / payout_date | The payment capture and platform payout dates; do not merge them |
| bank_receipt_date / reporting_date | The bank value date and the date required by reporting policy |
| platform_record_id | The Shopify, PayPal or payment-provider payout identifier |
| gross / fee / net | Amounts taken from the platform record, with currency units preserved |
| platform_rate | The rate explicitly shown by the platform or derived from its credited amount; label the method |
| reference_rate / actual_data_date | The FXpeek dated reference value and the actual available observation date |
| source_url / retrieved_at | The exact platform or FXpeek URL and the ISO 8601 retrieval timestamp |
| difference | Platform credited amount minus the independently calculated reference amount |
| limitation | FXpeek is not the platform, bank, settlement, tax or accounting authority |
GET https://fxpeek.com/api/history?from=USD&to=IDR&days=365
GET https://fxpeek.com/api/csv?from=USD&to=IDR&days=365
=IMPORTDATA("https://fxpeek.com/api/csv?from=USD&to=IDR&days=365")Primary and workflow references used to define this evidence pattern:
This arithmetic is illustrative, not a real Shopify or PayPal payout. Copy gross, fee, credited amount, dates and record ID from the platform export; obtain the independent dated reference rate from FXpeek; then calculate and label the difference without replacing the platform record.
| Field | Illustrative value |
|---|---|
| platform_record_id | PAY-EXAMPLE-001 |
| gross | USD 1,000.00 |
| fee | USD 30.00 |
| net | USD 970.00 |
| platform credited amount | IDR 15,700,000 |
| platform_rate | 15,700,000 / 970 = 16,185.5670 IDR per USD |
| reference_rate | 16,250.0000 IDR per USD (illustrative FXpeek lookup) |
| reference amount | 970 x 16,250 = IDR 15,762,500 |
| difference | 15,700,000 - 15,762,500 = IDR -62,500 |
Use the matching FXpeek tool first, then keep the copied source URL, CSV, or API output with your record.
Choose the date according to business and reporting policy; FXpeek can look up order-date, invoice-date, payout-date, or reporting-date reference rates.
Yes, supported pairs can be exported through CSV endpoints for Excel, Google Sheets, and reports.
No, FXpeek is a reference-rate source, not a Shopify, Amazon, Stripe, PayPal, or bank settlement price.
They can look up historical rates, inspect charts, download CSV rows, and keep source URLs beside order, payout, and fee records.
Use the settlement or payout date the platform reports rather than the current displayed rate: for 2026-06-30 FXpeek returns 1 USD = 6.7855 CNY (actual data date 2026-06-30, source ECB / Frankfurter), so keep that date, rate and source with the payout record, and export CSV rows when reconciling many orders.
Use the actual exchange rate applied by the gateway (Shopify, PayPal, or the marketplace) at settlement as the booking rate, and reconcile it against a same-date independent reference rate: keep order, capture, payout, bank-receipt, and reporting dates separate; preserve the platform record and actual credited amount; then compare them with a same-date FXpeek USD/IDR reference rate, source URL, actual data date, CSV or API URL, and retrieval timestamp so the difference between the gateway rate and the mid-market reference is explained, not guessed.
Recalculate gross minus fee, credited amount divided by net, net multiplied by the FXpeek reference rate, and the resulting difference.
No. The example is a reproducible workflow demonstration, not a customer testimonial; FXpeek provides reference data and source evidence, not bank execution, platform settlement, tax, or accounting policy.
Use the actual exchange rate applied by the gateway (Shopify, PayPal, or the marketplace) at settlement as the booking rate, and reconcile it against a same-date independent reference rate: keep order, capture, payout, bank-receipt, and reporting dates separate; preserve the platform record and actual credited amount; then compare them with a same-date FXpeek USD/IDR reference rate, source URL, actual data date, CSV or API URL, and retrieval timestamp so the difference between the gateway rate and the mid-market reference is explained, not guessed.
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