House Account Folio Balance .ng

House Account Folio Balances Report Overview

Parent Hub: πŸ’° Finance & Accounting Reports

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

Target Roles: Hotel Controllers, Night Auditors, Accounts Receivable Managers, Front Office Managers, Staff Accountants, Directors of Finance

Key Value: Complete internal ledger governance, auditing permanent operational clearing folios (e.g., POS interface, laundry, management entertainment) and temporary function accounts (e.g., meeting rooms, local corporate event billings), tracking intraday charges and settlements, and reconciling house account net asset and liability balances against general ledger trial balance control accounts.

Date Parameter: Single Date Selector | Past Only (Historical, no limit on days prior)

Executive Summary

The House Account Folio Balances report is an indispensable subledger control, cashiering audit, and internal accounting governance document within the βš–οΈ Ledgers & Trial Balance category of the πŸ’° Finance & Accounting Reports hub. Designed to maintain oversight of internal, non-guest lodging ledgers, it details the daily financial activities, opening positions, posted debits/credits, and closing balances for all permanent and temporary house accounts established in the property management system.

  • Structured across 2 defined report sections: House Account Folio Balances and Balances, this report provides complete transparency from granular account transactions up to macro-level ledger control roll-forwards. Preceded by operational profile metadata (House Account Code, House Account Name, Type, Open Date, Close Date, Status, Username, Last Transaction Posted), the primary section itemizes daily postings and balances across all house folios. The concluding section rolls up the entire house account subledger into a verified three-line roll-forward balance summary (House Account Opening Balance, Today's Net Change, House Account Closing Balance). This comprehensive framework enables hotel controllers and night auditors to audit point-of-sale interface drop accounts, detect lingering balances on closed meeting room folios, prevent unallocated internal expenses, and guarantee trial balance integrity.

Key Capabilities

  • Two-Section Subledger Architecture: Itemizes individual house account folios (House Account Folio Balances) and provides a macro-level roll-forward control block (Balances) on a single auditable report.

  • Account Classification Segregation: Distinguishes ongoing interface/operational clearing accounts (Type = PERMANENT, e.g., POS drop, loyalty points clearing) from event-specific accounts (Type = TEMPORARY, e.g., meeting room rentals, banquet functions).

  • Lifecycle Status Governance: Monitors active operational accounts (Status = OPEN) alongside deactivated folios (Status = CLOSED), identifying closed accounts that erroneously retain lingering balances.

  • Daily Roll-Forward Accounting: Models standard ledger roll-forward mechanics across each account by tracking opening positions (Today's Opening Balance), daily debits (Today's Charges), daily credits (Today's Payments), net variance (Today's Net Change), and closing positions (Today's Ending Balance).

  • Staff Accountability & Audit Trail: Records the primary operator (Username) responsible for account setup and logs the exact timestamp of the most recent ledger activity (Last Transaction Posted).

  • Two-Way Balance Exposure Auditing: Identifies unbilled internal expense assets (positive ending balances) and unapplied advance event payments or credit adjustments (negative ending balances).

Report Views & Functional Breakdown

The House Account Folio Balances report organizes internal ledger activity across 2 defined sections:

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚                   HOUSE ACCOUNT FOLIO BALANCES REPORT                  β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚                       2 Defined Report Sections                        β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1. House Account Folio Balances  β”‚ 2. Balances                         β”‚
β”‚    (Itemized Account Ledgers)    β”‚    (Macro Subledger Roll-Forward)   β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

1. House Account Folio Balances Section (Itemized Account Ledgers)

Details every permanent and temporary house account folio, displaying administrative lifecycles, operating dates, daily debits and credits, and net financial balances.

  • Primary Use: Daily cashiering reconciliation, auditing POS interface postings, managing banquet event deposits, and tracking operator accountability.

  • Key Metrics: House Account Code, House Account Name, Type, Open Date, Close Date, Status, Username, Today's Charges, Today's Payments, Today's Opening Balance, Today's Net Change, Today's Ending Balance, Last Transaction Posted.

Image 8-20-26 at 11.25β€―AM.png
House Account Folio Balances Section

2. Balances Section (Macro Subledger Roll-Forward)

Consolidates the entire property house account subledger into an executive roll-forward control block.

  • Primary Use: Night audit ledger balancing, verifying subledger mathematical integrity, and reconciling house account net positions with the general ledger trial balance.

  • Key Metrics: House Account Opening Balance, Today's Net Change, House Account Closing Balance.

Image 8-20-26 at 11.26β€―AM.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 13 exact dynamic columns available in this report, sorted in alphabetical order by column name:

βš–οΈ Subledger Roll-Forward & 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 net hotel assets (unbilled charges, debit balances owed to the house); negative balances reflect customer deposits, credit adjustments, or unapplied payments held by the property.

  • Section Balancing Parity: In Section 2 (Balances), House Account Opening Balance = Today's Opening Balance and House Account Closing Balance = Today's Ending Balance from Section 1.

Column Name

Section Applicability

Description

Data Source / System Mapping

Includes Taxes & Fees?

Close Date

Section 1

Scheduled expiration date or historical closing date on which the house account was terminated.

House Account Master > Close Date

N/A

House Account Code

Section 1

Unique alphanumeric account code or internal identifier assigned to the house account folio (e.g., POS, OFBRR080149).

House Account Master > Account Code

N/A

House Account Name

Section 1

Descriptive title, department designation, or function name assigned to the house account (e.g., POS House Account (Interface), Loyalty Rewards, Meeting Accounts).

House Account Master > Account Description

N/A

Last Transaction Posted

Section 1

Calendar date and timestamp on which the most recent debit charge, payment credit, or ledger adjustment was posted to the house account.

Folio Subledger > Latest Activity Timestamp

N/A

Open Date

Section 1

Calendar date on which the house account folio was created and activated in the property management system.

House Account Master > Creation Date

N/A

Status

Section 1

Operational lifecycle state of the house account folio (e.g., OPEN, CLOSED).

House Account Master > Operational Status

N/A

Today's Charges

Section 1

Cumulative monetary value of debit transactions (departmental postings, charges, fees) recorded on the house account during the reporting business day.

Folio Subledger > Daily Debit Postings

🟒 Yes

Today's Ending Balance

Section 1

Net closing monetary balance remaining on the house account folio at the end of the reporting business day (Today's Opening Balance + Today's Net Change).

Calculated: Subledger Closing Position

🟒 Yes

Today's Net Change

Section 1

Net difference between daily debit charges and credit payments posted to the account during the reporting business day (Today's Charges - Today's Payments).

Calculated: Daily Activity Movement

🟒 Yes

Today's Opening Balance

Section 1

Net monetary balance brought forward on the house account folio at the start of the reporting business day.

Folio Subledger > Carried Forward Balance

🟒 Yes

Today's Payments

Section 1

Cumulative monetary value of credit transactions (cash, credit card settlements, direct bill transfers, refunds) applied to the house account during the reporting business day.

Folio Subledger > Daily Credit Postings

🟒 Yes

Type

Section 1

Structural classification of the house account determining its operational duration (PERMANENT for perpetual operational clearing accounts or TEMPORARY for short-term events/meetings).

House Account Master > Classification Type

N/A

Username

Section 1

System login identifier or staff name of the employee who created, modified, or administered the house account folio.

Security / User Directory > Operator Name

N/A

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 logical blocks:

    • Section 1: House Account Folio Balances

      • House Account Identifiers & Classification (Cols 1–4): House Account Code | House Account Name | Type | Status

      • Account Lifecycle Window & Staff Accountability (Cols 5–7): Open Date | Close Date | Username

      • Financial Ledger Roll-Forward Sequence (Cols 8–12): Today's Opening Balance | Today's Charges | Today's Payments | Today's Net Change | Today's Ending Balance

      • Audit Activity Timestamp (Col 13): Last Transaction Posted

    • Section 2: Balances

      • Summary Item / Description: House Account Opening Balance | Today's Net Change | House Account Closing Balance

      • Monetary Value / Balance: Corresponds to the property-wide financial values reconciling the house account ledger.

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 attach to internal departmental billing packets, night audit packs, or general ledger journal entry imports.

  • Filtering: Filter data by specific House Account Code, Type, Username, or non-zero Today's Net Change entries.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-value internal charges or house accounts with unexpected credit/debit balances.

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

  • In House Guest Folio Balances – Track daily financial shifts and balances for active in-house guest stays.

  • Group Ledger – Audit daily roll-forward balances for active group master accounts.

  • Closed Folio Balances – Track post-settlement charges, payments, and net changes on closed accounts.

  • Balance Details – Detailed roll-forward tracking starting balances, credits, debits, and ending balances per category.

Cross-Pillar Deep Dives: