Deposit Reports > Deposit Reports - Numerical Order

Availability

This report is generally run monthly in the afterhours. Consult your GOLDPoint Systems banking consultant if you want to schedule this report differently.

Purpose

The Retirement Accounts In Distribution Report lists deposit retirement account holders who are 70½ or older. These account holders are required to begin taking disbursements from their retirement accounts.

An option is available to list accounts of owners who are and will turn 70½ in the next 12 months starting at the current date.

An option is available to list accounts of owners who will turn 70½ in the next 12 months starting July 1 following the current date. Education and Roth accounts will be excluded.

An option is available to list accounts of owners who turned 70½ in the 12 months before July 1 following the current date. Education and Roth accounts will be excluded.

An option is available to list all accounts in distribution. The list will exclude Education and Roth IRAs.

A warning will be printed on the report if a retirement account has no name and address associated with it, or if the account holder's birthday is unknown.

If no messages are printed, the special message column will contain the date the account owner will reach age 70½.

The report will allow sorting by branch, birth date, account number, and Social Security number.

GOLDPoint Systems Only: To set the report to show all owners turning 70½ years old in the next 12 months starting with the run date, set miscellaneous option 1 to "Y."

To change the annual run of the report from July 1 to June 30 and to show all owners turning 70½ in the next year, set miscellaneous option 2 to "Y."

To change the annual run from July 1 to June 30 and to show all owners who turned 70½ in the past year, set miscellaneous option 3 to "Y."

To set the report to show all accounts in distribution, set miscellaneous option 4 to "Y."

Report Column Information

See FPSDR114 Example for an example of this report.

Column Heading	Description
Account Number	This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) for the account.
Household #	This is the household number in which this account resides taken from the CIF System (MNHHLD).
Birth date	This is the birth date of the IRS owner of the account, taken from the CIF System.
Age	This is the current age of the IRS owner of the account.
Customer Name	This is the short name of the IRS owner of the account taken from the CIF System (SHNAME).
Social Sec #	This is the Social Security number of the IRS owner of the account taken from the CIF System.
Phone Number	This is the phone number of the IRS owner of the account taken from the CIF System.
Current Balance	This is the current balance of the account taken from the Current Balance field (DMCRBL) on the Deposit Master Fields screen (function 1/2).
Special Messages	This column will contain any messages that the system needs to relay to you, such as "RET ACCT W/NO BIRTH DATE" when it encounters a retirement account where the birth date of the account owner is unknown. If no messages are relayed, this column will contain the date the account owner reaches age 70½.

Totals and Subtotals Provided

Subtotals are provided by office number for the following:

•Total number of accounts.

•Total number of bad accounts.

•Total amount of current balances on accounts.

If other subtotals are desired, consult your customer service representative. Institution totals are also provided for the subtotals listed above.

Retirement Accounts in Distribution (FPSDR114)

Retirement Accounts in Distribution (FPSDR114)