Arrivals .ng

Arrivals Report Overview

Parent Hub: πŸ›ŽοΈ Front Desk & Guest Services

Category: 🚨 Downtime & Contingency

Target Roles: Front Office Managers, Front Desk Agents, Night Auditors, Executive Housekeepers, Guest Experience Leads, General Managers

Key Value: Serves as the primary operational downtime contingency manifest for expected check-ins, allowing front desk teams to process check-ins, verify pre-blocked room numbers, confirm rate plans, and review guest preferences during PMS system outages or network offline periods.

Date Parameter: Single Date Selector | Future Only | Maximum Range: 365 days

Executive Summary

The Arrivals Report is a critical operational contingency, pre-arrival planning, and system outage management document within the 🚨 Downtime & Contingency category of the πŸ›ŽοΈ Front Desk & Guest Services hub. Designed to ensure seamless property operations during unexpected software outages, planned PMS maintenance, or network disconnections, it provides a comprehensive printed or exported manifest of all reservations scheduled to arrive on the current business date.

  • By mapping core guest identity parameters (Guest Name, First Name, Last Name, Additional Guests, Local First Name, Local Last Name) to reservation parameters (Confirmation Number, Arrival Date, Departure Date, Number Of Nights, Arrival Time), physical room allocations (Room Number, Room Type, Connecting Room), financial arrangements (Rate Plan, Avg. Room Rate, Avg. Room Taxes, Fee, Guarantee Type, Virtual CC), and operational preferences (Stay Requests, Room Preferences, VIP Guest, Housekeeping Remarks, Booking Remarks, Stay Remarks), this report guarantees front office continuity, accurate rate collection, and personalized guest service even when primary cloud systems are offline.

Key Capabilities

  • Downtime Contingency Check-In Manifest: Provides an essential physical or PDF fallback register to check in arriving guests, verify identity credentials, and record room key issuances during system outages.

  • Pre-Arrival Room Blocking & Inventory Audit: Displays assigned physical room numbers (Room Number) and room categories (Room Type) to ensure expected check-ins match inspected housekeeping status.

  • Financial & Payment Guarantee Control: Itemizes base rate charges (Avg. Room Rate), estimated taxes (Avg. Room Taxes), ancillary fees (Fee), guarantee methods (Guarantee Type), and Virtual Credit Card flags (Virtual CC) for precise manual folio management.

  • Digital Engagement Tracking: Displays mobile check-in completion states (Digital Check In) and keyless entry issuing statuses (Digital Key) to streamline arrival desk flows.

  • Consolidated Remarks & VIP Inspection: Consolidates multi-departmental notes (Housekeeping Remarks, Booking Remarks, Stay Remarks, Group Remarks) and VIP tier standing (VIP Guest, Guest Tier, Loyalty Tier) to maintain high-touch guest recognition.

Report Views & Functional Breakdown

The Arrivals Report presents expected arrival data in a unified, single-table master manifest supporting three primary operational perspectives:

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚                        ARRIVALS REPORT                                 β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚                         Unified Matrix View                            β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1. Guest Identity &      β”‚ 2. Room Assignment &     β”‚ 3. Financial,    β”‚
β”‚    Stay Timeframe Trace  β”‚    Digital Key Status    β”‚    Guarantee &   β”‚
β”‚                          β”‚                          β”‚    Remarks Trace β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

1. Guest Identity & Stay Timeframe Trace

Monitors expected guest names, accompanying occupants, stay durations, and expected arrival times.

  • Primary Use: Verifying guest identity at check-in during offline shifts, planning arrival desk staffing, and checking expected stay durations.

  • Key Metrics: Confirmation Number, Guest Name, First Name, Last Name, Additional Guests, Arrival Date, Departure Date, Number Of Nights, Arrival Time.

2. Room Assignment & Digital Key Status

Tracks physical room allocations, room categories, connecting room requirements, and mobile key provisioning.

  • Primary Use: Verifying room pre-blocking prior to guest check-in, coordinating room releases with housekeeping, and monitoring digital check-in adoption.

  • Key Metrics: Room Number, Room Type, Connecting Room, Digital Check In, Digital Key, Housekeeping Remarks.

3. Financial, Guarantee & Remarks Trace

Audits rate plan structures, daily rate charges, payment guarantee security, corporate/agent affiliations, and multi-departmental stay remarks.

  • Primary Use: Verifying manual credit card authorizations or Virtual CC vouchers during outages, ensuring accurate rate billing, and executing VIP/stay requests.

  • Key Metrics: Rate Plan, Avg. Room Rate, Avg. Room Taxes, Fee, Guarantee Type, Virtual CC, VIP Guest, Stay Requests, Booking Remarks, Stay Remarks.

