Navigation: Deposit Reports > Deposit Reports - Numerical Order >
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.