How to Reconcile Stripe Fees in QuickBooks Online (Step-by-Step)

To reconcile Stripe fees in QuickBooks Online, you need to account for the difference between the gross amount your customers pay and the net amount Stripe deposits in your bank — specifically by recording Stripe's processing fees as a separate expense. The cleanest method is to create a dedicated "Stripe Clearing" account, record the full transaction amount as income, then record Stripe's fee as an expense, so the net payout matches your bank deposit exactly.

This guide walks you through the step-by-step manual process, explains where it breaks down for growing businesses, and covers how to automate it entirely.

Why Stripe Reconciliation Is Harder Than It Looks

Every Stripe payout creates a math problem in your books.

When a customer pays $500, Stripe charges its standard fee — 2.9% + 30¢ on most US cards — and deposits $485.20 to your bank. If you record $485.20 as revenue, your books are wrong: you made $500 in revenue and spent $14.80 on processing fees. These are two separate line items.

At low transaction volume, this is annoying but manageable. At 50, 100, or 500 transactions a month — each with its own fee calculation, potential refunds, disputes, and multi-day payout timing — it becomes a bookkeeping nightmare. That's where most businesses fall apart.

The goal of reconciliation is to make three numbers agree:

1. Your Stripe dashboard (what came in)
2. Your QuickBooks books (revenue minus fees)
3. Your bank statement (net deposits)

Here's how to do it.

Step 1: Set Up a Stripe Clearing Account in QuickBooks Online

Stripe Clearing account

How to create it:

1. Go to Accounting → Chart of Accounts
2. Click New
3. Account Type: Bank
4. Detail Type: Checking
5. Name it: Stripe Clearing (or "Stripe Merchant Account")
6. Leave the opening balance at $0
7. Save

This account will never carry a balance if your reconciliation is correct — every dollar in should match every dollar out.

Step 2: Create a Stripe Fees Expense Account

You also need a dedicated expense account to track what Stripe charges you.

1. Go to Accounting → Chart of Accounts → New
2. Account Type: Expenses
3. Detail Type: Bank Charges
4. Name it: Stripe Processing Fees
5. Save

This keeps your processing costs visible in P&L reports and makes tax prep cleaner — payment processing fees are a deductible business expense.

Step 3: Record Each Stripe Transaction

For each Stripe payment, create a Sales Receipt or Invoice Payment in QuickBooks:

• Deposit To: Stripe Clearing (not your bank account)
• Amount: The gross amount the customer paid ($500.00)
• Customer/Product: as normal

This records full revenue before any fee deduction.

Step 4: Record the Stripe Fee as an Expense

For each transaction, record the fee Stripe charged:

1. Create an Expense in QuickBooks
2. Payment Account: Stripe Clearing
3. Category: Stripe Processing Fees
4. Amount: The fee Stripe charged (e.g., $14.80)

After this step, your Stripe Clearing account reflects the net amount — $500.00 in, $14.80 out, $485.20 remaining. That should match Stripe's payout.

Step 5: Record the Stripe Payout to Your Bank

When Stripe sends a payout to your bank (typically 2 business days after transactions settle):

1. Create a Transfer in QuickBooks
2. From: Stripe Clearing
3. To: Your business checking account
4. Amount: The payout amount (e.g., $485.20)

This moves the net amount from the clearing account to your bank, and brings the Stripe Clearing balance back to $0.

Step 6: Match Against Your Bank Statement

In QuickBooks Banking:

1. Go to Banking → Bank Transactions for your business checking account
2. Find the Stripe payout deposit
3. Click Match — it should match the Transfer you recorded in Step 5
4. If the amounts align, you're reconciled

If there's a discrepancy, check for: uncaptured authorizations, refunds processed during the payout period, or disputed charges. Stripe's payout breakdown in the dashboard will show the exact transaction list for any payout.

Where Manual Reconciliation Breaks Down

The 6-step process above works. The problem is repeating it dozens or hundreds of times a month — for every transaction, every fee, every refund, every dispute, every payout.

Here's what breaks:

Payout batching. Stripe groups multiple transactions into a single payout. One $2,341.17 deposit in your bank might represent 87 transactions. Recording each one individually is hours of work. Recording a lump sum means you lose the transaction-level detail your accountant needs.

