ACH Payment Customers Report

This report is produced when ACH Payment Customers is selected from the Reports drop-down list. The report is a listing of all customers that have one or more loans being paid by an ACH transaction. A separate detail line is produced for each loan that meets the selection criteria.

 The report detail lines are sorted by:

• Last Name

• First Name

• SSN

• Loan Status

Sample Report

The following is a sample ACH Payment Customers report:

Report Composition

The data elements which comprise the ACH Payment Customers report are described in the following table:

Column Name	Description
Detail Lines
Last Name	Customer's last name.
First Name	Customer's first name.
SSN	Social Security Number.
Status	Loan repayment status. See Loan Status Codes for more information.
Transaction Type	ACH Transaction Type code. See ACH Transaction Type Codes for more information.
Payment Amount	Loan payment amount.
Summary Line
Customer Count	The number of unique customers/SSNs retrieved.
Total	Sum total of the (ACH) loan payment amounts.

Record Selection Criteria

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

• The loan is being paid via an ACH transaction

• The loan's principal balance is greater than zero.

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