Room Rate

The Room Rate report allows users to view a list of all in-house guests and the current rate for each reservation. This is useful when user needs to determine whether the standard rate created for the rate plan is different than the rate currently on the reservation. This is known as variance. As a property manager, user can use this report to determine the accuracy of the rate before posting room and tax for the night. If a package rate plan is associated with the reservation, it appears on the report with a palm tree icon.

Perform the following steps to generate the report:

Navigate to Reports All Reports Room Rate (under Revenue/Forecasting).

Graphical user interface, text, application

Description automatically generated

Select a date range field from the calendar to generate dates for the report.

Choose which sort options to include in the report:

Field

Description

Sort by Date

Sorts the report alphabetically by the date entered.

Sort by Guest Name

Sorts the report alphabetically by guest last name.

Sort by Room Rack Number

Sorts the report alphanumerically by room rack number.

Sorts by Group Name

Sorts the repot alphabetically by group name.

Sort by Rate Plan

Sorts the report alphabetically by rate plan.

Sort by Arrival Date

Sorts the report alphanumerically by arrival date.

Sort by Departure Date

Sorts the report alphanumerically by departure date.

Sort by Guest Type

Sorts the report alphabetically by guest type.

Choose which Reservation Status to include in the report:

Field

Description

Select All

Includes all account statuses.

In House

Guests who are checked in and on the property.

Departed

Guests who already departed.

Reservation

Guests who have reservations on a future date and have not checked in.

Cancelled

Guests who abandoned their reservations, including walk-in and no-show reservations.

Click Generate. The report with the selected data appears.

Click Print to send a copy of the report to the printer.

Sample Report

Table

Description automatically generated

Report Parameters

This report displays the following parameters:

Field

Description

Date

The date of booking.

Room #

The room number that the guest is staying in, if assigned.

Room Type

The type of room that the guest has reserved.

Guest Name

The name of the main guest of each reservation.

Conf #

The confirmation number on the reservation.

Arrival Date

The arrival date for the reservation.

Departure Date

The departure date for the reservation.

Nights

The number of nights that the guest is staying for the reservation.

Adults

The number of adult guests for each reservation.

Children

The number of under-aged guests for each reservation.

Res Status

The reservation status that indicates whether the reservation is still in house, due to depart, or already departed.

Rate Plan

The rate plan associated with the reservation. If multiple rate plans are associated with the reservation, the rate plan currently in effect appears on the report.

Rate

The rate being charged for each reservation.

Overridden

If the rate plan was overridden, a Y (yes) displays. Otherwise, N (no) appears.

Override Comment

The comment entered when the rate was overridden.

Group

The group name associated with the reservation if one applies.

Company

The company name associated with the reservation if one applies.

Source

The source associated with the reservation.

Segment

The market segment associated with the reservation.

Guest Type

The guest type associated with the reservation.