Rental Property & Airbnb Tracker | Automated Google Sheets Dashboard for Short-Term Rental Hosts

Know exactly how much each rental makes. No more guessing, no more messy spreadsheets at tax time.

This automated Google Sheets tracker is built for Airbnb, VRBO and short-term rental hosts with 1 to 6 properties. Log a booking and it calculates nights, revenue, platform fees and your real net payout on its own. Everything flows into a live dashboard.

What's included

• Dashboard with gross revenue, expenses, net profit, occupancy % and ADR
• 12-month performance table + 3 charts (profit, occupancy, where the money goes)
• Filter by year and by property, or see all properties together
• Property comparison with Cash-on-Cash ROI
• Bookings log: nights, fees and net payout calculate automatically
• Expenses log with 16 categories that follow IRS Schedule E
• Tax Summary per property, ready for your accountant, with 1-click PDF export
• Occupancy splits stays across months correctly (most templates don't)
• Custom menu: quick-add booking/expense forms, sort by date, clear sample data
• Works for long-term tenants too
• Excel (.xlsx) version included

How it works

1. Buy and download the PDF
2. Click the button in the PDF to make your own copy in Google Sheets
3. Add your properties and start logging. The dashboard updates live

Good to know

• Instant digital download.
• Requires a free Google account. The Excel version works without the menu buttons.
• The first time you use the custom menu, Google asks you to authorize it and shows an "unverified app" notice. Click Advanced > Go to Rental Tracker Menu > Allow. The script only runs inside your own copy.
• Currency shows as $ and works for any dollar currency.
• Sample data is included so you can see it working. Clear it with one click.
• This is an organizing tool, not tax or financial advice.
• For personal use only. Please don't resell or share.

Questions? Email me and I'll help you set it up.