Shopify accounting topic hub

Shopify payouts and reconciliation

Explain every Shopify deposit from gross sales through refunds, fees, adjustments, clearing, and the final bank match.

14 focused guides

Illustrated reconciliation workshop turning mixed Shopify transactions into one matched bank deposit

What you will learn

Shopify sends net deposits, while accounting needs the gross activity behind them. A reliable reconciliation connects captured sales, refunds, fees, disputes, reserves, adjustments, and timing differences to the exact amount that reaches the bank.

Use this hub to follow the money from Shopify reports into QuickBooks, investigate a difference without forcing a match, and keep evidence that another reviewer can retrace at month-end.

01

Understand the payout

Learn why sales, payout, and bank dates differ—and which Shopify reports answer each question.

02

Build the accounting entry

Separate revenue, refunds, fees, disputes, taxes, and clearing before posting the net movement.

03

Investigate the variance

Trace missing, duplicated, split, delayed, or multi-gateway deposits without using an unexplained plug.

Continue through the topic

Every guide in this hub.

Follow the sequence or choose the specific accounting problem you need to solve.

Shopify payouts

Shopify sales vs payouts: why the numbers are different

Shopify sales and Shopify Payments payouts rarely match for the same date. Learn what each number means, why the gap happens, and how to reconcile it without guessing.

9 min read →
Payout accounting

Shopify payout journal entry: a complete worked example

Build a balanced Shopify payout journal entry in QuickBooks Online, record sales, refunds, fees and tax, then match the bank deposit without duplicating income.

9 min read →
QuickBooks setup

Shopify clearing account in QuickBooks: how to fix messy payouts

Set up a Shopify clearing account in QuickBooks Online, record fees and refunds correctly, and match each payout to the bank without duplicating sales.

9 min read →
Shopify fees

How to record Shopify fees in QuickBooks Online

Record Shopify Payments fees in QuickBooks without reducing sales twice, missing expenses, or creating a payout that will not match the bank.

9 min read →
Refunds and chargebacks

How to record Shopify refunds, chargebacks and disputes in QuickBooks

Record Shopify refunds and chargebacks in QuickBooks without duplicating the return, losing the processing fee, or treating a temporary dispute hold as a final loss.

9 min read →
Accounting methods

Per-order sync vs payout summaries for Shopify accounting

Compare per-order Shopify sync with payout summaries in QuickBooks. Choose the right level of detail without creating duplicate sales or an account that will not reconcile.

9 min read →
Payment reconciliation

How to reconcile Shopify Payments, PayPal and other gateways

Reconcile Shopify Payments, PayPal and other payment gateways in QuickBooks without mixing deposits, fees, refunds or money still in transit.

9 min read →
Shopify reports

How to find and export Shopify payout reports

Find the right Shopify payout, reconciliation and finance reports, export them for QuickBooks, and save a clean month-end evidence package.

9 min read →
Free template

A Shopify payout reconciliation checklist and spreadsheet

Download a practical Shopify payout reconciliation spreadsheet and learn how to check fees, refunds, deposits and QuickBooks entries without duplicating sales.

9 min read →
Troubleshooting

Why your Shopify revenue does not match your bank deposits

Learn why Shopify sales and bank deposits show different totals, then trace fees, refunds, payout timing, tax, holds and other gateways without guessing.

9 min read →
Troubleshooting

How to fix a Shopify clearing account that won’t reconcile

Find why your Shopify clearing account does not match, trace the difference to payouts, refunds, fees or duplicates, and fix it without forcing the balance to zero.

9 min read →
Payout reconciliation

How to reconcile Shopify payouts in QuickBooks Online

A practical workflow for separating sales, refunds, fees, taxes, and disputes before matching the Shopify deposit in QuickBooks.

8 min read →
Troubleshooting

Why a Shopify payout may not match the bank deposit

The most common reasons a Shopify payout and bank deposit differ, plus a structured way to investigate the variance.

7 min read →

A practical route

Use this hub in three passes.

  1. 01

    Start with sales versus payouts to understand the reconciliation boundary.

  2. 02

    Use the journal-entry and clearing-account guides to build the accounting flow.

  3. 03

    Move to the mismatch and troubleshooting guides when a payout does not clear.