Breadcrumbs

Departures Details Report .ng

Departures Details Report Overview

Parent Hub: 🛎️ Front Desk & Guest Services

Category: 🧳 Arrivals & Departures

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

Key Value: Monitor daily scheduled guest departures, track live check-out statuses, verify folio balances and billing routing prior to departure, inspect company affiliations, and ensure seamless guest check-out and room turnover workflow.

Executive Summary

The Departures Details Report is an essential operational check-out manifest and guest ledger balancing document within the 🧳 Arrivals & Departures category of the 🛎️ Front Desk & Guest Services hub. Designed to deliver complete front desk and billing visibility over departing guests, it itemizes every reservation scheduled to check out on the selected date range alongside room assignments, folio numbers, company affiliations, and outstanding folio balances.

  • By mapping operational stay parameters (Confirmation Number, Guest Name, First Name, Last Name, Room Number, Reservation Status, Arrival Date, Departure Date) to billing and corporate routing attributes (Folio Number, Company Name, Company Address, Folio Balance), this report enables front desk agents, guest services supervisors, and hotel controllers to streamline check-out workflows, settle pending guest ledger balances, audit corporate direct billing arrangements, and coordinate timely room turnarounds with housekeeping.

Key Capabilities

  • Daily Departure Manifest Tracking: Itemizes all scheduled departing reservations, capturing assigned physical room numbers (Room Number) and stay windows (Arrival Date and Departure Date).

  • Live Reservation Status Monitoring: Displays real-time stay statuses (e.g., CHECKED_IN, HOLD, CHECKED_OUT) to distinguish guests who are actively departing from those on administrative hold or completed departures.

  • Folio Ledger & Balance Auditing: Captures specific folio sub-accounts (Folio Number) and live outstanding net dollar balances (Folio Balance) to ensure zero-balance settlement upon guest departure.

  • Corporate & Direct Billing Verification: Identifies corporate company profiles (Company Name) and billing addresses (Company Address) to confirm direct bill routing or loyalty program billing before checkout completion.

  • Multi-Folio Granular Traceability: Breaks down multi-folio reservations into individual folio sub-records, allowing agents to inspect split charges (e.g., room rent vs. incidentals) across distinct folio numbers.

Report Views & Functional Breakdown

The Departures Details Report presents departing guest data in a unified single-table ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                   DEPARTURES DETAILS REPORT                            │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Guest Stay & Room     │ 2. Folio Ledger &        │ 3. Corporate &   │
│    Departure Manifest    │    Balance Audit         │    Billing Trace │
└──────────────────────────┴──────────────────────────┴──────────────────┘
1. Guest Stay & Room Departure Manifest

Monitors departing guest room assignments, stay dates, and operational reservation statuses.

  • Primary Use: Managing the morning check-out queue, verifying guest room departure statuses, identifying late check-outs, and notifying housekeeping of vacated rooms.

  • Key Metrics: Confirmation Number, Guest Name, Room Number, Reservation Status, Arrival Date, Departure Date.

2. Folio Ledger & Balance Audit

Audits individual guest folio sub-accounts and live outstanding financial balances prior to departure.

  • Primary Use: Ensuring all outstanding guest charges (room, tax, incidentals) are fully settled to zero balance before check-out, and verifying credit card authorization balances.

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

3. Corporate & Billing Trace

Correlates departing guest stays with company profiles and billing address details.

  • Primary Use: Verifying corporate direct bill authorizations, confirming company invoice routing, and reviewing loyalty profile billing attachments.

  • Key Metrics: Confirmation Number, Guest Name, Company Name, Company Address, Folio Number, Folio Balance.

Image 10-10-26 at 4.13 PM.png
Departures Details 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 every column available in this report:

💡 Folio Balance Note: Folio Balance reflects the current net outstanding ledger balance for the specific Folio Number. A positive balance indicates guest charges pending payment settlement, whereas a zero balance indicates a fully settled folio.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Confirmation Number

Unique alphanumeric reservation identifier.

Reservation System > Confirmation Number

N/A

Guest Name

Combined full name of the registered guest.

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

Folio Number

Specific sub-folio account number linked to the reservation (e.g., Folio 1 for Room/Tax, Folio 2 for Incidentals).

PMS Folio Ledger > Folio ID

N/A

Company Name

Name of corporate company profile or loyalty program linked to the stay (e.g., MUNICH RE).

Reservation System > Corporate Account

N/A

Company Address

Physical or billing address of the associated company profile.

Corporate Profile > Address

N/A

Room Number

Physical guest room assigned to the departing reservation.

PMS > Assigned Room Number

N/A

Reservation Status

Live operational stay status (e.g., CHECKED_IN, HOLD, CHECKED_OUT).

Reservation System > Operational Status

N/A

Arrival Date

Scheduled or actual check-in date of the reservation.

Reservation System > Arrival Date

N/A

Departure Date

Scheduled check-out date of the reservation.

Reservation System > Departure Date

N/A

Folio Balance

Net outstanding dollar balance on the specified folio account.

Guest Folio > Outstanding Balance

Yes

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:

    • Reservation & Guest Audit (Cols 1–5): Confirmation Number | Guest Name | First Name | Last Name | Folio Number

    • Company Profile & Billing (Cols 6–7): Company Name | Company Address

    • Stay Itinerary & Room Assignment (Cols 8–11): Room Number | Reservation Status | Arrival Date | Departure Date

    • Folio Settlement & Balance (Col 12): Folio Balance

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

  • Exporting & Shift Reconciliations: Download in Excel or PDF format to support morning front desk shift briefings, mid-day check-out audits, and night audit balancing.

  • Filtering: Filter data by Reservation Status = CHECKED_IN to view guests yet to check out, or filter for non-zero balances (Folio Balance > $0) to identify uncollected payments.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high outstanding folio balances, administrative hold statuses (HOLD), or specific corporate billing accounts.

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

  • Departures List – Standard summary manifest tracking daily scheduled guest departures and check-out counts.

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

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

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

Cross-Pillar Deep Dives:

  • ⚖️ Ledgers & Trial Balance: Reconcile guest folio balances against Guest Ledger control accounts in Trial Balance.

  • 💳 Payments & Transactions: Inspect non-zero departure balances and settled credit card transactions in Settlement By Payment Type.