How Shopify Payout Accounting Actually Works

Every few days, Shopify deposits money into your bank account. For most merchants, that deposit is followed by a question: "How do I record this in QuickBooks?"

It sounds simple. Money came in — just write it down, right? But Shopify payout accounting is one of the most misunderstood parts of running an online store. Get it wrong and your books look fine right up until tax time, when your accountant tells you your profit margins are off and you owe more — or less — than you thought.

This guide breaks down exactly how it works, in plain English.

The core problem: a payout is not the same as your sales

This is the root of almost every Shopify bookkeeping mistake.

When a customer buys something from your store for $100, Shopify records $100 in sales. But what lands in your bank account might be $97.10 — because Shopify already deducted a 2.9% + $0.30 payment processing fee before sending you the money.

If you record the $97.10 bank deposit as "$97.10 in revenue," you've just understated your sales by $2.90 and hidden the fees entirely. Do that across thousands of transactions over a year and your books are meaningfully wrong.

The right approach is to record the full $100 as revenue and then separately account for the $2.90 fee. That way your income statement tells the true story of your business.

What's actually inside a Shopify payout

Every Shopify payout bundles together activity from several days of trading. Here's what goes into it:

• Gross sales — the full amount customers paid you, including tips and shipping you collected
• Refunds — money returned to customers during the payout period (subtracted)
• Payment processing fees — Shopify's cut per transaction (subtracted)
• Disputes — chargebacks decided against you (subtracted); you get them back if you win
• Adjustments — rare corrections Shopify makes to fix prior payout errors

The formula is: Gross sales − Refunds − Fees − Disputes ± Adjustments = Your payout

So a month where you did $20,000 in sales might result in payouts totalling $18,900 once everything is netted out.

Why payout timing creates confusion

Shopify doesn't pay you transaction by transaction. Instead, it batches your sales into payouts released every two business days by default. That means a single payout might include sales from Monday, Tuesday, and Wednesday — plus a refund from a sale that happened last week.

This is why you can't simply match your bank statement to your Shopify sales report. The timing doesn't line up, and the amounts don't match because of fees and refunds.

The three-entry method: how to record a payout correctly

Accountants who work with ecommerce businesses use a method that involves three entries per payout. It looks like more work at first, but it's the only way to keep your books accurate.

Entry 1: Record gross sales as a Sales Receipt

Create a Sales Receipt in QuickBooks for the full gross amount of the payout — not the net amount that hit your bank. This entry posts to a clearing account (a temporary holding account, not your bank).

Example: gross sales were $5,000, so you create a Sales Receipt for $5,000 to "Shopify Clearing."

Entry 2: Record refunds as a Refund Receipt

If there were refunds in the payout period, create a Refund Receipt for the total refund amount. This also posts to the Shopify Clearing account, reducing the balance there. If there were no refunds, skip this entry.

Entry 3: Record the deposit

Create a Deposit in QuickBooks for the exact net amount that hit your bank account. This moves money from the Shopify Clearing account to your actual bank account in QuickBooks.

The difference between the Sales Receipt amount and the Deposit amount is your fees — that difference stays in the clearing account and implicitly represents the fees Shopify deducted. You don't need a separate fee entry because the math handles it for you.

What is a clearing account and why do you need one?

A clearing account is a temporary holding account. Think of it as a waiting room where money sits between "Shopify received it" and "it hit my bank." You never look at your clearing account balance and think "that's my money." Its balance should always trend toward zero.

In QuickBooks, your clearing account is set up as an Other Current Asset account, named something like "Shopify Clearing." If the balance is persistently positive, it means a Sales Receipt was recorded but the corresponding Deposit is missing.

What happens to Shopify fees in QuickBooks?

Shopify's payment processing fees don't appear as a line item on your bank statement — they're already deducted before the payout lands. With the three-entry method, fees are implicitly captured through the clearing account. The gross Sales Receipt posts $5,000 to clearing. The Deposit moves $4,710 to your bank. The $290 that stays in clearing represents your fees.

Some merchants prefer to make this explicit by adding a fee line to the Deposit entry. Either approach works — the important thing is that you don't record the net amount as revenue.

What about sales tax?

Shopify collects sales tax on behalf of merchants in many US states. This money passes through your account but isn't your revenue — it belongs to the tax authority. In QuickBooks, sales tax collected should go to a liability account (like "Sales Tax Payable"), not to your income account.

The most common mistakes

• Recording the net deposit as revenue. This understates sales and hides fees. Always record gross.
• Not using a clearing account. Without one, your bank account in QuickBooks will never reconcile with your actual bank statement.
• Ignoring refunds. Refunds need their own entry, or your income is overstated.
• Mixing payout periods. Each payout should be its own set of entries — don't lump multiple payouts into one transaction.
• Forgetting adjustments and disputes. Rare, but when they happen they need to be recorded or your clearing account won't zero out.

How PaydayBooks handles this automatically

PaydayBooks connects to your Shopify store and your QuickBooks Online account and handles every step automatically. Every time Shopify releases a new payout, PaydayBooks reads the full breakdown — gross sales, refunds, fees, tips, shipping — and creates the three QuickBooks entries with the exact amounts.

It runs every 6 hours. Your books stay accurate without you touching a spreadsheet.

If you're spending time on payout accounting right now, install PaydayBooks and let it run in the background. Questions? Email us at [email protected].