In-House Guest Folio Balances Report Overview
Parent Hub: π° Finance & Accounting Reports
Category: βοΈ Ledgers & Trial Balance
Target Roles: Hotel Controllers, Night Auditors, Front Desk Managers, Accounts Receivable Managers, Staff Accountants, Directors of Finance
Key Value: Live guest ledger subledger auditing, tracking opening balances, daily charges, applied payments, net change, and ending balances across in-house guest stays and active group master folios, auditing credit risk and high-balance limits, and reconciling guest ledger control accounts against the trial balance.
Date Parameter: Single Date Selector | Past Only (Historical, no limit on days prior)
Executive Summary
The In House Guest Folio Balances report is the primary subledger audit, credit risk management, and trial balance balancing document within the βοΈ Ledgers & Trial Balance category of the π° Finance & Accounting Reports hub. Designed to provide finance leadership and front office teams with complete real-time visibility over active guest ledger exposure, it details the daily financial roll-forward mechanics across all currently registered in-house guest rooms, stay-over reservations, and active group master billing folios as of a designated operational business date.
-
Structured across four defined report sections: Reservations, Groups, Net Totals, and Balances, this report maintains financial traceability from individual room-level folios to macro-level ledger control accounts. It pairs guest demographics and booking attributes (
Confirmation Number,Guest Name,First Name,Last Name,Company Name,Room Number,Status,Check In Date,Check Out Date,Last Posting Date) and group contract parameters (Group Number,Group Name,Group Code,Group Contact Name,Company Name,Start Date,End Date,Last Posting Date) with 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 individual transient rooms from corporate and convention room blocks, this report enables night auditors and controllers to enforce high-balance credit card floor limits, investigate unposted room and tax revenue, ensure accurate daily debit-credit balancing, and verify guest ledger equilibrium against the general ledger trial balance.
Key Capabilities
-
Four-Section Guest Subledger Architecture: Segregates active in-house lodging liabilities and receivables into transient bookings (
Reservations), master room blocks (Groups), consolidated subledger rollups (Net Totals), and overall control benchmarks (Balances). -
Standard Daily Roll-Forward Accounting: Models double-entry ledger mechanics for every active account by calculating opening positions (
Today's Opening Balance), intraday debit charges (Today's Charges), intraday credit payments/adjustments (Today's Payments), net daily activity (Today's Net Change), and closing positions (Today's Ending Balance). -
High-Balance & Credit Risk Surveillance: Audits live outstanding folio balances (
Today's Ending Balance) on currently occupied rooms (Status = CHECKED_IN), enabling front desk supervisors to secure additional pre-authorizations when charges approach credit ceilings. -
Active Group Master Billing Governance: Tracks corporate and convention master accounts (
Group Number,Group Code), monitoring cumulative master charges, client advance deposits, and billing transfers before post-event departure. -
Folio Activity & Posting Recency Auditing: Preserves the last financial interaction timestamp (
Last Posting Date), highlighting dormant in-house folios that have not received room, tax, or incidental postings. -
Two-Way Balance Exposure Monitoring: Distinguishes accounts carrying guest receivables (positive ending balances owed to the property) from accounts with unapplied prepayments, cash advances, or deposit credits (negative ending balances).
Report Views & Functional Breakdown
The In House Guest Folio Balances report structures active guest ledger balances across four defined sections:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β IN HOUSE GUEST FOLIO BALANCES REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β 4 Defined Report Sections β
ββββββββββββββββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββββββββββ€
β 1. Reservations β 2. Groups β
β (In-House Transient Stays) β (Active Group Master Folios) β
ββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββ€
β 3. Net Totals β 4. Balances β
β (Subledger Category Rollup) β (Guest Ledger Control Rollup) β
ββββββββββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββ
1. Reservations Section (In-House Transient Stays)
Itemizes every individual registered guest folio in the hotel, tracking room assignments, stay duration dates, daily debit/credit postings, and live ending balances.
-
Primary Use: Daily night audit cashier balancing, monitoring in-house guest floor limits, auditing room-and-tax postings, and reviewing disputed incidental charges.
-
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 (Active Group Master Folios)
Details all open group master accounts, conference room blocks, and tour group folios holding active billing balances during the reporting business day.
-
Primary Use: Tracking group banquet/meeting room postings, monitoring master bill credit balances, verifying billing routing rules, and reviewing master account balances prior to checkout.
-
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 (Subledger Category Rollup)
Consolidates daily financial roll-forward metrics across both operational streams (Reservations and Groups) into executive comparative summary rows alongside an overall net total.
-
Primary Use: Comparing daily transient ledger activity against group master billing volumes and verifying mathematical subledger roll-forward consistency.
-
Key Metrics: Today's Charges, Today's Payments, Today's Opening Balance, Today's Net Change, Today's Ending Balance.
4. Balances Section (Guest Ledger Control Rollup)
Summarizes the property-wide macro opening balance, net daily activity, and closing control balance for the active in-house guest ledger subledger.
-
Primary Use: Night audit ledger balancing, verifying subledger mathematical integrity, and reconciling in-house guest ledger control totals against the general ledger trial balance.
-
Key Metrics: In House Guest Folio Opening Balance, Today's Net Change, In House Guest 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 Activity: Calculated dynamically as Today's Net Change = Today's Charges - Today's Payments.
Closing Balance Roll-Forward: Calculated dynamically as Today's Ending Balance = Today's Opening Balance + Today's Net Change.
Balance Polarity: Positive balances indicate guest debit balances owed to the property; negative balances reflect unapplied cash/credit card payments, deposit credits, or overpayments.
Section 3 Rollup Parity: In Section 3 (
Net Totals), Reservations Ending Balance + Groups Ending Balance = Combined Net Ending Balance.Section 4 Control Parity: In Section 4 (
Balances), theIn House Guest Folio Closing Balanceequals the grand net ending balance shown in Section 3 and the trial balance Guest Ledger control account.
|
Column Name |
Section Applicability |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Check In Date |
Section 1 |
Calendar date on which the registered guest checked into the hotel. |
Front Desk Subledger > Check-In Date |
N/A |
|
Check Out Date |
Section 1 |
Scheduled calendar date on which the in-house guest is scheduled to depart. |
Reservation Engine > Departure Date |
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 unique 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 termination date for the active group room block. |
Group Master > Block End Date |
N/A |
|
First Name |
Section 1 |
First name of the primary registered in-house guest. |
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 legal name of the designated primary meeting planner, corporate coordinator, or group contact. |
Group Master > Contact Person |
N/A |
|
Group Name |
Section 2 |
Official title, convention event name, or master identifier assigned to the group block. |
Group Master > Group Block 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 occupying the room, formatted as LAST FIRST. |
Guest Profile > Full Name |
N/A |
|
Last Name |
Section 1 |
Last name (surname) of the primary registered in-house guest. |
Guest Profile > Last Name |
N/A |
|
Last Posting Date |
Sections 1, 2 |
Most recent calendar date on which a financial charge, payment, or adjustment was posted to the folio. |
Folio Subledger > Latest Activity Date |
N/A |
|
Room Number |
Section 1 |
Physical guest room number currently occupied by the in-house guest. |
Room Inventory Master > Assigned Room |
N/A |
|
Start Date |
Section 2 |
Contractual commencement or arrival date for the group room block. |
Group Master > Block Start Date |
N/A |
|
Status |
Section 1 |
Operational lifecycle state of the reservation (e.g., |
Front Office Subledger > Operational Status |
N/A |
|
Today's Charges |
Sections 1, 2, 3 |
Monetary value of debit transactions (room rate, taxes, incidentals, restaurant charges) posted 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 folio at the end of the reporting business day (Today's Opening Balance + Today's Net Change). |
Calculated: Closing Subledger Position |
π’ 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 Activity Movement |
π’ Yes |
|
Today's Opening Balance |
Sections 1, 2, 3 |
Net monetary balance brought forward on the folio at the beginning 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 settlements, deposits, direct bill transfers) applied 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 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: Reservations
-
Primary Reservation Key & Physical Room Anchor (Cols 1β2):
Confirmation Number|Room Number -
Guest Profile & Occupancy Details (Cols 3β6):
Guest Name|First Name|Last Name|Additional Guests -
Corporate & Group Billing Affiliations (Cols 7β8):
Group Code|Company Name -
Stay Execution Schedule (Cols 9β10):
Check In Date|Check Out Date -
Pricing Plan, Settlement Tender & Lifecycle State (Cols 11β13):
Rate Plan|PAYMENT METHOD:|Status -
Ledger Roll-Forward Balances & Daily Movement (Cols 14β18):
Today's Opening Balance|Today's Charges|Today's Payments|Today's Net Change|Today's Ending Balance
-
-
Section 2: Groups
-
Group Master Identifiers (Cols 1β3):
Group Number|Group Code|Group Name -
Account Accountability & Corporate Sponsor (Cols 4β5):
Group Contact Name|Company Name -
Group Block Itinerary Schedule (Cols 6β7):
Start Date|End Date -
Pricing Plan & Billing Settlement Method (Cols 8β9):
Rate Plan|PAYMENT METHOD: -
Group Master Roll-Forward Balances (Cols 10β14):
Today's Opening Balance|Today's Charges|Today's Payments|Today's Net Change|Today's Ending Balance
-
-
Section 3: Net Totals
-
Individual Guest Ledger Sub-Total:
In House Guest Folio Opening Balance|Today's Net Change|In House Guest Folio Closing Balance -
Group Master Ledger Sub-Total:
In house Group Opening Balance|In house Group Net Change|In house Group Ending Balance
-
-
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 & Night Audit Delivery: Download in Excel or PDF format to support daily trial balance tie-outs, credit limit monitoring, or general ledger balancing.
-
Filtering: Filter data by specific Payment Method, Rate Plan, or high Ending Balance thresholds.
-
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-balance guest folios exceeding credit limits or negative balance positions.
π Related Reports & Next Steps
Within βοΈ Ledgers & Trial Balance & π³ Payments & Transactions:
-
Trial Balance β Translate in-house guest and group sub-ledger closing balances into formal General Ledger asset and liability control accounts.
-
Day End Summary β Verify consolidated daily revenue, tax, payment, and deposit blueprints at business date close.
-
All Payments β Audit line-item cash, check, and card payment receipts posted across in-house folios.
-
Adjustments & Refunds Activity β Review charge write-offs and payment reversals applied to in-house guest folios.
Cross-Pillar Deep Dives:
-
ποΈ Front Desk & Guest Services: Cross-reference active room occupation with In-House Guest to verify guest stay details and departure schedules.
-
π¬ Billing & Receivables (AR): To inspect corporate direct-bill balances transferred from checked-out guest folios, review Direct Bill Ledger Details.