Home / Free Tools / Hotel Overbooking Calculator
Free hotel tool

Hotel Overbooking Calculator

Find how many extra rooms you can safely sell using your no-show rate, late cancellations and the cost of walking a guest.

Data-drivenIncludes walk costNo sign-up
From your last 3 months of data
Cancelled on the day / too late to resell
Alternative hotel, transport, goodwill

Why hotels overbook

Some guests never arrive and some cancel too late to resell the room. Without overbooking, those rooms stay empty and the revenue is lost. A controlled overbooking level sells a few extra rooms so that, after no-shows and late cancellations, the hotel ends the night close to full — without walking guests. This hotel overbooking calculator suggests a safe number using your own no-show history and the cost of walking a guest.

Suggested overbooking = Expected empty rooms × ADR ÷ (ADR + cost of walking a guest)

The safety factor makes the calculator more careful when walking a guest is expensive. Read our full guide to hotel overbooking strategy for rules by day of week, group arrivals and peak nights.

Rules for safe overbooking

  • Use separate no-show rates for weekdays, weekends and segments — OTA prepaid guests rarely no-show.
  • Reduce overbooking on sold-out city-wide event nights when alternative hotels are full.
  • Agree a walk policy with a nearby partner hotel in advance.
  • Never overbook VIPs, long stays or guests arriving late at night.

Frequently asked questions

Is overbooking legal for hotels?

Overbooking is a common industry practice, but hotels must treat walked guests fairly — typically by arranging and paying for comparable alternative accommodation and transport. Check local consumer rules and OTA policies.

How do I find my no-show rate?

Divide the number of no-show reservations by total reservations due to arrive over the last few months, ideally separately for weekdays, weekends and each booking channel.

What does it cost to walk a guest?

Usually the alternative room, transport, a goodwill gesture and the risk of a negative review. Including this cost keeps your overbooking level conservative.

Want a revenue expert to check your numbers?

Get a free OTA, pricing and reputation audit from Revgrow360 — no obligation.