Daily ACH Payments Report

This report is produced when Daily ACH Payments is selected from the Reports drop-down list. The report is a listing of all applied ACH payments (Payment History records) that were made on the supplied Payment Date parameter. These will not include any corresponding Payment Reversal transactions. Please note that this report shows how the borrower's payment was allocated across the borrower's loans (and Campuses, if applicable). For each loan payment, the detail lines indicate the total amount, as well as how this amount was allocated to Principal, Interest, Late Charges and Collection Costs. The report output is grouped by Campus and Loan Name.

Parameter Entry

When Daily Payments is selected, the top portion of the Reports screen is replaced with a parameter entry window as shown in the following example:

The user should enter the desired Payment Date and then click the Submit button to generate the report. If a date value is not entered, or an invalid date is entered, the following error message will be displayed:

Sample Report

The following is a sample Daily ACH Payments report:

Report Composition

The data elements which comprise the Daily ACH Payments report are described in the following table:

Column Name	Description
Page Heading
Payment Date	This is the Payment Date parameter value supplied by the user.
Campus Group Heading
Campus Code	This is the Campus associated with the following loan payments.
Loan Group Heading
Loan Name	This is the Loan Name.
Payment Detail Lines
SSN	Borrower's social security number.
Borrower Name	Borrower's name, comprised of "Last Name", "First Name".
Check/Voucher Number	The check number or voucher number that was associated with this payment (if any).
Payment Amount	The amount of the borrower's payment that was allocated to this loan.
Principal Amount	The portion of the borrower's payment that was allocated to this loan, that was allocated to the Principal Balance.
Interest Amount	The portion of the borrower's payment that was allocated to this loan, that was allocated to the Interest Balance.
Late Charge Amount	The portion of the borrower's payment that was allocated to this loan, that was allocated to the Late Charge Balance.
Collection Costs Amount	The portion of the borrower's payment that was allocated to this loan, that was allocated to the Collection Costs Balance.
Loan Totals Lines
Total Amounts	Totals of the corresponding amount fields from the associated detail lines for this loan grouping.
Campus Totals Lines
Total Amounts	Totals of the corresponding amount fields from the associated detail lines for this Campus grouping.
Grand Totals Line
Total Amounts	Grand totals of the corresponding amount fields.

Record Selection Criteria

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

• The payment history record transaction date matches on the supplied Payment Date parameter.

• The history record does not represents an ACH Payment transaction.

A separate report detail line is created for each ledger record that is associated with the borrower's payment history record(s) that are retrieved from the database. The detail lines are grouped by Campus Code and Loan Name, and then sorted by borrower SSN.