Enterprise Report - Booked Reservations .ng
Enterprise Booked Reservations Report
Report Description: The Enterprise Booked 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 canceled reservations.
Date Range: Historical - 90 days in the past
Booked Reservations Section: provides an overview of revenue and occupancy for the defined dates for all properties in the region.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Property Code | Identifies the hotel code | Not Applicable | Not Applicable |
Property Name | Identifies the name of the hotel | Not Applicable | Not Applicable |
Booking Date | Date of the booking (ex - March 25, 2024) | Not Applicable | Not Applicable |
Booked By | The user ID, user name or system that made the reservation | Not Applicable | Not Applicable |
Booking Time | Time of the booking (ex - 05:39:49 AM) | Not Applicable | Not Applicable |
Confirmation Number | Reservation confirmation number | Not Applicable | Not Applicable |
External Confirmation Number | Information on reservations made through external booking channels other than Online Travel Agencies (OTAs); important for tracking and analyzing reservation sources | Not Applicable | Not Applicable |
PO Number | Purchase order number | Not Applicable | Not Applicable |
Guest Name | Name of the primary guest associated with the reservation | Not Applicable | Not Applicable |
Company Name | Name of the company the guest is affiliated with | 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 | Not Applicable |
Room Type | Room type associated with the reservation | Not Applicable | Not Applicable |
Rate Code | Rate plan code on the reservation | Not Applicable | Not Applicable |
Source | The booking source or channel through which reservations are made (e.g., phone, online, direct bookings). | Not Applicable | Not Applicable |
Total Room Rate | Total room rate amount on the reservation based on consumed nights (example: 2-nights consumed, night 1 posted $135 and night two posted $148 the report would display $283) | NO | =sum(consumed room rate) |
ADR | Average daily rate for all occupied rooms | NO | ADR = (revenue / rooms sold) |
Current Booking Status | Current status of the booking (Canceled, Arrival, In House, etc) | 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 |
Average Room Rate | The average price paid for a room over a specific period of time | Not Applicable | =sum (Total Room Revenue / Number of Rooms Sold) |
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 |
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) |
Local First Name | Guest first name in local language | Not Applicable | Not Applicable |
Local Last Name | Guest last name in local language | 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 |
Currency | Currency used at the local hotel level | 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
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.