Breadcrumbs

Guest Balance Activity .ng

Guest Balance Activity Report Overview

Parent Hub: 🛎️ Front Desk & Guest Services

Category: 🧾 Guest Folios & Billing

Target Roles: Hotel Controllers, Finance Managers, Night Auditors, Front Office Managers, Credit Managers, Accounting Supervisors, General Managers

Key Value: Monitor real-time guest and group ledger balances, distinguish posted charges from pending night audit projections, evaluate current versus full-stay exposure, enforce credit limits, and optimize pre-check-out folio collections.

Executive Summary

The Guest Balance Activity Report is an essential financial exposure audit, credit governance, and ledger management document within the 🧾 Guest Folios & Billing category of the 🛎️ Front Desk & Guest Services hub. Designed to deliver complete operational and financial visibility over outstanding receivables across active guest reservations and group master accounts, it itemizes current folio postings alongside projected stay balances.

  • By organizing ledger exposure into 2 defined report sections: Reservation Due and Group Due, this report enables hotel controllers, night auditors, and front office managers to evaluate individual guest folio activity (Reservation Due) alongside master group account balances (Group Due). It correlates stay parameters (Room Number, Confirmation Number, Group Number, Group Code, Guest/Group Name, Check In Date, Check Out Date, Guarantee Type) with confirmed posted revenue (Confirmed Charges, Total Charges), pending night audit projections (Pending Charges), recorded settlements (Payments, Total Payments), current business day liabilities (Today's Balance), and full-stay exposure (Full Stay Balance, Balance).

Key Capabilities

  • Two-Section Ledger Exposure Audit: Distinguishes individual guest reservation liabilities (Reservation Due) from master corporate and tour group balances (Group Due).

  • Confirmed vs. Pending Charge Breakdown: Separates actual posted folio transactions (Confirmed Charges) from unposted future room/tax projections (Pending Charges) to model total stay financial exposure (Total Charges).

  • Real-Time Dual-Balance Tracking: Displays the guest's immediate liability up to the current business day (Today's Balance) alongside the projected end-of-stay liability (Full Stay Balance).

  • Group Master Account Oversight: Tracks master group block charges (Total Charges), advance deposits or posted credits (Total Payments), and net outstanding group liabilities (Balance).

  • Guarantee Method Verification: Identifies payment guarantee arrangements (Guarantee Type, e.g., Credit Card, Direct Bill) to ensure high-balance accounts are backed by valid payment methods.

Report Views & Functional Breakdown

The Guest Balance Activity Report presents guest and group ledger data in a structured matrix across 2 defined sections:

┌────────────────────────────────────────────────────────────────────────┐
│                   GUEST BALANCE ACTIVITY REPORT                        │
├────────────────────────────────────────────────────────────────────────┤
│                       2 Defined Report Sections                        │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Reservation Due       │ 2. Group Due             │                  │
│    Section (Individual)  │    Section (Group Master)│                  │
└──────────────────────────┴──────────────────────────┴──────────────────┘
1. Reservation Due Section

Monitors financial transactions, posted charges, pending projections, and net balances for individual in-house guest reservations.

  • Primary Use: Reviewing active guest credit limits, auditing pending night audit room/tax charges, identifying high-balance stayover guests, and collecting mid-stay payments at the front desk.

  • Key Metrics: Room Number, Confirmation Number, Guest Name, Confirmed Charges, Pending Charges, Total Charges, Payments, Today's Balance, Full Stay Balance.

Image 10-13-26 at 8.44 AM.png
Reservation Due Section
2. Group Due Section

Tracks master group accounts, corporate block charges, recorded payments, and net outstanding group balances.

  • Primary Use: Reconciling master group folios prior to group departures, auditing corporate direct-bill routing, and verifying group advance deposit posting.

  • Key Metrics: Group Number, Group Code, Group Name, Company, Total Charges, Total Payments, Balance.

Image 10-13-26 at 8.46 AM.png
Group Due 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 all 18 unique columns available across the 2 report sections:

