How to Record Shopify Sales in QuickBooks Online and Reconcile Payouts

Record Shopify sales in QuickBooks Online as a summary per payout, not as individual orders. Connect the two with the free Shopify Connector by Intuit, map sales to an income account, Shopify fees to an expense account, refunds to a contra revenue account and collected sales tax to a liability account, then reconcile against the bank deposit using the payout date. The single most common mistake is filtering by transaction date instead of payout date, which is why your numbers never tie out.

This guide covers US stores on Shopify Payments and QuickBooks Online. If you are still choosing a ledger, the comparison of Shopify accounting software covers the whole field including Xero, Wave and the paid connectors.

Does Shopify integrate with QuickBooks?

Yes, and the official integration costs nothing extra. The Shopify Connector by Intuit is included with a QuickBooks Online subscription, and it is the method both Intuit and Shopify point their own customers to. It syncs sales transactions, refunds, Shopify Payments payouts, processing fees, sales tax by jurisdiction, customer records and inventory quantities.

There are three ways to get Shopify data into QuickBooks, and picking the wrong one is the source of most of the pain.

Notice what the second and third rows have in common. Both record a summary per payout. That is not a coincidence, and it is the shape most accountants want, because it reconciles cleanly to the bank line without hundreds of entries to match.

How to connect Shopify to QuickBooks Online

1. Install the QuickBooks Online app from the Shopify App Store, or start from inside QuickBooks under Apps.
2. Authorize it against the QuickBooks company you actually file from. If you run more than one company file, check this twice. Moving synced data later is genuinely unpleasant.
3. Map your accounts before the first sync. Sales to a sales income account. Shopify fees and payment processing to an expense account. Refunds to a contra revenue or refunds account. Collected sales tax to a liability account, never to income.
4. Turn on the setting that automatically exports Shopify Payments fees and payouts. Without it you get orders in QuickBooks with no way to tie them to deposits.
5. Set a start date, then sync one recent week only. Open the results and check that one payout in QuickBooks matches one line in your bank feed.
6. Fix the mapping now, while there are ten transactions to clean up instead of ten thousand. Then run the full backfill.

Step three is the one people skip. Booking collected sales tax as revenue is the classic error: it inflates your income, inflates your apparent profit, and produces a tax return that overstates what you earned. The tax you collect from a customer in Texas was never your money.

How to record Shopify sales in QuickBooks, entry by entry

Whether the connector does it or you type it, the shape of a correct entry is the same. Say Shopify deposits $2,143.17 on a Thursday. That deposit is the net of a batch, and the batch looks something like this.

Debits and credits balance, and the checking line equals the number on your bank statement to the penny. That last point is the whole test. If your entry does not produce the exact deposit amount, something in the batch is unaccounted for, and it is almost always a refund or a chargeback you did not know about.

A note on gross versus net that costs sellers real money at tax time. Platforms report gross on the 1099-K, not net. If you record only the $2,143.17 that landed, your books understate receipts by exactly the fee and refund total, and that mismatch is visible to the IRS while being impossible to explain from a bank statement alone. Recording the gross and the deductions separately is not bookkeeping fussiness. It is what makes the 1099-K reconcile.

How to reconcile Shopify in QuickBooks

Reconcile the bank account, not the orders. The sequence that works:

1. Pull the payout data from Shopify. For a monthly summary, use Finance > Documents > Payout Reconciliation Report. For transaction detail, use Settings > Payments > View payouts > View Transactions and export the CSV, which Shopify emails to you rather than downloading in the browser.
2. Filter by payout date. Not transaction date. This is the step that decides whether the rest of the afternoon goes well.
3. In QuickBooks, open the checking account register and start a reconciliation for the period.
4. Match each Shopify deposit to one payout in the report. The amounts should be identical.
5. For any deposit that does not match, open that single payout in Shopify and read the activity behind it before touching QuickBooks.

The two Shopify payout reports guide covers exactly what each column in those exports means, including the three-day data delay on the reconciliation report that catches people out when they pull yesterday.

Three mistakes that break the reconciliation

1. Filtering by transaction date instead of payout date. A Thursday payout settles Monday and Tuesday transactions. Pull Thursday's orders and you get sales that are in next week's deposit. The two sets overlap enough to look nearly right, which is worse than being obviously wrong, because you will spend an hour hunting a $61 gap that is really a timing difference.

2. Treating refunds as dated to the original sale. A refund is recorded when it is issued, so it can reduce a payout weeks after the order it reverses. If you are trying to make a payout match the sales from the same three days, a refund from last month will not be in your list and the deposit will come up short.

3. Forgetting money that moves without an order. Chargebacks, dispute fees, reserve holds and releases, Shopify Capital repayments and app charges all move the balance with no corresponding sale. These are the entries that make a payout look inexplicable. The payout reconciliation guide walks through each type and where it shows up.

When should I use A2X or Synder instead?

The honest trigger is volume plus a person. Below roughly a few hundred orders a month with one sales channel, the free Intuit connector plus a monthly look at the reconciliation report holds up fine, and a paid connector buys convenience rather than accuracy. Two things change the answer: your order count passing what you are willing to eyeball, or a bookkeeper billing you hourly to untangle order-level data.

A2X posts one summarized journal entry per payout, split into gross sales, fees, refunds and sales tax, at a published US$29 a month for Shopify. It prices per sales channel, so a seller running Shopify and Etsy buys two subscriptions. Synder starts at $65 a month for Basic on monthly billing with 500 synced transactions, and can sync per transaction rather than only per payout, which some accountants want and others find noisy. Link My Books does the same payout-entry job but publishes no named tiers and no fixed prices at all, only a calculator keyed to orders per month and channel count, so treat any article quoting its plan prices with suspicion.

What to do at year end

Two documents have to agree: your QuickBooks profit and loss, and the 1099-K Shopify issues. For 2026 the 1099-K threshold reverted to more than $20,000 and more than 200 transactions, with both conditions required, so smaller stores may not receive one at all. Income is taxable either way, and a form arriving or not arriving changes nothing about what you owe.

If you did receive one, the number on it is gross. Your books should show that same gross with fees, refunds and chargebacks recorded as separate deductions beneath it, and the two should reconcile without a plug figure. When you get to the return itself, that reconciled gross is the figure Schedule C wants, and a filing tool that can read the 1099 forms straight into a return saves retyping numbers you have already reconciled once.

One last thing worth setting up while the year is fresh. If Shopify is not your only channel, the deposits from Etsy, Stripe, PayPal and everything else land in the same checking account as undifferentiated ACH credits, each with a different fee structure and settlement schedule. QuickBooks records all of them correctly and still cannot tell you the gross behind any of them, because a bank feed only knows what landed. A Shopify payout tracker shows the per-payout view for this channel, and the wider multi-platform income tracker puts every platform on one board as gross, fees and take-home.