GMS RLSS Online Help
  • Home
  • Contents
  • Index
  • Search

WELCOME TO GMS RLSS ONLINE HELP

The help you need at  your fingertips.
You are here: Reports > Accrued Interest Analysis

ACCRUED INTEREST ANALYSIS

Function
To provide accurate information regarding delinquent interest to assist with cash-flow and income projections.


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 

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.

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.

Interpreting the Accrued Interest Analysis Report

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. 

Pmts                           
In the Loan Master file, Loan Terms tab, there is a field titled Total Pmts.  The data within that field is shown here.

Rate                            
This shows the annual interest rate for each loan. 

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

Last Activity               
Reflects the date of the most recently recorded activity prior to the cutoff date, along with the amount of that activity. 

Days                           
Calculated as the days between the Last Activity date and the cutoff date. 

Accrued Interest       
The sum of any accrued interest recorded in the loan history plus interest that has accrued between the Last Activity Date and the cutoff date. 

Current Balance       
The sum of Last Balance plus Accrued Interest. 

Things You Should Know
  • This report may be produced as often as desired with no consequence to the database. 
  • 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 reports screen and then select “Accrued Interest Analysis” 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. 
Picture
Copyright © 2019 GRANTS MANAGEMENT SYSTEMS, INC.
  • Home
  • Contents
  • Index
  • Search