Airbnb Pricing and Occupancy Tracker Spreadsheet, Vacation Rental Income Tracker, ADR RevPAR, Excel

An Airbnb pricing and occupancy tracker spreadsheet for Excel and Google Sheets. One row per month. Type in the figures from your payout report, what you paid for cleaning, and the nights you had open. It shows how full you were, your average nightly rate, what you earned per available night, and what you kept after platform and cleaning.

WHAT’S INSIDE
• Monthly tracker: 12 months with yearly totals
• Plain-English definitions above the table
• Kept after platform and cleaning, net before tax, and average stay, calculated for you
• Built-in chart: each month’s earned-per-available-night (RevPAR) against the same month last year
• Optional same-month-last-year column, because that is the fair comparison

No filler. Every tab and column is one we use at our own rentals.

WHO WE ARE
We’re Ken & Moya, Airbnb Superhosts with 586+ Airbnb guest reviews, a 4.9 rating and 25+ years in hospitality. At peak we ran fifteen rentals, seven of them short-term, across two countries and three very different markets. We’re operators, not a management company, and we still run our properties. Everything in this shop is what we use ourselves.

“This is the 4th time we’ve stayed at Ken & Moya’s place, so obviously we like it a lot.” Marti, Fayetteville, PA (an Airbnb guest review of one of our rentals)

FORMATS
Excel file (.xlsx) that also opens in Google Sheets and Numbers.

QUESTIONS
• Mac or PC? Both. Opens in Excel, Google Sheets or Numbers. Yellow cells to fill in; everything else calculates.
• Is it filled in? Labelled example rows show how it works; type over them with yours.
• Refunds? Digital files can’t be returned, but if something isn’t right, message us and we’ll make it right.

Founding price: goes up after our first 25 Etsy reviews.

HOW IT WORKS
Instant download; nothing ships. After purchase, download from Purchases & Reviews in your Etsy account. Etsy delivers it as a .zip: open it to see the files.

LICENSE
For use at your own properties. Please don’t resell or share the files.

Written by us from our own rentals. AI tools helped with layout.