Direct Bill Ledger Details .ng
Direct Bill Ledger Details
Report Description: The Direct Bill Ledger Details report provides a comprehensive view of outstanding and settled balances for direct-bill companies. It helps finance, front desk, and accounts teams monitor receivables, invoice aging, and settlements by company, enabling effective credit control, follow-ups, and reconciliation of direct billing activity.
Date Range: One day (historical dates (365-days) up to yesterday’s date)
Available Report Columns for Following Sections:
Accounts Receivables
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Company Name | The name of the company to which the charges are direct billed. | Not Applicable | Not Applicable |
Confirmation Number | The reservation confirmation number associated with the receivable balance. | Not Applicable | Not Applicable |
Guest Name | The name of the guest linked to the direct-bill reservation. | Not Applicable | Not Applicable |
Check In Date | The date the guest checked in for the stay. | Not Applicable | Not Applicable |
Check Out Date | The date the guest checked out of the property. | Not Applicable | Not Applicable |
Current | Outstanding amount that is not yet overdue. | Yes | Not Applicable |
Over 7 | Outstanding amount overdue by more than 7 days. | Yes | =sum(0:7) |
Over 14 | Outstanding amount overdue by more than 14 days. | Yes | =sum(8:14) |
Over 30 | Outstanding amount overdue by more than 30 days. | Yes | =sum(15:30) |
Over 60 | Outstanding amount overdue by more than 60 days. | Yes | =sum(31:60) |
Over 90 | Outstanding amount overdue by more than 90 days. | Yes | =sum(61:90) |
Over 120 Days | Outstanding amount overdue by more than 120 days. | Yes | =sum(91:120) |
Over 150 | Outstanding amount overdue by more than 150 days. | Yes | =sum(121:150) |
Total | The total outstanding receivable amount across all aging buckets. | Yes | Sum of all |
Invoices
Provides a detailed list of invoices by company and aging group that have not been settled.
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Company Name | The company associated with the generated invoice. | Not Applicable | Not Applicable |
Invoice Number | The unique invoice number issued for direct billing. | Not Applicable | Not Applicable |
Current | Invoice amount that is not yet overdue. | Not Applicable | Not Applicable |
Over 7 | Invoice amount overdue by more than 7 days. | Yes | =sum(0:7) |
Over 14 | Invoice amount overdue by more than 14 days. | Yes | =sum(8:14) |
Over 30 | Invoice amount overdue by more than 30 days. | Yes | =sum(15:30) |
Over 60 | Invoice amount overdue by more than 60 days. | Yes | =sum(31:60) |
Over 90 | Invoice amount overdue by more than 90 days. | Yes | =sum(61:90) |
Over 120 Days | Invoice amount overdue by more than 120 days. | Yes | =sum(91:120) |
Over 150 | Invoice amount overdue by more than 150 days. | Yes | =sum(121:150) |
Total | The total invoice amount across all aging buckets. | Yes | Sum of all |
Settlements
Provides a detailed list of applied settlements (payments) by company and aging group.
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Company Name | The name of the company for which settlements have been recorded. | Not Applicable | Not Applicable |
Payment Type | The mode of payment used to settle direct-bill invoices (e.g., bank transfer, cheque). | Not Applicable | Not Applicable |
Current | Settlement amount applied within the current period. | Not Applicable | Not Applicable |
Over 7 | Settlement amount applied against balances overdue by more than 7 days. | Yes | =sum(0:7) |
Over 14 | Settlement amount applied against balances overdue by more than 14 days. | Yes | =sum(8:14) |
Over 30 | Settlement amount applied against balances overdue by more than 30 days. | Yes | =sum(15:30) |
Over 60 | Settlement amount applied against balances overdue by more than 60 days. | Yes | =sum(31:60) |
Over 90 | Settlement amount applied against balances overdue by more than 90 days. | Yes | =sum(61:90) |
Over 120 Days | Settlement amount applied against balances overdue by more than 120 days. | Yes | =sum(91:120) |
Over 150 | Settlement amount applied against balances overdue by more than 150 days. | Yes | =sum(121:150) |
Total | The total settlement amount applied across all aging buckets. | Yes | Sum of all |
Misc Report Information:
Available Features:
Export: ability to download and save the file into an alternate format.
Filter: filter a range of data based on criteria defined by the user.
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
Grouping: ability to view the data grouped by: All or Company Name
Pie Chart: ability to view grouped data in a Pie Chart view.
Available Configuration:
User Preferences: allows the user to customize their report view by repositioning or removing columns.
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.
Baseline Configuration:
Property Preferences Settings:
Following columns to be disabled for initial deployment:
Not Applicable