To open the Loan Contractual Overdue Report, from the Report menu, click Report Explorer and select the Loan Reports group.

Select the Order By and Accounts to show

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 accounts to be included or leave blank for all accounts.

Use F6 to Lookup Accounts

Date As At

Select or enter a date. The Date 'As At' is used when calculating values such as Monitor Categories, Balance and Overdues.

Select Columns to include

Columns

Tick to include columns and corresponding information required for the report; leave blank to not include this information.

Select sections to include

Clients

Tick to include Client details. The detail included is determined by the "Display" option selected.

Display

Select from:

Standard - shows minimal Client detail, e.g. Client Number and Client Name.
Standard (Notes Single Line) - as per Standard, however the "Notes" column is restricted to one line.
Detail - shows detail for the Client, including Address and Date of Birth.
Detail (Notes Single Line) - as per Detail, however the "Notes" column is restricted to one line.

The information in the "Notes" column comes from the Account, Client Page, Notes entered against the Client information.

Overdue Payments

Tick to include a breakdown of overdue instalments.

Overdue Days/Dollars - The number of days between the oldest overdue transaction as at a date and the as at date.
Overdue transactions are calculated based upon the overdue balance as at the date, and working back through transaction overdues until this balance is paid off.
Transaction overdues are calculated based upon allocation rules. Payments falling due add to the overdue balance, as is any transaction that is defined as being due immediately, e.g. an ad-hoc fee charged during the term ; of the Loan.
Payment transactions can be manually overridden, but if left to automatically allocate are paid from the balance of Interest Bearing Fees, Non-Interest Bearing Fees, Interest, Interest Bearing Principal and finally Non-Interest Bearing Principal.
Additionally Overdue transactions can factor in a small balance threshold. If the oldest transaction is less than the threshold it is combined into the next oldest transaction and so on until the oldest overdue transaction is equal to or greater than the threshold.

See Topics, for more information about Account Filters, Ranges, Grouping, Printer, Data Export, Add to Queue and Settings.

Reports, Loan Reports, Loan Contractual Overdue Report