Image 10-13-26 at 7.46β€―PM.png
Arrivals Report (Columns 1 - 20)
Image 10-13-26 at 7.49β€―PM.png
Arrivals Report (Columns 21 - 35)

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 43 exact dynamic columns available in this report, sorted in alphabetical order by column name:

πŸ›ŽοΈ Operational Rate & Contingency Notes:

  • Nightly Financial Averages: Avg. Room Rate reflects the average net nightly accommodation rate across the stay (excluding taxes), while Avg. Room Taxes displays the average nightly occupancy and sales taxes.

πŸš€ Upcoming Release Note (Version 6.0.6):

The Billing Remarks columnβ€”which displays specific folio routing instructions, corporate direct bill notes, and payment responsibility directives (e.g., Charges routed to AR, Guest responsible for all charges)β€”will become available starting in the 6.0.6 version release.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Add On

Supplementary packages, amenities, or ancillary items attached to the reservation (e.g., breakfast package, parking, welcome amenity).

Reservation Engine > Package Add-Ons

Varies by Item

Additional Guests

Full names of accompanying adult or child guests registered to share the room alongside the primary guest.

Reservation Engine > Accompanying Guests

N/A

Adults

Total count of adult occupants booked on the reservation.

Reservation Engine > Adult Occupancy

N/A

Arrival Date

Scheduled check-in calendar date for the incoming reservation.

Reservation Engine > Check-In Date

N/A

Arrival Time

Estimated or guest-specified time of arrival at the property.

Reservation Engine > Estimated Arrival Time

N/A

Avg. Room Rate

Average nightly net room rate charged across the duration of the guest's stay, excluding taxes and fees.

Rate Engine > Average Nightly Rate

❌ No

Avg. Room Taxes

Average nightly occupancy, state, and local lodging taxes calculated across the guest's stay.

Tax Engine > Average Nightly Taxes

🟒 Yes

Billing Remarks

Folio routing directives, direct bill instructions, and payment responsibility notes (Available in the 6.0.6 version release).

Folio Billing Setup > Billing Remarks

N/A

Booking Remarks

General reservation notes entered at the time of booking (e.g., ID verification rules, extension permissions).

Reservation Engine > Booking Notes

N/A

Children

Total count of child occupants booked on the reservation.

Reservation Engine > Child Occupancy

N/A

Company Name

Registered commercial trade name or corporate account associated with the reservation (e.g., HotelKey, Inc.).

Company Master > Company Legal Name

N/A

Company Service Level

Designated corporate tier or VIP service classification assigned to the sponsoring company profile.

Company Master > Service Tier

N/A

Confirmation Number

Primary unique property management system (PMS) confirmation identifier assigned to the booking.

Reservation Engine > Confirmation ID

N/A

Connecting Room

Indicator specifying whether the assigned room is part of a connecting room pair (Yes or No).

Room Inventory Master > Connecting Flag

N/A

Departure Date

Scheduled check-out calendar date for the incoming reservation.

Reservation Engine > Check-Out Date

N/A

Digital Check In

Indicates whether the guest has completed or initiated contactless mobile check-in (Yes or No).

Mobile Journey Engine > Digital Check-In Status

N/A

Digital Key

Indicates whether a mobile Bluetooth/NFC room key has been issued or requested for the reservation (Yes or No).

Mobile Key Interface > Key Issuance Status

N/A

Duplicate Reservations

System alert flag or confirmation reference identifying potential duplicate bookings under the same guest name and arrival date.

Reservation Audit > Duplicate Detection Flag

N/A

Fee

Mandatory nightly or per-stay resort, destination, or facility fees applicable to the reservation.

Rate / Fee Engine > Mandatory Fees

❌ No

First Name

First name of the primary registered guest arriving at the property.

Guest Profile > First Name

N/A

Group Remarks

Master operational notes inherited from an associated group room block contract.

Group Master > Group Block Remarks

N/A

Guarantee Type

Payment guarantee method securing the reservation against late arrival or no-show (e.g., PROPERTY GUARANTEE, Credit Card, Direct Bill).

Reservation Engine > Guarantee Policy

N/A

Guest Name

Full legal name of the primary registered guest, formatted as LAST FIRST.

Guest Profile > Full Name

N/A

Guest Tier

Secondary or property-specific guest recognition tier assigned to the traveler's profile.

Guest Profile > Recognition Tier

N/A

Housekeeping Remarks

Special room preparation, crib/rollaway setup, or cleaning instructions directed to the housekeeping team.

Housekeeping Module > Room Prep Notes

N/A

Last Name

Last name (surname) of the primary registered guest arriving at the property.

Guest Profile > Last Name

N/A

