Shopify Payments payouts / transactions export
The settlement export from Settings > Payments > Shopify Payments (the payout list and the underlying transactions CSV). It is a CASH/settlement file that people mistake for a sales file, the deposited amount is not revenue.
The shape, how the file is really laid out
The transactions CSV is one row per money event with columns like Transaction
Date, Type (charge / refund / dispute / adjustment / payout / refund_failure),
Order, Card Brand, Payout Date, Payout Status (pending / paid), Available On,
Amount, Fee, Net, Currency, and (for cross-currency stores) Presentment Amount,
Presentment Currency and Exchange Rate. Rows are grouped by the payout that
settles them; a payout summary gives the deposit amount, its date, and status.
Net = Amount − Fee per row. "adjustment" and "dispute" rows are NEGATIVE and
frequently carry no Order id (reserve holds/releases, chargeback reversals).
The traps
Payout ≠ revenue: the deposited amount is gross charges − refunds − processing fees − chargebacks − reserve, so treating it as sales understates GMV by the fee and refund drag and misses tax/shipping entirely.
- Every trap in this export, worked through
- The reconciliation anchor, the total the file asserts about itself
- The refusal cases, when to stop and ask instead of guess
Reference: Shopify Help Center, "Shopify Payments payouts" and transactions export reference (documentation)