DDA Trial Balance (DD001)
Click here to view report sample.
Optional report (dda 0055) produced daily from the Update program. (Bank Option 0277Bank Option 0277 must also be set.)
Available in CenterView in the Trial Balance group of reports.
Remote Print File Location: DTS001/STS001
The Trial Balance may be used as archival storage for on-line banks and a reference for non on-line banks. It contains balance information as well as static information about the account.
The following legend describes the information included under each field name to make it easier for you to understand and use the information contained on the Trial Balance.
Confidential information can be suppressed on employee accounts as an option (dda 0048). Two values are available:
1 = Suppress Last Dept Amt, Dt Lst Dep, Current Bal, Avail Bal, Coll Bal, Hold Amt and Sweep Bal (Prints ***EMPLOYEE*** in the balance field and does not print any activity)
2 = Suppress Last Dep Amt and Dt Lst Dep (Prints ***EMPLOYEE*** in Last Deposit Field)
Sales tax information is included for banks that use the Sales Tax Rate option (dda 3988).
Field Definitions
|
ACCOUNT # |
Customer Account Number displayed in the mask established in your bank control record. |
|
|
NAME |
First 24 characters of the 30 character Name field will be printed on the Trial Balance. |
|
|
ACTV |
Dormant will be displayed under the account number to identify dormant accounts. The number of debits (standard) or debits and credits (optional) posted since the account’s last statement is displayed under ACTV. This number can be used for verifying the item count and/or calculating a final service charge if an account is being closed before its normal statement date. |
|
|
TY/ST/SC/WV/IF/BR/IGL |
Type / Statement Cycle / Service Charge Code / Waive Code / Interest Formula Code / Branch Code / IGL Code (15 characters) For example: 1/31/0A/44/01/0003/02 |
|
|
|
1 31 0A 44 01 0003 02 |
Type Statement Cycle Service Charge Code Waive Code Interest Formula Code Branch Code IGL Code |
|
CURRENT BALANCE |
Often referred to as Ledger Balance. This balance represents the balance after the most recent posting update (the balance as of the date of the Trial Balance). |
|
|
AVAIL BALANCE |
Available Balance = Ledger Balance - Float - Holds |
|
|
COLL BALANCE |
The Collected Balance will be reported if the account is paying interest on a collected balance service charge routine calculation. |
|
|
LNK SAV BALANCE |
Current Balance in the Linked Savings portion of the account. |
|
|
LAST DEP AMT |
Amount of the last posted deposit. As an option you may choose to display zeroes in this field for employee accounts. |
|
|
HOLD AMT |
The total amount of any Holds established on the account. |
|
|
SWEEP BALANCE |
If the account is linked to a Sweep account, the Sweep balance will be displayed. |
|
|
DT LST DEP |
Date (MMDDYY) of the last posted deposit (may be prior to the date of the Trial). These deposits include Tran Codes 040, 042 and 049 only. Transactions made with Tran Codes 004, 005, and 006 are not included. |
|
|
LAST STMT |
Date (MMDDYY) the last statement was produced (includes Regularly Scheduled, Special, Exception, Overnight, and Daily Statements). |
|
|
LAST ACTIVE |
Indicates the date the account was last active for either deposit or check activity. This information can help you to identify inactive accounts. Use the Trial Balance from this date to research the most recent activity on the account. |
|
|
SWP |
Sweep Fund Code established on the account. |
|
|
ACCR INT |
Accrued not-paid interest. |
|
|
ACCR WITHHOLD |
Amount of accrued interest withheld. |
|
|
AOD AMOUNT |
Allowable Overdraft Amount established on the account. |
|
|
INTEREST ACCOUNT IDENTIFIER |
One of the following symbols will be displayed to identify the interest account. |
|
|
|
* # @ & $ % |
NOW Money Market Fund Sweep Super NOW HSA HSA Sweep |
|
LK SV ACR INT |
Linked Savings Accrued Not Paid Interest. If the account is reclassified, the accrued interest is not. It remains as Linked Savings Accrued and is paid as Linked Savings Interest Paid. |
|
|
PEND S/C |
Pending Service Charge Amount (Interest Bearing Accts Only). |
|
|
RATE |
The interest rate in use, based on accrued today. The Base Rate +/- Margin and Exception Rates are considered when calculating this Rate. |
|
|
ATM/TOT |
These three numbers represent the ATM Relationship Code and the Total Code. For example: 2 / 99 |
|
|
|
||
|
The following fields display information for a Cash Reserve, Super CRA, or Revolving Credit loan linked to the DDA account. |
||
|
LOAN BAL |
The CRA, Super CRA, or RVC loan balance. |
|
|
ACCR INT |
Interest accrued not paid on the loan account. |
|
|
PAYOFF |
Current payoff amount. |
|
|
CRED LIMIT |
Credit limit established for the loan. |
|
|
PL TYP IGL |
Codes that identify the Plan Code, Type Code, and IGL Code established on the CRA, Super CRA, or RVC account.
For example: 1 SUP 09 |
|
|
|
1 SUP 09 |
Plan Code Type Code IGL Code |
|
DUE |
Payment due day for the loan. |
|
|
MAT DATE |
Maturity date established on the loan account. |
|
|
REG CC INFORMATION |
The number of overdrafts that occurred in the last six months and the number of overdrafts that exceeded $5525 will be disclosed so that the bank can choose whether or not to apply a hold. For example: #OD LAST 6 MO 99 OVER $5,525 |
|
|
ALERTS |
This line is used to alert you of exception conditions on the account. This includes a special alert that your bank has established on the account and/or system generated messages:
Bank Established Special Alerts: Lost Book 2 Signatures Required Pledged as Collateral Suspected Forgeries Caution Duplicate Book Issued Power of Attorney No Disclosure Bankruptcy Do Not Reopen Death on Account 22 - 99 (Bank-Defined)
System Generated Messages: |
|
|
|
STOP PAY XD ATS L, S, or D 000012345678 MCMG NEW *NEW* CLOSED |
A stop pay has been established on the account. Excess Debit ATS Code ATS Transfer Application and Borrower/Note Number Multiple Cash Management Account Number New account today New account within last 30 days Account closed today |
|
FLOAT AMTS 1 - 4 |
An account level field, Print Float on Trial Balance, can be established so that Float Amounts for Days 1, 2, 3 and 4 are displayed on the Trial Balance (F/M Code 155 = 1). |
|
|
AVAIL AMTS 1 - 9 |
A separately priced account level option can be established so that Available Funds for Days 1 - 9 are displayed on the Trial Balance (F/M Code 155 = 1). |
|
|
SYSTEM GENERATED MESSAGES |
S/C TODAY 999.99 - Service Charge amount assessed today |
|