Report this item to Etsy

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

Item highlights

  • Digital download
  • Digital file type(s): 4 Files

Seller's description

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.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/J0q8yX1A99Y

✨ 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 grid
• Properties and Setup for your listings, fixed costs, platforms and fees, expense categories, season multipliers and pricing rules
• 12 charts, drop-down lists, data bars and color-coded alerts throughout
• Sample data version + blank ready-to-use version (Excel + Google Sheets)

★ PERFECT FOR ★
✓ Airbnb and VRBO hosts
✓ Co-hosts and property managers
✓ Anyone deciding whether a rental is worth it

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Purchase and download the .xlsx file instantly
2. Add your properties and fixed costs
3. Log bookings and expenses
4. See occupancy and profit update automatically

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ SAVE WITH A BUNDLE ★
Get this template plus 4 more in the Real Estate Investor Spreadsheet Bundle and save 46%: https://www.etsy.com/listing/4600494811/real-estate-investor-spreadsheet-bundle

★ PLEASE NOTE ★
This is a digital download. No physical item will be shipped. Not affiliated with Airbnb or VRBO. This is a record-keeping tool, not tax advice. Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.

View more

NowPrice:$4.49

Original Price: $8.99

Loading

50% off

•

Sale ends on November 22

You can only make an offer when buying a single item

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

May include: A digital Airbnb and Short-Term Rental Host Tracker spreadsheet displayed on a laptop screen. The interface features a Host Dashboard with KPIs, a booking calendar, pricing calendar, and cleaning schedule with sample data included.

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.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/J0q8yX1A99Y

✨ 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 grid
• Properties and Setup for your listings, fixed costs, platforms and fees, expense categories, season multipliers and pricing rules
• 12 charts, drop-down lists, data bars and color-coded alerts throughout
• Sample data version + blank ready-to-use version (Excel + Google Sheets)

★ PERFECT FOR ★
✓ Airbnb and VRBO hosts
✓ Co-hosts and property managers
✓ Anyone deciding whether a rental is worth it

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Purchase and download the .xlsx file instantly
2. Add your properties and fixed costs
3. Log bookings and expenses
4. See occupancy and profit update automatically

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ SAVE WITH A BUNDLE ★
Get this template plus 4 more in the Real Estate Investor Spreadsheet Bundle and save 46%: https://www.etsy.com/listing/4600494811/real-estate-investor-spreadsheet-bundle

★ PLEASE NOTE ★
This is a digital download. No physical item will be shipped. Not affiliated with Airbnb or VRBO. This is a record-keeping tool, not tax advice. Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.

Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

Meet your seller

SheetSmartTemplateCo
SheetSmartTemplateCo ·

South Bend, Indiana

We calculate this number using a recency-weighted average of all ratings, with a rating's value decreasing by half each year to best reflect the current experience. 5.0
·
10 sales
·
New on Etsy
Jesse
1 shop member

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 21, 2026