Home› Celigo› Integrations› Shopify ↔ QuickBooks
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.

01
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.
02
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.
03
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.

1
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.
2
Build
Weeks 2–3
Celigo flow configuration. DocNumber idempotency. Tax line splitting. Payout reconciliation per processor. Product mapping table. Refund and credit memo flows.
3
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.
4
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

Shopify ↔ HubSpot
View в†’
Shopify ↔ Salesforce
View в†’
NetSuite ↔ Shopify
View в†’
Shopify ↔ Amazon
View в†’
Ready to automate Shopify to QuickBooks?
Entech is a certified Celigo partner. We build Shopify QuickBooks integrations that get the accounting right — correct record types, accurate tax mapping, payout reconciliation, and zero duplicates.
Get in touch в†’