Navigation: Loans > Loan Screens > Account Information Screen Group > Account Detail Screen > Statistics tab > Average Balances tab >
Average Balances list view
The list view on the Average Balances tab displays information pertaining to a loan for the current year and the prior two years. Information for the current year is "year-to-date," while information for the past two years covers the period of January 1 through December 31 for each year.
Information is displayed according to field information available. Clicking on the column headings will sort the columns in ascending or descending numerical or alphabetical order for that category.
This information is for display only and cannot be changed from this tab.
This list view displays the following averages:
Row |
Description |
---|---|
Interest Accrued |
This row displays the total interest accrued year-to-date and for the prior two years. The current year column for this field will be increased each day by the daily interest accrual amount (per diem).
For weekends and holidays in the same month, the system calculates the information on the previous run date. If you process afterhours on Saturday, then Saturday night it will calculate Sunday’s information, and Monday morning you will have the correct amount.
If a weekend or holiday crosses monthend, the calculation will not be processed until the night of the first business day following. |
Interest Paid |
This row displays the total interest paid year-to-date and for the prior two years. The current year column for this field will be updated at monthend. |
Fees Assessed |
This row displays the total fees assessed year-to-date and for the prior two years. At monthend, the system reads history for the month, looking for tran codes 660 (Assess Miscellaneous Fee) and 668 (Assess Miscellaneous Fee Correction). It then totals the monthly transaction amounts and updates the current year column by that amount. |
Fees Paid |
This field displays the total fees paid year-to-date and for the prior two years.
At monthend, the system reads history for the month, looking for tran codes 850 (Pay Loan Fees) and 858 (Pay Loan Fees Correction). It then totals the monthly transaction amounts and updates the current year column by that amount. |
Fees Waived |
This field displays the total fees waived year-to-date and for the prior two years.
At monthend, the system reads history for the month, looking for tran codes 670 (Waive Miscellaneous Fee) and 678 (Waive Miscellaneous Fee Correction). It then totals the monthly transaction amounts and updates the current year column by that amount. |
Late Charges Assessed |
This field displays the total late charges assessed year-to-date and for the prior two years.
At monthend, the system reads history for the month, looking for tran codes 560 (Assess Late Charge) and 568 (Assess Late Charge Correction). It then totals the monthly transaction amounts and updates the current year column by that amount. |
Late Charges Paid |
This field displays the total late charges paid year-to-date and for the prior two years.
At monthend, the system reads the history for the month, looking for tran codes 550 (Pay Late Charge), 558 (Pay Late Charge Correction), 600 and 690 (Loan Payment), and 608 and 698 (Loan Payment Correction). It then totals the monthly transaction amounts and updates the current year column by that amount. |
Late Charges Waived |
This field displays the total late charges waived year-to-date and for the prior two years.
At monthend, the system reads the history for the month, looking for tran codes 570 (Waive Late Charge) and 578 (Waive Late Charge Correction). It then totals the monthly transaction amounts and updates the current year column by that amount. |
Principal Balance High |
This field displays the high principal balance year-to-date and for the prior two years. The year-to-date amount is calculated at monthend.
For loans with an LIP method code greater than zero, the disbursed balance is used in the monthly calculation.
For a construction/permanent loan where the LIP method code is deleted during the month, the disbursed balance is used up to the date the LIP method code is deleted; then the principal balance is used in the calculation. |
Principal Balance Low |
This field displays the low principal balance year-to-date and for the prior two years. The year-to-date amount is calculated at monthend.
For loans with an LIP method code greater than zero, the disbursed balance is used in the monthly calculation.
For a construction/permanent loan where the LIP method code is deleted during the month, the disbursed balance is used up to the date the LIP method code is deleted; then the principal balance is used in the calculation. |
Principal Balance Average |
This field displays the average principal balance year-to-date and for the prior two years. The year-to-date amount is calculated at monthend by finding the average for the month based on the principal balance for all days, divided by the number of days in the month. For loans with an LIP method code greater than zero, the disbursed balance is used in the monthly calculation. For a construction/permanent loan where the LIP method code is deleted during the month, the disbursed balance is used up to the date the LIP method code is deleted; then the principal balance is used in the calculation. For loans opened during the month, when the system calculates the average balance for the month, only the actual number of days the loan was opened is used in the calculation. For example, if a loan opens on the 13th, the number of days used in the calculation would be 19 for a 31-day month. The system always uses the date in the Date Opened field in the calculation of the average balance. If this date is different from the date the open loan transaction was processed, the average balance may be incorrect, as it would use zero for the daily balance for the number of days’ difference between the open loan transaction and the opened loan date. For loans closed during the month, the system calculates the average balance for the month of the payoff by using the actual days the loan was open during the month. It does not include the payoff date. For example, if a loan pays off on the 20th, the number of days used in the calculation would be 19 (the day of the payoff is not included). |
Average Rate |
This field displays the average rate year-to-date and for the prior two years. The year-to-date average is calculated at monthend. For payment method 7 and 6 with the Use ARM Fields? field checked, the rate used is LNAMRT. For LIP loans with an LIP method code greater than zero, the rate used is LNLRAT. For all others, the rate used is LNRATE. |
Days Active |
This field displays the number of days active year-to-date and for the prior two years. The year-to-date number of days is calculated at monthend.
Each day the principal balance is greater than zero, the loan is considered active.
For loans with an LIP method code greater than zero, the disbursed balance is used in the monthly calculation. |
Days Inactive |
This field displays the number of days inactive year-to-date and for the prior two years. The year-to-date number of days is calculated at monthend. Each day the principal balance is zero, the loan is considered inactive. For loans with an LIP method code greater than zero, the disbursed balance is used in the monthly calculation. |
Days Inactive High |
This field displays the most days in a row that the loan has been inactive year-to-date and for the prior two years. The year-to-date high is calculated at monthend.
Each day the principal balance is equal to zero, the loan is considered inactive. |