How to Use the Shopify Connector App in QuickBooks Online

The Shopify connector is the app that ties a Shopify storefront to QuickBooks Online. It moves products, sales, refunds, and Shopify Payments payouts into your books with very little typing. We cover setup, the payout flow, and the snags that trip most new users.

What does the connector sync?

Products, first. New Shopify items can be created in QuickBooks, or matched to existing ones by SKU. Orders come across as sales transactions, with refunds and processing fees on their own lines. Shopify Payments payouts post as single deposits. Customer records are optional, and many firms leave them off to keep the list lean. The connector covers Shopify only; other sales channels need their own apps.

What do you need before you start?

A QuickBooks Online subscription, since this is an online app with no Desktop equivalent. Admin access to the Shopify store, so you can approve the connection. A bank account in your books that mirrors where Shopify actually sends payouts. And a cut-off date: stop any manual sales entries from that point so nothing posts twice. The connector itself carries no separate subscription from Intuit at the time of writing.

How do you connect the store?

1. Open the Apps area in QuickBooks Online and search for the Shopify connector.
2. Install it, then enter your store address exactly as it appears in Shopify’s settings.
3. Approve the connection from your Shopify admin when prompted.
4. Choose what syncs: products, orders, and payouts at minimum.
5. Map the accounts where sales income, fees, refunds, and payouts should post.
6. Run a first sync over a short window, and review it before extending.

How are sales recorded as orders come in?

Paid orders typically post as sales receipts. Orders awaiting payment post as invoices, then close when the money clears. Refunds post as refund receipts, and processing fees post separately. That separation is deliberate: it is what lets the payout reconcile later.

How do payouts reach your books?

Shopify does not send each order’s money separately. It lumps a period of takings into one payout, minus fees, refunds, and adjustments. The connector mirrors that flow. Gross sales post as orders sync, fees and refunds post on their own lines, and the payout arrives as one deposit that should match your bank feed. Match that deposit when it clears. Selling in multiple currencies can leave small conversion differences.

Where do you manage the sync day to day?

Settings live under Apps in QuickBooks Online. The dashboard shows whether the last run succeeded and flags orders stuck in error. You can pause syncing, retry a failed batch, or disconnect entirely. Pause before big changes, such as switching accounts or closing a period. Careless disconnect and reconnect cycles are a common cause of duplicated history.

What usually goes wrong, and what can you fix?

• Duplicated sales, usually after manual entries overlap the sync or after a reconnect. Set a clean cut-off, review the overlap, and delete only what you can confirm twice.
• Payouts that miss by a little, often from app-based fees, disputes, or currency conversion. Compare the payout breakdown in Shopify with the deposit line, then adjust in your books.
• Duplicate products from SKU mismatches. Align the SKUs in both systems, then rematch the items rather than re-importing.
• Stuck orders, typically a missing product or a locked accounting period. Fix the cause, then resync the failed batch from the dashboard.

Start small, then extend

Connect with a short history window rather than the store’s whole life. Sync a week or two first. Then check one payout end to end: gross sales, fees, refunds, and the deposit. When that reconciles exactly, extend the sync backward and let routine take over. One clean payout is the fastest proof your settings are right.