What cancellations actually cost your hotel

A cancellation feels like nothing happened. A booking arrived, a booking left, and the calendar looks the way it did before.

Sometimes that’s true. Added up over a year, the ones that arrive late are a revenue line. And at most hotels nobody owns that line, because no standard report separates the cancellations that cost you from the ones that didn’t.

When does a cancellation actually cost you?

It comes down to lead time, meaning how far before arrival the cancellation lands. An individual room cancelled 60 days out goes back on sale with plenty of demand still to come, and usually resells at or near full rate. Sometimes better, if the market has firmed up since. A group cancellation is a different problem: it can undo the pricing you built around that block, which is why groups get their own terms later in this piece.

The cost concentrates in the final days before arrival. Inside 72 hours, most of the people who were ever going to book that night have already booked. A room handed back on Thursday for Friday night faces thin demand. It goes unsold, or it resells cheap.

And that’s where cancellations cluster. Kalibri Labs’ analysis of US hotel data in 2023 found 45% of cancellations landed less than two days before arrival, and 64% inside a week. The market has moved since, on more than one continent, so take the shape as the lesson and get the level from your own data. The average notice period looks comfortable. Cloudbeds’ 2025 data, from 90 million bookings, puts the average cancellation window at 39 days, up from 35 in 2023. A few early cancellations drag that average out, and the money is in the cluster near arrival. The typical cancellation is late.

Rule of thumb: a cancellation at 60 days costs you nothing. A cancellation at 60 hours costs you the room.

Where does the revenue go when a guest cancels?

It goes into one of two columns, kept or lost, and the column is decided before the guest ever cancels.

Revenue kept. The booking was on a non-refundable rate, or your policy allowed a cancellation charge and the card details were valid. The guest cancelled, the money stayed. If the room then resells, that’s a bonus.

Revenue lost. The booking was flexible, or the fee was never collected. Now the room either sits empty, which costs the full rate, or resells at a distressed last-minute price, which costs the gap.

Explorer reports the two columns as two pages, CXL Income and CXL Loss. CXL is hotel shorthand for cancellation.

The total at stake is £28,080 a year, around 1.5% of this hotel’s room revenue at 75% occupancy, on cautious assumptions. The split came from which rate each guest booked and whether a fee could be charged.

Rule of thumb: revenue kept comes from the terms you set at booking. Revenue lost comes from the terms you didn't.

Which bookings cancel the most?

OTA bookings cancel at about twice the rate of direct ones, though the pattern at your hotel is the one that matters. Cloudbeds’ 2026 State of Independent Hotels report found bookings through OTAs such as Booking.com and Expedia cancelled at 21.8% in 2025. Direct bookings cancelled at 10.6%. Same hotels, same year.

Measured in money rather than bookings, it’s worse. D-EDGE’s 2024 Hotel Distribution Report, covering around 5,000 European hotels, found 42% of Booking.com revenue was cancelled in 2023 against 18% of direct revenue. Across all sources, 23% of bookings cancelled but 34% of revenue did, because the long-lead, high-value bookings are the ones most likely to go.

That gap is the trap inside your average. A blended cancellation rate of 18% looks manageable. It can hide one source running at 25% or more, quietly filling your calendar with bookings that evaporate. The same applies to segments and days of the week. A flexible corporate one-nighter on a Tuesday behaves nothing like a family booked non-refundable for the school holidays.

Studies count differently and markets vary, so twelve months of your own data beats any of them. And when you compare sources, compare the revenue you keep after commission, not the gross figure. Gross vs net revenue covers why that changes the answer.

Rule of thumb: never manage cancellations as one number. Break them down by lead time first, then source, then segment.

How do you measure your own cost?

Four numbers, all from the last 12 months of data in your PMS, the property management system that holds your bookings:

1. Cancellation rate by source, segment, and day of week. Count and percentage. The pattern is rarely spread evenly.
2. Refundable vs non-refundable mix. What share of the bookings on your calendar can walk away free? That share is inventory you hold at risk, not revenue.
3. Cancellation lead time. What share of cancellations lands inside 7 days of arrival, and inside 72 hours? Those are the ones that cost. The rest mostly resell.
4. Kept vs lost. For late cancellations, how much revenue stayed with you through non-refundable rates or charged fees, and how much walked out the door? Unsold rooms count at the full rate. Resold rooms count the gap.

Watch your occupancy while you do this. A hotel that refills late-cancelled rooms with heavy last-minute discounting can hold occupancy while revenue slides. That’s the occupancy trap, and cancellation-heavy sources feed it.

Which policies actually move the split?

Four policies move it: a real non-refundable discount, card validation, cancellation windows set by source, and deposits where the risk is. Each trades a few bookings for certainty, so aim it at the segments where the lost column lives, not at every guest.

• A real non-refundable discount. Price flexibility instead of giving it away. A gap of 10 to 15% gives committed guests a reason to lock in, and every booking that takes it moves from the lost column to the kept one before anything happens. Mews’ data puts only 22% of rates sold in 2024 on non-refundable terms, with flexible rates cancelling at over 35%. Booking.com’s own advice to partners says guests who pay online are four times less likely to cancel or no-show.
• Validate cards at booking. A cancellation fee only exists if it can be charged. On high-risk sources, a card check at booking time filters out the bookings that were never real and makes your policy collectable.
• Different windows by source. One policy everywhere is convenient. It is rarely the best one. If late cancellations cluster on one source, tighten the free-cancellation window there and keep the flexible terms for your direct guests.
• Deposits where the risk is. Group bookings, peak dates, and any segment with a proven late-cancellation history. A blanket deposit policy costs you bookings from guests who were always going to arrive.

Rule of thumb: free cancellation is a product. Sell it at a price, or stop giving it away.

See what you kept, what you lost, and which source cost you most

None of this needs a spreadsheet project. Explorer gives cancellations and no-shows two pages, fed in real time by your PMS. CXL Income is the money you kept: cancellation fees and non-refundable charges. CXL Loss is the money you lost on the bookings you couldn’t charge for. Both break rooms and revenue down by date, day of the week, room type and segment, then split products by date, day of the week and product type, so you can see whether the breakfasts and dinners that went with the room matter as much as the room itself.

The controls are the same as every Explorer page. Compare any date range against any other, always matched by day of the week, so a Monday is measured against a Monday. Look at cancellations by stay date or by the date the booking was made, which tells you whether a problem sits in a season or in a booking window. Switch the revenue view to Net (ex. tax & com) and the loss is measured on what you would have kept. Loss by source lives on the Sources page, which carries CXL Loss next to each source’s rooms, revenue and commission. AI Insights flags the concerns you’d otherwise dig for, like a single source or segment driving most of your late cancellations.