QuickBooks Shopify reconciliation

Reconcile Shopify to QuickBooks so the payout finally ties to the bank.

The deposit Shopify sends you is never your order total: Shopify Payments takes its fee first, refunds and chargebacks come off, and one payout covers many orders across a pay period. We book gross sales, fees, and sales tax through a clearing account, then match the net payout to the deposit — so every batch reconciles and your revenue is honest.

Call (850) 842-6767 Get your free review

Last reviewed October 2026 by a Certified QuickBooks ProAdvisor

Gross sales booked, not just the net deposit
Fees, refunds, and tax broken out
One specialist — never a rotating pool

What QuickBooks Shopify reconciliation really means

Shopify reconciliation means proving that the money Shopify deposited into your bank matches the sales your store actually made — after every fee, refund, and timing lag is accounted for. Shopify is an ecommerce platform where orders arrive all day at their full gross value, but the cash that reaches your bank has already been reduced by Shopify Payments' processing fee and by any refunds or disputes, and it arrives on a payout schedule that batches many orders together. The gap between those two numbers is where most Shopify books go wrong.

The usual failure is simple and quiet: the net Shopify deposit gets booked straight to a "sales" account. That single shortcut buries the processing fees, hides the sales tax you collected inside your revenue, makes refunds invisible, and guarantees the bank reconciliation never quite ties. None of it is the store owner's fault — it is what happens when a merchant payout is treated like an ordinary deposit. This page walks through the mechanics we actually apply to fix it. It is one channel-specific lens on the same discipline as a full QuickBooks cleanup, pointed at a Shopify store's books.

Why your Shopify payout never equals your order total

The core problem is the gap between the gross order total a customer paid and the net payout that lands in your bank — and that gap is two things stacked together: fees and timing. Fees are the amount Shopify Payments deducts before it deposits. Timing is the fact that a payout settles a day or more after the sale and usually bundles many orders from a pay period into one deposit.

Walk one order through it. A customer pays the gross total — the product price, any shipping you charged, and the sales tax you collected, less any discount. Shopify Payments then deducts its processing fee. If that order was refunded or disputed, that comes off too. What remains is grouped with every other order settling in the same pay period and sent as a single payout. So the deposit on your bank statement is the gross of a batch of orders, minus fees, minus refunds, arriving after the fact — which is why it can never match a single day's sales figure, and why matching it by eye is hopeless. Reconciliation exists precisely because that arithmetic is invisible from the bank line alone.

How to book gross sales, fees, and the payout with a clearing account

Shopify payout reconciliation

Read this as text

Left: a Shopify order at gross broken into product sales, sales tax collected, and shipping, then reduced by Shopify Payments processing fees and by refunds. Right: each piece routed to its account in QuickBooks — sales to income, tax to a liability, the balance through a Shopify clearing account, fees to an expense — and the net payout reconciled to the bank deposit, marked with a verified tick. Amounts are illustrative, not a measured statistic.

A Shopify payout is not one number: gross sales, tax, and shipping route to their accounts, fees and refunds come off through a clearing account, and the net payout finally ties to the bank deposit — which booking the net deposit as "sales" never does. Amounts and line names are illustrative.

The technique that makes a Shopify payout reconcile is a clearing account — a holding account that sits between your sales and your bank. Orders post into it at gross, the fees and refunds reduce it, and when the real payout hits the bank you move that net amount out of clearing into the bank account. If every piece is recorded, the clearing account nets to zero once the payout arrives; whatever is left in it is money Shopify is still holding.

Read left to right, that is the whole method: gross sales, tax, and shipping post to their own accounts; the Shopify Payments fee posts as an expense; refunds and chargebacks reduce the total; and the net that remains is the payout, matched to the deposit on the bank statement. When one payout is built that way, every payout after it reconciles the same way. Getting the underlying accounts right is the foundation, which is why a QuickBooks cleanup is so often where a drifted Shopify file starts.

How Shopify payments processing fees post in QuickBooks

Processing fees are recorded as an expense, against gross sales — never by shrinking the sales figure down to the net deposit. Shopify Payments deducts its fee before it deposits, so the money never appears in your bank as a separate line; it is simply missing from the payout. If you book only what arrived, your revenue looks smaller than it was and your fee cost disappears entirely, which distorts both the top line and the margin.

The correct entry records the full order value as income and the fee Shopify took as a merchant-fee expense, so the profit-and-loss shows both what you sold and what the fee cost. We do not assert a fee percentage on this page — the rate depends on your Shopify plan and your agreement, and quoting one would be a guess. What matters mechanically is that the actual fee Shopify reports on each payout is the fee we record, every time, so the fee expense on your books matches reality rather than an assumed rate.

