Shopify Payout Does Not Match Sales - Review Payout Support and Bank Deposits
Review Shopify payout exports, refunds, adjustments, timing, and grouped payout support when sales totals do not match the bank deposit.
Try with sample files | View sample report
Problem statement
A Shopify sales total is usually a gross order view, while the bank deposit is the payout after deductions, refunds, timing shifts, and possible grouped activity. The right workflow starts from the payout support, not from a single sales total.
Numeric example
| Line item | Amount |
|---|
| Gross order total | $2,134.24 |
| Refunds | -$120.00 |
| Payout deductions | -$64.20 |
| Possible adjustment | -$15.00 |
| Bank payout | $1,935.04 |
Why the numbers do not match
- The payout export can contain fees, refunds, adjustments, and payout status changes that do not show up in the same way inside a gross sales report.
- Refunds and chargebacks can land in a different payout period than the original sale.
- Several days of orders can be grouped into one payout deposit.
- Pending orders, manual payments, and third-party gateways may not belong inside the Shopify Payments payout support.
- Payout schedule timing can move the bank date away from the order date.
What files to export
- Shopify orders export with order number, paid date, payment status, gross total, payment method, and refund fields.
- Shopify payout report with payout ID, gross, fees, refunds, adjustments, status, payout date, and net amount.
- Bank statement export with deposit date, amount, and bank description for Shopify transfers.
Manual workflow
- Start from the payout ID or payout date instead of the store-wide sales total.
- Separate gross orders, refunds, payout deductions, payout status, and possible adjustments.
- Use payout CSV columns first when the order report and payout report disagree about what belongs in the bank movement.
- Match the payout net amount to the bank deposit by amount, date, and reference.
- Keep orders from non-Shopify gateways outside the payout explanation unless the export proves they belong there.
- Leave timing gaps and weak-reference rows in review instead of forcing a final explanation.
Common mistakes
- Comparing gross sales totals directly to one bank deposit.
- Calling every shortfall a fee when the payout export only proves a broader amount difference or adjustment.
- Ignoring refunds that landed in a later payout period.
- Forgetting that non-Shopify gateways may be excluded from Shopify Payments payouts.
How Reconcile Locally helps
- Keeps gross orders, payout rows, and bank rows in one local review flow.
- Separates matched deposits from amount differences, unknown bank payments, and review rows instead of hiding them in spreadsheet formulas.
- Keeps unpaid or excluded orders visible when the payout support is incomplete.
- Exports a report you can review before you change accounting entries.
What still needs manual review
- Some payout differences still need manual review when references are incomplete or several deposits could match the same payout.
- Cross-gateway workflows may need one more exported file before the difference is fully explained.
- The payout export may show a deduction or adjustment without proving the exact accounting classification of every row.
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 export should I use first?
Start with the payout export and match its payout ID, net amount, and status to the bank deposit. Then use the order export to explain what sits behind that payout.
Does every Shopify payout difference mean a fee?
No. A lower bank deposit can also reflect refunds, chargebacks, timing differences, payout adjustments, or grouped activity. Use amount-difference wording unless the export explicitly proves the cause.
Which Shopify payout columns matter most?
Start with payout ID, status, payout date, gross, refunds, adjustments, and net amount. Those columns usually explain more than a store-wide sales total.