Airbnb / STR Tracker Spreadsheet Template for Excel & Google Sheets
Log every booking, see monthly occupancy, ADR, and RevPAR by month, and watch annual profit update from a simple P&L. Built for working short-term rental hosts in Microsoft Excel and Google Sheets.
One-time purchase
Airbnb / STR Tracker Spreadsheet
Everything in This STR Tracker
Listing Performance at a Glance
Six KPIs sit at the top - occupancy, ADR, RevPAR, gross revenue, net to host, and annual profit. A status banner flags profitability, and charts plot monthly nights and monthly gross across the calendar year.
- Six KPIs - occupancy, ADR, RevPAR, gross, net, profit
- Status banner for annual profit
- Monthly nights and monthly gross charts
Per-Booking Ledger
Each row is one booking - check-in, nights, guests, nightly rate, gross, platform fee, cleaning, and net. Gross equals nights times rate; net equals gross minus platform fee minus cleaning. Total row sums each column.
- Check-in, nights, guests, nightly rate per row
- Auto gross, platform fee, cleaning, net per booking
- Total row sums across all bookings
Monthly Occupancy and ADR
Twelve rows, one per month, with nights booked, gross revenue, and ADR derived from the bookings list by check-in month. Use the table to spot strong and slow months and to set rates seasonally.
- One row per month, twelve months
- Nights booked, gross, and ADR per month
- Spot seasonality at a glance
Annual Operating Expenses
Eight category lines covering the typical STR operating cost stack - mortgage P&I, property tax, insurance, utilities, internet, supplies, repairs, and management if you use one. The total feeds the dashboard annual profit figure.
- Eight category lines for STR operating costs
- Edit names and amounts to fit your listing
- Total feeds the annual profit on the dashboard
Tune Your Listing Defaults
Settings holds your listing name, currency, nights available (365 minus blocked days), platform fee percent, and per-booking cleaning fee. The booking ledger and dashboard read from these values, so you only set them once per season.
- Listing name, currency, nights available
- Platform fee percent applied to gross
- Cleaning fee per booking
Up and Running in 15 Minutes
Start on Settings, paste or type recent bookings into the ledger, and enter your eight annual expense categories. The dashboard fills in - occupancy, ADR, RevPAR, gross, net, and annual profit all read from your inputs.
- Settings, then Bookings, then Expenses
- Dashboard updates from your inputs
- 15-minute initial setup
Customizable & Flexible
Adapt the template to your listing. Add a co-host split, change the platform fee, or block extra days for maintenance - the formulas update automatically. Works identically in Excel and Google Sheets.
- Adjust platform fee and cleaning
- Add or rename expense categories
- Excel and Google Sheets compatible
Ready to take control of your finances?
Set Up in 15 Minutes
How the STR Tracker Works
Open in Excel or Google Sheets
Get instant access after purchase. Open in Microsoft Excel directly, or import into Google Sheets - no software to install, no add-ons.
Set Listing Defaults
On Settings, set the listing name, currency, nights available, platform fee percent, and cleaning fee per booking.
Log Bookings and Expenses
Add a row for every booking with check-in, nights, guests, and nightly rate. Enter eight annual operating expense categories.
Read the Performance
Dashboard KPIs and the monthly Performance table update from your bookings - occupancy, ADR, RevPAR, gross, net, and annual profit.
Customer Reviews
Used by STR Hosts Worldwide
"If I get half as good at handling my finances as you are at customer service, this'll be the best $26 I've spent lately."
"Great tool! Simplifies financial planning without the hassle of complex spreadsheets."
"I recently purchased your super convenient spreadsheet, it really helps me!"
"They're great and super intuitive. Thank you!"
Built for Working Hosts
Why Hosts Use This STR Tracker
Real STR Metrics
Occupancy, ADR, and RevPAR - the standard short-term rental KPIs - wired to a per-booking ledger and nights-available on Settings.
No Formulas to Write
Enter values in highlighted input cells. KPIs, per-month performance, annual profit, and charts are pre-built and update automatically.
Excel and Google Sheets
Works identically in Microsoft Excel and Google Sheets. No macros, no add-ons, no proprietary functions.
Free Lifetime Updates
All future improvements to the STR tracker included at no extra cost.
Your Listing Data Stays Private
Runs entirely in your spreadsheet. Booking and expense data stay in your file - we never see or store them.
One-Time Purchase
Pay once, use forever. No subscriptions, no monthly fees, no recurring charges.
Got Questions?
Frequently Asked Questions
Is this template free to use?
This template is not free, but it is available for a one-time purchase. This purchase gives you lifetime access to the template and all future updates.
What do you mean by lifetime access?
Lifetime access means that you will have access to this template for as long as you need it. You will not be required to pay any additional fees for continued access to the template or any future updates.
Do I need to sign up to use this template?
You don't need to create an account with us. The template works in Google Sheets, so you'll need a Google account. If you don't have one, you can create one for free at google.com. After you purchase the template, copy it to your Google Drive, and start using.
What are the benefits of using this template?
This template offers a range of benefits, including: Easy-to-use interface, Customizable to suit your needs, Secure and private, Regular updates and improvements, One-time purchase for lifetime access.
Can I get future updates?
Yes, you will receive all future updates to this template at no additional cost. This ensures that you always have access to the latest features and improvements.
Do you offer any discounts?
At this time, we do not offer any discounts on this template. However, the template is available for a one-time purchase, which provides lifetime access and free updates.
Do you have any access to my financial data?
No, we do not have access to your financial data when you use this template. The template is designed to be used in your own Google Sheets account, ensuring that your financial information remains private and secure.
Is this template financial advice?
Our templates are not financial advice. They are tools designed to help you manage your personal finances more effectively. If you need personalized financial advice, consider consulting with a financial advisor or accountant.
Can I make my own changes and customize this template?
Yes, you can make your own changes and customize this template to suit your needs. The template is designed to be flexible and adaptable, allowing you to add or remove sections, change formulas, and adjust formatting as needed.
Do you offer technical support?
This is a self-service product, and we do not offer technical support. However, if you encounter any issues or have any questions about the template, please contact our team for assistance. Because everyone's financial situation is unique, consider consulting with a financial advisor or accountant if you need personalized financial advice.
Do you offer refunds?
All sales are final. Because these are digital products delivered instantly, we do not offer refunds.
Can't find the answer you're looking for? Contact our team
Highlights:
Track Your STR Without the Math
Get the Airbnb / STR Tracker template and start logging bookings, watching occupancy and ADR, and seeing annual profit in Excel or Google Sheets.