Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Account Update Report (FPSDR003)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Account Update Report (FPSDR003)

Previous pageReturn to chapter overviewNext page  Print this Topic

Availability

This report should be run daily in the afterhours.

 

Purpose

The Account Update Report checks for the following changes to accounts:

 

1.Certificate accounts which have matured.

2.Certificate accounts which have been renewed.

3.Accounts with changes to interest rates.

4.Interest payments made to Anniversary accounts relative (monthly, annually) to the original open date.

5.Accounts that are cycling (creating a statement).

 

The report is typically sorted by account number.

 

Report Column Information

See FPSDR003 Example for an example of this report.

 

Heading

Description

Account Number

This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) for the account.

Short Name

TThis is the short name of the IRS owner of the account, taken from the CIF System (SHNAME).

Household Number

This is the household number for the account, taken from the CIF System (MNHHLD).

Prod Code

This is the product code used for this account, taken from the Product Code field (DMPDCD) on the Deposit Master Fields screen (function 1/2).

Acct Type

This is the account type for this account, taken from the Type field (DMDPTP) on the Deposit Master Fields screen (function 1/2).

Gen Cat

This is the general category for this account, taken from the Gen Catfield (DMGENL) on the Deposit Master Fields screen (function 1/2).

Account Features

These are the feature codes selected for this account, such as IN for interest, CK for checking, RT for retirement, etc.

Accrued to Today

This figure is calculated by accruing from the date last accrued to the date of the report and adding the result to the accrued amount on the deposit master record. When running the report for a date in the past, if the date last accrued is past the report date, the accrual calculation will give a negative result. The resulting amount may be positive or negative when added to the accrued amount.

Account Balance

This is the current balance of the account, taken from Current Balancefield (DMCRBL) on the Deposit Master Fields screen (function 1/2).

Type of Processing

This provides a brief description of what kind of processing has happened on the account. It is limited to 20 characters. Possible descriptions are

Account matured

Accrued rate change

Account cycled

Anniversary account

 

Totals and Subtotals Provided

Subtotals are provided for each ACH transaction batch for the following:

 

Total number of accounts maturing and their total balance

Total number of accounts cycling and their total balance

Total number of anniversary accounts and their total balance

Total number of product code rolls and their total balance

Total maturity earnings and balance

 

The total number of accounts read for the report is also provided. If other subtotals are desired, consult your customer service representative.

©2021 GOLDPoint Systems. All rights reserved.