Bank Totals (DD-04/SV-04)
Click here to view report sample.
Standard report produced daily.
The Bank Totals DD-04 is available in CenterView with the DDA Exceptions Report and at the end of the Trial Balance DD0001 in the Trial Balance Group of Reports.
Branch and Region Totals allow you to monitor growth, volume and change for each Branch and Region.
# Accounts is broken down to reflect the # Active and # Closed that are still on the system.
# New and # Closed are daily totals.
Debit and Credit Control Totals and Source information allow you to balance input totals to your General Ledger.
Sweep accounts are included in the Balance that is reported for the Branch Totals, Region Totals, Service Charge Code Totals, Type Totals and Class Totals.
Regular (Non-interest Bearing) and Interest Bearing Account activity and totals are included for balancing and control.
Prior Year Contributions are listed separately and included in the Reportable Contributions Total.
Account Profitability Charges are reported on the SAV Expanded Branch Code Totals Report (SV-014) and the Bank Totals Report.
Number of Automated Charge-Offs, Amounts and Recoveries are listed.
The Linked (Savings) Balance amount is shown for NOW, SuperNOW and any non-interest bearing accounts established as Linked. Linked Balance = Total Balance for these accounts - Balance of transaction account portion
The Linked Balance is based on the Linked Savings Tolerance Amount and Linked Savings Tolerance in 1000s established on your accounts. For example, if:
|
Current Balance |
= |
$221,491.69 |
$221,491.69 |
|
Linked Savings Tolerance |
= |
200 |
200 |
|
Linked Savings Tol. in 1000s |
= |
blank |
T |
|
Then: |
|
|
|
|
Move current balance over $$ |
|
$200 |
$200,000 |
|
Amount moved to Linked Savings and reported on the Bank Totals |
= |
$221,291.69 |
$21,491.69 |
The DDA System calculates accrued interest in advance of weekends and other closed days. The Amount of Interest Accrued Today is calculated by taking the amount of accrued interest this processing and dividing it by the number of days in the processing period. Any decimal positions over 2 are rounded off and that amount rounded off is added to the first day’s accrual.
For example:
If the amount of accrued interest for 5/07, 5/08, and 5/09 is $205.8294, that amount is divided by 3. Any amounts over the 2 decimals are rounded-off. The amount that was rounded off is then added to the first day’s accrual.
$205.82 / 3 = 68.6098
Accrued for 5/07 = $68.63
Accrued for 5/08 = $68.60
Accrued for 5/09 = $68.60
Total for period = $205.83
Activity and Totals for Health Savings Accounts (HSA) are displayed.
Interest-bearing DDA accounts that are tied to a Sweep are reported in the NOW account totals. Non-interest bearing DDA accounts that are tied to a Sweep are reported in the regular accounts totals.
The total, *CLN DDA1total, *CLN DDA1, will display on this report and the DDA Transaction Report (DD-02) when the Secondary Market Past Due option is used and dollar activity from automated funding is present. Refer to the LNS Help File for more information.
Recap Totals for Cash Reserve/Revolving Credit are provided for verification and balancing to your General Ledger.
The summary includes a comprehensive recap of all activity by Tran Code. LATE CHG. PAID TODAY includes both Late Charges automatically posted to the CRA account and Late Charges that are posted manually. Late Charges Collected YTD are reported on the Expanded Branch Totals Report.
AUTO LATE CHG. PAID TODAY includes only Late Charges that are automatically posted to the CRA account.
The CRA/RVC Rate Control Data includes rate change information for Cash Reserve/Revolving Credit accounts. Automatic Rate Changes should always be verified when a change is made.
Service Charge Code totals are provided for verification and control of balances, # of accounts, and accrued not paid interest.
In the Service Charge Totals Section, a second line will be printed for each service charge code if there is a linked savings balance for that service charge. The second line will include the service charge code and the current balance of linked savings followed by an (L).
Type Totals provide information for FR2900, Call Report and other regulatory reporting requirements. The number of accounts and balance information is provided for Linked Savings accounts.
DDA Auto Rate Change information is displayed for your verification.
Rates entered from the Rate Control screens are reported as *AUTOMATIC RATE CONTROL DATA*.
Rates which are established by CSI in your bank control record (Service Charge Routine) are reported as *BCR RATE CONTROL DATA*.
Automatic Rate Control Data may display exact rates or margins (+ or -) to rates based on the parameters defined in your Service Charge routine.
Account Profitability Analysis entries are provided for verification prior to actual statement production. The APA Rate Control Data includes the earnings established for Rates 1 - 6.
If a TC 85 - APA Charge is erased (soft or hard), it will display in the Account Profitability Analysis Account Entries section and on the Erase Activity Today Report.
The Expanded Rate Control Summary (DDA Option 3814) provides totals by Service Charge Code for the number of accounts and balance used for accrual within each rate tier (ledger, average, or collected). If an Interest Floor Rate was used instead of Rate01 - Rate09, then the account will still display on the report under the totals with which it is normally associated.
The number of Sending Accounts used with the Compensating Activity Rewards Product will be listed on the report.
Sales tax information is included for banks that use the Sales Tax Rate option (dda 3988).