This report is produced when ACH Payoffs is selected from the Reports drop-down list. The report is a listing of all borrowers that are paying on their loan(s) via an ACH method, and whose loan balance is less than the regular loan payment amount.
A separate detail line is produced for each borrower/loan. Each detail line identifies the loan, payment and balance amounts, and the next payment due date. The report detail lines are grouped/sorted by:
Borrower SSN
Loan Name
The following is a sample ACH Payoffs report:
The data elements which comprise the ACH Payoffs report are described in the following table:
|
Column Name |
Description |
|
Social Security Number |
Borrower's social security number. |
|
Borrower Name |
The borrowers name, formatted as "Last, First" |
|
Loan Name |
The Loan's name. |
|
Balance |
The loan's Principal Balance. |
|
Payment |
The regular payment amount for this loan. |
|
Next Due |
The date when the next payment on this loan is to be made. |
This report retrieves Borrower and loan data from the CLM database that meets the following conditions:
The borrower/loan has an ACH payment method
The loan's principal balance is less than the regular (ACH) payment amount.
A separate report detail line is created for each borrower/loan that is retrieved from the database.