Navigation: Deposit Reports > Deposit Reports - Numerical Order >
Availability
This report runs daily in the afterhours.
Purpose
The Deposit Account Analysis Statements program creates statements for accounts that were analyzed that night. If the Skip Credit Statement? (AISKCR) field is checked on the Costed Service Institution Defaults screen (function 447/448), then statements will not be created for accounts that have a credit amount.
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.
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. The Critical From field must be set to “1” to “14.” |
---|
Report Column Information for Individual Analysis Statements
See FPSDR089 Example for an example of this report.
Column |
Description |
---|---|
Name |
This displays the mailing name for this account. |
Address |
This displays the mailing address for this account. |
Statement Period |
This displays the date range for this month’s statement period. |
Individual Analysis Statement |
This displays the office number, account number, and check digit for the account being analyzed. |
IRS Owner Name |
This is the full name of the IRS owner of the account in first-middle-last name format. |
xxxxxxx Balance for Cycle |
This displays the balance on the account during the statement cycle used for the analysis. “AVERAGE” is displayed if the average balance was used. “ACCT HI” is displayed if the high balance was used, and “ACCT LO” is displayed if the low balance was used. |
Float Amount For Cycle |
This displays the float amount for this account during the statement cycle. |
Average Daily Collected Balance |
This displays the average collected balance during the statement cycle. It is calculated by subtracting the Float Amount for Cycle from theXXXXXXX Balance for Cycle. |
Required Federal Reserves |
This displays the dollar amount that is required to be maintained in reserve for this account at the institution. It is calculated by multiplying the Average Daily Collected Balance by the rate displayed on this line. |
Required Institution Reserves |
This displays the amount that your institution requires to be maintained in reserve for this account. It is calculated by multiplying theAverage Daily Collected Balanceby the rate displayed on this line. If your institution does not maintain reserves, this field will not be shown. |
Net Available Balance |
This displays the amount that is used to calculate an earnings credit for the account. It is calculated by subtracting the Required Federal Reserves and the Required Institution Reserves from the Average Daily Collected Balance. If the result is negative, this may result in an additional charge rather than an earnings credit. |
Start Date, End Date, and # Of Days |
This displays the cycle start date, the cycle end date, and the total number of days present in the statement cycle. The # of Days is used in several of the calculations in account analysis. |
Earned/Charge On Net Available At |
This displays the Earned on Net Available at if the Net Available Balance is greater than or equal to zero. charge on net available atwill be displayed if the Net Available Balance is negative. This amount is calculated by multiplying the Net Available Balance by the rate displayed on this line, dividing by 365, and multiplying by the number of days in the cycle. |
Forwarded Credit |
This displays the credit amount, if there is any, forwarded from the last statement. The credit is applied to the cost of services for the account. |
Balance Before Services |
This displays the sum of the Earned/Charge on Net and theForwarded Credit. This line is only present if there is a Forwarded Credit amount. |
Service Provided |
This column displays the description of each costed service provided for this account. The Deposit Admn Fee field displays the amount charged for FDIC insurance on this account. It is calculated by multiplying the Average Daily Collected Balance by the rate displayed on this line. It is considered a costed service. |
Cost/Item |
This column displays the cost per item for each service provided to the account. |
# Of Items |
This column displays the number of items for each service provided to the account during the statement cycle. If this field is negative, the number of items was credited to the account. |
Total Cost |
This column displays the total cost for each service. It is calculated by multiplying the # of Items by the Cost/Item. If the result is less than zero (credit for number of items), the Total Cost will be zero for that service, rather than giving a credit amount. |
Comp Balance |
This displays the compensating balance that corresponds to the total cost of the provided service. The compensating balance is the balance needed in order for the account NOT to receive a charge for that item. An account that has no forwarded balance and that receives neither a charge nor a credit will have a total compensating balance that is equal (or very near to) the Average Daily Collected Balance. |
Total of Services |
This displays the total of all the Services Provided in the detail lines. |
Net Earnings Credit/Net Charge to Account xxxx xxxxxxxxxx xx |
This displays the total charge or credit amount for this statement. If theTotal of Services was greater than the Balance Before Servicesamount or if the EARNED amount was a CHARGE, then the result is a charge to the account. If theTotal of Servicesis less than or equal to theBalance Before Services, the result is a credit amount. If the result is a charge, the account that will be charged is displayed. |
Required Balance For No Charge |
This displays the balance that, if maintained through the statement period, would have resulted in no charge made to the account. This line appears only for charge balances. |
Account Not Charged During Evaluation Period |
If the account has a CHARGE amount showing on the statement, but the Charge Fees? (AICHGS) field in function 62 is set to "N" (no), this message will be displayed on the statement to show that the account was not charged the displayed amount. This allows an evaluation period on the account before starting to charge for account analysis. |
Report Column Information for Combined Analysis Statements
See FPSDR089 Example for an example of this report.
Column |
Description |
Name and Address |
This displays the mailing names and address where the combined statement will be sent. Names and addresses are pulled from the CIF System (Application 9). The Assign Data To Batch Reports screen (function 44 in CIF) allows you to set up mailing names and addresses for combined accounts to designate where statements will be sent. |
Statement Period |
This displays the date range for this month’s statement period. |
Combined Analysis Statement |
This displays the statement number shown on each page of the combined statement. The statement number shows where the accounts on the statement were combined. |
Individual Analysis Statement |
This displays the individual analysis for each account that was combined on this statement. Several individual statements can be printed. The format of the individual statement is the same as the single account statement. |
Combined Statement Summary |
This heading is followed by a summary of the individual statement information displayed above. It displays the household and statement number. |
Total Earned/Charge Amount From All Accounts |
This displays the total earned from all accounts on the combined statement. If the amount is negative, the line displays "CHARGE" instead of "EARNED". This amount is calculated by adding up eachEarned/Charge on Net Available At from each individual statement. |
Total Forwarded Balances From All Accounts |
This displays the sum of all Forwarded Credit amounts from each individual account. |
Total Of Services From All Accounts |
This displays the sum of all Total of Services from all individual statements. |
Net From All Accounts Charged To xxxx xxxxxxxxxx xx/Net Earnings Credit From All Accounts |
This displays the result of Total Earned/Charge Before Services from All Accounts minus Total of Services from All Accounts. If the result is positive, then the result is a NET EARNINGS CREDIT, otherwise, it is a charge amount and the account that was charged is displayed. |
Account Not Charged During Evaluation Period |
If an account has a CHARGE amount showing on the statement, but the Charge Fees? field (AICHGS) on the Account Analysis Costed Services screen (function 61/62) is blank, this message will be displayed. This indicates the account is not set up to be charged; therefore, it will not be charged. It is displayed after the Net from All Accounts Charged to xxxx xxxxxxxxxx xx/Net Earnings Credit from All Accounts line to show that the fees have not been charged to the specified account. |
Totals and Subtotals Provided
Institution totals are provided for the number of batch assignment records in each section.