No-Show Rate Calculator — Hotel No-Show Percentage

Calculate hotel no-show rate as a percentage of expected arrivals. Optimise overbooking strategy and reduce lost revenue from no-show guests.

$
No-Show Rate
8%
12 of 150 bookings
Show Rate
92%
138 guests arrived
Revenue Lost
$2,160.00
12 × $180.00
Revenue Retained
$24,840.00
From 138 arrivals
Overbook By
8.7%
+14 extra bookings
Actual Arrivals
138
150 − 12
Arrivals vs No-Shows92% / 8%
Arrived
No-Show
Planning notes, formulas, and examples

About the No-Show Rate Calculator — Hotel No-Show Percentage

The no-show rate measures the percentage of guests with confirmed reservations who fail to check in without cancelling. It is calculated by dividing the number of no-shows by the expected arrivals for a given day or period and multiplying by 100.

No-shows represent a direct revenue leak for hotels because the room sits empty despite being held for a guest who never arrives. Unlike cancellations, which happen in advance and allow the hotel time to resell, no-shows typically occur too late in the day to recover the lost revenue through walk-in or last-minute bookings.

This calculator helps revenue managers quantify no-show exposure, build more accurate overbooking models, and evaluate the effectiveness of guarantee and deposit policies. Tracking no-show rates by segment, day of week, and booking channel reveals actionable patterns that can significantly reduce revenue loss.

When This Page Helps

No-show data is the most critical input for your overbooking model. Without an accurate no-show rate, you either overbook too aggressively (causing costly walks) or too conservatively (leaving rooms unsold). It gives the foundational metric to balance those risks.

How to Use the Inputs

  1. Enter the number of no-shows for the period.
  2. Enter the total expected arrivals (confirmed reservations due to check in).
  3. Review the calculated no-show rate.
  4. Compare against historical rates and day-of-week patterns.
  5. Use the rate to inform your overbooking percentage.
  6. Evaluate whether guarantee or deposit policies should be tightened.
Formula used
No-Show Rate (%) = (No-Shows ÷ Expected Arrivals) × 100

Example Calculation

Result: 8.00%

12 no-shows ÷ 150 expected arrivals × 100 = 8.00% no-show rate. Eight percent of guests with reservations failed to check in.

Tips & Best Practices

  • Require credit card guarantees for all reservations to reduce no-shows.
  • Send day-before arrival confirmation emails or texts to catch potential no-shows early.
  • Charge a no-show fee equal to one night's room rate for guaranteed reservations.
  • Track no-show rates by day of week — Fridays and Sundays often have higher rates.
  • Use historical no-show data to set overbooking levels on a night-by-night basis.
  • Segment no-shows by rate type — non-guaranteed rates naturally have higher no-show rates.

The Revenue Impact of No-Shows

A 200-room hotel with 90% occupancy and a 5% no-show rate loses approximately 9 room nights per night, which at an ADR of $150 amounts to over $1,350 in daily lost revenue — nearly $500,000 annually. Even modest reductions in the no-show rate translate to meaningful revenue gains.

No-Show Patterns and Predictions

No-show behaviour follows predictable patterns. Business travellers are more likely to no-show on Mondays (flight changes) and Fridays (early departures). Leisure guests tend to no-show more during shoulder seasons when travel plans are less firm. Building day-of-week and seasonal no-show models improves overbooking accuracy.

Technology Solutions

Modern PMS platforms can automate pre-arrival confirmation workflows, flagging guests who haven't responded as potential no-shows. Some revenue management systems incorporate real-time no-show probability scores into their overbooking recommendations, helping front-desk managers make better day-of decisions.

Sources & Methodology

Last updated:

Frequently Asked Questions

  • Most hotels see no-show rates between 2% and 10%, though rates vary by market, season, and guarantee policy. Properties with strong deposit requirements tend to see rates below 3%.