Unfulfilled Reservations

This report is useful for seeing how many reservations have been "missed" due to customer cancellations, inquiries that did not turn into reservations, and not being able to accommodate customers.  It will report percentages (or totals) in five categories:

Could Not Fill (the "couldn't book" flag on reservations)

Cancelled (presumably cancellations by the customer)

No-Show (the customer did not show up)

No-Stay (the customer showed up but did not stay at least 1 night)

Mistake (an operator cancelled it for some reason)

Cancelled/Other (an operator cancelled it for some reason other than those above)

Waiting List (couldn't book them but they wanted to know if something came available)

Inquiries (information saved but no reservation made)

Filled or Pending (either successful past reservations or booked future reservations).  

The Filled or Pending category is included even though they were not unfulfilled, just so that the totals can be seen for proper perspective.

Note that you can use this report to report on future dates as well as the past, which can indicate when you have a lot of customers already waiting for space (perhaps to prepare some extra sites to take on the demand).  You can also have it report according to the date each reservation was created.

In addition to the percentages for each date period of each category, the average percentage for the entire date range is shown.  Since all possible status conditions are covered, the Totals for all categories should be 100% for each date period, as well as the Averages.

If you don't select the Show as Percentages option, you will see the actual number of reservations (or reservation nights) for each of the categories, which can also be useful.

You can also select which site types to report or other reservation or site filtering criteria, which would allow you do make comparisons between cancellations of deluxe sites vs. economy sites, for instance.

Further Topics:

Report Dialog Controls