Direct Bill Aging .ng
Direct Bill Aging
Report Description: The Direct Bill Aging report provides a list of companies current balance and if the company has 30, 60, 90, 120 or 150+ past due balance.
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 | Direct bill company name (ex - Jen’s Bakery) | Not Applicable | Not Applicable |
Company Code | Direct bill company code (ex - 5010) | Not Applicable | Not Applicable |
Current | Current outstanding Accounts Receivable balance (0-30 days) | YES | =sum(0:30) |
Over 30 | Current outstanding Accounts Receivable balance (31-60 days) | YES | =sum(31:60) |
Over 60 | Current outstanding Accounts Receivable balance (61-90 days) | YES | =sum(61:90) |
Over 90 | Current outstanding Accounts Receivable balance (91-120 days) | YES | =sum(91:120) |
Over 120 | Current outstanding Accounts Receivable balance (121-150 days) | YES | =sum(121:150) |
Over 150 | Current outstanding Accounts Receivable balance (over 151) | YES | =sum(over 151) |
Total | Total outstanding Accounts Receivable balance across all dates | YES | =sum(current:over 150) |
Accounts Receivable section: total amount due from accounts yet to be invoiced by aging period.
Invoices section: the total amount invoiced but not settled to accounts by aging period.
Settlement section: the total amount settled to accounts by aging period.
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