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).
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
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. |