Why Do E-Commerce Sellers Split Net Deposits Into Gross Sales and Fees?
When operating an online store across platforms like Shopify, Amazon Marketplace, Stripe, eBay, or WooCommerce, cash does not flow directly into the bank account on an invoice-by-invoice basis. Instead, payment processors accumulate orders across a 24-hour, 48-hour, or bi-weekly disbursement cycle, subtract payment gateway fees, offset customer dispute chargebacks, withhold regulatory tax reserves, and deposit a single lump-sum net figure into the company checking account.
For millions of business owners and bookkeepers, the immediate temptation is to open QuickBooks Online or Xero, see the lump-sum deposit sitting in the bank feed (for instance, a deposit of $8,941.12), and click “Add” or categorize it directly to an account titled “Sales Revenue”.
The Cascade of Errors Triggered by “Net Deposit” Bookkeeping
When merchant payouts are booked on a net basis, four fundamental financial statement errors occur simultaneously:
- Understated Top-Line Gross Revenue: Your income statement reports net cash collected rather than the total value of products purchased by consumers. This severely lowers valuation multiples during acquisitions or lender underwriting.
- Unclaimed Tax Deductions: Payment processing fees (often between 2.2% and 3.5% + $0.30 per charge, escalating to 15% to 20% on Amazon FBA) are ordinary deductible business expenses. Failing to break them out on Schedule C or Form 1120-S means overpaying income tax on phantom margin.
- Distorted Cost of Goods Sold (COGS) and Gross Margin: Without accurate gross revenue benchmarks, inventory profitability, unit economics, and return-on-ad-spend (ROAS) calculations become unreliable.
- Omitted Sales Tax Liability Obligations: If sales tax collected from customers is blended directly into top-line sales revenue, your liability to state taxing authorities remains unrecorded on the balance sheet, resulting in penalties when quarterly sales tax returns are filed.
GAAP ASC 606 & Revenue Recognition: Gross vs. Net Reporting
The Financial Accounting Standards Board (FASB) and International Accounting Standards Board (IASB) address revenue recognition under ASC 606 (Revenue from Contracts with Customers). A key consideration under ASC 606 is whether an entity acts as a Principal or an Agent in delivering goods to the customer.
For sellers acting as principal, ASC 606 generally calls for reporting gross sales, with processing fees as an expense. Confirm treatment with your CPA. Under this presentation, costs incurred to process the transaction (payment processing interchange fees, platform commissions, and merchant gateway surcharges) are recorded separately as operating expenses.
Reporting revenue net of fees is typically used by brokers or agents who earn a commission without controlling the underlying inventory.
How Does the 4-to-5-Line General Ledger Journal Model Balance E-Commerce Settlements?
To follow GAAP ASC 606 and keep your balance sheet balanced, every e-commerce payout must be split into a multi-line journal entry. Acctbot’s splitter automates this breakdown:
| Account Type | Standard Account Title | Normal Balance | Ledger Impact |
|---|---|---|---|
| Current Asset | 1010 Operating Checking | Debit | Debit: Exact cash received in the bank account |
| Operating Expense | 6080 Merchant Processing Fees | Debit | Debit: Total transaction & gateway fees deducted |
| Refunds (Contra-Revenue) | 4090 Customer Returns & Allowances | Debit | Debit: Refunds, return allowances & chargebacks |
| Operating Revenue | 4010 E-Commerce Gross Sales | Credit | Credit: Total merchandise sales & shipping collected |
| Current Liability | 2050 State Sales Tax Payable | Credit | Credit: Sales tax collected held in escrow for remittance |
The Double-Entry Balancing Equation
In double-entry bookkeeping, the sum of debits must equal the sum of credits to the exact cent ($0.00 difference). Acctbot’s automatic balance check continuously verifies this equation:
If your processor settlement report lists gross revenue of $10,000.00, customer refunds of $250.00, sales tax collected of $800.00, and processing fees of $320.00:
- Total Credits: $10,000.00 (Gross Sales) + $800.00 (Tax Payable) = $10,800.00
- Debits (excluding cash): $320.00 (Fees) + $250.00 (Refunds) = $570.00
- Required Net Bank Deposit: $10,800.00 − $570.00 = $10,230.00
When this balanced journal is posted to QuickBooks Online or Xero, the $10,230.00 debit matches the bank feed deposit with zero difference, while your P&L reflects true gross sales and fully captured merchant fee deductions.
The Clearing Account Method: How to Reconcile E-Commerce Payouts to $0.00 in QuickBooks & Xero
Why is direct-debiting your Operating Checking account risky? Stripe and Shopify payouts take 2 to 5 business days to clear your checking account, and payouts crossing month-end (such as orders placed on September 29 settling on October 2) create timing differences. If you debit Checking directly on the date of sale, your bank reconciliation will not match your cleared bank statement.
The Two-Step Clearing Account Lifecycle
Professional bookkeepers and CPAs handle high-volume e-commerce stores using a two-step clearing sequence:
Generated by this tool and imported into QuickBooks or Xero:
- Debit: Shopify Clearing Account (Net Expected: $10,230.00)
- Debit: Merchant Processing Fees (Expense: $320.00)
- Debit: Customer Returns & Allowances (Refunds: $250.00)
- Credit: E-Commerce Gross Sales (Revenue: $10,000.00)
- Credit: Sales Tax Payable (Liability: $800.00)
When the physical funds clear into your business bank account 2 to 3 days later:
- Bank Feed Action: Click “Match” or record a Transfer from the Shopify Clearing Account to Operating Checking.
- Debit: Operating Checking ($10,230.00)
- Credit: Shopify Clearing Account ($10,230.00)
- Clearing Account Balance: $0.00 (Balanced)
2026 Merchant Processing Fee Benchmarks: Where Does Your $100 Sale Go?
One of the most frequent questions e-commerce accountants and online founders ask is: “How much does each payment processor actually take from a $100 customer purchase?” The table below reflects standard domestic merchant processing rates across major e-commerce gateways:
| Payment Processor / Gateway | Standard US Card Fee Formula | Deducted Fee ($100 Sale) | Net Bank Deposit | Effective Fee % |
|---|---|---|---|---|
| Stripe Online Payments | 2.9% + $0.30 | $3.20 | $96.80 | 3.20% |
| Shopify Payments (Basic Plan) | 2.9% + $0.30 | $3.20 | $96.80 | 3.20% |
| Shopify Payments (Advanced Plan) | 2.4% + $0.30 | $2.70 | $97.30 | 2.70% |
| PayPal Checkout (Standard) | 3.49% + $0.49 | $3.98 | $96.02 | 3.98% |
| Square Online (Free Plan) | 3.3% + $0.30 | $3.60 | $96.40 | 3.60% |
| Amazon Seller Central (Home & Kitchen) | 15.0% Referral Fee | $15.00 | $85.00* | 15.00% |
*Note: International cards add a 1.5% cross-border fee ($1.50) and currency conversion adds another 1% ($1.00), bringing the total Stripe fee on international payments to $5.70 (Net: $94.30). Amazon referral fees replace gateway processing; additional FBA pick/pack fees ($3.50 to $6.00+) and monthly Professional seller subscriptions ($39.99/mo) apply separately.
Platform-by-Platform Settlement Mechanics
1. Stripe Settlement Structures
Stripe provides detailed balance_transaction export files. Each line item separates charges, refunds, fee deductions, and transfers. Stripe payouts often include rolling reserves or delayed payouts (common for new merchants or higher-risk categories). Acctbot tags these holds as balance sheet reserve receivables rather than misallocating them to expense accounts.
2. Shopify Payments & Shopify Balance
Shopify Payments runs on Stripe infrastructure but introduces multi-currency conversions and international card surcharges. Transactions settled in foreign currencies undergo currency conversion before reaching your domestic bank account. Acctbot separates exchange differences from core merchant processing fees.
3. Amazon Marketplace (Seller Central) & Marketplace Facilitator Laws
Amazon accounting involves Marketplace Facilitator Laws (MFL). In most US states, Amazon collects and remits sales tax directly to state revenue agencies on behalf of third-party sellers. Therefore, Amazon does not pay that tax out to the seller, nor does the seller owe it on their state tax return. Acctbot separates Amazon MFL tax so sellers do not overstate their Sales Tax Payable liability.
Acctbot Private Browser Tool vs. Cloud Integration Connectors
| Feature | Acctbot Browser Tool | Legacy Cloud SaaS Sync Plugins | Manual Bookkeeper Excel |
|---|---|---|---|
| Data Privacy & Storage | Processed in Browser: Runs in Your Browser (No Uploads) | Third-party cloud storage of order data | Local files stored on workstation |
| Monthly Subscription Fee | $0.00 Free Browser Utility | Monthly subscription per connected store | Included in staff wages |
| API Rate Limits & Sync Errors | None: Instant CSV parsing | Subject to Stripe/Shopify API rate caps | Manual calculation errors |
| Automatic Balance Check (Debits = Credits) | Built-in $0.00 balance check | Manual verification or adjustment entries | Manual human verification needed |
| Accounting Formats | QuickBooks Online & Xero Ready | Direct API push only | Non-standard layouts |
| Best Suited For | E-Commerce Businesses & Bookkeepers needing balanced GAAP ASC 606 entries with no per-store fees. | High-volume stores using cloud API syncing per store. | Low-volume single-channel stores with simple manual volume. |
Step-by-Step Tutorial: Importing Settlement CSVs and Posting Journals
- Export Payout Settlement CSV: Log into your merchant portal (Stripe Dashboard, then Balance, Payouts, Export; Shopify Admin, then Finances, Payouts, Export; or Amazon Seller Central, then Payments, All Statements, Download Flat File).
- Drop Into Acctbot: Drag your settlement export into the drop zone above. Your browser reads all transaction lines locally on your computer, extracting Gross Sales, Merchant Fees, Customer Refunds, and Sales Tax in milliseconds.
- Check the Balance Status: Verify the green “Balanced Journal Entry: Zero Difference” indicator. If small rounding differences occur from currency calculations, click “Auto-Balance Net Deposit” to balance the entry.
- Download & Import: Click “Export QBO Journal CSV” or “Export Xero Journal CSV”. Open your accounting software’s batch transaction importer and import the file. In your bank feed, click “Match” to link the imported journal to the cleared bank deposit.
Common questions bookkeepers ask
Reconciling Stripe, Shopify, and Amazon payouts is a common workflow challenge for e-commerce bookkeepers. Key accounting practices include:
- Avoid Clicking “Add” on Bank Feed Net Deposits: Direct-adding net processor payouts distorts sales tax liability accounts and causes businesses to miss deductible fee expenses on tax returns. Instead, post a clearing journal entry and click “Match” in the bank feed.
- Separate Amazon Marketplace Facilitator Tax: Since Amazon remits sales tax directly to states under Marketplace Facilitator Laws (MFL), sellers separate withheld tax out of liabilities to prevent double reporting on state returns.
- Automate Gross vs. Net Fee Splits: Using browser-based calculators removes manual spreadsheet formulas and keeps QuickBooks Online and Xero journals aligned with merchant payout exports to the exact cent.
Frequently Asked Questions (FAQ)
How does Acctbot compare to e-commerce accounting apps like A2X, Synder, and Bookkeep?
Cloud connectors like A2X, Synder, and Bookkeep charge monthly fees per connected store and require direct cloud API access to merchant accounts. Acctbot provides a free browser GAAP ASC 606 calculator that splits payout deposits into gross sales, processing fees, refunds, sales tax, and reserves with no subscription paywalls and no cloud uploads. For businesses and bookkeeping teams managing multiple stores, Acctbot’s commercial packages provide automations licensed and maintained while your plan is active, with data handling agreed in writing before any paid build.
Why do e-commerce sellers split net deposits into gross sales and fees?
For sellers acting as principal, ASC 606 generally calls for reporting gross sales, with processing fees as an expense. Confirm treatment with your CPA. E-commerce payment processors (Stripe, Shopify, Amazon) deposit net lump-sum amounts after deducting processing fees, customer refunds, and sales tax. This tool splits the net deposit into gross sales (credit), processing fees (debit), customer refunds (debit), and sales tax liabilities (credit), producing a balanced journal entry where total debits equal total credits to the exact cent.
What is an e-commerce clearing account and why should I use one instead of debiting my bank feed directly?
An e-commerce clearing account (for example, “Shopify Clearing Account” or “Stripe Holding Account”) is a dedicated asset account that temporarily holds payout funds between order placement and bank deposit. Because payouts clear 2 to 5 days after customer orders, debiting checking directly causes cash timing mismatches and complicates month-end reconciliations. Posting payouts to a clearing account lets you match the bank feed transfer, bringing the clearing balance to $0.00.
How much does a payment processor actually deduct from a $100 sale?
For a standard $100.00 US domestic credit card sale, Stripe and Shopify Payments (Basic) deduct $3.20 (2.9% + $0.30), leaving a net bank deposit of $96.80. PayPal Checkout deducts $3.98 (3.49% + $0.49, Net: $96.02). Square Online deducts $3.60 (3.3% + $0.30, Net: $96.40). Amazon Seller Central deducts an 8% to 15% category referral fee ($15.00 on most goods, Net: $85.00) before separate FBA pick/pack fees.
Can Stripe split payouts automatically between accounts or categories?
Stripe can programmatically split checkout charges among marketplace sellers via Stripe Connect. However, for a store’s own bookkeeping, Stripe deposits a single net lump sum into your checking account. Splitting this lump sum into gross sales, fees, and refunds for accounting requires a tool like Acctbot or manual journal entries.
Can you split payouts in Shopify into gross sales, fees, and refunds?
Inside Shopify Admin, payouts cannot be split into multiple deposits because Shopify bundles orders and sends a single net deposit to your connected bank account. For bookkeeping, you can split this lump-sum deposit into Gross Sales, Shopify Payments processing fees, refunds, and collected sales tax under GAAP ASC 606.
What should I do if my bank deposit doesn’t match the payment processor payout figure?
A difference between the processor payout report and the bank statement deposit usually indicates one of three items: an incoming bank wire fee deducted by your bank (typically $15 to $30), a merchant cash advance repayment (such as Shopify Capital or Stripe Capital), or a reserve hold. Check the memo line of your bank statement to identify any separate deductions.
How does the tool handle Amazon Marketplace Facilitator sales tax?
Under marketplace facilitator laws, Amazon collects and remits sales tax on behalf of sellers in most states. The tool separates marketplace facilitator tax into an offset entry so your business does not mistakenly record remitted tax as income or double-pay state sales tax on its return.
Why is this E-Commerce Settlement Splitter free to use?
Multi-channel e-commerce reconciliation across Shopify, Stripe, and Amazon is one of the most tedious manual tasks for bookkeepers and business owners. Offering this GAAP ASC 606 calculator for free lets you verify our built-in $0.00 balance check first. High-volume teams upgrade to Package 2 ($299/mo, or $249/mo on the 12-month plan) for automated nightly payout sync and Package 3 (Starting at $699/mo, or $599/mo on the 12-month plan) for multi-company consolidation, intercompany eliminations, custom reporting, and 13-week rolling cash flow dashboards. Automations are licensed and maintained while your plan is active, and data handling is agreed in writing before any paid build.