Shopify ↔ QuickBooks Online on Celigo

Shopify QuickBooks integration on Celigo — stop re-entering orders into your accounting

Every Shopify order that gets manually entered into QuickBooks is a bookkeeper hour wasted and a data entry error waiting to happen. Entech builds Celigo integrations that push Shopify orders to QuickBooks automatically — with the right record type, the right tax mapping, and Shopify Payments payouts reconciled to bank deposits without manual matching.

Talk to an integration expert →

What you get

What this integration does

The core outcome: Shopify orders flow into QuickBooks automatically. Payouts reconcile to your bank account. Refunds create credit memos. Your bookkeeper stops re-entering data.

Shopify

Order paid

→

QuickBooks Online

Sales Receipt created with line items, customer, shipping, tax, and discount — matched to the Shopify Order ID as the QBO DocNumber for idempotency

Shopify

New customer created

→

QuickBooks Online

Customer record created or matched by email — name, email, billing address synced; duplicate check prevents creating two QBO customers for the same buyer

Shopify Payments

Payout deposited to bank account

→

QuickBooks Online

Bank Deposit created covering all orders in the payout period; Shopify processing fees recorded as an expense line against your payment processing account

Shopify

Refund issued

→

QuickBooks Online

Credit Memo or Refund Receipt created and linked to the original transaction — restores inventory quantity if QBO inventory tracking is enabled

QuickBooks — optional

Product/item catalog

→

Shopify

QBO items kept in sync with Shopify products — ensures Sales Receipts reference valid QBO items for accurate P&L reporting by product

Field-level detail

What data moves and how

Celigo's Shopify and QuickBooks Online connectors handle OAuth2 authentication. Entech configures the record type logic, tax mapping, fee handling, and chart of accounts mapping for your specific QBO setup.

Sales Receipt vs Invoice — why it matters

Shopify paid orders should create QuickBooks Sales Receipts — not Invoices. A Sales Receipt records a completed, paid transaction. An Invoice creates an accounts receivable balance expecting future payment. If you create Invoices for Shopify orders that are already paid, your QBO balance sheet shows inflated AR that doesn't exist. Entech configures the correct record type during discovery — most DTC stores use Sales Receipts; B2B stores with net terms may use Invoices for specific customer types.

Shopify Payments payout reconciliation

Shopify Payments consolidates multiple orders into a single payout every 1–3 business days, net of processing fees. The Celigo flow maps each payout to a QBO Bank Deposit — with individual order Sales Receipts as the deposit line items — and records Shopify's processing fee as an expense against your Payment Processing Fees account. This makes your QBO bank register match your actual bank statement without manual splitting or journal entries.

Tax line mapping

Shopify collects sales tax line items per order. In QuickBooks, that tax amount needs to map to your Sales Tax Payable liability account — not to revenue. Entech configures the Celigo transformation to split the Shopify order total into subtotal (revenue account), shipping (shipping income account), tax (sales tax liability), and discount (discount expense account). This keeps your QBO P&L and balance sheet accurate without a separate month-end tax journal entry.

Product → QBO item matching

QuickBooks Sales Receipts require a valid QBO Item on each line to post to the correct income account. Shopify line items carry product and variant names that rarely match QBO item names exactly. Entech builds a product mapping table — by SKU or by a custom field — that links Shopify products to QBO items. Products without a match route to an unmapped product queue for review, not a catch-all "General Sales" line that obscures revenue by product category.

What makes this hard

Where Shopify QuickBooks integrations go wrong

The basic order sync is straightforward. These are the accounting accuracy problems that surface in month-end close if the integration isn't configured correctly.

Duplicate transactions from retries

If a Celigo flow fails mid-run and retries, it can create a second Sales Receipt for the same Shopify order. QuickBooks doesn't prevent duplicate records by default — it will happily accept two Sales Receipts for the same order. Entech uses the Shopify Order ID as the QBO DocNumber (a unique reference field in QBO) so that any retry finds the existing record rather than creating a new one. This idempotency design is non-optional for a production integration.

Third-party payment processors alongside Shopify Payments

Stores that accept PayPal, Klarna, Afterpay, or other payment methods alongside Shopify Payments receive payouts from multiple processors on different schedules with different fee structures. Each processor needs its own payout reconciliation logic in Celigo — a separate deposit flow that maps to the right QBO bank account and expense account for that processor's fees. Entech audits all active payment methods during discovery and builds a separate payout flow per processor.

QBO's 500-request-per-minute rate limit at scale

QuickBooks Online's API is throttled at 500 requests per minute per company. For high-volume stores processing hundreds of orders per hour, a naive order-by-order sync approach will hit this limit. Entech configures Celigo's batch processing to pace the API calls within QBO's limits, implements exponential backoff on 429 responses, and uses Celigo's error queue to safely retry throttled requests without data loss or duplicate records.

Implementation

Typical project timeline

A standard Shopify QuickBooks Online integration runs 3–4 weeks. High-volume stores, multi-currency setups, or businesses with complex chart of accounts structures run 4–6 weeks.

Discovery

Week 1

QBO chart of accounts review. Payment processor audit. Record type decision (Receipt vs Invoice). Product-to-item mapping. Historical data scope. Tax setup review.

Build

Weeks 2–3

Celigo flow configuration. DocNumber idempotency. Tax line splitting. Payout reconciliation per processor. Product mapping table. Refund and credit memo flows.

UAT

Week 3–4

Full cycle testing: order → Sales Receipt → payout deposit. Refund and credit memo. Duplicate prevention test. Bookkeeper review of QBO output against Shopify source data.

Go-Live

Week 4–5

Historical order import (configurable lookback window). Production cutover. First payout cycle monitored. Bank reconciliation validation with your bookkeeper.

Related work

Other integrations we build

Questions

Frequently asked questions

Does Celigo support Shopify QuickBooks Online integration?

Yes. Celigo has native connectors for both Shopify and QuickBooks Online. Entech configures flows for order-to-sales-receipt sync, customer sync, Shopify Payments payout-to-bank-deposit, product-to-item sync, and refund-to-credit-memo. The integration is built on Celigo's certified QBO connector using OAuth2 — no third-party apps in the middle.

Should Shopify orders create QuickBooks invoices or sales receipts?

For most ecommerce businesses, Shopify paid orders should create QuickBooks Sales Receipts — not Invoices. A Sales Receipt is for immediate payment (which Shopify orders are), while an Invoice is for payment due later (net terms). Creating Invoices for Shopify orders results in accounts receivable that is already collected, which distorts your QBO balance sheet. Entech configures the correct record type for your business model during discovery.

How does Shopify Payments sync to QuickBooks?

Shopify Payments pays out every 1–3 business days as a lump sum covering multiple orders minus Shopify's processing fees. Celigo maps each payout event to a QuickBooks bank deposit, with individual order line items making up the deposit total and Shopify's fees recorded as an expense line. This keeps your QBO bank register reconcilable against your actual Shopify Payments bank account without manual matching.

How are Shopify taxes handled in QuickBooks?

Shopify collects and remits sales tax in most US states through Shopify Tax. In QuickBooks, tax collected needs to be mapped to the correct tax liability account. Entech configures the tax line from each Shopify order to flow into the right QBO tax account — so your sales tax liability is accurate without manual journal entries. For international businesses with VAT, we configure the equivalent mapping for your QBO tax setup.