RevPARGenius methodology and owner guides
Reviewed by Mark Joefer, Hotel Market Intelligence Researcher · 13 October 2026 · 9 min read
Hotel cancellations and no-shows do not change what a room is worth, but they change how much the pickup on your screen can be trusted. In our worked example, 9.4% of reservations cancelled or did not arrive.
This guide is for GMs and owners of small hotels, motels and parks who set rates from pickup. It covers how to read pickup net of cancellations, when a non-refundable rate pays, and why overbooking needs a policy before it needs a number.
Hotel cancellations matter for pricing because they turn gross pickup into a smaller net figure. In a worked example (synthetic data) for a fictional 40-cabin NZ park, 47 of 640 reservations (7.3%) cancelled and 13 (2.0%) were no-shows. Read pickup net of cancellations, keep any non-refundable discount below your own cancellation share, and do not overbook without a written policy.
How many bookings cancel or no-show in a small property?
It varies by property, channel and season, so the only figure that matters is your own. To show how to read it, we use a worked example (synthetic data) for a fictional 40-cabin NZ holiday park, 90 nights from 14 October 2026. It is not a real property, and its booking sample is separate from its daily occupancy file, so the two are not added together.
| Reservation status (worked example (synthetic data)) | Reservations | Share of 640 |
|---|---|---|
| Confirmed | 580 | 90.6% |
| Cancelled | 47 | 7.3% |
| No-show | 13 | 2.0% |
| Cancelled or no-show | 60 | 9.4% |
Shares computed from the booking sample in the worked example.
Put plainly: for every 100 reservations taken, about 7 cancelled and 2 did not arrive. That is a manageable level, but it is not zero, and it changes how you should read the numbers on your screen when you set rates.
Why do cancellations change how you read pickup?
Pickup is the number of rooms booked for a future night since you last looked. Most property systems show gross pickup: new bookings added. Net pickup subtracts the cancellations that came in over the same period. When cancellations are steady, the two numbers tell the same story. When a group or a batch of flexible bookings cancels, gross pickup can look strong while the night is actually going backwards.
For pricing this matters because a rate decision is a response to pace. If a Saturday shows six rooms picked up this week but four of the earlier bookings cancelled, the real movement is two rooms. Raising the rate on the back of six is a decision made on a number that is not there.
Timing matters as much as the count. In the worked example (synthetic data), confirmed reservations had a median lead time of 14.5 days, with the middle half between 6 and 30 days. Half of all confirmed bookings (290 of 580) arrived within 14 days of the stay, and 169 (29.1%) within 7 days.
| Lead time band | Confirmed reservations | Share of 580 |
|---|---|---|
| 0–3 days | 83 | 14.3% |
| 4–7 days | 86 | 14.8% |
| 8–14 days | 121 | 20.9% |
| 15–30 days | 150 | 25.9% |
| 31–60 days | 107 | 18.4% |
| 60+ days | 33 | 5.7% |
Worked example (synthetic data). Lead time counts confirmed reservations only.
If half the bookings arrive in the last fortnight, a cancellation 20 days out still leaves time to resell the room. A cancellation two days out often does not. Our lead time guide shows how to find when your last rooms actually sell.
Read pickup net of cancellations, and note when the cancellations land. A cancellation that comes inside your last-minute booking window is the one that costs a room night.
When does a non-refundable rate pay for itself?
A non-refundable rate trades a discount for certainty. It pays when the discount is smaller than the revenue you would otherwise lose to cancellations you cannot resell. As a simplified illustration: the discount should stay below the revenue you expect to lose from flexible bookings that cancel and are not resold. That depends on the rates, lengths of stay and cancellation fees of the bookings that cancel, not only on how many cancel.
In the worked example (synthetic data), 7.3% of reservations cancelled. If we assume the cancelled bookings were worth about the same as the rest, carried no cancellation fee, and none were resold, a non-refundable discount deeper than about 7% would give away more than the cancellations take. Change any of those assumptions and the ceiling moves. If most cancelled rooms are resold, which is likely when half the bookings arrive in the last 14 days, the useful discount is smaller still. That is why many small properties keep the non-refundable step modest and use it mainly on high-risk dates.
Fences make the trade cleaner. The common ones:
- Cancellation window: free cancellation until 7 or 14 days out on normal nights, longer on event nights such as the Labour Day long weekend (24 to 26 October 2026) or Christmas and New Year.
- Deposit: a first-night deposit on peak dates, refundable up to the window.
- Rate plan by channel: check that the non-refundable plan you load on the OTA and your website has the same terms, so guests do not shop the fence.
- No-show charge: a clear first-night charge for no-shows, stated at booking and applied consistently.
Should a small hotel overbook to cover no-shows?
Only with a written policy and a plan for the guest who arrives to a full house. Overbooking is a calculated risk that large hotels manage with data and relocation agreements. In a 20- or 40-room property, one walked guest on a busy night can mean a refund, a taxi, a room at a competitor and a review that outlives the revenue.
The worked example (synthetic data) shows why caution fits: 13 no-shows across 640 reservations is 2.0%, a small number to plan a full night around, and no-shows do not arrive evenly across dates. If you want to explore overbooking, start by recording no-shows by night, by channel and by rate plan for a full season, agree a relocation arrangement with a nearby property, and set a limit of one room on nights your own history supports. We do not recommend overbooking without that policy.
How should cancellation patterns change your weekly rate review?
Add three lines to the review you already do. The 20-minute weekly rate review template has space for them:
- Cancellations received this week, by stay date, and whether each room was resold.
- Net pickup for the next 30 nights, beside gross pickup.
- Any night where cancellations pushed occupancy on the books back below the level that triggered your last rate rise.
If a night you raised has gone backwards because of cancellations, do not drop the rate straight away. Check whether the cancellations landed early enough to resell. Then use break-even occupancy (current occupancy × current rate ÷ target rate) to see what the higher rate needs. In the worked example (synthetic data), at 93.2% occupancy a 5% higher rate keeps the same room revenue down to 88.8%. Our break-even occupancy check walks through the same sum with your own numbers.
What to do this week
- Export the last 90 days of reservations with status, channel, rate plan and lead time. Work out your own cancelled and no-show shares.
- Split cancellations by how many days before arrival they came. Mark those inside your last-minute window.
- Compare your non-refundable discount with your cancellation share. If the discount is deeper, review it.
- Check that cancellation terms match across your website and each booking site.
- Add net pickup and cancellations to your weekly rate review sheet.
Our take
Cancellations and no-shows do not change what a room is worth. They change how much you can trust the pickup you are reacting to.
In the worked example, 9.4% of reservations cancelled or did not show. Read pickup net of cancellations, keep any non-refundable discount below your own cancellation share, and leave overbooking alone unless a written policy and a relocation plan are in place.
Frequently asked questions
What is a normal hotel cancellation rate?
There is no single normal rate; it depends on channel, rate plan, season and guest mix. Measure your own over at least 90 days. In the worked example in this guide, 7.3% of reservations cancelled and 2.0% were no-shows.
What is net pickup in hotel pricing?
Net pickup is the number of new bookings for a future night minus the cancellations received over the same period. It shows the real movement on a date, which is what a rate decision should respond to.
How big should a non-refundable discount be?
Keep it below the share of flexible bookings that cancel and are not resold. If 7% of bookings cancel and none are resold, a discount above about 7% gives away more than cancellations take; if most are resold, keep the discount smaller.
Should small hotels overbook?
Only with a written policy, a relocation arrangement with a nearby property and a clear limit based on your own no-show history. In a small property one walked guest can cost more than the extra booking earned.
Do cancellations mean I should lower my rate?
Not automatically. Check when the cancellations came and whether the rooms can be resold in your usual booking window. Then use break-even occupancy to judge whether the current rate still works.
The next step is to put your own dates beside the market middle for the same nights, with the capture date on every number.
Data sources: worked example (synthetic data) for a fictional 40-cabin NZ holiday park, booking sample of 640 reservations and daily file for 90 nights from 14 October 2026. Analysis run October 2026. Last reviewed October 2026. RevPARGenius is a hotel market intelligence platform. It is not affiliated with any online travel agency or hotel chain.
Research methodology and disclosures: Market figures in this article are calculated by RevPARGenius from room rates publicly displayed on online travel agency (OTA) channels, on one search basis (1 night, 2 adults, 1 room, cheapest offer shown). We publish a market figure only where at least 15 properties were priced. The figures are advertised asking prices. They do not show occupancy, bookings, negotiated corporate rates or revenue achieved. Worked examples marked as synthetic use invented data. This article is general information, not pricing advice: each hotel sets its own rates independently. RevPARGenius and CloseMode are commercially affiliated platforms.
