Imagine a 30-night month with 18 nights sold and six nights removed for owner use. Against the whole calendar, those sales represent 60%. Against the 24 nights offered for sale, occupancy is 75%. Both ratios describe the same bookings.
The problem is not that the ratios differ. It is presenting one as if it proved stronger demand than the other. Define availability once and retain enough detail to explain what changed.
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.
Separate unsold nights from nights not offered
For this operating method, sold nights and unsold nights offered to guests form available inventory. Owner-use nights and documented maintenance closures are shown separately. An unsold night remains available even if it did not attract a booking.
Record the reason for each exclusion. Do not reclassify an unsold night after the event merely to raise occupancy. A property that opens mid-month also needs a clearly stated starting date.
- Sold: a guest occupied the night.
- Offered but unsold: included in available inventory.
- Not offered: separately identified owner use or closure.
Read two denominators without mixing them
In the example, 18 sold plus six unsold equals 24 offered nights. Another six nights were reserved for the owner. The whole-month use ratio includes those excluded nights in its denominator, while commercial occupancy does not.
Label each figure explicitly and use the same definition in comparisons. Other systems may define availability differently, so reconcile their definitions before comparing percentages.
| Measure | Calculation | Result |
|---|---|---|
| Offered-night occupancy | 18 ÷ 24 | 75% |
| Sold nights / calendar nights | 18 ÷ 30 | 60% |
The denominator also changes RevPAR
At €100 per sold night, accommodation revenue is €1,800. Divide it by 24 offered nights and RevPAR is €75. Dividing it by 30 calendar nights gives €60, a different capacity-based measure that should be labelled separately.
A maintenance closure can therefore raise reported RevPAR if the excluded nights shrink the denominator while revenue remains unchanged. Read how RevPAR connects price and occupancy alongside the calendar.
ADR €100 × occupancy 0.75 gives the same result.
Do not call every blocked night lost revenue
Multiplying six owner-use nights by the usual price assumes every one would have sold. That is a scenario, not a measured loss. If you explore opportunity cost, state the assumed probability of sale and subtract the costs that the hypothetical booking would have incurred.
A repair may protect future operations even though it reduces this month’s inventory. Keep the closure, actual repair expense and any hypothetical lost contribution on separate lines.
Add an availability check to each monthly review
Save the calendar categories with the monthly report. Explain changes in available inventory before interpreting changes in occupancy or RevPAR, particularly when comparing a full-time rental with an occasional-use property.
Check that the workbook’s availability entries use your stated convention. For a portfolio, sum sold and available nights before calculating occupancy.
Explore related questions
Clear answers, without the jargon
Should owner stays count as guest occupancy?
Not in the paid-guest measure used here. Record them separately and disclose whether their nights are excluded from offered inventory.
Is an unsold night unavailable?
No. If it was offered for sale under your chosen inventory definition, it stays in the denominator.
What if there are no available nights?
Occupancy and RevPAR on offered inventory are undefined. Show them as unavailable and report the reason for closure.
Does 100% occupancy mean the strongest profit?
No. The price, operating costs and number of nights offered also matter. Inspect absolute profit alongside the ratio.
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
Occupancy
RevPAR