Basics of Bank Audit in CBS environment-

Basics of Bank Audit in CBS environment

CA Rahul Nahar
CA Alok Somani

1. Statutory Bank
Branch Audit -
CBS Tools

Prepared by
▪CA Alok Somani CA Rahul Nahar
9967579781 8989464889

2. Applications (CBS)
used in Banks
Finacle Bancs Link Flexcube

3. Finacle
1. Andhra Bank
2. Bank of Baroda
4. Bank of India
5. Corporation Bank
6. Dena Bank
7. IDBI Bank
8. Indian Overseas Bank
9. Oriental Bank of
Commerce
10. Punjab & Sind Bank
11. Punjab National Bank
12. UCO Bank
13. United Bank of India
14. Union Bank of India
15. Vijaya Bank

4. Reports in Finacle
▪Reports are generated by Branch code
▪Report keys are required to be inserted to
generate a report

5. Welcome screen on Finacle 10

6. Different reports available in Finacle
▪ List of all loan and OD A/c - A1A4 or Jotting report or Daily o/s
report
OR ___RPT >> Report code: RPT_3 >> RPT_3_7A (called as 3/7)
▪____RPT/ FINRPT / HFINRPT – List of reports
▪Overdue advances report – HPRR2
▪PC Overdue report – HEXPPCI/ HDEFPC
▪Contingent liabilities (LC & LG) – HGILR/ HBKGURI/ HDCLIABR/
HDCREG
▪Account Master Print - ACMP
▪Balancing Report - BR
▪Loans Repayment Schedule Report – HLARSH
▪HPR>> Printing of report generated through above commands.

7. Different viewing commands under
▪Account Ledger Inquiry>> ACLI/ HACLI
▪Complete details of LOAN account >>ACLIMQ/ HACLIMQ
(This provides details of mortgage securities/ Documents/
Insurance details.
▪ACLHM/ HACLHM / ACM>> Limit/ DP/ Sanction date/ expiry
date/ stock
▪Account Interest Details Inquiry >>AITINQ / HAINTRPT
▪Customer Master Inquiry >>CUMI/ CUMM
▪Poor Turnover/ Account turnover >>ATOR/ ACTI/ HACTI

8. Bancs Link
1. State Bank of India
2. Allahabad Bank
3. Bank of Maharastra
4. Central Bank of India
5. Indian Bank

9. Different reports under Bancs Link
▪Automated reports are generated on daily
basis for the branch in report folder
▪Different sub folders are available for
different reports

10. Welcome Screen

11. Viewing commands
▪60450 - All account search by CIF/ Account no
▪450 – Account ledger enquiry/ transaction enquiry
▪20450 – Bank General Ledger Enquiry
▪10511 – NPA status enquiry
▪700 – CC OD statement printout
▪10700 – TL Statement printout
▪10400 / 10440/ 10450- Short enquiry / Long Enquiry
(Customer profile)

12. Reports

13. Reports>> LOANS

14. Reports>> BMS Folder

15. Sample Reports
▪Exception_report_for_interest_rates_variation_for_CCOD_depd0650.txt


▪Exception_report_for_interest_rates_variation_for_DLTL_lond7002.txt



▪ZERO_LIMIT_ZERO_DP_CCOD_WCDL_ACCOUNTS_lond7059



▪LoansBalanceFile-lond2390.txt

16. Flexcube
1. Canara Bank
2. Syndicate Bank

17. Reports in Flexcube
▪Reports to be downloaded from reporting
server
▪Mostly reports available in EOD report ie.
LN167, CH701, AL167
▪Some exceptional report ie. SMA(FCR SMA,
FCC SMA), OD limit expiry report etc. required
to be requested separately

18. Viewing commands in Flexcube
▪BASIC COMMANDS
For request: 7775
For download report/statement 7778

▪DIRECT/SHORTCUT COMMANDS
CH031 - Customer Ledger Enquiry – CC/OD/SB/CC
CHM06 - Collateral & Stock statement
CHM07 - Limit Enquiry
LNM10 – Loan Enquiry
1000 - CIF Enquiry
7026 - Term Loan Enquiry
GLM04 - GL Enquiry

19. Thank you
Regards,
CA Alok Somani CA Rahul Nahar
[email protected] [email protected]