Direct Bill Aging .ng

Direct Bill Aging Report Overview

Parent Hub: πŸ’° Finance & Accounting Reports

Category: πŸ“¬ Billing & Receivables (AR)

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

Key Value: Multi-dimensional accounts receivable credit risk analysis, auditing aged direct bill debt across unbilled folio transfers, finalized client invoices, and unapplied settlements, tracking delinquency across 8 distinct aging buckets (Current, Over 7, Over 14, Over 30, Over 60, Over 90, Over 120 Days, and Over 150), and delivering consolidated portfolio totals by company and transaction stream.

Date Parameter: Single Date Selector | Past & Future (Aging As-Of Cutoff Date)

Executive Summary

The Direct Bill Aging report is the primary credit governance, ledger auditing, and cash flow forecasting document within the πŸ“¬ Billing & Receivables (AR) category of the πŸ’° Finance & Accounting Reports hub. Designed to provide hospitality finance leaders and credit controllers with comprehensive oversight of outstanding city ledger balances, it segments direct billing receivables into their operational components: unbilled folio transfers awaiting formal invoicing, finalized accounts receivable invoices, and unapplied customer settlements.

  • Structured across 5 defined report sections: Accounts Receivables, Invoices, Settlements, Summary By Company, and Totals, this report delivers complete financial visibility across the entire direct billing lifecycle. It maps corporate client profiles (Company Name, Company Code) across high-resolution aging intervals (Current, Over7, Over14, Over 30, Over 60, Over 90, Over 120 Days, Over 150) and cumulative account totals (Total). By isolating unbilled guest folio transfers (Accounts Receivables) from finalized bills (Invoices) and customer payments on account (Settlements), this report enables property accountants to identify billing bottlenecks, prioritize delinquent collections, reconcile unallocated cash, and verify overall city ledger balance sheet integrity.

Key Capabilities

  • Five-Section Direct Bill Lifecycle Governance: Disaggregates accounts receivable into five targeted operational perspectives: unbilled folio transfers (Accounts Receivables), finalized statements (Invoices), unapplied cash deposits (Settlements), gross corporate exposure (Summary By Company), and ledger-wide category summaries (Totals).

  • High-Resolution Aging Granularity: Features an expanded 8-bucket aging distribution incorporating short-term intervals (Over7 and Over14) alongside standard monthly brackets (Current, Over 30, Over 60, Over 90, Over 120 Days, Over 150), providing early warning indicators for corporate billing friction.

  • Unbilled Transfer Bottleneck Detection: Tracks guest folios routed to direct bill that have not yet been compiled into master invoices (Accounts Receivables), preventing delayed invoice delivery to corporate clients.

  • Finalized Invoice Delinquency Monitoring: Audits outstanding generated invoices (Invoices) against agreed payment terms, enabling credit managers to identify aged corporate debt and initiate collection workflows.

  • Settlement & Unapplied Cash Auditing: Identifies unallocated corporate payments, credits, or prepayments (Settlements) that require manual matching against historical debit charges to clear artificially inflated balances.

  • Gross Company Exposure Consolidation: Calculates gross accounts receivable exposure per client (Summary By Company) and verifies the entire property portfolio through macro-level rollups (Totals).

Report Views & Functional Breakdown

The Direct Bill Aging report organizes accounts receivable balances into 5 defined sections:

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚                       DIRECT BILL AGING REPORT                         β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚                       5 Defined Report Sections                        β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1. Accounts Receivables          β”‚ 2. Invoices                         β”‚
β”‚    (Unbilled Folio Transfers)    β”‚    (Finalized Master Bills)         β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 3. Settlements                   β”‚ 4. Summary By Company               β”‚
β”‚    (Unapplied Payments & Credits)β”‚    (Gross Exposure per Corporate AR)  β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 5. Totals (Portfolio Category Summaries & Reconciliation Rollup)       β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

1. Accounts Receivables Section (Unbilled Folio Transfers)

Monitors room, tax, and incidental folios transferred from front desk checkouts to company city ledgers that remain unbilled.

  • Primary Use: Tracking newly transferred guest checkout balances, auditing charges awaiting invoice generation, and identifying delayed billing cycles.

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

Image 8-10-26 at 9.05β€―PM.png
Accounts Receivables Section

2. Invoices Section (Finalized Master Bills)

Details open balances on formally generated accounts receivable invoices issued to corporate accounts.

  • Primary Use: Managing collections, evaluating client payment compliance against contracted payment terms, and calculating aging on billed statements.

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

Image 8-10-26 at 9.07β€―PM.png
Invoices Section

