Calculate hotel overbooking percentage from rooms sold vs. available. Balance revenue maximisation with walk risk for optimal inventory management.
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.
Restaurant owners, hotel managers, and event coordinators depend on accurate overbooking percentage calculator — hotel overbook rate numbers to maintain profitability while delivering exceptional guest experiences. Return to this tool whenever menu prices, occupancy rates, or staffing levels shift to keep your operations on track.
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. Instant results let you test multiple scenarios so you can align pricing, staffing, and inventory decisions with current demand and cost pressures.
Overbooking % = ((Rooms Sold − Available Rooms) ÷ Available Rooms) × 100
Result: 10.00%
(220 sold − 200 available) ÷ 200 × 100 = 10.00% overbooking. The hotel has sold 20 more rooms than physical capacity, anticipating cancellations and no-shows.
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.
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.
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.
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.
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.
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.
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.
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.
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.