Navigation: Deposit Reports > Deposit Reports - Numerical Order >
Availability
This report should run daily in the afterhours.
Purpose
This report shows balance and activity information for all deposit accounts. The report uses the deposit (DM), CIF (MN), and transaction log (TG) records, and shows each day’s activity.
The following report example is sorted by office number and by selecting the deposit types explained in the previous paragraph.
GOLDPoint Systems Only: To exclude any office number from the report, list the offices in the Misc Parm field with commas between, as illustrated in the following example. The offices to be excluded are 8, 9, 10, 11, and 12.
Misc Parm 8,9,10,11,12
The report can be sorted by the following:
If you don’t want a page break between the Sort fields, then theCritical field should always be from 1 to 4. |
---|
Report Column Information
See FPSDR191 Example for an example of this report.
Column |
Description |
---|---|
Account Number |
This column displays the account number. It consists of the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG). |
Short Name |
This is the short name of the IRS account owner (SHNAME), pulled from the CIF System. |
Prod Code |
This is the product code used for this account. It is pulled from theProduct Code field (DMPDCD). |
Today’s Activity |
This is the total amount the account balance changed on the date the report was run. It is a calculated field using transaction log records and the Current Balance field (DMCRBL) on the Deposits > Account Information > Account Information screen in CIM GOLD. |
Month to Date Activity |
This is the total amount the account balance has changed from the date the report was run since the last monthend date. |
Month End Balance |
This is the account balance at last monthend. It is pulled from theMonthend Balance field (DMMEBL) on the Deposits > Account Information > Additional Fields screen in CIM GOLD. |
Current Balance |
This is the current balance of the account. It is pulled from the Current Balance field (DMCRBL) on the Deposits > Account Information > Account Information screen in CIM GOLD. |
Average Daily Balance |
This column displays the daily average balance on the account. It is a calculated field taken from the Average Balance/Cycle field (DMAVBL) on the Deposits > Account Information > Account Information screen in CIM GOLD. |
Totals and Subtotals Provided
Subtotals are provided by office number. Totals are provided by institution.