Stripe Clearing Account in QuickBooks Guide

TL;DR

A Clearing Account (also referred to by CPAs as a holding account, wash account, or suspense account) is a virtual bank account created in your accounting software that mirrors an intermediary payment processor like Stripe.

Because Stripe batches customer payments together, deducts processing fees, holds reserves, and deposits lump sums days after individual sales occur, treating Stripe transactions as direct deposits into your checking account results in broken audit trails, distorted gross revenues, and impossible bank reconciliations.

By creating a dedicated Stripe Clearing bank account in QuickBooks Online:

Gross payments and processing fees live on separate clean lines in their own dedicated bank register, keeping your checking account feed uncluttered.
Lump-sum bank deposits are matched with a single click as internal transfers rather than manual splits.
Month-end reconciliation takes less than five minutes: the ending balance in your QuickBooks Stripe Clearing account should match your actual Stripe dashboard balance to the exact cent.

Using PayoutPrep automates the conversion of your Stripe balance reports into import-ready CSV batches tailored specifically for the QuickBooks Stripe Clearing workflow.

Why Online Businesses Need a Stripe Clearing Account

To understand why a clearing account is considered the gold standard of e-commerce and SaaS bookkeeping, consider how a standard transaction lifecycle unfolds over a 5-day business week:

Monday:    Customer A pays $100.00 (Stripe fee: $3.20)  -> Stripe Balance: +$96.80
Tuesday:   Customer B pays $50.00  (Stripe fee: $1.75)  -> Stripe Balance: +$145.05
Wednesday: Customer C pays $200.00 (Stripe fee: $6.10)  -> Stripe Balance: +$338.95
Thursday:  Stripe initiates a batch payout of $338.95   -> Stripe Balance: $0.00
Friday:    Your physical checking account receives a single lump sum deposit of $338.95

If you only account for transactions when money reaches your primary checking account on Friday, you face multiple accounting challenges:

Missing Fee Deductions: You cannot record the $11.05 in merchant processing fees as deductible business expenses unless you manually split the Friday deposit using a calculator.
Understated Gross Revenue: Categorizing the $338.95 deposit as “Sales Income” under-reports your true top-line sales ($350.00) by $11.05, causing discrepancies with your IRS Form 1099-K.
Timing Distortions: Sales that occurred on Monday, Tuesday, and Wednesday are reported as occurring on Friday, distorting weekly and monthly sales analytics.
Customer Refund Complications: If Customer A requests a refund before the payout arrives, the payout is reduced, making manual reconciliation nearly impossible.

The Stripe Clearing Account eliminates every single one of these problems by introducing a virtual holding container between Stripe and your physical bank.

Step 1: Create the Stripe Clearing Account in QuickBooks Online

Setting up the clearing account in QuickBooks Online takes less than two minutes:

Log into your QuickBooks Online company file.
In the left navigation menu, click Accounting (or click the Gear icon ⚙️ in the top header) and choose Chart of Accounts.
In the top-right corner, click the green New button.
Complete the account setup panel using the following settings:
- Account Type: Select Bank. (Critical: Do NOT select “Other Current Asset” or “Current Asset”. You must choose Bank so QuickBooks unlocks the Bank Transactions review feed, CSV file uploader, and official monthly bank reconciliation screen!)
- Detail Type: Choose Cash on hand or Checking.
- Account Name: Name the account Stripe Clearing (or Stripe Holding Account).
- Description: Temporary holding account for gross Stripe activity and fee splitting.
- Currency: Choose the primary settlement currency of your Stripe account (e.g., USD - US Dollar). If you operate multi-currency Stripe balances, create a separate clearing account for each currency (e.g., Stripe Clearing USD, Stripe Clearing EUR).
Set the starting balance to $0.00 if you are beginning at the start of an accounting period (or enter your actual verified Stripe balance if establishing mid-year).
Click Save and Close.

Your Chart of Accounts will now display a dedicated Stripe Clearing account tile in your Banking and Transactions menu!

Step 2: Export and Convert Your Stripe Activity Report

Now that your clearing account exists in QuickBooks, you need to populate it with clean transaction records:

Export the Right Stripe File: In your Stripe Dashboard, navigate to Reports → Balance. Under the header Balance change from activity, click Download.
- Make sure to select Itemized (never Summary).
- Select your target date range (e.g. Previous Calendar Month).
- Select your reporting timezone.
- Click Download to retrieve the CSV. (Note: Avoid the standard export under the Payments tab, as it omits payouts, fee refunds, and dispute holds!)
Convert the CSV Using PayoutPrep: QuickBooks Online requires CSV files to follow a strict 3-column or 4-column format with plain date strings, Windows CRLF line endings, and no timestamps or currency symbols. Furthermore, QuickBooks limits uploads to 1,000 transaction rows.
- Drag your exported Stripe CSV into PayoutPrep in your browser.
- PayoutPrep splits every transaction into a gross sale row, a fee row, and payout rows.
- Large files are automatically split under 999 rows each and packaged into a ZIP archive.
- Because conversion runs locally inside your browser, none of your customer or revenue data ever touches an external server.
Upload the Converted CSV to QuickBooks:
- In QuickBooks Online, go to Transactions → Bank transactions.
- Click the arrow next to Link account in the upper-right corner and select Upload from file.
- Drag and drop your converted CSV file.
- Select Stripe Clearing as the destination QuickBooks account.
- Confirm column mappings (Date, Description, Amount) and click Finish.

Step 3: Categorize Transactions in the Stripe Clearing Feed

Open the Stripe Clearing tile in your Bank Transactions tab. You will see individual, clean rows awaiting your review:

1. Customer Payment Rows (Money In)

