Stay Over and Balance Due .ng

Stay Over and Balance Due Report Overview

Parent Hub: 🛎️ Front Desk & Guest Services

Category: 🧾 Guest Folios & Billing

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

Key Value: Monitor real-time uncollected folio balances for active stayover guests, enforce credit limit thresholds and mid-stay payment authorizations, audit guest ledger exposure, and prevent bad debt write-offs prior to check-out.

Executive Summary

The Stay Over and Balance Due Report is an essential credit control, guest ledger audit, and risk mitigation document within the 🧾 Guest Folios & Billing category of the 🛎️ Front Desk & Guest Services hub. Designed to provide complete financial transparency over active in-house guests who are continuing their stay past the current business date (stayovers), it itemizes all live stayover reservations with accumulated, unpaid folio balances.

• By mapping physical guest accommodations (Room Number) and reservation identifiers (Confirmation Number) to stay duration timeframes (Check In Date, Check Out Date) and accumulated uncollected ledger charges (Balance Due Today), this report enables hotel controllers, night auditors, and front office managers to review active guest credit limits, obtain mid-stay payment authorizations, request folio settlements during multi-week stays, and safeguard property cash flow.

Key Capabilities

• Stayover Ledger Exposure Monitoring: Isolates active in-house stayover guests who carry an outstanding ledger balance on the current business date.

• Real-Time Balance Due Calculation: Captures total accrued uncollected room charges, incidental postings, and taxes (Balance Due Today) billed to the active folio.

• Stay Duration & Extended Stay Tracking: Displays scheduled arrival (Check In Date) and departure (Check Out Date) dates to identify long-stay guests requiring periodic interim billing.

• Credit Limit & High-Balance Enforcement: Serves as the primary operational tool for front desk supervisors to enforce property high-balance credit limits and request interim credit card re-authorizations.

• Night Audit Ledger Reconciliations: Provides night auditors and accounting managers with an auditable summary of active guest ledger receivables.

Report Views & Functional Breakdown

The Stay Over and Balance Due Report presents uncollected stayover ledger data in a unified single-table matrix that supports three primary analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                   STAY OVER AND BALANCE DUE REPORT                     │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Active Room & Stayover│ 2. Stay Timeframe &      │ 3. Ledger Balance│
│    Account Identification│    Duration Alignment    │    & Exposure    │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Active Room & Stayover Account Identification

Monitors physical room numbers and reservation confirmation numbers for active stayover occupants.

• Primary Use: Scanning active stayover rooms to cross-reference front office guest folios and room keys.

• Key Metrics: Room Number, Confirmation Number.

2. Stay Timeframe & Duration Alignment

Tracks arrival dates and expected check-out dates for each stayover guest.

• Primary Use: Distinguishing short-stay stayovers from multi-week extended stays to schedule periodic interim folio settlements.

• Key Metrics: Check In Date, Check Out Date, Confirmation Number, Room Number.

3. Ledger Balance & Exposure

Itemizes accumulated unpaid folio balances carried on the current business day.

• Primary Use: Identifying high-balance guests, requesting credit card re-authorizations at the front desk, and auditing total guest ledger receivables.

• Key Metrics: Balance Due Today, 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 5 columns available in this report:

💡 Coupled Financial Posting Note: Balance Due Today represents the total uncollected dollar amount posted to the active guest folio. It is marked Yes under "Includes Taxes & Fees?" because the balance includes base room charges, incidental fees, and all coupled tax and fee postings.

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:

  • Physical Location Anchor (Col 1): Room Number

  • Guest & Stay Identification (Cols 2–4): Confirmation Number | Check In Date | Check Out Date

  • Financial Action Indicator (Col 5): Balance Due Today

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.

Advanced Controls

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

• Filtering: Filter data by Balance Due Today > $500 to generate front desk credit call lists, or isolate long-stay stayovers.

• Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-balance stays (Balance Due Today > $500) or approaching departure dates.

🔗 Related Reports & Next Steps

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

• In House List – Real-time guest register detailing active room occupants, rate plans, and vehicle registration data.

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

• Recurring Charge Details – Automated repeating charge audit report for individual, group, and house accounts.

• Departures Details Report – Manifest tracking scheduled guest departures, folio numbers, and outstanding balances.

Cross-Pillar Deep Dives:

• ⚖️ Ledgers & Trial Balance: Reconcile total active stayover balances (Balance Due Today) against the active Guest Ledger control account in Trial Balance .

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