Report
| Description |
The Loan Aged Overdue Report lists the overdue payments due at various date intervals. It calculates the actual overdue amount "as at" the date of the Report based on the Payment Schedule and takes into account any special repayment arrangements. Payments are not overdue until the day after the payment is due, therefore, if a payment is due on the 16th of August then it is "Overdue" on the 17th of August. |
| Purpose | Normally generated on an ad hoc basis, to identify the payments which make up the total amount owing on overdue accounts. |
Order By
Select the order in which the report is to appear, by Code, Name, Date Opened, Date Quoted, Overdue, Overdue Days, Contractual Overdue, Contractual Overdue Days, Balance, Next Payment Date, Last Payment Date or Maturity Date.
Descending
Tick to display in a descending order or leave blank to display in an ascending order.
Accounts
Select the Accounts to be included or leave blank to include all.
Date As At
Enter the date the report will be calculated "to". The 'As At' Date is used when calculating values such as Monitor Categories, Balance and Overdues.
Frequency
Select Frequency for the report, by Daily, Weekly, Fortnightly, 4 Weekly, 30 Days, Monthly, EOM (End of Month), 2 Months, Quarterly, 6 Months, or Yearly. The frequency is not limited to the list shown, it can be any valid date cycle, e.g. M20 for 20th of the month.
Alternatively click here for more examples of Date Expressions.
Show Value
Select the order in which a report is to appear, by Overdue, Count, Balance, Contractual Overdue, Count (Contractual Overdue), or Balance (Contractual Overdue).
Columns
Select the number of "Columns" for the report, e.g. 1 to 99. Any number of columns selected over 12 will not display well on a Preview and is instead designed for the report to be exported.
Columns
Tick the applicable boxes to include any columns required for the report. Leave blank if not required.