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 > Current Non Current Balances

CURRENT NON CURRENT BALANCES

Function 
To assist in cash-flow projections by analyzing the principal portion of loans expected to be repaid within the next twelve months, and the remaining balance which is expected to be repaid beyond the next twelve months.


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 Current/Non-Current Balances Report

At the top of the report, you will find the selection criteria, including cutoff date, as entered. The date and time of the report is also included.

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.

Repaid 
This represents the principal portion of the loan that has been repaid as of the cutoff date.

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

Current Next 12 Months 
By comparing the loan balance and the loan terms found within the Loan Master file, the program uses an amortization schedule to forecast the principal repayment that can be expected within the 12 month period following the cutoff date.

Non-Current 
The loan balance, minus the Current Next 12 Months portion, is listed as Non-Current.

Things You Should Know
  • This report may be produced as often as desired with no consequence to the database. 
  • Accurate data within the Loan Master file related to loan terms is vital to production of a valid report. If the data does not appear as expected, review the Loan Master file, Loan Terms tab and edit as necessary. Empty fields will also have an impact on the report. 
  • If the Maturity Date found within Loan Master file, Loan Terms tab falls within the 12 months following the cutoff date, the loan balance will be considered “Current”. 
  • 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 “Current/Non-Current Balance” 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