How to reconcile Stripe with QuickBooks Online, and when to automate it

Why don't Stripe payouts match QuickBooks deposits?

Stripe doesn't send you each payment separately. It collects payments, takes out its fees, subtracts refunds and disputes, and sends what's left to your bank as a payout. Stripe describes each automatic payout as the transfer that settles a batch of transactions. So your bank shows one deposit, while QuickBooks shows several invoices paid at their full amounts. The two only agree after you account for everything Stripe netted out of that batch.

Three more things cause mismatches:

• Timing. Stripe's payout reconciliation report groups payouts by their estimated arrival date, not the date your bank posts the deposit. Its data can also arrive later than the payout itself.
• Payment method. Bank debits like ACH take longer to settle than cards, so a payment can land in a later payout than you expect.
• Instant payouts. You choose the timing and amount of an instant payout, so Stripe can't tell you which transactions it included. You have to reconcile those yourself.

Which should you use: manual, a connector app, or a custom sync?

QuickBooks Online has no direct Stripe connection. Intuit says QuickBooks Online “can only integrate directly with QuickBooks Payments merchant services”. So for Stripe, the only option that uses QuickBooks' built-in tools alone is the manual Bank Deposit method.

How do you set up Stripe to QuickBooks reconciliation, step by step?

1. Use automatic payouts, or pick the right report. Stripe's payout reconciliation report covers automatic payouts. If you use manual payouts, Stripe points you to its Balance report instead.
2. Tag every payment with your own reference. Put your invoice or booking ID in the PaymentIntent's metadata. Stripe's itemized payout reconciliation export can include that metadata as a column, which lets you match each Stripe transaction to its QuickBooks record.
3. Set up the accounts in QuickBooks. Create an expense account for Stripe fees (Intuit suggests the “Bank charges” detail type). Then decide where payments wait before the payout lands. Undeposited Funds is QuickBooks' built-in holding account. For QuickBooks Desktop, Stripe's IIF export creates a separate bank-type “Stripe Account” that holds charges, refunds and payouts.
4. Record each payment at its gross amount. Use Receive payment against the invoice, deposited to Undeposited Funds, or to your clearing account if you set one up.
5. For each payout, list what's inside it. Download the itemized CSV from Stripe's payout reconciliation report. In code, list balance transactions filtered by the payout ID. Each balance transaction has a gross amount, a fee and a net, and Stripe recommends using its reporting_category field for accounting.
6. Create one QuickBooks deposit per payout. Select that payout's payments in the Bank Deposit screen. Add Stripe's fees as a negative line to your fee account, and account for any refunds and disputes in that payout. Then confirm the deposit total equals the payout amount.
7. Match the deposit to your bank feed. Once the deposit equals the payout, match it to the bank transaction in QuickBooks.
8. Send exceptions to a person. Anything that doesn't tie out goes to a named person to approve, instead of being guessed. That includes an unmatched payment, a partial refund or a dispute.
9. Automate what repeats. Once the manual steps work, move them into a connector or a custom sync. Stripe sends webhook events such as payout.paid, payout.failed, charge.refunded and charge.dispute.created that can trigger each step.

How should you handle Stripe fees, refunds and disputes in QuickBooks?

• Fees: Record sales at the gross amount and fees as an expense. Intuit's guide for third-party merchant services has you enter the fee as a negative amount on the Bank Deposit screen, coded to an expense account, so the deposit matches what the bank received.
• Refunds: Stripe doesn't return its processing fees from the original payment when you refund it. Your books should therefore show the refund and the fee you kept as separate items. Refunds come out of your available Stripe balance and lower that payout. A refund issued shortly after the charge may go through as a reversal, which works differently from a refund. A refund can also fail, in which case Stripe puts the money back in your balance.
• Disputes: When a customer disputes a charge, Stripe takes the disputed amount plus a dispute fee out of your balance. For businesses outside Mexico, the fee for receiving a dispute isn't refundable. If you counter the dispute and win, Stripe returns the separate “dispute countered” fee along with the disputed amount. Disputes can stay open for months, so track each one until it closes.
• Negative balances: If your refunds are larger than your new sales, your Stripe balance can go negative. Stripe can then create a payout that debits your bank account. Record it as money going out, not as a deposit.

What are the most common Stripe to QuickBooks reconciliation pitfalls?

• Recording net instead of gross. Revenue looks smaller and Stripe's fees disappear from your expenses.
• Matching on dates. Payout dates, the report's “estimated arrival” date and your bank's posting date can all be different. Match on the payout ID and amount instead.
• Duplicate or out-of-order webhooks. Stripe says webhook endpoints may get the same event more than once and doesn't guarantee the order events arrive in. A custom sync should track the event IDs it has already processed, quickly return a 2xx response, and do the actual work in a queue.
• Unverified webhooks. Check the Stripe-Signature header on every event before you act on it.
• Currency conversion. If you charge in one currency and settle in another, the balance transaction carries an exchange_rate. Record the deposit at the settled amount, and book any difference from the invoice amount as an exchange gain or loss (confirm the treatment with your accountant).
• Instant payouts. They don't come with a per-payout list of transactions, so reconcile them against your transaction history.
• QuickBooks API details. A QuickBooks Online Deposit needs a DepositToAccountRef, the bank account the money goes into, and it records payments moving out of Undeposited Funds into that bank account.

When should you hire a Stripe to QuickBooks consultant?

Hire help when:

• someone spends hours every week matching Stripe payouts by hand;
• payments come from several places (Stripe, ACH, checks, a booking engine) and none of them matches QuickBooks;
• a connector app is installed but its sync leaves unmatched deposits for someone to fix;
• your accountant keeps asking what a deposit was for;
• you want refunds, disputes and partial payments to go to a person for approval instead of being guessed.

When I take this on, I build inside the tools you already use. I map how each Stripe transaction should land in QuickBooks, write that down, and choose manual, a connector or a custom sync with you. Then I build it so that anything unusual waits for a named person on your team. You own what I build: it runs in your accounts, and you get the runbook. Start with the 3-Day Revenue Plumbing Fix if your payments and email setup both need work, or with integrations and syncs for a custom Stripe to QuickBooks flow.

What have I built with Stripe and QuickBooks?

This is how I describe my work for Alohause on diegogallovich.com: