Reconciling Shopify payouts in QuickBooks Online is one of the most common accounting challenges for ecommerce businesses. Shopify pays out every few days, each payout contains dozens or hundreds of transactions, and the payout amount rarely equals a simple sum of your order totals.

This guide covers the correct approach: account setup, journal entry format, handling the common edge cases, and how to verify your reconciliation is correct.

Understanding the Shopify payout structure

A Shopify payout is not simply “sales for the period.” It is a net amount calculated as:

Gross sales
+ Shipping collected
+ Tax collected (if you collect, not Shopify)
− Processing fees
− Refunds
− App deductions (Klaviyo, Shopify Subscription, etc.)
− MFT deductions (if applicable)
± Adjustments (disputes won/lost, etc.)
─────────────────────────────────────────────────
= Net payout to your bank

Each of these components needs to hit a different account in QuickBooks. If you post the payout as a lump sum to revenue, your books will be wrong.

Step 1: Set up the right accounts in QBO

Before reconciling your first payout, create the following accounts in QuickBooks if they do not already exist:

Current assets:

Undeposited Funds — Shopify(or “Clearing Account — Shopify Payments”) — this bridges the gap between when you recognise revenue and when Shopify pays you

Revenue:

Sales — Online — your product revenue
Sales — Shipping — shipping charged to customers (optional, can combine with Sales)

Current liabilities:

Sales Tax Payable — tax collected from customers

Expenses:

Shopify Payment Processing Fees — the 2.x% + 30¢ per transaction
Shopify Platform Fees — Shopify subscription and app charges deducted from payouts

Step 2: The clearing account pattern

The key to correct Shopify reconciliation is the clearing account(often called “Undeposited Funds” in QBO). Here is why you need it and how it works.

When you fulfil an order on Monday, you have earned that revenue. But Shopify does not pay you until Wednesday or Thursday. If you post directly to your bank account when revenue is recognised, your bank balance will be wrong until the payout arrives.

The clearing account solves this:

When revenue is recognised (order fulfilled): debit Clearing Account, credit Revenue
When payout arrives in bank: debit Bank Account, credit Clearing Account

The clearing account should be zero at the end of each reconciliation period if all payouts have been received and matched.

Step 3: Journal entry format

For each Shopify payout, the journal entry looks like this (using a payout of £14,820.40 as an example):

/* PAYOUT SETTLEMENT — Jun 9 2026 */
DR  Bank Account                            14,820.40
CR  Clearing Acct — Shopify Payments               14,820.40

/* REVENUE RECOGNITION — Jun 6–8 2026 orders */
DR  Clearing Acct — Shopify Payments        15,716.40
CR  Sales — Online                                 14,808.22
CR  Sales — Shipping                                 496.00
CR  Sales Tax Payable                                412.18

/* FEES */
DR  Shopify Payment Processing Fees             896.00
CR  Clearing Acct — Shopify Payments                  896.00

When done correctly, the Clearing Account balance before the payout settlement equals exactly the net payout amount. After settlement, it zeros out.

Step 4: Handling refunds

Refunds require reversing the original revenue entries. But there is an important detail: Shopify does not refund your processing fee. You pay the fee on the original transaction and Shopify does not return it when the order is refunded.

The refund journal entry:

DR  Sales — Online                            148.00
  CR  Clearing Acct — Shopify Payments               148.00

/* Fee is NOT reversed — you keep paying it */
/* This creates a small net cost per refund */

Some accountants prefer to book the non-refunded fee as an additional expense line. This is more accurate but adds complexity.

Step 5: Handling app deductions

Shopify deducts some app and partner charges directly from your payout. These show as negative adjustment lines in your payout report. Common examples:

Shopify subscription fees
Klaviyo usage charges
Klarna / Afterpay / BNPL fees
Shopify Capital repayments

Each deduction needs to hit the correct expense account. Do not lump them into “miscellaneous” — that makes it impossible to reconcile your P&L against your payout reports later.

Step 6: Verify the reconciliation

After posting all entries for a payout period, verify:

The Clearing Account balance equals £0 (all revenue recognised + payout received)
Total debits to Bank Account equals the actual Shopify deposit in your bank statement
Revenue lines match what Shopify reports in the payout breakdown
Sales Tax Payable reflects the tax you collected and owe

If the Clearing Account does not zero, there is a discrepancy — either a payout has not arrived yet, or you have missed a transaction.

Automating this process with Rappel

Doing the above manually for each payout takes significant time, especially for stores with high order volumes. The account setup, journal entry creation, refund handling, and verification all need to happen for every 2–3 day payout cycle.

Rappel automates all of it. Connect Shopify and QuickBooks via OAuth. Rappel reads your chart of accounts, suggests the account mappings, and builds the journal entries automatically for every payout. You review and approve — then click to post to QBO.

The exact structure described above (clearing accounts, separate revenue/fee/tax lines, refund handling) is how Rappel builds every journal entry. No manual work, no spreadsheets, no missed deductions.

Shopify Payout Reconciliation in QuickBooks Online — The Complete 2026 Guide