Breadcrumbs

Reservations Report .ng

Reservations Report Overview

Parent Hub: 🛎️ Front Desk & Guest Services

Category: 🧳 Arrivals & Departures

Target Roles: Front Office Managers, Reservations Managers, Revenue Managers, General Managers, Guest Services Supervisors, Hotel Controllers

Key Value: Comprehensive multi-section master ledger tracking all reservation activity across the full lifecycle—from master bookings, upcoming arrivals, and active in-house stays to completed check-outs, no-shows, and cancellations.

Executive Summary

The Reservations Report is the master operational ledger and reservation audit document within the 🧳 Arrivals & Departures category of the 🛎️ Front Desk & Guest Services hub. Designed to provide 360-degree visibility over all guest booking records, it categorizes property reservations into 6 distinct operational sections: Reservations (Master List), Arrivals, In House, Checked Out, No Show, and Cancelled.

  • By mapping market classifications (Market Segment Code, Local Market Segment Code) and booking identifiers (Confirmation Number, Group Number, Group Code, External Confirmation Number, PO Number, OTA Booking Number) to guest profile data, stay windows, room assignments, rate codes, and monetary metrics, this report enables front desk teams, reservations agents, and revenue managers to audit daily room inventory, verify check-in/check-out statuses, reconcile guest ledgers, and analyze cancellation/no-show trends.

Key Capabilities

  • Six-Section Lifecycle Organization: Categorizes all property reservations into Reservations (Master), Arrivals, In House, Checked Out, No Show, and Cancelled sections for targeted operational auditing.

  • Complete Booking Identification: Captures internal confirmation numbers (Confirmation Number), group master links (Group Number, Group Code), external channel reference IDs (External Confirmation Number), purchase orders (PO Number), and OTA booking identifiers (OTA Booking Number).

  • Hierarchical Market & Rate Mapping: Tracks market segment codes (Market Segment Code, Local Market Segment Code) and rate plans alongside room category allocations and assigned physical room numbers.

  • Guest Profile & Loyalty Tracking: Displays guest name details, accompanying guest names, loyalty membership standings, and corporate account affiliations.

  • Financial & Stay Balance Verification: Itemizes total stay nights, daily base rates, total room revenue, collected deposits, and net outstanding folio balances across every reservation status.

Report Views & Functional Breakdown

The Reservations Report presents master property reservation data in a structured matrix across 6 defined sections:

┌────────────────────────────────────────────────────────────────────────┐
│                        RESERVATIONS REPORT                             │
├────────────────────────────────────────────────────────────────────────┤
│                       6 Defined Report Sections                        │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Master Reservations   │ 2. Arrivals Section      │ 3. In House      │
│    (Full Property List)  │    (Expected Today)      │    Section       │
├──────────────────────────┼──────────────────────────┼──────────────────┤
│ 4. Checked Out Section   │ 5. No Show Section       │ 6. Cancelled     │
│    (Completed Stays)     │    (Unfulfilled Arrivals)│    Section       │
└──────────────────────────┴──────────────────────────┴──────────────────┘

⚠️ IMPORTANT: Screenshots in this document are provided as representative examples. Each section contains over 60 columns of data; actual views and available fields may vary based on your screen size and configuration.

1. Master Reservations Section

Contains the master consolidated ledger of all recorded reservations across all statuses within the report date window.

  • Primary Use: Comprehensive reservation auditing, cross-status verification, and master property booking ledger reviews.

  • Key Metrics: Confirmation Number, Group Code, Guest Name, Status, Room Number, Total Revenue, Balance.

Reservations_Reservations.png
Reservation Section (Columns 1 - 17)
Reservations_Reservations_2.png
Reservations Section (Columns 33 - 48)
2. Arrivals Section

Isolates all reservations scheduled to arrive and check in on the selected date.

  • Primary Use: Managing the daily check-in manifest, verifying pre-assigned room numbers, checking advance deposit statuses, and preparing guest registration cards.

  • Key Metrics: Confirmation Number, Guest Name, Room Type, Room Number, Rate Plan, Arrival Date, Departure Date.

Reservations_Arrivals.png
Arrivals Section (Columns 1 - 21)
Image 10-11-26 at 10.34 AM.png
Arrivals Section (Columns 32 - 53)
3. In House Section

