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.

What if the Shopify orders were paid through PayPal instead of Shopify Payments?

Treat it as a cross-platform workflow. Shopify still explains the order context, but PayPal controls the fees, holds, refunds, and withdrawal that reached the bank, so the PayPal withdrawal review should come next.

When should I use the Shopify payout example instead of this guide?

Use the example when you want one concrete payout walkthrough from gross orders to the bank deposit. Use this guide when you need the broader workflow, export decisions, and edge-case handling across several payout situations.

When should I use the Shopify payout mismatch page instead of this guide?

Use the mismatch page when the payout exists but the shortfall still depends on payout status, delayed deposits, export-column disagreement, or unresolved bank-side evidence. Use this guide when you still need the broader payout-first workflow.