The host problem
Most hosts open a blank spreadsheet, type in their monthly payout, and stop there. That number tells you what you received. It does not tell you whether you could have earned more, whether your occupancy is soft for your market, or whether your pricing decisions last month helped or hurt.
A KPI sheet is not a complicated dashboard. Your first one should fit on a single tab with fewer than fifteen rows. The goal is to give you enough information to make one better pricing decision per month.
What the tool helps you decide
Your first KPI sheet helps you answer three questions before you change any price:
- How much accommodation revenue did I produce per booked night?
- What share of my available nights actually converted?
- Did rate and occupancy work together or did one mask a problem with the other?
Without those three answers, pricing changes are guesses.
Inputs required
You need four raw numbers from your Airbnb payout detail. Pull them for one full calendar month at a time.
- Live Accommodation Revenue: the total accommodation charge collected across all bookings that stayed in the month. Exclude cleaning fees, taxes, and platform fees.
- Live Booked Nights: the total count of occupied nights from live bookings in the month. Exclude canceled reservations.
- Available Nights: the number of nights your listing was open and bookable. Subtract owner blocks, maintenance blocks, and offline periods from total calendar nights.
- Number of Live Bookings: the count of reservations that survived and produced booked nights in the month. Exclude cancellations.
Outputs produced
From those four inputs, your sheet calculates:
- ANR = Live Accommodation Revenue ÷ Live Booked Nights
- Occupancy Rate = Live Booked Nights ÷ Available Nights
- RevPAR = Live Accommodation Revenue ÷ Available Nights
- ALOS = Live Booked Nights ÷ Number of Live Bookings
Those four metrics give you a complete read of one month’s performance.
Example
A host pulls February numbers. 28 available nights. 18 booked nights. 4 bookings. $2,340 in accommodation revenue.
- ANR = $2,340 ÷ 18 = $130
- Occupancy Rate = 18 ÷ 28 = 64%
- RevPAR = $2,340 ÷ 28 = $83.57
- ALOS = 18 ÷ 4 = 4.5 nights per booking
Now the host has something to work with. If March shows ANR dropping to $110 with the same occupancy, that is a rate signal. If March shows occupancy dropping to 50 percent with ANR holding, that is a conversion signal. The direction matters.
What most hosts get wrong
The most common mistake is including cleaning fees in the revenue figure. Cleaning fees inflate ANR and mask what you actually earned on the accommodation itself. Pull them out first.
The second mistake is using calendar nights as the denominator instead of available nights. If you blocked ten days for owner use in February, your available nights drop to 18, not 28. Using the wrong denominator makes occupancy look artificially low and makes RevPAR look weaker than it is.
How to use it this week
- Log into your Airbnb account and pull your payout detail for last month.
- Separate accommodation revenue from cleaning fees, taxes, and host service fees.
- Count booked nights and available nights separately.
- Build a simple four-row input block: Revenue, Booked Nights, Available Nights, Bookings.
- Add four formula rows below: ANR, Occupancy, RevPAR, ALOS.
- Record this month’s results. Next month, add a column and compare.
Connected articles
- Beginner’s Guide to RevPAR, ADR, ANR, and Occupancy for Airbnb Hosts
- ANR Explained for Airbnb Hosts
- RevPAR Explained for Airbnb Hosts
- ALOS Explained for Airbnb Hosts
- How to Track Airbnb KPIs Once Per Month
Educational note
This page is educational. It is not tax, legal, investment, or guaranteed-income advice.