Isolates registered guests currently occupying physical guest rooms.

  • Primary Use: Managing active guest stays, auditing occupied room numbers, verifying mid-stay folio balances, and coordinating housekeeping service priorities.

  • Key Metrics: Confirmation Number, Room Number, Guest Name, Rate Plan, Nights, Total Revenue, Balance.

Image 10-11-26 at 10.53 AM.png
In House Section
4. Checked Out Section

Itemizes completed stays where the guest has checked out during the reporting window.

  • Primary Use: Post-departure ledger auditing, zero-balance verification, corporate billing reconciliation, and room turnover tracking.

  • Key Metrics: Confirmation Number, Room Number, Guest Name, Departure Date, Total Revenue, Balance ($0.00).

Image 10-11-26 at 11.14 AM.png
Checked Out Section
5. No Show Section

Tracks expected arrivals that failed to arrive or check in on their scheduled arrival date.

  • Primary Use: Night audit no-show billing verification, penalty charge reconciliation, releasing unassigned rooms, and inventory release.

  • Key Metrics: Confirmation Number, Guest Name, Company, Arrival Date, Penalty Amount, Payment Status.

Image 10-11-26 at 11.32 AM.png
No Show Section
6. Cancelled Section

Logs all reservations cancelled prior to check-in across the report timeframe.

  • Primary Use: Attrition analysis, evaluating cancellation reasons and lead times, tracking fee waivers, and monitoring inventory release back to availability.

  • Key Metrics: Confirmation Number, Guest Name, Rate Plan, Cancellation Date, Lost Revenue, Cancellation Penalty.

Image 10-11-26 at 11.44 AM.png
Cancelled Section

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary representing every column available in this report:

💡 Ledger Note: Total Revenue represents net base room revenue earned or quoted. Balance reflects the current live outstanding guest folio balance for the reservation.

Column Name

Section Applicability

Description

Data Source / System Mapping

Includes Taxes & Fees?

Market Segment Code

All 6 Sections

Master corporate market segment code (e.g., P, Y, D, V, G, W, K, C, L, M).

PMS > Market Segment Code

N/A

Local Market Segment Code

All 6 Sections

Property-specific local market segment code (e.g., M).

PMS > Local Market Code

N/A

Confirmation Number

All 6 Sections

Primary unique alphanumeric reservation identifier.

Reservation System > Confirmation Number

N/A

Group Number

All 6 Sections

Master group contract or block identification number.

Group Management > Group ID

N/A

Group Code

All 6 Sections

Alphanumeric code assigned to the group block (e.g., DFW).

Group Management > Group Code

N/A

External Confirmation Number

All 6 Sections

Secondary confirmation reference from CRS or third-party distribution channels.

CRS / Channel Manager > External ID

N/A

External Cancellation Number

Sec 6 (Cancelled)

Reference code issued by external channel upon cancellation.

CRS / Channel Manager > Cancellation ID

N/A

PO Number

All 6 Sections

Purchase order number supplied for corporate direct billing.

Billing Setup > PO Number

N/A

OTA Booking Number

All 6 Sections

Third-party booking reference ID provided by online travel agencies.

OTA Interface > Booking Reference

N/A

Package

All 6 Sections

Code of package inclusions attached to the rate plan.

Rate Engine > Package Setup

N/A

Package Name

All 6 Sections

Full descriptive title of the attached amenity or dining package.

Rate Engine > Package Title

N/A

Package Element

All 6 Sections

Specific component items included in the package.

Rate Engine > Package Item

N/A

Status

Sec 1 (Reservations)

Overall operational reservation status (e.g., In House, Arrival, Checked Out, No Show, Cancelled).

Reservation System > Status Flag

N/A

Guest Name

All 6 Sections

Combined full name of the primary registered guest.

Guest Profile > Full Name

N/A

Contact Role

All 6 Sections

Role or relationship title assigned to the guest contact profile.

Guest Profile > Role Title

N/A

Additional Guests

All 6 Sections

Names of accompanying secondary guests in the room.

Guest Profile > Accompanying Guests

N/A

Loyalty Tier

All 6 Sections

