Deposit Reports > Deposit Reports - Numerical Order

Availability

Combined Debenture (certificate account) Statements can be set up to run semi-annually in June and December or annually in December.

Purpose

This report prints statements for all the certificate accounts belonging to an IRS owner within the same household. First it is sorted by IRS account owner, then by the first mailing address on the account. If the account owner has multiple accounts, they will be sorted in account number order and printed on one statement (unless they have different mailing addresses or are in different households).

The following information is printed on the statement:

•Account number

•Interest rate

•Issue amount

•Current balance

•Issue date

•Next maturity date

•Final maturity date

GOLDPoint Systems Only: The first Sort field must be set to "80," and the critical fields must be "1" to "22." (Having the critical fields set "1" to "22" will make a separate statement for each IRS owner. Separate statements for an IRS owner will be created if the IRS owner owns accounts in different households or accounts with different mailing addresses.)

The second and third Sort fields must be set to "1" and "2," respectively, to sort each statement in account number order.

Report Column Information

See FPSDR184 Example for an example of this report.

The IRS owner’s full name will appear above the address. No ownership will appear on this line even if the ownership code is above 100.

Column	Description
Account Number	This column displays the office number (DMACTO), account number (DMACTA), and the check digit (DMCKDG) for the certificate account.
Interest Rate	This is the current interest rate for this certificate account, taken from the Interest Rate field (DMRATE) on the Features/Options tab of the Deposits > Account Information > Account Information screen.
Issue Amount	This is the opening balance for this account, taken from the Opening Balance field (DMOPBL) on the Additional Fields tab of the Deposits > Account Information > Additional Fields screen.
Current Balance	This is the current balance of the account, taken from the CurrentBalance field (DMCRBL) on the Account Information tab of the Deposits > Account Information > Account Information screen.
Issue Date	This is the date the account was opened. This date is pulled from theDate Opened field (DMDTOP) on the Account Information tab of the Deposits > Account Information > Account Information screen.
Next Maturity Date	This is the maturity date for this account, taken from the Maturity Datefield (DMMTDT) on the Features/Options tab of the Deposits > Account Information > Account Information screen.
Final Maturity Date	This is the date of the last account maturity. This is pulled from the expiration date for hold/action code 11. If the date for hold/action code 11 is blank or in the past, the expiration date for hold/action code 12 will be used. Hold code expiration dates are found in the Expiration Date fields (DMHACX) on the Restriction/Action Codes tab of the Deposits > Account Information > Restrictions & Warnings screen in CIM GOLD. If the expiration dates for both hold codes 11 and 12 are blank, the current maturity date will be used (thus the next maturity and final maturity dates will be the same). The maturity date is found in theMaturity Date field (DMMTDT) on the Features/Options tab of the Deposits > Account Information > Account Information screen.
UTMA Flag	If this IRS account owner’s ownership code is 138 (UTMA), then the letters "UTMA" will appear at the end of the account information line on the right side of the statement.

Totals and Subtotals Provided

Subtotals for each statement are provided in the following categories:

•Issue amount

•Current balance

Combined Debenture Certificate Statements (FPSDR184)

Combined Debenture Certificate Statements (FPSDR184)