Deposit Reports > Deposit Reports - Numerical Order

Availability

This report can be run any time during a month. However, it is generally processed at monthend. Consult your GOLDPoint Systems banking consultant about how you want to schedule it.

Purpose

The $250,000.00 and Over Report lists all accounts by Social Security number for which the combined account balance is greater than $250,000.00. If an account is General Category 9 (non-interest bearing), it will not be used for this reporting from December 31, 2010 to December 31, 2012.

	Note: Accounts with no Social Security number or CIF data on file will still be listed as long as the individual account balance is at the specified limit.

The information provided in the report includes:

•Account Number

•Maturity Date

•Short Name

•CIF Ownership Code

•Current Balance

•Social Security Number

•Date Opened

•Phone Number

•Interest Rate

•Term

No sort options are available. The report will automatically sort and subtotal by Social Security number and the IRS owner. Within each Social Security number, accounts will appear in account order.

GOLDPoint Systems Only: Turn on option 1 to process a $250,000.00 and Over report.

Turn on option 2 to report the full name of the IRS account owner.

To override the $250,00.00 limit, enter a value in the Misc Parmfield. The field is 14 digits long. For $3,000.00, the override parameter would be 00000000300000.

To pull by FDIC type, use pull field #21. This option can be used separately or combined with others. There is no limit on the number of setups.

Report Column Information

See FPSDR066 Example for an example of this report.

Column	Description
Account Number	This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) for the account.
Short Name	This is the short name of the IRS owner of the account, taken from the CIF System (SHNAME).
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).
Date Opened	This is the date this account was opened, taken from the Date Openedfield (DMDTOP) on the Deposit Master Fields screen (function 1/2).
Interest Rate	This is the interest rate on the account, taken from the Interest Ratefield (DMRATE) on the Deposit Master Fields screen (function 1/2).
Term	This is the term of the account, taken from the Term and Type fields (DMTMTP and DMCTRM) on the Deposit Master Fields screen (function 1/2). The term is displayed as “NNNX,” where NNN is the length of the term, and X is the term type. For example, “24M” in this column would indicate a term of 24 months, and “180D” in this column would indicate a term of 180 days.
Maturity Date	This is the maturity date of the account, taken from the Maturity Datefield (DMMTDT) on the Deposit Master Fields screen (function 1/2).
CIF Owner	This is the CIF ownership code associated with this account, taken from the CIF System. This field (MNOCOD) indicates how the IRS owner is vested on the account.
FDIC Type	This is the FDIC type code (MNFDIC), taken from the Account Detail screen in CIF (function 23/24). The FDIC type code is utilized for uninsured deposits reporting. Valid values are 1-9 if you are utilizing this code.
Social Security #	This is the Social Security number (MNSSFI) for the IRS owner of the account, taken from the CIF System.
Telephone Number	This is the telephone number on the account, taken from the CIF System (MNPHAC - MNPHPF - MNPHON).

Totals and Subtotals Provided

Subtotals are provided for each Social Security number.

Institution totals are provided for number of accounts and number of account holders, which is the number of Social Security numbers listed on the report.

Report Selection Options

This report will default to the $250,000 and over amount and only reporting the short name of the IRS account owner. Options available for this report are as follows:

•Report customers with $250,000.00 and over.

•Report the first, middle, and last name of the IRS account owner on a separate line.

•Institution defined reporting amount.

$80,000 or $100,000 and Over Report (FPSDR066)

$80,000 or $100,000 and Over Report (FPSDR066)