Deposit Reports > Deposit Reports - Numerical Order

Availability

This report can only process at monthend.

Purpose

The Monthly Cash Activity Report (FPSDR206) reads month-to-date history on accounts and calculates the cash totals. For each account, the month-to-date cash in and cash out are added together and then compared to the limit specified on the report. Any account that meets this limit is printed, along with key fields. By default, accounts with cash activity greater than $3,000.00 will appear on the report. This limit amount can be changed to any number less than or equal to $99,999.99.

This report can be printed in detail or summary form and sorted by office (81) and by Social Security number (80).

GOLDPoint Systems Only: To print in detailed form, set the first Misc Opts to "Y."

To pull month-to-date history, set the last Misc Opts to "Y."

To sort by social, use key Sort Key Field 80 with criticals 1-15.

To sort by office, use Sort Key Field 81 with criticals 1-8.

Enter the override cash amount in the Misc Parm field. For example, enter $6,000.00 as "0600000."

Input Records are DM, MN, and DZ.

Report Column Information

See FPSDR206 Example for an example of this report.

The summary print of the report will only print accounts with Cash In and Cash Out totals greater than $6,000.00, sorted and subtotaled by office. The detailed print of the report is described below.

Column	Description
Account Number	This is the office number (DMACTO), the account number (DMACTA), and the check digit (DMCKDG) for the account.
Account Owners	Up to four account owners will print in this section. This field will display up to 30 characters for each name, and the first name listed is always the IRS owner. All information for these fields come from the CIF System.
SSN	This field displays the Social Security numbers for each name on the account, taken from the CIF System.
Beg Balance	This is the balance on the account at the beginning of the month (DMMEBL).
End Balance	This is the balance on the account at the end of month (DMCRBL).
MTD Cash In	This field shows the Cash In total by adding all the Cash In amounts for the month.
MTD Cash Out	This field shows the Cash Out total by adding all the Cash Out amounts for the month.
MTD Deposits	This field indicates the total deposits for the month (DMDMDP).
MTD W/D	This field indicates the total withdrawals for the month (DMDMWD).
MTD Ck Dep	This field shows the total check deposits by adding all check deposits for the month.
Account Status	This field indicates the current status of the account.
Hold Codes	These 12 fields indicate any hold codes that are on the account.