Small Balance Report

This report is produced when Small Balance is selected from the Reports drop-down list. The report is a listing of all customers/loans that have a principal balance of less than negative $5.00 . The report is grouped by Borrower last name, and then by borrower SSN within the last name grouping. A separate detail line is produced for each borrower loan that meets the selection criteria. A sub-total is produced for each borrower, and the report also provides a grand total for all borrower loans. The report detail lines are grouped by:

• Last Name

• Social Security Number

Sample Report

The following is a sample Small Balance report:

Report Composition

The data elements which comprise the Small Balance report are described in the following table:

Column Name	Description
Primary Grouping Line
Last Name	Borrower Last Name. This is the primary grouping field. Within each group all (retrieved) borrowers having this Last Name are detailed by SSN.
Borrower Detail Line
SSN	Borrower's social security number. This is also the secondary grouping field. A separate detail line is produced for each borrower/loan that is retrieved.
Last Paid Amount	The amount that was last paid on the loan.
Last Paid Date	The date the last payment was made.
Payment Amount	The regular payment amount for the loan.
Principal Balance	The current Principal Balance of the loan.
Payment Due Date	The date the next scheduled payment is due.
Borrower Total Line
SSN	Borrower's social security number.
Total Last Paid Amount	Total of the individual Last Paid Amounts for this borrower.
Total Payment Amount	Total of the individual Payment Amounts for this borrower.
Total Principal Balance	Total of the individual Principal Balance Amounts for this borrower.
Grand Total Line
Total Last Paid Amount	Total of the individual Last Paid Amounts for all borrowers.
Total Payment Amount	Total of the individual Payment Amounts for all borrowers.
Total Principal Balance	Total of the individual Principal Balance Amounts for all borrowers.

Record Selection Criteria

This report retrieves all Loan data (and associated Customer information) from the CLM database that meets the following conditions:

• The loan has a status of "R" (in repayment)

• The loan's principal balance is less than negative $5.00.

A separate report detail line is created for each loan that is retrieved from the database.