The Reservations Report provides a comprehensive overview of all property reservations within a specific date range, enabling property staff to identify trends and improve their reservation process to improve overall guest experience on various reservation statuses including reservations, arrivals, in-house guests, checked-out guests, no shows, and cancelled reservations.
Date Range: This report can render the data for up to 94 days
The report includes the following columns:
|
Column Name |
Description |
|
Confirmation Number |
Unique identifier for the reservation confirmation |
|
Group Number |
Number associated with the group reservation |
|
Group Code |
Code representing the group reservation |
|
External Confirmation Number |
Information on reservations made through external booking channels other than Online Travel Agencies (OTAs); important for tracking and analysing reservation sources |
|
PO Number |
Purchase order number |
|
OTA Booking Number |
Information on reservations made through online travel agencies (OTAs); important for tracking and analyzing reservation sources |
|
Package |
Information on packages or special deals included in the reservation |
|
Status |
Current status of the reservation (e.g. confirmed, cancelled) |
|
Guest Name |
Name of guest who made the reservation |
|
Loyalty Tier |
Loyalty account status of the guest who made the reservation and any specific requirements or assistance they may need during their stay |
|
Guest Tier |
Tier status of the guest |
|
Requires Assistance |
Indicator if guest requires assistance |
|
Room Type |
Room type associated with the reservation |
|
Room Number |
Room number associated with the reservation |
|
Rate Plan |
Rate plan associated with the reservation; important for resource allocation and revenue management |
|
Source |
Information on the source of the reservation (e.g. direct booking, OTA) |
|
Complimentary |
Lists any complimentary services or amenities included in the reservation |
|
Market Segment |
Market segment of the guest |
|
Local Market Segment |
Local market segment associated with the reservation |
|
Company Name |
Name of the company the guest is affiliated with; important for analyzing and targeting specific demographics and groups |
|
Booking Date |
Date of the booking |
|
Booking Time |
Time when the reservation was made |
|
Cancellation Date |
Date when the reservation was cancelled |
|
Cancellation Time |
Time when the reservation was cancelled |
|
Arrival Date |
Date the guest is scheduled to arrive |
|
Arrival Time |
Time the guest is expected to arrive |
|
Departure Date |
Date the guest is scheduled to depart |
|
Departure Time |
Time the guest is expected to depart |
|
Nights |
Number of nights in the reservation |
|
Adults |
Number of adult guests associated with the reservation |
|
Children |
Number of child guests associated with the reservation |
|
Guarantee Type |
Guarantee type associated with the reservation |
|
Total Charges |
Charges applied to the reservation |
|
Total Payments |
Payments made on the reservation |
|
Balance |
Remaining balance due on the reservation |
|
Booking Remarks |
Remarks added to the reservation at the time of booking |
|
Stay Remarks |
Remarks added to the reservation during the guest's stay |
|
Housekeeping Remarks |
Remarks added to the reservation by or for Housekeeping |
|
Other Remarks |
All other remarks added to the reservation |
|
Digital Key |
Information about any digital key associated with the reservation |
|
Digital Check In |
Information associated with digital check in on the reservation |
|
Digital Check Out |
Information associated with digital check out on the reservation |
|
Virtual CC |
Virtual credit card information |