📘 What is Cancellation Ratio?
The Cancellation Ratio measures the percentage of bookings that are cancelled compared with the total number of bookings made during a specific period.
It is one of the most important indicators for understanding demand quality, forecast reliability and booking behaviour across segments and distribution channels.
A high Cancellation Ratio can directly affect:
- final occupancy,
- expected revenue,
- operational planning,
- overbooking strategies,
- demand forecasting.
📊 Cancellation Ratio Formula
Cancellation Ratio (%) = (Cancelled Bookings / Total Bookings) × 100
Where:
- Cancelled Bookings = number of cancelled reservations
- Total Bookings = total number of reservations made
✅ Why is Cancellation Ratio important?
- Improves forecast accuracy.
- Supports overbooking optimisation.
- Identifies channels with higher cancellation risk.
- Supports pricing and restriction decisions.
- Helps assess the real quality of incoming demand.
💡 Practical example of Cancellation Ratio
- A hotel receives 1,000 bookings during a month.
- Out of those bookings, 180 are cancelled before arrival.
- → Cancellation Ratio = (180 / 1,000) × 100 = 18%
- This means that almost two out of every ten bookings will not materialise into actual stays.
🔄 Disambiguation of Cancellation Ratio
- Cancellation Ratio vs No-Show Ratio:
A cancellation occurs before arrival.
A no-show occurs when the guest fails to arrive without cancelling. - Cancellation Ratio vs Wash Factor:
Wash Factor estimates the proportion of bookings likely to disappear through cancellations and no-shows.
Cancellation Ratio measures actual cancellations. - Cancellation Ratio vs Pickup:
Pickup measures bookings gained.
Cancellation Ratio measures bookings lost. - Cancellation Ratio vs Occupancy:
Occupancy reflects the final outcome.
Cancellation Ratio helps explain why actual occupancy may differ from booked occupancy.
In summary: Cancellation Ratio = the percentage of bookings cancelled before becoming actual stays.
👉 Not every booking made ends up becoming a stay.
