How do I split Stripe processing fees in QuickBooks Online?

In QuickBooks Online, Stripe deposits the net amount into your bank, but your invoices reflect the gross amount. To reconcile without errors, create a Split Deposit with Line 1 as Gross Sales (Sales Revenue), Line 2 as Stripe Processing Fees (negative Expense), resulting in a net total matching the bank feed cleared deposit to the exact penny.

What is the Stripe Clearing Account method and why do bookkeepers recommend it?

The Stripe Clearing Account method is the industry-standard workflow recommended on r/Bookkeeping. Instead of matching hundreds of individual transactions in the bank feed, bookkeepers post gross sales, fees, and refunds to a Stripe Clearing bank account, and record payouts as simple transfers from the clearing account to the operating checking account.

How does the Beginning & Ending Balance Checksum prevent reconciliation errors?

QuickFinSync extracts Beginning Balance and Ending Balance from your bank statement header. It applies the mathematical formula (Beginning Balance + Inflows - Outflows = Calculated Ending Balance). If a bank line item or service charge is missing, QuickFinSync flags the exact variance before you import into QuickBooks.

What is a .QBO file and why is it better than CSV for QuickBooks?

A .QBO (QuickBooks Web Connect / OFX) file is an Intuit-standard financial exchange format. When imported into QuickBooks Online or Desktop, it automatically populates the Bank Feed without asking the user to manually map date, description, and amount columns.

Are my clients financial records and bank statements stored on your servers?

Solo conversions operate on 100% in-browser memory with zero server storage. For Bookkeeper Hub client links, the extracted transactions are sent over HTTPS, visible only to the bookkeeper, and automatically deleted after 7 days.

Does QuickFinSync work with Shopify Payments and PayPal Activity CSVs?

Yes. QuickFinSync features dedicated reconciliation engines for Shopify Payments and PayPal Activity downloads, automatically splitting processing fees, refunds, and generating balanced General Ledger journal entries.

Which payment processor has the lowest fees for e-commerce?

Square and Stripe domestic card rates (2.6% - 2.9% + $0.30) are typically lowest for direct web sales, whereas Amazon FBA take-rates typically range between 15% and 35% due to referral and fulfillment fees.

What is unrecovered refund fee leakage?

When a customer is refunded, payment processors like Stripe, Shopify Payments, and PayPal keep the original processing fees. This unrecovered fee expense is a direct loss that must be isolated in your bookkeeping.

2026 E-Commerce Margin & Clearing Audit Tool

Shopify, Stripe, Square & Amazon FBA Payout Fee Calculator

Calculate your exact net bank deposit after processing fees, Amazon FBA fulfillment fees, and unrecovered refund fee losses — plus generate a balanced QuickBooks clearing journal entry in one click.

Monthly Store Volume Parameters

Monthly Gross Sales ($)$50,000

Average Order Value — AOV ($)$75.00 (667 orders/mo)

Customer Refund Rate (%)4%

Payment processors do not return processing fees when you refund a customer.

Amazon FBA Fulfillment Fee ($ / unit)$4.75

Annualized Gateway Fee Spread

Highest Net Payout Direct Gateway: Square POS / In-Person ($46,599.95/mo net). Save up to $5,060.76/yr compared to standard PayPal Digital Checkout rates.

5-Channel Net Payout & Refund Fee Leakage Comparison

Based on 667 monthly orders at $75.00 AOV.

Channel / Processor	Total Fees	Refund Fee Loss	Effective %	Net Bank Deposit
Shopify Payments (Basic) 2.9% + $0.30	-$1650.10	-$66.10	3.30%	$46,349.90
Stripe Direct Checkout 2.9% + $0.30	-$1650.10	-$66.10	3.30%	$46,349.90
Square POS / In-PersonBest Net 2.6% + $0.15	-$1400.05	-$56.05	2.80%	$46,599.95
PayPal Digital Checkout 3.49% + $0.49	-$2071.83	-$83.03	4.14%	$45,928.17
Amazon Seller FBA (15% Referral + FBA) 15.0% Referral + $4.75/unit	-$10668.25	-$300.00	21.34%	$37,331.75

Balanced QuickBooks / Xero Clearing Journal Entry (Shopify / Stripe)

Reconciles gross order revenue, non-refundable processing fees, and refunds to $0.00 variance.

General Ledger Account	Debit ($)	Credit ($)	Audit Memo
1010 · Operating Checking Account (Bank Feed)	$46349.90	—	Net cleared payout deposit for 667 orders
6110 · Merchant Processing & Gateway Fees	$1650.10	—	Non-refundable gateway fees (includes $66.10 refund fee leakage)
4090 · Sales Returns & Customer Refunds	$2000.00	—	Customer refunds (4.0% return rate)
4000 · Gross E-Commerce Product Sales	—	$50000.00	Gross order volume reconciled to $0.00 clearing variance

Automate Your Actual Monthly Payout CSV

Convert Real Shopify, Stripe & Amazon Settlement CSVs into QuickBooks (.QBO)

Drop your raw settlement file into our browser-native Reconcile Studio to split fees, refunds, and net bank deposits automatically with $0.00 discrepancy.

Open Reconcile Studio