Audit Through Core Banking Solution

Views:
 
     
 

Presentation Description

The Presentation for Chartered Accountants for Statutory Bank Branch Audit in Core Banking Software (CBS) Environment - Focus on Finacle from Infosys and B@NCS from TCS

Comments

Presentation Transcript

slide 1:

Bank Audit Through CBS An Introduction

slide 2:

Bank Audit Through CBS Disclaimer These are our personal views and can not rather shall not be construed to be a Professional Advice and be acted upon. You may retain any Benefit accruing to you out of the same. No representation or warranties are made by the Professional with regard to this presentation. This presentation may not be reproduced in part or in whole in any manner or form without our written permission.

slide 3:

Are You Familiar with ... Banking Systems - with NPAs Computer Network Internet - with Hackers Next Door Mobile Sorry Smart Phone - CA FirmPune Duped by Rs. 79 Lacs. Bank Audit Through CBS

slide 4:

Today the Computer is taking Centre Stage of Banking and leading all the Good / Fast √ results. ✓ Goodies are ATMs / Cr. Cards / Debit Cards / Online Banking many more... Are we prepared to understand what this means A slight neglect may result in anything… Bank Audit Through CBS

slide 6:

Fund Based Advances D CC - Demand Cash Credit S OD - Secured Over Draft Ad hoc Over Draft EPC - Export Packing Credit Purchase Order Defacing TL - Open Term Loan Non Fund Based Advances BG - Bank Guarantee Revolving BG LC/LSC - Letter of Small Credit Bill Discounting Usanse / Collection / Sight Buyers Credit Banking and Advances Bank Audit Through CBS or the Line of Credit

slide 7:

• Core Banking Solutions are – typically relational database management packages with a GUI – Programmes are used to • Automate number crunching • Validating • Locking / authorising limits • Consolidating Bank Audit Through CBS

slide 8:

CBS is Distinguished from LAN Bank Audit Through CBS

slide 9:

CBS is Distinguished from LAN which is total branch automation Bank Audit Through CBS Parameter CBS LAN Data Storage on Line Local Updation on Line Local Controls Web Based App Controlled Reports Web Based / Stored Live Backup Web Based / on Line Local

slide 10:

The Prime CBS Vendors Finacle from Infosys - Bank of Baroda Bank of India Union Bank of INdia IDBI Bank ICICI Bank Axis Bank Vijaya Bank Uco Bank Punjab National Bank Bncs from TCS - State Bank of India and Associates Allahabad Bank Bank of Maharashtra Central Bank of India. FlexCube from iFlex - HDFC Bank Top 10 Banking Software for Financial / Banking Services in India 1. Infosys - Finacle 2. TCS - Bancs 3.Oracle FSS Oracle Financial Services Software - iFlex 4.TEMENOS - Temenos T24 5. Polaris - Intellect suite 6. Nucleus Software - FinnOne 7. Infrasoft Technologies - OMNIEnterprise 8. Saraswat Infotech Limited SIL - SwiftCore 9. Misys - BankFusion Universal Banking 10. FIS | Fidelity Top 10 Banking Software for Financial / Banking Services in India 1. Infosys - Finacle 2. TCS - Bancs 3.Oracle FSS Oracle Financial Services Software - iFlex 4.TEMENOS - Temenos T24 5. Polaris - Intellect suite 6. Nucleus Software - FinnOne 7. Infrasoft Technologies - OMNIEnterprise 8. Saraswat Infotech Limited SIL - SwiftCore 9. Misys - BankFusion Universal Banking 10. FIS | Fidelity Top 10 Banking Software for Financial / Banking Services in India 1. Infosys - Finacle 2. TCS - Bancs 3.Oracle FSS Oracle Financial Services Software - iFlex 4.TEMENOS - Temenos T24 5. Polaris - Intellect suite 6. Nucleus Software - FinnOne 7. Infrasoft Technologies - OMNIEnterprise 8. Saraswat Infotech Limited SIL - SwiftCore 9. Misys - BankFusion Universal Banking 10. FIS | Fidelity Top 10 Banking Software for Financial / Banking Services in India 1. Infosys - Finacle 2. TCS - Bancs 3.Oracle FSS Oracle Financial Services Software - iFlex 4.TEMENOS - Temenos T24 5. Polaris - Intellect suite 6. Nucleus Software - FinnOne 7. Infrasoft Technologies - OMNIEnterprise 8. Saraswat Infotech Limited SIL - SwiftCore 9. Misys - BankFusion Universal Banking 10. FIS | Fidelity Bank Audit Through CBS

slide 11:

