Airbnb Host Spreadsheet, Short Term Rental Income Expense Tracker, Occupancy, Airbnb Host Template, Excel Google Sheets

Airbnb Host Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Know exactly what each of your short-term rentals earns. This Airbnb & Short-Term Rental Host Tracker logs every booking and expense and calculates occupancy, ADR, RevPAR and net profit per month and per property. Perfect for Airbnb and VRBO hosts. ✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition. ★ WHAT'S INCLUDED ★ • 16 tabs: Start Here, Dashboard, Bookings, Booking Calendar, Pricing Calendar, Cleaning Schedule, Monthly Report, Property P&L, Platforms & Payouts, Expenses, Guests, Reviews, Revenue Planner, Properties, Setup, How To Use • Clickable Start Here cover page with quick-start steps and a color key (yellow = you type) • Host Dashboard: payout, net profit, occupancy, ADR, RevPAR, average rating, check-ins in the next 30 days, revenue on the books, gross bookings, platform fees, all costs, profit margin, average stay, lead time, repeat guests and open nights, plus month by month results, a property scoreboard, your next check-ins, a Needs Attention panel and 4 charts • Bookings (1,000 rows): property, platform, guest, dates, nightly rate, cleaning and extra fees, status (confirmed, cancelled, owner stay, blocked); nights, gross, platform fee, payout, payout date, cleaning cost, net profit and lead time are calculated • Booking Calendar: all your listings on one month grid, color-coded by platform, plus a month view with guest names for any property • Pricing Calendar: a suggested nightly rate for every date using your base rate, season multipliers, weekend uplift, events and last-minute discounts, with open nights and the revenue still to sell • Cleaning Schedule: your next 30 turnovers sorted for you, with the next arrival, same-day turnover and missing-cleaner alerts, a cleaner list with turnovers and pay, and a turnover checklist • Monthly Report: stays, nights, available nights, occupancy, gross, fees, payout, ADR, RevPAR, cleaning, expenses, fixed costs, net profit and margin for each month, for one property or all, with 2 charts • Property P&L: occupancy vs target, ADR, RevPAR, payout, costs, net profit, margin and yearly ROI side by side for up to 10 listings, with 2 charts • Platforms & Payouts: stays, fees, effective fee %, payout, ADR and cancel rate by platform, payouts by month and the next 15 payouts on the way • Expenses (1,000 rows) with yearly budget vs actual by category and spending by property • Guest log (300 guests): stays, nights, total paid, first and latest stay, average review and VIP / repeat / do-not-rebook tags • Reviews (600 rows): overall and category stars, reply tracker, weakest area per listing and a monthly rating trend chart • Revenue Planner: what-if calculator with yearly profit, break-even occupancy and nightly rate, payback months and a rate x occupancy profit g