Booked Reservations Report
Report Description: Provides a comprehensive overview of all reservations booked within a specific period. This report is a vital tool for on-property leadership and front office teams to monitor booking trends and manage upcoming arrivals. With the addition of the "Room Number" column, managers can now gain immediate visibility into which reservations have already been assigned a room. This surfaces actionable data at a glance, allowing teams to efficiently manage repeat guests, group travel, and extended stays without the need to drill into individual guest profiles.
Date Range: This report can render data for up to 365 days in the past.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Room Number |
Displays the assigned room number for roomed reservations; remains blank if unassigned |
Not Applicable |
Not Applicable |
|
Booking Time |
The specific time the reservation was created |
Not Applicable |
Not Applicable |
|
Confirmation Number |
The unique PMS identifier for the reservation |
Not Applicable |
Not Applicable |
|
Promotion Name |
Displays the name of any active promotion applied to the booking |
Not Applicable |
Not Applicable |
|
External Confirmation Number |
The confirmation number from an external source (e.g., OTA or GDS) |
Not Applicable |
Not Applicable |
|
PO Number |
Purchase Order number associated with the booking, if applicable |
Not Applicable |
Not Applicable |
|
Guest Name |
The primary name on the reservation |
Not Applicable |
Not Applicable |
|
Company Name |
The name of the company or account associated with the booking |
Not Applicable |
Not Applicable |
|
Arrival Date |
The scheduled date of arrival |
Not Applicable |
Not Applicable |
|
Departure Date |
The scheduled date of departure |
Not Applicable |
Not Applicable |
|
Nights |
Total number of nights for the stay |
Not Applicable |
Not Applicable |
|
Adults |
Number of adults included in the reservation |
Not Applicable |
Not Applicable |
|
Children |
Number of children included in the reservation |
Not Applicable |
Not Applicable |
|
Room Type |
The specific category of room booked (e.g., KGRN, QBRM) |
Not Applicable |
Not Applicable |
|
Rate Plan |
The code for the pricing structure applied to the stay |
Not Applicable |
Not Applicable |
|
Market Segment |
The business segment the booking belongs to (e.g., Corporate, Leisure) |
Not Applicable |
Not Applicable |
|
Local Market Segment |
A property-specific sub-category of the market segment |
Not Applicable |
Not Applicable |
|
Source |
The channel through which the reservation was made (e.g., Phone, Booking) |
Not Applicable |
Not Applicable |
|
Total Room Rate |
The total revenue for the room portion of the stay |
YES |
=sum(total room rate) |
|
ADR |
Average Daily Rate for the reservation |
Not Applicable |
=sum(room revenue) / (nights) |
|
Current Booking Status |
The status of the reservation (e.g., Checked Out, Cancelled, Reserved) |
Not Applicable |
Not Applicable |
|
Cancellation Date |
The date the reservation was cancelled, if applicable |
Not Applicable |
Not Applicable |
|
Cancellation Time |
The time the reservation was cancelled, if applicable |
Not Applicable |
Not Applicable |
|
Booked By |
The username of the person or system that created the booking |
Not Applicable |
Not Applicable |
|
Booking Remarks |
Notes entered at the time of booking |
Not Applicable |
Not Applicable |
|
Stay Remarks |
Notes specific to the guest's stay requirements |
Not Applicable |
Not Applicable |
|
Guarantee Method |
The method used to secure the reservation (e.g., Property, Credit Card) |
Not Applicable |
Not Applicable |
Misc Report Information:
Available Features:
-
Export: Ability to download and save the report for planning meetings or shift handoffs.
-
Filter: Filter by booking dates, arrival dates, or specific booking statuses.
-
Highlight: Use conditional formatting to identify VIP guests or specific guarantee methods.
-
Grouping: Ability to view data grouped by: Market Segment, Source, Room Type, or Booked By.
Available Configuration:
-
User Preferences: Allows users to customize their view. It is recommended to position the Room Number column immediately after Room Type for best visibility.
-
Property Preferences: Allows the property to standardize the column order for all users.
Baseline Configuration:
Property Preferences Settings:
-
Following columns to be disabled for initial deployment: None.