An account statement is the record of transactions and their effect on account balances over a specified period of time for a given account. An account statement lists the debits and credits that have taken place over a time period.
A detailed statement gives minute details of the transactions that have occurred on a given account, including the order of details, ultimate beneficiary, payment method etc. On the other hand a summary statement shows all transactions but gives only limited details of individual transactions like the reference number, date and the amount with a debit/credit indicator.
SWIFT account statements are statements generated for NOSTRO type of accounts, i.e., for a bank type of a customer. MT940 is generated for an account with its primary statement as detailed and a MT950 is generated for an account with its primary statement as summary.
This chapter contains the following sections:
You need to maintain a basic set-up at the following levels to generate account statements:
This section contains the following topic:
Oracle FLEXCUBE offers you a format, on the basis of which you can maintain a layout for account statements to be generated. The maintenance form shown below offers you the flexibility of maintaining format details – like the lines per page and columns per page – according to your requirements, as also to maintain the tags required for populating the details. The system generates account statements, including ad hoc account statements, according to the maintenance provided by you.
You can invoke the ‘Advice Format Maintenance’ screen by typing ‘MSDADVFT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You need to maintain two advice formats – one for Savings accounts and the other for Nostro accounts viz ‘ACST_DETAILED’ and ‘SWIFT’ respectively as shown below.
You need to maintain details as shown in the screen below.
Format Text
Specify the following format.
BANK-NAME
COPY AS OF ASOFDT
-------------------------------------------------------------------------------------------------------------------------------
CUSTNAME
Account Branch : BRNAME
ADDRESSONE
Branch Address : BRADDR1
ADDRESSTWO
BRADDR2
ADDRESSTHREE
BRADDR3
ADDRESSFOUR
Cust ID : CUSTNO
Account No : ACCOUNTNO
Account Desc. : ACCOUNTDESC
Account Class : ACLASSNAME
Account Currency : ACYNAME
-------------------------------------------------------------------------------------------------------------------------------
Statement From : FROMDATE
To : TODATE
OPENBALANCE
Account Open Date : OPENDATE
OPENING BALANCE DRCR
OPENBALANCE
AVAILABLE BALANCE AVLBALANCE2
STATEMENT OF ACCOUNT : ACCOUNTNO
Statement From : FROMDATE
To : TODATE
PAGE :1
Trn Code/Narrative REFERENCE Book Date Value Date Withdrawal Deposit Closing Balance
F TAGVAL E TD
F TAGVAL E RC
F TAGVAL E BT
F TAGVAL E VD
FTAGVAL E
FTAGVAL E
F TAGVAL E TD
ACC NO REFERENCE DATE LOAN CHARGES DESC AMOUNT
CL F TAGVAL E CL
CL F TAGVAL E CL
CL F TAGVAL E CL
CL F TAGVAL E CL
CL F TAGVAL E CL
=====================================================================
Totals DEBITVALUE CREDITVALUE
----------------------- …………………………………
No. of DEBITS: ND AND CREDITS NC
=====================================================================
CLOSING BALANCE DRC CLOSEBALANCE AVAILABLE BALANCE AVLBALANCE2
UNCOLBALANCE
UNCOLLECTED BALANCE UNCOLBALANCE BLOCKED BALANCE BLOCKEDBALANCE
UNCOLBALANCE
* = UNAUTH ENTRY / R = REVERSAL
*** End Of Statement ***
If the trust account credit transaction is from FT module then system will show the following details as part of ‘TRNCODEDESC’:
If the trust account credit transaction is from any other module, the system will show the following details as part of ‘TRNCODEDESC’:
You need to maintain details as shown in the screen below.
Format Text
Specify the following format.
#B
#LOOP
_LINE_
#ENDLOOP
#EB
You need to specify the account statement format for Savings and Nostro types of account classes in the ‘Account Class Maintenance’ screen. You can invoke the ‘Account Class Maintenance’ screen by typing ‘STDACCLS’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You need to maintain the following details.
Account Type
You need to maintain two records – for one choose ‘Savings’ and for the other choose ‘Nostro’.
Account Statement Format
Choose ‘ACST_DETAILED’ for Savings type of account class and Nostro type of account class.
You can invoke the ‘Message Type Maintenance’ screen by typing ‘MSDMSTYM’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You need to maintain eight records with details given below.
Sr. No |
Module |
Message Type |
SWIFT Message Type |
Consolidation Message Type |
1 |
AC |
ACST_BALANCE |
MT941 |
ACST_DETAILED |
2 |
AC |
ACST_DETAILED |
|
ACST_DETAILED |
3 |
AC |
ACST_DETAILED2 |
|
ACST_DETAILED |
4 |
AC |
ACST_DETAILED3 |
|
ACST_DETAILED |
5 |
AC |
ACST_DETAIL_VD |
|
ACST_DETAILED |
6 |
AC |
ACST_INT_DTL |
MT942 |
ACST_DETAILED |
7 |
AC |
MT940 |
MT940 |
ACST_DETAILED |
8 |
AC |
MT950 |
MT950 |
ACST_DETAILED |
For further details, refer the chapter titled ‘Maintaining Messaging Branch Preferences’ in the Messaging System User Manual.
You can invoke the ‘Customer Address Maintenance’ screen by typing ‘MSDCUSAD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Here you need to maintain three records with the following details.
Sr. No |
Branch |
Module |
Message Type |
Format |
1 |
ALL |
AC |
ACST_DETAILED |
ACST_DETAILED |
2 |
ALL |
AC |
ACST_DETAILED2 |
ACST_DETAILED |
3 |
ALL |
AC |
ACST_DETAILED3 |
ACST_DETAILED |
For further details, refer the chapter titled ‘Maintaining Addresses for Customer’ in the Messaging System User Manual.
You can have the statement generation happen automatically as part of the automated End Of Day cycle, using the ‘Batch EOD Function Input’ screen. You can invoke this screen by typing ‘BADEODFE’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You need to specify the following details.
Function Identification
Specify ‘ACSTHAND’ or select this value from the adjoining option list.
End Of Cycle Group
Choose the option ‘Transaction Input’.
For further details, refer the chapter titled ‘Automated End of Cycle Operations’ in the Automated End of Day User Manual.
Given below is a sample account statement:
Sample account statement
You can maintain ad hoc requests for consolidated statements raised by customers using the ‘Adhoc Consolidated Statement Request Statement’ screen. You can invoke this screen by typing ‘STDCRSMT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can capture the following details here:
Reference Number
Specify a 16-digit unique code to identify the record with. You can leave the field blank to have the system generate it automatically upon saving the record.
Branch Code
The system displays the branch code.
Customer No
Specify a valid customer number who has raised an ad hoc request for statement. The adjoining option list displays all valid customer numbers maintained in the system. You can select the appropriate one.
Customer Name
The name of the customer for the specified customer number is displayed.
Request Type
Select the request type from the adjoining drop-down list. The available options are:
From Date
Specify the start date of the statement.
To Date
Specify the end date of the statement.
Request Date
Specify the date on which the request is raised by the customer.
Note
Note that ‘To Date’ must be less than or equal to ‘Request Date’.
Process Status
The system displays the status denoted by a single letter as below:
Note
Using the Generic Interface, you can maintain the statement format and generate the statements.
Process Status Details
The system gives the description of the single letter Process Status displayed above.
E-Statement
Check this box to indicate that E-Statement is required.
Charge Account Branch
Specify the account branch from which charge is deducted for the E-Statement.
Charge Account
Specify the charge account. The adjoining option list displays all the valid account numbers maintained in the system. You can choose the appropriate one.
To view the joint holder’s details of an account and the mode of operation maintained at the account level, place the cursor on the Charge Account field and press Ctrl+J. The system displays the ‘Joint Holder’ screen.
For more information on the ‘Joint Holder’ screen refer to the section ‘Joint Holder Maintenance’ in this User Manual.
Charge Account Description
The system displays the description of the specified charge account number based on the details maintained at ‘Customer Account Maintenance’ level.
You can view a summary of adhoc consolidated statement requests using the ‘Adhoc Consolidated Statement Request Summary’ screen. You can invoke this screen by typing ‘STSCRSMT’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can query on records based on any or all of the following criteria:
Click ‘Search’ button. The system identifies all records satisfying the specified criteria and displays the following details for each one of them:
You can maintain statement requests of customers who would require consolidated statements on an automatic basis using the ‘Automatic Consolidated Request Statement Maintenance’ screen. You can invoke this screen by typing ‘STDACRST’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can capture the following details here:
Reference Number
Specify a 16-digit unique code to identify the record with. You can leave the field blank to have the system generate it automatically upon saving the record.
Branch Code
The system displays the branch code.
Customer No
Specify a valid customer number for whom you wish to maintain a request for automatic consolidated statements. The adjoining option list displays all valid customer numbers maintained in the system. You can select the appropriate one.
Customer Name
The system displays the name of the specified customer ID based on the details maintained at ‘Customer Maintenance’ level.
Charge Account Description
The system displays the description of the specified charge account number based on the details maintained at ‘Customer Account Maintenance’ level.
Effective Date
Specify the date on which the statement is requested.
Frequency
Select the frequency of the statement requested from the adjoining drop-down list. The available options are:
Start Month
Select the starting month of the requested statement from the adjoining drop-down list. The available options are:
Start On
Specify which day of the month the statement should begin from.
Last Executed Date
The system displays the date on which the statement request was last executed, if any.
E-Statement
Check this box to indicate that E-Statement is required.
Charge Account Branch
Specify the account branch from which charge is deducted for the E-Statement.
Charge Account
Specify the charge account. The adjoining option list displays all the valid account numbers maintained in the system. You can choose the appropriate one.
To view the joint holder’s details of an account and the mode of operation maintained at the account level, place the cursor on the Account Number field and press Ctrl+J. The system displays the ‘Joint Holder’ screen.
For more information on the ‘Joint Holder’ screen refer to the section ‘Joint Holder Maintenance’ in this User Manual.
You can view a summary of automatic consolidated statement requests using the ‘Automatic Consolidated Request Statement Summary’ screen. You can invoke this screen by typing ‘STSACRST’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can query on records based on any or all of the following criteria:
Click ‘Search’ button. The system identifies all records satisfying the specified criteria and displays the following details for each one of them:
You can generate a combined statement for all accounts through the ‘Combined Statement Maintenance’ screen. To invoke this screen type ‘STDCDSTM’ in the field at the top right corner of the Application tool bar and click. the adjoining arrow button.
Specify the following details:
Statement ID
Specify the statement plan identification.
Customer No
Select the customer number from the adjoining option list.
All Accounts/Loans
Check this box to generate statement for all accounts and loans of the customer.
Populate
Click ‘Populate’ button to default all the accounts, deposits and loans belonging to the customer.
If ‘All Accounts/Loans’ is unchecked then the ‘Populate’ button will be disabled. You will have to manually specify the details in this case.
The system displays the following CASA details of the customer:
The system displays the following deposit details of the customer:
The system displays the following loan details of the customer:
Format
Select the statement format from the adjoining option list.
Frequency
Select the frequency at which the combined statement should be generated from the adjoining drop-down list. The options available are:
Statement Day
Select the day on which combined statement should be generated from the adjoining drop-down list. If value for Statement Day is not selected, then the system defaults the values based on the frequency cycle selected. The statement gets generated on the month end of the defaulted values.
The statement displays the balance for CASA and TD accounts based on book dated or value dated balance. This will be parameterized at the bank level.
For the parameter COMBINED_STATEMENT, the system defaults the value as BOOK_DATED.
Apply Charge
Check this box to apply charge during the EOD batch process.
Charge Account
Select the charge account from the adjoining option list. Charge Account is mandatory if ‘Apply Charge’ is checked.
Charge Branch
The system displays the branch of the selected charge account.
Charge Currency
The system displays the currency of the selected charge account
CIF Creation Date
Select ‘CIF Creation Date’ to generate the combined statement with from date as CIF creation date.
User Input Date
Select ‘User Input Date’ to specify the date with which the combined statement should be generated. However you cannot modify the user input date. This field is enabled only if ‘User Input Date’ is selected.
Previous Statement Date
The system displays the last combined statement generation date.
No Previous Statement
The system displays the number of combined statement generated till date.
Note
You can view the combined statement details maintained in the ‘Combined Statement Maintenance’ screen using the ‘Combined Statement Maintenance Summary’ screen. You can invoke this screen by typing ‘STSCDSTM’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In the above screen, you can base your queries on any or all of the following parameters and fetch records:
Select any or all of the above parameters for a query and click ‘Search’ button. The system displays the following records meeting the selected criteria:
Periodic charges are applied to the charge account maintained in the combined statement plan. The charges are computed based on the slab details maintained and the number of combined statement generated. The account class mapped to charge basis ‘NUM-COMB-STMTS' returns the number of combined statements generated. The counter for the charge basis are COMB_STMNT_FMT is reset after the charges are collected during IC liquidation.