Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Activity Tracking Report (FPSDR191)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Activity Tracking Report (FPSDR191)

Previous pageReturn to chapter overviewNext page  Print this Topic

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.

 

honeycombgoldgpsonly

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:

 

Sort Fields

Sort Key Field

Critical

Office Number

80

1-6

Product Code

81

1-6

Short Name

82

1-24

Deposit Type Code

83

1-5

 

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.

©2021 GOLDPoint Systems. All rights reserved.