Cancellation Rate
In hotel revenue management, the cancellation rate is the share of reservations that are cancelled before arrival, measured over a period and used to work out how much of what is on the books will actually turn up.
Most properties know their blended figure and almost none know the splits, which is unfortunate, because the blended figure is the one number in the set that cannot be acted on.
See how ampliphi reads demand for independent hotels
Get a free revenue audit · Book a demo
What is a cancellation rate?
Cancelled reservations divided by total reservations, over a defined period.
Two definitional points decide whether your number is comparable to anyone else's, including your own from last year. The first is the denominator. Cancellations against all reservations made in a period is the usual convention, and cancellations against reservations that were live at some point gives a different answer. Pick one and hold it.
The second is that no-shows are not cancellations. A cancellation is a guest who told you. A no-show is a guest who did not. They behave differently, they are worth tracking separately, and the combined figure is what you actually need for forecasting, usually called attrition.
The reason the blended rate is not useful is that cancellation behaviour varies enormously within one property. It varies by lead time, by channel, by rate plan, by season and by segment, and those splits do not move together. A single percentage averaged across all of them describes no reservation you will ever take.
What you want instead is a small table: cancellation rate by lead time band, and by channel or rate plan. That takes one export and answers questions the blended number cannot.
Resources: On the books · Booking window · Distribution mix
How cancellation rate works in practice
Export a year of reservations with booking date, arrival date, status and source, then split before you summarise.
Worked example. A 46-room inn takes about 3,900 reservations in a year and finds a blended cancellation rate of 18 percent. The splits tell a different story. Bookings made inside 7 days cancel at about 6 percent, while bookings made 60 or more days out cancel at about 31 percent. By channel, a free-cancellation OTA rate runs near 27 percent and a direct non-refundable rate runs near 4 percent. The 18 percent figure applies to no date and no channel the property actually sells.
Those splits are immediately usable. A date whose on-the-books is mostly long-lead OTA bookings is far less solid than a date holding the same count in short-lead direct ones, and nothing in the raw count distinguishes them.
The everyday use is adjusting on the books. A date showing 35 of 46 rooms at 21 days out, in a property with 15 percent attrition at that lead time, is realistically nearer 30. Treating 35 as settled is how a property holds rate on a date it should still be selling.
The second use is diagnosis. A cancellation rate that has climbed year on year usually has a cause you can name: a channel whose share has grown, a policy that got looser, a rate plan that made free cancellation the default. Finding the cause is generally more useful than reacting to the total.
Resources: Demand forecasting · Overbooking
Why cancellation rate matters for independent hotels
Because at 46 rooms, attrition is the difference between holding your rate and giving it away.
The error runs in one direction and it is expensive. A property treating on the books as final will believe a date is nearly sold at 35 rooms, hold its rate through the final fortnight, watch five cancellations arrive, and end at 30 with no time left to sell. The rooms it could have sold at a good rate three weeks earlier finish empty.
It is also the input that makes every other forward number honest. A forecast without an attrition estimate is on the books plus optimism. Overbooking without one is a guess with real guests attached. Neither is available to a property that has never measured this.
And the splits point directly at things you can change. If your long-lead OTA bookings cancel at three times the rate of your direct ones, that is a fact about your distribution mix with a number attached, and it belongs in any conversation about what each channel is really worth.
Resources: Revenue management for independent hotels
How to measure cancellation rate at your property
- Fix the denominator and write it down. Cancellations against reservations made in the period is the usual convention.
- Separate cancellations from no-shows. Track both, and use the combined figure for forecasting.
- Split by lead time into bands such as inside 7 days, 8 to 30, 31 to 90 and beyond. The spread will be wide.
- Split by channel and rate plan. This is where the actionable differences live.
- Apply it to on the books on every date inside your window, rather than reading the raw count as settled.
- Review annually and after any policy change. A looser cancellation policy shows up here before it shows up anywhere else.
What cancellation rate will not tell you
It cannot tell you whether a cancellation cost you anything. A room cancelled 40 days out on a date that later sold out cost nothing at all, and one cancelled two days out on a soft date cost the full rate. The rate treats them the same.
It says nothing about why guests cancelled. Plans change, a cheaper option appeared, the guest booked three properties and kept one. Those have different answers, and a percentage contains none of them.
And a falling cancellation rate is not automatically good news. Tightening your policy will reduce cancellations and may reduce bookings by more, since free cancellation is a real part of what makes a rate competitive. The number to watch alongside it is total revenue, not the rate on its own.
How ampliphi approaches cancellations
Ampliphi does not set your cancellation policy and does not manage reservations. Those sit in your PMS and in the rate plans you have built with each channel.
Where it is relevant is in what the rate suggestion reads. The everyday suggestion is demand-based, built on booking pace and occupancy, and pace is measured from reservations as they currently stand, so a date that gains nine bookings and loses three is assessed on the net position rather than on the gross. That keeps a date that looks busy but is churning from reading as stronger than it is.
What it does not do is model your attrition or produce an adjusted arrival forecast. The suggestion covers your base rate and the differential between room types. You approve every rate before it publishes, and ampliphi runs on top of the PMS you already use.
Key takeaways: cancellation rate
- The share of reservations cancelled before arrival, over a defined period.
- No-shows are separate. Track both, and combine them for forecasting.
- The blended figure is the least useful number in the set. Split by lead time and by channel.
- Long-lead bookings commonly cancel at several times the rate of short-lead ones.
- Use it to adjust on the books, because an unadjusted count leads you to hold rate on a date you should still be selling.
- A falling cancellation rate is not automatically good. A tighter policy can cost more bookings than it saves.
Frequently asked questions about cancellation rate
What is a normal cancellation rate for a hotel?
Wide enough that an external benchmark is close to useless for your decisions.
The figure depends on your channel mix, how much of your business is long-lead leisure, what share of your rates are freely cancellable and which market you are in. Two properties on the same street with different channel mixes will report very different numbers, and neither is wrong.
Your own splits are the benchmark that matters. Calculate the rate by lead time band and by channel from a trailing year, and compare against your own history rather than against a published average built from properties that do not look like yours.
How do I account for cancellations when reading on the books?
Apply your attrition rate for that lead time to the current count, rather than treating the count as final.
A date showing 35 of 46 rooms at 21 days out, in a property with 15 percent attrition at that lead time, is realistically nearer 30 arrivals. That five-room difference is exactly the gap between correctly continuing to sell and incorrectly deciding the date is done.
Do it with your own numbers by band, not a single blended figure, because the adjustment at 90 days out and at 5 days out are not remotely the same.
Should I tighten my cancellation policy to reduce cancellations?
Only if you can watch what happens to bookings at the same time, because the trade is real in both directions.
A stricter policy will reduce cancellations. It will also make your rate less attractive against a competitor offering free cancellation, particularly on OTAs where the filter is one tap away. Properties that tighten without measuring frequently find they traded a cancellation problem for a conversion problem.
The approach that usually works better is offering both: a flexible rate at a higher price and a non-refundable rate at a lower one, then letting guests sort themselves. That also gives you a clean read on how much flexibility is actually worth to your market.
Do OTA bookings cancel more than direct bookings?
At most properties yes, though the cause is usually the rate plan rather than the channel itself.
OTA bookings skew toward freely cancellable rates, are easier to make speculatively, and are more likely to be one of several held by a guest still deciding. Direct bookings skew toward guests who chose the property deliberately, and non-refundable direct rates cancel very little.
Measure it before assuming it, and split by rate plan as well as by channel so you can see which of the two is doing the work. The answer belongs in your net ADR yield thinking, since a channel that cancels heavily is worth less than its commission rate alone suggests.
Is a no-show the same as a cancellation?
No, and combining them hides two different problems.
A cancellation is a guest who told you, which gives you time to resell the room. A no-show is a guest who did not, which usually means the room is lost and there may be a charge to collect.
Track them separately so you can act on each. A rising cancellation rate points at policy, channel mix or a competitor. A rising no-show rate points at your guarantee and confirmation process. For forecasting purposes you want the combined figure, since both reduce arrivals, which is why the combined number is often called attrition rather than cancellation.
Related terms
On the books
The count of rooms currently reserved for a future date. The cancellation rate is what turns that count into a realistic expectation of arrivals.
Overbooking
Deliberately selling above capacity. The cancellation rate is the input the entire calculation rests on, and its variance is the risk.
Demand forecasting
Predicting how a date will finish. Expected attrition is the third term in the arithmetic, after on the books and expected pickup.
Booking window
The gap between booking and arrival. Cancellation rates vary sharply across it, which is why the blended figure is unusable.
Distribution mix
The share of room nights from each channel. Channels cancel at very different rates, so mix and attrition are the same conversation.