The Airbnb → bank reconciliation gap: why deposits never match Line 3
Every Airbnb operator I know can tell you what hit their bank account last month. Almost none can tell you the gross booking revenue those deposits represent. That gap, between your Airbnb payout and your actual Schedule E Line 3 rents received, is the single most common source of mis-stated STR tax returns. On a five-door portfolio, it typically costs $6,000 to $10,000 a year in mis-categorized income, understated deductions, and downstream errors that cascade through cost-seg allocations and §469 math.
The four layers of the gap
A single Airbnb payout to your bank is the net result of at least four adjustments layered on top of the gross booking amount:
1. Host service fee (15.5% for most US hosts in 2026)
Airbnb moved hosts connected to property-management software to a single host-only fee of 15.5% on October 27, 2025, and has since retired the old split fee (about 3% to the host, the rest charged to the guest) for most remaining hosts, per Hospitable's fee explainer. The fee is taken on the booking subtotal, cleaning fee included, and deducted before the payout hits your bank. If your 2025 books show a 3% fee, that was right then; check which structure applied in which months. On the tax return, this is a deductible expense (commissions/management fees, Schedule E Line 8 or Line 11 depending on how your CPA categorizes it), not a reduction of gross rent.
2. Cleaning fee passthrough
Airbnb collects the cleaning fee from the guest gross, then remits it to you as part of your payout. On Schedule E, the cleaning fee is gross rent income on Line 3, and the amount you actually pay your cleaner is a separate deductible expense on Line 14 (cleaning & maintenance). If you book only the net, you've collapsed both sides and lost the audit trail.
3. Occupancy tax collected and remitted
In many jurisdictions (and by default in ~30 states plus most cities with STR-specific ordinances), Airbnb collects lodging/occupancy tax from the guest and remits it directly to the taxing authority. You never touch that money, but if you're pulling revenue reports the wrong way, you can accidentally book it as your income. It's neither income nor a deduction to you (Airbnb is the pass-through remitter).
4. Payment processor timing
Airbnb pays out roughly 24 hours after check-in, not at booking. A reservation booked and checked in on December 30 pays out January 2, landing in the wrong tax year if you use the cash-basis bank deposit as your revenue trigger. IRS Publication 527 permits both cash and accrual methods for rental activities, but you have to pick one and apply it consistently. A "mostly cash except when it's inconvenient" approach is what gets flagged.
What the IRS actually wants on Schedule E Line 3
Schedule E, Line 3 asks for "Rents received." The same form gives commissions their own expense line (Line 8) and management fees theirs (Line 11), which only works if Line 3 is measured before the platform takes its cut. For platform bookings, that means the rent and fees the guest was billed, less only bona fide refunds and chargebacks. It is also the basis the platform reports: the Form 1099-K gross amount carries no adjustment for fees (Form 1099-K instructions).
Under the host-only fee, a deposit-based Line 3 is short by 15.5% of every Airbnb subtotal before anything else goes wrong. Net income can still come out right, because the missing fee is also missing from Line 8. What breaks is everything that reads gross: the 1099-K match, the revenue a lender underwrites, and the revenue an examiner sets next to the hours you log for §469 material participation and the STR loophole.
Comparison: what each tool books
| Booking event | Gross amount | What a bank-feed-only tool books (Baselane / QBO) | What Schedule E Line 3 wants |
|---|---|---|---|
| Nightly rate × nights | $3,800 | Rolled into one deposit | $3,800 on Line 3 |
| Cleaning fee (guest paid) | $275 | Rolled into deposit | $275 on Line 3 |
| Occupancy tax (Airbnb remits) | $342 | Sometimes rolled in, sometimes ignored | $0 (pass-through) |
| Host service fee (15.5% of $4,075) | ($632) | Netted out of deposit | Expense on Line 8/11 ($632) |
| Actual bank deposit | $3,443 | Booked as revenue | n/a |
| Correct Line 3 | $4,075 | $3,443 (understated by $632) | $4,075 |
A fair note on Stessa, because accuracy matters more than a clean table. Stessa does split the booking correctly if you use its Airbnb CSV importer — its own documentation says "Airbnb reports two line items per stay… Gross income (Money In), Host fee (Money Out)." The catch is the workflow, not the capability: that split only happens on a manual CSV upload, and the same help article warns that "if you've also connected a bank account in Stessa, check for duplicates and delete as needed." So the correct number and the automatic number fight each other, and you are the referee every month. Stessa is also candid that feeds break at all — its bank-connections fact sheet says connections "are inherently complex and sometimes unreliable." Baselane and QuickBooks are characterised above as booking the net deposit; Stessa is better than that and worth crediting for it.
One booking, a $632 gap. It is not $632 of tax: the fee is deductible, so the deposit method understates revenue and expenses by the same amount. The cost is a return whose Line 3 will not tie to the 1099-K, and a CPA who cannot see what the platform charged you all year. Illustrative figures; your own reservation export has the real ones.
How to reconcile correctly
Whether you use RentReel or a spreadsheet, the reconciliation is the same three steps:
- Pull the reservation-level report from your PMS or Airbnb host dashboard, not the payout report. The reservation report shows gross booking amount, cleaning fee, taxes, and fees as separate line items.
- Sum the reservation-level gross (nightly + cleaning fee guest paid). That's Line 3.
- Book the host service fee and the cleaner payment on their own expense lines, and keep occupancy tax the platform remitted off the books entirely. The bank deposit is now a reconciling event, not a revenue event.
If you book Airbnb deposits as revenue on the host-only fee, your Line 3 is short by at least 15.5% of every Airbnb subtotal. Fixing it is worth doing before you file 2026. The gross-vs-net PMS trap covers the same problem in PMS exports.
RentReel is bookkeeping software, not a CPA or tax preparer. Every number RentReel produces is an estimate based on data you provide and IRS rules as published. Always have a licensed CPA review your Schedule E before filing.
How RentReel handles it
RentReel parses the reservation itself, from Hospitable, OwnerRez, or a CSV export from any PMS, and builds Schedule E from the gross booking amount. Cleaning fees, host service fees, and occupancy tax remittances land on their correct expense (or pass-through) lines automatically. The bank deposit becomes a reconciling event that ties the reservation-level revenue to your bank ledger, not the source of truth.
Investor ($79/mo · free 14-day trial, no card required) builds Line 3 from the reservation-level gross and tags the matching platform payouts as transfers, so a deposit is never counted as revenue twice. If you're going into Q4 with a gross-rent number you're not confident in, load a quarter of reservations and compare the Line 3 total to the number you were about to report.
Frequently asked questions
Why doesn't my Airbnb payout match my gross booking revenue?
Four things sit between them. Airbnb deducts its host service fee before paying you (15.5% of the booking subtotal for most US hosts in 2026). The guest-paid cleaning fee rides inside the payout. Occupancy tax is often collected and remitted by Airbnb and never reaches you. And the payout arrives about 24 hours after check-in, so a December 30 check-in can be paid in January.
What goes on Schedule E Line 3 for Airbnb income?
The rent and fees the guest was billed (nightly rate plus cleaning and other guest-paid fees) before Airbnb takes its service fee, less only bona fide refunds. Schedule E gives commissions and management fees their own expense lines, which only works if Line 3 is measured before them. On the 15.5% host-only fee, a Line 3 built from bank deposits is short by 15.5% of every Airbnb subtotal.
Is occupancy tax that Airbnb remits my income?
No. Where Airbnb collects lodging tax from the guest and remits it to the taxing authority, it is neither income nor a deduction to you. It usually lands on a return by mistake, when revenue is pulled from a report that includes the tax collected.
How do I reconcile Airbnb payouts correctly?
Pull the reservation-level report, not the payout report. Sum nightly rent plus guest-paid fees for Line 3. Book the host service fee and your cleaner payments on their own expense lines, and leave platform-remitted occupancy tax off the books. The bank deposit then becomes a reconciling event, not revenue.
Sources cited
- IRS Publication 527 (2024): Residential Rental Property (Including Rental of Vacation Homes) · cash vs accrual, gross-rent reporting
- IRS Schedule E Instructions (2024) · Line 3 rents received, Lines 8, 11, 14 expense categorization
- IRS Topic 415: Renting Residential and Vacation Property
- Airbnb Help Center: Occupancy Tax Collection & Remittance · which jurisdictions Airbnb remits directly
Related deep dives
Want RentReel to run this reconciliation on your books?
Drop a Hospitable, OwnerRez, or Airbnb-direct CSV into RentReel and get Line 3 built from the reservation-level gross with the host fee, cleaning, and occupancy tax on their own lines, and platform deposits tagged as transfers instead of revenue. Start free, no card required · 14 days of everything on Investor ($79/mo).