Guest loyalty membership standing (e.g., DIAMOND ELITE, PLATINUM ELITE, CLUB).

Loyalty System > Membership Tier

N/A

Guest Tier

All 6 Sections

VIP property tier classification.

Guest Profile > VIP Tier

N/A

Requires Assistance

All 6 Sections

Disability or special assistance flag for ADA room allocation.

Guest Profile > Accessibility Flag

N/A

Room Type

All 6 Sections

Code representing the room category allocated.

PMS > Room Type Code

N/A

Room Number

Sec 1–4

Assigned physical guest room number (Blank for unassigned/No Show/Cancelled).

PMS > Assigned Room Number

N/A

Pending Departure

Sec 3 (In House)

Operational flag indicating late check-out or pending departure status.

Front Office > Departure Flag

N/A

Rate Plan

All 6 Sections

Active rate plan code attached to the reservation.

Reservation System > Active Rate Code

N/A

Source

All 6 Sections

Booking channel or origin interface (e.g., PHONE, WEB, GDS).

CRS / PMS > Reservation Source

N/A

Source Code

All 6 Sections

Alphanumeric code representing the booking source channel.

CRS / PMS > Source Code

N/A

Sub Source Code

Sec 2 & 3 (Arrivals, In House)

Secondary channel distribution code.

CRS > Sub-Source Code

N/A

Sub Source Name

Sec 2 & 3 (Arrivals, In House)

Secondary channel distribution name.

CRS > Sub-Source Title

N/A

Travel Agent Name

All 6 Sections

Name of travel agency profile linked to the booking.

Reservation System > Travel Agency

N/A

Travel Agent Number

All 6 Sections

IATA or unique travel agency identifier.

Travel Agency Profile > IATA Code

N/A

Complimentary

All 6 Sections

Flag indicating if the reservation is a zero-rate complimentary stay.

Rate Engine > Comp Flag

N/A

Market Segment

All 6 Sections

Full name of master corporate market segment.

PMS > Market Segment Title

N/A

Local Market Segment

All 6 Sections

Full name of property-specific local market segment.

PMS > Local Market Title

N/A

Company Name

All 6 Sections

Corporate company profile name linked to the stay.

Reservation System > Company Account

N/A

Booking Date

All 6 Sections

Calendar date on which the reservation was created.

PMS Audit Trail > Creation Date

N/A

Booking Time

All 6 Sections

Exact timestamp recording when the reservation was created.

PMS Audit Trail > Creation Time

N/A

Cancellation Date

All 6 Sections

Calendar date on which cancellation was processed (if applicable).

PMS Audit Trail > Cancellation Date

N/A

Cancellation Time

All 6 Sections

Exact timestamp recording when cancellation occurred.

PMS Audit Trail > Cancellation Time

N/A

Cancellation Deadline

All 6 Sections

Policy deadline timestamp prior to which penalty-free cancellation is permitted.

Rate Engine > Cancellation Deadline

N/A

Late Cancel

Sec 6 (Cancelled)

Indicator flag identifying whether the cancellation occurred past deadline.

PMS Audit Trail > Late Cancel Flag

N/A

Arrival Date

All 6 Sections

Scheduled or actual check-in date.

Reservation System > Check-In Date

N/A

Arrival Time

All 6 Sections

Actual or estimated arrival timestamp.

Reservation System > Check-In Time

N/A

Departure Date

All 6 Sections

Scheduled or actual check-out date.

Reservation System > Check-Out Date

N/A

Departure time

All 6 Sections

Actual or estimated departure timestamp.

Reservation System > Check-Out Time

N/A

Nights

All 6 Sections

Total physical room nights spanned by the stay.

Reservation System > Total Nights

N/A

Adults

All 6 Sections

Count of registered adult occupants.

Reservation System > Adult Count

N/A

Children

All 6 Sections

Count of registered child occupants.

Reservation System > Child Count

N/A

Guarantee Type

All 6 Sections

Payment guarantee arrangement (e.g., CREDIT CARD, COMPANY GUARANTEE).

Billing Setup > Guarantee Type

N/A

Tax Exempt

Sec 2 & 3 (Arrivals, In House)

Indicator flag denoting tax exemption status.

PMS Billing > Tax Exempt Flag