The Other CBS Vendors Temenos - Temenos T24 Polaris - Intellect Suite Nucleus Software - FinnOne Infrasoft Technologies - OmniEnterprise Saraswat Infotech - SwiftCore Misys - BankFusion Universal Banking Fedility - FIS Bank Audit Through CBS Top 10 Banking Software for Financial / Banking Services in India 1. Infosys - Finacle 2. TCS - Bancs 3.Oracle FSS Oracle Financial Services Software - iFlex 4.TEMENOS - Temenos T24 5. Polaris - Intellect suite 6. Nucleus Software - FinnOne 7. Infrasoft Technologies - OMNIEnterprise 8. Saraswat Infotech Limited SIL - SwiftCore 9. Misys - BankFusion Universal Banking 10. FIS | Fidelity Top 10 Banking Software for Financial / Banking Services in India 1. Infosys - Finacle 2. TCS - Bancs 3.Oracle FSS Oracle Financial Services Software - iFlex 4.TEMENOS - Temenos T24 5. Polaris - Intellect suite 6. Nucleus Software - FinnOne 7. Infrasoft Technologies - OMNIEnterprise 8. Saraswat Infotech Limited SIL - SwiftCore 9. Misys - BankFusion Universal Banking 10. FIS | Fidelity Top 10 Banking Software for Financial / Banking Services in India 1. Infosys - Finacle 2. TCS - Bancs 3.Oracle FSS Oracle Financial Services Software - iFlex 4.TEMENOS - Temenos T24 5. Polaris - Intellect suite 6. Nucleus Software - FinnOne 7. Infrasoft Technologies - OMNIEnterprise 8. Saraswat Infotech Limited SIL - SwiftCore 9. Misys - BankFusion Universal Banking 10. FIS | Fidelity Top 10 Banking Software for Financial / Banking Services in India 1. Infosys - Finacle 2. TCS - Bancs 3.Oracle FSS Oracle Financial Services Software - iFlex 4.TEMENOS - Temenos T24 5. Polaris - Intellect suite 6. Nucleus Software - FinnOne 7. Infrasoft Technologies - OMNIEnterprise 8. Saraswat Infotech Limited SIL - SwiftCore 9. Misys - BankFusion Universal Banking 10. FIS | Fidelity Top 10 Banking Software for Financial / Banking Services in India 1. Infosys - Finacle 2. TCS - Bancs 3.Oracle FSS Oracle Financial Services Software - iFlex 4.TEMENOS - Temenos T24 5. Polaris - Intellect suite 6. Nucleus Software - FinnOne 7. Infrasoft Technologies - OMNIEnterprise 8. Saraswat Infotech Limited SIL - SwiftCore 9. Misys - BankFusion Universal Banking 10. FIS | Fidelity Top 10 Banking Software for Financial / Banking Services in India 1. Infosys - Finacle 2. TCS - Bancs 3.Oracle FSS Oracle Financial Services Software - iFlex 4.TEMENOS - Temenos T24 5. Polaris - Intellect suite 6. Nucleus Software - FinnOne 7. Infrasoft Technologies - OMNIEnterprise 8. Saraswat Infotech Limited SIL - SwiftCore 9. Misys - BankFusion Universal Banking 10. FIS | Fidelity Top 10 Banking Software for Financial / Banking Services in India 1. Infosys - Finacle 2. TCS - Bancs 3.Oracle FSS Oracle Financial Services Software - iFlex 4.TEMENOS - Temenos T24 5. Polaris - Intellect suite 6. Nucleus Software - FinnOne 7. Infrasoft Technologies - OMNIEnterprise 8. Saraswat Infotech Limited SIL - SwiftCore 9. Misys - BankFusion Universal Banking 10. FIS | Fidelity

slide 12:

Bank Audit Through CBS Finacle

slide 13:

Bank Audit Through CBS Key Function F1 Field Level Help F2 List the Codes in a particular Field F3 / Esc Quit / Back / Escape Shift + F3 Completely Quit / Bring Back to Main Menu F4 ACCEPT and validate the Value and Move to next Field F5 Send the Screen to Background visit other Menu item F6 Next Block / Next Page F8 Copy a Record F9 View Signature F10 Commit Update Database Records F11 Next Field F12 Previous Block Finacle F Keys

slide 14:

Bank Audit Through CBS Key Sets Function Tab / Enter Go to Next Valid Field Shift + Tab Go to Previous Valid Field Control + Next Record Control + Previous Record Control + F9 MEMO Pad Look up Control + U Page Up in List Control + D Page Down in List Control + E Explode / Drill Down / Details Control + F Flush / Clean / Clear Field Contents Control + X Current Date or BoD Shift + F4 Select From List Finacle Keys

slide 15:

