How to Reconcile Shopify to QuickBooks Online

What you need before you start

• Admin access to Shopify (Orders, Finances, Reports)
• QuickBooks Online with bank feeds connected for the deposit account
• A spreadsheet (Excel or Google Sheets) for the working file
• The chart of accounts set up for Shopify revenue, processing fees, sales tax payable, refunds, and inventory (see our Shopify accounting guide)

Step 1: pull the monthly payouts

In Shopify admin, go to Finances, then Payouts. Filter by date range for the month you're closing. Export the payout list as a CSV.

Each payout row will show: Date, Status, Amount (the net deposit), Charges, Refunds, Adjustments, Reserved Funds, Fees. The Amount column is what hits your bank.

Step 2: pull the Finances Summary

In Shopify, go to Analytics, then Reports, then Finances summary. Set the date range to the month you're closing. Note the values for:

• Gross sales
• Discounts
• Returns
• Net sales
• Shipping charged to customer
• Taxes (collected from customer)
• Total sales

These are your top-line revenue numbers. The total sales line should equal (charges minus refunds) on the payouts report, minus any tax that Shopify collected as facilitator.

Step 3: book the monthly revenue journal

In QuickBooks Online, create a journal entry dated the last day of the month:

DR Shopify Clearing (asset) [total sales]
CR Sales, Shopify [gross sales]
CR Shipping income, Shopify [shipping]
CR Sales tax payable [self-collected sales tax only]
DR Discounts, Shopify [discounts]
DR Refunds, Shopify [returns]

The Shopify Clearing account is your in-flight account. Money sitting in Shopify, not yet deposited to your bank.

Step 4: match payouts to bank deposits

Open QuickBooks Online's Banking tab. For each Shopify payout that hit your bank in the month:

1. Find the matching bank deposit by date and amount.
2. Categorize the deposit as a transfer from Shopify Clearing.
3. Reduce Shopify Clearing by the payout amount.

The processing fees come out of gross charges before the payout. Book them as a separate journal:

DR Shopify Payments processing fees
CR Shopify Clearing

Step 5: reconcile the Shopify Clearing account

At end of month, the Shopify Clearing account should have a small balance representing orders placed in the last 1 to 3 days of the month that paid out in the first few days of the next month. This is correct accrual accounting.

If the clearing balance is larger than 3 to 5 days of normal sales, something didn't reconcile. Common causes: a payout you didn't match to a bank deposit, processing fees not booked, a refund booked twice, a marketplace-facilitator sales tax journal entry that didn't net to zero.

Step 6: handle sales tax correctly

This is where most reconciliations break. There are three buckets:

• Self-collected sales tax (your nexus states, direct checkout orders). Sits in Sales tax payable until you remit. Reduces when you pay the state.
• Shopify-facilitated sales tax (Shop Pay or Shop app orders in facilitator states). Net zero in your books because Shopify collected and remitted. Should not flow to your Sales tax payable.
• Marketplace-facilitated sales tax (if you also sell on Amazon, Walmart, eBay). Net zero in your books for those marketplaces. Don't include in your Shopify reconciliation.

Mixing these creates the most common error in Shopify books: over-reporting sales tax liability, then under-reporting it after the next return filing reduces the wrong amount.

Step 7: COGS at month-end

If you use periodic inventory: at month-end, count or pull a system snapshot of on-hand inventory and adjust COGS for the period:

DR COGS, Shopify [beginning inventory + purchases minus ending inventory]
CR Inventory asset, Shopify

If you use perpetual inventory with a system like ConnectStock: COGS posts automatically per unit sold, at FIFO landed cost. No month-end calculation needed.

How long this takes

Manually, expect 2 to 4 hours for a single-Shopify-store operation under 500 orders per month. Past 1,000 orders per month or with multi-location inventory, the time investment grows past 6 hours and the error rate increases. Most sellers move to an automation past that threshold.

What's the most common Shopify-to-QBO reconciliation error?

Mixing marketplace-facilitator sales tax with self-collected sales tax. Both end up in the same Sales tax payable account, then the state filing reduces the wrong amount, then the books carry a phantom liability for years.

Should I use a clearing account or post directly to revenue?

Clearing account. Always. Direct posting hides the timing gap between sale and payout and makes month-end reconciliation impossible to verify.

Can I just use the Shopify QuickBooks Online sync?

The native Shopify Connector for QuickBooks Online creates per-order entries, which is unusable for any seller past about 100 orders per month. It also doesn't handle marketplace-facilitator sales tax separation. Most ecommerce bookkeepers turn it off.

Take Control of Your E-Commerce Business with ConnectBooks

Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.

Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo