There are various CBS developed by various software companies created to serve the banking Industry.. The same are available in the market however, out of the all, highly acclaimed and widely used Core Banking Softwares are
a) FINACLE by Infosys,
b) BaNCS by Tata Consulting Services and
c) FlexCube by Oracle Financial Services
FlexCube provides a comprehensive, integrated, interoperable, and modular solution that enables banks to manage evolving customer expectations.Like other financial softwares , Flexicube is also run by many Public Sector Banks.
Page Contents
Flexcube Functionalities:
- 24/7 processing of large transaction volumes, with high availability
- Multiple delivery channel support
- Security management covering application and role-based access
- Service-oriented architecture supports agile business process management
- Componentized architecture helps build scalable and reusable solutions
Quick access screens through Hot Keys in Flexcube
| Hot Keys | Screen Name | Description |
| Alt + B | Balance Inquiry | This screen displays the account details of the savings and checking account
balances such as the available balance, nucleated balance, current book balance, passbook balance, net balance, etc. |
| Alt + C | Customer Name And Address Inquiry | This screen displays the details such as the name, address, city, country, SSN/TIN number, etc of the selected customer |
| Alt + A | Account Details | This screen displays the account details of the customer such as account number, account branch, account currency, customer name, etc. |
| Alt + S | Amount based Account Image
Display |
This screen displays the images on the basis of the details maintained in the Amount Based Operating Instruction Maintenance ( Fast Path: 7116) option |
| Alt + P | This will enable the user to print the receipt of the transaction. | |
| F8 | This will enable the user to return to the same screen. |
List of Important Menu Commands of CBS
Following is the list of various important menu commands for Auditors based on area of operations in the bank.
1. Accounts, Customer Master and Inquiry
| CBS Package | Menu Code / Access path | Menu Name | Menu Type (Inquiry
/ Report) |
| FlexCube | CH021 | Account Master Maintenance | Inquiry |
| FlexCube | CH701 | Customer account balances-Other than loans-For standard accounts but including CC limit accounts | Inquiry |
| FlexCube | CH703 | RD account balances- Customer wise | Inquiry |
| FlexCube | 2000 | CTI Customer Search | Inquiry |
| FlexCube | 7004 | Customer Name and Address Inquiry | Inquiry |
| FlexCube | 7100 | All Balance Inquiry | Inquiry |
| FlexCube | 7105 | Display Customer Image | Inquiry |
| FlexCube | BA095 | Account Level Attributes Inquiry | Inquiry |
| FlexCube | 7002 | Balance Inquiry | Inquiry |
| FlexCube | CH031 | Statement Inquiry | Inquiry |
| FlexCube | BAM24 | Account Status Audit Trail Inquiry | Inquiry |
| FlexCube | 1337 | Term Deposit Interest Payout Inquiry | Inquiry |
| FlexCube | 7020 | TERM DEPOSIT Balance Inquiry | Inquiry |
| FlexCube | TD023 | TERM DEPOSIT Rates History Inquiry | Inquiry |
| FlexCube | TD031 | TERM DEPOSIT Audit Trail Inquiry | Inquiry |
| FlexCube | TD037 | TERM DEPOSIT Account Ledger Inquiry | Inquiry |
| FlexCube | TD050 | TERM DEPOSIT Interest Inquiry | Inquiry |
| FlexCube | TD11 | TDS Inquiry | Inquiry |
2. Transactions
| CBS Package | Menu Code / Access path | Menu Name | Menu Type (Inquiry
/ Report) |
| FlexCube | TD044 | TD Transactions Inquiry | Inquiry |
| FlexCube | LN058 | Loan Interest Adjustment Transaction | Inquiry |
| FlexCube | PM025 | Payment Transaction Inquiry | Inquiry |
| FlexCube | GLM04 | GL Transactions and Movements Inquiry | Inquiry |
| FlexCube | AT002 | Audit Trail Financial Transactions Inquiry | Inquiry |
| FlexCube | BA777 | Audit Trail Inquiry for Non-Financial Txns | Inquiry |
3. Office Accounts Maintenance
| CBS Package | Menu Code / Access path | Menu Name | Menu Type (Inquiry
/ Report) |
| Flexcube | GLM01 | GL Voucher Entry | Inquiry |
| Flexcube | GLM02 | Chart of Accounts | Inquiry |
| Flexcube | GLM04 | GL Transactions and Movement Inquiry | Inquiry |
| Flexcube | 1005 | Miscellaneous GL Transfer (Dr/Cr) | Inquiry |
4. Loans & Advances
| CBS Package | Menu Code / Access path | Menu Name | Menu Type (Inquiry
/ Report) |
| FlexCube | CH066 | Limit Collateral Inquiry | Inquiry |
| FlexCube | CHM06 | OD Collateral Maintenance | Inquiry |
| FlexCube | CHM07 | OD Limit Master Maintenance | Inquiry |
| FlexCube | ST070 | Cheque Purchase | Inquiry |
| FlexCube | CH033 | Average Quarterly / Monthly Balance Inquiry | Inquiry |
| FlexCube | TDM24 | Lien Master | Inquiry |
| FlexCube | 1413 | Loan Disbursement Inquiry | Inquiry |
| FlexCube | LN522 | Account Schedule Inquiry | Inquiry |
| FlexCube | LNM10 | Account Transactions Inquiry | Inquiry |
| FlexCube | BA433 | Collateral To Accounts Inquiry | Inquiry |
| FlexCube | BA434 | Account To Collateral Inquiry | Inquiry |
5. DD / PO, Cheque Book maintenance, Stop Payments and Security Stationery maintenance
| CBS Package | Menu Code / Access path | Menu Name | Menu Type (Inquiry/ Report) |
| FlexCube | CH078 | Cheque Status Maintenance | Inquiry |
| FlexCube | CHM35 | Stop Cheque Instructions | Inquiry |
| FlexCube | CHM37 | Cheque Book Issue Maintenance | Inquiry |
| FlexCube | IV011 | Stock Inquiry | Inquiry |
| FlexCube | IV004 | Inventory Lost report Register maintenance | Inquiry |
| FlexCube | MCA80 | Inquiry of sold/issued inventory | Inquiry |
6. Compliances
| CBS Package | Menu Code / Access path | Menu Name | Menu Type (Inquiry / Report) |
| FlexCube | TDS06 | Tax Parameters Maintenance | Inquiry |
| FlexCube | TDS04 | Tax waiver criteria Maintenance | Inquiry |
| FlexCube | TDS05 | Customer special Tax code maintenance | Inquiry |
| FlexCube | TDS11 | Tax Inquiry | Inquiry |
| FlexCube | SY001 | Guarantee Inquiry | Inquiry |
| FlexCube | BIM04 | Bill Parameters Maintenance | Inquiry |
| FlexCube | BIM05 | Bills Processing Maintenance | Inquiry |
| FlexCube | BI001 | Bills Data Entry | Inquiry |
7. Guarantee/Bills
| FlexCube | SY001 | Guarantee Inquiry | Inquiry |
| FlexCube | BIM04 | Bill Parameters Maintenance | Inquiry |
| FlexCube | BIM05 | Bills Processing Maintenance | Inquiry |
| FlexCube | BI001 | Bills Data Entry | Inquiry |
Audit Activity for LFAR and Tax Audit Requirements
Following are few checkpoints for auditors for reporting under Long Form Audit Report along with suggested system support.
| Audit Activity / Process
/ Audit Area |
Auditors’ Primary Checks | Suggested System Support |
| Cash | Ø Physical verification of Cash Balance
Cash Balance as on the date of Audit Period |
Ø GLM02 – Chart of Accounts
Ø GLM04 – GL Transactions and Movement Inquiry |
| Balances with RBI / SBI / Other Banks | Ø Balance as on Date
Ø Transactions in Mirror Accounts Ø Reconciliation Statement (Generally outside of CBS) |
Ø GLM02 – Chart of Accounts
Ø GLM04 – GL Transactions and Movement Inquiry |
| Advances | Ø Sanction Limit / Drawing Power setup | Ø CHM07 (OD Limit Master Maintenance)
Ø CH409 (OD Limit History Report) |
| Advances | Ø Account & Customer Master parameters setup viz.
Ø Interest Parameters (Regular & Penal Interest) Ø Repayment Instructions Ø Standing Instructions (SI) Parameters Ø Linking of Interest Rates with Benchmark Rates |
Ø BAM12 (Interest Index Maint.)
Ø BAM13 (Interest Index Rates) Ø LN060 (Loan Product Rates Plan) Ø LNM41 (Interest Rules) Ø LNM42 (Product Interest Attributes Maintenance) Ø LNM81 (Rate Change) |
| Advances | Ø Transactions in Borrower’s Account | Ø CH031 (Statement Inquiry) |
| Advances | Ø Interest Rate History | Ø LN022 (Interest Calculation Inquiry)
Ø LN608 (Interest Charges Report) Ø LN801 (Loan Interest Report) |
| Advances | Ø Temporary Overdraft | Ø CHM07 (OD Limit Master Maintenance)
Ø CH226 (Adhoc List of Overdue CASA Accounts) |
| Advances | Ø Non-Performing Asset
Ø Search an Account based on Criteria |
Ø AC02 – CRR (Credit Risk Rating) Inquiry
Ø LN156 – Non Performing Loan Details Report Ø LN191 – Accounts in NPA Status |
| Advances | Ø Interest Report | Ø LN022 (Interest Calculation Inquiry)
Ø LN608 (Interest Charges Report) Ø LN801 (Loan Interest Report) |
| Advances | Ø Primary & Collateral Security Maintenance | Ø CH066 Limit Collateral Inquiry
Ø CHM06 OD Collateral Maintenance |
| Advances | Ø Lien Marking | Ø TDM24 Lien Master
Ø CH031 Statement Inquiry Ø 7010 Passbook update Ø LNM10 Account Transactions Inquiry Ø LN421 Statement of Account NPA |
| Stationary | Ø Physical Verification of Stationery and confirmation of Balance as per CBS | Ø IV011 – Stock Inquiries
Ø IV001 – Stock Transactions Ø IV002 – Stock Adjustment |
| Office Accounts (Suspense, Sundry etc.) | Ø Outstanding entries for reporting
Ø Entries outstanding – Whether any provisioning is required? |
Ø GLM02 – Chart of Accounts
Ø GLM04 – GL Transactions and Movement Inquiry |
| TDS Related | Ø TDS Information and Reports | Ø TDS11 TDS Inquiry
Ø TDS15 Inquiry on Projected Tax |
Miscellaneous Useful Commands.
| CBS Package | Menu Code / Access path | Menu Name |
| FlexCube | LN158
|
Loan arrears aging analysis- NPA Related |
| FlexCube | LN167
|
Loan Statement other than CC Account |
| FlexCube | CH118
|
Overline/TOD Report |
| FlexCube | CH185
|
Cheques Purchased report |
| FlexCube | CH194
|
Daily Overline/ TOD Transaction report |
| FlexCube | CH701
|
Customer account balances-Other than loans-For standard accounts but including CC limit accounts
|
| FlexCube | CH703
|
RD account balances- Customer wise |
| FlexCube | CH704 | Current account NPA’s report including CC limit accounts |
| FlexCube | CH705 | Customer acount balances- Other than loans Both standard and NPA’s |
| FlexCube | CH713 | ATM/POS DAILY Transactions Report |
| FlexCube | GL306 | Interbranch transactions report |
| FlexCube | GL307 | Interbranch transactions Summary |
| FlexCube | IB005 | Details of Third Party Funds Transfer |
| FlexCube | LN157 | NON PERFORMING LOANS SUMMARY |
| FlexCube | LN152 | LOAN BALANCE MOVEMENTS-Product wise |
| FlexCube | LN163 | Accounts closed on a particular day report |
| FlexCube | LN192 | Fresh NPA’s report |
| FlexCube | LN215 | Loan arrears details without NPA aging |
| FlexCube | LN201 | Loan accounts opened on that day report |
| FlexCube | LN236 | Loans disbursement pending report |
| FlexCube | LN252 | Collateral inadequacy report |
| FlexCube | LN304 | Loans account with credit balance |
| FlexCube | LN351 | Loans account wise balance report |
| FlexCube | ST002 | Inter branch transactions journal |
| FlexCube | ST015 | Cheques pending for clearance |
| FlexCube | TD101 | Term deposits-Deposits opened on that day report |
| FlexCube | TD102 | Term deposits-Maturities due report |
| FlexCube | TD103 | Term deposits-Maturities today report |
| FlexCube | TD104 | Deposits renewed report-on that day |
| FlexCube | TD105 | TIME DEPOSITS – DEPOSITS REDEEMED TODAY REPORT |
| FlexCube | TD107 | Time deposits-INTEREST ACCRUAL REPORT |
| FlexCube | TD108 | Time deposits- INTEREST PAID TODAY REPORT |
| FlexCube | TD112 | TIME DEPOSITS – ACCOUNT TRIAL BALANCE |
| FlexCube | TD114 | TIME DEPOSITS – CUSTOMER-WISE TAX DEDUCTION REPORT |
| FlexCube | TD130 | Time deposits-DEPOSITS CLOSED TODAY REPORT |
| FlexCube | TD143 | Time deposits- DEPOSITS CREATED BY MATURITY INSTRUCTIONS report |
| FlexCube | LCO | OUTSTANDING LC’s and BG’s PRODUCT WISE REPORT |
| FlexCube | CH106
|
Savings Account report |
| FlexCube | FCC
|
Customer wise dues Accounts held by Large borrowers report above 1 Crore |
Author Bio
NICE