Shopify Payout Export Columns Guide
Which Shopify payout export columns help explain gross activity, deductions, payout status, net payout, and bank timing first.
Try with sample files | View sample report
Problem statement
The Shopify payout export contains several fields, but only a subset explains the expected net payout and final bank movement first. Reviewers need those columns before they decide whether a shortfall is explained.
Numeric example
| Line item | Amount |
|---|
| Identity | Payout ID and transaction type |
| Timing | Payout date and status |
| Amounts | Gross, refunds, adjustments, net payout |
Why the numbers do not match
- Payout ID ties the payout support to the bank deposit and to review notes.
- Status and timing fields separate late deposits from true missing-payout cases.
- Gross, refunds, adjustments, and net amount explain why sales totals differ from cash.
- Reference fields help separate summary rows from correction or review-only rows.
What files to export
- Shopify payout export with payout ID, status, dates, gross rows, deductions, and net amount.
- Shopify orders export with order references and gross sales support.
- Bank statement export with deposit amount, date, and bank description.
Manual workflow
- Start from payout ID, payout date, status, and net amount.
- Separate gross rows from refunds, adjustments, and other deductions.
- Use order-level exports only after the payout summary already explains the expected net deposit.
- Match the expected net payout to the bank row by amount, date, and reference.
- Keep unexplained shortfalls as amount differences until the export proves the cause.
Common mistakes
- Starting from store sales totals instead of payout ID and net amount.
- Ignoring payout status when the expected deposit is late or failed.
- Treating every lower deposit as a fee when the export only proves a broader deduction.
How Reconcile Locally helps
- Keeps payout summary, order support, and bank rows visible in one payout-first review flow.
- Preserves review wording when the export proves a deduction but not its final classification.
- Exports a report that keeps matched payouts and unresolved differences separate.
What still needs manual review
- Column names and ordering can vary across exports.
- Some grouped or cross-gateway cases still need another export before the difference is fully explained.
Content review and sources
Written and reviewed by the Reconcile Locally product team. Last reviewed June 7, 2026.
Guidance is checked against current product behavior and first-party documentation where available. Reconciliation results still require human review.
Frequently asked questions
Which Shopify payout columns matter most?
Start with payout ID, payout date, status, gross activity, refunds, adjustments, and net amount. Those fields usually explain more than a store-wide sales total.
Should I reconcile from orders or from payout rows first?
Start from payout rows first. Orders are supporting detail, but the bank deposit usually matches the net payout after deductions.