Shopify QuickBooks Integration
Built for Clean Books

Yes, through an app. Shopify doesn't connect to QuickBooks Online on its own, so the link runs through one of three kinds of integration: Intuit's free Shopify connector, summary apps that post a daily or per-payout total, or an order-level integration like the one MerchFace is building.

Which one fits depends on your volume and on what your books need. A small store with a simple catalog is often well served by a free connector. Once you sell wholesale, track inventory in QuickBooks, or spend hours each month matching payouts to orders, an order-level integration with mappings you control pays for itself.

Use sales receipts for most orders. A sales receipt records a sale that was paid at the time of purchase, which is what a normal Shopify checkout is. Use invoices for orders paid later, such as wholesale or B2B orders on net terms or draft orders sent for payment, because an invoice opens a receivable until it is paid.

Many stores need both. MerchFace's connector is built to let you choose by sales channel or order type, so retail orders post as sales receipts and wholesale orders as invoices in the same QuickBooks company.

Post each sale to a clearing account (Undeposited Funds or a dedicated Shopify clearing account), not straight to your bank. When Shopify pays out, record one deposit from that clearing account to your bank for the payout amount, with Shopify Payments fees, refunds, chargebacks, and adjustments as separate lines.

The deposit then matches the transaction in your bank feed exactly, and processing fees land in their own expense account instead of being buried in net revenue. Sales tax collected goes to its liability account, not to income.

Yes, with two conditions. QuickBooks Online tracks inventory quantities only on the Plus and Advanced plans, and each Shopify product needs a SKU that matches an inventory item in QuickBooks.

Pick one system as the source of truth for stock and sync quantities in one direction: usually Shopify for a store that sells mostly online, or QuickBooks when purchasing and receiving happen there. Selling a tracked item in QuickBooks also posts its cost of goods sold, so gross margin is right without month-end journal entries.

Duplicates usually come from a sync that retries without remembering what it already sent, or from two tools posting the same orders. Missing orders usually come from a mapping that fails quietly: a product with no matching QuickBooks item, a tax rate with no equivalent, or a customer record that cannot be created.

The fix is to record each Shopify order ID against what it created in QuickBooks, so a retry updates instead of duplicating, and to report every failure with its reason so nothing goes missing silently. Run one integration at a time, and switch the old one off before connecting a new one.

Early access covers QuickBooks Online. QuickBooks Desktop and Enterprise connect differently, through the QuickBooks Web Connector running on a computer on your network, so we set those up as a custom integration project.

Book a call and we'll tell you what's involved for your setup.