Daily Activity Summary

This report is produced when Daily Activity Summary is selected from the Reports drop-down list. The report provides a summation, by loan and ledger account, of all financial transactions that were applied on a specified transaction date. For each loan/ledger account the total Debit, Credit and Net amounts are displayed. Totals of the Debit, Credit and Net amounts are provided at the Loan, Campus, and report level.

Parameter Entry

When Daily Activity Summary 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 Transaction 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 Activity Summary report:

Report Composition

The data elements which comprise the Daily Activity Summary report are described in the following table:

Column Name	Description
Page Heading
Transaction Date	This is the Transaction Date parameter value supplied by the user.
Ledger Account Detail Lines
Ledger Account Number	The CLM ledger account identifier.
Debit Amount	The total amount of all Debit transactions for this ledger account and this loan, that were made on the specified date.
Credit Amount	The total amount of all Credit transactions for this ledger account and this loan, that were made on the specified date.
Net Amount	The total net amount (Debit Amount - Credit Amount) of all transactions for this ledger account and this loan, that were made on the specified date.
Loan Totals Heading
Loan Type	The loan type represented by the previous ledger account details. Formatted as "Loan Name", "Loan Sub Name".
Debit Amount	The total amount of all Debit transactions for this loan, that were made on the specified date.
Credit Amount	The total amount of all Credit transactions for this loan, that were made on the specified date.
Net Amount	The total net amount (Debit Amount - Credit Amount) of all transactions for this loan, that were made on the specified date.
Campus Totals Lines
Campus Code	This is the Campus associated with the previous ledger and loan detail 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 Ledger data (and associated Campus, Loan and Borrower information) from the CLM database that meets the following conditions:

• The ledger record transaction date matches on the supplied Transaction Date parameter.

A separate report detail line is created for each ledger account. The detail lines are grouped by Loan Type and Campus Code.