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.

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

Qualification: CA in Practice
Company: N/A
Location: Meerut, Uttar Pradesh, IN
Member Since: 17 Jun 2018 | Total Posts: 113
Author was Member of ICAI- Regional Research Committee 2013-14 and ICAI- Committee For Direct Taxes 2011-12 and can be reached at email [email protected] or on phone Phone: 0 1 2 1-2 6 6 1 9 4 6. Cell: 9 8 3 7 5 1 5 4 3 2 having office at 1 1 5, Chappel Street, Meerut Cantt, UP, INDIA) View Full Profile

My Published Posts

More Under CA, CS, CMA

One Comment

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Posts by Date

April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930