QuickBooks Reconciliation for Shopify POS: Payouts, Cash and Fees

To reconcile Shopify POS in QuickBooks Online, treat card sales and cash sales as two streams. Card sales paid through Shopify Payments arrive in a payout. Confirm the sales and fees in the Shopify Connector by QuickBooks, then confirm the payout so QuickBooks builds one deposit. Then Match that deposit in your bank feed. Cash never enters a payout, so it needs its own deposit, built from your register session totals. Most “won’t reconcile” problems come from mixing the two, or from adding a deposit by hand in the bank feed.

This guide is for a single-store business in the US or Canada with one register, a Shopify store and a QuickBooks Online account. Why it matters: a business that cannot reconcile cannot trust its financials, its taxes or its margins. Clean books also help you stay organized at tax time.

Can Shopify and QuickBooks work together?

Yes. The Shopify Connector by QuickBooks is the native QuickBooks integration. It brings Shopify transactions, fees, refunds and payouts into QuickBooks Online. Third party apps such as A2X are the other way to integrate Shopify, covered below.

QuickBooks Shopify POS reconciliation: the two streams

Money	How it reaches the bank	What QuickBooks needs
Card and tap at the register (Shopify Payments)	Shopify payout, net of fees	Connector sales receipts and fees, then the payout deposit
Online orders (same processor)	Same payout as POS cards	Same as above; both sales channels share deposits
Notes and coins at the register	You carry them to the bank	A manual bank deposit that matches your session close
Outside card terminal	That processor’s own deposit	Its own deposit, matched to its batch report
Gift cards sold	Not revenue until redeemed	A liability account, which the Connector maps

Connect Shopify integration to QuickBooks Online

You need a QuickBooks Online account, your myshopify.com address, your Shopify account login, and app permissions.

Intuit’s steps to integrate Shopify:

In QuickBooks Online, go to Integrations and select Explore integrations.
Find the Shopify Connector by QuickBooks and select Get integration now.
Enter your Shopify store URL, select Connect, sign in to Shopify and authorize.
On the settings page, set the options below and select Sync now.

The first import of your Shopify store data can take 10 minutes to 3 hours.

Settings to choose before the first sync

Transaction sync date. How far back to import, up to 12 months.
Deposit account. The bank account where Shopify payouts land.
Payments account. Used when you owe Shopify money.
Add transactions automatically. Posts high-confidence transactions without review. Leave it off for the first month.
Product Tracking. Matches product data to QuickBooks inventory items by SKU and name. With it off, every sale uses the default Shopify Sales Item, and inventory reports lose detail.
Customer Tracking. Syncs customer information. With it off, sales use a default Shopify Customer.

A single store rarely needs Customer Tracking; it adds thousands of walk-in customers to your QuickBooks account.

How the Connector books Shopify sales

Each confirmed payment becomes a Sales Receipt with the gross amount, shipping, discounts, taxes and products. The transaction type shows as Payment Received. Fees become an Expense. Both sit in a clearing account, Undeposited Funds or Payments to deposit, until the payout.

That is how the Connector can automatically create entries that record Shopify fees per sale. All the fees go to one account for Shopify fees.

The Connector also creates default accounts for adjustments, reserve balance, tips, gift card liability, and holds and disputes. Review each one in App Settings before you confirm anything.

Refunds, gift cards, tips and invoices

Refunds import as their own transactions, with amount, taxes and products; partial refunds work the same way. Gift card sales post to a liability account. Tips go to a Tips account. Discounts sit on each sales receipt.

B2B orders import as an invoice linked to a company customer. Each invoice still needs its invoice payment confirmed.

Reconcile Shopify payouts, step by step

Intuit’s order, which you should not change:

Open Integration transactions. In For Review, work the Confirm list and the Review list.
Make sure all transactions in the payout show as Categorized, and every line under Funds in this payout has an account.
Confirm the Payout. QuickBooks creates a bank deposit that moves the net payout from the clearing account to your Deposit account.
Go to Bank transactions, select the deposit account, and select Match on the suggested deposit.

Intuit’s warning is the one to tape to the monitor: do not add the deposit by hand. That books the money twice and breaks the reconciliation process.

When the payout and the bank disagree

Shopify’s payout page gives you the transaction details. Go to Finance > Payouts, click the payout date, then Export > Export payout transactions. Columns include transaction type, order, amount, fee and net amount.

Webgility’s guide lists the usual reasons Shopify payouts differ from what QuickBooks shows: fees, refunds, chargebacks, reserves and timing. Shopify payouts can also bundle refunds from earlier sales. One chargeback with no account leaves a gap that grows.

A payout marked Deposited can take 1 to 3 business days to reach your bank. Match on the bank date, so the final deposit lines up with the bank statements.

Drawer takings: the deposit QuickBooks cannot build for you

The Connector’s help pages do not cover POS cash. In our accounts, these Shopify POS sales import as sales receipts, then sit in the clearing account with no payout to clear them.

The clean routine for one register:

Close the register session each night.
Take the notes and coins above your float to the bank.
In QuickBooks Online, create a bank deposit that pulls those sales receipts out of the clearing account.
Match it to the bank line when it posts.

If the drawer was over or short, record the difference to an over/short expense account in the same deposit. Do not edit the sales receipts to force a match.

Does QuickBooks have a reconciliation tool?

Yes. Intuit’s help page describes the Reconcile tool in QuickBooks Online. Once payouts and deposits are matched, reconcile the bank account against your statement.

Go to Accounting > Reconcile and pick the account.
Enter the ending balance and ending date from your statement.
Select Start reconciling and tick each transaction on the statement.
Keep going until the Difference shows $0.00, then select Finish now.

