Viewing a Loan

Loans must first be loaded into the search result tree before their data can be viewed. The details of the selected loan in the tree will then be displayed to the right in the main view area with all of its data organized into individual tabs.


Searching for Loans

To initiate a search, click Get Query. This will load all loans in the database into the tree when no search criteria is specified.

To locate a specific loan record, enter a search criteria for the loan in the global search field or enter a value to search for in each individual field and hit Enter or click Get Query Get Query. Only loans that match all of the specified criteria will be loaded into the tree.

For information on increasing the efficiency of your searches using Metacharacters, see Search Criteria Metacharacters.

Click on a loan in the tree to display the details for that particular loan.

To clear the search result, click Clear Query Clear Query or hit F5 on the keyboard.

NLS 4.10.8 and laTer

Querying by Status Code

Status codes can be included or excluded in the loan query screen by selecting the status code to be included or excluded in the Status Codes drop down list. Click the checkbox to toggle between ignore, include, and exclude.

Ignore Status code is not used in the search criteria.
Include Loans with the selected status code is specifically included in the search result.
Exclude Loans with selected status code is specifically excluded from the search result. Excluded status codes are shown within [brackets] in the Status Codes field.

NLS 5.6 and later

Right click and select Check All to select all status codes, Uncheck All to deselect all status codes, or Exclude All to exclude all status codes.

NLS 5.4 and later

Click the AND/OR button to toggle between matching all (AND) of the selected status code query criteria or any one (OR) of the selected criteria.

Advanced Global Search

NLS 5.6 and later

Click Advanced Global Search to open a dialog to search only in one particular field.

Enter a search criteria into one of the fields and click Search to search only in that one particular field.

NLS 5.21 and later

Searches can be restricted to one particular branch by selecting the branch from the Search by Branch drop down list.

Select Include co-borrowers in last name search to include co-borrowers when searching by Last Name. This option is only available for loan queries.

Saving Query Criteria

Query criteria can be saved for easy searches in the future. After performing a search, click on the search field and select Save last query criteria or click . Enter a name for the query criteria in the blank field provided.

Once a query is saved, it will be listed in the search field drop down list. Select the saved query criteria to perform a query based on the saved criteria.

The saved criteria listing order can be rearranged by clicking the arrow icons shown to the right of each criteria. The criteria can be deleted by clicking .

Clicking will prevent the criteria from being seen by other users. These criteria are labeled as being private.

Click to create groups to organize the criteria list. Criteria can be placed in a group by using the arrow icons to move them under the group name. Groups can be collapsed and expanded as needed to hide or show its content.

Advanced Query

Additional search options are available by clicking Advanced Query ....

Interest Only Period Match loan that has the Beginning Interest Only Period option selected.
Parent of Shadow Loan Match loan that is a parent of a shadow loan.
Participation
Part. Ref#

Match loans with the specified participation reference number.
Part. Number

Match loans with the specified participation number.
Shortname

Match loans with the specified shortname of a participant.
Loan Group

Match participation loans belonging to the specified loan group.
CIF-Loan Relationship
CIF Refno

Match loans with the specified CIF Refno.
Contact Number

Match loans with the specified contact number in its contact-loan relationship.
Relationship

Match loans with the selected contact-loan relationship code.
Transaction History

Click to specify search criteria pertaining to the past transactions made on the loan.
Payment History

Click to specify search criteria pertaining to the past payments made on the loan.
Promise To Pay

Click to specify search criteria pertaining to promises to pay on the loan.
Next Impound Analysis Date Match loans with the specified date (MM/DD/YYYY) for its next impound analysis.
SQL Statement5.21+

Click and enter a SQL query to search for loans.

Example: Search for loans whose last activity date falls within 12/10/2019 and 12/20/2019

SQL

select acctrefno from loanacct where (last_activity_date between '2019-12-10' and '2019-12-20')

Example: Search for loans whose ratio of the current loan amount to the current principal balance is 5:1.

SQL

select acctrefno from loanacct where (current_principal_balance/current_note_amount) < .2

Example: Search for the first 10 loans whose total past due balance is greater than 500.

SQL

select top 10 acctrefno from loanacct where total_past_due_balance > 500