Linked Reservations

Confirmation number(s) of associated multi-room bookings linked together under the same party or itinerary.

Reservation Engine > Linked Booking IDs

N/A

Local First Name

First name of the primary guest written in local or native script/language for international properties.

Guest Profile > Native Script First Name

N/A

Local Last Name

Surname of the primary guest written in local or native script/language for international properties.

Guest Profile > Native Script Last Name

N/A

Loyalty Tier

Brand loyalty club membership status level associated with the guest profile (e.g., Blue, Silver, Gold, Platinum, Diamond).

Loyalty Engine > Membership Tier

N/A

Number Of Nights

Total scheduled length of stay measured in room nights.

Reservation Engine > Room Nights

N/A

Purpose Of Visit

Travel classification captured on the reservation (e.g., Business, Leisure, Group, Crew).

Reservation Engine > Visit Purpose

N/A

Rate Plan

Pricing code or rate tier booked for the reservation (e.g., SPECIAL).

Rate Master > Rate Plan Code

N/A

Requests

General service requests submitted by the guest or booking channel prior to arrival.

Reservation Engine > General Requests

N/A

Room Number

Physical guest room number pre-assigned or blocked for the arriving reservation.

Room Inventory Master > Assigned Room

N/A

Room Preferences

Specific guest room attribute preferences stored in the guest profile (e.g., high floor, near elevator, feather-free).

Guest Profile > Room Attributes

N/A

Room Type

Inventory room category code booked or assigned to the reservation (e.g., QR).

Room Inventory Master > Room Type Code

N/A

Stay Remarks

Specific operational instructions pertaining to the current stay dates (e.g., late arrival, early arrival).

Reservation Engine > Stay-Specific Notes

N/A

Stay Requests

Actionable amenity or service requests scheduled for fulfillment during the guest's stay.

Guest Service Module > Stay Requests

N/A

Travel Agent Company Name

Name of the travel agency, TMC, or OTA entity credited with booking the reservation.

Agency Master > Travel Agency Name

N/A

Travel Agent Number

IATA, ARC, or CLIA identification number of the booking travel agency.

Agency Master > IATA / Agency ID

N/A

VIP Guest

Designates whether the arriving guest holds special VIP status requiring heightened operational attention (Yes or No).

Guest Profile > VIP Indicator

N/A

Virtual CC

Indicator specifying whether the reservation is guaranteed or paid via a single-use virtual credit card (Yes or No).

Payment / Channel Interface > Virtual Card Flag

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:

    • Primary Booking Keys & Room Inventory (Cols 1–4): Confirmation Number | Room Number | Room Type | Connecting Room

    • Stay Schedule, ETA & Nights Duration (Cols 5–8): Arrival Date | Arrival Time | Departure Date | Number Of Nights

    • Guest Profile & Local Name Identifiers (Cols 9–14): Guest Name | First Name | Last Name | Local First Name | Local Last Name | Additional Guests

    • VIP Recognition & Loyalty Status (Cols 15–17): VIP Guest | Loyalty Tier | Guest Tier

    • Party Occupancy & Travel Context (Cols 18–20): Adults | Children | Purpose Of Visit

    • Digital Check-In & Mobile Key Readiness (Cols 21–22): Digital Check In | Digital Key

    • Rate Plan & Daily Revenue / Tax Metrics (Cols 23–26): Rate Plan | Avg. Room Rate | Avg. Room Taxes | Fee

    • Guarantee, Virtual Card & Reservation Linkages (Cols 27–30): Guarantee Type | Virtual CC | Linked Reservations | Duplicate Reservations

    • Corporate Account & Travel Agency Profiles (Cols 31–34): Company Name | Company Service Level | Travel Agent Company Name | Travel Agent Number

    • Guest Requests, Preferences & Add-Ons (Cols 35–38): Add On | Requests | Stay Requests | Room Preferences

    • Departmental & Operational Remarks (Cols 39–43): Billing Remarks | Housekeeping Remarks | Booking Remarks | Stay Remarks | Group Remarks

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.

Advanced Controls
  • Downtime Contingency Printing & Exporting: Automatically schedule a daily PDF/Excel export prior to shift changes (e.g., 06:00, 14:00, 22:00) to maintain an updated offline emergency check-in binder at the front desk.

  • Filtering: Filter data by Room Number = Blank to generate unassigned arrival lists requiring pre-blocking, or isolate Virtual Credit Card bookings (Virtual CC = Yes).

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-tier VIP arrivals (VIP Guest = Yes), unassigned rooms, or specific stay remarks.

Within πŸ›ŽοΈ Front Desk & Guest Services & 🚨 Downtime & Contingency:

Cross-Pillar Deep Dives: