Why the bank deposit is not your sales total
A Shopify payout is a settlement, not a sales report. The amount reaching the bank can contain captured sales, refunds, processing fees, disputes, reserves, and adjustments from different transaction dates.
Posting the net deposit directly to revenue hides those components. It can overstate or understate sales, distort fees and taxes, and make later investigation unnecessarily difficult.
1. Start with the payout, not the orders
Use the Shopify payout as the reconciliation boundary. Record its payout ID, settlement date, currency, bank destination, and net amount. That gives you one cash event to explain from source activity through to the bank feed.
- Payout ID and settlement date
- Gross transaction activity
- Refunds and reversals
- Shopify Payments fees
- Disputes, reserves, and other adjustments
- Final net deposit
2. Reconstruct the payout components
Group every balance transaction included in the payout by its accounting treatment. Sales, shipping, tax, discounts, refunds, fees, and disputes normally need separate accounts even though Shopify settles them as one deposit.
The grouped components must add back to the exact payout amount. If they do not, stop and investigate the difference before creating a journal.
3. Use a clearing account
A Shopify clearing account separates accounting recognition from the movement of cash. The journal records the detailed payout activity against the clearing account. The bank deposit then clears the same amount when it appears in QuickBooks.
When both sides match, the clearing balance for that payout returns to zero. A remaining balance is evidence that something is missing, duplicated, or mapped incorrectly.
4. Review the journal before posting
Confirm that debits equal credits, mappings are approved, tax treatment is appropriate, and the clearing amount equals the Shopify payout. Keep the payout ID on the journal so a future reviewer can trace it back to Shopify.
- Every line has an approved QuickBooks account
- The journal balances
- The clearing line equals the net payout
- The payout currency matches the destination account
- The payout has not already been posted
5. Match the bank deposit
When the deposit appears in the QuickBooks bank feed, match it against the clearing entry rather than recording new income. The payout ID, date, amount, and bank destination should all agree.
The result is a bank match supported by a complete path from Shopify transactions to accounting entries and cash.