The question of how to connect Shopify to QuickBooks Online gets asked the same way it always has. The answer changed significantly in 2024 — not because the connection step changed, but because what the integration does after you connect has. WeIntegrate’s payout automation, which reached general availability in June 2024, means every Shopify payout now flows into QuickBooks as a real, assembled QBO Deposit. Not a journal entry approximating the net result. A real Deposit, with individual order documents assigned as line items and processing fees recorded as named expense lines.
If you’re setting up the Shopify-QuickBooks integration for the first time, or evaluating whether your current integration is doing what your books actually require, 2024 is a different baseline than any prior year.
The Connection and Setup — Still 10 Minutes
WeIntegrate connects to Shopify and QuickBooks Online via OAuth — no passwords shared, access revocable at any time from either platform. Once both connections are authorized, the Configuration Setup Wizard guides you through account mapping.
This step is not automatic. WeIntegrate provides the wizard structure; you supply the QBO accounts that match your chart of accounts:
- Product revenue → your income account
- Sales tax collected → your Sales Tax Payable liability account (never an income account)
- Shipping collected → your shipping income account
- Shopify fees → your designated expense account
- Customer matching → match orders to existing QBO customers, or configure auto-create and default-record rules
- Product matching → match Shopify products to existing QBO items by name or SKU, or configure auto-create and fallback rules
Ten minutes of deliberate configuration here determines how every order lands in QuickBooks from the first transaction forward. Once the wizard completes, sync begins immediately — there is no separate step to enable it. Every new Shopify order starts flowing into QuickBooks automatically from that point.
What Every Order Creates in QuickBooks
Every paid Shopify order — web store, POS, any channel — creates a Sales Receipt in QuickBooks Online the moment payment is confirmed. Not at the end of the day. Not when the payout arrives. Instantly, at the individual order level, with the Shopify order number on the document.
That Sales Receipt contains:
- Product line items → revenue posted to your income account
- Sales tax collected → posted to your Sales Tax Payable liability account
- Shipping collected → posted to your shipping income account
- Discounts → reflected as reductions against revenue
- Shopify fees → posted to your expense account as a separate line item
When a customer returns an order, a Refund Receipt appears in QuickBooks automatically — linked to the original Sales Receipt and the originating Shopify order number, with the refunded tax amount reducing your Sales Tax Payable balance. Your refund records match exactly what Shopify processed.
Customer and product matching ensure the records are properly attributed. WeIntegrate matches incoming orders to existing QBO customers by email and matches products by name or SKU, with auto-create and default-record fallbacks configured in the wizard. The document that lands in QBO is a complete, properly attributed transaction record — not a placeholder.
The 2024 Development: Shopify Payouts Now Create Real QBO Deposits
This is the change that fundamentally altered what your QuickBooks books contain.
Shopify batches fulfilled orders over a rolling period and issues a net payout to the merchant’s bank — gross sales from the period, minus processing fees, minus any refunds, minus adjustments. The net deposit arrives at the bank carrying none of that breakdown. Before WeIntegrate’s payout automation reached general availability, most integrations responded to that deposit with a journal entry: a net credit to an income account that balanced the bank statement while making every per-order detail invisible in QBO.
WeIntegrate creates a real QuickBooks Online Deposit for every Shopify payout. That deposit is assembled from the individual Sales Receipts and Refund Receipts already in QuickBooks for every order in that payout period — the same documents created at order time. Processing fees appear as dedicated expense lines on the deposit. Any adjustments, credits, disputes, or shop-cash offsets appear as their own named lines. The deposit total equals the Shopify payout total to the penny.
Bank reconciliation is one-to-one: one Shopify payout, one QBO Deposit, matched at the bank statement level. Every question about what the payout contained — which orders were included, what was earned in product revenue, what was paid in fees, what reduced the payout from refunds — can be answered from the QBO Deposit directly. No Shopify export required.
A journal-entry integration records the net number and calls it done. The detail it collapsed is not recoverable from QBO. WeIntegrate records the detail first, then assembles it into the deposit — so the deposit can explain itself.
The Payout Report
WeIntegrate’s Payout Report, launched September 2024, gives merchants and their accountants a single view of every payout’s reconciliation status. Green means the payout matched the expected amount cleanly. A flag means there’s a specific discrepancy — WeIntegrate shows the exact line causing the gap, so the investigation starts from a specific amount rather than a full ledger search.
For accountants and bookkeepers managing multiple Shopify clients, the Payout Report surfaces every payout status in one place without opening each account individually. The work of reconciling a payout becomes comparison and verification — not reconstruction from Shopify’s export reports.
Why Per-Transaction Documents Matter
A journal entry that summarizes 200 orders into a net debit and credit balances at the total level while being wrong at every account level beneath it. Revenue includes sales tax (which belongs in a liability account). Processing fees are absent (buried in the net before QBO ever saw the payout). Individual orders are not queryable because they were never individually recorded.
Per-transaction documents — a Sales Receipt for every order, a Refund Receipt for every return, a real QBO Deposit for every payout — keep all of that detail in QBO where it belongs. The Sales Tax Liability Report draws from real tax line items. The P&L shows true gross revenue and correctly classified fee expenses. The audit trail from any line on the bank statement runs back to the specific order document in seconds.
This is the accounting infrastructure that integrations built on journal entries cannot provide, regardless of how cleanly they connect.
Who This Matters For
Shopify merchants at any volume need QBO records that show gross revenue, real expense lines for fees, and sales tax in a liability account — not a net deposit that conflates all three. WeIntegrate provides that from the first order.
Accountants and bookkeepers managing Shopify clients need payout deposits already assembled and reconciled before month-end close begins. WeIntegrate’s Payout Report shows every client’s status at a glance. The reconciliation work is verification, not rebuild.
Operators evaluating their current integration should run a simple test: find a month in QBO and ask whether you can answer — from QBO alone — which orders funded a specific payout, what the processing fee burden was, and what the Sales Tax Liability Report shows compared to what Shopify collected. If those questions require leaving QBO, the integration isn’t recording what it should.
For how WeIntegrate’s Undeposited Funds configuration enables per-payout deposit assembly from individual Sales Receipts, see how to set up Undeposited Funds for Shopify payouts in QuickBooks Online.
For the Payout Report and how it surfaces reconciliation status across every payout, see how the WeIntegrate Payout Report works.
For the accounting foundation behind why per-transaction documents produce better books than daily summaries or payout journal entries, see the accounting basics every Shopify merchant needs.
For the 2022 setup guide covering the core connection and account mapping steps, see how to connect Shopify to QuickBooks Online.
Start your free 15-day trial of WeIntegrate and connect Shopify to QuickBooks Online in 10 minutes. No credit card required.