How refunds and chargebacks reduce a Shopify payout

Refunds and chargebacks both pull money back out of a payout, so both have to be recorded — and when either is skipped, the payout won't tie and the clearing account won't clear. They are not the same event, though, and treating them identically hides useful information.

A refund is you returning money to a customer; it reverses part or all of a sale and reduces the payout it settles against. A chargeback is a customer disputing a charge through their card issuer, reversed through the card networks, and it can carry its own fee on top of the reversed amount. Booked properly, a refund reduces sales and a chargeback reduces sales while its fee posts as an expense — so your net revenue is honest and the deposit still reconciles. Left out, they are the classic reason a Shopify bank reconciliation is off by an amount nobody can find. This is the same in-transit and adjustment discipline described in our bank reconciliation guide.

How the sales tax Shopify collects reconciles in QuickBooks

Sales tax that Shopify collects on an order is not revenue — it is money you hold on behalf of a tax authority — so it posts to a sales-tax liability, never to income. When the net payout gets booked straight to sales, that collected tax is silently mixed into revenue, which overstates what you earned and leaves the liability you actually owe untracked.

What we do is keep the collected tax coded to its liability consistently, and reconcile that liability to what gets remitted, so the amount you owe is always visible and always ties. Whether a given sale is taxable, which jurisdictions you have to collect for, and the return itself are positions for you and your CPA to set — Shopify's tax settings and your CPA decide the treatment; we make QuickBooks reflect it accurately. We keep the books; we do not file the return or decide the tax position.

How payout timing creates the deposit-versus-order gap

The month-end timing gap

Read this as text

A worked example with illustrative amounts: orders earned at the end of the month post $1,150.00 net into the Shopify clearing account, which holds it as the in-transit balance when the month closes; the payout of the same $1,150.00 arrives days later in the new month and returns the clearing account to zero. Revenue lands in the period it was earned while the bank shows only cash that moved. Illustrative, not a measured statistic.

A payout that straddles month-end still ties: the net of the orders sits in clearing as the visible in-transit amount, and the deposit clears it to zero when it lands — revenue in the right period, cash on its real date. Amounts are illustrative, not a measured statistic.

Payout timing is the second half of the gap, and it is the one that quietly breaks a month-end close. Shopify Payments settles on a payout schedule, so the cash for today's orders lands in your bank a day or more later, and one payout usually bundles orders from across a pay period. That means at any month-end, some sales have been earned but their cash is still in transit.

The clearing account is what keeps that honest. Orders recorded during the month sit in clearing until their payout arrives, so revenue lands in the period it was earned while the bank only ever shows cash that actually moved. The clearing balance at month-end is the in-transit amount — the money Shopify is holding but hasn't paid out — which is a real number you can point to, not a mystery discrepancy. When several processors are in play, each payout stream gets its own clearing account so a Shopify Payments deposit and a third-party gateway deposit never get tangled. It is the same in-transit discipline any clean bank reconciliation relies on. And if you also sell on a marketplace, the batching takes a different shape there — settlement reports, reserves, FBA fees — which is why decomposing Amazon settlements into QuickBooks gets a walkthrough of its own.

How it goes

How a Shopify reconciliation engagement starts

Whether you need a one-time catch-up or ongoing monthly work, the shape is the same: a free review, a pass to set up the clearing account and mapping, reconciliation of the payouts to the bank, and a handback. Stores months behind start with a catch-up; stores that are current move straight to a clean monthly rhythm.

Free review
Day 0
View-only look at the file: how payouts, fees, and tax are posting today, and how far behind the reconciliation is.
Set the structure
Week 1
A clearing account per payout stream, gross-sales mapping, and fee, refund, and sales-tax accounts set correctly.
Reconcile
Weeks 1–2
Each payout split into sales, fees, refunds, and tax and tied to the bank deposit; the sales-tax liability reconciled.
Hand back or run it
Ongoing
A file that ties, a written summary of what changed, and either a handback or ongoing monthly bookkeeping.

Illustrative day numbers. Your written scope sets the schedule.

See how it works

What changes

Shopify books reconciled right vs. left as net deposits

A file built for Shopify shows gross sales, breaks out fees and tax, and ties each payout to the bank; a file that books net deposits hides all of it. Here is the difference line by line.

Reconciled Shopify books vs. net-deposit shortcut
	Reconciled properly	Booked as net deposits
