Deposit Reports > Deposit Reports - Numerical Order

Availability

This report must be processed daily in the afterhours. Multiple setups of this report can be processed.

Purpose

The Daily and Yearly Statistics Report is a collection of information of total balances, averages, and numbers of accounts for the following four categories:

1. Passbook or selected deposit type

2. Savings or selected deposit type

3. Certificates under 100K (all accounts with CD feature)

4. Certificates over or equal to 100K (all accounts with CD feature)

This report is e-mailed to specified personnel at your institution every processing day.

GOLDPoint Systems Only: Input records are DM.

Two deposit types (DMDPTP) must be included to have Passbook and Savings account categories reported properly. Enter the two deposit type digits in the Misc Parm field as shown in the following example:

For deposit type 1, enter "01"

For deposit type 50, enter "50"

The deposit types entered in the Misc Parm field must be separated by a space. For example: "1 50"

Only two deposit types can be used in this field. The first deposit type is for Passbook accounts, the second is for Savings accounts. If the deposit type is not included in the Misc Parm field, the data for those two categories will not be accurate.

For this report to run properly, the first Sort field must be set to "1," and the Critical fields must be "1" to "6," or "1" to "4" if you do not need the office number individually.

Subprog Cntrls Print must be set to "Y."

Note: This report is not printable.

The loan portion of this report is created by running the Daily Statistics Report for Loans. Institution option EISU must also be turned on in order for the information to be gathered for the e-mail.

Report Column Information

Column	Description
# New Accounts MTD	This row shows the number of accounts opened in the current month.
Amount New Accts. MTD	This row shows the total opening balances (DMOPBL) from all accounts opened in the current month. For certificate accounts, the opening transaction will be used.
Average New Accts. MTD	This row shows the average balances of the new accounts this month, using the number of new accounts month-to-date and the amount of new accounts month-to-date.
# New Accounts YTD	This row shows the number of accounts opened in the current year.
Amounts New Accounts YTD	This row shows the total opening balances (DMOPBL) from all accounts opened in the current year. For certificate accounts, the opening transaction will be used.
Average New Accts. YTD	This row shows the average balances of the new accounts this year, using the # New Accounts YTD and the Amount New Accounts YTD.
# Closed Accts. MTD	This row shows the number of all closed accounts in the month the report is run.
Amount Closed Accts. MTD	This row shows the total amount of last withdrawal (DMLWAM) from all closed accounts in the month the report is run.
Average Closed Accts. MTD	This row shows the average balance of the closed accounts this month, using the # Closed Accounts MTD and total Amount Closed Accounts MTD.
# Closed Accts. YTD	This row shows the number of closed accounts this year.
Amount Closed Accts. YTD	This row shows the total amount of last withdrawal (DMLWAM) from all closed accounts for the year.
Average Closed Accts. YTD	This row shows the average balance of the closed accounts of the year, using the # Closed Accounts YTD and the total Amount Closed Accounts YTD.
# Change MTD	This row shows the number of accounts where the balance changed from the prior month. This is calculated by subtracting the previous monthend’s outstanding accounts from the current monthend’s outstanding accounts (e.g., January 31, 2004 from February 28, 2004).
Amount Change MTD	This row shows the amount changed. This is calculated by subtracting the previous monthend’s outstanding balance from the current monthend’s outstanding balance (e.g., January 31, 2004 from February 28, 2004).
Average Change MTD	This row shows the average balance of the changes for the month, using the # Change MTD and the total Amount Change MTD.
# Change YTD	This row shows the number of accounts that changed for the year. It is calculated by subtracting the previous year ending outstanding accounts from the current year ending outstanding accounts (e.g., December 31, 2008 from February 28, 2009).
Amount Change YTD	This row shows the amount that has changed in the past year. It is calculated by subtracting the previous year’s ending outstanding account balances from the current year’s ending outstanding account balances (e.g., December 31, 2008 from February 28, 2009).
Average Change YTD	This row shows the average balance of the changes for the year, using the # Change YTD and the total Amount Change YTD.
# Outstanding Accounts	This row shows the number of all open (outstanding new and old) accounts.
Amount Outstanding Accounts	This row shows the balance for all open accounts.
Percentage	This row shows what percent each product type is of the total outstanding amount.
Average	This row shows the average balance of all open accounts, using the # Outstanding Accounts and the total Amount Outstanding Accounts.

Daily and Yearly Statistics Report for Deposits (FPSDR186)

Daily and Yearly Statistics Report for Deposits (FPSDR186)