N/A

Tax Exempt Code

Sec 2 & 3 (Arrivals, In House)

Tax exemption certificate or category code.

PMS Billing > Tax Exempt Code

N/A

Room Rate

Sec 3 (In House)

Live posted daily base room rate for the stay.

Folio Posting > Live Room Rate

❌ No

Room Taxes

Sec 3 (In House)

Live posted room tax for the stay date.

Folio Posting > Live Room Tax

🟢 Yes

Avg. Room Rate

Sec 2 (Arrivals)

Quoted daily average base room rate for arriving stay.

Rate Engine > Avg Daily Rate

❌ No

Avg. Room Taxes

Sec 2 (Arrivals)

Estimated daily average room tax for arriving stay.

Rate Engine > Avg Daily Tax

🟢 Yes

Average Room Rate

All 6 Sections

Average Daily Rate across total stay duration ($\text{Total Revenue} \div \text{Nights}$).

Revenue / Nights

❌ No

Total Charges

All 6 Sections

Cumulative gross charges posted to the folio.

Folio Ledger > Gross Charges

🟢 Yes

Total Room Revenue

All 6 Sections

Gross base room revenue generated by the booking.

SUM(Base Room Revenue)

❌ No

Total Taxes

All 6 Sections

Total room and incidental taxes billed to the folio.

SUM(Billed Folio Taxes)

🟢 Yes

Total Payments

All 6 Sections

Total payments and deposit credits collected on the folio.

Guest Folio > Total Payments

🟢 Yes

Balance

All 6 Sections

Net live outstanding folio balance remaining.

Guest Folio > Outstanding Balance

🟢 Yes

Booking Remarks

All 6 Sections

Remarks recorded during reservation creation.

Reservation Notes > Booking Remarks

N/A

Stay Remarks

All 6 Sections

Remarks specific to stay handling or room requests.

Reservation Notes > Stay Remarks

N/A

Housekeeping Remarks

All 6 Sections

Instructions for housekeeping room preparation.

PMS Housekeeping > Room Remarks

N/A

Other Remarks

All 6 Sections

General operational or administrative notes.

Reservation Notes > Other Remarks

N/A

Digital Key

All 6 Sections

Status flag for mobile digital key issuance.

Keyless Entry > Digital Key Status

N/A

Digital Check In

Sec 1, 3, 4 (Reservations, In House, Checked Out)

Status flag for mobile app digital check-in.

Mobile App > Check-In Flag

N/A

Digital Check Out

Sec 1, 3, 4 (Reservations, In House, Checked Out)

Status flag for mobile app digital check-out.

Mobile App > Check-Out Flag

N/A

Virtual CC

All 6 Sections

Indicator flag noting payment by Virtual Credit Card.

PMS Billing > VCC Flag

N/A

Local First Name

All 6 Sections

First name in local character set/language script.

Guest Profile > Local First Name

N/A

Local Last Name

All 6 Sections

Last name in local character set/language script.

Guest Profile > Local Last Name

N/A

Booked By

All 6 Sections

Name or user login ID of employee/agent who created the reservation.

Security Audit Trail > User Name

N/A

Check Out Reason

Sec 4 (Checked Out)

Recorded reason code selected upon guest check-out.

Front Office > Check-Out Reason

N/A

Stay Requests

All 6 Sections

Guest amenity, floor, or room feature requests.

Guest Preferences > Special Requests

N/A

Linked Reservations

All 6 Sections

Confirmation numbers of linked party/family stays.

Reservation System > Linked IDs

N/A

Customization & Platform Features

