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 (
Over7andOver14) 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.
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.
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.
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), andOver 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., |
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 |
|
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. |
|
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.
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.
π Related Reports & Next Steps
Within βοΈ Ledgers & Trial Balance & π¬ Billing & Receivables (AR):
-
Direct Bill Aging Report β Review company-level direct bill summaries across Accounts Receivables, Invoices, Settlements, and Totals.
-
Direct Bill Reconciliation Report β Compare total charges against total payments for corporate stays to spot payment gaps.
-
Accounts Receivable Activity Report β Audit every line-item transaction hitting the direct-bill ledger.
-
AR Invoice Aging Report β Categorize open invoice balances across 30-day time bands.
-
Customer Statement Report β Generate client-facing statements with invoice details and bank remittance info.
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.