How to Record a Shopify Payout in QuickBooks Online (Step-by-Step)
The Problem with Shopify Payouts in QuickBooks
If you've ever tried to record a Shopify payout in QuickBooks Online by matching it directly to a bank deposit, you've run into the core problem: the deposit amount doesn't equal your gross sales.
Shopify batches together your sales, refunds, and fees, then deposits the net amount. A payout of $4,218.43 might represent $5,100.00 in gross sales, minus $72.90 in Shopify transaction fees, minus $808.67 in refunds. Recording the deposit as revenue means you're understating gross sales, missing your refund detail, and losing the fee breakdown entirely.
This guide walks through the correct method — and where most bookkeepers go wrong.
The Most Common Mistake: Recording the Net Deposit as Revenue
Want to skip the manual work?
Upload your settlement file — no login required. SettleBooks parses it and generates a balanced journal entry in under 60 seconds.
Try the free Settlement Summary Viewer →The #1 Shopify bookkeeping error in QuickBooks:
- Shopify pays out $4,218.43 to your bank
- You open QBO, find the bank deposit
- You categorize it directly to "Sales Revenue"
- QBO shows $4,218.43 of revenue
What's wrong: Your actual gross sales were $5,100.00. Your refunds ($808.67) are invisible. Your Shopify fees ($72.90) are hidden inside the revenue line. Your P&L is wrong, your sales tax reconciliation is wrong, and your refund liability is unrecognized.
The Correct Method: Two-Account Clearing
The right approach uses a Shopify Clearing Account (a Current Asset account) as an intermediate holding account. Here's how the flow works:
Gross Sales → Credit Sales Revenue
Debit Shopify Clearing
Shopify Fees → Debit Shopify Transaction Fees
Credit Shopify Clearing
Refunds → Debit Sales Returns & Allowances
Credit Shopify Clearing
Payout → Debit Bank Account
Credit Shopify Clearing
After all entries, the Shopify Clearing Account nets to zero — exactly as it should, since you've accounted for every dollar.
Step-by-Step: Recording the Payout
Step 1: Set Up Your Shopify Clearing Account
If you haven't already: 1. Go to Accounting > Chart of Accounts > New 2. Account Type: Other Current Assets 3. Detail Type: Other Current Assets 4. Name: Shopify Clearing Account 5. Number: 1110 (or whatever fits your chart) 6. Save
Step 2: Download Your Shopify Payout Report
- Log in to your Shopify Admin
- Go to Finance > Payouts
- Click the payout you want to record
- Click Export to download the CSV
- The CSV includes: gross sales, refunds, adjustments, fees, and net payout
Step 3: Summarize the Payout
From your CSV, identify: - Gross sales: total before any deductions - Total refunds: sum of all refund amounts - Shopify transaction fees: the fee column total - Net payout: what hit your bank
Example payout summary:
| Line | Amount |
|---|---|
| Gross sales | $5,100.00 |
| Refunds | −$808.67 |
| Transaction fees | −$72.90 |
| Net payout | $4,218.43 |
Step 4: Create the Journal Entry in QBO
Go to + New > Journal Entry.
| # | Account | Debits | Credits | Description |
|---|---|---|---|---|
| 1 | Shopify Clearing Account | $5,100.00 | Gross sales | |
| 2 | Sales Revenue | |||
| — | (QBO auto-balances) | $5,100.00 | ||
| 3 | Shopify Transaction Fees | $72.90 | Shopify fees | |
| 4 | Shopify Clearing Account | $72.90 | Fee offset | |
| 5 | Sales Returns & Allowances | $808.67 | Refunds issued | |
| 6 | Shopify Clearing Account | $808.67 | Refund offset |
In practice, QBO journal entries require debits = credits per entry. The cleanest approach is one journal entry for the entire payout period:
| Account | Debit | Credit |
|---|---|---|
| Shopify Clearing Account | $5,100.00 | |
| Shopify Transaction Fees | $72.90 | |
| Sales Returns & Allowances | $808.67 | |
| Sales Revenue | $5,100.00 | |
| Shopify Clearing Account | $881.57 | |
| Totals | $5,981.57 | $5,981.57 |
Wait — that doesn't look right. Let me simplify. The cleanest single journal entry:
| Account | Debit | Credit |
|---|---|---|
| Sales Returns & Allowances | $808.67 | |
| Shopify Transaction Fees | $72.90 | |
| Shopify Clearing Account | $4,218.43 | |
| Sales Revenue | $5,100.00 | |
| Totals | $5,100.00 | $5,100.00 |
This records the gross sales as revenue, the refunds and fees as debits, and holds the net $4,218.43 in the clearing account waiting for the bank deposit.
Step 5: Match the Bank Deposit
When the $4,218.43 hits your bank feed in QBO: 1. Go to Banking > Bank Feed 2. Find the Shopify deposit 3. Match it to a Transfer from Shopify Clearing Account (not a new expense or income) 4. The clearing account drops to zero
Now your bank balance is correct, your revenue is correct, your fees are itemized, and your refunds are captured.
Handling Sales Tax
If Shopify collected sales tax on your orders, that amount is included in gross sales in the payout report but is not your revenue — it's a liability you owe to the state. Add a line to your journal entry:
| Account | Debit | Credit |
|---|---|---|
| Sales Tax Payable | $210.00 | |
| Sales Revenue | $4,890.00 | |
| (other lines as above) |
Shopify calculates and remits sales tax automatically for most US states (Shopify Tax / automatic collection), but you still need to record the liability in your books.
Automate This in One Upload
The manual two-account method is correct, but it takes 15–30 minutes per payout period — and that's for a clean, straightforward file. Add refunds across multiple periods, multiple currencies, and discount codes, and it gets complicated fast.
SettleBooks reads your Shopify payout CSV, applies the clearing account method automatically, and produces a balanced journal entry ready for import into QuickBooks Online. One upload, one export, done.