Reservations and Waitlists

Reservation Reports Every Manager Should Read

Five weekly reservation reports: covers by source, no-shows, lead time, party size and turn time, what each shows and the action each drives.

AssistCall research teamPublished Reviewed by Faruque Amin, VP of Sales and Marketing6 min read

On this page
  1. Why five reports are enough
  2. Set up the weekly review
  3. Report 1: covers by source
  4. Report 2: no-shows and late cancellations
  5. Report 3: booking lead time
  6. Report 4: party size mix
  7. Report 5: turn time
  8. Make the data trustworthy first
  9. Two more numbers worth a glance
  10. The five reports on one page
  11. Example: one week, five actions
  12. Frequently asked questions
  13. References
Reservations and Waitlists: Reservation Reports Every Manager Should ReadArticle coverRESERVATIONS AND WAITLISTSReservation ReportsEvery Manager ShouldReadAva for RestaurantsInsightsReservations and Waitlists: Reservation Reports Every Manager Should ReadArticle coverRESERVATIONS AND WAITLISTSReservation ReportsEvery Manager ShouldReadAva for Restaurants

Key takeaways

  • Five reports cover most decisions: covers by source, no-shows and late cancels, lead time, party size mix and turn time.
  • Read them weekly in a fixed 20-minute slot, comparing with the same week last month and last year.
  • Every report should end in an action or a deliberate decision to change nothing.
  • Count seated covers, not bookings; bookings flatter the numbers.

Why five reports are enough

Reservation systems can produce dozens of reports. Most managers open none of them, because there is no time and no clear question to answer. Five reports, read every week, cover the decisions that matter: where guests come from, who fails to show, how far ahead people book, what sizes of party you seat and how long tables take. Each one drives a specific action on staffing, policy, marketing or pacing.

The money is in the actions. Food and labor each take roughly 33 cents of every sales dollar[1], so scheduling servers and prep to the covers you will really seat is one of the biggest levers a manager has. Reservation data is the best forecast you have.

Set up the weekly review

  1. Pick a fixed slot

    Monday or Tuesday morning, 20 minutes, with the general manager and host lead.

  2. Export the same date range

    Last full week, Monday to Sunday, plus the same week last month and last year for comparison.

  3. Use seated covers

    Count guests seated, not bookings made. Mark no-shows and walk-ins correctly at close each night, or every report is wrong.

  4. Read the five reports in order

    Source, no-shows, lead time, party size, turn time.

  5. Write one action per report

    Or write "no change". Review last week's actions first.

Report 1: covers by source

This report shows where seated guests booked: phone, your website, each booking network, social links, walk-ins. Phone remains a large channel for many restaurants; at top US restaurants studied by Cornell, 49% of reservations were made by telephone and 25% through one online platform[2]. Among online bookers, about 60% used a multi-restaurant site rather than the restaurant's own website[3]. Your mix will differ, which is the point of measuring it.

How reservations were made at top US restaurantsCornell study, 2012; other channels made up the rest
How reservations were made at top US restaurantsColumn chart. Telephone: 49%; One online platform: 25%.0%20%40%60%Telephone: 49%49%TelephoneOne online platform: 25%25%One online platformHow reservations were made at top US restaurantsColumn chart. Telephone: 49%; One online platform: 25%.0%20%40%60%Telephone: 49%49%TelephoneOne online platform: 25%25%One onlineplatform

Source: Cornell University Center for Hospitality Research (Kimes and Kies), 2012[2]

Show the data
ItemValue
Telephone49%
One online platform25%
  • Question: which channels bring guests, and which bring new guests?
  • Watch: a falling phone share alongside rising missed calls; a rising network share on nights you sell out anyway.
  • Action: move promotion to channels that fill quiet nights; push direct booking links to repeat guests; staff the phone at the hours calls arrive.

Source data also drives cost. Network covers often carry higher fees than direct ones, as explained in reservation platform fees and cover charges.

Report 2: no-shows and late cancellations

Split bookings that did not dine into no-shows (no word) and late cancellations (cancelled within your policy window). Break both down by night, slot, party size and source. Cornell research advises restaurants to discourage late arrivals, overbook or charge for no-shows, and make it easy for customers to contact the restaurant if they are running late or cannot make it[4].

  • Question: where and when are tables lost?
  • Watch: a no-show rate rising on particular nights or from one channel; unconfirmed bookings no-showing far more than confirmed ones.
  • Action: move or strengthen reminders, add card holds for the worst slots, or set a small overbooking allowance as described in overbooking reservations without burning guests.

Report 3: booking lead time

Lead time is the gap between when a booking is made and when the guest dines. Read it as a distribution: what share booked the same day, one to three days ahead, four to fourteen days and further out. Also note when bookings are made: an early Cornell analysis cited an estimate that 25% of online reservations are made between 10 pm and 10 am[5], when nobody is at the stand.

  • Question: how far ahead do prime slots fill, and is that changing?
  • Watch: prime slots filling earlier each month, which can mean regulars are being squeezed out.
  • Action: adjust the booking window or hold back tables for later release; see how far in advance to open reservations.

Report 4: party size mix