Refunds and disputes. A refund in Stripe reverses the fee but at a different rate. A dispute (chargeback) adds a $15 fee from Stripe regardless of outcome. These edge cases don't follow the standard formula and frequently get miscategorized.

Multi-currency. If you accept payments in GBP, EUR, or other currencies, Stripe applies conversion fees on top of processing fees. Each currency creates its own reconciliation sub-problem.

Scale. At 10 transactions a month, manual reconciliation takes 30 minutes. At 300 transactions a month, it takes 10+ hours — hours your team could spend on anything else.

If you're processing more than ~50 Stripe transactions a month, manual reconciliation is costing you more in time than it's saving in software costs.

The Automated Approach: How Acodei Handles It

Acodei connects Stripe directly to QuickBooks Online and handles the entire reconciliation automatically:

• Every Stripe transaction is recorded at the gross amount to the correct income account
• Processing fees are recorded as expenses in real time — not at payout time
• Refunds and disputes are categorized correctly with no manual intervention
• Each payout is matched to its constituent transactions automatically
• Multi-currency transactions are converted and recorded with the correct exchange rate

The result: your Stripe Clearing account zeros out every payout cycle without you touching it. Your books reflect real revenue, real costs, and real cash — always.

See how Acodei syncs Stripe to QuickBooks →

Tips for Accurate Stripe Reconciliation

Reconcile by payout, not by day. Stripe pays out on a rolling basis. Reconcile each payout as a unit — it maps cleanly to a single bank deposit.

Don't record net revenue. A common mistake is recording only the net payout ($485.20) as revenue. This understates revenue and hides your processing costs from your P&L. Always record gross revenue + fee as a separate expense.

Use Stripe's payout export. For each payout, Stripe provides a CSV export of every transaction in that payout. This is your source of truth when reconciling manually.

Reconcile frequently. Weekly beats monthly. The longer you wait, the harder it is to trace discrepancies — especially for refunds and disputes that may post days after the original transaction.

Separate Stripe income by product type if needed. If you sell multiple product lines through Stripe, consider separate income accounts per category. Acodei can map Stripe metadata (product ID, customer type) to different QuickBooks accounts automatically.

Frequently Asked Questions

Why doesn't the Stripe payout match my invoice total?

Stripe deducts its processing fees before sending your payout. A $500 payment becomes a ~$485 deposit after Stripe's 2.9% + 30¢ fee. The gap is the fee — which you should record as a separate expense, not a revenue reduction.

How do I record a Stripe refund in QuickBooks Online?

Refund Receipt

What account type should Stripe Clearing be in QuickBooks?

Bank type (checking sub-type). This lets you run reconciliation reports against it and match bank transactions to it properly. Using a current liability or other asset type causes problems in reconciliation workflows.

How do I handle a Stripe dispute (chargeback) in QuickBooks?

A dispute reverses the original transaction and adds a $15 dispute fee from Stripe. In QuickBooks: reverse the original sales receipt, create an expense for the $15 dispute fee to your Stripe Processing Fees account. If you win the dispute, Stripe reverses the fee — record that as a credit. Acodei handles this automatically including the outcome-based fee reversal.

Can I connect Stripe directly to QuickBooks Online?

QuickBooks has a native Stripe connector, but it has limitations: it doesn't handle payout-level reconciliation well, doesn't support multi-currency fee accounting, and requires manual intervention for refunds and disputes. Purpose-built tools like Acodei offer more complete automation with transaction-level detail.

How long does Stripe take to pay out?

Payouts

Does Stripe charge fees on refunds?

Stripe does not refund the processing fee when you issue a refund on most plans. So if you refund a $500 payment, Stripe returns $500 to the customer but keeps the $14.80 processing fee. On Stripe's custom pricing plans, this policy may differ. Always record the net cost of a refund in QuickBooks — the full refund plus the unrecovered fee.

Summary

Reconciling Stripe fees in QuickBooks Online comes down to one core principle: record gross revenue, record fees as a separate expense, and use a clearing account to bridge the gap between Stripe and your bank. Follow the 6 steps above for a clean manual setup.

If you're processing at volume, manual reconciliation doesn't scale — and the errors compound over time. Acodei automates the entire workflow: every transaction, fee, refund, and payout mapped to the right QuickBooks accounts without the spreadsheets.

Start your free trial → or learn more about Acodei's Stripe-QuickBooks integration.