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 (
Over7andOver14) 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.
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.
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.
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.
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.
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, andOver 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., |
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., |
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 |
|
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 & 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.
π Related Reports & Next Steps
Within π¬ Billing & Receivables (AR):
-
Accounts Receivable Activity Report β Audit line-item transaction entries hitting the direct-bill ledger.
-
AR Invoice Aging Report β Categorize open invoice balances across 30-day time bands.
-
Direct Bill Reconciliation Report β Identify payment gaps and verify guarantee statuses for corporate invoicing.
-
Customer Statement Report β Generate client-facing statements with invoice details and remittance bank info.
-
Invoice Details Report β Detailed lifecycle tracking of every generated invoice.
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.