User & Property Preferences

  • Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.

  • Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks:

    • Section 1: Reservations

      • Reservation Identification & Creation Audit (Cols 1–8): Confirmation Number | External Confirmation Number | OTA Booking Number | PO Number | Group Number | Group Code | Status | Booked By

      • Guest Profile & Contact Identification (Cols 9–17): Guest Name | Local First Name | Local Last Name | Additional Guests | Contact Role | Loyalty Tier | Guest Tier | Requires Assistance | Company Name

      • Stay Itinerary & Timestamps (Cols 18–26): Booking Date | Booking Time | Arrival Date | Arrival Time | Departure Date | Departure time | Nights | Adults | Children

      • Room Assignment & Package Details (Cols 27–31): Room Number | Room Type | Package | Package Name | Package Element

      • Rate Plan & Market Mapping (Cols 32–37): Rate Plan | Average Room Rate | Market Segment Code | Market Segment | Local Market Segment Code | Local Market Segment

      • Booking Source & Channel Origin (Cols 38–43): Source | Source Code | Travel Agent Name | Travel Agent Number | Complimentary | Guarantee Type

      • Financial Ledger & Tax Breakdown (Cols 44–49): Total Room Revenue | Total Charges | Total Taxes | Total Payments | Balance | Virtual CC

      • Cancellation Audit & Policy Deadlines (Cols 50–52): Cancellation Date | Cancellation Time | Cancellation Deadline

      • Digital Experience & Guest Amenities (Cols 53–56): Digital Key | Digital Check In | Digital Check Out | Linked Reservations

      • Operational Remarks & Guest Requests (Cols 57–61): Booking Remarks | Stay Remarks | Housekeeping Remarks | Other Remarks | Stay Requests

    • Section 2: Arrivals

      • Reservation Identification & Creation Audit (Cols 1–7): Confirmation Number | External Confirmation Number | OTA Booking Number | PO Number | Group Number | Group Code | Booked By

      • Guest Profile & Contact Identification (Cols 8–16): Guest Name | Local First Name | Local Last Name | Additional Guests | Contact Role | Loyalty Tier | Guest Tier | Requires Assistance | Company Name

      • Stay Itinerary & Timestamps (Cols 17–25): Booking Date | Booking Time | Arrival Date | Arrival Time | Departure Date | Departure time | Nights | Adults | Children

      • Room Assignment & Package Details (Cols 26–30): Room Number | Room Type | Package | Package Name | Package Element

      • Rate Plan & Market Mapping (Cols 31–36): Rate Plan | Average Room Rate | Market Segment Code | Market Segment | Local Market Segment Code | Local Market Segment

      • Tax Exemption Audit (Cols 37–38): Tax Exempt | Tax Exempt Code (Arrivals Native)

      • Booking Source & Channel Origin (Cols 39–44): Source | Source Code | Sub Source Code | Sub Source Name | Travel Agent Name | Travel Agent Number

      • Rate Inclusions & Guarantee (Cols 45–47): Avg. Room Rate | Avg. Room Taxes | Guarantee Type

      • Financial Ledger & Tax Breakdown (Cols 48–53): Total Room Revenue | Total Charges | Total Taxes | Total Payments | Balance | Virtual CC

      • Cancellation Policy & Digital Experience (Cols 54–59): Cancellation Date | Cancellation Time | Cancellation Deadline | Digital Key | Linked Reservations | Complimentary

      • Operational Remarks & Guest Requests (Cols 60–64): Booking Remarks | Stay Remarks | Housekeeping Remarks | Other Remarks | Stay Requests

    • Section 3: In House

      • Reservation Identification & Creation Audit (Cols 1–8): Confirmation Number | External Confirmation Number | OTA Booking Number | PO Number | Group Number | Group Code | Pending Departure | Booked By

      • Guest Profile & Contact Identification (Cols 9–17): Guest Name | Local First Name | Local Last Name | Additional Guests | Contact Role | Loyalty Tier | Guest Tier | Requires Assistance | Company Name

      • Stay Itinerary & Timestamps (Cols 18–26): Booking Date | Booking Time | Arrival Date | Arrival Time | Departure Date | Departure time | Nights | Adults | Children

      • Room Assignment & Housekeeping (Cols 27–31): Room Number | Room Type | Package | Package Name | Package Element

      • Rate Plan & Market Mapping (Cols 32–37): Rate Plan | Average Room Rate | Market Segment Code | Market Segment | Local Market Segment Code | Local Market Segment

      • Tax Exemption Audit (Cols 38–39): Tax Exempt | Tax Exempt Code (In-House Native)

      • Booking Source & Channel Origin (Cols 40–45): Source | Source Code | Sub Source Code | Sub Source Name | Travel Agent Name | Travel Agent Number

      • Daily In-House Posting Audit (Cols 46–48): Room Rate | Room Taxes | Guarantee Type

      • Financial Ledger & Folio Breakdown (Cols 49–54): Total Room Revenue | Total Charges | Total Taxes | Total Payments | Balance | Virtual CC

      • Cancellation Audit & Policy (Cols 55–58): Cancellation Date | Cancellation Time | Cancellation Deadline | Complimentary

      • Digital Experience & App Status (Cols 59–62): Digital Key | Digital Check In | Digital Check Out | Linked Reservations

      • Operational Remarks & Guest Requests (Cols 63–67): Booking Remarks | Stay Remarks | Housekeeping Remarks | Other Remarks | Stay Requests

    • Section 4: Checked Out

      • Reservation Identification & Creation Audit (Cols 1–7): Confirmation Number | External Confirmation Number | OTA Booking Number | PO Number | Group Number | Group Code | Booked By

      • Guest Profile & Contact Identification (Cols 8–16): Guest Name | Local First Name | Local Last Name | Additional Guests | Contact Role | Loyalty Tier | Guest Tier | Requires Assistance | Company Name

      • Stay Itinerary & Timestamps (Cols 17–25): Booking Date | Booking Time | Arrival Date | Arrival Time | Departure Date | Departure time | Nights | Adults | Children

      • Room Assignment & Checkout Departure (Cols 26–31): Room Number | Room Type | Check Out Reason | Package | Package Name | Package Element

      • Rate Plan & Market Mapping (Cols 32–37): Rate Plan | Average Room Rate | Market Segment Code | Market Segment | Local Market Segment Code | Local Market Segment

      • Booking Source & Channel Origin (Cols 38–43): Source | Source Code | Travel Agent Name | Travel Agent Number | Complimentary | Guarantee Type

      • Financial Ledger & Folio Settlement (Cols 44–49): Total Room Revenue | Total Charges | Total Taxes | Total Payments | Balance | Virtual CC

      • Cancellation Audit & Policy Deadlines (Cols 50–52): Cancellation Date | Cancellation Time | Cancellation Deadline

      • Digital Experience & Guest Amenities (Cols 53–56): Digital Key | Digital Check In | Digital Check Out | Linked Reservations

      • Operational Remarks & Guest Requests (Cols 57–61): Booking Remarks | Stay Remarks | Housekeeping Remarks | Other Remarks | Stay Requests

    • Section 5: No Show

      • Reservation Identification & Creation Audit (Cols 1–7): Confirmation Number | External Confirmation Number | OTA Booking Number | PO Number | Group Number | Group Code | Booked By

      • Guest Profile & Contact Identification (Cols 8–16): Guest Name | Local First Name | Local Last Name | Additional Guests | Contact Role | Loyalty Tier | Guest Tier | Requires Assistance | Company Name

      • Stay Itinerary & Timestamps (Cols 17–25): Booking Date | Booking Time | Arrival Date | Arrival Time | Departure Date | Departure time | Nights | Adults | Children

      • Rate Plan & Market Mapping (Cols 26–31): Rate Plan | Average Room Rate | Market Segment Code | Market Segment | Local Market Segment Code | Local Market Segment

      • Booking Source & Channel Origin (Cols 32–37): Source | Source Code | Travel Agent Name | Travel Agent Number | Complimentary | Guarantee Type

      • Financial Penalty Ledger & Charges (Cols 38–43): Total Room Revenue | Total Charges | Total Taxes | Total Payments | Balance | Virtual CC

      • Cancellation Audit & Penalty Deadlines (Cols 44–46): Cancellation Date | Cancellation Time | Cancellation Deadline

      • Package Details & Amenities (Cols 47–50): Package | Package Name | Package Element | Linked Reservations

      • Operational Remarks & Guest Requests (Cols 51–57): Booking Remarks | Stay Remarks | Housekeeping Remarks | Other Remarks | Stay Requests | Digital Key | Room Type

    • Section 6: Cancelled

      • Reservation Identification & Cancellation Audit (Cols 1–9): Confirmation Number | External Confirmation Number | External Cancellation Number | OTA Booking Number | PO Number | Group Number | Group Code | Late Cancel | Booked By

      • Guest Profile & Contact Identification (Cols 10–18): Guest Name | Local First Name | Local Last Name | Additional Guests | Contact Role | Loyalty Tier | Guest Tier | Requires Assistance | Company Name

      • Stay Itinerary & Timestamps (Cols 19–27): Booking Date | Booking Time | Arrival Date | Arrival Time | Departure Date | Departure time | Nights | Adults | Children

      • Cancellation Audit Timestamps & Policy (Cols 28–30): Cancellation Date | Cancellation Time | Cancellation Deadline

      • Rate Plan & Market Mapping (Cols 31–36): Rate Plan | Average Room Rate | Market Segment Code | Market Segment | Local Market Segment Code | Local Market Segment

      • Booking Source & Channel Origin (Cols 37–42): Source | Source Code | Travel Agent Name | Travel Agent Number | Complimentary | Guarantee Type

      • Financial Ledger & Penalty Assessment (Cols 43–48): Total Room Revenue | Total Charges | Total Taxes | Total Payments | Balance | Virtual CC

      • Package Details & Amenities (Cols 49–52): Package | Package Name | Package Element | Linked Reservations

      • Operational Remarks & Guest Requests (Cols 53–59): Booking Remarks | Stay Remarks | Housekeeping Remarks | Other Remarks | Stay Requests | Digital Key | Room Type

