How to Reconcile Stripe Payouts in QuickBooks Online

Stripe bundles dozens — sometimes hundreds — of individual transactions into a single bank deposit, deducts its fees before the money leaves, and gives QuickBooks no native way to interpret the net figure. The result: your bank feed shows one number, your Stripe dashboard shows another, and your books show a third. This guide covers the exact steps to fix that using the clearing account method accountants recommend. It works whether you reconcile manually or use an automated tool.

Table of Contents

• Why Stripe Reconciliation in QBO Is Tricky
• Set Up Your QuickBooks Chart of Accounts
• Method 1: Manual Reconciliation Step by Step
• Method 2: Automate with a Stripe-QBO Integration Tool
• Common Mistakes and How to Avoid Them
• Manual vs Automated: Quick Comparison
• Frequently Asked Questions

Why Stripe Reconciliation in QuickBooks Is Tricky {#why-tricky}

Most accounting problems with Stripe come down to three structural issues that do not exist with simpler payment setups.

Bundled payouts. Stripe batches all charges processed over a rolling period — typically two business days — into a single lump-sum deposit. That one deposit could represent 5 transactions or 500. When QuickBooks imports your bank feed, it sees a single line item with no breakdown.

Gross vs. net deposits. Stripe deducts its processing fees before sending the payout. On a standard online card transaction, Stripe charges 2.9% + 30¢ per transaction in the US (1.5% + 25¢ for European cards). If you processed $2,000 in sales, your bank receives roughly $1,942 after fees. Recording $1,942 as revenue understates your gross income and eliminates any record of the $58 in processing fees.

Refunds offset future payouts. When you issue a refund, Stripe deducts it from a future payout rather than sending a separate reversal. Each refund must be recorded individually — not as a deposit adjustment — to keep your accounts receivable and income records accurate.

No native QuickBooks integration. QuickBooks Payments has deep native sync inside QBO. Stripe does not. Every Stripe transaction must reach QuickBooks through manual entry or a third-party connector — there is no official Stripe app built into QBO that handles this correctly.

Set Up Your QuickBooks Chart of Accounts {#setup}

Before reconciling a single payout, you need three items in your QBO account. Get this structure right once and every future reconciliation follows the same clean pattern.

Step 1: Create a Stripe Clearing Account

This is the foundation of the whole method. The clearing account acts as a virtual holding account for all Stripe activity — sales, fees, and refunds — before the net amount transfers to your real bank account.

1. Go to Accounting > Chart of Accounts in QBO.
2. Click New.
3. Set Account Type to Bank.
4. Set Detail Type to Checking.
5. Name it "Stripe" or "Stripe Clearing Account."
6. Set the opening balance to $0.00.
7. Click Save and Close.

Setting the account type to Bank (not Current Asset) is deliberate — it allows QBO to use the account in bank reconciliations and bank deposits, which you will need in the steps below.

Step 2: Create a Stripe Fees Expense Account

Stripe fees are a real business expense and need their own account so they appear correctly on your Profit & Loss statement.

1. Go to Accounting > Chart of Accounts > New.
2. Set Account Type to Expenses.
3. Set Detail Type to Bank Charges.
4. Name it "Stripe Fees" or "Merchant Processing Fees."
5. Click Save and Close.

Step 3: Create a Stripe Fees Service Item

This item lets you reference the Stripe Fees expense account when creating bank deposits, which is how you will record the fee deduction in each payout cycle.

1. Go to Sales > Products and Services > New.
2. Choose Service.
3. Name it "Stripe Processing Fee."
4. Under Income/Expense Account, select the Stripe Fees expense account you just created.
5. Click Save and Close.

Method 1: Manual Reconciliation Step by Step {#manual}

With your chart of accounts set up, the manual method has seven steps. Follow them in order for each payout you need to reconcile.

Step 1: Download Your Stripe Payout Report

Log in to the Stripe Dashboard and go to Balances > Payouts. Click the specific payout you want to reconcile and click Download. Set the report format to "Itemized" and select all columns. This CSV lists every charge, refund, fee, and adjustment in that payout. Keep it open in a spreadsheet — you will cross-reference every QBO entry against it.

Step 2: Record Each Sale into the Stripe Clearing Account

For each customer payment in the payout CSV, create a corresponding record in QuickBooks at the full gross amount — what the customer paid, not what Stripe deposited.

If you invoice customers through QBO:

1. Go to + New > Receive Payment.
2. Select the customer and apply the payment to the correct open invoice.
3. Set Deposit To to your Stripe Clearing Account.
4. Enter the gross payment amount.
5. Click Save and Close.

If you do not use invoices (e.g., for e-commerce or direct sales):

1. Go to + New > Sales Receipt.
2. Add the product or service sold.
3. Set Deposit To to your Stripe Clearing Account.
4. Enter the gross sale amount.
5. Click Save and Close.

Repeat for every charge line in your payout CSV.

Step 3: Record Stripe Fees as a Negative Deposit Line

Once all sales are recorded in the clearing account, offset the fees.

1. Go to + New > Bank Deposit.
2. Set the Account to Stripe Clearing Account.
3. Set the date to the payout date.
4. Scroll to the Add funds to this deposit section.
5. Add a line item:
   • Account: Stripe Fees (your expense account)
   • Amount: enter the total fee as a negative number (e.g., -58.00)
6. Click Save and Close.

The negative amount reduces the clearing account balance by the fee total and simultaneously records the expense. Never enter the fee as a positive number — this inflates the clearing account instead of reducing it.

Step 4: Record Any Refunds

For each refund line in the payout CSV:

1. Go to + New > Refund Receipt (if the original sale was a Sales Receipt) or Credit Memo (if the original sale was an invoice).
2. Select the customer and the original product or service.
3. Enter the refund amount at the gross value.
4. Set the Refund From account to your Stripe Clearing Account.
5. Click Save and Close.

This reduces the clearing account balance to reflect each refund Stripe already deducted from your payout.

Step 5: Verify the Clearing Account Balance

Before moving money to your real bank account, confirm the math. Open the Stripe Clearing Account register and verify that the current balance equals the exact net payout amount. If it does not, compare the register line by line against your Stripe CSV to find the discrepancy. Common causes: a fee entered as positive instead of negative, a refund not recorded, or a transaction accidentally posted to the wrong period.

Step 6: Record the Payout Transfer to Your Bank

When the clearing account balance matches the net payout amount exactly:

1. Go to + New > Transfer.
2. Transfer Funds From: Stripe Clearing Account.
3. Transfer Funds To: your main business bank account.
4. Enter the exact net payout amount.
5. Set the date to the date the deposit actually appeared in your bank — not the date Stripe initiated the transfer (these are often 1–2 business days apart).
6. Click Save and Close.

Step 7: Match and Reconcile in Your Bank Feed

1. Go to Banking > Bank Transactions.
2. Find the Stripe deposit in your bank feed.
3. Click Match — QBO should detect the transfer you just recorded.
4. Confirm the match.

Once all payouts for the month are matched, go to Accounting > Reconcile, select your main bank account, enter the closing balance from your bank statement, and tick off each transaction. The difference should be $0.00. The Stripe Clearing Account should also show a $0.00 balance — confirming every dollar flowing through Stripe is fully accounted for.

Method 2: Automate With a Stripe-QBO Integration Tool {#automate}

Manual reconciliation is manageable at low volumes. Once you cross 50–100 Stripe transactions per month, the manual method takes 2–3 hours and introduces significant room for data entry errors. Automation tools handle the entire process without any manual steps.

When evaluating a Stripe-QBO tool, look for four things: (1) gross-amount sync — each charge recorded at the full customer payment, not net of fees; (2) automatic fee recording to a separate expense account; (3) payout matching that creates a transfer QBO can auto-match to your bank deposit; and (4) individual refund handling, not folded into the deposit total.

Reconkept is built specifically for this problem. It connects to both Stripe and QuickBooks Online, reads each payout in full detail, and writes the correct sequence of transactions — gross sales, fee deductions, refunds — into your Stripe Clearing Account automatically. When the payout arrives in your bank, QBO matches it without any manual input.

Other tools in this space include Synder (strong for service businesses and SaaS, from ~$11/month), PayTraQer by SaasAnt (transaction-based pricing, suited for high volume), and A2X (payout-summary journal entries, preferred by accountants for audit-ready output).

Common Mistakes and How to Avoid Them {#mistakes}

• Recording the net deposit as revenue. The most common error is importing the Stripe bank deposit directly as income. This understates gross revenue and eliminates the fee expense from your P&L entirely. Always record gross sales first, then record fees separately as a negative line.

• Entering fees as a positive number. In the Bank Deposit screen, fees must be entered as a negative value (e.g., -58.00). A positive entry inflates the clearing account balance and makes it impossible to match the payout transfer.

• Missing refunds. Refunds reduce your payout amount but do not appear as a separate bank entry — they are simply subtracted from the next deposit. If you skip recording a refund in QBO, your clearing account balance will be higher than the payout amount and the transfer will not match.

• Using the wrong account type for the clearing account. Setting up the Stripe account as a Current Asset instead of a Bank account prevents you from using it in bank deposits and reconciliations. It must be set as Bank type.

• Using the payout initiation date instead of the deposit date. Stripe shows when it initiated a payout in the dashboard, but funds typically arrive in your bank 1–2 business days later. If you use the initiation date for the transfer in QBO, the bank feed match will fail because the dates do not align.

• Not reconciling per payout. Leaving multiple payouts unreconciled until month-end makes discrepancies much harder to trace. Reconcile each payout as soon as it appears in your bank account. For businesses on Stripe's standard automatic payout schedule, this means weekly.

Manual vs Automated: Quick Comparison {#comparison}

Frequently Asked Questions {#faq}

How do I reconcile a Stripe payout in QuickBooks? {#faq-how}

Create a Stripe Clearing Account (bank type) in your QBO Chart of Accounts. Record each charge at the gross amount into the clearing account, add the total Stripe fee as a negative line in a bank deposit, and record any refunds as Refund Receipts or Credit Memos against the same account. Then create a Transfer from the clearing account to your real bank account for the exact net payout amount and match it in your bank feed. The clearing account balance should reach $0.00 when the reconciliation is complete.

Why does my Stripe balance not match QuickBooks? {#faq-mismatch}

The most common cause is the gross vs. net discrepancy. Stripe deducts processing fees (2.9% + 30¢ per online transaction in the US) before sending your payout, so the bank deposit is always smaller than total sales. Without a clearing account and a separate fee entry, those two figures will never reconcile directly. Other causes include unrecorded refunds, timing differences between when Stripe initiated the payout and when it appeared in your bank, and unreconciled balances carried over from a previous period.

Should Stripe be a bank account in QuickBooks? {#faq-bank-account}

Yes. Set up a Stripe Clearing Account as a Bank type account (with a Checking detail type) in QBO. Using the Bank type is deliberate — it enables the account to be used inside bank deposits, transfers, and the standard QBO bank reconciliation tool. If you set it up as a Current Asset instead, you lose access to these workflows and the reconciliation process becomes significantly more complicated.

How do I record Stripe fees in QuickBooks Online? {#faq-fees}

Create a dedicated expense account under Bank Charges named "Stripe Fees." When recording a Bank Deposit in your Stripe Clearing Account, scroll to the "Add funds to this deposit" section and add a line using the Stripe Fees account with a negative amount equal to the total fees for that payout (e.g., -58.00). This reduces the clearing account balance by the fee amount and posts the expense to your Profit & Loss in one step. Never net fees against revenue — always record them as a discrete expense line.

What is a Stripe clearing account in QuickBooks? {#faq-clearing}

A Stripe clearing account is a bank-type account in your QuickBooks chart of accounts that temporarily holds all Stripe activity — charges, refunds, and fee deductions — before the net amount transfers to your real bank account. When Stripe sends a payout, you record a transfer from the clearing account to your actual bank account for the exact net deposit amount. If everything is entered correctly, the clearing account reaches $0.00 after the transfer, confirming that gross sales, fees, and refunds all reconcile to the payout. This account holds no real money; it exists purely as a bookkeeping intermediary.

How do I handle Stripe refunds in QuickBooks? {#faq-refunds}

Record each refund as a Refund Receipt (if the original sale was a Sales Receipt) or a Credit Memo (if the original sale was an invoice). Set the account to your Stripe Clearing Account and enter the full gross refund amount. This reduces the clearing account balance to match the reduced payout amount on the Stripe side. Note that Stripe may return a portion of the processing fee on refunded transactions — check your payout CSV to confirm the exact fee reversal and adjust your fee line accordingly.

Can I connect Stripe directly to QuickBooks? {#faq-native}

QuickBooks Online has no built-in native integration with Stripe. QuickBooks Payments is Intuit's own processor and the only one with a deep native sync inside QBO. For Stripe, your two options are the manual clearing account method described in this guide or a third-party connector. Tools like Reconkept, Synder, PayTraQer, and A2X connect Stripe to QBO and automate transaction sync. Some appear in the QuickBooks App Store, but none are built by Intuit and none are included with a standard QBO subscription.

How often should I reconcile Stripe in QuickBooks? {#faq-frequency}

Reconcile with every payout. Stripe's default schedule sends funds on a rolling daily or weekly basis depending on your account settings. Reconciling per payout keeps each session short — one payout CSV, not a month of accumulated data — and makes discrepancies easy to catch before they compound. At a minimum, reconcile whenever you close your books for the month. Waiting until month-end means tracing which transactions belong to which payout period across multiple CSVs, which adds significant time to the process.