Summary Age Analysis
About Aging
The Age Analysis Summary and Age Analysis Detail reports provide the primary means by which carrier/dealer account balances and aging amounts can be reviewed (aging can also be viewed in Route Service). The total account balance will be divided into as many as 12 aging periods, including the current aging period.
Note: Business Rules govern whether aging is based on days past due, periods past due, or the Aging Calendar. Business Rules also determine whether credit memos and unapplied payments should be aged.
Aging periods can be based on:
Billing periods (see Bill Period in the Setup Manual). If aging is based on billing periods, an account charge will be in the current billing period from the time it is billed to the next billing date; then it will move to period 1. It will move to period 2 on the billing date after that, and so on.
The Aging Calendar (see Aging Calendar in the Setup Manual). If aging is based on age periods, an account charge will be in the current aging period from the time it is billed to the next aging date; then it will move to period 1. It will move to period 2 on the aging date after that, and so on.
A user-defined number of days (see Age Period in the Setup Manual). If aging is based on a user-defined number of days, a charge will be in the current aging group for the number of due days allowed in the carrier’s account terms (see Terms in the Setup Manual). After this, the charge will move to aging group 1 for the number of days defined for the first aging group, and so on.
For example, say an account draw charge of 160.00 is billed on 05/31, and the number of due days is 15 (or the 15th of the month). Also assume the paper bills again on 6/30. If aging is done by billing period, and the carrier does not pay this charge, it will be in the current aging group from 5/31 to 6/29, and will move to aging group 1 on 6/30. If aging is done by a user-defined number of days, and each aging group is, say, 20 days, the charge will be in the current aging group for 15 days (5/31- 6/14) and be in aging group 1 for 20 (6/15 - 7/4).
Creating the Age Analysis Summary Report
The Age Analysis Summary report provides a summary of account aging. Individual charges and credits are not shown, only totals for each aging period.
To produce this report:
Select Summary Age Analysis from the Management menu to display the Age Analysis–Summary window.
Click Add and complete the following fields.
Field Type What to enter COMPANY
setup
Enter the company for which to run the aging report (enter “*” to select all companies).
BILL SOURCE
setup
Enter the bill source for which to run the report (enter “*” to select all bill sources).
AGING DATE
date
Enter the date on which the aging should be based.
SELECTION TYPE
predefined
Indicate whether this report should include one or more district, zone, region, or area, or account.
SELECTION
setup
Enter a particular district, zone, region, or area (depending on the selection type entered above) to include in the report, or enter “*” to multi-select. If Selection Type is “Account”, enter the account ID of the carrier/dealer for whom you are running the report, or enter “*” to include all accounts.
SELECT BY
predefined
Indicate whether this report should further select by route type, account class, account group, or collector. If not, select all in this field.
SELECTION
setup
If you entered “all” in Select By, this field will be skipped. Otherwise, enter one or more route types, account classes, account groups, or collectors, depending on what you entered in Select BY. Use * to multi-select.
DEMOGRAPHIC
setup
If you selected account class or account group in Select By, you will be able to select a single account demographic.
ANSWER
setup
Enter a valid answer to the demographic question selected.
AGING CRITERIA
predefined
Enter one of the following to indicate the aging period or type of content that is to appear in the report: All aging periods 1st aging period 2nd aging period 3rd aging period 4th aging period 5th-8th periods 9th-12th periods Unapplied payments
BALANCE TYPE
predefined
Select the type of balance to include in the report: credit, debit, or both.
BALANCE MINIMUM
decimal
If you selected a balance type of “credit” or “debit”, enter the minimum balance an account must have to be selected for the report.
PERIODS TO DISPLAY
open (2)
Enter the number of age periods to display on the report (between 4 and 12).
ZERO BALANCE ACCOUNTS
yes/no
Indicate whether to include zero balance accounts in the report.
SORT BY
predefined
Indicate whether the report should sort by account or name (alphabetical) within the sort area defined above.
GENERATE TASKS
yes/no
Select this checkbox to generate event tasks for qualifying accounts when running this report. Note: Event tasks must be set up previously.
EXPORT
yes/no
Select this checkbox if you want to create an export file.
FILE FORMAT
setup
Select the file map to use for this export. A file map must be set up previously.
FILE NAME
open
You can accept the default file name or modify it.
Click OK and then Continue to produce the report.
Example—Summary Age Analysis Report
Last updated