Report Toolbar & Quick Actions

Use the top-right toolbar icons on the report page to manage and export your data view:

Icon

Action / Feature

Description
Image 9-29-26 at 1.04 PM.png

Knowledge Article

Opens the knowledge base article to learn how to interpret this report.
Image 9-30-26 at 2.14 PM.png

 

Background Export

Allows users to download up to 365 days of data directly to their computer in CSV format.
Image 9-29-26 at 12.37 PM.png

Saved Views

Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.
Image 9-29-26 at 12.39 PM.png

Filter

Opens filter controls to isolate specific data within a column based on your selected criteria.
Image 9-29-26 at 12.40 PM.png

Highlight

Highlights column values in a designated color based on selected conditions.
Image 9-29-26 at 12.42 PM.png

Export

Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.
Image 9-29-26 at 12.43 PM.png

Configure

Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.
Image 9-29-26 at 12.44 PM.png

Additional Configuration

Provides advanced report configuration and display formatting options to customize data presentation.
Image 9-29-26 at 12.53 PM.png

Group By

Summarize and group report data dynamically in real time.
Interactive Visualizations & Grouping Controls

  • Group By & Pie Chart Visualization: The Reservations report features an interactive pie chart to help analyze reservation activity, stay volume, and financial balance distributions. Users can toggle or expand/collapse the Room Type, Source, Rate Plan, Status, or Company Name sections to analyze specific operational cohorts independently. By selecting a metric from the Select Base Column dropdown menu—such as Confirmation Number, Nights, Total Charges, Total Taxes, Total Payments, or Balance—the chart dynamically renders percentage share breakdowns accompanied by an interactive color-coded legend.

