← Back to Blog
guide

How to Connect Shopify to QuickBooks Online in 2025: Five Document Types for the Complete Order Lifecycle

By WeIntegrate Team September 24, 2025
Business owner analyzing financial reports on laptop, tablet, and notebook — Shopify QuickBooks Online integration five document types 2025

The full Shopify order lifecycle — from a B2B order placed on net terms to the payout landing in the bank — now maps to five distinct QuickBooks Online document types in WeIntegrate. That wasn’t true a year ago. Invoices for open-terms orders, Payments for invoice settlement, and Credit Memos for reversed invoiced orders reached general availability in 2025, completing the document set that covers every Shopify transaction type in QBO with the correct accounting treatment.

For merchants evaluating how to connect Shopify to QuickBooks Online in 2025, the question isn’t whether WeIntegrate creates real per-transaction documents — it always has. The question is which document types apply to your order mix and how the automated payout-to-deposit flow connects individual order records to your bank statement.

Setup: Still 10 Minutes, Now Covering More

WeIntegrate connects to Shopify and QuickBooks Online via OAuth — no passwords shared, revocable from either platform at any time. Once both connections are authorized, the Configuration Setup Wizard guides you through account mapping.

Account mapping is not automatic. WeIntegrate provides the wizard structure; you supply the QBO accounts that match your chart of accounts:

  • Product revenue → your designated 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/item matching → match products by name or SKU, or configure auto-create and fallback defaults

Once the wizard is complete, sync begins immediately. There is no step to enable it — the connection is live, and every new Shopify order flows into QuickBooks automatically from that point.

Five Document Types — One for Every Stage

The reason WeIntegrate’s QBO records are actionable is that each stage of the Shopify order lifecycle creates the right type of document for what happened — not a single catch-all entry for everything.

Sales Receipts record every paid Shopify order the instant payment is confirmed — web store, Shopify POS, any sales channel. Product revenue posts to your income account. Sales tax posts to your Sales Tax Payable liability account, never touching income. Shipping, fees, and discounts each land where they belong. The Shopify order number appears on every Sales Receipt.

Refund Receipts appear automatically when a customer returns an order — linked to the original Sales Receipt and the originating Shopify order number. The refunded tax amount reduces your Sales Tax Payable balance. Refund records in QBO match exactly what Shopify processed.

Invoices record B2B and wholesale Shopify orders placed on net terms, at the moment the order is placed — before payment arrives. Accounts receivable reflects what the customer owes. The sale is on the books from day one, not from the day the payment clears.

Payments settle the open Invoice when the customer pays — reducing accounts receivable, updating the Invoice status in QBO, and closing the loop between what was invoiced and what was collected.

Credit Memos reverse an invoiced order when a return is processed — reducing accounts receivable, crediting the customer account, and keeping the accrual record consistent with what was actually returned.

Every one of these document types is created automatically in response to the corresponding Shopify event. No manual entry. No journal entries approximating what the transaction was.

Payout Automation: One Payout, One QBO Deposit

Every Shopify payout automatically becomes a real QuickBooks Online Deposit, assembled from the individual Sales Receipts and Refund Receipts WeIntegrate created for that payout period. Processing fees and transaction fees appear as separate expense lines. Any adjustments, credits, or disputes appear as their own named lines. The deposit total matches the Shopify payout total exactly.

Bank reconciliation is one-to-one: one payout from Shopify, one QBO Deposit, matched at the bank statement. Every question about what the payout contained — which orders, what revenue, what fees, which refunds reduced the total — can be answered from the QBO Deposit directly. No Shopify export required.

WeIntegrate’s Payout Report shows the reconciliation status of every payout — green for clean, flagged for any specific discrepancy — without leaving the dashboard. For accountants managing multiple Shopify clients, the Payout Report surfaces every client’s status in one view. The reconciliation work is comparison and verification, not reconstruction from reports.

Conditional Sync: Control Which Orders Reach QBO

In 2025, WeIntegrate added conditional sync — rules that determine which Shopify orders sync to QuickBooks Online at all. Merchants operating across multiple sales channels, fulfillment partners, or wholesale accounts can configure sync rules so that only the orders belonging to a specific QBO company file are synced. Orders that don’t meet the conditions are tracked in WeIntegrate but not pushed to QBO.

For multi-entity operators or businesses separating their B2B and DTC accounting, this is the mechanism that makes a single WeIntegrate connection work cleanly with a structured chart of accounts.

What the Books Look Like After Six Months

Six months of WeIntegrate means six months of individually queryable QBO records. Every Sales Receipt is linked to its Shopify order number. Every Refund Receipt ties to the original. Every payout is a real QBO Deposit assembled from the order documents for that period. The Sales Tax Liability Report draws from real, per-order tax line items. The P&L shows true gross revenue and correctly classified fees.

An accountant reviewing the books can find any order from any period in seconds. A payout that arrived short explains itself through the Refund Receipts on the deposit. A sales tax discrepancy traces to the specific Sales Receipt where the gap originated.

Integrations that create journal entries — net summaries of batched orders — cannot support any of that. Journal entries balance the bank statement while making the per-order detail permanently unrecoverable.

Who This Matters For

Retail and DTC Shopify merchants need books that show gross revenue, real expense lines for fees, and sales tax in a liability account from every order — not a net deposit that conflates all three. WeIntegrate provides that from the first transaction.

B2B and wholesale operators now have the full document set: Invoices for open-terms orders, Payments when they settle, and Credit Memos when orders are reversed. The accrual accounting that wholesale operations require is no longer a workaround — it’s how WeIntegrate handles it by default.

Accountants and bookkeepers managing Shopify clients in 2025 receive QBO files where every order has a real document, every payout has a real Deposit, and the month-end close starts from a position of completeness rather than a cleanup list. The time that would otherwise go toward reconstructing what a journal-entry integration failed to record goes toward work that actually requires judgment.

Multi-location and multi-channel operators using QBO Classes for departmental or location-based reporting have class assignment available on order documents and payout line items — enabling per-location revenue and cost reporting without manual journal entry work.


For a detailed look at each WeIntegrate document type and what it records, see understanding your documents.

For the Invoices and Payments launch and how B2B order flows work in WeIntegrate, see Shopify Invoices and Payments in QuickBooks Online.

For how WeIntegrate’s payout-to-deposit automation assembles individual Sales Receipts into a reconciled QBO Deposit, see how the WeIntegrate Payout Report works.

For why per-transaction documents produce fundamentally better books than journal entries — and what each approach costs accountants and merchants over time, see per-transaction vs. journal entries for Shopify-QuickBooks Online.

For the 2024 setup guide covering payout automation as it launched, see connecting Shopify to QuickBooks Online in 2024.

Start your free 15-day trial of WeIntegrate and connect Shopify to QuickBooks Online in 10 minutes. No credit card required.

Ready to Get Started?

Connect Shopify to QuickBooks Online in 10 minutes with weintegrate .

Start Free Trial