1.0 Why Lump-Sum Deposits Break Net-Only Matching

When Shopify Payments or Stripe settles into a business checking account, the bank feed only receives the net transfer. Recording that deposit straight to Sales drops gross revenue, hides 2.9% + $0.30 card processing fees, masks customer refunds, and misstates Sales Tax Payable on the balance sheet.

A dedicated Clearing Account bridges the timing gap between daily checkout orders and batch bank transfers. Once the payout journal entry posts, the checking transfer zeroes the clearing balance to $0.00.

2.0 The 5-Line GAAP ASC 606 Journal Entry

For sellers acting as principal, ASC 606 generally calls for reporting gross sales, with processing fees as an expense. Confirm treatment with your CPA. Use this worked 5-line structure for each settled Shopify or Stripe payout batch.

Account Name Account Type Debit Credit
Shopify / Stripe Clearing Bank (Clearing) $9,154.00
Merchant Processing Fees (2.9% + $0.30) Operating Expense $326.00
Sales Returns & Refunds Contra-Revenue $420.00
Processor Reserve Holdback Other Current Asset $500.00
Gross E-Commerce Sales Income $9,600.00
Sales Tax Payable Current Liability $800.00

3.0 The $0.00 Clearing Account Equation

Every payout split must prove two checks simultaneously before import: total journal debits must equal total journal credits, and the clearing debit must match the exact ACH deposit entering checking.

Payout Settlement Proof
Gross Sales + Sales Tax − Refunds − Processing Fees − Reserve Holdback = Net Deposit

In the worked entry above, $10,400.00 total credits minus $1,246.00 fees, refunds, and reserve holdback equals the $9,154.00 net checking transfer, leaving $0.00 variance.

4.0 Four Steps to Wire the Clearing Account

  1. Create Bank-type clearing accounts: Add Shopify Clearing and Stripe Clearing as Bank accounts in QuickBooks Online or Xero so checking transfers match cleanly.
  2. Export your processor payout CSV: Download the settlement report from Shopify Payments or Stripe without connecting third-party OAuth scrapers.
  3. Split rows in your browser: Load the CSV into the E-Commerce Payout Splitter to generate a balanced GAAP ASC 606 journal export verified to $0.00.
  4. Match the checking transfer: Code the bank feed deposit as a transfer from the clearing account so the clearing balance resets to $0.00 after every payout.

5.0 Scaling With Package 2 and Package 3

Brands running high order volumes across Shopify, Stripe, Amazon, PayPal, and Square can move beyond manual CSV uploads with Package 2: Full-Cycle Bookkeeping Automation ($299/mo), which splits multi-channel payouts and routes reviewed drafts into QuickBooks Online or Xero. Multi-entity groups and finance advisors managing 35 to 80+ accounts use Package 3: Multi-Company Reporting & Dashboards (from $699/mo) for consolidated rollups and rolling 13-week cash flow forecasts.

Split Your Next Shopify or Stripe Payout

Turn lump-sum processor CSVs into balanced QBO and Xero journal entries directly in browser memory.

Open Payout Splitter

6.0 Frequently Asked Questions

Why not code lump-sum Shopify or Stripe deposits straight to Sales?
For sellers acting as principal, ASC 606 generally calls for reporting gross sales, with processing fees as an expense. Confirm treatment with your CPA. Coding net payouts directly to Sales understates gross revenue, omits 2.9% + $0.30 processing fees from expenses, hides refunds, and fails to separate Sales Tax Payable liabilities.
What account type should the clearing account use in QBO and Xero?
Create each clearing account as a Bank account type (Checking in QuickBooks Online; Bank Account in Xero) so bank feed transfers match directly against the clearing debit.
How should processor reserve holdbacks be recorded?
Book reserve holdbacks as a debit to a Processor Reserve Current Asset account rather than an expense or revenue reduction. Credit that asset back to clearing when the processor releases the funds.
Which Acctbot plan covers multi-channel payouts and multi-entity dashboards?
Package 2 ($299/mo) automates Shopify, Stripe, Amazon, PayPal, and Square payout splits into QBO or Xero, while Package 3 (from $699/mo) adds multi-company consolidation and rolling 13-week cash dashboards. Automations are licensed and maintained while your plan is active, and data handling is agreed in writing before any paid build.