Overbooking Percentage Calculator — Hotel Overbook Rate

About the Overbooking Percentage Calculator — Hotel Overbook Rate

Overbooking percentage measures how far beyond physical capacity a hotel has sold rooms on a given night. It is calculated by subtracting available rooms from rooms sold, dividing by available rooms, and multiplying by 100. A positive percentage indicates the property is oversold.

Strategic overbooking is standard practice in the hotel industry because cancellations and no-shows reliably leave rooms empty. The challenge lies in finding the right level — enough to compensate for attrition without exceeding it and being forced to walk guests to competitor properties.

This calculator helps revenue managers quickly determine their overbooking level and assess whether it aligns with historical cancellation and no-show data. By tracking actual outcomes (walks versus empty rooms), you can continuously refine your overbooking strategy to maximise occupancy while keeping walk incidents within acceptable limits.

When This Page Helps

Overbooking is the single most impactful lever for maximising occupancy on sold-out or near-sold-out nights. Without it, hotels routinely leave 5-15% of rooms empty due to cancellations and no-shows. This calculator gives you precision control over how aggressively you overbook relative to your available inventory.

How to Use the Inputs

1. Enter the total number of rooms sold (including oversold reservations).
2. Enter the total number of rooms available in the hotel.
3. Review the overbooking percentage.
4. Compare against your historical cancellation + no-show rate.
5. Ensure the overbook level does not exceed your expected attrition.
6. Adjust the number of rooms sold to model different scenarios.

Example Calculation

Tips & Best Practices

• Base your overbooking level on your combined cancellation + no-show rate minus a safety margin.
• Set different overbooking levels by day of week — weekday attrition patterns differ from weekends.
• Always have a walk protocol and partner hotel agreements in place before overselling.
• Track the cost per walk (competitor room + transport + compensation) to set your risk tolerance.
• Increase overbooking during high-demand periods when walk alternatives are limited — be cautious.
• Use your PMS to set automated overbooking limits tied to real-time cancellation data.

The Economics of Overbooking

The financial case for overbooking is straightforward. An unsold room generates zero revenue and cannot be inventoried for tomorrow. If cancellations and no-shows reliably empty 15% of rooms, selling up to 10% beyond capacity captures revenue that would otherwise be lost entirely. The expected value of that incremental revenue almost always exceeds the expected cost of occasional walks.

Building an Overbooking Model

Effective overbooking models combine historical cancellation rates, no-show rates, walk costs, and marginal room revenue. The optimal overbook level is the point where the expected revenue from one additional room sold equals the expected cost of walking one additional guest. Revenue management systems compute this daily by room type.

Managing Walk Events Gracefully

When walks are necessary, execution matters enormously. Arrange the walk hotel in advance, provide complimentary transportation, offer a future stay voucher, and ensure the walked guest receives a personal call from management. A well-handled walk can preserve — or even strengthen — the guest relationship.

Frequently Asked Questions

• Is overbooking legal?

  Yes. Unlike airlines, hotels in most jurisdictions are not legally prohibited from overbooking. However, you have a contractual obligation to find comparable accommodation if you cannot honour a reservation.

• What is a safe overbooking percentage?

  A common guideline is to overbook at 50-80% of your combined cancellation and no-show rate. If your total attrition is 20%, overbooking by 10-16% provides a reasonable balance between occupancy and walk risk.

• What happens when I overbook too much?

  You are forced to "walk" guests — relocate them to another hotel at your expense. Walk costs include the competitor's room charge, transportation, compensation, and significant goodwill damage, especially with loyalty members.

• How do I decide which guests to walk?

  Walk order should prioritise protecting high-value guests. Loyalty programme members, direct bookers, and long-stay guests should never be walked. OTA single-night reservations booked at the lowest rate are typically walked first.

• Does overbooking affect my STR data?

  STR metrics are based on rooms sold and revenue, not physical capacity. Overbooking can inflate your reported occupancy above 100% on sold-out nights, which is reflected in RevPAR performance.

• Can I overbook specific room types?

  Yes. Many hotels overbook standard room types more aggressively and accommodate overflow with complimentary upgrades to premium rooms. This reduces walk risk while still capturing incremental revenue.