Image 10-11-26 at 11.46 AM.png
Group By & Pie Chart Visualization
Advanced Controls

  • Exporting & Master Ledger Audits: Download in Excel or PDF format to support morning front desk shift briefings, night audit reconciliations, and weekly revenue meetings.

  • Filtering: Filter data by specific Status = Arrival or Status = In House, isolate unassigned room bookings (Room Number = Blank), or filter for high outstanding balances (Balance > $0).

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight VIP loyalty tiers (Loyalty Tier = DIAMOND ELITE), unassigned arrivals, or non-zero departure balances.

Within 🛎️ Front Desk & Guest Services & 🧳 Arrivals & Departures:

  • Arrivals List – Detailed daily manifest of expected arriving guests, check-in statuses, and room assignments.

  • Departures Details – Comprehensive manifest tracking daily scheduled guest departures, folio numbers, and outstanding balances.

  • In House Guest List – Real-time roster of registered guests currently occupying physical hotel rooms.

  • Booked Reservations – Audit log tracking newly created and modified reservation entries.

  • Cancelled Reservation Report – Two-section audit report tracking individual and group cancellations, penalties, and release timestamps.

  • No Show and Late Cancel – Operational audit log tracking unfulfilled arrivals and penalty fee collection.

Cross-Pillar Deep Dives: