Why platform reports are not enough
Airbnb and Vrbo reports are built to show you activity, not profitability. They mix this month's stays with next month's payouts, quote gross numbers before fees, and say nothing about what a stay cost you — the cleaner's invoice, the supplies, the utilities burned by a full house in August. Hosts who rely on the dashboard alone routinely discover at tax time that their “great year” was a mediocre one, and that reconstructing per-stay numbers from payout emails takes a full weekend.
An income and expense tracker spreadsheet fixes this with one discipline: one row per stay, logged when the stay happens, with the handful of numbers that decide whether hosting pays.
What to track for every stay
| Per-stay field | What it tells you |
|---|---|
| Check-in / check-out & nights | Nights are the denominator of everything — occupancy, ADR and RevPAR all start here. Calculate nights from the dates; never type them. |
| Platform & guest | Airbnb vs. Vrbo vs. direct bookings have very different fee structures. Knowing your mix is knowing your margin. |
| Gross booking amount | The headline number — useful, but only as the starting point. |
| Platform service fee | Typically 3% on a host-only fee structure, up to ~14–16% of the booking subtotal where the split-fee lands mostly on you via pricing pressure. Log the actual fee per stay; averages lie. |
| Cleaning fee charged vs. cleaning cost | Two different numbers. If you charge guests $75 and pay your cleaner $95, cleaning is a quiet $20 loss on every stay — multiplied by 40 stays a year. |
| Net payout | Gross minus platform fees (and any adjustments). The number that should reconcile with your bank deposits. |
The three metrics that summarize the year
- Occupancy rate — nights booked ÷ nights available. Tells you whether the calendar is the problem.
- ADR (average daily rate) — room revenue ÷ nights booked. Tells you whether pricing is the problem.
- RevPAR — ADR × occupancy (equivalently, room revenue ÷ nights available). The single number that combines both, and the one experienced hosts compare month over month and against their long-term-rent alternative.
In the Tracker's included sample, a short-term unit logs 12 stays and 45 nights for $10,495 gross, a $233 ADR and a $28.75 RevPAR — modest occupancy, strong rate, which points the owner at marketing the empty nights rather than cutting price. That is the kind of conclusion a payout list never gives you.
Expenses: the other half of the sheet
Stay-level income is only half the picture. The property still has mortgage interest, taxes, insurance, utilities, repairs and supplies — and those belong in the same workbook as your long-term rentals, categorized the same way, so year-end reporting is one exercise instead of two. Short-term hosts also carry costs long-term landlords do not: restocking consumables, laundry, platform tools, and more frequent wear-and-tear repairs. Log them as they occur, in the same expense categories you use for every property, and your Schedule E worksheet totals stay consistent across the whole portfolio.
Tax note, honestly: whether a short-term rental is reported on Schedule E or Schedule C depends on average stay length and the services you provide — it is genuinely fact-specific. A tracker cannot make that call for you; what it can do is keep per-stay and per-category records clean enough that your CPA makes the call in minutes instead of billing you for a reconstruction.
The Bundle: long-term and short-term, one workbook
The Rental Property Tracker Bundle adds a dedicated STR (Airbnb) sheet to the full tracker: one row per stay with platform, gross, platform fee, cleaning charged and cleaning cost, nights and net payout calculated automatically, and a summary block that totals bookings and nights and computes occupancy, ADR and RevPAR. Your long-term units keep using the rent roll and income ledger; your short-term units feed the same Dashboard, Monthly P&L and expense categories. One file for a mixed portfolio — see the full feature list.
Long-term only? The Standard Tracker is $29 and covers everything except the STR sheet.
FAQ
Can't I just download my Airbnb transaction history?
You can, and you should keep it — but it shows gross amounts and payouts, not your cleaning costs, supplies or utilities, and it does not compute occupancy, ADR or RevPAR against your available nights. The tracker combines platform numbers with your real costs in one place.
How is RevPAR different from ADR?
ADR measures the rate you achieved on nights you sold. RevPAR measures revenue across all available nights, sold or not — so it punishes empty calendars. A rising ADR with a falling RevPAR usually means prices went up and bookings went down.
Does the STR sheet work for Vrbo and direct bookings too?
Yes. Platform is a column on every stay row, so Airbnb, Vrbo and direct bookings sit in the same log with their own fee amounts (zero, for a direct booking) and roll into the same summary.
Does it work in Google Sheets?
Yes — standard .xlsx, ordinary formulas, no macros. Upload to Google Sheets and everything carries over.
Will this tell me whether to report on Schedule E or Schedule C?
No — that determination depends on your average stay and services, and belongs to your tax professional. The Bundle keeps the underlying per-stay records complete and categorized so the question is easy to answer with good data. See the disclaimer below.