Shopify to QuickBooks: Why the Deposit Never Matches Your Sales
Shopify doesn't deposit your sales. It deposits sales plus shipping and tax, minus refunds, fees and chargebacks, bundled across several days. Most connectors sync the sales side and leave the rest for you to work out. Here's one payout broken down.
A connector app from the Shopify App Store or the QuickBooks app marketplace. The most common route: install it, authorize both accounts, and pick which accounts sales, fees and tax go to.
By hand: export Shopify's sales and payout reports and enter them in QuickBooks, usually once a month. Workable at a few dozen orders a month.
A custom sync, when you need sales split by product line or channel, real cost of goods sold, or payouts matched automatically. That's the one we build.
One payout, broken down
The top line is what Shopify says you sold. The bottom line is what reaches your bank. A connector that books daily sales as one lump entry only records the first line.
| Product sales (What a summary connector books) | $4,812.00 |
|---|---|
| Shipping charged to customers | + $318.50 |
| Sales tax collected (A liability, not revenue) | + $341.20 |
| Refunds (Often from orders in an earlier payout) | − $212.00 |
| Shopify Payments processing fees | − $151.84 |
| Chargeback | − $89.00 |
| Chargeback fee | − $15.00 |
| Deposit in your bank | $5,003.86 |
Every line has its own home in QuickBooks: sales, shipping income, sales tax payable, refunds, merchant fees. Booking the deposit as "sales" makes revenue, tax and fees all wrong at once.
Booking a payout by hand, the clean way
If you're doing this yourself today, a clearing account is what keeps it tidy. Sales go in, the deposit comes out, and anything left over is your mismatch.
- 1
Create a "Shopify Clearing" account
Settings ⚙ › Chart of accounts › NewMake it a bank-type (or other current asset) account. Shopify sales get booked into it instead of straight to your checking account.
- 2
Pull the payout breakdown from Shopify
Shopify admin › Finance › PayoutsOpen the payout that matches the deposit and export its transactions. That's your list of orders, refunds, fees and adjustments.
- 3
Record the deposit with split lines
In QuickBooks banking, open the Shopify deposit and split it to match the payout: the gross amount from Shopify Clearing, fees to Merchant fees, chargebacks and refunds to their own accounts.
Watch for: refunds and chargebacks that belong to orders from an earlier payout. They're why one day's sales never lines up with one day's deposit.
- 4
Check the clearing account balance
Once every payout is booked, Shopify Clearing should sit close to zero, apart from payouts still in transit. If it drifts, the leftover is exactly the amount you haven't explained yet.
What a connector gives you, and what your books need
Sales, summarized
- One "Shopify Sales" entry per day or per order, into one revenue account.
- Cost of goods sold estimated, or not booked at all.
- Payout matching left to you, every month.
- Wholesale, retail and other channels mixed together.
Sales you can make decisions from
- Revenue split by product line or channel, so you can see what makes money.
- Cost of goods sold from your real product costs.
- Each payout matched to its orders, fees and refunds automatically.
- Only the payouts that don’t reconcile land on someone’s desk.
A store in exactly this spot
Shopify retailer · connector installed years earlier
Sales synced into QuickBooks as one number a day. It showed revenue going up, but not whether the best-selling product line made money once real shipping and product costs came out.
Every month someone spent half a day working out why a payout didn't match the sales report.
Orders now sync itemized by product category as they come in, with cost of goods sold taken from actual product costs.
Each payout is matched against its orders, fees and refunds automatically.
The half-day reconciliation became a five-minute check of the few payouts that didn't match on their own.
Send us one payout that never matched
Tell us which connector you use (or that you don't use one) and roughly how many orders a month you get. n-frames fixes it at the right level: a settings change, a better connector, or a custom sync that matches every payout to its orders, fees and refunds.
Let's look at it →Questions people ask
Does Shopify integrate with QuickBooks?
Yes. Several apps in Shopify's App Store sync orders and customers into QuickBooks Online. They're fine for getting sales into your books. Where they usually fall short is payouts, fees and cost of goods sold.
What's the QuickBooks Shopify connector from Intuit?
Intuit and Shopify have each backed connector apps over the years that sync orders and customers between the two. What they cover has changed from version to version, so check what the current one actually does (summary entries or itemized orders, and whether it handles payouts) before assuming it covers your books.
Why is my Shopify payout less than my sales?
Because the payout has processing fees, refunds and chargebacks taken out, and shipping and sales tax added in, often across several days of orders. The breakdown above shows how it adds up.
How do I reconcile Shopify payouts in QuickBooks?
Open the payout in Shopify (Finance, then Payouts) to see the orders, fees and refunds inside it, then match that total to the deposit in your QuickBooks bank feed. A Shopify clearing account, as in the steps above, keeps it tidy. At volume this matching is what a custom sync does for you, flagging only the payouts that don't add up.
Should Shopify sales tax go into revenue?
No. Sales tax you collect is owed to the state, so it belongs in a sales tax payable account. Booking it as revenue overstates your income and understates what you owe.