The host problem
A host may have numbers in several places: Airbnb payouts, calendar notes, a pricing spreadsheet, and memory. The host can calculate ANR once, but month-to-month comparison still feels messy.
A one-property KPI dashboard creates a simple monthly view. It should show enough to guide pricing. It should not turn one listing into an enterprise report.
What the tool helps you decide
The dashboard helps you decide whether last month improved or weakened compared with prior months.
It should show whether rate, conversion, booking shape, or turnover drag drove the change.
Inputs required
Enter one row per month.
Each monthly row needs Live Accommodation Revenue, Live Booked Nights, Available Nights, Live Bookings, and TCP.
Use accommodation revenue only. Exclude cleaning fees, taxes, platform fees, damage claims, and canceled revenue.
If a cancellation reopened inventory, record the cancellation in a separate cancellation worksheet. Do not merge canceled revenue into live revenue.
Outputs produced
The dashboard should calculate ANR, Occupancy Rate, RevPAR, RCI, ALOS, Turnover Drag per Occupied Night, and Net RevPAR.
It should also show month-over-month direction for each metric.
A simple dashboard can flag three patterns.
High RCI with low ANR may signal underpricing.
Low RCI with high ANR may signal weak conversion or overpricing.
High RevPAR with low Net RevPAR may signal too much turnover.
Example
A host enters three monthly rows.
January shows ANR of $155, occupancy of 52 percent, and RevPAR of $80.60.
February shows ANR of $140, occupancy of 68 percent, and RevPAR of $95.20.
March shows ANR of $132, occupancy of 85 percent, and RevPAR of $112.20.
The dashboard shows RevPAR improved while ANR fell. That pattern does not automatically mean pricing got worse. It means conversion improved enough to offset lower rate. The host now checks RCI and Net RevPAR before deciding whether to raise.
What most hosts get wrong
Most hosts build dashboards that show too much. A one-property dashboard should not bury the decision under twenty charts.
The second mistake is showing gross payout instead of accommodation revenue. Gross payout can include fees and adjustments that do not belong in live KPI formulas.
The third mistake is treating the dashboard as the pricing decision. The dashboard gives the read. The host still chooses the move.
How to use it this week
Create one monthly row for each month you can support cleanly.
Enter the five required inputs. Let the dashboard calculate the metrics.
Highlight the month with the highest RevPAR and the month with the highest Net RevPAR. If they differ, inspect turnover drag and ALOS.
Use the result to choose one pricing question for the next weekly review.
Connected articles
- How to Track Airbnb KPIs Once Per Month
- Airbnb KPI Spreadsheet Template
- Your First Airbnb KPI Sheet
- Airbnb KPI Field Guide for Normal Hosts
- Revenue Capture Index: The Metric That Keeps Occupancy and Rate in Frame
Educational note
This page is educational. It is not tax, legal, investment, or guaranteed-income advice.