Airbnb & STR Tracker Spreadsheet (Google Sheets & Excel)
Google Sheets + Excel · Light & Dark Modes
Occupancy, ADR, Payout Calculator & Schedule E Tax Summary
- STR Performance Dashboard (Live Gross Revenue, Net Income, Occupancy Rate % & ADR)
- Multi-Platform Booking Log (Airbnb, VRBO, Direct Booking fee and payout automation)
- Channel Fee & Cleaning Fee Deductions (Calculates exact take-home host payout per stay)
- Tax Deduction Expense Ledger with Schedule E Category Alignment
- Property Comparison Matrix (Evaluate profitability across multiple rental units)
- Monthly & Annual Cash Flow Breakdowns with Visual Charts
- Light & Dark Mode Included (Google Sheets + Microsoft Excel)
Instant digital download. All sales final. Message us anytime for help.
Run your short-term rental properties like a professional hospitality business. The DownloadSuite Airbnb & STR Tracker Spreadsheet is an automated financial command center for Airbnb hosts, VRBO owners, and direct-booking operators to track occupancy rates, average daily rate (ADR), channel payout fees, and Schedule E tax deductions.
What's Included in This System:
- STR Performance Dashboard: Real-time visibility into Gross Booking Revenue, Host Net Payout, Occupancy Rate %, Average Daily Rate (ADR), and Net Operating Income.
- Multi-Channel Booking Ledger: Log reservations from Airbnb, VRBO, Booking.com, and direct guests with automated platform commission and cleaning fee deductions.
- Schedule E Tax Deduction Engine: Categorize cleaning expenses, supplies, guest amenities, repairs, utilities, insurance, and management fees for CPA-ready tax filings.
- Multi-Property Comparison Matrix: Compare profitability, occupancy trends, and seasonal revenue across up to 10 rental listings side-by-side.
- Monthly & Annual Cash Flow Breakdowns: Automated revenue vs expense charts and seasonality projections.
- Light & Dark Mode Included: Native Microsoft Excel workbooks and Google Sheets copy links in both sleek Dark and clean Light themes.
How to Use:
- Open the Google Sheets copy link or Excel workbook and set up your property names and nightly target rates.
- Enter each booking payout and deductible operational expenses as they occur.
- Review your live Occupancy %, ADR, and annual Schedule E tax summary instantly.
What's inside
- Start Here Quick-Start & STR Host Tax Setup Guide
- STR Command Dashboard with Revenue & Occupancy Metrics
- Property Listings & Seasonality Setup Tab
- Master Bookings Log with Automated Net Payout Formulas
- Deductible Operating Expenses & Supplies Log
- Schedule E Accountant-Ready Tax Summary
- Instant Google Sheets Copy Links + Native Excel .xlsx Workbooks
FAQ
Does this work for VRBO, Booking.com, and direct bookings?
Yes! You can select any platform from a dropdown and customize fee structures per channel.
How is the Occupancy Rate calculated?
Occupancy is automatically calculated based on total nights booked divided by available calendar nights per listing.
Can I use this for tax filing?
Yes. The Tax Summary tab groups expenses exactly as IRS Schedule E requires (cleaning, management fees, repairs, utilities, insurance, supplies).
Does it work in Excel and Google Sheets?
Yes! Both native Excel workbooks and Google Sheets copy links in Light and Dark themes are included.