Guest Balance Summary .ng

Guest Balance Summary 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 guest ledger exposure across active in-house reservations, evaluate confirmed posted charges versus full-stay projections, track payment collections and deposit coverage, enforce credit limit thresholds, and prevent check-out billing losses.

Executive Summary

The Guest Balance Summary Report is a primary guest ledger audit, credit control, and financial risk mitigation document within the 🧾 Guest Folios & Billing category of the 🛎️ Front Desk & Guest Services hub. Designed to provide concise, property-wide visibility over active guest room liabilities, it itemizes every in-house reservation alongside posted charges, projected full-stay totals, settled payments, and current net balances.

• By mapping room allocations (Room Number) and reservation identifiers (Confirmation Number) to guest profile attributes (Guest Name, Company Name, Guarantee Type, Reservation Status), stay timeframes (Arrival Date, Departure Date), and financial posting metrics (Confirmed Charges, Total Charges, Payments, Today's Balance, Reservation Balance), this report enables hotel controllers, night auditors, and front office managers to audit guest ledger exposure, evaluate credit card deposit coverage, request mid-stay folio settlements, and ensure smooth check-out operations.

Key Capabilities

• In-House Guest Ledger Audit: Itemizes all active in-house reservations to provide an operational snapshot of current guest ledger liabilities.

• Confirmed vs. Total Stay Revenue Tracking: Distinguishes actual revenue posted to date (Confirmed Charges) from cumulative projected revenue for the entire stay duration (Total Charges).

• Settlement & Deposit Coverage Analysis: Tracks cumulative settled payments, advance deposits, and credit card authorizations (Payments).

• Real-Time Dual Balance Auditing: Calculates net liability incurred up to the current business day (Today's Balance) alongside net projected liability at scheduled check-out (Reservation Balance).

• Corporate Account & Guarantee Method Mapping: Identifies corporate company attachments (Company Name) and payment guarantee rules (Guarantee Type, e.g., CREDIT CARD, PROPERTY) to enforce high-balance credit limits.

Report Views & Functional Breakdown

The Guest Balance Summary Report presents guest ledger data in a unified single-table matrix that supports three primary analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                   GUEST BALANCE SUMMARY REPORT                         │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Guest Identity &      │ 2. Confirmed vs. Total   │ 3. Settlement &  │
│    Guarantee Matrix      │    Stay Revenue Trace    │    Ledger Balance│
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Guest Identity & Guarantee Matrix

Monitors room allocations, reservation confirmation numbers, guest names, corporate company attachments, and active payment guarantee methods.

• Primary Use: Verifying guest room assignments, checking corporate billing attachments, and confirming valid payment guarantee methods during shift handovers.

• Key Metrics: Room Number, Confirmation Number, Guest Name, Company Name, Guarantee Type, Reservation Status.

2. Confirmed vs. Total Stay Revenue Trace

Tracks actual charges billed to date alongside projected total charges across the entire stay window.

• Primary Use: Comparing posted room/incidental revenue against total contracted stay value to anticipate future night audit postings.

• Key Metrics: Confirmed Charges, Total Charges, Arrival Date, Departure Date, Confirmation Number.

3. Settlement & Ledger Balance

Itemizes settled payment credits, current day net liabilities, and projected end-of-stay balances.

• Primary Use: Identifying high-balance guests requiring interim payment authorization, reviewing deposit credit coverage, and preventing check-out billing delays.

• Key Metrics: Payments, Today's Balance, Reservation Balance, Room Number, Confirmation Number.

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 13 columns available in this report:

💡 Coupled Financial Posting Note: Numerical monetary values in this report (Confirmed Charges, Total Charges, Payments, Today's Balance, Reservation 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 folios.

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 Entity Locators (Cols 1–4): Room Number | Guest Name | Confirmation Number | Company Name

  • Core Actionable Balances (Cols 5–6): Today's Balance | Reservation Balance

  • Financial Ledger Breakdown (Cols 7–9): Confirmed Charges | Total Charges | Payments

  • Stay Context & Operational Metadata (Cols 10–13): Arrival Date | Departure Date | Reservation Status | 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
	Knowledge Article	Opens the knowledge base article to learn how to interpret this report.
	Saved Views	Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.
	Filter	Opens filter controls to isolate specific data within a column based on your selected criteria.
	Highlight	Highlights column values in a designated color based on selected conditions.
	Export	Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.
	Configure	Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.
	Additional Configuration	Provides advanced report configuration and display formatting options to customize data presentation.
	Group By	Summarize and group report data dynamically in real time.

Interactive Visualizations & Grouping Controls

• Group By & Pie Chart Visualization: The Guest Balance Summary report features an interactive pie chart to help analyze guest ledger exposure and balance distributions. Users can group guest balance records on the fly by Guarantee Type, Company Name, or Reservation Status to evaluate payment method security and corporate credit risk. By selecting a metric from the Select Base Column dropdown menu—such as Confirmed Charges, Total Charges, Payments, Today's Balance, or Reservation Balance—the chart dynamically renders percentage share breakdowns accompanied by an interactive color-coded legend.

Advanced Controls

• Exporting & Credit Limit Audits: Download in Excel or PDF format to support daily front desk credit audits, night audit folio balancing, and general manager high-balance reviews.

• Filtering: Filter data by Today's Balance > $500 to generate front desk credit call lists, or isolate negative balance accounts (Today's Balance < $0) indicating advance deposit over-payments.

• Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-balance stays (Reservation Balance > $1,000), unconfirmed payment guarantees, or unassigned room numbers.

🔗 Related Reports & Next Steps

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

• Guest Balance Activity – Dual-section audit report detailing reservation and group master balances.

• Stay Over and Balance Due – Focused audit report isolating active stayover room balances.

• Transferred and Routed Charges – Dual-section audit report tracking manual charge transfers and automated group routings.

• Dynamic Charge Details – Tax and surcharge audit report detailing per-person city tax postings and exemptions.

Cross-Pillar Deep Dives:

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

• 💳 Payments & Transactions: Verify guest credit card pre-authorizations and deposit top-ups in Authorized Payments.