Shopify payout reconciliation checklist for QuickBooks Online
A Shopify payout reconciliation checklist helps explain why the amount deposited in the bank often does not equal gross sales in QuickBooks Online. Before changing rules or blaming QuickBooks, review the payout period, order totals, payment processor fees, refunds, chargebacks, taxes, shipping adjustments, app charges, receipt evidence, and deposit timing. The goal is not to force every number into one line. The goal is to understand what the payout contains and what support is missing before month-end close. ArnBooks uses this checklist as a practical review layer around QuickBooks Online: gather source context, flag gaps, and make the next accounting step clearer. QuickBooks remains the ledger, and a bookkeeper or accountant should still handle judgment calls, tax treatment, and complex reconciliation decisions. Use the checklist to decide whether the issue is a true accounting problem, a missing receipt problem, a payout timing issue, or simply an upstream workflow that needs better notes.
Confirm the payout period
Start with the payout start date, payout end date, date the payout was created, and date the bank deposit landed. A deposit that lands after month-end can make the books look wrong even when the underlying activity is explainable.
If the sales activity and bank date land in different periods, write that down before changing QuickBooks rules.
Break out the payout components
Review gross sales, discounts, refunds, returns, shipping collected, taxes collected, processor fees, chargeback fees, currency conversion, and any app or platform deductions.
The bank deposit is usually a net number. The reconciliation job is to explain the net deposit from its parts, not to pretend gross sales and bank cash should always match.
Check receipts and source evidence
Look for ad platform receipts, shipping receipts, app subscription receipts, contractor invoices, supplier receipts, and unusual owner-paid expenses. Missing evidence is often the reason the QuickBooks file feels messy later.
ArnBooks should use the checklist to help identify what is missing before the month-end review depends on memory.
Flag items that need human judgment
Tax-sensitive items, owner transactions, missing source documents, large new vendor charges, chargebacks, disputes, and unclear transfers should not be forced through a rule just because automation can guess.
A good reconciliation workflow preserves these exceptions with plain-English notes so the owner, bookkeeper, or accountant can review the right items.
Decide the next action
If evidence is complete, prepare the QuickBooks handoff. If receipts are missing, collect them before final review. If timing is the issue, document the period difference. If accounting judgment is needed, ask the bookkeeper or accountant.
If the same issue repeats each month, improve the workflow instead of solving the same mismatch again.
Sources worth reading
- Shopify bookkeeping guide — operator-level context for ecommerce bookkeeping responsibilities.
- Shopify ecommerce accounting guide — context for ecommerce accounting workflows and reporting needs.
- A2X Shopify + QuickBooks guide — public context on Shopify and QuickBooks bookkeeping complexity.
- Bookkeep Shopify payout explainer — public context on what can be hidden inside Shopify payouts.
- QuickBooks Online by Intuit — context for the ledger receiving the reviewed payout workflow.
FAQ
Why does my Shopify payout not match QuickBooks?
The payout may include sales, fees, refunds, chargebacks, taxes, and timing differences. The bank deposit is usually a net number, not the full sales story.
Should I record the Shopify payout as sales?
Do not rely on this checklist as accounting advice. The right treatment depends on your bookkeeping setup, tax handling, and QuickBooks workflow.
What is the safest first step?
Gather the payout report, bank deposit date, fee detail, refunds, chargebacks, and receipt evidence before changing QuickBooks rules.
Can ArnBooks reconcile Shopify payouts automatically?
ArnBooks should be framed as a review and workflow layer that helps identify gaps and prepare notes around QuickBooks Online.
When should I get help?
Get help when mismatches cross month-end, taxes are involved, refunds or chargebacks are unclear, or the QuickBooks file has repeated uncategorized or suspense items.
Turn the checklist into a scan
Use the mismatch scan to check payout timing, receipts, and source notes before the month-end review turns into guesswork.
Run the Shopify payout mismatch scan