Shopify Payout Reconciliation: Why Payouts Don't Match Sales or Bank Deposits
Review Shopify sales, deductions, payout reports, and bank deposits together before you update accounting entries.
Try with sample files | View sample report
Problem statement
Shopify orders show gross sales, but the bank deposit is the payout after fees, refunds, chargebacks, timing shifts, and adjustments. A direct sales-to-bank comparison hides the real review work.
Numeric example
| Line item | Amount |
|---|
| Gross Shopify orders | $2,134.24 |
| Refunds | -$120.00 |
| Processing fees | -$64.20 |
| Adjustment | -$15.00 |
| Bank payout | $1,935.04 |
Why the numbers do not match
- Fees reduce the payout before it reaches the bank.
- Refunds and chargebacks can land in a different payout cycle than the original order.
- One payout often groups several order dates together.
- Non-Shopify gateways may not appear inside Shopify Payments payouts.
- 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, customer, gross total, and refund fields.
- Shopify payout report with payout ID, gross, fees, refunds, adjustments, and net amount.
- Bank statement export with deposit date, amount, and bank description for Shopify transfers.
Manual workflow
- Start from payout ID or payout date, not from the store sales total.
- Separate gross sales, fees, refunds, chargebacks, and adjustments.
- Calculate the expected net payout for each payout batch.
- Match the expected net payout to the bank deposit by amount, date, and reference.
- Keep timing gaps separate from true missing deposits.
Common mistakes
- Comparing total store sales directly to one bank deposit.
- Treating deductions as missing cash instead of reviewing the payout detail.
- Ignoring refunds that landed in a later payout cycle.
- Mixing non-Shopify gateways into the same payout explanation.
How Reconcile Locally helps
- Keeps gross orders, payout rows, and bank rows in one review flow.
- Separates matched rows from amount differences and unknown bank payments.
- Keeps unpaid orders and duplicate candidates visible for follow-up.
- Exports a report you can review before posting anything to accounting.
What still needs manual review
- Grouped payouts still need a human decision when references are incomplete or several deposits look plausible.
- Cross-gateway workflows may need one more exported file before the remaining difference is fully explained.
- Unclear timing gaps should stay in review instead of being forced into a final match.
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
Should Shopify sales equal the bank deposit?
Usually no. Shopify sales are gross order totals, while the bank deposit is normally net of fees, refunds, chargebacks, and adjustments.
What is the safest first check?
Find the payout ID and reconcile that payout's gross, refunds, fees, and net amount before comparing it to the bank statement.