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