Shopify and QuickBooks reconciliation: a practical workflow
A Shopify bank deposit is a net payout, not a sales total. Clean bookkeeping keeps the orders, taxes, fees, refunds and payout timing connected so the final deposit can be matched without guessing.
The short version: record the underlying activity first, route it through a Shopify clearing account, then match the net payout to the bank deposit. Do not record the deposit itself as new sales.
Why the numbers look different
Shopify records customer activity when orders and refunds occur. Your bank records cash when Shopify sends a payout. Those dates and totals often differ because a payout can combine activity from many orders while subtracting fees, refunds, disputes and other adjustments.
Shopify's payout reconciliation report breaks down balance activity for a selected period and currency. Shopify also notes that the report is not a revenue statement: sales reporting and payout reporting can use different timing and totals.
A reliable reconciliation sequence
- Choose a clean opening date. Avoid changing methods halfway through an unreconciled period.
- Map each category. Sales, discounts, shipping, taxes, gift cards, fees, refunds and disputes should land in the intended accounts.
- Use a Shopify clearing account. The gross activity increases or decreases the clearing balance before cash reaches the bank.
- Review imported exceptions. Missing products, customers or account mappings should be resolved before the payout is confirmed.
- Record the payout transfer. Move the net payout from the clearing account to the bank account.
- Match the bank deposit. The accounting deposit should equal the amount that actually reached the bank.
- Reconcile the clearing balance. Remaining balances should be explained by unsettled activity, timing or a specific exception.
What the native QuickBooks connector can do
QuickBooks Online's current Shopify Connector can import individual sales, refunds, fees and payouts. Intuit's workflow asks users to categorize the transactions included in a payout, map adjustment lines, confirm the payout, and then match the resulting deposit in Bank Transactions.
A native connection may be enough when
- Shopify Payments is the primary processor
- The account mapping is straightforward
- Someone reviews exceptions consistently
- The opening books are already clean
A configured workflow becomes valuable when
- Stripe, PayPal or other channels are also involved
- Refunds and chargebacks cross accounting periods
- Taxes, currencies or gift cards need special handling
- The connector is importing data but the books still do not tie out
Common mistakes to avoid
- Adding the net bank deposit as revenue after the underlying orders were already recorded
- Posting processing fees as a reduction of sales instead of to the intended expense account
- Ignoring third-party processors that do not appear in the Shopify Payments payout
- Forcing a match without explaining the remaining clearing-account balance
- Turning on automatic rules before validating one complete payout period to $0.00
Not sure where your difference is coming from?
Tell us which systems you use and what is not matching. LZ Financial will review the workflow and reply with the likely gaps and the most practical next step.
Request a free payout assessment →Official references
This guide is general educational information, not accounting or tax advice. Your accountant remains responsible for approving account treatment and filings.