Unexpected Stay-Over Report

This report lists unexpected stay overs within the date range specified. Unexpected stay overs are guests that extended their stay on their original departure date. The report includes room, guest name, account number, VIP level, status, same day reservation indicator, old departure date, new departure date, room type, rate code, number of guests, stay over number of nights, and stay over average rate. The report then gives a summary for total number of guests, total stay over nights, total stay over average rate, total reservations for all guest accounts represented on the report.

You can filter the report by specifying the property, room type, and rate plan. Room type and rate plan are multi select. You can optionally include guest statuses of checked out and in-house. You can sort the report by rate plan or room type.

The following are some of the important points to be noted:

  • This report is dependent on the audit trail for the reservation stay table being configured with the tracking taking place on an update to the departure date field.
  • The report is looking for updates to the departure date where the old departure date value is less than the new departure date value.
  • If multiple values are entered on multiple fields on the report parameter screen and at least one value is in conflict with another value, no records will be returned.
  • When a guest account has a scheduled room move during the stay over dates, the report displays the new room. When the report date equals the hotel date and a guest account has a scheduled room move for that day, the report must verify the "Reservation Stay Date Room" verses the "Current Room", when they do not match the report will use the current room.
  • The report displays a value for the Stay-Over Nights column that represents only the number of extended nights. The column does not represent a guest stay records total nights.
  • The report displays a value for the Stay-Over Average Rate column that represents only the rates configured on the extended nights. If there are difference rates configured over the extended nights, the report will calculate the average rate for each record and show that value under the Stay-Over Average Rate column.
  • This report applies the VVIP functionality.
  • The report applies Incognito enhancement. See Incognito Functionality
Related topics