Hotel booking cancellation rate: formula and fair comparisons

Hotel booking cancellation rate answers a specific question: what share of a defined group of reservations ended in cancellation? A useful answer needs more than two totals. The reservations in both totals must belong to the same group, and their status must be evaluated at a stated time.

This guide concerns measurement for hotels in Azerbaijan. For reception decisions, room release and payment follow-up, use the separate cancellation and no-show handling guide. All numbers below are fictional examples, not market benchmarks.

Start with the formula and one counting unit

HSMAI Academy defines cancellation rate as cancelled bookings divided by total bookings.

Cancellation rate (%) = cancelled reservations ÷ all valid confirmed reservations in the cohort × 100.

For this worksheet, count each unique reservation once. Exclude test records, duplicates and enquiries that never became confirmed reservations. A confirmed reservation that later cancels remains in the denominator. Removing it would turn the calculation into a different ratio.

If the cohort contains 100 confirmed reservations and 20 have cancelled by the cutoff, the result is 20 ÷ 100 × 100 = 20%. Dividing by the 80 remaining reservations would be incorrect for this measure. With no eligible reservations, show “not applicable” rather than zero percent.

Define the arrival cohort before reading statuses

Use an arrival-month cohort: all valid confirmed reservations originally due to arrive during September, including those cancelled before September began. For this example, fix membership using the arrival date recorded at initial confirmation. Retain that date in the history, and identify subsequent date changes separately.

Evaluate those same records using their final known status at a documented cutoff, for example 5 October after the September review. The report should name the period, cutoff and date-change rule. A later correction requires a labelled revision. If some outcomes remain unresolved, mark the result provisional and give the unresolved count.

Do not divide cancellations recorded during September by reservations arriving during September. The first total could include December stays, while cancellations of September stays recorded in August would disappear. An alternative cohort based on booking creation month can be useful, but it answers a different question and needs its own outcome cutoff. A cancellation-date activity report measures operational flow, not this arrival-cohort percentage.

Combine channels using counts

Consider two fictional channels within the same cohort and cutoff.

Channel	Cancelled / confirmed and rate
A	10 / 20 = 50%
B	10 / 80 = 12.5%
Combined	20 / 100 = 20%

The simple average of 50% and 12.5% is 31.25%, which gives the smaller channel too much weight. Add the cancelled counts and confirmed counts first. Show both counts beside every percentage, especially for small samples.

A channel difference is a reason to investigate, not proof of poor performance. Review booking conditions, guest segments and booking lead time before interpreting it. Apply the same cohort rules to each channel and keep unknown sources visible.

Keep other measures separate

A no-show is not a cancellation in this worksheet. It stays outside the cancellation numerator and remains in the original confirmed denominator. Track it separately. A shortened stay also needs its own classification rather than treating the whole reservation as cancelled.

Reservation counts and room-night counts produce different weights. A one-night reservation and a five-night reservation each count once here. A room-night cancellation measure needs documented rules for original nights, partial cancellations and amendments; label it separately. Refund amounts cannot substitute for cancelled reservations because booking status and payment movements describe different events.

Preserve enough evidence to repeat the calculation

Prepare a worksheet with a unique reservation identifier, initial confirmation date, original arrival date, booking source, status history and cancellation timestamp where applicable. Add the report cutoff and correction notes. These are analytical data requirements, not a promise that every field is available in a BirOtel export.

Deleted cancellation records cannot be reconstructed reliably from a current active-booking list. Preserve supported history or dated snapshots. Pickup reporting likewise depends on knowing what changed between observations.

Use the BirOtel reporting overview to review the current reporting scope, then demonstrate with sample records whether the required history can be obtained. This calculation does not establish a native cancellation-rate dashboard or automatic refunds. Give the monthly review a named owner who checks exclusions, unresolved statuses and the combined totals before distributing the result.

Frequently asked questions

What if the denominator is zero? Show “not applicable”; zero eligible bookings cannot establish a cancellation percentage.

Does a no-show count as cancelled? No. Keep it outside the cancellation numerator and inside the original confirmed denominator.

Can channel percentages be averaged? Add cancelled counts and confirmed counts first, then calculate the combined percentage.