Reservation cancellation rate measures what percentage of confirmed bookings are cancelled before service. It helps you understand how reliable demand is and adjust forecasts, rotas, purchasing and booking policy.
Reservation cancellation rate in hospitality is the percentage of confirmed bookings that end up being cancelled before service time. It is a key indicator for any restaurant that works with a booking diary, sittings, set menus, limited terrace space or high demand, because it lets you separate apparent demand from the demand actually served. A restaurant can have a full book on Tuesday morning and still reach service with empty tables if many bookings cancel at the last minute. Cancellation is not always negative: a cancellation with enough notice lets you release the table, accept another booking, reorganise the floor and adjust production.
The problem arises when cancellations are frequent, late or concentrated in high-demand time slots. In that case they affect occupancy rate, RevPASH, demand forecasting, staff planning and purchasing of perishable products. It is worth analysing cancellations by day of the week, sitting, booking channel, party size, lead time and type of guest. A table for two cancelled 48 hours ahead is not the same as a table for ten cancelled an hour before service.
It should also be distinguished from a no-show: with a cancellation, the guest lets you know; with a no-show, they neither turn up nor release the table. A reasonable cancellation rate depends on the type of business, but when it regularly exceeds 10–15%, it is worth reviewing automatic confirmations, deposit policy, waiting lists, reminders, conditions for groups and the quality of your booking channels.
Cancellation rate (%) = (Cancelled bookings / Confirmed bookings) × 100
To calculate it, take all the confirmed bookings for a period and divide the number that were cancelled by the total number of confirmed bookings. Then multiply by 100. If your restaurant had 240 confirmed bookings in a week and 30 were cancelled, the cancellation rate was (30 / 240) × 100 = 12.5%.
To make the figure useful, it is worth also calculating the late cancellation rate: bookings cancelled within a critical window, for example less than 4, 12 or 24 hours before service. That variant is usually more important financially than total cancellations, because it shows how much capacity is lost without enough time to resell the table.
A 70-seat restaurant records 320 confirmed bookings in May. Of these, 42 are cancelled: 18 more than 24 hours in advance, 14 on the same day and 10 in the last hour before service. The total cancellation rate is 42 / 320 × 100 = 13.1%. The figure seems manageable, but analysing by sitting, the restaurant finds that late cancellations on Saturday nights reach 9% and mainly affect tables of four or more booked through external platforms.
Since those tables are hard to fill at such short notice, the restaurant introduces automatic reminders the day before, asks large groups to actively confirm and sets up a waiting list. A month later, the total cancellation rate falls only to 11%, but late cancellations drop to 4%, improving actual occupancy and reducing unproductive hours front of house and in the kitchen.
Cancellation rate matters because a booking is not revenue until the guest sits down and orders. If the restaurant plans purchasing, mise en place and staff rotas around bookings that later disappear, it ends up with too much product prepared, too many staff and empty tables at peak times. It also helps you assess the quality of each booking channel: a channel may bring in many bookings, but if it cancels twice as often as your own website, it may not be as profitable. Monitoring this metric helps you decide when to ask for a deposit, when to confirm manually, how much cautious overbooking to accept, how to manage waiting lists and which time slots need commercial action.
It is especially useful alongside no-shows, occupancy, demand forecasting, average spend and RevPASH, because it connects guest behaviour with capacity, revenue and operating profitability.
Zindra helps you control cancellation rate by connecting bookings, occupancy, sales and operational planning. You can see cancellations by sitting, channel, time slot, party size and lead time, compare forecast demand with actual demand and adjust purchasing, rotas, confirmations and booking policies based on data, not gut feeling.
Tools and content to go deeper into this concept.
RevPASH (Revenue per Available Seat Hour) measures the revenue generated by each available seat per hour. It is the most complete indicator of a restaurant's operational efficiency and real profitability.
The occupancy rate measures the percentage of available seats actually filled during a service. It is a key indicator of a restaurant's efficiency and the basis for working out its revenue potential.
Table turnover measures how many times each table is occupied during a service. It is a key operational efficiency indicator which, combined with average spend, determines the restaurant's revenue potential.
A no-show is when a guest with a booking neither turns up nor lets you know. No-shows affect 10–20% of bookings in Spain and cost restaurants thousands of euros a year in empty tables that could have been re-let.
Controlled overbooking is the practice of accepting more bookings than there are seats, anticipating that a percentage of guests won't turn up (no-shows). Calculated well, it maximises occupancy without creating conflicts.
Demand forecasting is the prediction of the sales, covers or usage a restaurant will have in a future period. It helps you buy better, plan staff and prepare production with less waste and fewer stockouts.
Every hospitality term with formulas, examples and benchmarks in a handy PDF.
Try Zindra free and keep food cost, staff, inventory and much more under control from a single platform.