This post may contain affiliate links, which means I may earn a small commission if you make a purchase through them — at no extra cost to you. I only share products and tools I truly love and recommend!

Prefer to listen instead of read? Listen to the related podcast episode here, or find it on your favorite platform:

If you’ve been opening QuickBooks, finding your Shopify deposit in your bank feed, and clicking “Sales” or “Revenue” as the category, this post is for you. It makes total logical sense that you’d do it that way. The money came from your sales, so it’s sales, right? But that’s not actually how it works, and recording it that way means your financial reports aren’t accurate and you could be overpaying in taxes without even realizing it.

The good news is that once you understand the correct system for recording Shopify deposits in QuickBooks Online, it is genuinely simple. We’re talking a 2-minute task you can do once a week or once a month. Here’s how it works.

Why Your Shopify Deposit Isn’t Just “Sales”

Earlier, we covered how your Shopify deposit is made up of 6 different components: gross sales, discounts, returns, shipping income, sales tax collected, and processing fees (if you missed it, go back and read/listen to it here!).

Every single one of those needs its own line in your books. When you lump the whole deposit together as Sales, you’re overstating your income by every dollar of sales tax you collected (which is NOT your money, it belongs to the state), and you’re missing out on the processing fees as a tax deduction. Both of those things can result in a higher tax bill than you actually owe. And beyond taxes, your reports just won’t reflect what’s really going on in your business.

The Mindset Shift That Makes This Click

Start thinking of your Shopify account as its own separate bank account. The moment a customer pays for their order, that money is legally yours. But it doesn’t hit your actual bank account right away. It sits in your Shopify account while it’s being processed. So in QuickBooks Online, you’re going to set up a Shopify bank account to represent that holding place. This is the foundation the whole system is built on, and once you have it set up, everything else falls into place.

How to Record Your Shopify Deposits Correctly

Once a week or once a month, whichever rhythm works for you, you’re going to enter all 6 components as one single entry in QuickBooks. Your gross sales, discounts, returns, shipping income, sales tax collected, and processing fees all go in together as a journal entry. A journal entry is just a form in QuickBooks where you record multiple pieces of financial information at once.

And here’s the part that makes this actually sustainable: you can save it as a RECURRING TEMPLATE. So every time you sit down to do this, the entry is already built. You just plug in the new numbers. The whole thing takes about 2 minutes.

Then, when the actual deposit shows up in your real bank account, you record it as a transfer from your Shopify account. That’s it. No math, no guessing, no trying to figure out what made up that number, because you already handled that in your journal entry.

Don’t Skip the Reconciliation

The last piece of this system is reconciling your Shopify payouts, which is just a way of verifying that Shopify is actually paying you everything they owe you. You compare what you collected from customers through Shopify Payments, subtract the processing fees Shopify deducted, and confirm the net amount matches what hit your bank. It’s a simple check that gives you a lot of confidence in your numbers.

Ready to See It in Action?

Reading about journal entries and reconciling is one thing. Actually watching someone do it inside QuickBooks while you follow along is a completely different experience. Inside the Bookkeeping Made Simple for Boutiques Membership, I walk you through this entire process on video, step by step, so you can implement it in your own QuickBooks account without the guesswork. If you’re ready to stop wondering if you’re doing it right, come join us at www.findingfreedomfinancial.com/membership.