Suppose you planned 20 sold nights at €150, giving €3,000 accommodation revenue. You actually sold 18 nights at €155, giving €2,790. The rate improved, but revenue fell by €210 because fewer nights sold.
Now add costs. Planned operating costs were €1,400 and actual costs were €1,550. Operating profit therefore fell from €1,600 to €1,240. This simplified example has no cleaning income or other revenue, so every part of the €360 shortfall can be followed directly.
Apply this method to your own records: explore the Airbnb operating profit calculator.
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.
Freeze the original plan before the month starts
Record planned sold nights, ADR, available nights and operating costs with the assumptions behind them. Keep a later forecast in a separate version. If you rewrite the budget to match the result, you lose the information needed to learn from it.
Align revenue and expense definitions with the actual report. A plan excluding platform charges cannot be fairly compared with an actual result that includes them. Use the monthly close checklist before analysing deviations.
Separate the volume and rate effects
One exact bridge measures the volume change at the planned rate, then the rate change on actual sold nights. Here the volume effect is (18 − 20) × €150 = −€300. The rate effect is 18 × (€155 − €150) = +€90.
Together, −€300 + €90 = −€210, exactly the revenue change. This ordering assigns the interaction between volume and rate to the rate effect. Other valid orderings exist, so keep yours consistent.
Use unrounded ADRs for the calculation and round only the displayed results.
Complete the bridge to operating profit
The €150 cost overrun reduces profit by another €150. The complete bridge is therefore −€300 from volume, +€90 from rate and −€150 from costs: a €360 reduction in profit.
If cleaning income or other operating revenue exists, add its own variance line. Separate platform fees, per-stay costs and fixed operating expenses rather than assuming every cost moves in proportion to revenue.
| Item | Plan | Actual | Effect on profit |
|---|---|---|---|
| Accommodation revenue | €3,000 | €2,790 | −€210 |
| Operating costs | €1,400 | €1,550 | −€150 |
| Operating profit | €1,600 | €1,240 | −€360 |
Distinguish a numerical explanation from a cause
The bridge proves that sold-night volume reduced revenue; it does not prove why fewer nights sold. Check available inventory, cancellations, comparable demand periods and any pricing changes before deciding on a response.
Likewise, a higher repair expense may be a one-off event, an overdue invoice or a recurring issue. Inspect the underlying records. A variance is evidence of a difference, not automatically evidence of poor management.
Turn the review into a testable next step
Choose one action connected to the verified cause and assign a review date. For example, correct missing availability data before changing prices, or obtain a new cleaning quote after confirming that the unit cost has risen.
Keep the original plan, actual result, variance bridge and revised forecast together. A forecast uses what you now know; the budget preserves what you originally expected. Compare revenue and operating profit to keep both views useful.
Explore related questions
Clear answers, without the jargon
Why use actual nights in the rate effect?
With the volume effect valued at the planned rate, this makes the two effects sum exactly to the revenue difference, including their interaction.
Should I show a percentage variance when the budget is zero?
No. A percentage change from zero is undefined. Report the currency difference and explain the unplanned item.
Does a higher ADR mean better performance?
Not by itself. Fewer nights sold or higher costs may more than offset the higher rate, as the worked example shows.
Does the calculator automatically build a budget bridge?
No. This guide describes a separate review method. Use the workbook’s operating totals as inputs and maintain your budget comparison separately.
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.
Build a monthly view you can explain.
Record your stays and expenses in Hostpartner. Use the guide to understand the workbook’s reporting rules before comparing your results.
- Built for 1–7 properties
- Excel (.xlsx)
- No platform connection required
What the Hostpartner calculator measures and which inputs you need
Revenue and profit