Loan Detail

The top section of the loan view contains the primary details of the loan that was entered when the loan was added to the database. This section is visible at all times and some of the fields can be modified directly. The same fields can also be modified in the Loan Setup dialog.

The Setup Date is a date that was assigned by the system at the time the loan was entered. This field is not user editable.

The Main tab of the Loan Query displays all of the relevant dates for the loan setup, as well as current loan balances, projected next billings, and past due amounts.

Some fields will display a bubble when moused over to display supplemental information.

A field with a red triangle in its top left corner can be clicked on to display additional information.


Open Date The Origination Date of the Loan.
Funded Date5.20+
 The effective date of the first principal advance. The loan view must be reloaded to see the updated value if any transaction is made that affects this date.
Curr Date The origination of the current term of the loan. This will only be different from the Open Date if the loan has been renewed. Generally, renewal should only be done on lines of credit. Term loans should have their terms Modified or Extended.
Maturity Date The date on which the loan is expected to mature if there are no renewals or extensions.
Payoff/Closed Date

Payoff Date is the date on which the Payoff payment was made on a loan.
Closed Date is the date on which the loan status was set to CLOSED.
Dates will be blank on an active loan.
One scenario where the two dates may differ is on a loan where it is paid off on one date and closed at a later date once a refund for any overpayment is issued.

Last Activity The date of the last payment activity.
Int Accr Thru The date of the most recent daily interest accrual recorded for this loan.
Int Paid Thru The due date of the last interest receivable, billed by NLS, that has been paid in full.
Prin Paid Thru The due date of the last principal receivable, billed by NLS, that has been paid in full.
Next Stmt The date on which the next statement is to be sent to the print queue. It is calculated by the next payment date and the billing cutoff.
Accr Cut Off The date through which the interest accruals are to be included on the next billing.
Loan Type Tells if the loan is a Term loan, Add on interest loan, or a line of credit.
Int Type Tells if the loan is simple interest or some form of fixed amortization.
Curr Rate The current interest rate of the loan. This is effective as of the interest accrued through date.
Term Type Tells if the loan term is calculated using Months, Payments, or Days.
Term The number of Months, Days, or Payments in the term.
Term Due On some amortized loans, the loan can be amortized over a certain term, but actually due in a shorter period than the amortization term. In this case, this field will be used to determine the actual maturity date.
Payment Period5.27+
 Shows the interest and principal payment periods. “Custom” will be shown if a custom payment schedule is used.
SAC Exp/Ineligible Shows the Same as Cash expiration and ineligible dates.
Credit Line Limit If the loan is a line of credit, this is the maximum balance that may be advanced.
Curr Loan Amt The total amount of the loan. This value is increased when principal is advanced only if the new value exceeds the old value. It is never decreased except in the case of a reverse of an advance that caused it to increase.
Principal Bal The actual principal currently outstanding on the loan.
Interest Bal The balance of all accrued but unpaid interest.
Fees Bal The balance of all assessed but unpaid fees (not counting late charges).
Late Charges Bal The balance of all assessed but unpaid late charges.
User Def Total Bal The sum of the current balances of the 10 user-defined Loan Balances.
Total Balance The sum of the Current Principal Amount, the Current Interest Amount, The Current Fees, the Current Late Charges, and the Current User Defined Total. Due to the combination of First/Last day accrual and Beginning/End of day accrual parameters on the loan, this may not be equal to the amount of the payoff (as derived by a payoff notice) on the loan for the current date.
Click on the Total Balance field to open the Payoff Info dialog showing the payoff amount for the following 10 days.
Mouse over the values to show a breakdown of any additional fees that may be included in the payoff amount.5.19+

Example

If the loan is End of day accrual, then accruals for the current date have not yet posted. If the loan is also Last day accrual, the accruals for the date of payoff must be included in a payoff amount. Since today’s accrual has not yet posted, the current Total Balance is not including this last day of accrual.

Note

