STR Host Income & Expense Tracker — Airbnb, Vrbo & Booking.com fees, cleaning costs & tax set-asides (Excel + Google Sheets)
See your STR's real profit — platform by platform, booking by booking.
STR Host Income & Expense Tracker is a single spreadsheet system for Airbnb, Vrbo and
Booking.com hosts who want every dollar in one place without paying for accounting
software.
WHAT'S INSIDE
- Dashboard — income vs expenses by month (with chart), YTD profit, bookings and nights
booked, average income per night, a full expense-category breakdown, and a platform
scorecard showing what each channel's fees really cost you. All automatic.
- Transactions — log every payout and cost with Type/Category dropdowns made for STR:
cleaning & turnover, Airbnb / Vrbo / Booking.com fee categories, utilities, supplies,
furnishings (with a depreciation note), mortgage interest (interest-only note),
permits, host insurance and more (Schedule E aligned).
- Reservation log — one row per stay: nights, accommodation and gross fill themselves;
type the platform fee from your payout statement. Cancelled stays stay in the log but
drop out of every report.
- Mileage log — supply runs, cleaner hand-offs, property checks; deductible value from
your editable IRS-rate setting.
- Quarterly tax estimator — a suggested set-aside per quarter from your own
effective-rate estimate, so tax season never ambushes you.
- Settings & guide — your rates, category/platform/property lists, and a plain-English
quick guide with the STR tax notes hosts actually need.
WHY YOU'LL LIKE IT
- The commodity $4.50 trackers squeeze platform fees into "misc". This one tracks fees
per channel and shows the effective fee % — sample data runs Airbnb ~3%, Vrbo ~13%,
Booking.com ~15%, and the scorecard proves why direct bookings matter.
- Schedule E-aligned categories your tax preparer will recognize, plus notes on
mortgage interest (interest only) and furnishing depreciation.
- Zero setup: no macros, no add-ins, no accounts. Opens in Excel 2016+ and imports into
Google Sheets in one click.
- Ships with clearly-marked sample data (two sample properties, Jan–Aug 2026) so you can
see every report working before you type a thing — delete the sample rows and it's yours.
- New year? Duplicate the file and keep going. No subscription, ever.
YOU GET
- STR-Host-Tracker-v1.xlsx (the full system)
- Quick-start guide (PDF included in the zip)
- Single-user license (personal/business use; no resale)
HONEST NOTES
- Brand-new product from a small template studio — v1.0. Spotted a bug or want a
category added? Message us through Payhip and we'll fix it in the next update.
Buyers get free updates to v1.x.
- Sample-data fee percentages are illustrative (real rates are whatever your statements
show), and estimates in the workbook are plain math, not tax advice.