Gross sales recorded at full order value
Shopify Payments fees shown as expense
Refunds and chargebacks recorded
Sales tax coded to a liability
Payout matched through a clearing account
In-transit balance visible at month-end
Bank deposit ties to the penny
Verdict	A file you and your CPA can trust	Revenue and fees nobody can see

The source documents and the connector

Reconcile from Shopify's own records: the Payouts report (each payout and the orders, refunds, fees and adjustments inside it) and the finance summary for the period. A payout that doesn't tie usually hides a Shopify Capital repayment, a chargeback, or taxes withheld before the deposit.

Intuit's own connector. Intuit's Connect Shopify to QuickBooks Online article (updated August 2026, checked October 2026) says it imports each order as an individual sales transaction and each refund individually, records fees as separate expenses, groups each payout with its sales, fees and adjustments, holds confirmed sales in Undeposited Funds (Payments to Deposit) until the payout arrives, uses a payments account — typically a card — for negative payouts, and can import up to one year of history. Summary connectors post a daily journal instead. Pick one route — two connectors, or a connector plus manual entry, is how sales land twice.

Whatever the route: the payout lands in a clearing account first — every sale posted gross, every fee, refund and adjustment as its own line — and the bank deposit is matched to the payout, never added a second time. Gift cards sold are a liability until redeemed, not income, and inventory sold through Shopify needs its cost reaching cost of goods sold in QuickBooks.

What it costs

What Shopify reconciliation costs

Real ranges depend on order volume, payout streams, and how far behind the books are. The floors shown are published starting points; a free review sets your scope.

Shopify reconciliation pricing
Engagement	Starting price	Planned timeline	What's included
Shopify cleanup / catch-up	From $1,500	2–4 weeks	Rebuild gross sales, break out fees and refunds, restore the sales-tax liability, reconcile back payouts.
Monthly bookkeeping	From $400/mo	Ongoing	Each payout reconciled through clearing, fees and sales tax kept current, monthly P&L, one payout stream.
Multi-channel / multi-processor	Custom fixed quote	Scoped	Several payout streams, a clearing account each, consolidated into one reconciled file.

Get your range after a free review

How QBSpecialist's Shopify reconciliation is different

The same hands set up and reconcile your file from a documented plan — not an outsourced pool learning what a payout schedule is on your books. Every store we take on gets the same mechanics applied deliberately: gross sales booked, fees and refunds broken out, sales tax to its liability, each payout tied through a clearing account.

Our discipline is verification, not assertion. We reconcile each payout to the deposit and show you the tie, rather than telling you it balances. Access stays minimal — QuickBooks' accountant access to make and log every correction, or a screen-share you control, never your bank logins or your Shopify admin credentials. And we stay in our lane: we keep the books accurately and consistently, and we hand your CPA a file that already ties, but we do not file sales-tax returns, decide whether a sale is taxable, or give tax advice. That line is deliberate, and the honesty about where our job ends is part of doing it well. You can read the full method on our methodology page.

When not to hire us for Shopify reconciliation

Skip us when your file already works. If your Shopify payouts already reconcile to the bank, your gross sales and fees are already broken out, and your sales-tax liability already ties to what you remit, there is nothing here for us to fix — and no reason to pay someone to reconcile a file that already ties.

Skip us, too, when what you need is a different professional. If you need a return prepared, a ruling on whether a product is taxable in a given state, or nexus advice, that is your CPA's work, not ours. And if your store volume is low enough that one payout a week reconciles in a few minutes and you are comfortable in QuickBooks, you may be able to set the clearing account up yourself with a cleanup checklist and no invoice from anyone. We will tell you which case you are in during the free review, even when the honest answer is that you do not need us. See the full range of industries and integrations we reconcile to find the closest fit.

How to verify our Shopify reconciliation

You don't have to take our word for it. Here is the evidence you can check — the deliverable you receive, the method we use to prove a payout ties, and our response commitment.

Who’s responsible for your file
A Certified QuickBooks ProAdvisor handles your file from the review through the corrections to the hand-back — the same person throughout, never a rotating pool.
About QBSpecialist
Illustrative example — not a client file.
Sample payout reconciliation
The exact worksheet tying a Shopify payout's sales, fees, refunds, and tax to the deposit on the bank.
Our methodology
Each payout reconciled to the deposit, each fee and refund tied out. Read the discipline we apply.
Read the full method
Response commitment
A written reply within one business day.

Remote-first, nationwide

Mon–Sat · 8am–6pm CT

We work entirely remote — view-only for the free review, then QuickBooks' accountant access to make and log every correction — never your bank logins; every change visible to you in the audit log, and every reconciliation and correction documented in writing.

All 50 states
Remote-first
View-only review

Questions about QuickBooks Shopify reconciliation

Why doesn't my Shopify payout match my order total?

Because a payout is never the same number as the orders that produced it. Shopify Payments takes its processing fee before it deposits, refunds and chargebacks are netted out, and a single payout usually covers several orders across a pay period rather than one order at a time. So the deposit that lands in your bank is the gross of many orders, minus fees, minus refunds — and it settles a day or more after the sales happened. Reconciliation splits that deposit back into its parts so it ties to the bank.

How do you record Shopify Payments processing fees in QuickBooks?

As an expense, not as lost sales. The common mistake is booking only the net deposit as income, which quietly understates both revenue and expenses. Instead we record gross sales at the full order value, then record the processing fee Shopify deducted as a merchant-fee expense. That way your profit-and-loss shows what you actually sold and what the fee actually cost, and both numbers are there when your CPA needs them. We do not assert a fee percentage on this page — the rate is set by your Shopify plan and agreement, and we use the actual fee Shopify reports on your payout.

What is a clearing account and why do you use one for Shopify?

A clearing account is a holding account that sits between your Shopify sales and your bank. Orders post into it at gross, fees and refunds reduce it, and when the real payout hits the bank you move that net amount out of clearing and into the bank account. Done right, the clearing balance at any moment equals the money Shopify is holding but hasn't paid out yet — the in-transit amount — and it nets to zero once every payout has arrived. It is the single technique that makes a multi-order payout reconcile cleanly.

How do refunds and chargebacks show up in reconciliation?

Both reduce a payout, so both have to be recorded, and they behave a little differently. A refund reverses part or all of a sale and reduces the payout it settles against. A chargeback is a customer dispute reversed through the card networks, and it can carry its own fee. If either is simply left out, the payout won't tie and the clearing account won't clear. We record refunds against sales and chargebacks with their fee so the deposit reconciles and your net revenue is honest.

Do you handle the sales tax Shopify collects?

We record it correctly; we do not file it. When Shopify collects sales tax on an order, that money is not revenue — it is money you owe to a tax authority, so it posts to a sales-tax liability, not to income. We keep that coding consistent and reconcile the liability to what gets remitted. Whether a sale is taxable, which jurisdictions you owe, and the return itself are positions for you and your CPA to set. We make QuickBooks reflect them accurately.

What if I use PayPal or another gateway instead of Shopify Payments?

Shopify lets merchants take payment through third-party gateways as well as Shopify Payments, and each settles on its own schedule with its own fees. The reconciliation method is the same — gross sales in, fees out, payout matched — but each payout stream gets its own clearing account so a PayPal deposit and a Shopify Payments deposit never get tangled. If several processors are involved, we set one clearing account per stream and reconcile each to its own report.

How does payout timing affect my month-end close?

Payouts settle a day or more after the orders happen and often batch across a pay period, so at month-end some sales have been earned but the cash is still in transit. The clearing account captures exactly that: orders recorded in the month sit in clearing until their payout arrives, so your revenue lands in the right period and the timing gap is visible instead of silently throwing off the bank reconciliation. It is the same in-transit discipline we apply in any bank reconciliation.

We're behind on Shopify reconciliation — can you catch it up?

Yes, and it is a common starting point. When months of payouts have been booked as plain deposits with fees, refunds, and tax all buried inside the net number, the fix is a catch-up: rebuilding gross sales, breaking out fees and refunds, restoring the sales-tax liability, and reconciling each payout to the bank. Once the file is current and the clearing account is set, keeping it current each month is light work. The free review tells you how far off the books actually are.

How much does Shopify reconciliation cost?

The fee depends on your order volume, how many payout streams you run, how far behind the books are, and whether you need a one-time cleanup or ongoing monthly work. We set a fixed scope and a fixed fee after a free review rather than quoting a number that has to change later. The floors on this page are published starting points; the review sets your real range.

Shopify reconciliation is one channel lens on the same craft. See the bank reconciliation guide for the in-transit method underneath it, the full QuickBooks cleanup a Shopify catch-up is part of, and every industry and integration we reconcile.

Talk to a QuickBooks specialist.

Describe the file and a specialist will tell you which of these you are dealing with — including when the answer is that you don't need us.

Call (850) 842-6767 Talk to a specialist

Or start with a free, view-only review

Reconcile Shopify to QuickBooks so the payout finally ties to the bank.

Free review

Set the structure

Reconcile

Hand back or run it

Who’s responsible for your file

Sample payout reconciliation

Our methodology

Response commitment

More on this topic

Talk to a QuickBooks specialist.