Direct Bill Aging .ng
Direct Bill Aging
Report Description: The Direct Bill Aging report provides real-up-to-date details on accounts receivable activity, invoice activity and settlement activity. This report categorizes activity by how long they have been aging in 30-day intervals.
Date Range: Current day and up to 365 days in the past
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Company Name | Local direct bill company name on the reservation. | Not Applicable | Not Applicable |
Company Code | Local direct bill company code (ex - 5010). | Not Applicable | Not Applicable |
Current | Current balance aged between 0 and 7 days. | YES | current = (all charges + taxes) - (adjustments) |
Over 7 | Balance aged between 8 and 14 days. | YES | Over 7 = (all charges + taxes) - (adjustments) |
Over 14 | Balance aged between 15 and 30 days. | YES | Over 14 = (all charges + taxes) - (adjustments) |
Over 30 | Balance aged between 31 and 60 days. | YES | Over 30 = (all charges + taxes) - (adjustments) |
Over 60 | Balance aged between 61 and 90 days. | YES | Over 60 = (all charges + taxes) - (adjustments) |
Over 90 | Balance aged between 91 and 120 days. | YES | Over 120 = (all charges + taxes) - (adjustments) |
Over 120 | Balance aged between 121 and 150 days. | YES | Over 120 = (all charges + taxes) - (adjustments) |
Over 150 | Balance aged 151+ days. | YES | Over 151 = (all charges + taxes) - (adjustments) |
Total | Total balance across all aging periods for the company. | YES | Total = (sum of all balances current:over 150) |
Accounts Receivable section: Total amount un-invoiced by the company, categorized by aging period.
Invoices section: Total invoiced amount not yet settled, broken down by aging period for the company.
Settlement section: the total amount settled by aging period for the company.
Totals section: summary of total amounts for Accounts Receivables, Invoices and Settlements by aging period.
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.
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