Count seated parties by size: ones, twos, threes and fours, fives and sixes, and larger. Compare the mix with your table mix. A room full of four-tops seating couples is losing covers every night.

  • Question: does the floor plan match the parties you actually seat?
  • Watch: twos seated at fours on busy nights; large parties being turned away because tables cannot combine.
  • Action: split or combine tables, change which sizes can book online, or adjust the large-party policy.

Report 5: turn time

Turn time is how long a table is occupied, from seating to leaving, by party size and night. Most systems estimate it from seat and clear times; if your POS records check open and close, use that. Average turn time hides the long tail, so look at the slowest quarter of tables too.

  • Question: are the durations in the booking system realistic?
  • Watch: tables regularly overrunning the duration set for that party size, which causes waits for the next booking.
  • Action: correct durations in the system, change pacing, or introduce time limits on peak slots, as explained in time-limited reservations.

Make the data trustworthy first

Reports are only as good as the close-out each night. If hosts do not mark no-shows, walk-ins are seated without being entered, or tables are cleared in the system an hour after guests leave, every number above is wrong. Before you act on any report, fix the habits that feed it.

  • Mark every no-show and late cancellation before the stand closes.
  • Enter walk-ins in the system when they are seated, even on paper-list nights.
  • Seat and clear tables in the system as it happens, not in a batch at the end of the night.
  • Record the true source of phone bookings, rather than letting staff pick the first option in the list.
  • Merge duplicate guest profiles monthly so repeat guests are counted as repeat guests.

Spend the first two weekly reviews checking data quality rather than making decisions. Pick five bookings at random and compare the record with what the host remembers. Once the records match the night, the reports become something you can run the business on.

Two more numbers worth a glance

Beyond the five reports, two quick numbers catch problems the reservation book cannot see. First, walk-ins turned away or lost from the waitlist, by night: if this is high on nights when the book shows empty tables, your split between booked and walk-in tables needs work. Second, missed calls by hour from your phone system: if they cluster in the hour before service, guests trying to book or change plans are not getting through, which shows up later as lost covers and no-shows.

The five reports on one page

A one-page summary for the weekly reservation review
ReportKey questionExample triggerTypical action
Covers by sourceWhere do seated guests come from?Phone share falling while missed calls riseStaff or cover the phone at peak call times
No-shows and late cancelsWhere are tables lost?One slot no-shows far more than othersEarlier reminder, card hold or small overbook
Lead timeHow far ahead do prime slots fill?Saturdays full three weeks outHold back tables or change the window
Party size mixDoes the floor fit the parties?Many twos seated at foursSplit tables or change online party limits
Turn timeAre durations realistic?Four-tops overrun their durationFix durations; pace or limit peak tables

Example: one week, five actions

Example: a 100-seat restaurant reviews its week. Covers by source show phone bookings down on Friday afternoon while voicemail messages rose, so the manager moves a host shift earlier to cover calls. No-shows were highest for Saturday 6:00 pm two-tops booked through a network, so those get a card hold. Lead time shows Saturday 7:30 pm full nine days out, unchanged, so the window stays. Party size shows couples seated at four-tops most Fridays, so two four-tops are split into two-tops. Turn time shows six-tops overrunning by about 20 minutes, so the system duration for six-tops is extended.

Five small changes, each tied to a number, are more useful than a long report nobody acts on. If many of the gaps trace back to unanswered calls, Ava can answer the restaurant line and log every call, so demand that used to vanish into voicemail shows up in your records. When late cancellations show up in Report 2, follow how to refill last-minute cancelled tables.

Frequently asked questions

Which reservation reports should a restaurant manager read?

Covers by source, no-shows and late cancellations, booking lead time, party size mix and turn time, every week, compared with the same week last month and last year.

How do I calculate my restaurant no-show rate?

Divide bookings that did not arrive and did not cancel by total bookings for the same period. Split it by night, slot, party size and source to find where to act.

What is booking lead time?

The gap between when a reservation is made and when the guest dines. It tells you how far ahead prime slots fill and whether your booking window fits.

Why use seated covers instead of bookings?

Bookings include no-shows and cancellations, so they overstate demand. Seated covers show what actually happened and what to staff for.

References

  1. National Restaurant Association (2026). Restaurants remain resilient despite challenging business conditions (opens in a new tab) ↑

  2. Cornell University Center for Hospitality Research (Kimes and Kies) (2012). The Role of Multi-Restaurant Reservation Sites in Restaurant Distribution Management (Cornell Hospitality Report, 2012) (opens in a new tab) ↑

  3. Cornell University Center for Hospitality Research (Kimes and Kies) (2012). The Role of Multi-Restaurant Reservation Sites in Restaurant Distribution Management (Cornell Hospitality Report, 2012) (opens in a new tab) ↑

  4. Cornell University (Sheryl E. Kimes) (2011). Customer Attitudes towards Restaurant Reservations Policies (Kimes, Journal of Revenue and Pricing Management, 2011) (opens in a new tab) ↑

  5. Cornell University Center for Hospitality Research (Sheryl E. Kimes) (2009). How Restaurant Customers View Online Reservations (Cornell Hospitality Report Vol. 9, No. 5) (opens in a new tab) ↑

Book a demo

See Ava handle your calls.

Book a short demo. We’ll walk through your calls and workflow, and agree what Ava should take care of.

Book a demo