The actual values of the balances are stored in the database to the 10th decimal place and are displayed rounded to the 2nd decimal place. The displayed total balance is the rounded value of the sum of the actual values of those balances. An asterisk (*) next to the total balance will appear if the sum of the displayed balances is not equal to the displayed total balance.
Add on Interest Only used for Add On Interest Loans. On these loans, the interest for the entire life of the loan is calculated and added on at the origination of the loan. As interest is paid, it is deducted from this balance. It shows all interest that remains to be paid over the life of the loan.
Loan Remaining The sum of the Current Principal Amount and the Add on Interest.
Suspense The amount by which the loan has been overpaid. Certain combinations of payment application default settings can also cause a portion of a payment to go into suspense.
Pending The total amount of outstanding future dated transactions. These will be posted to the loan automatically during the accrual process of the date for which they are effective.
Per Diem The current daily interest accrual on the loan.
Unamortized Fees The sum of all the setup amounts for amortized fees on the loan, less the sum of all fee amortizations to date.
Off Loan Balance This field contains the sum of Off Loan Balance User Defined Fields # 1, 2, and 3. These three user-defined loan balances represent balances that are increased and decreased through manual transaction codes for funds which the lender needs to track on an individual loan, which are not part of the loan’s payoff.
Balloon Payment The amount and date of the scheduled Balloon Payment (if any).
Next Principal Billing The amount and date of the next scheduled, unbilled, Principal Payment.
Next Interest Billing The amount and date of the next scheduled, unbilled, Interest Payment.
Next Tot/Reg Payment On fixed payment loans, this is the regular payment amount. On loans that have fluctuating payment amounts, this is the sum of the next principal due and next interest due.
Last Payment The amount and date of the last payment that was made on the loan. The date is the date entered, and this field does not revert back to a previous value when a transaction is reversed.
Total Past Due The sum of all outstanding billed payments that have due dates earlier than today’s date.
Total Curr Due The sum of all outstanding billed payments.
Days Past Due The number of days the loan is past due.
When a loan has deferred payments (except for the first payment eligible for deferral), this field will change to Days Past Due per CARES Act or Deferment Days Past Due and an asterisk will appear next to the number of days past due. Placing the cursor over this field will display a tooltip showing the total days past due and the number of days in deferment since the past due date that was used to determine the value.5.20+
Tooltip will only appear on loans that were past due prior to October 1, 2022, during the active CARES Act period.5.35.8+

NLS 5.13 and later

The number of user defined fields have been increased to 75.

The Detail 1 tab holds the data for the user-defined loan fields. To add user-defined information, simply type the information into the appropriate field and click Save .


NLS 5.13 and later

The number of user defined fields have been increased to 75.

The Detail 2 tab holds the data for additional user-defined loan fields. To add user-defined information, simply type the information into the appropriate field and click Save .


The Comments tab allows access to the Loan commenting and document storage system.


The functions of the buttons are:

Add Add This button allows you to log a new comment. The comment will be automatically stamped with the date, time, and your User ID number.
Delete Delete This button will remove the highlighted comment if you have the privilege to delete comments.
Modify Modify This button will allow you to edit an existing comment if you have the privilege to modify comments.
Print This button will print out all of the existing comments on the currently selected Contact.
Search This button allows you to search the database comments for key words. The search may include just the currently selected Contact, or may search the entire table.
Wrap Text Clicking this button will cause the text of the comments to be displayed on multiple lines, allowing all of the comments to be read from the list in their complete form.

Right-click on a comment to display a popup menu:

Move to Another Loan Where applicable, opens a Find Loan dialog where a loan can be queried and the comment will be moved, not copied, to the selected loan.
Hide/Show UDF Column Where applicable, the UDF columns can be toggled to be hidden or shown in the table view.

The Relationships tab of the Loan Query provides access to all of the Contact-Loan relationships for the currently selected loan.


For information on adding relationships, see Contact Manager.


The Payments Due tab of Loan Query provides access to a list of all currently outstanding receivables on the loan.


The functions of the buttons are:

Print This button will print out the full list of outstanding payments.
Modify Modify This button will allow you to edit existing receivables. If the amount of the receivable is reduced so that the Amount Remaining is equal to zero, the receivable will be deleted.

The Payment History tab displays a record of all payments that have been made on this loan account. Only payment transactions are shown here, and if a payment is reversed, the payment record is removed from the list.


The functions of the buttons are:

Print This button will print out the full list of the payment history.

Right-click on a payment history to display a popup menu:

Add Payment History Manually enter a payment history.
Modify Payment History Edit the selected payment history. This option is only available for manually entered payment history.
Delete Payment History Delete the selected payment history. This option is only available for manually entered payment history.
Remove NSF5.18+
 Removes the NSF entry from the payment history and will reverse the associated unpaid NSF fee. NSF fee that has been partially or fully paid will need to be reversed manually. This option is only available for NSF payments.

Bulk Payment

NLS 5.14 and later

Move the cursor over a Bulk Payment ID in the Reference column to see a list of loans and the distribution amount from the bulk payment.

The Loan History is a running list of transactions and balances by effective date. It is designed to give a picture of the transaction history of the loan from the borrowers point of view, showing the principal balance at all times, and the transaction history that justifies those balances.


The functions of the buttons are:

Show
Detailed Payment

Shows payments broken out into various interest, principal, and fees.
Summarized Payment

Shows individual payments on a single line.
Precomputed Payment5.4+

Only available on precomputed loans. Shows all original transactions that affects the balance of the loan.
Print This button will print out the full list of the loan history.

All transactions are listed in the transaction history. The date and time of the actual moment of transaction entry are recorded along with the user ID. The effective date is the date entered by the user at the time of transaction entry.

When a transaction is reversed, it is not taken off of transaction history, but a reversing transaction is added. The transaction history, therefore; will show a complete history of every event that has happened on the loan except for interest accruals, rate changes, and modifications to the loan setup.



The functions of the buttons are:

Show/Hide Reversed Transactions Button toggles the list to hide or show reversed transactions.
The initial state can be configured in Loan Setup > Loan Defaults > Miscellaneous.5.18+
Print This button will print out the full list of the transaction history.
Comments Clicking this button brings up a comments window which will allow you to add comments that are linked directly to individual transactions.

Right-click on a transaction to display a popup menu:

Add Transaction History Manually enter a transaction history item.
Modify User Defined Fields Modify the user-defined fields of the selected transaction history item.
Delete Transaction History Delete the selected transaction history. This option is available only on manually entered transaction history item.
Transfer Check/ACH…5.4+
 Move the transaction from one loan to another. Enter the loan number to which to transfer the transaction and click Transfer. The transaction, including the transaction code, will be moved to the specified loan and any balances affected will be updated.

Only available on transactions codes that creates a voucher and a check (or ACH) to a vendor.

Must first be enabled in default, user, or group privilege under Loan > Transaction Entry > Other > Allow check/ACH transfer between loans.

Right click on the header row of the table to display a popup menu to choose what and how the data is displayed and organized.

Complete statistical data for each loan is available through the Statistics tab.


The statistics are shown for the loan's life to date, for each calendar year of the loan’s existence, and for each month of the loan’s existence.

Principal Advanced The sum of all Principal Advance Transactions made during the statistical period.
Principal Paid The sum of all principal payments made during the statistical period.
Interest Earned The sum of all interest accruals and interest adjustments during the statistical period. As interest adjustments may be positive or negative, any negative interest adjustments during the statistical period will reduce the total Interest Earned.
Interest Paid The sum of all Interest Payments made during the statistical period.
Late Charges Earned The sum of all late charges assessed during the statistical period.
Late Charges Paid The sum of all late fee payments made during the statistical period.
Misc Fees Earned The sum of all fees (other than late fees) assessed during the statistical period.
Misc Fees Paid The sum of all fee payments (other than late fees) made during the statistical period.
Escrow Interest Earned This statistic is not currently in use.
Escrow Interest Paid This statistic is not currently in use.
Average Balance The sum of all daily balances during the statistical period, divided by the number of days in the period.
High Balance The greatest single daily balance for the loan in the statistical period.
Low Balance The lowest single daily balance for the loan in the statistical period.
Past Due 10/30/60/90/120+

A counter of the number of distinct billings that have gone past due, categorized by the number of days past due. Days past due is the loan's accrued through date minus the payment's due date. Once a payment is past due by 10 days, the 10 days past due counter is set and until the payment is paid in full, it will remain there until it is 30 days past due at which point the count is moved to the 30 days past due counter.
When a payment is made in full, the count will remain where it was last categorized. Reversing payments will not resume the counter for that billing.