Intuit suggests reconciling every month. Finishing with a difference creates an adjusting entry, so talk to your accountant first.

Month-end with the Shopify Payments activity report

Since August 22, 2026, Shopify offers a payments activity report under Finance > Documents. For any date range it shows starting balance, gross activity, fees, payouts received and ending balance.

Use it at month end to check the financials against Shopify data: does the processor balance in your QuickBooks records match Shopify’s? It follows payout timing, so sales reports will differ.

Shopify’s Finance reports and analytics draw a second line: payments reports show funds received, not revenue, so they never match your financials.

GST/HST and US sales tax in the Connector

Intuit’s guide splits taxes two ways, and the integration handles each differently:

Merchant-liable tax (GST/HST, PST, QST or state sales tax you collect) is recorded on the sales receipt and posted to the tax agency account.
Marketplace tax (tax Shopify collects on Shop app sales) goes to Sales Tax Payable and is adjusted at payout.

If Automated Sales Tax is off, the default Shopify Sales Tax Item is used for taxes on every Shopify store sale. For a Canadian business, check that sales post to your province’s tax codes.

Sales tax is not revenue

Sales tax you collect belongs to the government, not the business. In QuickBooks it sits in a liability account until you remit it. If taxes land in income, your financials and taxes owing both look wrong.

Shopify’s Canada sales tax report gives a province summary to check against your QuickBooks tax reports.

Other payment gateways: PayPal and outside terminals

Intuit’s guide describes payouts from Shopify only. Payment gateways such as PayPal deposit on their own schedule, with their own fees. Treat each of your payment gateways as its own clearing workflow, as Webgility’s guide recommends.

An outside card terminal works the same way. Shopify shows orders marked paid with “Other” as Manual. Reconcile those against the terminal’s batch and bank deposit.

Accounting software that automates reconciliation

The Connector posts one sales receipt per payment. Some accountants prefer one summary per payout. Accounting software apps take that route and automate the mapping of transactions, refunds and taxes.

App	Approach	Notes from the vendor
A2X	One summary entry per payout	Separate entries per gateway such as PayPal; Assisted Setup maps accounts and taxes; splits POS and online
Synder	Daily summary or per transaction	Sales tax mapping; payouts auto-match; from $65 USD a month
Xero & QuickBooks Smart Sync	One invoice per payout	Claims one click reconciliation in QuickBooks; from $9 USD a month
Webgility	Full payout detail	Syncs every order, fee and payout to automate reconciliation

A2X says its summary data covers the exact period of a payout, so it matches the deposit in your bank. These are the vendors’ own claims. Test any accounting software on one month of transactions first, and integrate Shopify only once.

When the Connector is enough

For one register and Shopify Payments only, the free integration is enough. An app pays off when you add PayPal or more sales channels, such as a marketplace. Its value is making reconciliation faster, not new rules for the business.

How often to do reconciliation

Confirm Connector transactions and data weekly, and reconcile the bank monthly. Small batches of transactions isolate errors. Making reconciliation weekly beats a year-end scramble for the business. A 15-minute weekly routine keeps accounting data clean and helps you stay organized.

Worked example: one week for one store

A Canadian gift shop takes $6,200 at the register in a week: $5,100 by card and $1,100 in notes and coins. Online orders add $1,400.

Shopify pays out $6,310 across five Shopify payouts, a net payout after $190 in fees and two small refunds.
The owner confirms each payout in the Connector. QuickBooks builds five deposits, and each one matches in the bank.
The owner deposits $1,080 from the drawer on Friday, $20 short against the session totals.
In QuickBooks, a deposit pulls $1,100 of sales receipts from the clearing account. A $20 line goes to over/short.
Undeposited Funds returns to zero.

Reconciliation problems: cause-to-fix table

Symptom	Likely cause	Fix
Deposit appears twice	Deposit added from the bank feed by hand	Undo the manual add, Match to the Connector deposit
Payout will not confirm	A sale still in For Review, or an adjustment with no account	Categorize Shopify transactions and map every adjustment
Undeposited Funds keeps growing	Drawer sales never deposited	Build a bank deposit after each bank run
All sales use one item	Product Tracking off or SKUs unmatched	Turn it on; create missing inventory
Duplicate sales	Sales entered by hand before the sync	Exclude the imported transactions for that period
Fees do not match	A fee or refund mapped to the wrong account	Check the correct accounts in App Settings

What Shopify’s native route does not cover

Drawer takings. No payout, no automatic deposit. You build it.
An outside card terminal. Its money comes from another processor.
Multi-currency. Intuit’s Connector pages do not address it. If you take USD in a Canadian business, deposit and book it separately, with its own taxes.
Store-level splits. The Connector books by payout. For store and online revenue on separate lines, use Shopify’s Is physical storefront analytics filter and journal it monthly.

QuickBooks and Shopify POS FAQ

Is QuickBooks POS being discontinued?

It already was. Intuit discontinued QuickBooks Desktop Point of Sale 19.0 and its connected services on October 3, 2023. Intuit names Shopify POS as a migration partner, and Shopify says customers, vendors, products and locations can move across.

Why do CPAs not like QuickBooks Online?

In our experience, the complaint is rarely the QuickBooks Online software itself. It is clutter from per-sale syncing and uncategorized transactions left for months, which hurt reconciliation. Summary posting and a weekly review answer most of it.

Do I need a bookkeeper?

Not to run the routine above. A bookkeeper helps with monthly reconciliation, taxes and year end.