Balance Details .ng | HotelKey Knowledge Base

Balance Details Report Overview

Parent Hub: 💰 Finance & Accounting Reports

Category: ⚖️ Ledgers & Trial Balance

Target Roles: Directors of Finance & Controllers, Night Auditors, Accounting Managers & Clerks

Key Value: Provide a comprehensive financial ledger roll-forward across all property ledgers, tracking starting balances, credits, debits, and ending balances to pinpoint discrepancies and tie out period-end financials.

Executive Summary

The Balance Details Report is a core financial reconciliation and trial balance tool within the ⚖️ Ledgers & Trial Balance module. Designed for rigorous financial auditability, it functions as a comprehensive ledger roll-forward that tracks every revenue, tax, payment, and ledger shift across the property during the operational day.

By mapping financial movements across primary property ledgers (HOTEL BALANCE, IN HOUSE, HOUSE ACCOUNT, CLOSED FOLIO, ADVANCE DEPOSIT, DIRECT BILL) and breaking them down by specific Transaction Category (REVENUE, TAXES, PAYMENTS) and Transaction Type (ROOM RENT, City Tax, CREDIT CARD, CASH), this report equips finance teams to audit daily debits and credits, pinpoint ledger discrepancies, and tie out period-end trial balances with zero variance.

Key Capabilities

Complete Ledger Roll-Forward: Tracks strict mathematical continuity: $\text{Starting Balance} + \text{Credits} - \text{Debits} = \text{Ending Balance}$ across all primary property ledgers.
Granular Charge & Tax Itemization: Isolates individual revenue streams (ROOM RENT, FOOD, Onsite Parking, Club Lounge) and statutory tax collections (City Tax, Sales tax, State Tax).
Tender & Shift Reconciliation: Audits payment disbursements across cash and credit card processing gateways to ensure cashier drawers and batch settlements balance against ledger entries.

Report Views & Functional Breakdown

The Balance Details Report presents daily financial activity across three structured analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                        BALANCE DETAILS REPORT                          │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Ledger Roll-Forward   │ 2. Category & Revenue    │ 3. Tender &      │
│    Summary               │    Breakdown             │    Settlement    │
│                          │                          │    Audit         │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Ledger Roll-Forward Summary

Provides a macro-level trial balance summary tracking overall property health and net balances across primary operational ledgers.

Primary Use: Verifying night audit trial balances and ensuring the overarching hotel balance equals the sum of all sub-ledgers.
Key Metrics: Primary Ledger Type (HOTEL BALANCE, IN HOUSE, HOUSE ACCOUNT, CLOSED FOLIO, ADVANCE DEPOSIT, DIRECT BILL), Starting Balance, Credits, Debits, Ending Balance.

2. Category & Revenue Breakdown

Isolates daily financial movements categorized strictly by transaction classification (REVENUE, TAXES) and specific posting codes.

Primary Use: Auditing daily departmental room and ancillary earnings, verifying tax accrual accuracy, and tracking charge adjustments.
Key Metrics: Transaction Category (REVENUE, TAXES), Transaction Type (ROOM RENT, FOOD, BREAKFAST, City Tax, Sales tax, State Tax), Credits, Debits.

3. Tender & Settlement Audit

Captures all payment tender methods applied across active guest folios, house accounts, and settled closed folios.

Primary Use: Reconciling front desk cash drops, balancing credit card gateway settlements, and verifying city ledger direct-bill postings.
Key Metrics: Transaction Category (PAYMENTS, SETTLEMENT PAYMENTS), Transaction Type (CREDIT CARD, CASH, ACCOUNT RECEIVABLE), Debits (Applied Payments).

Image 8-13-26 at 10.58 AM.png — Balance Details Report

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary available for this report:

💡 Tax Treatment Note: Base revenue charges (ROOM RENT, FOOD, Club Lounge, etc.) represent net amounts exclusive of taxes. Total ledger roll-forward balances (HOTEL BALANCE, IN HOUSE, CLOSED FOLIO, DIRECT BILL) represent gross figures reflecting all applied charges, taxes, and payments.

Column Name	Description	Data Source / System Mapping	Includes Taxes & Fees?
Type	Primary property ledger or system line-item classification.	System Ledger Engine	N/A
Transaction Category	Macro financial category (REVENUE, TAXES, PAYMENTS, SETTLEMENT PAYMENTS).	System Ledger Classification	N/A
Transaction Type	Specific charge, tax, or payment posting code (e.g., ROOM RENT, Sales tax, CASH).	Transaction Code Configuration	N/A
Starting Balance	Ledger balance at the beginning of the operational business day.	Prior Day Closing Balance	🟢 Yes
Credits	Total financial increases or revenue/tax charges applied during the day.	`SUM(Day's Charges & Accruals)`	❌ No
Debits	Total financial reductions or payment settlements applied during the day.	`SUM(Day's Payments & Adjustments)`	❌ No
Ending Balance	Net calculated ledger balance at business day close.	`Starting Balance + Credits - Debits`	🟢 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 3 logical blocks:
- Account & Transaction Hierarchy (Cols 1–3): Type | Transaction Category | Transaction Type
- Activity & Ledger Movements (Cols 4–5): Credits | Debits
- Balance Flow & Audit Totals (Cols 6–7): Starting Balance | Ending Balance

Advanced Controls

Exporting & Audit Delivery: Download in Excel or PDF format to support end-of-month general ledger tie-outs or external accounting audits.
Filtering: Filter data by specific Transaction Category, Primary Ledger, or date range.
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight ledger variances, negative starting balances, or high-value payment tenders.

Within ⚖️ Ledgers & Trial Balance:

Trial Balance Report – Translate daily property activity into strict General Ledger (GL) asset, liability, income, and expense accounts.
Closed Folio Balances Report – Track daily financial shifts and net changes on settled post-departure accounts.
Day End Summary Report – Review consolidated revenue, tax, and payment blueprints at the close of the business day.
Direct Bill Ledger Details Report – Deep-dive into unbilled corporate balances, aging invoices, and applied settlements.

Cross-Pillar Deep Dives:

📬 Billing & Receivables (AR): To audit outstanding city ledger invoices and corporate aging buckets, review AR Invoice Aging Report or Accounts Receivable Activity Report.
💳 Payments & Transactions: To inspect cashier shift drops or credit card processing gateway logs, cross-reference Control Report or All Transactions 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.