Direct Bill Ledger Details .ng

Direct Bill Ledger Details Report Overview

Parent Hub: πŸ’° Finance & Accounting Reports

Category: βš–οΈ Ledgers & Trial Balance / πŸ“¬ Billing & Receivables (AR)

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

Key Value: Granular city ledger subledger reconciliation, auditing individual direct-billed transactions across unbilled guest folio transfers, finalized commercial invoices, and unapplied payments on account, categorized across an expanded 8-tier aging distribution (Current through Over 150 Days).

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

Executive Summary

The Direct Bill Ledger Details report is the foundational subledger audit, transaction tracing, and credit governance document within the βš–οΈ Ledgers & Trial Balance category of the πŸ’° Finance & Accounting Reports hub. Designed to establish complete transparency over the property's city ledger receivables, it itemizes every direct-billed balance by tracing its exact operational originβ€”separating unbilled checkout folio transfers awaiting statement compilation from finalized accounts receivable invoices and unapplied corporate payments on account.

  • Structured across three defined report sections: Accounts Receivables, Invoices, and Settlements, this report provides complete financial traceability from macro-level trial balance control figures down to individual guest stay transactions. It maps corporate client profiles (Company Name) alongside guest stay attributes (Confirmation Number, Guest Name, Check In Date, Check Out Date), formal billing keys (Invoice Number), and tender methods (Payment Type, e.g., CHECK, CREDIT CARD) across high-resolution aging intervals (Current, Over7, Over14, Over 30, Over 60, Over 90, Over 120 Days, Over 150) and cumulative row totals (Total). By isolating unbilled guest checkout lines from formal master invoices and unallocated corporate deposits, this report equips accounting teams to identify billing bottlenecks, reconcile city ledger subledger variances against general ledger trial balances, expedite cash application, and prevent uncollected debt accumulation.

Key Capabilities

  • Three-Tier City Ledger Subledger Architecture: Disaggregates property direct billing receivables into three targeted operational components: unbilled front desk folio transfers (Accounts Receivables), finalized master statements (Invoices), and unapplied corporate payments on account (Settlements).

  • High-Resolution Short- and Long-Term Aging: Features an expanded 8-bucket aging matrix incorporating weekly short-term brackets (Over7 and Over14) alongside standard monthly intervals (Current, Over 30, Over 60, Over 90, Over 120 Days, Over 150), providing early visibility into delinquent accounts.

  • Unbilled Transfer Verification: Itemizes guest folios routed to direct bill that have not yet been compiled into master accounts receivable invoices (Accounts Receivables), capturing guest names (Guest Name), stay windows (Check In Date, Check Out Date), and central confirmation codes (Confirmation Number).

  • Finalized Invoice Delinquency Monitoring: Audits open balances on officially generated direct billing statements (Invoices), displaying individual invoice identifiers (Invoice Number) and aging maturity.

  • Settlement & Payment Application Auditing: Details unapplied payments on account, advance corporate deposits, and unallocated wire/check receipts (Settlements), logging specific tender types (Payment Type) to facilitate matching against open debit invoices.

  • Subledger-to-General-Ledger Balancing: Provides Section summary totals (Total) across all three operational streams, allowing controllers to verify that Net City Ledger Balance = Accounts Receivables + Invoices - Settlements.

Report Views & Functional Breakdown

The Direct Bill Ledger Details report organizes city ledger accounts receivable into three defined sections:

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚                   DIRECT BILL LEDGER DETAILS REPORT                    β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚                       3 Defined Report Sections                        β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1. Accounts Receivables          β”‚ 2. Invoices                         β”‚
β”‚    (Unbilled Folio Transfers)    β”‚    (Finalized Master Statements)    β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 3. Settlements (Unapplied Corporate Payments & Advance Credits)        β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

1. Accounts Receivables Section (Unbilled Folio Transfers)

Itemizes individual guest checkout folios transferred to direct billing that remain pending on the ledger without a formal master invoice number.

  • Primary Use: Tracking newly transferred guest checkouts, auditing unbilled balances by stay dates, and identifying delayed corporate billing cycles.

  • Key Metrics: Company Name, Confirmation Number, Guest Name, Check In Date, Check Out Date, Current, Over7, Over14, Over 30, Over 60, Over 90, Over 120 Days, Over 150, Total.

Image 8-13-26 at 2.36β€―PM.png
Accounts Receivables Section

2. Invoices Section (Finalized Master Statements)

Itemizes all officially generated accounts receivable invoices issued to corporate accounts, tracking open balances across aging brackets.

  • Primary Use: Monitoring invoiced debt, evaluating corporate payment performance against contractual credit terms, and prioritizing delinquent collections.

  • Key Metrics: Company Name, Invoice Number, Current, Over7, Over14, Over 30, Over 60, Over 90, Over 120 Days, Over 150, Total.

Image 8-13-26 at 2.40β€―PM.png
Invoices Section

3. Settlements Section (Unapplied Corporate Payments & Advance Credits)

Details unapplied customer check, credit card, and electronic fund payments held on account.

  • Primary Use: Auditing unallocated cash receipts, identifying payments requiring manual invoice matching, and reconciling credit balances.

  • Key Metrics: Company Name, Payment Type, Current, Over7, Over14, Over 30, Over 60, Over 90, Over 120 Days, Over 150, Total.

Image 8-13-26 at 2.42β€―PM.png
Settlements 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 16 exact dynamic columns available across the three report sections, sorted in alphabetical order by column name:

