Overview of Core Banking Solutions in Financial Institutions
Core Banking Solutions (CBS) play a vital role in modern banking systems, providing efficient and integrated services to customers. This content provides insights into Finacle and other CBS applications used by various banks, highlighting modules like SSO, CRM, and GL processes. It includes diagrams and explanations of scheme types, GL codes, and account references. BH Rama Murty, Chief Manager IT at Bank of India, is at the forefront of implementing these solutions.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
FINACLE & CORE BANKING SOLUTION BH RAMA MURTY , CHIEF MANAGER IT BANK OF INDIA
CORE BANKING SOLUTIONS IN VARIOUS PRIVATE AND PUBLIC SECTOR BANKS Application Name Finacle Provider Infosys Banks Using the Application BOI, UBI, BOB, IOB, PNB, PSB ICICI, Axis, IDBI etc Canara Bank HDFC, YES Bank etc SBI, BOM, CBI, Indian Bank etc Flexcube Oracle(iFlex) TCS& BaNCS TCS BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
MODULES IN FIANCLE CBS SSO ( Single Sign On) CRM ( Customer Relationship Module) CORE( CBS Core Module) SVS( Signature Verification System GBM( Government Business Module) BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
GENERAL LEDGER PROCESS DIAGRAM >General Ledger in the Core Banking Solution is supported both at the GL head and the GL sub head levels. >In the Core Banking Solution, the GL head is a reference code used to dynamically generate the consolidated position. >The GL sub head provides day-wise information for each SOL and in each currency. BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
GENERAL LEDGER PROCESS DIAGRAM Scheme Type GL Code GL Sub Head Code Scheme Code Currency Example : Scheme Types are Like SBA, TDA, ODA, CCA , LAA, PCA Scheme Codes under SBA can be defined as SB101,SB102, SB103 etc etc GL Code for Savings Accounts like 10 GL Sub Head Codes under Saving GL Code like 10011, 10012,10013 BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
GENERAL LEDGER PROCESS DIAGRAM All accounts in the Core Banking solution have the following references: SOL to which the account belongs Currency to which the account is linked Product code or scheme code under which the account is opened Note: The scheme code is used for behaviour validations. It maps directly to the various products offered by the bank. Based on the features of these products, scheme codes are categorized under 17 predefined scheme types in the Core Banking Solution. Scheme type: This is a grouping/segregation based on the type, nature and behaviour of account. Scheme code: This is one set of rules defined by the user on a scheme type for particular behaviour of a group of accounts. GL Sub head: All data are consolidated and stored daily during the End of Day process at this level for further consolidation and reporting in General Ledger. SOL: SOL refers to Service Outlet. Both an extension counter of a branch as well as a full-fledged branch is termed as a Service Outlet (SOL) in Finacle. BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
Scheme code creation The Below Details are mandatory to open a Scheme Code : >General Details >Scheme Details >Currency Details >GL Sub Head Codes Menu: HGSPM BH Rama Murty , Chief Manager IT , Bank of India
Scheme code creation HGSPM: GL SUB-HEAD CODES DETAILS In HOAACSB menu GL Sub Head Code will Populate automatically. BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
OFFICE ACCOUNTS A Assets (Office accounts used for recording Assets eg. Fixed Assets) B- Balance Sheet (Office accounts used for Balance sheets items like prepaid expenses etc ) C Cash (Office accounts used for recording CASH) E Expenditure (Office accounts used for recording Expenditures) I Income (Office accounts used for recording Incomes) L Liabilities (Office accounts used for recording Liabilities like amounts held in trust etc .) N OBS Non Contingent Contra (Office accounts used for recording Off Balance Sheet Contra Accounts Eg. Syndication contra Account) O - OBS Non Contingent Asset (Office accounts used for recording Off Balance Sheet Non contingent Accounts Eg. Syndication draw down Account) P Capital (Office accounts used for recording Capital Account) S Sundry (Office accounts used for recording Sundry & Suspense Accounts) T Loan Interest Account (Office accounts used for recording Loan Interest Accounts). BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
OFFICE ACCOUNTS Sl. No. 1. 2. 3. Scheme Type Finacle Abbreviation OAB OAP OSP Category Office Account Basic Office Account Pointing Office Account System Pointing Head Office Accounting Demand Draft Office Account Dummy Savings Current Overdraft Cash Credit Term Deposit Term Loans Internal to bank Internal to bank Internal to bank 4. 5. 6. 7. 8. 9. 10. 11. 12. HOC DDA OAD SBA CAA ODA CCA TDA LAA Internal to bank Internal to bank Internal to bank Customer related Customer related Customer related Customer related Customer related Customer related BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
OFFICE ACCOUNTS Sl. No. 13. 14. 15. 16. 17 Scheme Type Finacle Abbreviation Category Commercial Lending Bills Inland Bills Foreign Packing Credit Top up deposits CLA BIA FBA PCA TUA Customer related Customer related Customer related Customer related Customer related BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
OFFICE ACCOUNTS An office account is an account which is opened, without reference to a CIF Id or without involving a customer where all operations on the account are initiated and done by the Bank and in which features like issuance of cheque book, charge calculation, minimum balance check, and interest calculations are not applicable. Office accounts are required by the banks to record transactions relating to: Assets and Liability Accounts Income and Expenditure Accounts Contingent Accounts Provision Accounts Inter Branch Accounts Sundry & Suspense Accounts Demand Drafts & Banker s Cheque Accounts BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
OFFICE ACCOUNTS Office Account Basic(OAB): Accounts like Cash, Asset accounts, Liability Accounts, Contingent Accounts, Interest, Commission, Exchange, Discount, and Charges are opened under this Scheme Type. Office Account Pointing (OAP): This Scheme Type is used for opening Sundry and Suspense Accounts. Office System Pointing (OSP): This Scheme Type is used for opening only Proxy Accounts, where the system is not expected to do any parameter validations. Proxy accounts are used for posting un- posted transactions wherever necessary if defined in the bank parameters in the HSCFM menu. Head Office Accounts (HOC): HO Accounts are used for accounting Inter- Bank, Inter Branch and Clearing Transactions. (E.g.: MT, TT). These accounts are mainly used for inter branch reconciliation and transfer of funds from Finacle branch to a non Finacle branch. Demand Draft Accounts (DDA): Under DDA Scheme Type, account used for handling issue and payment of Demand drafts, Bankers Cheque, Pay order and Cashier Cheque are opened. Account placeholder: Account Placeholder is a concept used in Finacle, for the system to pick appropriate office account for posting in certain transactions based on context level SOL and Currency BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
OFFICE ACCOUNTS Office Accounts are opened using the menu option HACMDB. While opening an Office Account the user has to specify the following details: Service Outlet to which it belongs (Defaulted with the user login SOL) The Currency in which it is being opened (Default Home Currency) The GL Subhead to which it belongs to (Default GL Subhead, if specified in the HOAGSPM) The Scheme Code under which it is being opened.( this has to be specified by the user) Menu : HACMDB BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
OFFICE ACCOUNTS Consolidate Balance This feature helps banks in consolidating balances in selected office accounts into a single designated office account. Transferring balances in the different income and expense accounts to retained earnings account at the end of the accounting year is a good example for this kind of activity. GRCBBSA menu will generate a report of balances consolidated. Async Accnt Balance update This feature helps overcome performance issues arising when the system is trying to create simultaneous transactions on the same office account. Example : When interest run (HACINT) is in progress for savings deposit accounts, system parallelises posting transactions to the savings deposit accounts. Since it is the same office account (Interest paid on SB accounts) that gets debited for all these parallel transactions, till the first set is posted and balance is updated, all other subsequent transactions fail. This is because the debit account is locked till the first set is posted. This results in performance issue. When this field is set to yes, system just posts all the transactions simultaneously without waiting for the balance to be updated. BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
OFFICE ACCOUNTS HACLINQ is the menu for inquire on balances and transactions that have taken place in an office account. . HACLPOA is the menu option, which provides this feature of printing of office account statements. BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
OFFICE ACCOUNTS Menu : HIOT (INQUIRY ON POINTING TYPE OF TRANSACTIONS) This menu will be very handy for a bank used to inquire on outstanding entries in a sundry or suspense accounts. Menu: HMSOIRP (OUTSTANDING ITEM REPORTS AGE WISE) This report gives the user an age wise (in no of days) break-up of outstanding amounts in pointing accounts. BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
OFFICE ACCOUNTS Menu: HMSGOIRP (OUTSTANDING ITEMS REPORT) This report gives the user the details on the original amount and the amount outstanding in an account. It gives the summary report wherein the consolidated opening balance, credit amounts, debit amounts and closing balance for a GL head is reflected. HIEARP (INCOME/EXPENDITURE ANALYSIS REGISTER) This report is used for monitoring the transactions posted to Income and Expenditure accounts. It gives the details of all the transactions done for a period, not only for a GL head but also for the GL sub-head. Menu: HMSTRP (TRANSACTION REPORTS) The HMSTRP option is used to print the report of all transactions on pointing type of accounts. This report is similar to the Office Account Ledger Print report, except that reversal date is available on this report. BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
Inter-SOL (ISO) Account Whenever a transaction takes place between two accounts of different branches (SOLs-Service Outlets), in order to balance the transactions for individual branches, the system has to use some office account. The reason being when the individual SOLs draw their balance sheet, the accounts must match and both sides of the balance sheet must be balanced. A self-reconciliation process by way of summing up of balances in all ISO accounts across SOLs in a Data Centre will be done and it is ensured that the balance is Zero at the end of the day during EOD/BOD processes for each currency. For Example: As part of end of day, the Core Banking Solution creates a transaction as: Credit ISO account of Branch A 1000 Debit ISO account of Branch B 1000 Now the entries available at Branch A are as follows: Debit Savings Bank Account 123 of Branch A 1000 Credit ISO account of Branch A 1000 Similarly entries available at Branch B are as follows: Credit Savings bank Account 456 of Branch B 1000 Debit ISO account of Branch B 1000 With the above entries the balance sheet of both branches tally. BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
Inter-SOL (ISO) Account 1.PROCESS DIAGRAM Run ISO Reconciliation Programme-HRIST BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
EVENT BASED CHARGES Charges calculation is on Event Based and user can define the structure Event Id and Event Type to be collected . In Finacle these events are pre-defined. Some of the Events are as below: Sl No 1 2 3 4 5 6 7 8 Event Type ACCLS ACHCI ACHCO ACCMNT ACOPN BGADD DDD DORM Event Description Account Closure ACH Inward charges ACH Outward Charges Account Maintenance Account Opening Bank Guarantee Issue Duplicate DD charges Account Dormant Charges BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
EVENT BASED CHARGES BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
EVENT BASED CHARGES Bank Level Fee Setup in HSCFM menu: Partial Recovery of charges are available and this can be set in HSCFM menu. Whenever the parameter is set Y , during charge recovery process system will recover charges partially and marks lien for uncollected amount A Batch Job APCHCOLL will collect pending charges whenever balance is available in the charge debit account. Menu HPPTM is for Charge Event Setup BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
EVENT BASED CHARGES Batch Charge Calculation: Using HBCCALC menu , the following charges can be collected. Ledger Folio Charges/Account maintenance charges, Dormant charges, Minimum Balance charges, Inactive charges , Commitment charges. Reports/ Inquiry Menus: HCLCI : Charge level code can be enquired using the menu HCLCI. HCLCSR: Charge level Code status report Status report of different versions of the charge level code , active as well as suspended. HCRV : Inquiry option for charge related details HCHGIR: Information related to the charges collected and charges computed. HCCI: Customer Charges Inquiry : This menu can be used to view the charges inquiry for a customer/account based on selection criteria. IRPC: This menu is to list charge transactions for which default charge is collected/adjusted. BH Rama Murty , Chief Manager IT , Bank of India Classification: Internal Internal
REPORTS Other than Core reports , each bank will have its own customized report menu with different name. Example : MISRPT ( Miscellaneous report), which consists of various reports for all modules. Report is as below: Classification: Internal Internal
REPORTS Classification: Internal Internal