3. Settlements Section (Unapplied Payments & Credits)

Isolates customer payments on account, credit adjustments, and unallocated wire/check deposits.

  • Primary Use: Auditing unapplied customer cash, identifying payments needing manual invoice reconciliation, and reviewing negative credit balances.

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

Image 8-10-26 at 9.09β€―PM.png
Settlements Section

4. Summary By Company Section (Gross Corporate Exposure)

Calculates the consolidated gross direct bill exposure for each company profile by combining unbilled transfers, finalized invoices, and unapplied settlements.

  • Primary Use: Assessing true total corporate liability, monitoring credit limit utilization, and reviewing total client balances for dunning notices.

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

Image 8-10-26 at 9.10β€―PM.png
Summary by Company Section

5. Totals Section (Category Summaries & Reconciliation Rollup)

Rolls up the entire property direct bill ledger into high-level summary lines representing each operational component (Accounts Receivables, Invoices, Settlements) alongside a grand total.

  • Primary Use: Executive controllership reviews, month-end balance sheet reconciliation, and general ledger trial balance verification.

  • Key Metrics: Current, Over 30, Over 60, Over 90, Over 120 Days, Over 150, Total.

Image 8-10-26 at 9.11β€―PM.png
Totals 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 11 exact dynamic columns available across the 5 report sections, sorted in alphabetical order by column name:

πŸ’° Aging Calculation & Financial Balancing Logic:

  • Discrete Aging Buckets: Aging days are calculated as Report As-Of Date - Posting/Invoice Date. Balances are allocated into non-overlapping brackets: Current (0-7 days or 0-30 dayd depending on profile rule), Over7, Over14, Over 30, Over 60, Over 90, Over 120 Days, and Over 150.

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

  • Gross Exposure Parity: In Section 4 (Summary By Company), each corporate client's gross balance equals Accounts Receivables + Invoices - Settlements.

  • Portfolio Rollup: In Section 5 (Totals), the grand total reflects the combined gross asset value of all city ledger receivables across the property.

Column Name

Section Applicability

Description

Data Source / System Mapping

Includes Taxes & Fees?

Company Code

Sections 1, 2, 3, 4

Unique alphanumeric client code or city ledger identifier assigned to the company account (e.g., 539, 225, 01).

Company Master > Company Code

N/A

Company Name

Sections 1, 2, 3, 4

Registered commercial trade name, corporate billing entity, or agency title (e.g., CLC, CRETE CARRIER CORP).

Company Master > Company Legal Name

N/A

Current

All Sections

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

City Ledger > Aging Calculation (Current)

🟒 Yes

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

Severely delinquent 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

Sections 1, 2, 3, 4

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

Sections 1, 2, 3, 4

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

City Ledger > Aging Calculation (8-14d)

🟒 Yes

Total

All Sections

Gross outstanding receivable balance representing the cumulative sum across all aging intervals.

Calculated: Aging Buckets

🟒 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 Context (Cols 1–2): Company Name | Company Code

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

    • Section 2: Invoices

      • Account Context (Cols 1–2): Company Name | Company Code

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

    • Section 3: Settlements

      • Account Context (Cols 1–2): Company Name | Company Code

      • Aging Breakdown & Credit Allocation (Cols 3–11): Current | Over7 | Over14 | Over 30 | Over 60 | Over 90 | Over 120 Days | Over 150 | Total

    • Section 4: Summary by Company

      • Account Context (Cols 1–2): Company Name | Company Code

      • Aging Breakdown & Credit Allocation (Cols 3–11): Current | Over7 | Over14 | Over 30 | Over 60 | Over 90 | Over 120 Days | Over 150 | Total

    • Section 5: Totals

      • Module Classification (Col 1): Module Type (e.g., Accounts Receivables, Invoices, Settlements)

      • Portfolio Aging Rollup (Cols 2–10): Current | Over7 | Over14 | 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.

Advanced Controls

  • Exporting & Report Distribution: Download in Excel or PDF format to distribute collection packets to corporate accounts or audit teams.

  • Filtering: Filter data by specific date ranges, corporate account status, or aging buckets.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight overdue balances exceeding 60 days or accounts with high unbilled receivables.

Within πŸ“¬ Billing & Receivables (AR):

Cross-Pillar Deep Dives:

  • βš–οΈ Ledgers & Trial Balance: To reconcile direct-bill aging totals against general ledger accounts, review Direct Bill Ledger Report.

  • πŸ’³ Payments & Transactions: To inspect corporate check settlements or credit card prepayments, cross-reference Payment Activity 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.