Closed Folio Balance .ng

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.

Image 8-13-26 at 1.42β€―PM.png
Reservations Section

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.

Image 8-13-26 at 1.47β€―PM.png
Groups Section

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.

Image 8-13-26 at 1.49β€―PM.png
Net Totals Section

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.

Image 8-13-26 at 1.51β€―PM.png
Balances 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 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., CANCELLED, NO SHOW).

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

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 & 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.

Within βš–οΈ Ledgers & Trial Balance:

Cross-Pillar Deep Dives: