Why do Shopify payouts not match sales totals?

Shopify payouts are net of processing fees, refunds, chargebacks, and other adjustments. Reconcile payout batches to bank deposits, not gross sales totals.

Should I reconcile by order date or payout date?

For matching bank deposits, reconcile by payout date and payout batch. Orders often settle into later payouts.

How do refunds affect payouts?

Refunds reduce net payouts and may occur in periods different from the original sale. Track refunds as separate adjustments.

Bank Tools · Shopify

Shopify Payout Reconciliation Questions

Shopify pays out in batches. Your reconciliation target is the payout deposit, not the order total. Match payout batches to bank deposits.

Shopify Workflow Merge PDFs Preview PDFs

Non-negotiable rules

Reconcile to deposits: match payout batches to bank deposits.
Separate components: gross sales, fees, refunds, chargebacks, and other adjustments.
Use a consistent boundary: payout period is usually the cleanest boundary for deposit matching.
Expect cross-period adjustments: refunds and chargebacks can occur later than the sale.

A clean model: Gross sales - fees - refunds - chargebacks - holds = net payout. Net payout should match the bank deposit.

What accountants want

One bundle per period (monthly close or payout cycle)
A short note defining the boundary you used
Traceable mapping from payout batch to bank deposit
Clear separation of fees and adjustments

What breaks Shopify reconciliation

Reconciling to order date instead of payout date
Mixing multiple payout periods in one file
Ignoring chargebacks and negative adjustments
Using partial exports without validating completeness

Common Shopify payout issues

Gross sales does not match deposit

Payouts are net. Differences are typically fees, refunds, chargebacks, or adjustments. Start by identifying the payout batch that matches the deposit date.

Payout timing vs order date

Orders can settle into later payouts. If you export by order date, you will not match deposits cleanly.

Refunds and chargebacks across periods

Refunds reduce net payouts. Chargebacks can create additional adjustments. Expect these to appear in periods different from the original sale.

Taxes and shipping confusion

Taxes and shipping can be reported differently depending on settings. For deposit matching, focus on the net payout and reconcile the breakdown separately.

Recommended workflow (operator version)

Choose a boundary: monthly close or payout cycle.
Collect payout documentation for that boundary.
Match payout batch amounts to bank deposits.
Explain differences using fees, refunds, and chargebacks.
Create one PDF bundle per boundary and send to accounting.

Open Shopify Workflow Back to Guide Compare: Stripe QuickBooks Questions

This content is operational guidance and does not provide tax advice.