Airbnb Host Spreadsheet | Short Term Rental Income and Expense Tracker | Google Sheets & Excel Template | Vrbo Occupancy Tracker
Run your rentals by the numbers with this Short-Term Rental Host Tracker spreadsheet for Airbnb and Vrbo hosts: bookings, occupancy, nightly rate and real profit per property.
WHAT'S INSIDE
- Start Here: type your details and settings once, with simple step-by-step instructions
- Dashboard: occupancy, average nightly rate (ADR), revenue and profit by month and by property, plus tax set-aside estimate
- Bookings: every reservation: property, platform, guest, dates and payout
- Expenses: every cost assigned to the property it belongs to
- Help & FAQ: answers to the most common questions
FEATURES
✔ Up to 10 rental properties
✔ Nights, nightly rate and payout calculated automatically
✔ Occupancy rate by month
✔ Profit per property
✔ Cancelled bookings left out with one click
✔ Tax set-aside estimate with your own % (not tax advice)
✔ Editable platform and expense category lists
HOW IT WORKS
1. Write your property names in Start Here.
2. Add every booking and every expense.
3. Open the Dashboard for occupancy and profit per property.
YOU WILL RECEIVE
✔ 1 spreadsheet template (.xlsx)
✔ 1 DEMO file with sample data, so you can see how it works
✔ 1 PDF guide: how to open it in Google Sheets (free) or Excel
PLEASE NOTE
- This is a digital product. Nothing physical will be shipped.
- Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer / Microsoft 365.
- Not compatible with Apple Numbers.
- Tax amounts are estimates only, not tax advice.
- Not affiliated with Airbnb or Vrbo.
- Due to the digital nature of this item, no returns, but please message us for any help.
- For personal or own-business use only (no resale or sharing of the file).
Dark Mode version and Spanish version also available in our shop.