Closed Folio Balances Report Overview
Parent Hub: π° Finance & Accounting Reports
Category: βοΈ Ledgers & Trial Balance
Target Roles: Hotel Controllers, Night Auditors, Accounts Receivable Managers, Staff Accountants, Front Office Managers, Directors of Finance
Key Value: Forensic guest and group subledger auditing, identifying non-zero lingering balances on inactive, cancelled, and no-show folios, tracking daily charge and payment movements on closed accounts, enforcing zero-balance folio hygiene, and reconciling closed folio ledger totals against trial balance control accounts.
Date Parameter: Single Date Selector | Past Only (Historical, no maximum days prior)
Executive Summary
The Closed Folio Balances report is an essential financial integrity, subledger audit, and balance sheet reconciliation document within the βοΈ Ledgers & Trial Balance category of the π° Finance & Accounting Reports hub. Designed to maintain strict accounting governance across inactive accounts, it detects, itemizes, and audits non-zero balances remaining on guest reservations and group master folios that have ceased operational activityβspecifically bookings transitioned to cancelled or no-show states without completing financial zero-out settlement.
-
Structured across four defined report sections: Reservations, Groups, Net Totals, and Balances, this report provides complete financial traceability over lingering debit assets and credit liabilities. It correlates individual guest profiles (
Confirmation Number,Guest Name,Room Number,Status,Check In Date,Check Out Date,Last Posting Date) and group contracts (Group Number,Group Name,Group Code,Group Contact Name,Company Name,Start Date,End Date) with standard daily ledger roll-forward metrics (Today's Charges,Today's Payments,Today's Opening Balance,Today's Net Change,Today's Ending Balance). By isolating inactive accounts carrying unsettled guest debt (positive balances) from unrefunded advance deposits (negative balances), this report equips hotel controllers and night auditors to eliminate subledger clutter, prevent revenue leakage, process timely guest refunds, and ensure trial balance equilibrium.
Key Capabilities
-
Four-Section Closed Subledger Auditing: Segregates closed accounts into individual bookings (
Reservations), master room blocks (Groups), consolidated rollups (Net Totals), and overall ledger control benchmarks (Balances). -
Cancelled & No-Show Folio Leakage Detection: Identifies reservations that bypassed financial settlement upon status cancellation (
Status = CANCELLED) or failed guest arrival (Status = NO SHOW), preventing uncollected penalty fees or abandoned deposits. -
Two-Way Balance Exposure Monitoring: Highlights uncollected hotel receivables (positive ending balances) requiring collection or write-off, alongside unearned guest liabilities (negative ending balances) requiring deposit forfeiture or refund disbursement.
-
Daily Roll-Forward Accounting: Tracks intraday ledger adjustments by pairing opening balances (
Today's Opening Balance) with current-day debits (Today's Charges) and credits (Today's Payments) to compute net daily variance (Today's Net Change) and closing totals (Today's Ending Balance). -
Group Master Inactive Balance Auditing: Captures lingering billing balances on concluded corporate group blocks and convention masters (
Group Number,Group Code), identifying unbilled attrition fees or unallocated master billing credits. -
Posting Recency & Inactivity Tracking: Preserves the last financial interaction date (
Last Posting Date), highlighting dormant folios requiring administrative write-off or escheatment review.
Report Views & Functional Breakdown
The Closed Folio Balances report organizes inactive subledger accounts into four defined sections:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β CLOSED FOLIO BALANCES REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β 4 Defined Report Sections β
ββββββββββββββββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββββββββββ€
β 1. Reservations β 2. Groups β
β (Cancelled & No-Show Stays) β (Concluded Group Masters) β
ββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββ€
β 3. Net Totals β 4. Balances β
β (Rollup by Subledger Stream) β (Closed Folio Control Ledger) β
ββββββββββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββ
1. Reservations Section (Cancelled & No-Show Stays)
Itemizes individual transient guest folios that carry non-zero financial balances despite the booking being cancelled or marked as no-show.
-
Primary Use: Investigating uncollected no-show penalties, unrefunded guest cancellation deposits, and unallocated advance room payments.
-
Key Metrics: Confirmation Number, Guest Name, First Name, Last Name, Company Name, Room Number, Status, Check In Date, Check Out Date, Last Posting Date, Today's Charges, Today's Payments, Today's Opening Balance, Today's Net Change, Today's Ending Balance.
2. Groups Section (Concluded Group Masters)
Audits group master folios, corporate event contracts, and convention room blocks that retain active balances after their contractual departure date.
-
Primary Use: Reconciling unbilled master charges, applying final group check payments, transferring group balances to city ledger AR, and closing out completed blocks.
-
Key Metrics: Group Number, Group Name, Group Code, Group Contact Name, Company Name, Start Date, End Date, Last Posting Date, Today's Charges, Today's Payments, Today's Opening Balance, Today's Net Change, Today's Ending Balance.
3. Net Totals Section (Rollup by Subledger Stream)
Consolidates daily financial roll-forward activity into high-level subledger summary rows for Reservations and Groups, culminating in an overall portfolio net total.
-
Primary Use: Providing executive controllers with comparative balance summaries across subledger modules and verifying mathematical roll-forward balancing.
-
Key Metrics: Today's Charges, Today's Payments, Today's Opening Balance, Today's Net Change, Today's Ending Balance.
4. Balances Section (Closed Folio Control Ledger)
Summarizes the property-wide macro opening balance, net daily activity, and closing control balance for the closed folio subledger.
-
Primary Use: High-level general ledger balancing, trial balance cross-referencing, and night audit shift verification.
-
Key Metrics: Closed Folio Opening Balance, Today's Net Change, Closed Folio Closing Balance.
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 21 exact dynamic columns available across the report table sections, sorted in alphabetical order by column name:
βοΈ Financial Roll-Forward & Subledger Balancing Logic:
Net Daily Change: Calculated dynamically as Today's Net Change = Today's Charges - Today's Payments.
Ending Balance Roll-Forward: Calculated dynamically as Today's Ending Balance = Today's Opening Balance + Today's Net Change.
Balance Polarity: Positive balances reflect uncollected guest or group debit obligations owed to the hotel; negative balances reflect unrefunded advance payments, credit adjustments, or customer deposit liabilities.
Section 3 Rollup Parity: In Section 3 (
Net Totals), Reservations Ending Balance + \Groups Ending Balance = Combined Net Ending Balance.
|
Column Name |
Section Applicability |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Check In Date |
Section 1 |
Calendar date on which the guest was scheduled to arrive or originally checked in. |
Reservation Engine > Scheduled Arrival |
N/A |
|
Check Out Date |
Section 1 |
Calendar date on which the guest was scheduled to depart or formally checked out. |
Reservation Engine > Scheduled Departure |
N/A |
|
Company Name |
Sections 1, 2 |
Registered commercial entity, corporate direct billing account, or company associated with the reservation or group block. |
Company Master > Company Legal Name |
N/A |
|
Confirmation Number |
Section 1 |
Primary central reservation system (CRS) or property management system (PMS) booking identifier. |
Reservation Engine > Confirmation ID |
N/A |
|
End Date |
Section 2 |
Scheduled departure or contractual end date for the group room block. |
Group Master > Block End Date |
N/A |
|
First Name |
Section 1 |
First name of the primary registered guest on the closed reservation folio. |
Guest Profile > First Name |
N/A |
|
Group Code |
Section 2 |
Unique alphanumeric block booking code assigned to the group contract. |
Group Master > Group Code |
N/A |
|
Group Contact Name |
Section 2 |
Full name of the designated primary group coordinator, meeting planner, or corporate liaison. |
Group Master > Contact Person |
N/A |
|
Group Name |
Section 2 |
Official title, event name, or master identifier assigned to the group block. |
Group Master > Group Name |
N/A |
|
Group Number |
Section 2 |
Unique central master tracking number assigned to the group booking. |
Group Master > Group ID |
N/A |
|
Guest Name |
Section 1 |
Full legal name of the primary registered guest, formatted as LAST FIRST. |
Guest Profile > Full Name |
N/A |
|
Last Name |
Section 1 |
Last name (surname) of the primary registered guest on the closed reservation folio. |
Guest Profile > Last Name |
N/A |
|
Last Posting Date |
Sections 1, 2 |
Most recent calendar date on which a financial transaction (charge, payment, or adjustment) was posted to the folio. |
Folio Subledger > Latest Activity Date |
N/A |
|
Room Number |
Section 1 |
Physical guest room number assigned to the reservation prior to cancellation or no-show processing. |
Room Inventory Master > Assigned Room |
N/A |
|
Start Date |
Section 2 |
Scheduled arrival or contractual commencement date for the group room block. |
Group Master > Block Start Date |
N/A |
|
Status |
Section 1 |
Operational lifecycle state of the closed reservation record (e.g., |
Reservation Engine > Booking Status |
N/A |
|
Today's Charges |
Sections 1, 2, 3 |
Monetary value of debit transactions (room, tax, incidental fees, or penalties) posted to the closed folio during the reporting business day. |
Folio Subledger > Daily Debits |
π’ Yes |
|
Today's Ending Balance |
Sections 1, 2, 3 |
Net closing monetary balance remaining on the closed folio at the end of the reporting business day (Today's Opening Balance + Today's Net Change). |
Calculated: Closing Subledger Balance |
π’ Yes |
|
Today's Net Change |
Sections 1, 2, 3 |
Net difference between debit charges and credit payments posted to the folio during the reporting business day (Today's Charges - Today's Payments). |
Calculated: Daily Ledger Activity |
π’ Yes |
|
Today's Opening Balance |
Sections 1, 2, 3 |
Net monetary balance brought forward on the closed folio at the start of the reporting business day. |
Folio Subledger > Carried Forward Balance |
π’ Yes |
|
Today's Payments |
Sections 1, 2, 3 |
Monetary value of credit transactions (cash, credit card, refund, or direct bill settlement) applied to the closed folio during the reporting business day. |
Folio Subledger > Daily Credits |
π’ Yes |
Customization & Platform Features
User & Property Preferences
-
Personal Preference: Tailor your individual view by hiding or dragging columns. Your preference saves 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: Reservations
-
Reservation & Guest Identifiers (Cols 1β5):
Confirmation Number|Guest Name|First Name|Last Name|Status -
Account Context & Stay Dates (Cols 6β8):
Company Name|Check In Date|Checkout Date -
Balance Flow & Activity (Cols 9β13):
Today's Opening Balance|Today's Charges|Today's Payments|Today's Net Change|Today's Ending Balance
-
-
Section 2: Groups
-
Group Identifiers (Cols 1β4):
Group Number|Group Code|Group Name|Group Contact Name -
Account Context & Stay Window (Cols 5β7):
Company Name|Start Date|End Date -
Balance Flow & Activity (Cols 8β12):
Today's Opening Balance|Today's Charges|Today's Payments|Today's Net Change|Today's Ending Balance
-
-
Section 3: Net Totals
-
Category Classification (Col 1):
Module Type -
Aggregate Balance Flow (Cols 2β6):
Today's Opening Balance|Today's Charges|Today's Payments|Today's Net Change|Today's Ending Balance
-
-
Section 4: Balances
-
Ledger Item & Amount (Cols 1β2):
Balance Item Descrption|Amount
-
-
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 & Audit Delivery: Download in Excel or PDF format to support daily night audit packets, general ledger balancing, or financial compliance reviews.
-
Filtering: Filter data by specific Status, Company Name, or non-zero Today's Net Change entries.
-
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight closed folios with active net changes (
Today's Net Change β $0.00) or unexpected negative balances.
π Related Reports & Next Steps
Within βοΈ Ledgers & Trial Balance:
-
In House Guest Folio Balances Report β Track daily financial shifts and balances for active, in-house guest stays.
-
House Account Folio Balance Report β Audit daily roll-forward balances for internal non-guest master folios.
-
Group Ledger Report β Review daily roll-forward balancing for active group master accounts.
-
Balance Details Report β Comprehensive ledger roll-forward detailing starting balances, credits, debits, and ending balances per transaction category.
Cross-Pillar Deep Dives:
-
π¬ Billing & Receivables (AR): To inspect closed folios transferred to city ledger billing, review Direct Bill Ledger Details Report or Accounts Receivable Activity Report.
-
π³ Payments & Transactions: To audit payment tenders or refunds posted to closed accounts, cross-reference Adjustments and Refunds Activity Report or Payment Activity Report.
-
π Forward Revenue & Analytics: Looking for forward-facing revenue projections or macro performance metrics (like RevPAR or ADR)? Please visit the π Revenue & Analytics reporting hub.