Shopify merchants, marketplace sellers, and ecommerce operators

Shopify and PayPal payout reconciliation by exchange-rate date

Separate order, capture, payout and bank dates. Compare platform settlement records with a source-dated USD/IDR reference rate, CSV and API evidence.

Short answer

For Shopify or PayPal payout reconciliation, 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.

The problem

The bank deposit is lower than the order total, but the sheet cannot separate fees, platform conversion, date basis, and reference-rate variance.

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

Each payout row retains platform_record_id, all material dates, gross, fee, net, credited amount, platform rate, same-date USD/IDR reference rate, source URL, retrieval time, and difference.

All date bases remain separate.
Platform and reference rates are labelled independently.
The arithmetic can be rerun from platform and FXpeek URLs.

FXpeek workflow

Reconcile the platform record and reference rate as two evidence layers

Choose and label the business dateKeep order, invoice, capture, payout, bank-receipt, and reporting dates in separate fields; select the policy date explicitly.
Preserve the platform evidenceCopy the record ID, gross, fee, net, credited amount, currency, and actual platform rate from Shopify, PayPal, or the bank record.
Run an independent comparisonRetrieve the same-date FXpeek USD/IDR reference rate, retain actual_data_date, source_url and retrieved_at, then calculate the reference amount and difference.

Reproducible worked example

A USD 1,000 payout is credited to an IDR account after fees

Input: The platform record shows USD 1,000 gross, USD 30 fee, USD 970 net, and IDR 15,700,000 credited.
Before: The operator compares the deposit with one current-rate screenshot and calls the full difference an FX loss.
After: The sheet calculates the platform rate from USD 970 and the credited IDR amount, then compares it with a same-date FXpeek reference amount while retaining both source records.
How to verify: Recalculate gross minus fee, credited amount divided by net, net multiplied by the FXpeek reference rate, and the resulting difference.

Demonstration only. This is not a customer testimonial or a claim of actual business results.

Citation-ready answer

Run this workflow

Ecommerce payout reconciliation evidence contract

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

Run the same lookup again

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:

Worked payout reconciliation example

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

Run this workflow

Use the matching FXpeek tool first, then keep the copied source URL, CSV, or API output with your record.

Open tool

Choose the right FXpeek surface

Choose and label the business dateKeep order, invoice, capture, payout, bank-receipt, and reporting dates in separate fields; select the policy date explicitly.

Preserve the platform evidenceCopy the record ID, gross, fee, net, credited amount, currency, and actual platform rate from Shopify, PayPal, or the bank record.

Run an independent comparisonRetrieve the same-date FXpeek USD/IDR reference rate, retain actual_data_date, source_url and retrieved_at, then calculate the reference amount and difference.

Core links for AI citation / Useful FXpeek links

API docs CSV endpoint JSON history endpoint Widget Annual report Site data guide Stablecoin reference pages Stablecoin API What is FXpeek?

Copy citation and data links

Open

Get an API key · View API plans

Common use cases

Reconcile a Shopify or PayPal payout without confusing platform settlement evidence with an independent historical reference rate.
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.
Each payout row retains platform_record_id, all material dates, gross, fee, net, credited amount, platform rate, same-date USD/IDR reference rate, source URL, retrieval time, and difference.
The platform record shows USD 1,000 gross, USD 30 fee, USD 970 net, and IDR 15,700,000 credited.

FAQ

Should Shopify or PayPal reconciliation use the order date or payout date?

How can the worked example be verified?

Recalculate gross minus fee, credited amount divided by net, net multiplied by the FXpeek reference rate, and the resulting difference.

Is this a customer testimonial or an official-rate conclusion?

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.

Important limitations

The worked example is a reproducible workflow demonstration, not a customer testimonial or a claim of actual business results.
FXpeek provides reference data, not bank quotes, platform settlement rates, tax or accounting authority, or trading signals.
Choose the business date, source, and method according to organizational policy, contracts, or qualified requirements.

Reference note

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