Revised Date:
Booked Reservations Report
Report Description: The Booked Reservations Report provides a comprehensive overview of all reservations within a specific date range, enabling property staff to identify trends and improve their reservation process to improve overall guest experience.
Date Range: This report can render the data for up to 94 days in the past or future
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
First Name |
The individual given name of the guest who booked the stay. |
Not Applicable |
Not Applicable |
|
Last Name |
The family name or surname of the guest who booked the stay. |
Not Applicable |
Not Applicable |
|
Contact Role |
The designated role of the main contact person for the reservation. |
Not Applicable |
Not Applicable |
|
Market Segment Code |
A short system code representing the primary classification of the business source. |
Not Applicable |
Not Applicable |
|
Local Market Segment Code |
An internal, location-specific system code for more detailed localised tracking. |
Not Applicable |
Not Applicable |
|
Total Revenue |
The total gross monetary amount generated by the entire reservation. |
Not Applicable |
Not Applicable |
|
Housekeeping Remarks |
Specific instructions or notes left for the cleaning staff regarding the room. |
Not Applicable |
Not Applicable |
|
Housekeeping Requests |
Special items or services requested by the guest from housekeeping, like extra towels. |
Not Applicable |
Not Applicable |
|
Linked Reservations |
Reference numbers tying this booking to other related reservations in the system. |
Not Applicable |
Not Applicable |
|
Sub Source Code |
A secondary, detailed tracking code specifying how the booking was captured. |
Not Applicable |
Not Applicable |
|
Sub Source Name |
The full descriptive text name of the secondary booking channel. |
Not Applicable |
Not Applicable |
|
Cancellation Policy |
The specific rules and deadlines governing financial penalties if the booking is cancelled. |
Not Applicable |
Not Applicable |
|
Booking Time |
Time the reservation was booked |
Not Applicable |
Not Applicable |
|
Confirmation Number |
Unique identifier for the reservation confirmation |
Not Applicable |
Not Applicable |
|
Promotion Name |
The specific discount or marketing campaign applied to the reservation rate. |
|
|
|
External Confirmation Number |
The unique confirmation ID generated by an external booking platform or global distribution system. |
Not Applicable |
Not Applicable |
|
PO Number |
Purchase order number |
Not Applicable |
Not Applicable |
|
Guest Name |
Name of the primary guest who made the reservation |
Not Applicable |
Not Applicable |
|
Company Name |
Name of the associated company |
Not Applicable |
Not Applicable |
|
Arrival Date |
Date the guest is scheduled to arrive |
Not Applicable |
Not Applicable |
|
Departure Date |
Date the guest is scheduled to depart |
Not Applicable |
Not Applicable |
|
Nights |
Number of nights in the reservation |
Not Applicable |
=sum(nights) |
|
Adults |
Number of adult guests associated with the reservation |
Not Applicable |
=sum(adults) |
|
Children |
Number of child guests associated with the reservation |
Not Applicable |
=sum(children) |
|
Room Type |
The classification code for the specific style or layout of the room booked. |
Not Applicable |
Not Applicable |
|
Room Number |
The specific physical room assigned to the guest for their stay. |
Not Applicable |
Not Applicable |
|
Rate Plan |
Rate plan associated with the reservation; important for resource allocation and revenue management |
Not Applicable |
Not Applicable |
|
Market Segment |
Market segment of the guest |
Not Applicable |
Not Applicable |
|
Local Market Segment |
Local market segment associated with the reservation |
Not Applicable |
Not Applicable |
|
Source |
Information on the source of the reservation (e.g. direct booking, OTA) |
Not Applicable |
Not Applicable |
|
Total Room Rate |
The combined cost of the room charges alone, excluding extra fees or taxes. |
Not Applicable |
Not Applicable |
|
ADR |
The average revenue earned per occupied room for a single day of the stay. |
Not Applicable |
Not Applicable |
|
Current Booking Status |
The real-time operational state of the reservation, such as Arrival, In House, or Checked Out. |
Not Applicable |
Not Applicable |
|
Cancellation Date |
Date when the reservation was canceled |
Not Applicable |
Not Applicable |
|
Cancellation Time |
Time when the reservation was canceled |
Not Applicable |
Not Applicable |
|
Booked By |
The user ID, user name or system that made the reservation |
Not Applicable |
Not Applicable |
|
Local First Name |
The guest's first name translated or written in the property's local language format. |
Not Applicable |
Not Applicable |
|
Local Last Name |
The guest's last name translated or written in the property's local language format. |
Not Applicable |
Not Applicable |
|
Booking Remarks |
Remarks added to the reservation at the time of booking |
Not Applicable |
Not Applicable |
|
Stay Remarks |
Remarks added to the reservation during the guest's stay |
Not Applicable |
Not Applicable |
|
Guarantee Method |
The payment or authorization method used to secure and hold the reservation. |
Not Applicable |
Not Applicable |
|
Booking Date |
The calendar day the reservation was officially entered into the property management system. |
Not Applicable |
Not Applicable |
Misc Report Information:
Available Features:
-
Export: ability to download and save the file into an alternate format.
-
Filter: filter a range of data based on criteria defined by the user.
-
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
-
Group By: ability to group data All, Room Type, Source Rate Plan, Status, Company Name
-
Pie Chart: ability to view grouped data in a Pie Chart view.
Available Configuration:
-
User Preferences: allows the user to customize their report view by repositioning or removing columns.
-
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.