Understanding Shopify Payouts in QuickBooks Online (QBO)

The Core Concept

Every Shopify payout is a net deposit calculated as:

Gross Sales – Refunds – Discounts – Taxes – Fees = Bank Deposit

QuickBooks needs to see the full picture, not just the final payout, for proper reconciliation.

1. Understand What’s in the Shopify Deposit

Example payout summary from Shopify Payments:

If you only see the $896 deposit in your bank feed, QBO will not know how much was fees versus refunds, which is why it’s important to record the gross activity.

2. How to Record It in QuickBooks Online

Option A Recommended: Use a Shopify Clearing Account

This method keeps your books clean and reconciled.

1. Create a new account:
   • Go to Settings → Chart of Accounts → New
   • Type: Bank
   • Name: Shopify Clearing Account (or “Shopify Payments Clearing”)
2. Record a journal entry or sales receipt for each payout:
   • Debit: Shopify Clearing Account $1,000 (Gross Sales)
   • Credit: Sales Revenue $1,000
   • Debit: Shopify Fees Expense $29
   • Credit: Shopify Clearing Account $29
3. When the deposit hits your bank, record:
   • Debit: Checking Account $896
   • Credit: Shopify Clearing Account $896

After each payout, your Shopify Clearing Account should zero out, confirming that fees and sales are fully matched.

Option B If You Sync Automatically (e.g., A2X or Synder)

These apps handle clearing accounts and fees automatically:

• They import gross sales, fees, taxes, and refunds.
• They create summarized journal entries that match the bank deposit.
• You simply match the bank feed deposit to the journal entry.

If you use the native Shopify–QuickBooks integration, it may not record fees correctly, often showing only net sales.

3. Where to Record the Fees

• Use an expense account named “Shopify Fees” or “Merchant Processing Fees”
• Account Type: Expenses
• This ensures your Profit & Loss report shows how much you paid Shopify in processing fees each month.

4. Monthly Reconciliation Tip

1. In Shopify, go to Payouts Report.
2. Export totals for gross sales, refunds, fees, and payouts.
3. Compare the payout total to the Shopify Clearing Account balance in QBO, it should be $0 if everything is matched.

5. Common Mistakes to Avoid

• Recording only the net deposit as income, which understates sales.
• Recording fees twice, which can happen if manually entered and also synced by an app.
• Skipping a clearing account, which leads to unreconciled differences if multiple payouts overlap.