Reports, Loan Reports, Loan Interest Rate Variance List
|

To open the Loan Interest Rate Variance List Report, from the Report menu, click Report Explorer and select the Loan Reports group.

Report

DescriptionThe Loan Interest Rate Variance List displays Fixed Term Floating Rate and Revolving Credit Accounts and their potential variance.
PurposeTo compare the Account base rate against the Account Type or benchmark rate to highlight any Variances that have been excluded from the Floating Rate Change Wizard.


Reports, Loan Interest Rate Variance List

Select the Order By and Accounts to show

Order By

Select the order in which the report is to appear, by Code or Name.

Descending

Tick to display in a descending order or leave blank to display in an ascending order.

Accounts

Select the Account to be included or leave blank to include all.

Alternatively use F6 to look up Accounts.

Account Type

Select the Account Type to be included or leave blank to include all.

Alternatively use F6 to look up Account Type.

Date As At

Enter the date the report will be calculated "to"; used when calculating values such as Balance.

Rate

Enter a rate to check the Variance against a benchmark Interest rate, alternatively leave blank to check against the Account Type's Interest rate.

Include All Accounts

Tick to display All Accounts with or without a Variance.

Variance

Enter a Variance percentage to include Accounts above the value defined.