
How to Track Guest Damage Claims and Insurance Payouts

The Short-Term Rental Guide to Reconciling Stripe Payouts in QuickBooks Online

Booking Platform Fees on Your STR P&L: Where They Really Belong

How to Handle Resort Fees and Cleaning Fees in Your Books

The Right Way to Track Security Deposits in QuickBooks Online

Recording Airbnb Refunds, Cancellations, and Chargebacks

How to Categorize Wi-Fi, Streaming, and Utility Expenses for STRs

Tracking Cleaning Fees and Turnover Costs in QuickBooks Online

How to Record Airbnb Host Fees and Service Fees Correctly

Reconciling OwnerRez Payouts to QuickBooks Online Deposits
Quickbooks and Bookkeeping
The Short-Term Rental Guide to Reconciling Stripe Payouts in QuickBooks Online

Let’s be completely honest for a minute: if you take direct bookings and collect guest payments through Stripe, you’ve definitely looked at your bank feed and wanted to pull your hair out.
You open up your QuickBooks Online (QBO) dashboard, see a lump-sum deposit hit your account, and realize it doesn't match a single booking number on your ledger.
That exact financial gap is what trips up a lot of short-term rental operators. It isn't just an annoying math puzzle—it causes real, expensive errors in your property owner statements, totally skews your tax filings, and hides your legitimate business expenses.
If you want your short-term rental (STR) business to scale without a mess, you have to stop guessing. Here is the ultimate, peer-tested blueprint to handling Stripe payouts the right way.
Why Stripe Payouts Don't Match Your Booking Revenue
Stripe doesn't send you the full amount a guest pays.
Before the payout hits your account, Stripe deducts:
Processing fees (typically 2.9% + $0.30 per transaction for standard card payments)
Refunds already issued to guests
Disputes and chargebacks held back during review
So if a guest pays $1,000 for a booking, Stripe might send you $970.40 after its fee. If you record that $970.40 as revenue in QBO, you're understating income and losing the fee as a deductible expense.
That $29.60 matters. Across 50 bookings a month, you could be misrepresenting $1,480 in revenue and missing the same amount in legitimate deductions.
Gross vs. Net: Recording It the Right Way
The correct approach in QuickBooks Online is to record the gross amount the guest paid as revenue, then record Stripe's fee as a separate expense. The deposit you actually receive is the net - and it should tie to gross revenue minus fees.
Here's the structure:
Revenue account: Full booking amount (e.g., $1,000.00)
Expense account (Merchant Fees or Payment Processing): Stripe fee (e.g., $29.60)
Net deposit: $970.40
This keeps your revenue figures accurate for owner distributions, tax reporting (Schedule E or Schedule C depending on your structure), and profit-and-loss reporting.
Setting Up in QuickBooks Online
In QuickBooks Online, use a Sales Receipt or Invoice for the full booking amount. When Stripe deposits the net payout, create a corresponding entry that splits the deposit: a full revenue credit plus a debit to your merchant fee expense account.
Many operators use a Stripe clearing account - a current-asset or other-current-liability account in QuickBooks Online - to make this cleaner. Revenue posts to the clearing account on the booking date; fees and the actual deposit clear it when Stripe pays out. This makes the math visible and auditable.
Worked Example: A Single Stripe Payout
Let's say your direct booking site collected three guest payments in a rolling 2-day period:
Booking | Guest Payment | Stripe Fee | Net |
|---|---|---|---|
Cabin A | $850.00 | $24.95 | $825.05 |
Cabin B | $1,200.00 | $35.10 | $1,164.90 |
Cabin C | $600.00 | $17.70 | $582.30 |
Total | $2,650.00 | $77.75 | $2,572.25 |
Stripe batches these and sends a single payout of $2,572.25.
If you record $2,572.25 as income, you've:
Understated revenue by $77.75
Lost $77.75 in deductible processing expenses
Failed to allocate revenue correctly to three separate properties - and possibly three separate owners
The correct QBO entries record $2,650.00 in revenue split across three properties, $77.75 in merchant fee expense, and a $2,572.25 deposit line.
The Timing Problem
Stripe's payout schedule adds another wrinkle. By default, Stripe pays out on a rolling 2-day basis - a booking taken Monday might land in your account Wednesday. Some operators choose weekly or monthly payout schedules.
This creates timing differences between:
Booking date (when revenue is earned)
Payout date (when cash arrives)
For accrual-basis books, revenue should be recognized when earned - typically when the guest checks out or when the booking becomes non-refundable, depending on your policy. For cash-basis books, it goes in when you receive it. Either way, the Stripe payout date rarely matches the booking date, and if you're not careful, revenue can land in the wrong accounting period.
This matters most at month-end and year-end. A December 30 booking that pays out January 2 needs to land in the right tax year.
Multi-Property and Multi-Owner Complications
If you manage properties for multiple owners, a single Stripe payout might contain revenue belonging to five different owners. Each owner needs their portion correctly attributed in your owner statements.
A lump-sum deposit that doesn't map to individual bookings and properties makes owner statements unreliable. Owners may be paid incorrect amounts, or your trust accounting may fall out of balance - which creates both financial and legal exposure in many states.
Common Errors That Surface in QBO
These are the mistakes that appear most often when STR operators reconcile Stripe payouts in QBO:
Recording net instead of gross: The single most common error. Understates revenue, loses deductions.
Missing refunds: A refund processed through Stripe reduces the next payout. If you don't record the refund separately, the deposit looks short with no explanation.
Chargeback confusion: Disputes temporarily reduce payouts. If a dispute resolves in your favor, Stripe adds funds back. If not, the loss needs to go to the right expense category.
Payout-period mismatches: Bookings recorded in one month, payouts deposited in another, with no accrual entry to bridge them.
Misattributed property revenue: Revenue from Cabin B posted to Cabin A's ledger because the payout arrived as a single line.
These errors compound over time. Twelve months of net-instead-of-gross recording doesn't just create a tax problem - it creates inaccurate owner statements, wrong distributions, and a trust account that won't balance.
Stripe Data You Need Before Reconciling
Before you sit down to reconcile a period, pull these reports from your Stripe Dashboard:
Payouts report: Lists each payout, the date, and the total amount
Balance transactions report: Shows every charge, refund, and fee that contributed to each payout
Disputes report: Any open or resolved chargebacks in the period
The balance transactions report is the key one. It lets you match each Stripe charge to a specific booking, property, and owner - which is what you need to post revenue correctly in QBO.
Export the balance transactions CSV, filter by payout date, and you'll have a line-by-line breakdown of what's inside each deposit. That's your source of truth.
Frequently Asked Questions
Why doesn't my Stripe payout match my QuickBooks deposit?
Stripe automatically deducts processing fees and customer refunds before transferring money to your bank. Your bank statement shows the net payout, while your invoices record the gross sales. To fix this, you must record Stripe fees as a negative adjustment to balance the deposit.
What is a Stripe Clearing Account and do I need one?
A clearing account is a temporary "holding room" in your QuickBooks Chart of Accounts. It holds your gross sales receipts until the actual payout clears into your real bank account. Using one is highly recommended to prevent tax-reporting errors and handle month-end timing differences.
How do I handle Stripe refunds and disputes in QuickBooks?
When a refund occurs, Stripe returns the gross sales amount to the customer but retains its fixed transaction fee. In QuickBooks, you should record the refund against your clearing account and log the unreturned processing fee as a standard Stripe Fee Expense.
Should I use an app to automate Stripe-to-QBO reconciliation?
If you process more than 20 transactions per month, automation saves hours of data entry. Native tools like the Stripe Connector by QuickBooks or third-party apps like Acodei automatically match gross sales, log fee expenses, and clear your bank feed with one click.
By Jessica Hudson, CPA - specializing in short-term rental tax, bookkeeping, and financial operations for vacation rental hosts and property managers.