Bank Audit Through CBS Menu Function ACLI Account Ledger Inquiry ACI ACLI then Control+E EMI No of Instalments Over-Due in A/c CUS Customer Selection on Criterion Y for TDS Exempted List CUMI / CUMM Customer Master Inquiry / Maintenance ACM Account Master - for Basic Details ACS Account Selection - with Criterion Customer / Ledger Inquiry Finacle

slide 16:

Bank Audit Through CBS Menu Function INTTM Interest Table Master Deposit / Advances AINTRPT Interest Report for Loan A/cs ACINT Verify running Interest Calculation TM TI Transaction Maintenance / Transaction Inquiry Transaction ID and Date used for Inquiry FTI Financial Transaction Inquiry on Criterion ACLPOA Account Ledger Print Office Account for Printing PSP Pass Sheet Print - for Printing A/c Statement IOT Inquiry on Transaction - Reversals Suspense A/c etc. Interest Inquiry / Transaction Inquiry Finacle

slide 17:

Bank Audit Through CBS Menu Function SRM Security Register Maintenance for Drawing Power Stock Statement Submission Insurance Coverage Last Valuation Date. ALM A/c Lien Maintenance for preventing inconsistant transactions ACTODM A/c TOD Maintenance System Generated or User Generated Single Type Running Type Period Based or Ad-hoc Type Period based Loan Inquiry / Security Inquiry Finacle

slide 18:

Bank Audit Through CBS Menu Function LAOPI Loan Advance Overdue Position Inquiry Principal and Interest of a Loan A/c LTL LNDI Limit Tree Lookup Limit Node Inquiry ACLHM A/c Limit History Maintenance Verify History of Drawing Power and Sanctioned Limit CHLMT Change in Sanction Limit ODFDREP Report for Matured OD / FD Accounts PCFCBAL Packing Credit FC Balancing Report Loan Overdue / Limit Inquiry Finacle

slide 19:

Bank Audit Through CBS Menu Function INQLADC Loan Document Expired Report STKSTMT Stock Statement not Received PLIST Pending Instalments List ACTI ATOR A/c Turnover Inquiry / Report INSEXPD INSTOEXP Insurance Expired Report LAROR Loan A/c Not Reviewed LFAR Schedules/ Audit Inquiry Finacle

slide 20:

Bank Audit Through CBS Menu Function BM BI Bill Maintenance Bill Inquiry Inland Bills Cheque Purchased Sent for Collection FBM Foreign Bill Maintenance FBI Foreign Bill Inquiry - on Various Criterions FBP Foreign Bill Inquiry - Printing BRBPR Balancing Report for Bills Purchased Inland Status BRCR Balancing Report for Bills on Collection Inland Status FBBR Balancing Report for Foreign Bills Status Bills Inquiry Finacle

slide 21:

Bank Audit Through CBS Menu Function GILR Guarantee Issued Liability Register BGMARGIN BG Margin Printing GENR Guarantee Expired not Reversed GIPNP Guarantee Invoked not Paid DCQRY DCSTMT Documentary Credit Issued Query DCEXPLST DCLIABRG Documentary Credit Expired Documentary Credit Liability Register CHGIR Charges Income Register Bank Guarantee / Letter of Credit Finacle

slide 22:

Bank Audit Through CBS Menu Function ISAR Inter Sol Audit Report Inter Branch ISTR Inter Sol Transaction Report Inter Branch IRM Inward Remittance Maintenance ORM Outward Remittance Maintenance LKRCM LKTRM Locker Rent Change Collection Maintenance TDSIP TDS Inquiry and Print TDSREP Customer wise TDS Report Misc. Reports Finacle

slide 23:

TCS BNCS Sample Screen Bank Audit Through CBS Main Menu Help Cancel Previous Next Keys Shortcut Menus Icons Collapse All Menus Button Deposit / CC / OD Accounts DL / TL Accounts Services

slide 24:

Bank Audit Through CBS Customer Management— Function Enquiries— Search by CIF No. Search Enquiries — Search by ID No. Search Enquiries — Search by Name Search Relationship / Ownership— Associated Accounts Linked Accounts Customer Reports TCS BNCS

slide 25:

Bank Audit Through CBS Deposit / CC / OD A/c Master— Function Enquiries— Deposit / CC / OD A/c Verify A/c Details Enquiries — Short Basic Enquiry Enquiries — Long Detailed Enquiry Enquiries — Transaction for Transaction Enquiry Amend — Pending Charges Pending Charges Details Deposit / CC / OD A/c Master Transactions TCS BNCS

slide 26:

Bank Audit Through CBS Branch Accounting— Function Enquiries— Account Enquiry Enquiries — Account No. Search Search by No. Enquiries — Transaction for Transaction Enquiry Branch General Ledger Transactions TCS BNCS

slide 27:

Bank Audit Through CBS DL/TL Accounting Services— Function Loan Tracking — Operations To Change Interest Rate Loan Processing — Generate Repayment Schedule — Action - E Print Repayment Schedule Enquiries — Short — Option “Balance Breakup Enquiry” To View Arrears Breakup of Principal Interest Securities Primary / Collateral — Customer— Enquiry — Enquire Security Summery Find Collateral Details Loan Module TCS BNCS

slide 28:

Bank Audit Through CBS Menu Function Valuable Paper Inventory System— Enquiry of VPIS — General Enquiry Check Inventory Collection and Cheque Purchase — Enquiries — Enquiries Inquiry on Cheque purchased / sent for collection Misc Matters TCS BNCS

slide 29:

It may be noted that All Menu Codes as discussed above may not be operative in Finacle / Bncs in all the banks. Again some of these Menu Codes may be customised by a particular Bank for its specific needs of CBS Environment. Bank Audit Through CBS

slide 30:

Application Controls Operating System Controls Database Controls Physical Checks Logical Checks Exception Reports Red Flags Bank Audit Through CBS The CBS Audit can be elaborated as

slide 31:

DP / Limit Setting Data Validation Processing of Data KYC Compliance Computer Internet Parallel Systems Maker Checker Application Controls Bank Audit Through CBS

slide 32:

Roll Setting Password Management Authorisation Matrix Computer Accessibility Rating / Interest Rate Classification Change authorisation Exception Reports of Login Login Matching with Leave Logical Controls/ Access Controls Bank Audit Through CBS

slide 33:

§ Filing of Followup Reports - FFR / QIS / Stock Statement in System § Major Transactions Report Top 5 Dr Top 5 Cr etc. § Cash Movements - from Bank to Chest Account to Account etc. § Currency Chest vis-a-vis CBS Balance Amendments Data Mining Bank Audit Through CBS

slide 34:

Packing Cr released to CC - Charging of Interest Bank Guarantee properly created/renewed i.e. date etc. Term Loans instalments properly recorded in Master Changes due to Credit Rating / Financial Statements Management Change and RoC Filings etc. Consortium Bankers Drawing Power Intimation / MoM Re-Valuation of Security at regular intervals e.g 3 years. Credit Facility Bank Audit Through CBS

slide 35:

Timely Stock Audit Revenue Leakage Audit Cash and Bank Reconciliation Joint Custody. NPA Income Recognition Asset Classification in System Collection from Customers which are Written Off Comments of Inspection Committee Last Years Report. Pen Drive Policy. Not to be used with CBS Terminal Location of Main Power Switch and Power Backup Good Governance Bank Audit Through CBS

slide 36:

Stock Reconciliation of Stationary etc. Stamps in name of Bank Advantage of Weak Internal Control Passwords communicated easily Multiple Loans on Same Property / Same Guarantor. Check Cersai / CIBIL Reports Every Security Provider should be Guarantor to Facility. Check all Ownerships and Guarantors Stamp Duty Payment should be in Proper Online Code. Check Points Bank Audit Through CBS

slide 37:

Equitable Charge Creation Document. Registered Charge Creation if any. Registration of Equitable Charge with Sub Registrar. Cersai Registration of Charge. Registration of Charge with Registrar of Companies if any. Registration / Boja on Property Card / City Survey Record. Updating Data with CIBIL in Time. Check Points in Charge Bank Audit Through CBS

slide 38:

Lien marking on FD for OD / BG / LC. Window Dressing by Short Review No Credits for Interest in CC/OD Loan Against LIC Policy Policy given to Customer for Money Back Claim - Check Assignment. Ad-hoc Limits - Finacle - effective even after given time period Cases for Discussion Bank Audit Through CBS

slide 39:

Everything we hear is an opinion NOT a Fact Everything we see is a perspective NOT the Truth. Bank Audit Through CBS

slide 40:

Giving Incomplete Information Documents Addiction Expensive Lifestyle Heavy Funds / Cash Movement Business Loss of Borrower Clues in Title / Charges in Search for Property Parallel Systems / Classification Facilities Sanctioned in March No Staggered Disbursement Old Quotations used - ve Databases The Red Flags Bank Audit Through CBS

slide 41:

Indian Penal Code 1861 Companies Act 2013 CARO The Banking Regulation Act 1949 Exceptional Reports for RBI Prevention of Corruption Act Income Tax Act 1961 Information Technology Act 2000 Securitisation Act Taking Possession of Property by Banks The Law for Audit Fraud Enforcement Bank Audit Through CBS

slide 42:

Bank Audit Through CBS Fraud Detection

slide 43:

Thank You Charudutt Marathe F.C.A. D.I.S.A.ICA F.I.C.A. C.F.E. LL.B. B.Com. charuduttmyahoo.co.in 093714 32369 0712 - 2532369 Bank Audit Through CBS

authorStream Live Help