💡 Coupled Financial Posting Note: Numerical monetary values in this report (Confirmed Charges, Total Charges, Payments, Today's Balance, Full Stay Balance, Total Payments, Balance) reflect gross ledger postings. They are marked Yes under "Includes Taxes & Fees?" because taxes and fees are coupled directly with room and incidental charges on guest and group folios.

Column Name

Section Applicability

Description

Data Source / System Mapping

Includes Taxes & Fees?

Room Number

Section 1

Physical guest room assigned to the active reservation.

PMS > Assigned Room Number

N/A

Confirmation Number

Section 1

Primary unique alphanumeric reservation identifier.

Reservation System > Confirmation ID

N/A

Guest Name

Section 1

Combined full name of the registered primary guest.

Guest Profile > Full Name

N/A

First Name

Section 1

First name of the primary registered guest.

Guest Profile > First Name

N/A

Last Name

Section 1

Last name of the primary registered guest.

Guest Profile > Last Name

N/A

Company

Both Sections

Corporate company profile or client name linked to the reservation or group.

Reservation / Group Setup > Company

N/A

Check In Date

Both Sections

Scheduled or actual check-in date.

Reservation / Group > Arrival Date

N/A

Check Out Date

Both Sections

Scheduled check-out date.

Reservation / Group > Departure Date

N/A

Guarantee Type

Both Sections

Active payment guarantee method on file (e.g., CREDIT CARD, Direct Bill).

PMS Billing > Guarantee Method

N/A

Confirmed Charges

Section 1

Actual dollar amount of transactions already posted to the folio.

Folio Posting > Posted Charges

🟢 Yes

Pending Charges

Section 1

Projected room, tax, and recurring charges scheduled to post during future night audits.

PMS Night Audit > Pending Charges Projections

🟢 Yes

Total Charges

Both Sections

Sum of confirmed and projected charges (Confirmed + Pending) for Section 1; Total master folio charges for Section 2.

PMS Folio > Total Stay Charges

🟢 Yes

Payments

Section 1

Total settled payments, deposit credits, and refund postings on the guest folio.

Folio Posting > Total Payments

🟢 Yes

Today's Balance

Section 1

Net outstanding balance owed for charges incurred up to the current business date.

PMS Folio > Current Date Net Balance

🟢 Yes

Full Stay Balance

Section 1

Net projected balance owed at check-out after applying pending future charges and payments.

PMS Folio > Projected Final Balance

🟢 Yes

Group Number

Section 2

Unique master group identification number in the PMS.

Group Master > Group ID

N/A

Group Code

Section 2

Alphanumeric block code assigned to the group contract (e.g., FAL, MTU).

Group Master > Group Code

N/A

Group Name

Section 2

Official title or contract description of the group block.

Group Master > Group Name

N/A

Total Payments

Section 2

Cumulative payments, prepayments, and deposit credits posted to the master group folio.

Group Folio > Total Payments

🟢 Yes

Balance

Section 2

Net outstanding balance currently owed on the master group account.

Group Folio > Net 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:

    • Section 1: Reservation Due

      • Primary Entity Locators (Cols 1–6): Room Number | Guest Name | First Name | Last Name | Company | Confirmation Number

      • Core Actionable Balances (Cols 7–8): Today's Balance | Full Stay Balance

      • Financial Sub-Ledger Breakdown (Cols 9–12): Total Charges | Payments | Confirmed Charges | Pending Charges

      • Stay Context & Operational Metadata (Cols 13–15): Check In Date | Check Out Date | Guarantee Type

    • Section 2: Group Due

      • Group Entity Anchors (Cols 1–4): Group Number | Group Name | Group Code | Company

      • Core Actionable Financials (Cols 5–7): Balance | Total Charges | Total Payments

      • Event Context & Corporate Metadata (Cols 8–10): Check In Date | Check Out Date | Guarantee 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-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 & Credit Controls: Download in Excel or PDF format to support daily front desk credit calls, night audit balancing, and general manager financial risk reviews.

  • Filtering: Filter Section 1 by Today's Balance > $500 to generate high-balance guest lists, or filter Section 2 by Balance > $0 to isolate open group accounts.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-risk accounts (Today's Balance > $1,000), unconfirmed guarantees, or large pending charges.

Within 🛎️ Front Desk & Guest Services & 🧾 Guest Folios & Billing:

Cross-Pillar Deep Dives:

  • ⚖️ Ledgers & Trial Balance: Reconcile total guest and group balances (Today's Balance and Balance) against Guest Ledger and City Ledger control accounts in Trial Balance.

  • 💳 Payments & Transactions: Cross-reference credit card guarantee methods with Authorized Payments to verify active pre-authorizations.