ACH Customers with a Balance Report

This report is produced when ACH Customers w/Balance 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:

• Social Security Number

• Last Name

• Principal Balance

Sample Report

The following is a sample ACH Customers w/ Balance report:

Report Composition

The data elements which comprise the ACH Customers With a Balance report are described in the following table:

Column Name	Description
SSN	Customer's social security number.
Principal Balance	Principal Balance of the loan that is paid via an ACH transaction.
Last Name	Customer's last name.
Due Date	Loan payment due date.
Payment Amount	Loan payment amount.

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.