The sum of these counts should not exceed the total number of payments that have ever been past due.

The life to date past due counter can be changed by right-clicking on the life to date value and selecting Modify Past Due Counters.
NSF Payment A counter of all distinct NSF payments.
Promises Made The number of times that a Promise to Pay was logged in through the collections module.
Promises Kept The number of times that a Promise to Pay was logged in through the collections module, and an amount equal to or exceeding the amount of the promise was entered as a payment prior to the expiration of the promise.
Promises Broken The number of times that the expiration date of a Promise to Pay was reached before payments in amounts equal to or exceeding the amount of the promise were made.
Deferred Payments5.19+
 The number of deferred payments made. Partial payments and future deferments are included in the count.
User Def # 1–25 These statistics are defined by the system administrator, and may be updated by user-defined transactions.

The Int Accruals tab provides access to all of the daily accruals that have been earned on the loan.

DefaultShow CorrectionsVariable Rate

The functions of the buttons are:

Show/Hide Corrections This button is only available if the list is expanded to daily accruals. It adds daily accruals that have been superseded by correcting entries back into the list.
Print This button will print out the full list of the accrual history, either the monthly aggregates or the daily accruals for the selected month.
A dash (-) in the rate column indicates a variable rate. Move the cursor over the item to see the rate breakdown.

The Daily Trial Balance tab provides access to the Actual Trial Balance Entries (what the balance on the loan was on any given day) and the Effective Trial Balance Entries (balance adjusted to take backdated transactions into account so as to show what the balance would have been if those transactions had actually been entered on those days). In addition, a third set of balances, the GL Balances is identical to the effective balances, but uses the GL date of the transactions instead of the effective date for determining the adjustments.


The function of the buttons are:

Show/Hide User Defined Fields This button is only available if the list is expanded to daily trial balance entries. It adds the user-defined loan balance entries to the trial balance view.
Print This button will print out the full list of the trial balance history for the selected month.

Right click on the header row to display a menu for configuring the sorting and display of columns.

Columns Select which column to display.
Sort Ascending Sorts the rows in ascending order based on the selected column.
Sort Descending Sorts the rows in descending order based on the selected column.
No Sort Removes the highlighting from the currently sorted column. Does not affect the current sorting.
Remove Column Hides the selected column. The hidden column can be shown again by selecting it in the Columns menu.
Automatic Column Sizing When selected, all the columns are automatically sized to fit within the visible area.
Reset to Default Columns Resets the table to display the default set of columns. This cannot be undone.

The Task tab of Loan Query lists any Tasks, Work Packets, or Notifications that are associated with this loan.


The functions of the buttons are:

Print Clicking this button sends the displayed list of tasks, work packets, or notifications to the printer.
Refresh Record Clicking this button reloads the selected list so that it will include any tasks or work packets that have been added or modified by other users.

Right-click to display a popup menu:

Show/Hide Completed Object Toggle between showing and hiding completed items.

This tab is only present when the loan is a participation loan. It shows a quick view of all pertinent information related to all participants on the loan.



The Collateral tab provides access to any collateral items that have been added to the loan.


For information of the configuration and use of Collateral Codes, see Loan Setup.

The functions of the buttons are:

Add Add Allows you to add a new collateral item to the loan.
Modify Modify Allows you to switch an existing piece of collateral from one Collateral Code to another. You must be sure to check the information on your collateral user-defined fields to be sure it is still valid, as the fields may have different data types on the new code.
Delete Delete Removes the selected collateral item.

The History tab provides access to the history of all modifications that have been made to the loan setup.


The functions of the buttons are:

Print This button will print out the full list of the modification history.
Modify Modify This button allows you to add or modify notes about the currently selected Loan Setup Modification History item.
Filter Query By default, the field history shows the complete list of modifications for the currently selected loan. By clicking this button, you can run a search on all of the modification history in the database.
Refresh Record Clicking this button will reload the modification history for the current loan. This will allow you to view any modifications that you have just made to the loan, or any modifications that have been made to this loan by other users since you originally queried the loan.