Breadcrumbs

Linked Reservations .ng

Linked Reservations Report Overview

Parent Hub: 🛎️ Front Desk & Guest Services

Category: 🏨 In-House & Occupancy

Target Roles: Front Office Managers, Front Desk Agents, Guest Services Supervisors, Reservations Agents, Hotel Controllers, Night Auditors

Key Value: Monitor associated multi-room group/family bookings, track parent-child reservation links, audit individual folio balances across linked reservations, verify operational stay statuses, and streamline check-in and billing workflows for linked party stays.

Executive Summary

The Linked Reservations Report is a specialized front office operational tracking and guest relationship document within the 🏨 In-House & Occupancy category of the 🛎️ Front Desk & Guest Services hub. Designed to deliver complete visibility over associated guest stays, it itemizes every reservation linked to a primary or parent booking reference.

  • By mapping primary linkage identifiers (Confirmation Number, Original Confirmation Number) to guest profile details (Guest Name, First Name, Last Name, Contact Role), stay timeframes (Check In Date, Check Out Date, Nights), and live financial and operational statuses (Reservation Balance, Reservation Status), this report enables front desk agents, guest services supervisors, and controllers to coordinate group arrivals, manage multi-room folio billing, verify party check-in readiness, and ensure seamless guest service delivery.

Key Capabilities

  • Multi-Room Party Traceability: Correlates individual room confirmation numbers (Confirmation Number) directly with parent or primary reservation linkage codes (Original Confirmation Number) to identify linked party bookings.

  • Guest Identity & Contact Mapping: Displays primary guest names (Guest Name, First Name, Last Name) and profile contact designations (Contact Role) for all associated stays.

  • Stay Timeframe Synchronization: Tracks check-in dates (Check In Date), check-out dates (Check Out Date), and stay durations (Nights) across linked rooms to ensure aligned stay dates.

  • Individual Folio Balance Auditing: Captures live net outstanding ledger balances (Reservation Balance) for each linked room to assist front desk staff during group or family check-outs.

  • Live Status Monitoring: Displays real-time operational reservation statuses (e.g., ARRIVAL, CHECKED OUT, CANCELLED) to distinguish active, incoming, or cancelled linked bookings.

Report Views & Functional Breakdown

The Linked Reservations Report presents associated reservation data in a unified single-table ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                   LINKED RESERVATIONS REPORT                           │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Reservation Linkage & │ 2. Stay Timeframe &      │ 3. Financial &   │
│    Guest Register        │    Duration Alignment    │    Status Trace  │
└──────────────────────────┴──────────────────────────┴──────────────────┘
1. Reservation Linkage & Guest Register

Monitors confirmation numbers, parent linkage codes, and primary guest names.

  • Primary Use: Identifying associated multi-room bookings, verifying parent-child reservation links, and confirming guest profile names across linked party stays.

  • Key Metrics: Confirmation Number, Original Confirmation Number, Guest Name, First Name, Last Name, Contact Role.

2. Stay Timeframe & Duration Alignment

Tracks arrival dates, departure dates, and total night counts across linked room reservations.

  • Primary Use: Verifying stay date alignment for multi-room groups, identifying split-date arrivals within a linked party, and planning room allocations.

  • Key Metrics: Check In Date, Check Out Date, Nights, Confirmation Number, Guest Name.

3. Financial & Status Trace

Audits live outstanding guest ledger balances and active reservation statuses for each linked stay.

  • Primary Use: Ensuring individual linked room folios are settled prior to departure, identifying cancelled linked rooms, and monitoring check-in readiness.

  • Key Metrics: Reservation Balance, Reservation Status, Confirmation Number, Guest Name.

Image 10-11-26 at 2.46 PM.png
Linked Reservations Report

Data Dictionary (Dynamic View Columns)

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

💡 Folio Balance Note: Reservation Balance reflects the current live net outstanding balance for the individual reservation folio. A zero balance ($0.00) indicates full payment settlement or a non-revenue status (such as cancelled/checked out).

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Confirmation Number

Primary unique alphanumeric reservation identifier for the individual room.

Reservation System > Confirmation ID

N/A

Original Confirmation Number

Parent or primary reservation linkage code connecting associated party stays.

Reservation System > Parent Linked ID

N/A

Guest Name

Combined full name of the primary registered guest on the linked reservation.

Guest Profile > Full Name

N/A

First Name

First name of the primary registered guest.

Guest Profile > First Name

N/A

Last Name

Last name of the primary registered guest.

Guest Profile > Last Name

N/A

Contact Role

Primary contact or relationship role designation on the guest profile.

Guest Profile > Contact Role

N/A

Check In Date

Scheduled check-in date of the linked reservation.

Reservation System > Check-In Date

N/A

Check Out Date

Scheduled check-out date of the linked reservation.

Reservation System > Check-Out Date

N/A

Nights

Total physical room nights spanned by the stay.

Reservation System > Total Nights

N/A

Reservation Balance

Live net outstanding dollar balance on the individual reservation folio.

Guest Folio > Outstanding Balance

🟢 Yes

Reservation Status

Live operational stay status (e.g., ARRIVAL, CHECKED OUT, CANCELLED).

Reservation System > Operational Status

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:

    • Linked Reservation Audit (Cols 1–2): Confirmation Number | Original Confirmation Number

    • Guest Profile & Contact Identification (Cols 3–6): Guest Name | First Name | Last Name | Contact Role

    • Stay Itinerary & Timestamps (Cols 7–9): Check In Date | Check Out Date | Nights

    • Financial Ledger & Lifecycle Status (Cols 10–11): Reservation Balance | Reservation Status

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-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 Linked Reservations report features an interactive pie chart to help analyze reservation status distributions across multi-room bookings. Users can group linked records on the fly by Reservation Status to evaluate all rooms belonging to a specific party or family group. By selecting Confirmation Number from the Select Base Column dropdown menu, the chart dynamically renders percentage share breakdowns accompanied by an interactive color-coded legend.

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

  • Exporting & Shift Handovers: Download in Excel or PDF format to support front desk morning briefings, group check-in coordination, and shift handovers.

  • Filtering: Filter data by Reservation Status = ARRIVAL to manage incoming linked arrivals, or isolate open balances (Reservation Balance > $0).

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight linked rooms with open balances or status mismatches within the same party.

Within 🛎️ Front Desk & Guest Services & 🏨 In-House & Occupancy:

  • In House Guest List – Standard guest roster tracking active room occupants, contact info, and stay dates.

  • 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.

Cross-Pillar Deep Dives: