How to Reconcile Shopify Payouts in QuickBooks Online

If you run a Shopify store and do your own books, you’ve probably noticed the problem. The deposit that hits your bank doesn’t match the sales number in Shopify. Not even close.

That’s because Shopify doesn’t deposit what you sold. It deposits what you sold, minus payment processing fees, minus refunds, minus chargebacks, minus any holdbacks. And it does all of that in batches that don’t line up neatly with calendar days.

Most online store owners either give up and just categorize the bank deposit as “Shopify Sales” (wrong, and your books will lie to you forever), or they spend four hours a month trying to reverse-engineer it in a spreadsheet (also wrong, because you’re human and you’ll miss things).

Here’s the right way to do it in QuickBooks Online. The way a real bookkeeper does it.

What Shopify actually deposits into your bank

Before we touch QuickBooks, you need to understand what a Shopify payout actually is. Every payout is a rolled-up batch that usually includes:

• Gross sales (what customers paid)
• Minus Shopify Payments processing fees (typically 2.9% + 30¢)
• Minus refunds issued during that period
• Minus chargebacks
• Plus any adjustments Shopify made (rare, but it happens)

The number that lands in your bank is the net, not the gross. If you book the net as revenue, your Profit and Loss statement (P&L) is wrong. Your gross sales will be understated, your processing fees will be invisible, and your refunds will never be tracked properly.

The goal of reconciliation is to break that one net number back into its real pieces and record each piece in the right QuickBooks account.

Step 1. Set up a Shopify Clearing account in QuickBooks

Don’t book Shopify deposits straight to your bank account. You need a middle account, a “clearing” or “holding” account, that sits between Shopify and your bank.

In QuickBooks Online:

1. Go to Accounting > Chart of Accounts > New
2. Account type: Bank
3. Detail type: Cash on hand (close enough for our purposes)
4. Name: Shopify Clearing

This is the account where every sale, fee, and refund hits first. When Shopify actually deposits the money into your real bank, you transfer from Shopify Clearing into your Bank.

Why do it this way? Because Shopify works on gross numbers and your bank works on net. The clearing account is how you bridge them without losing detail.

Step 2. Record gross sales daily (or at least by payout batch)

When a sale happens in Shopify, you should be recording the full gross sale, not the net. The easiest workflow if you’re doing this manually:

• Run the Shopify Finances Summary report for the payout period
• Create a Sales Receipt or Journal Entry in QuickBooks that posts:
  • Debit: Shopify Clearing (gross sale amount)
  • Credit: Sales / Product Income (gross sale amount)

Step 3. Record processing fees

For every payout, Shopify tells you exactly how much they took in fees. Book it as:

• Debit: Merchant Processing Fees (expense)
• Credit: Shopify Clearing (reduces the balance)

This keeps your fees visible as an operating expense, which is what they are.

Step 4. Record refunds

When a refund goes out, Shopify reduces the payout by that amount. Mirror that in QuickBooks:

• Debit: Refunds & Returns (contra-revenue account)
• Credit: Shopify Clearing

A lot of online sellers make the mistake of netting refunds against sales. Don’t. Refunds get their own account so you can watch your return rate over time.

Step 5. Record the deposit when it hits your bank

Now Shopify sends the net amount to your actual bank. In QuickBooks:

• Go to the bank feed
• Categorize the incoming deposit as a Transfer from Shopify Clearing to Business Checking

If you did steps 2-4 correctly, Shopify Clearing will now zero out for that payout batch. That’s how you know the books are right.

Step 6. Reconcile the clearing account every month

At month-end, your Shopify Clearing account should have a small rolling balance representing sales that happened but haven’t paid out yet. Anything older than a week sitting in clearing is a red flag.

A better option: use A2X or Link My Books

If your volume is over 50 orders a month, the manual process above will eat your life. Use an integration.

A2X for Shopify ($29 to $79 per month) and Link My Books ($17 to $69 per month) both pull each Shopify payout, break it into the pieces we just described, and post a clean summary journal entry into QuickBooks automatically.

If you’re doing more than 100 orders a month, stop doing this manually. The $30 a month is cheaper than your own time.

Common reconciliation mistakes

• Booking the net deposit as “Sales.” The most common error. Your gross sales will be understated and your fees will be invisible.
• Ignoring refunds that crossed month-end. A refund issued on May 31 might not appear in the June payout. Track by transaction date, not payout date.
• Using one Shopify Clearing account for multiple stores. US store and Canadian store need separate clearing accounts.
• Forgetting chargebacks. Small number, but they come out of your deposit.
• Not reconciling monthly. Errors compound.

The bottom line

If your Shopify and QuickBooks numbers don’t match, it’s not a Shopify problem. It’s a bookkeeping workflow problem. Set up a clearing account, record gross sales and fees and refunds separately, and reconcile every month.

Stop categorizing the net deposit as “Sales.” Your P&L deserves better.