You are here: Reports > Aging Report

AGING REPORT
Function
To provide an analysis of the portfolio quality as it relates to current and delinquent loans.

Operating Instructions

Cutoff Date                
This date defaults to the current date but may be changed by selecting from the calendar.  The cutoff date will determine which activity will be included in the report.  Any recorded activity with an activity date beyond the cutoff date will not be included in the calculations. 

Loan Number           
The screen will automatically default to include all loans found within the database.  You may override the selection by either entering the loan # or selecting from the combo box.  To narrow the selection to only one loan, enter or select from the combo box,  the appropriate loan number in both the beginning field and the “to” field. 

Sort Options              
Using the combo box, select the order in which the data is to appear.  Selections include: 

#Loan Number

A Alphabetical

$Loan Amount 

Loan Officer

Payment Due Date
You may also enter #, A, or $ if do not wish to utilize the combo box. If the sort is to be by Loan Amount, it will be based on the amount in the Loan Master file, Loan Terms tab, Loan Amount field. This does not always match the dollars disbursed. Sorting by Loan Officer will insert a page break between each Officer. Sorting by Payment Due Date will separate loans according to their due date.

Selection Criteria     
Options for narrowing selection criteria include: 

Fund 

County 

City 

Status 

Loan Officer 

Loan Type

Borrower Type
The following instructions relate to limiting the search to specific Fund(s), and the same instructions apply to each of the potential criteria above.

If you do not wish to include all loans, click on the “funds” tab.  All existing funds will be displayed for your selection.  To select a fund, move the cursor to the fund to be included and click – it will then be highlighted, indicating loans with that fund are to be included on the report.  If you wish to include more funds, hold down the Ctrl key and click on the additional fund to be included.  If you select a fund by mistake, hold down the Ctrl key and click on the fund again – the highlighting will disappear, indicating it no longer is to be included in the selection criteria.  Continue this process until you have narrowed the search to include only those loans you wish to review.

Include Active $0.00 Balance Loans

Checking this box will cause all Active Status loans to print, regardless of balance. 

Include Borrower Name:
Removing the checkmark will generate a report without the borrower’s name included. Only the borrower’s Loan ID will appear on the report to assist in identifying the loan.

Interpreting the Aging Report
At the top of the report, you will find the selection criteria, including cutoff date, as entered.  The date and time of the report is also included.

Loan                           
Reflects the number associated with each loan. 

Company/Borrower  
If the Loan Master file contains information found under “Company Loan Information” the company name as entered will appear.  If the Loan Master file contains information under “Personal Loan Information” the first and last name of the borrower will appear.

Loan Amount            
This is the number listed under Loan Amount within the Loan Master file.

Disbursed                  
Reflects the total amount disbursed to the loan as of the cutoff date. 

Current Balance       
Reflects the loan balance as of the last recorded activity prior to the cutoff date. 

Regular Payment     
The Loan Master file, Loan Terms field titled Payment including Service Fees and Escrows is shown here.

Analysis of Payments Due:

1 payment – if any loan is delinquent by a minimum of one payment, that payment amount will be reflected in this column

2 payments – if any loan is delinquent by a minimum of two payments, the second payment amount will be reflected in this column.

3 payments – if any loan is delinquent by a minimum of three payments, the third payment amount will be reflected in this column.

Over 3 – if any loan is delinquent by a minimum of four payments, the total of the payments beyond three payments delinquent will be reflected in this column.

Total Due                  
The amounts in Analysis of Payment Due columns are totaled into this column. 

Late Days                  
Calculated as the days between the date the next payment was due and the cutoff date. 

Total Delinquent Dollars                       
If any loans are found delinquent, the current balances for those loans are added together and listed under the appropriate column.

Percent Delinquent
The total loan portfolio balance is divided by the “Total Delinquent Dollars” to create a percentage. 

Things You Should Know
  • This report may be produced as often as desired with no consequence to the database. 
  • If the Maturity Date found within the Loan Master file has passed, the entire loan balance is considered due. 
  • If the selection criteria is narrowed for any option, it is important to select “Clear Selections” before beginning again.  Another option for clearing selection criteria is to “Exit” the report screen and then select “Aging Report” once again from the Report Menu. 
  • Once the report is displayed on-screen, it may be sent to a printer or exported to a file by clicking on the appropriate icon on the top task bar.