An Airbnb dashboard for operating performance should bring together ten measures: revenue, costs, operating profit, margin, occupancy, ADR, RevPAR, result per stay, profit per occupied night and average stay length.
Use one selected month and a clearly defined property scope. A high occupancy rate means little if it belongs to a different period from the costs beside it. The example below uses ten completed stays entirely within the month, so booking and calendar-night reporting agree.
A clear definition of the metric or operating question.
A calculation you can reproduce with your own data.
The limits that prevent the number being misread.
1–2. Recorded revenue and operating costs
Revenue includes the operating income you record, such as accommodation and guest cleaning charges. Operating costs include direct stay costs plus general property expenses. Keep a documented rule for refunds and adjustments, and avoid counting fees twice.
Our example has €2,400 accommodation revenue and €400 cleaning income: €2,800 total revenue. Direct stay costs are €600 and general operating expenses are €500, giving €1,100 total costs.
3–4. Operating profit and operating margin
Profit shows the amount retained before the excluded tax, financing and accounting items. Margin shows the percentage retained from each euro of revenue. Use the short-term rental profitability formula to keep those meanings consistent.
A high margin does not necessarily mean the greatest total profit. Review both when comparing properties, and show margin as N/A if recorded revenue is zero.
€2,800 − €1,100 = €1,700. Margin: €1,700 ÷ €2,800 × 100 ≈ 60.7%.
5–7. Occupancy, ADR and RevPAR
Occupancy measures inventory sold. ADR measures accommodation revenue per sold night. RevPAR includes available inventory, which explains why a high nightly rate can coexist with weak overall commercial performance.
Keep cleaning income out of both ADR and RevPAR. Review how to calculate Airbnb occupancy with blocked nights, the ADR formula and RevPAR for short-term rentals if any inputs are unclear.
| Metric | Calculation | Example |
|---|---|---|
| Occupancy | 20 occupied ÷ 30 available × 100 | 66.7% |
| ADR | €2,400 accommodation ÷ 20 occupied | €120 |
| RevPAR | €2,400 accommodation ÷ 30 available | €80 |
8. Result per stay: state which definition you use
This label needs care. Average booking contribution deducts direct stay costs but excludes general overhead. In our example, (€2,800 − €600) ÷ 10 stays = €220 average contribution per stay.
If the KPI is average operating profit per stay, it includes the month's general expenses: €1,700 ÷ 10 = €170. These figures answer different questions. Label the selected definition beside the KPI rather than using both interchangeably.
The guide to Airbnb profit per stay and booking contribution explains how duration and turnover costs affect this comparison.
9–10. Profit per occupied night and average stay length
Operating profit per occupied night is the period's operating result divided by occupied nights: €1,700 ÷ 20 = €85. It includes recorded general expenses, unlike booking contribution per night.
Average stay length is occupied nights divided by the number of stays: 20 ÷ 10 = two nights. Shorter average stays can mean more turnovers for the same occupied nights, increasing costs that occur once per booking.
Use consistent stay and night allocation rules. If the month contains no stays or occupied nights, display the relevant per-stay or per-night metric as N/A.
Three views that explain the monthly KPIs
Charts should help locate the cause of a change. A growing gap between revenue and profit suggests costs need investigation, while falling RevPAR calls for a closer look at price and occupancy.
Use a vacation rental profitability comparison by property to decide where to investigate first. Avoid combining currencies or averaging ratios without considering their underlying totals.
- Revenue and operating profit over twelve months, using the same period definitions.
- Costs by category, with unusual repairs clearly identified.
- Property comparison showing operating profit and margin alongside commercial metrics.
How to use an Airbnb dashboard each month
Start by checking inputs: missing expenses, duplicate stays, availability and the selected reporting period. Then review profit and margin, explain commercial changes with ADR and occupancy, and record the action you want to check next month.
An Airbnb income and expense spreadsheet can supply the underlying records. Hostpartner's monthly Airbnb operating profit dashboard brings entered data together for up to seven properties in Excel 365 or Google Sheets.
A consistent monthly review supports operating decisions. It does not replace day-to-day guest operations, a PMS or accounting processes.
Explore related questions
Clear answers, without the jargon
Which metrics should an Airbnb dashboard show?
Revenue, operating costs, profit, margin, occupancy, ADR, RevPAR, result per stay, profit per occupied night and average stay length form a useful monthly operating view.
Does ADR include the cleaning fee?
In this reporting approach, ADR and RevPAR use accommodation revenue only. Cleaning charges remain part of total recorded operating revenue.
How often should I review rental profitability?
A consistent monthly review can support small-portfolio operating decisions. Operational tasks and emerging problems may require attention more frequently.
Does Hostpartner replace an Airbnb PMS?
No. Hostpartner focuses on operating performance from entered records. It does not provide platform synchronisation or the broader guest and reservation workflows of a PMS.
How this guide was prepared
Each example starts with recorded accommodation revenue, completed stays and operating costs. Calculations state their inputs, cleaning income is kept separate where comparability requires it, and no external income benchmark is presented as an expected result.
Hostpartner is an operational analysis tool. It does not calculate VAT, taxes, depreciation, financing or mortgage principal and does not connect to booking platforms, banks or PMS systems.
Connect the metrics that explain your rental operation.
Request Hostpartner's dashboard to review income, recorded costs and property performance in Excel 365 or Google Sheets.
- Built for 1–7 properties
- Excel 365 + Google Sheets
- No platform connection required
Portfolio performance
Booking profitability