βš–οΈ City Ledger Aging & Balancing Logic:

  • Aging Calculation: Elapsed maturity is calculated as Report As-Of Date - Posting/Invoice Date. Balances are allocated into mutually exclusive brackets: Current (0-7 days), Over7 (8-14 days), Over14 (15-30 days), Over 30 (31-60 days), Over 60 (61-90 days), Over 90 (91-120 days), Over 120 Days (121-150 days), and Over 150 (>150 days).

  • Line-Item Total: For each record, Total = Current + Over7 + Over14 + Over 30 + Over 60 + Over 90 + Over 120 Days + Over 150.

  • Net Ledger Exposure: The net asset value of the city ledger control account is derived as Section 1 (Accounts Receivables) + Section 2 (Invoices) - Section 3 (Settlements).

Column Name

Section Applicability

Description

Data Source / System Mapping

Includes Taxes & Fees?

Check In Date

Section 1

Calendar arrival date of the guest stay associated with the direct-billed folio transfer.

Reservation Engine > Arrival Date

N/A

Check Out Date

Section 1

Calendar departure date of the guest stay associated with the direct-billed folio transfer.

Reservation Engine > Departure Date

N/A

Company Name

All Sections

Registered commercial entity, corporate direct billing account, or agency title associated with the transaction.

Company Master > Company Legal Name

N/A

Confirmation Number

Section 1

Primary central reservation system (CRS) or PMS reservation confirmation number linked to the direct-billed folio.

Reservation Engine > Confirmation ID

N/A

Current

All Sections

Outstanding direct bill balance aged within the baseline current operating billing window (0-7 days).

City Ledger > Aging Calculation (Current)

🟒 Yes

Guest Name

Section 1

Full legal name of the registered guest whose stay charges were transferred to the city ledger direct bill account.

Guest Profile > Full Name

N/A

Invoice Number

Section 2

Unique master system accounts receivable invoice number assigned to the direct billing statement.

AR Invoicing Engine > Master Invoice ID

N/A

Over 120 Days

All Sections

Direct bill receivable balance aged between 121 and 150 calendar days from the transaction or invoice date.

City Ledger > Aging Calculation (121-150d)

🟒 Yes

Over 150

All Sections

Direct bill receivable balance aged beyond 150 calendar days from the transaction or invoice date.

City Ledger > Aging Calculation (>150d)

🟒 Yes

Over 30

All Sections

Direct bill receivable balance aged between 31 and 60 calendar days from the transaction or invoice date.

City Ledger > Aging Calculation (31-60d)

🟒 Yes

Over 60

All Sections

Direct bill receivable balance aged between 61 and 90 calendar days from the transaction or invoice date.

City Ledger > Aging Calculation (61-90d)

🟒 Yes

Over 90

All Sections

Direct bill receivable balance aged between 91 and 120 calendar days from the transaction or invoice date.

City Ledger > Aging Calculation (91-120d)

🟒 Yes

Over14

All Sections

Direct bill receivable balance aged between 15 and 30 calendar days from the transaction or invoice date.

City Ledger > Aging Calculation (15-30d)

🟒 Yes

Over7

All Sections

Direct bill receivable balance aged between 8 and 14 calendar days from the transaction or invoice date.

City Ledger > Aging Calculation (8-14d)

🟒 Yes

Payment Type

Section 3

Financial settlement method utilized for corporate payments on account (e.g., CHECK, CREDIT CARD, EFT, WIRE).

AR Cashiering > Settlement Method

N/A

Total

All Sections

Net cumulative direct bill monetary value representing the total balance across all aging intervals.

Calculated: Cumulative Aging Sum

🟒 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: Accounts Receivables

      • Account & Stay Context (Cols 1–5): Company Name | Confirmation Number | Guest Name | Check In Date | Check Out Date

      • Aging Breakdown & Balances (Cols 6–14): Current | Over 7 | Over 14 | Over 30 | Over 60 | Over 90 | Over 120 Days | Over 150 | Total

    • Section 2: Invoices

      • Invoice Identifiers (Cols 1–2): Company Name | Invoice Number

      • Aging Breakdown & Balances (Cols 3–11): Current | Over 7 | Over 14 | Over 30 | Over 60 | Over 90 | Over 120 Days | Over 150 | Total

    • Section 3: Settlements

      • Settlement Identifiers (Cols 1–2): Company Name | Payment Type

      • Aging & Payment Credit Allocation (Cols 3–11): Current | Over 7 | Over 14 | Over 30 | Over 60 | Over 90 | Over 120 Days | Over 150 | Total

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.

Image 9-29-26 at 12.53β€―PM.png

Group By

Summarize and group report data dynamically in real time.

Interactive Visualizations & Grouping Controls

  • Group By & Pie Chart Visualization: The Direct Bill Ledger Details report features an interactive pie chart to analyze direct bill balances and aging distributions across corporate accounts. Users can group line items on the fly by Company Name (across Accounts Receivables, Invoices, Settlements) to review aggregate balances. By selecting a metric from the Select Base Column dropdown menuβ€”such as Current balances or aging thresholds like Over 30, Over 60, or Over 120 Daysβ€”the chart dynamically displays percentage share breakdowns accompanied by a color-coded company legend.

Image 8-13-26 at 2.43β€―PM.png
Group By & Pie Chart Visualization

Advanced Controls

  • Exporting & Audit Delivery: Download in Excel or PDF format to attach line-item stay proof to outgoing corporate statements or collection notices.

  • Filtering: Filter data by specific Company Name, Payment Type, or Invoice Number.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight overdue invoice line items (Over 60 > $0.00) or high-value unbilled reservations.

Within βš–οΈ Ledgers & Trial Balance & πŸ“¬ Billing & Receivables (AR):

Cross-Pillar Deep Dives:

  • πŸ’³ Payments & Transactions: To inspect corporate checks, wire receipts, or credit card processing gateway logs, cross-reference Payment Activity Report.

  • πŸ›οΈ Taxes & Expenses: To verify tax calculation rules applied to direct-bill charges, review Active Taxes and Charge Types 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.