The host problem

Most hosts know roughly what Airbnb paid them. They can check deposits and earnings summaries.

That does not show whether income came from strong pricing or discounted occupancy. It also does not show whether last month improved or simply looked busier.

A KPI spreadsheet puts the right numbers in one place.

The decision this article helps you make

A KPI spreadsheet helps you answer one monthly question: did the listing perform better or worse than before, and why?

Without the sheet, you can see income. With the sheet, you can diagnose performance.

The signal to check first

Start with the fields that matter for pricing:

Everything else comes from those inputs.

How to read the signal

Use accommodation revenue only. Do not mix cleaning fees, taxes, or total payout into pricing metrics.

Once you have the five inputs, calculate:

ANR = Accommodation Revenue divided by Booked Nights. This shows realized nightly rate.

Occupancy Rate = Booked Nights divided by Available Nights. This shows how much sellable inventory converted.

RevPAR = Accommodation Revenue divided by Available Nights. This shows revenue captured across all available nights.

ALOS = Booked Nights divided by Number of Bookings. This shows average stay length.

BLT = Check-in Date minus Booking Date. This shows how far ahead guests book.

Read ANR Explained for Airbnb Hosts and RevPAR Explained for Airbnb Hosts before you change price from the sheet.

Simple example

April had 28 available nights, 20 booked nights, 6 bookings, and $2,800 in accommodation revenue.

ANR = $2,800 / 20 = $140.
Occupancy = 20 / 28 = 71%.
RevPAR = $2,800 / 28 = $100.
ALOS = 20 / 6 = 3.3 nights.

Now you have a baseline. In May, you can compare against it.

What most hosts get wrong

Hosts often track total payout instead of accommodation revenue. That distorts ANR and RevPAR because cleaning fees and other charges can move separately from nightly rate.

Hosts also forget available nights. If you block 14 nights for personal use, those nights should not count as available inventory.

What to do this week

  1. Open last month’s Airbnb earnings summary.
  2. Pull accommodation revenue only.
  3. Count booked nights, available nights, and bookings.
  4. Calculate ANR, occupancy, and RevPAR.
  5. Record those numbers as your first baseline.

Download the spreadsheet at Airbnb KPI Spreadsheet Template Download when you want a running record.

Where this fits in the STR Signals framework

A spreadsheet does not create strategy. It creates the baseline strategy needs.

With one or two clean months, you can see whether a problem comes from rate, occupancy, availability, lead time, or booking shape.

Use Available Nights vs. Calendar Nights before comparing months.