Shopify makes selling easy and bookkeeping deceptively hard. The trap: Shopify's default QuickBooks connections often sync orders or payouts as income — both wrong in different ways. Here's the setup that produces books your accountant (and any future buyer) will trust.
Payouts ≠ revenue, and orders ≠ revenue either
A Shopify payout is your sales minus processing fees and refunds, batched on a delay. Booking payouts as income understates revenue and hides fees. But syncing every individual order creates the opposite mess: thousands of tiny transactions that never quite match the deposits, plus sales tax booked as income. The correct unit is the payout summary: gross sales, discounts, refunds, fees and sales tax — each to its own account, tied to the deposit.
The five-step setup
- Separate income accounts for Shopify sales, and contra accounts for discounts and refunds — margins by promotion become visible.
- Sales tax is a liability, never income. Shopify collects it; you owe it to states. Booked as income, you're paying income tax on the state's money.
- Connect via a settlement tool (A2X or Link My Books) posting one clean journal per payout.
- Don't forget the other gateways. PayPal, Klarna and Shop Pay Installments each settle separately with their own fees — each needs its own clearing account.
- Reconcile monthly: every payout matched to a bank deposit, every gateway cleared to zero.
The inventory question
Shopify tracks stock counts, not accounting cost. For books that show real margins you need COGS posted monthly — see our guide to cash vs accrual for e-commerce for why this one choice can swing reported margin by 10–20 points.