Enter booking and revenue details
Use the responsive input grid below. Large screens show three columns, medium screens show two, and mobile shows one.
Visual analysis
The chart updates after each calculation to highlight reservation movement and the related revenue effect.
What this chart shows
Booked, cancelled, kept, and rebooked room nights are plotted beside revenue measures.
Use it to spot whether recovered nights are offsetting cancellation exposure.
Formula used
This calculator uses a rate formula for bookings, a second rate for room nights, and supporting revenue-loss estimates.
Cancellation Rate (%) = (Cancelled Reservations ÷ Total Reservations) × 100
Room Night Cancellation Rate (%) = (Cancelled Room Nights ÷ Total Room Nights Booked) × 100
Gross Revenue at Risk = Cancelled Room Nights × Average Daily Rate
Recovered Room Revenue = Rebooked Cancelled Room Nights × Average Daily Rate
Estimated Net Loss = Gross Revenue at Risk - Retained Deposits - Recovered Room Revenue + Lost Ancillary Revenue
How to use this calculator
- Enter the total reservations and cancelled reservations for the chosen reporting period.
- Split the cancellations into refundable and non-refundable counts if you track policy mix.
- Add room nights, average daily rate, retained deposits, and ancillary revenue assumptions.
- Enter rebooked cancelled room nights to estimate recovery from resale activity.
- Click the calculate button to show results above the form and refresh the chart.
- Download a CSV or PDF summary for reporting, revenue meetings, or audit files.
Example data table
Use this sample structure for daily or channel-level cancellation tracking.
| Date | Channel | Segment | Bookings | Cancelled | Room Nights | Cancelled Nights | ADR | Cancellation Rate |
|---|---|---|---|---|---|---|---|---|
| 2026-04-01 | Direct | Leisure | 120 | 14 | 238 | 29 | 112.00 | 11.67% |
| 2026-04-02 | OTA | City | 95 | 18 | 171 | 35 | 128.00 | 18.95% |
| 2026-04-03 | Group | Event | 60 | 6 | 180 | 18 | 146.00 | 10.00% |
| 2026-04-04 | Direct | Business | 84 | 9 | 132 | 15 | 139.00 | 10.71% |
| 2026-04-05 | OTA | Leisure | 104 | 21 | 224 | 48 | 119.00 | 20.19% |
Frequently asked questions
1. What is a good hotel cancellation rate?
There is no single ideal figure. A healthy rate depends on channel mix, seasonality, group business, lead time, destination demand, and deposit rules. Use your own historical average and compare each segment separately before judging performance.
2. Why track room night cancellation rate too?
A booking count can hide the real impact. One cancelled group booking may remove many room nights, while several short leisure cancellations may remove fewer nights. Tracking both metrics gives a fuller operational and revenue picture.
3. Should non-refundable cancellations be included?
Yes. They still affect operational planning, pickup forecasts, and guest behavior analysis. However, their financial impact is lower because retained deposits or full prepayment can offset part of the revenue loss.
4. How do rebooked room nights change the result?
Rebooked room nights reduce the final room revenue loss estimate. If cancelled inventory is resold quickly, the property may recover much of the expected loss even when the cancellation rate itself remains high.
5. What ancillary revenue should I enter?
Use the average extra spend tied to a cancelled reservation, such as breakfast, parking, resort fees, transfers, or upsells. Enter zero if you only want the room revenue effect.
6. Can I use this for channel comparison?
Yes. Run separate calculations for direct, OTA, wholesale, corporate, and group segments. Comparing each source shows which channel produces the most unstable demand and which one recovers fastest after cancellations.
7. Does a high lead time always reduce risk?
Not always, but earlier cancellations usually give revenue teams more time to resell inventory. Last-minute cancellations often create larger exposure because replacement demand may be weaker or discounted.
8. Is this calculator suitable for resorts and serviced apartments?
Yes. Any accommodation business that tracks reservations, room nights, and nightly rates can use it. You can adapt assumptions for villas, extended stay units, hostels, or mixed inventory properties.