Deposit Reports > Deposit Reports - Numerical Order

Availability

This report runs daily in the afterhours.

Purpose

The Account Analysis Statements program reads activities created from the Account Analysis function to create a report of accounts that were analyzed that night. This report will include all accounts that cycled, whether or not the account was charged and a statement was created.

Statements are sorted first by mail code*, then by statement type. Single account statements are sorted first, followed by combined accounts statements. Combined accounts statements are sorted first by household and statement number, then by account number.

The Warehouse indexes available for this report are:

1.Account Number

2.Household Number

3.Balance Used

GOLDPoint Systems Only: Input records are MN, TG.

*To sort by mail code, the report setup must be set to read CIF (MN record). Otherwise, the program will ignore the mail code and accounts will be sorted in account order.

If Misc Opts 1 is set to “Y,” “A” forms will be treated like “B” forms. Only set Misc Opts 1 if the “A” forms have printed material on the back (making them similar to B forms). Otherwise, do not set this option.

Report Column Information

See FPSDR092 Example for an example of this report.

Household #	This displays the household number for this account.
Stmt	This displays the statement number from the CIF System (function 44) that analysis accounts have been combined under. This column is left blank for accounts that are not combined.
Account Number	This displays the office number, account number, and check digit for the account whose analysis information is being shown.
Balance Used	This displays the high, low, or average balance for the account shown during the statement cycle. This balance is used as the base amount from which earnings credits are calculated.
Float Amount	This displays the float amount for this account during the statement cycle. This amount is subtracted from the Balance Used to give the Average Collected Balance for the cycle.
Reserves	This displays the combined total of the Federal Reserve and the Institution Reserve (if used).
Net For Svcs	This displays the result of Balance Used minus Float Amount minusReserves. This amount is the balance used to calculate the earnings credit against which costed services are subtracted. If the NET AMOUNT is negative, an additional charge will be assessed.
Earn+/Chrg-	This displays the result of the earned/charge calculation. It is calculated by multiplying the Net for Svcs by the applicable rate, then multiplying that amount by the number of days in the cycle. If the result is positive, this amount is a credit toward costed services provided to this account. If the result is negative, this is an additional charge.
Fwd Cr	This displays the forwarded credit amount used by the account for this statement.
Services	This displays the total of all costed services provided for the account. It includes the FDIC insurance amount and earned interest from the account (if used).
Net Cr+/Cg-	This displays the charge or credit amount that results from adding theFwd Cr amount to the Earn+/Chrg- amount and then subtracting the net services from the Earn+/Chrg- amount. If the result is greater than or equal to zero, then the amount is a credit balance and would not be charged to the account. If the amount is negative, then this is the amount that will be charged to the account for services. This total contains the state sales tax, if it has been added to the account.
*/#	If an "*" appears in this column next to a negative amount, it means that the amount was not actually charged to the account because the target account has the Charge Fees (AICHGS) field (function 62) set to "N" (no). If a "#" appears in the column next to a positive amount, it means that a statement was not created for that account. This will happen if the institution chooses not to create statements for analyzed accounts with net credit amounts.

Totals and Subtotals Provided

Subtotals are given for each combined statement to show the following:

1. Number of accounts combined together

2. Total reserves for combined accounts

3. Total net for services on combined accounts

4. Total earnings or charges from combined accounts

5. Total forwarded credits from combined accounts to the subtotals list

6. Total services from combined accounts

7. Total credit or charges for combined accounts

Totals are given for the institution showing:

1. Total number of accounts analyzed

2. Total reserves for all accounts

3. Total net for services on all accounts

4. Total earnings or charges from all accounts

5. Total forwarded credits from all accounts to the institution totals list

6. Total services from all accounts

7. Total credit or charges for all accounts

Account Analysis Statement Report (FPSDR092)

Account Analysis Statement Report (FPSDR092)