Description: Stripe sale - customer@example.com
Amount: +$100.00
Action: Select the transaction → Set Category to your income account (such as Sales Income, Service Revenue, or Product Sales) → Click Add.

2. Processing Fee Rows (Money Out)

Description: Stripe processing fee
Amount: -$3.20
Action: Select the transaction → Set Category to your expense account (such as Stripe Processing Fees or Merchant Account Fees) → Click Add.

For detailed tax and expense rules, read our dedicated guide: How to Record Stripe Fees in QuickBooks Online (the Right Way).

3. Payout Rows (Money Out)

Description: Transfer to bank - Stripe payout po_101
Amount: -$96.80
Action: Select the transaction → Choose Record as transfer → In the Transfer to dropdown, select your primary Business Checking account → Click Add.

Step 4: The One-Click Match in Your Primary Bank Feed

Here is where the clearing account architecture proves its worth.

When you switch your view from Stripe Clearing to your real Business Checking bank feed:

Locate the bank deposit row sent by Stripe (e.g., +$96.80).
Notice that QuickBooks has automatically matched this incoming deposit against the transfer you just recorded from your Stripe Clearing account!
QuickBooks highlights the row in green with a single button: Match.
Click Match.

Both accounts are now updated simultaneously:

Your checking account cash increases by $96.80.
Your Stripe Clearing account cash decreases by $96.80.
Your Profit & Loss reflects $100.00 in gross revenue and $3.20 in tax-deductible fees.
Zero manual calculations, zero Excel spreadsheets, zero errors!

Step 5: Automating the Process with QuickBooks Bank Rules

You can automate nearly 90% of your Stripe Clearing categorization by setting up three simple Bank Rules in QuickBooks Online:

Rule 1: Auto-Categorize Stripe Processing Fees

Rule Name: Stripe Fees Auto-Add
Apply to: Stripe Clearing
Type: Money out
Condition: Description contains "Stripe processing fee"
Transaction Type: Expense
Category: Stripe Processing Fees
Auto-add: ON

Rule 2: Auto-Transfer Stripe Payouts

Rule Name: Stripe Payouts Auto-Transfer
Apply to: Stripe Clearing
Type: Money out
Condition: Description contains "Transfer to bank"
Transaction Type: Transfer
Transfer to: Business Checking
Auto-add: ON

Rule 3: Auto-Categorize Standard Sales

Rule Name: Stripe Sales Auto-Categorize
Apply to: Stripe Clearing
Type: Money in
Condition: Description contains "Stripe sale"
Transaction Type: Deposit
Category: Sales Income
Auto-add: OFF (Recommended to leave OFF so you can review individual customer invoices or accounts receivable if matching against existing QBO invoices).

Step 6: Monthly Balance Reconciliation (The CPA Checklist)

At the close of each calendar month, you can reconcile the Stripe Clearing account just like a traditional brick-and-mortar bank account to guarantee that your books are 100% audit-proof.

1. Retrieve the Ending Balance from Stripe

In your Stripe Dashboard, go to Reports → Balance, set the date filter to the last day of the month (e.g., March 31), and note your Ending Balance (for example, $540.20). This ending balance represents cash held in Stripe that has not yet been paid out to your bank.

2. Open the QuickBooks Reconcile Screen

In QuickBooks Online, navigate to Accounting → Reconcile. Select your Stripe Clearing account from the dropdown.

3. Enter Statement Details

Ending Balance: Enter the exact ending balance from Stripe ($540.20).
Ending Date: Enter the last day of the calendar month (e.g., 03/31/2026).
Click Start reconciling.

4. Check Off Cleared Transactions

Check the box at the top to select all transactions imported for the month. Because PayoutPrep verified that your gross sales, fees, and payouts matched your Stripe net report down to the cent, the Difference counter at the top of the screen will show:

$0.00 Difference

Click the green Finish now button. You have successfully reconciled your Stripe revenue for the month!

Troubleshooting Common Clearing Account Discrepancies

If your monthly reconciliation does not yield a $0.00 difference, check these three common culprits:

1. Deposits in Transit (Timing Differences)

A payout was initiated by Stripe on March 31, but did not clear your physical bank checking account until April 2.

Solution: The clearing account correctly reflects this money leaving Stripe on March 31. Do not delete or alter the date; simply record the transfer on March 31, and match it in your checking account feed when it posts on April 2.

2. Rolling Reserves and Dispute Holds

If Stripe places a 10% rolling reserve on your account or temporarily holds funds during an active dispute, your available balance will diverge from your total balance.

Solution: Always reconcile against the Total Ending Balance (which includes reserved funds) reported under Stripe Balance Reports, rather than just the “Available for Payout” balance.

3. Multiple Currency Transactions

If a European customer pays you in Euros (€100.00) while your clearing account is configured for USD, Stripe converts the currency at a specific exchange rate and charges a conversion fee.

Solution: Ensure that your CSV conversion separates currencies. PayoutPrep allows you to select which currency to convert and cleanly separates USD, EUR, GBP, and JPY transactions so foreign exchange gains/losses can be recognized accurately.

Summary & Next Steps

Adopting the Stripe Clearing Account method transforms payment reconciliation from a monthly bookkeeping nightmare into a streamlined, automated 5-minute routine:

Gross sales, refunds, disputes, and fees are segregated onto their own line items.
You maintain complete compliance with GAAP double-entry standards and IRS 1099-K reporting.
You avoid paying for expensive, invasive third-party synchronization apps.

Ready to start importing? Read our comprehensive walkthrough on How to Import Stripe Transactions into QuickBooks Online (2026 Guide), or jump straight to PayoutPrep to convert your first file for free!

Set Up a Stripe Clearing Account in QuickBooks (Step by Step)