Finacle Friendly a Handbook on Cbs

ZONAL TRAINING CENTRE 36 – TEG BAHADUE ROAD DEHRADUN TEL % 0135&2670946] FAX% 0135&2678007

CCORE BANKING SOLUTION

Lead to inspire

Lead to serve

Lead to resolve

Lead to influence

Lead to facilitate sales.

(Updated 31.01.2015) Zonal Training Centre Dehradun

[1]

TABLE OF CONTENTS S.No.

PARTICULARS

1. 2.

Nevigation key – an introduction Customer ID Creation – Step by Step process (i) Number of customer ID required for a customer (ii) Risk Classification of the customer Flow chart for opening of SF/CA accounts (i) Small account product – SBSML (ii) Seeding of Aadhar number in accounts Transfer of accounts across SOLs Transfer of accounts between Schemes List of accounts attached with Mobile / Pan Number Handling KYC NON compliant accounts Transfer of accounts to inoperative category Depositor education and awareness fund scheme – 2014 (DEAF) Transfer of accounts from inoperative to operative category Standing Instructions maintenance Cheque Book Maintenance Security forms inventory management in CBS system Clearing Operations Transaction maintenance Cash payment – Use of menu option ‘TOKEN’ Facilities available in intersol / base branch Proxy Posting (i) Reversal of proxy posted transactioin Quoting of permanent account number (PAN) Pay order – Issue and Payment Inland Bills Term deposit account – Flow chart to open (i) Handling preferential interest on term deposit (ii) Correction of preferential interest in term deposit (iii) Auto generation of form 15G/15H (iv) Print TDS Certificates Locker module in CBS (i) Partial Recovery of Locker Rent (iii) Capturing signature of locker holder / authorised signatory (ii) Reports in locker module Loans and Advances (i) Cash Credit / Overdraft accounts (a) Attaching security with Loan accounts (b) Help window for interest table code (c) Handling subsidy linked through running account (ii) Term Loan / Demand Loan accounts (a) Opening loan a/c in transfer in mode (b) Reversal of Transaction in TL/DL account (c) CRMS – Credit rating Management (d) Back ended Principal subsidy loan accounts opening (d) Subsidy related transactions

3.

4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22.

24.

25.

Zonal Training Centre Dehradun

PAGE NO.

4 4 7 11 12 13 16 18 18 19 20 21 21 23 24 28 30 30 36 39 40 40 41 42 42 44 52 55 56 61 61 64 67 68 69 70 71 73 77 80 81 86 89 91 93 95

[2]

(iii)

26. 27. 28. 29. 30. 31. 32. 33. 34. 35.

36. 37. 38. 39. 40. 41. 42.

43. 44. 45. 46. 47.

Maintenance of Term Loan/ Demand Loan accounts (a) Generation of common reminders for all irregular accounts (b) Recalled account maintenance (c) TL where interest parked in office account –handling thereof (d) Correction of wrong interest demand effective date (e) Entering group codes in loan accounts (f) Loan module utilities and Wilful defaulters marking in CBS (g) Recovery of overdue instalment from operative account (h) Limit node maintenance (i) Post Dated cheque Management Guarantee Master Maintenance (i) Use of SFMS in sending and receiving Bank guarantee Inland letter of credit – ILCs through SFMS Non Fund details use of NFDET menu Memopad maintenance and entry in CBS FAMS – Integration with CBS Daily monitoring system Expenditure Monitoring system PAN Card business Indicative List of CBS Menu option NPA Management in CBS (i) Maintenance of restructured accounts use of RSAM Menu (ii) Charges handling in NPA Accounts Important credit related reports Frauds identification and marking in CBS Bio-metric Login in CBS – procedure Direct Benefit Transfer – LPG Indicative List of Scheme codes in CBS Trouble shooting - Day end activites Alternate Delivery Channels (i) ATM Card / Debit Card (ii) Credit Card (iii) Internet Banking - Retail (iv) Internet Banking - Corporate (v) Mobile Banking (vi) SMS Codes for customer facility (vii) Visually impaired customers Cash Deposit Machine – functionality Self Service Passbook printing terminal – functionality MIS codes in Loan accounts – V detail Report Generation in CBS – Indicative list of menu options NEFT and RTGS


102 109 109 109 111 113 121 121 125 130 132 133 134 136 139 142 146 147 150 152 177 192 192 196 197 199 204 205 212 214 214 223 227 233 237 244 246 248 252 253 274 279

[3]

NAVIGATION KEY –AN INTRODUCTION For the purpose of navigation the important function keys are as underPHYSICAL KEY F1 F2 F3 F4 F5 F6 F9

DESCRIPTION

PHYSICAL KEY DOWN UP CTRL+D CTRL+ E CTRL+F CTRL+U

DESCRIPTION

Field Level Help Next Record List Previous Record Quit Page Down on a List Accept Explode Back Ground menu Clear Field Next Block (page) Page up on a List View Signatures (F4 & F3 to Close) F10 Commit SHIFT+F4 Select the current item from the list F11 Next Field/Next Page on same SHIFT+F11 Transmit (Background Menu) Screen F12 Previous Block (previous page) SHIFT+TAB Go to the Previous Field TAB Go to the Next field ENTER Go to the Next Field Most of the function keys are also available on the last line of first page which can be used with mouse . CUSTOMER ID CREATION – STEP BY STEP PROCESS CCCCCCUSTOMER ID OF CUSTOMER ID EP BSTEP GUIE CUSTOMER ID CREATION – STEP BY STEP PROCESS STEP DESCRIPTION 1 Invoke CUMM menu 2

Enter “A” in function block and F4

3

Customer Title – F2 and

4

Name – Enter the Full name of the Customer and

5

Short name – Enter Short Name and . Go to “Gender “ field by

6

Gender – Enter the required value and . Go to “Staff “ field by

7

Staff – Enter “N” and . If staff, enter “Y” then for “Staff No” enter Employee PF

SHIFT + F4

required code and

No. or simply "Staff" and 8

Minor – Enter “N” and

9

Non-Resident – Enter “N” and

10

Trade Finance Customer – Enter “N” and

11

Marital Status – Enter appropriate Value and

12

Introducer Details – Title – F2 and SHIFT +F4 appropriate value and

13

Name – Enter the name of the Introducer and

14

Introducer Status – F2 and SHIFT + F4 appropriate value and

15

Frequency of Statement – (Please skip this) Press F6

16

Address Type – Enter “C” and .

17

Communication Address – Enter the full address of the customer in two fields and City Code – F2 and SHIFT + F4 appropriate city code and State – F2 and SHIFT + F4 appropriate State code and

18 19


[4]

20

Postal Code – Enter the PIN code of the city and

21

Country – F2 and SHIFT + F4 appropriate Country code and For India – IN

22

Phone Number – Enter the telephone number and and go to Next Address

23

Repeat steps 17 to 22 and for Next Address You can also fill up permanent address & Employer address

24

Repeat steps 17 to 22 and and go to field “Combined Statement”

25

If Customer wants Combined Statement – Enter “Y” (This will enable to print a combined statement for all types of accounts for this customer.) press and go to field “Tax Slab”

26

Tax Slab – Enter “TDSGE” and and and go to field “Purge Allowed”

27

Purge Allowed – Enter “N” and and go to field “Allow Sweeps”

28

Allow Sweeps – Enter “N” and and F4 For Sweep type account “Y”

29

The cursor will be at the Option Block. Here at option block enter “E” and F4

30

Enter “INR” and “EXPLODE”

31

Enter 0.00 and F4 and F4 and

32

The cursor will be again at the Option Block. Here at Option block enter “#” and press F4 twice. Fill here, State code, District Code, Sub district/Tehsil code and village code by taking help from F2. Also fill up details of KYC Documents and SBSML code which is shifted from 7th page of CUMM to # details(refer details below) Press now F4 and F10. Note down the customer ID.

34

Capturing of KYC details: To handle the revised KYC guidelines and to facilitate F2 (help) facility, functionality to capture KYC data has been shifted to CUMM (#) sub option. (Branches are already using CUMM ‘#’ sub option to capture village details of the customer). The existing data filled in CUMM (G) details– 7th page earlier has been migrated to respective data fields in CUMM (#) sub option. Process guidelines to capture KYC data is as under: a) Menu option – CUMM b) Option - M- to modify and A- Add c) In sub option check box: branch user has to enter ‘#’ and press F4 twice. d) After entering the mandatory details, branch user has to enter ‘Y’ in Cont.(Y/N) field to save the details or vice versa and complete the existing process of CUMM menu option. Important Note: i) ii) iii) iv)

F2 (Help) functionality has been provided. Now branch user can use F2 button to select appropriate value related to KYC details. Either of the Husband/father name can be captured as per customer request. SBSML code is to be filled in case of Small accounts deposit product only In case Identity Proof is PAN card (PANCD), system will not populate the same at CUMM – ‘G’ 4th page in PAN/GIR field but system will validate the entered PAN no. at Identification no. field in


[5]

‘#’ option with the PAN no. entered in PAN/GIR field at CUMM – ‘G’ 4th page. Hence, user has to enter the same PAN no. in both the fields. The detailed list of document codes and related document type are mentioned in Annexure A.

v)

Handling of KYC in Small Accounts: Continuation to the ITD/CBS/Circular No. 23/2013 dated 15-04-2013, the validations on KYC compliant documents with respect to SBSML codes have also been accordingly customized in CUMM (#) sub option. The details of the same are mentioned are as under: a. b.

c.

Small accounts can only be opened under scheme code SBSML if valid values are entered in SBSML code in CUMM (#). Valid SBSML Codes are: i) 000 - customer opens account by giving self-attested photograph and complete account opening form along with self-declaration. ii) 001 - Applied for ID Proof iii) 002 - Applied for Address proof iv) 888 - Applied for both Identity & address proof v) 003 - Submits Identity proof vi) 004 - Submits address proof vii) 999 - Submits both & address proof Applicable documents for above mentioned SBSML codes are mentioned in Annexure- B. Branches are advised to enter valid codes in KYC fields along with Small a/c codes.

ALLOTMENT OF UNIQUE CUSTOMER IDENTIFICATION CODE [UCIC] FOR BANK’S CUSTOMERS 1) Existing Cust ID of a customer for opening his / her account is to be used and not to create a fresh Cust ID for an exisisting customer. 2) Menu options CRV / MOPACINQ may be used, as a tool, to ascertain the existing Cust-ID of the customer and menu option CCA may be used for clubbing multiple Cust-IDs of an existing customer. 3) In order to check multiple Cust-IDs of a customer, necessary changes is made in CBS system that as and when branch user enters Aadhaar Number / PAN Number / Mobile Number / Passport Number of the proposed customer for creating a new Cust- ID at the time of opening an account , system will display a list of existing Cust-IDs on the screen of the computer, if Cust-ID is already been created with the same Aadhaar Number / PAN Number / Mobile Number / Passport Number and branches were advised to use the existing Cust-ID only. Ensure: To use the Cust ID of an existing customer for opening his / her new account . i) CRV / MOPACINQ menu options may be used as a tool to ascertain the existing Cust ID of a customer. ii) Wherever fresh cust ID is required to be created, it must be created in a prescribed manner. iii) To generate report on ‘Multiple Cust IDs of a customer based on PAN No’ and take corrective action. iv) To ensure that correct PAN No is fed in the system at appropriate place and take corrective steps, wherever required. CREATION OF CUST ID FOR OPENING OF ACCOUNT Applicable for all type of customers: i. All other details/relevant fields in CBS system to be filled in ii. PAN number be recorded in the field ‘PAN/GIR No.’ under Customer Tax Details in ‘CUMM iii. Selection of proper customer wise code for TDS


[6]

iv. The branches will not suspend valid customer IDs (belongs to trustee authorized/ partners authorized/joint account holder customer ID/ Proprietor) belongs to S. No. 2,5,6,7,8 till accounts are in open state. CREATION OF CUSTOMER ID – NUMBER OF CUSTOMER ID FOR SINGLE ACCOUNT: S.No. 1 2

Type of customer Individual Joint a/c of individuals

Guidelines for maintaining CUST ID One Cust ID for each individual i) Cust. ID to be created separately for each individual if not an existing customer ii) At the time of a/c opening CUST IDs are to be entered in related party details to open joint account (A-details) 3 Minor Create cust ID for minor only 4 HUF Create Cust ID for Karta only 5 Sole-Proprietor i) Create Cust ID for sole-prop. Firm ii) Create Cust ID for proprietor and entered in A-detail. iii) The details of proprietor is to be entered in related party details i.e. A-Detail. Details of authorized person/POA (If any) to be entered in A-detail only and need not to create a separate Cust ID. 6 Partnership firm i) Create Cust ID of Partnership Firm ii) Create Cust ID of all the partners authorized to operate the account and entered all the information in A-details iii) The details of authorized person/POA (If any) to be entered in A-detail only and need not to create a separate Cust ID. 7 Trust i) Create Cust ID of Trust ii) Create Cust ID of trustee authorized to operate the account and entered all the information in A-details iii) If any person other than trustee is authorized to operate the account, the details of authorized person/POA (If any) to be entered in A-detail only and need not to create a separate Cust ID. 8 Company i) Create Cust ID of the Company ii) Create Cust ID of authorized persons to operate the account and entered all the information in A-details iii) The details of POA (If any) to be entered in A-detail only and need not to create a separate Cust ID. VALIDATIONS/CHECKS CUSTOMIZED: Apart from above modifications, few logical checks & validations have been put in place in CUMM to ease operations in CUMM and capturing of qualitative data. The details of the same as under: S. No. Data Field Validations 1. Customer Name/ System will not accept any special character in Customer name/ short name Short Name field. 2. Minor Cust. Details: Check incorporated to accept only 6 digit postal numeric code incase Postal Code country code is 'IN' 3. Postal Code in Check incorporated to accept only 6 digit postal numeric code incase Communication/ country code is 'IN' Permanent Address In case country code other than ‘IN’ – INDIA and customer NRE flag as ‘Y’, system will allow to enter ‘ALPHA’ / ‘ALPHA NUMERIC’ PIN CODE. Help for entering valid PIN CODE After entry of city code and state code, press ‘F2’ button and then system displays list of valid PIN codes available in CBS for the combination of entered city & state code. In case non availability user should enter pin code as provided by customer.


[7]

ENTRY OF BENEFICIAL OWNER DETAILS – “P” DETAILS As per HO KYC cell capturing of Beneficial Owners details are required, hence necessary check has been put in place in CUMM to enter said details using sub-option ‘P’ in CUMM menu option. Following two codes are created in CBS: a. 026 – in case of Beneficial Owner b. 027- in case there is no Beneficial Owner Note: At least one record with 026 or 027 code should be entered otherwise system will not allow new account opening using the customer ID. Capturing of details of Beneficial Owners is mandatory for following constitution codes: Code Description Code Description 003 Co-op society 018 Micro finance institutions 004 Association 019 NBFC 005 Recreational club 020 NBFC-IFC 006 Trusts 021 NBFC-NDSI 007 Pvt. LTd. Company 022 PSU 008 Public Ltd. Company 024 Foreign Sovereign 012 Registered Society 025 Foreign PSE 013 Banking Company 026 AFC – Asset Finance Company 016 Self help group 028 CCP- Corporate 017 Joint Liability Group 029 LLP-Limited Liability Partnership Ensure that Beneficial Owner(s) is identified invariably in all above category of accounts (ie. Pvt. Ltd. Co. / Partnership firm / Unincorporated association or body of individuals / Clubs / Societies / Trust) and Cust ID of the Beneficial Owner(s) is entered in menu option CUMM ( P ) details of the above said accounts with relation code as 026. ANNEXURE-A List of Valid KYC Documents for accounts of Individuals (Except SBSML accounts): Valid Identity proof documents: Codes CRCRD

Document Description PHOTO CREDIT CARD WITH STATEMENT

DRVG

DRIVING LICENSE

ESIC

EMPLOYEE STATE INSURANCE CARD WITH PHOTOGRAPH

FFPAS IDCRD

FREEDOM FIGHTER PASS ISSUED BY MINISTRY OF HOME AFFAIRS, GOVT. OF INDIA WITH PHOTOGRAPH IDENTITY CARD ISSUED BY RECOGNISED AUTHORITIES

LOCAL

LOCAL GOVT. AUTHORITY

MRDWM

MARRIED WOMEN IDENTITY PROOF (SUPPORTED BY MARRIAGE CERTIFICATE)

NREGA

NREGA JOB CARD

PAIDT PANCD

LETTER FROM A RECOGNIZED PUBLIC AUTHORITY OR PUBLIC SERVANT VERIFYING THE IDENTITY AND RESIDENCE OF THE CUSTOMER TO THE SATISFACTION OF BANK PAN CARD

PROPD

REGISTERED PROPERTY DOCUMENTS WITH PHOTO

PSPRT

PASSPORT

UIDAI

AADHAR CARD


[8]

VOTER

VOTER ID CARD

Valid address proof documents: Codes

Document Description

BNKST

BANK ACCOUNT STATEMENT

CRCRD

CREDIT CARD WITH STATEMENT

DEED

COPIES OF REGISTERED LEASE AND LICENSE AGREEMENT/SALE DEED/LEASE AGREEMENT

DOMCL

DOMICILE CERTIFICATE WITH COMMUNICATION ADDRESS AND PHOTOGRAPH

DVORC

COURT DIVORCE ORDER. MARRIAGE ANNULMENT ORDER ISSUED BY COURT

ELBIL

ELECTRICITY BILL

EMPLT

LETTER FROM EMPLOYER

GASCD GZPSU

CONSUMER GAS CONNECTION CARD/BOOK/PIPE GAS BILL OFFICIALS OF CENTRAL/STATE GOVERNMENTS AND PUBLIC SECTOR UNDERTAKINGS, WHO ARE LOW RISK CUSTOMERS FOR BANK

HOSTL

CERTIFICATE ISSUED BY HOSTEL WARDEN/PRINCIPAL/DEAN OF STUDENT COLLEGE

ITWAO

INCOME/ WEALTH TAX ASSESMENT ORDER

POPBP

POST OFFICE SAVINGS PASS BOOK

PPO

PENSION PAYMENT ORDER

PSLTT PSOTH

LETTER FROM PUBLIC AUTHORITY LETTER FROM ANY RECOGNISED PUBLIC AUTHORITY HAVING PROPER AND VERIFIABLE RECORD OF ISSUANCE OF SUCH CERTIFICATE

PSUEM

LETTER FROM PUBLIC SECTOR EMPLOYER

RCARD

RNTAG

RATION CARD STUDENTs RESIDING WITH RELATIVES, ADDRESS PROOF OF RELATIVES, ALONG WITH THEIR IDENTITY PROOF A RENT AGREEMENT INDICATING THE ADDRESS OF THE CUSTOMER DULY REGISTERED WITH STATE GOVERNMENT OR SIMILAR REGISTRATION AUTHORITY

TLBIL

TELEPHONE BILL

TLMBL

TELEPHONE BILLS FROM ANY TSPs AND MSP NOT MORE THAN 2 MONTHS OLD, POSTPAID. THE LETTER ISSUED BY UIDAI CONTAINING DETAILS OF NAME, ADDRESS AND AADHAAR NUMBER. IN CASE THE ADDRESS PROVIDED BY THE ACCOUNT IS THE SAME AS THAT OF AADHAAR LETTER CERTIFICATE BY VILLAGE EXTENSION OFFICER (VEO) / VILLAGE HEAD OR EQUAL OR HIGHER RANK OFFICER

RLTVE

UIDAI VLGHD VOTER WRDCR

VOTER ID CARD CERTIFICATE FROM WARD/EQUIVALENT RANK OFFICER, MAINTAINING ELECTION ROLL CERTIFYING ADDRESS OF THE APPLICANT ANNEXURE B

Valid documents for applicable SBSML codes are as under: SBSML Code 000

ID proof Documents/ID proof Field

001

AARMLC

Blank (Not to be filled) APPL. FOR ARMED LICENSE ISSUED BY GOVT.


Address Proof Documents/ Address Proof Field Blank (Not to be filled) Blank (Not to be filled)

[9]

ADRVG AMRDWM

ANREGA APANCD APSPRT ARMLC AUIDAI AVOTER 002

APPL. FOR DRIVING LICENSE APPL. FOR MARRIED WOMEN IDENTITY PROOF APPL. FOR NREGA JOB CARD APPL. FOR PAN CARD APPL. FOR PASSPORT ARMED LICENSE ISSUED BY GOVT. APPL. FOR AADHAR CARD APPL. FOR VOTER ID CARD

Blank (Not to be filled)

ADOMCL

AELBIL AGASCD

ARCARD ATLBIL AVOTER 003 004

Any of the valid ID proof code mentioned in Annexure A Blank (Not to be filled)

APPL. FOR DOMICILE CERTIFICATE WITH ADDRESS AND PHOTOGRAPH APPL. FOR ELECTRICITY BILL APPL. FOR CONSUMER GAS CONNECTION CARD/BOOK/PIPE GAS BILL APPL. FOR RATION CARD APPL. FOR TELEPHONE BILL APPL. FOR VOTER ID CARD

Blank (Not to be filled)

888

Any of the valid ID proof code mentioned for SBSML code 001 above.

Any of the valid address proof code mentioned in Annexure A Any of the valid ID proof code mentioned for SBSML code 002 above.

999

Any of the valid ID proof code mentioned in Annexure A

Any of the valid address proof code mentioned in Annexure A

CAPTURE AREA CODE DETAILS OF THE CUSTOMERS Ministry Of Finance (MoF), India has mandated the Bank’s to provide functionality in CBS to capture the village/ town code (as per Census Code) details as part of capturing the customer details. The village/town code details which need to be incorporated consists of a combination of State Code, District Code, Taluk/Sub-district code and Town/Village code codes provided by RBI/Census data are incorporated in CBS to comply with this directive. This code will be a 16 character/digit format comprising of State Code(2) + District Code(3) + Sub District Code(5) + Town/Village Code (6) USER GUIDE 1. Branch user has to invoke menu option ‘CUMM’. 2. In CUMM, Branch user has to enter the function code as per requirement and then press F4.


[10]

3. 4.

5. 6. 7. 8.

A- To Add M- To modify To capture village/town code details, an additional custom tab is proposed (# - details). Branch user has to enter ‘#’ in ‘Enter option’ Field. Screenshot for reference is attached. Branch user has to select following codes, by pressing F2 button - State - District - Sub District - Town/village After entering the same, branch user has to press ‘F4’ mandatory to exit from this additional details form. Then continue with the normal process of CUMM menu option. As per maker checker concept, another branch user has to verify the same. The state code and other codes in this form will be given as per details captured in the address field which is meant for communication purpose. While entering the address if the use has chosen ‘P’ or ‘E’ i.e. permanent address or employer address as mandatory which will be printed in the passbook, the village/town code should be selected according to this mandatory address.

VERIFICATION OF CUSTOMER MASTER CREATION MENU OPTION -- "CUMM - V" Check all the relevant details from AOF and verify it. SUSPENSION OF CUSTOMER WITHOUT ANY ACCOUNT NUMBER Can be handled in two ways : 1) Invoke menu option CUMM use option “D” for suspension of Customer ID and use option “U” to unsuspend the Customer ID. 2) System will not allow suspending the customer ID using CUMM or CUMMSUSP menu option, if there is an active account/locker existing in the system. Further, customer IDs created for opening of Joint Account cannot be suspended till Joint account exists (Active) in the system. 3) Invoke menu option “CUMMSUSP” There is facility of single customer ID suspension as well as Bulk Customer ID Suspension SINGLE CUSTOMER ID Enter ‘S” in the field then press F4, Give customer ID and continue flag ‘Y’. On pressing F4 system will suspend the customer ID. BULK CUSTOMER ID Branch to prepare a text file with list of Customer IDs which are required to be suspend Enter ‘B’ in the field then press F4 give file name in Capital letters e.g. UPLOAD.TXT Continue ‘Y’. On pressing F4 system will suspend all customer IDs of the text file. CAUTION i) ii) iii) iv)

CUMMSUSP menu to be used only for customer IDs which have no account in system. Customer IDs suspended through this menu cannot be unsuspended even using CUMM. Customer IDs for Locker customer cannot be suspended through this menu. No verification required for this activity and can be used by GU work class of ‘030’.

RISK CLASSIFICATION OF THE CUSTOMER AND UPDATION OF CUSTOMER IDENTIFICATION INFORMATION / DATA : Risk Categorization of Customers in which they have informed that ‘RISK category’ field in CUMM is not required to be filled by the branches at the time of creating fresh/Modification of Cust-ID. It should be automatically populated by the system based on profession / activity codes. Profession / activity codes in the field “profession / activity” in # detail of customer master (CUMM) has been created by Data centre .


[11]

User has to select appropriate activity code from help key (F2) and system will automatically populate the risk category based upon the selection of Profession /Activity codes. With regard to updation of Customer Identification Information/Data and review of Risk Categorization necessary customization has been done in the system. The detail procedure to be followed by branches is given below: a) b) c) d)

Reports for generating pending records needs to be updated: The following two reports has been customized in the system to know the pending records due for necessary updation which can be available through menu option: PNBRPT- 9/143a & b 9/143a: Report for Cust Id due for Updation for Low Risk Category Customers. 9/143b. Report for Cust Id due for Updation for Medium and High Risk category Customers.

Branches may generate the above two reports and follow-up with customers for obtaining fresh documents and enter the date of updation of KYC data submitted by customer in # details of CUMM. RISK CATEGORY CHANGE – UPLOADING Bulk option to enter or modify the risk category of customers based on his/her profession without using CUMM menu option, a new menu option ‘RISKUPL’ has been customized in CBS. Process to use the said customized menu option is as under: Menu option: RISKUPL Said menu option will change the risk category of the customer IDs based on the entered business nature code and same can be checked using CUMI/CUMM menu option ‘#’ Details. Steps to use the same are as under: a. A text file to be created with following data: - Customer ID - Business Nature Codes (Data should be ‘|’ separated i.e AXF003310| UNUSL b. File name should in capital letter including file extension like RISK.TXT c. File should be saved in C:\upload directory d. Execute menu option ‘RISKUPL’. Enter File name and press ‘F4’. e. Use ‘PR’ menu option for success/failure reports. (Verification process is inbuilt) FLOW CHART FOR OPENING OF SF/CA ACCOUNT STEP 1 2 3 4 5 6 7

8 9 10 11

OPENING OF SF/CA - STEP BY STEP PROCESS Write OAAC at menu option and press enter At Customer ID field type Customer ID for which a/c will be opened, press TAB At Scheme Code type "SBGEN" or "CAGEN" or "SBSAL" and Press F4 Mode of Operation : Press F2 and select appropriate one by Shift+F4, press TAB Location Code : Press F2 and select appropriate one by Shift+F4, then press F6 Pass Book/ Statement : Enter "P" for pass book or "S" for stt. of a/c and press TAB If statement of a/c is chosen, enter frequency of statement as : M in first field and in 4th Filed any number between 1 to 31 and in the 5th field "N" and then press , at Despatch Mode : enter "C" (You may select appropriate despatch mode by pressing F1) Interest Cr A/c : Enter "S" and Interest Dr A/c Flag : Enter "S", press F6 for next page At this page enter contact phone no. if any, then press F4 The cursor will be at option : Change G to "S" for scheme details and press F4 If nomination is to be regd. go to "Availing Nomination Facility?" and change it to "Y" and


[12]

12 13 14

15 16

then press F4. If no cheque book is to be allowed for some reason, at the field "cheque book allowed?" change Y to N. Change the Option "S" to "N" and press F4 Nominee Name : Type Name of the Nominee, then address etc. and then press F4 If it is a joint a/c or an a/c of a firm/society/club then change the option to "A" and press F4 to allow you to enter the joint a/c holder's name or authorised signatory's name etc. If the joint holder or authorised signatory has some customer id, mention the same and press transmit key the name and address will automatically appear. In the absence of customer id you have to skip customer id field and enter name and address. Press down arrow key to enter the 2nd and subsequent names, then press F4 finally. Now at the option block press F10, the account number will be displayed.

FOR--Passbook/Statement – Valid values are P-Passbook, S-Statement, R-Deposit Receipt, BBoth P & S, N-None. Statement – If previous field is set to S (Statement), frequency for statement must be entered. There are five fields in statement. Field 1: D–Daily, W–Weekly, M–Monthly, F–Fortnightly, Q–Quarterly, H–Half yearly, Y – Yearly Field 2: 1-First, 2-Second, 3-Third, 4-Fourth week, M-Mid week, L–Last Week Field 3: 1-Sunday, 2- Monday………… 7- Saturday & 8 - No weekly off Field 4: Date of issue - 1 to 31 Field 5: For Holiday N – Next, P – Previous, S – Skip

Fields 2 & 3 are not required if frequency (field 1) is monthly, quarterly, half yearly and yearly Fields 2 ,3 & 4 are not required if frequency (field 1) is daily and fortnightly Fields 2 & 4 are not required if frequency (field 1) is weekly VERIFICATION OF ACCOUNT OPENING MENU OPTION -- "OAACAU" STEP S 1 2 3 4 5 6

PARTICULARS At function Block type "V" and press and enter the A/c No. to be verified, then press F4 Press F11 to visit next pages and at the 3rd page Press F4 Change the option to "S" and Press F4, see the values entered and again press F4 Change the option to "N" and Press F4, see the values entered and again press F4 Change option to "A" (for joint a/c or partnership etc. a/c only) and Press F4, see the values entered and again press F4 Press F10 finally. If the system displays any warning / exception, accept them by pressing F4. The a/c is verified. Press F3 to come back to main menu

The full 16 digits of an a/c number need not be remembered . Whenever this account is to be accessed, simply enter the scheme code and last 4/5 digits , system will automatically expand it to 16 digits. This facility is provided only when the customer’s accounts of same own branch are accessed. All 16 digits in account no must entered while accessing customer’s of other branches. SMALL ACCOUNT PRODUCT – OPENING OF ACCOUNT – SCHEME – SBSML Find below the details of the functionalities introduced in CBS 1. In CUMM: ‘#’ Details Case SBSML CODE Remarks If customer opens account by 000 Branch user has to capture the said giving self attested photograph code in Free text field 10. and complete account opening Account will remain active for 12 form in the branch. months only.


[13]

If customer opens account under small account scheme and also submits documentary proof that he/she applied for valid KYC document.

If customer applied for ID proof: 001

Account will remain active for 24 months only.

If customer applied Address Proof:

Also, branch user has to enter: 1. Valid value in ID proof field for code 001. 2. Valid value in Add. Proof field for code 002. 3. Valid values in both fields ID proof and address proof for code 888. 4. Identification details field is also be filled. e.g. Applied voter card Branch user has to enter: 1. Valid value in ID proof field for code 003. 2. Valid value in Add. Proof field for code 004. 3. Valid values in both fields ID proof and address proof for code 999. 4. Identification details field is also be filled as per extant guidelines. Note: If customer full fills KYC requirements, branch is advised to open account in normal saving scheme.

for 002

If customer applied for both ID proof and Address Proof : 888

If customer opens account under small account scheme and also submits valid KYC document.

If customer submits ID proof: 003 If customer submits Address Proof: 004

If customer submits both ID proof and Address Proof : 999

If existing small account holder full fills KYC norms, account should be transferred to normal saving product using ACXFRSC menu option. System will not allow to complete the ABH without transferring such accounts. 2. ACCOUNT OPENING: A new scheme code ‘SBSML’ has been introduced for opening of customer account under Small Account Deposit Product. Branches are advised to use menu option ‘OOAC’ and ‘OAACAU’ for the account opening. 3. Transaction Maintenance TM: As per product features, following checks has been implemented in ‘TM’ menu option in the system: 1. The aggregate of all credits in a Financial Year does not exceed rupees one lakh 2. The aggregate of all withdrawals and transfers in a month does not exceed rupees ten thousand; and 3. The balance at any point of time does not exceed rupees fifty thousand.


System will not allow to credit the customer account under ‘SBSML’, if aggregate of all credits reaches value of Rs. 1, 00,000/- within the financial year. System will not allow to debit the customer account under ‘SBSML’, if aggregate of all withdrawals and transfers in a month reaches value of Rs. 10,000 in a month. System will not allow to credit the customer account under ‘SBSML’, if aggregate of all credits reaches value of

[14]

Rs. 50,000/- at any point of time. System will allow to credit only if account balance in the account is less than Rs. 50,000/. 4. Issuance of ATM cards and Cheque book: As per FI Division circular, no cheque book and ATM card should be provided till the account becomes full KYC compliant. Necessary check has been put in the system to restrict issuance of cheque book and ATM card in ‘SBSML’ scheme. As already mentioned that if customer account under SBSML scheme becomes FULL KYC, said account is to be transferred to normal saving product scheme, then branch user can issue cheque book and ATM cards as per extant banking guidelines related to that saving product. WORK FLOW FOR ACCOUNT OPENING (ACOPN) Account opening process as mentioned above involves creation of customer master (for new customers using the option CUMM) followed by account opening (using OAAC menu option). Instead of using CUMM and OAAC separately, a workflow ‘ACOPN’ can be invoked. ACOPN is a combination of the two menus. The workflow involves the following steps:On invoking the menu ‘ACOPN’, the user(CTO) shall enter the cust-id (for existing customers) or type ‘New’ (for new customers) in the customer id field. Enter the authorised official's User-Id in the authorizer id field and F4 If the customer is new, the system brings up a parameter acceptance screen for capturing the mandatory fields of customer master like customer details, introducer details, communication address, minor details, NRI details, staff details, TDS table etc. Fill the relevant details and press F4. After all mandatory fields are entered, the system takes to another parameter acceptance screen for capturing account-opening details. On the other hand if the customer is an existing customer (i.e Cust Id available) system directly takes to account opening screen. In account opening screen, enter the scheme code in which a/c is to be opened and then press F4. Enter the transaction amount, mode of payment, debit a/c number (in case the a/c is opened by transfer of funds from some other a/c of the customer) and press F4. In this screen, specify the mode of operation, Cheque allowed (by default ‘Y’) and account preferential (Cr/Dr) and press F4. The system creates customer master, opens account, puts transaction to the account and displays the Cust-Id, account number, Tran-Id and Work Flow Id and queues the workflow for the authorised official (authorizer id) for verification. Note the Cust-Id, a/c number, Tran-Id and the workflow id on the AOF and pass on the AOF to the authorised official for verification. The authorised official for whom the workflow has been queued shall invoke menu option ‘DSPWFQ’ to display the pending workflows. The menu will display the list of workflows in queue. The authorised official shall explode (Ctrl+E) on the Workflow Id. If the customer is new, the system will display the customer master screen. The authorised official shall then visit each page of the screen (including ‘E’ details) like normal customer master verification. At the option block, commit. On committing the system displays the account verification screen. The authorised official shall verify account opening like normal account verification.

Alternatively, the official can verify customer master creation through CUMM option and account opening through OAACAU option. The authorised official shall then verify the transaction through ‘TM’ option. IMPORTANT

IT IS NOT POSSIBLE TO CAPTURE NOMINATION DETAILS, JOINT HOLDER, AUTHORIZED PERSON, POWER OF ATTORNEY ETC THROUGH ‘ACOPN’. THE USER SHALL CAPTURE THESE DETAILS BY MODIFYING CUSTOMER A/C THROUGH ‘ACM’ OPTION AND THEN GET IT VERIFIED FROM THE AUTHORISED OFFICIAL.


[15]

SEEDING AADHAR NUMBER - NEW FUNCTIONALITIES IN UIDNUM MENU OPTION Keeping in view the recent guidelines related to Aadhaar payment bridge system (APBS), DBT and to streamline the process of linking of Aadhaar number with primary account number, following new functionalities has been added in the menu option UIDNUM: Now, branch user can capture details of the Aadhaar based as well as non Aadhaar base beneficiaries along with scheme code. Branch user to use following options A : Add D : Delete M : Modify V : Verify I : Inquiry 1. A: Add functionality is to add new mapping in the CBS. Branch user has to enter all the mandatory details and same is to be verified by another branch user. User has to enter/ capture following information: - Aadhaar/Non Aadhaar ( If ‘A’ put Aadhar No., If “N” Fill other details) - Customer ID - Aadhaar Number - Primary Account number (user can only add the account number linked to the entered customer ID only) - Scheme code: (Said field is non mandatory): Branch user can select upto 5 different schemes by pressing F2 button for a particular beneficiary. (List of scheme codes is given below) - Add (Y/N)- Y to continue otherwise N 2. V: Verify: Now, in UIDNUM, maker- checker concept has been introduced. Branches are required to verify using ‘V’ function of the UIDNUM menu option. 3. M: Modify: This function is to be used when customer requests to change his/her account number. For the same branch user has to use ‘M’ function and change the account number (account number should belong to the entered customer ID) and same is to be verified by another branch user. 4. D: Delete: This function can be used for following two cases: - Customer ID changes: If customer request to change the customer ID. Then branch user has to use the said function and delete the existing entry. After deletion, branch user has to use ‘A: Add’ function to add new entry. - Aadhaar number change: If branch observed any mismatch in the Aadhaar number or observed that Aadhaar number entered wrongly. Then Branch user has to use the said function (D: Delete) to delete the existing entry. After deletion, branch user has to use ‘A: Add’ function to add new entry with correct Aadhaar number. - Customer wants to enter Aadhaar number: If customer’s data is already captured as ‘Non Aadhaar based customer’ and now customer requests to enter the Aadhaar number. Then Branch user has to use the said function (D: Delete) to delete the existing entry. After deletion, branch user has to use ‘A: Add’ function to add new entry with Aadhaar number. Branches are advised to use ‘D’ option judiciously. I- Inquiry function can be used by the user to inquire the entered Aadhaar number, customer ID and linked account number. Note: Inquiry can be done by entering customer ID or Aadhaar number. ‘C’ – for customer ID based inquiry ‘A’ – for Aadhaar number based inquiry Following type of accounts cannot be linked using UIDNUM as well as UIDUPL menu options: 1. Closed accounts 2. Inoperative accounts 3. Accounts of scheme other than saving and Current account. 4. Account with Credit or Total freeze


[16]

5. LIST OF SCHEME CODES TO BE ENTERED IN UIDNUM –AADHAR ENABLED A/C

Sr. No 1

2

3

4

5

6

7 8

Ministry/Department

Name of the Scheme

Code

M/o Social Justice & Empowerment

Post Matric Scholarship for SC Students.

C00001

Pre-Matric Scholarship for SC Students.

C00002

Pre-Matric Scholarship for Children of those engaged in unclean occupations. Up gradation of merit of SC Students.

C00004

Post Matric Scholarship for OBCs.

C00005

Top Class Education Scheme.

C00006

Rajiv Gandhi National Fellowship

C00007

M/o Human Resources Development, D/o Higher Education

Scholarship to Universities/College Students.

C00008

Fellowship Schemes of UGC.

C00009

Fellowship Schemes of AICTE.

C00010

M/o Human Resources Development, D/o School Education & Literacy M/o Tribal Affairs

National Means cum Merit Scholarship.

C00011

National Scheme for Incentive for the girl child for secondary education.

C00012

Post Matric Scholarship Scheme.

C00013

Top Class Education System.

C00014

Rajiv Gandhi National Fellowship.

C00015

Matric Scholarship Scheme.

C00016

Maulana Azad National Fellowship.

C00017

Merit cum Means Scholarship Scheme.

C00018

Indira Gandhi Matritva Sahyog Yojana (IGMSY).

C00019

Dhanalakshmi Scheme.

C00020

M/o Minority Affairs

M/o Women and Child Development M/o Health & Family Welfare M/o Labour and Employment

Janani Suraksha Yojana.

C00003

C00021

Scholarship to the Children of beedi workers.

C00022

Housing subsidy to beedi workers.

C00023

Stipend to children in the special schools under the Child Labour Project.

C00024

Stipend to trainees- Welfare of SC/ST through Coaching cum Guidance & Vocational Training

C00025

Stipend to trainees in LWE districts MGNREGS Scheme Subsidy of LPG

C00026 C00028 9 M/o Petroleum C00027 Linking of Aadhaar number with primary account number should be done using menu options ‘UIDNUM’ or ‘UIDUPL- for bulk upload’ only.


[17]

TRANSFER OF ACCOUNTS ACROSS SOLS - MENU OPTION -- ACXFRSOL • • • • • •

A customer’s account, belonging to SB/CA/CC and OD scheme types, is allowed for transfer across Sol. The account number will remain unchanged for the transferred account. Customers will be able to use the same account for their ECS (electronic clearing services), standing instructions and chequebook purposes. While entering the account number in any of the menu option full 16 digit account number is required to be entered. As part of the transfer, all the account related standing instructions, FFDs, linked sweeps/Liens will get carried over. If the subject account is referred to as the operative account/applicant account/party account in Bills module, documentary credits, forward contracts, and the same relationship will also be carried over.

- THE PROCESS… • • • • • • • • • • •

Function code values ‘T’ – Transfer, ‘V’ - Verify, ‘X’ – Cancel. When Function code ‘T’ is selected the source SOL ID and destination sol id is mandatory. Help Message is available for the same. The account ID is mandatory. During verification of request, the system will carry out the validations such as same person verification, work class check. The effects of transfer and the report of transfer will take place only after the transfer request has been verified. The system will generate a report of all such accounts, which have been transferred as part of this process along with any errors or exceptions due to which the transfer could not take place. The menu option will check/validate for the following conditions before the actual transfer of account takes effect:-Check for any transaction that may have happened on the account on the day of transfer. Check for any transactions that may be in entered status. Check for any cheque that may be logged in Inward Clearing. Validate for Unauthorized records for the account

There won’t be any history available prior to the transfer date in the new SOL. Audit trial will be available for the account and the menu option activities. This includes the transfer enterer id, verified person id, the old record, the new record, time stamp of such change. And when inquired on the transferred customer account itself, the audit trail will contain the information of old record, new record, who entered, who verified with time stamp will be available. Remarks for the audit written will be “SOL ID TRANSFER”. ACCOUNT TRANSFER ACROSS SCHEME CODE MENU OPTION- ACXFRSC A customer account is allowed for transfer across Scheme for the accounts belonging to SB/CA/CC and OD. This is done through a new menu option “ACXFRSC”, which will accept the values ‘T’ransfer, ‘X’-cancel, ‘V’erify (verification of the request of transfer). The effects of transfer and the report of transfer will take place only after the request of transfer has been verified. The execution may be in actual mode or in trial mode. Either one account or all accounts belonging to one scheme to another scheme can be transferred. In this case, GL sub-head is a mandatory criteria. System will generate Success and Failure reports. The transfer will not result in change in the account number to include the new scheme code and the GL subhead. System will not keep history for Charges/interest under old scheme and new scheme separately after such account transfer. Transfer of accounts between scheme are restricted for the same currency schemes


[18]

Irrespective of the scheme change the account status will continue. (Dormant, inactive, frozen). The account status will be printed in the ‘Success/Failure Report’ if the account is not active/dormant or frozen. The menu option will check/validate for the following conditions before the actual transfer of account to new scheme takes effect:-Check if Account is valid. Check if account is closed. Check if any non authorized audit records are pending for the account. Check if the account falls under the schemes SB/CA/CC/OD/TD. No transaction should exist in entered status. Check if the staff flag is modified in CUMM when the account is moving from Non Staff scheme to Staff scheme. Check for future dated transactions Check if TDS calc is up-to-date. Check if the target scheme belongs to the same scheme type as the source scheme. Check if the target scheme code currency is the same as source scheme code. Check for future dated account open effective date. Check for any cheque that may be logged in Inward/ Outward Clearing. Check for Income /Expense account in Home Currency. Check if the NRE flag is modified in CUMM menu option when the transfer is from NRE to Non NRE Scheme and Vice Versa. The Account will be locked once the transfer is initiated through ACXFRSC menu option. During this period no transactions will be allowed on the Account/Accounts. Limitations The account number will remain same, and will not include the product code of the transferee scheme. Charges (Batch charges): When the Account is moving from a scheme where charges are defined to a scheme where charges are not defined then the user has to ensure that the charges are collected before transfer. Interest treatment: If the Account is moving from a Scheme where Interest method is different then the Interest calculation will differ. ACCOUNT ATTACHED WITH MOBILE/PAN NUMBER A new menu option MOPACINQ has been provided. The menu will list a maximum of 10 account numbers maintained by the customer which is either attached with a Mobile number or PAN Card Number. Menu option: MOPACINQ Function : 1. M – Mobile number based search for accounts 2. P - PAN CARD based search for accounts 1)

MOBILE NUMBER BASED SEARCH a. Enter M in function and press F4 b. Enter valid mobile no of 10 digit in next screen and Press F4

The system will then display all Account Numbers with Account Name attached with the Mobile Number entered by the user. Enter ‘Y’ in ‘Inquire Other(Y/N)’ option to continue inquiring list of accounts for another mobile number. Note- Only 10 accounts can be viewed in the menu. If Number of accounts attached with mobile no is more than 10 then it will prompt for a message only. 2)

PAN NUMBER BASED SEARCH a) Enter P and Press F4 Enter valid PAN no and Press F4 Same procedure here also to inquire for other PAN numbers. Input option Y and press F4


[19]

HANDLING KYC NON COMPLIANT ACCOUNTS ‘RINGFENC’ in CBS for Ring Fencing the KYC non-compliant accounts. Problems are being faced that while Ring Fencing KYC non compliant accounts in CUMM (# details) menu in the CBS system, since different information(s) relating to customer is required to be uploaded at the time of Ring Fencing, which at times is not available with the branches. As a result, branches are also freezing KYC non-compliant accounts . 2.

In view of the above, a new menu option ‘RINGFENC’ has been customized in CBS. Therefore, branches are advised that all the KYC non-compliant accounts should be ‘Ring Fenced’ which means that such accounts may be placed under close watch and non-compliant customers may be deprived of certain additional facilities such as issuance of cheque book; issuance of ATM/Debit Card; providing Internet banking services; account transfer using ACXFRSOL; scheme transfer using ACXFRSC menu options and no payment through withdrawal slip at the base branch, till the customer complies with such requirements. This exercise, however, should not extend beyond a period of three months. In case the customer d espite such measures, shows unwillingness to comply with KYC/AML/CFT requirements, branches are free to proceed further and close the accounts after giving due notice to him/her. In no case the account should be freezed due to KYC non-compliance.

The procedure for Ring Fencing the account is given hereunder: (a) Use menu option ‘RINGFENC’ (b) Enter ‘S’ in ‘Function code’ field, then press F4. (c )User has to enter customer id and ‘Y’ to confirm. Then press F4 (d) can be used by ‘Manager’ & above having work class 060 or above in CBS (e) Does not require verification. (f) On obtaining ID and address proof document from the customer, user has to enter ID proof and address proof document through CUMM menu, function code ‘M’ , enter cust ID, press F4, ( # ) in enter option , press F4 twice. Also ensure that all the mandatory fields such as ID proof, address proof, total annual income, Profession /Activity and total annual turnover, are entered correctly. Enter ‘N’ in the ‘Ring Fenced (Y)’ field. Then, the account will be treated as KYC compliant. In any case ‘NA’ should not be selected and used in any field of (#) details of CUMM menu, otherwise the system will treat it as KYC non compliant account. On the basis of Profession / Activity system will classify the risk category (High / medium / low) automatically. SOME ISSUES IN SF / CA ACCOUNTS Customer accounts of other SOLs can not be modified. The system prints the name of joint a/c holder only if the name has been added in "A" option by specifying the relation field as "J". Credit Transactions can be done even before verification of the account opening. Debit transactions are not allowed on unverified accounts, Operative account to which interest credit or debit can be done can be specified which can belong to a different Service outlet also. In OAAC, select SBSTF as scheme code for staff SF A/c. The system will pick up interest rate code applicable for staff members. Don’t open the staff SF A/c in SBGEN scheme code and then give


[20]

additional benefit of interest in A/c Preferential Interest (Cr) field (General Details of OAAC) as system may not give other benefits to the staff accounts opened in SBGEN scheme code. Accounts can be opened in backdate TRANSFER OF ACCOUNTS TO INOPERATIVE CATEGORY A Savings Fund as well as a Current Account would be treated as ‘Inoperative Account’ if there is no ‘Customer Induced Transaction’ for a continuous period of 24 months. The process for classification of an account as Inoperative Others and transfer to ‘Inoperative Others’ Head is customized in FINACLE Application. The activity for classification and transfer of accounts as per above would be performed on quarterly basis in the month of January, April, July and October every year. The process of transferring account to ‘Inoperative Category’ is centralized in which status of account, GL Sub-head Code are changed and signatures are transferred from ‘AL’ Category to ‘IN’ Category In-operative heads in many Branches are not tallied. The reason for non-tallying of the in-operative heads in CBS is due to mismatch of account status maintained with that of GL subhead code. Some accounts marked as Inactive have GL Subhead Code of main operative account where as in some ACTIVE accounts, the GL Subhead Code is that of in-operative. In order to identify accounts with a mismatch in account status and GL Subhead code, A report is customized. The report is available in MIS under PNBRPT/ 9. Misc. reports- 107. Report of Active and Inoperative Account shown in wrong GL heads which identifies accounts with the following mismatches a. b.

Dormant (inoperative accounts) with wrong GL subhead Active accounts under inoperative GL Subheads.

Branches are advised to generate the report for their SOL and change the GL subheads of ‘Inoperative accounts with wrong GL subhead’ and ‘Active accounts having inoperative GL subheads’ through menu option TACBSH- (Transfer Accounts between Subheads). Thereafter tally this account wise balance with GL subhead and ensure its correctness DEPOSITOR EDUCATION AND AWARENESS FUND SCHEME, 2014 (DEAF) Balances in all accounts (Inoperative Accounts 10 years & above and amount remained unclaimed for more than 10 years) along with interest accrued should be transferred to the Depositor Education and Awareness Fund. Subsequently, banks shall transfer to the Fund the amounts becoming due in each calendar month (i.e. proceeds of the inoperative accounts and balances remaining unclaimed for ten years or more) as specified in the Scheme and the interest accrued thereon on the last working day of the subsequent month. Amounts to be credited to the Fund shall be the credit balance in any deposit account maintained with bank which have not been operated upon for 10 years or more, or any amount remaining unclaimed for 10 years or more which include: (a) Savings bank deposit accounts; (b) Fixed or term deposit accounts; (c) Cumulative/recurring deposit accounts; (d) Current deposit accounts; (e) other deposit accounts in any form or with any name; (f) cash credit accounts; (g) loan accounts after due appropriation by the banks; (h) marin money against issue of Letter of Credit/Guarantee etc., or any security deposit; (i) outstanding telegraphic transfers, mail transfers, demand drafts, pay orders, bankers cheques, sundry deposit accounts, vostro accounts, inter-bank clearing adjustments, unadjusted National Electronic


[21]

Funds Transfer (NEFT) credit balances and other such transitory accounts, un-reconciled credit balances on account of Automated Teller Machine (ATM) transactions, etc.; (j) undrawn balance amounts remaining in any prepaid card issued by banks but not amounts outstanding against travellers cheques or other similar instruments, which have no maturity period; (k) rupee proceeds of foreign currency deposits held by banks after conversion of foreign currency to rupees in accordance with extant foreign exchange regulations; and (l) such other amounts as may be specified by the Reserve Bank from time to time. Accounts which are frozen by order of Court, Income Tax Deptt. or any other statutory authorities will not be transferred to DEAF fund. The activity for classification and transfer of accounts in Inoperative category (10 years & Above) would henceforth be performed on monthly basis from July, 2014 onwards as against quarterly earlier. A report has been customized in PNBRPT 9/169 in the system which will provide list of Inoperative accounts which are likely to slip into Inoperative Accounts (10 years & above) in next quarter. On the date of transferring the amount to the Fund, the branch will maintain separately customer-wise details verified by the concurrent auditors, including payment of up-to-date interest accrued, that has been credited to the deposit account till the date of transfer to the Fund, with respect to interest bearing deposits, non-interest bearing deposits and other credits transferred to the Fund as detailed in Form-I. A report has been customized PNBRPT 9/171 to generate details of such accounts at branch/circle office level. The branch will preserve the above audited report at their level for the purpose of annual audit. REFUND AND CLAIM If after transfer of funds to DEAF, customer demands, branch should make payment to customer with up to date interest and lodge claim through Circle office to RMD HO. Branch to lodge the claim on monthly basis up to 5th day of the next month to Circle Office and CO by 8th to FGMO and FGMO consolidated claim to RMD HO by 10th day of the next month. PROCEDURE FOR CLAIM OF INOPERATIVE (10 YRS & ABOVE) TRANSFERRED TO DEAF, RBI 1. User has to enter menu option DEAFC. 2. User has to enter the type of account and add the same using option A and press F4 to add the record 3. User will be navigated to separate screens for deposit account or Draft/Cash Order as the case may be. i) For SB/CA/TD accounts, screen shall be displayed. User has to enter the account number and press F4. All other account related details will be displayed by the system and user has to enter Y/N only and press F4. ii) For Draft/ Cash Order screen shall be displayed. User has to enter the DD or CO Number along with the issuing branch ad issue date and press F4. All other DD/CO related details will be displayed by the system and user has to enter Y/N only and press F4. 4. After adding the account, same has to be verified in the same manner by using V option in DEAFC menu option. After verification of the same, in case of SB/CA/TD accounts, system will credit the amount in the customer’s account with current date, by debiting the Suspense DEAF account of the SOL (solid<5711370>).

5.

In case of DD/CO, system will credit the amount in the account number provided by the customer as entered in the “Credit Acc No” field. However, if customer account number is not available; sundry account for sol should be entered in “Credit Acc No” field and the same shall be credited. PNBRPT-9/177 DEAF Form III (Monthly Return Claiming Refund from Deaf) (for refund procedure refer RMD Circular 55/2014)


[22]

TRANSFER OF ACCOUNTS FROM INOPERATIVE TO OPERATIVE CATEGORY The transfer of inoperative accounts to operative accounts is done at branch level based on the request of the customer. Menu option “OPACTF” is available with Incumbent In charge of the base branch and the menu option performs following three activities: 1. Changes the account status from ‘D-DORMANT’ to ‘A-ACTIVE’. 2. Transfers Inoperative (Others & Over 10 years) GL-Sub-head code to operative GL-Sub-Head-code. 3. Changes the image access code from ‘IN-Inoperative’ to ‘AL-ALL’ On entering the account no. and pressing F4, the system will populate the details of the customer for crosschecking with the request given by customer. In case the details match with the request, user will have to enter ‘Y’ in “Continue(Y/N/)” field and press F4 As a policy decision, debit inter sol transactions to inoperative accounts are not allowed. DUPLICATE PB / STATEMENT CHARGES While closing of an account, system is charging duplicate passbook/statement charges. In some cases these charges have been levied 5-6 times. After migration to Finacle since application of these charges, the pass sheet in the a/c might have been printed in ad-hoc mode and the system is keeping trail of all such ad-hoc print outs. When the a/c comes for closure, system is calculating and recovering ad-hoc pass sheet printing charges as deferred charges. The branch can reverse the charges to the customer, if required through TM menu. MENU OPTIONS AT A GLANCE {FOR CUST-ID & A/C OPENING} MENU CUMM OAAC OAACAU

DESCRIPTION Customer Master Maintenance Accounts Opening Accounts Authorization

ACM

Accounts Maintenance

CACC CAAC CAACAU ALM JTHOLDER INTTM PSP PBP HACS

Closure Charges Collection Accounts Closing Accounts Closure auth. Auth A/C Lien Maintenance List Joint Holders Interest Table Maintenance Pass Sheet print Pass Book print A/C Selection

HCUS

Customer Selection

ACCBAL

Components of Account Balance Inquiry A/C Ledger Inquiry A/C Turnover Inquiry Print Dr/Cr. Advice To Customer Print Dr/Cr. Voucher A/Cs Below Minimum Balance-Report Account Freeze Status Maintenance Customer Becoming Major Customer A/C Ledger Print

ACLI ACTI ADVC VCHR ABMR AFSM CBM ACLPCA


PURPOSE To Add a new Customer For opening new accounts For Verification / Modification / Cancellation of Unverified Accounts For Modification of Verified Accounts And Other Inquiries/Maintenance To calculate/apply Account Closure Charges For closing accounts For Verification/Cancellation of Closed A/C To Mark/Release Lien on Accounts To view Joint Holders/ All Related Parties To view/modify Interest Table Code (Rates) To Print Statement Of Accounts To Print Passbooks To make inquiries on criteria-based selected accounts To make inquiries on criteria-based selected customers To view break-up of an account balance To view transactions in Account Ledger To view Turnover in account To Print Advices based on selected criteria To Print Vouchers based on selected criteria To print list of accounts below minimum balance To maintain freeze status in account To inquire / update status of minor a/c To print Ledger Printout of criteria-based selected accounts

[23]

CUIR

Customer Interest Report

CUMP

Customer Master Print

TACBSH

Transfer Accounts Subheads Interest run on account Inoperative to operative

INTRUN OPACTF

Between

To print Interest Application Report for a Customer’s Accounts To print Master Details for Customer’s Accounts based on Selected Criteria To transfer GL Subhead code of Accounts From Inoperative to Operative Category Application of interest on accounts To Transfer of accounts from Inoperative to Operative category

STANDING INSTRUCTIONS MAINTENANCE This menu option can be used for creating credit Transactions in loans account. If Charges are not to be recovered then Transaction TYPE should be BI instead of CI. For Loans recovery thru SI after filling information go to next page by pressing F6 for accepting FLOWID. RELATED MENU OPTIONS SIM

SI Maintenance

To Add, Modify, Cancel, Verify SIs

SIE SIETR SIRP SIADVC

Standing Instructions Execution SIs Executed Today Report S I Register Printing Print SI Advice To Customer

For Adhoc Execution Of Sis To Print Report Of SIs Executed Today To Print SI Register To Print Advices For Executed SIs

CFLM

Carry-Forward List Maintenance

To Maintain Failed SIs, Carried Forward For Next Day SII Standing Instructions Inquiry To Make Inquiries On Standing instruction CCCCREATION In Finacle, Standing Instructions can be defined through the menu Option SIM i.e. Standing Instructions Maintenance. Functions which can be performed are Add, Copy, Inquire, List, Modify, Undelete, Verify & Cancel. How to enter SI? Menu option – SIM (Standing Instruction Maintenance) Let’s take an example – Enter an SI which is requested by the customer (D10000411) to debit his SB A/c (01725) by a fixed amount of Rs.5000/-to credit his CC A/c (87433) which are being maintained at our SOL i.e. 417700. The SI should be executed on 20th day of every month. The SI should be executed till 20.12.2008. Steps 1. Function – Enter A (Add) and press F4. The cursor will appear in SI Class field. 2. SI Class – Default value is C (Customer Induced). Press Tab or F11. 3. Cust ID – D10000411 4. SOL Id – 417700 (default populated) 5. SI Frequency – As the above SI should be executed on 20th day of every month, the valid values in SI frequency are M-Blank-Blank-20-N. 6. Execution Time – Valid values are B (Day beginning), D (Anytime during day), A (After Business Hours), E (Every Time). ‘B’ means, SI will be automatically executed during Begin of day process. ‘D’ means, SI will be executed only once during the day whenever we run SIE (Standing Instruction Execution) menu option first time, ‘A’ means, SI will be executed during ABH process, ‘E’ means, SI will


[24]

be executed every time whenever we run SIE menu option. In our case we will take it as ‘D’ i.e. Anytime during day. 7. Next Execution Date – Enter the date on which the SI will be executed first time. Press Ctrl+X to bring today’s date. 8. Auto Post - Value is default Y, which means, whenever SI is executed, the system will post the transactions automatically and user need not go to TM (Transaction Maint.) menu option to post these transactions. If this is N, then the transactions created during execution of this SI will remain in Entered state. User has to go into TM and post them. 9. End Date – Enter the date on which SI to be ended. 10. Suspended Upto – Enter the date upto which SI will not be executed. Means, suppose, if the starting date is 20.12.2007 and End date is 20.11.2008 and on 01.02.2008, customer comes and request to suspend the SI till 20.04.2008, then this date can be entered in this field. This means, SI will not be executed on 20.02.2008 and 20.03.2008. 11. Accept Event – Press F2. Select the event by pressing Shift+F4. This field is used to select the charges to be levied on customer for requesting the SI. 12. Fail Event – Press F2. Select the event id by pressing Shift+F4. This field is used to select the charges to be levied on customer for if the SI fails. 13. Exec Event - Press F2. Select the event id by pressing Shift+F4. This field is used to select the charges to be levied on customer for execution of SI. 14. Chrg Rate – Default is NOR (i.e. Notional Rate). 15. Dr. Acct – If any or all the above three events are entered, then give the account number from where the charges will be deducted by the system automatically. 16. Delete tran if not posted – Default is N. If the transaction is not posted due to any reason and if this field is kept as N, the system will keep the transaction in Entered state, otherwise, the transaction will be automatically deleted by the system on unsuccessful execution of the SI. 17. Carry Forward – Default is Y. 18. Max times – enter number of days. If the Carry Forward field is kept as Y and value for Max times field is entered, the system will carry forward the SI for the number of days entered in Max times field, if not successfully executed. 19. Remarks – free text. 20. Closure Remarks – free text. Press F4. The system will bring Sub Instruction screen. The cursor is in Option field. At the right-top side Sub Instruction Serial No. 1 is displayed. Debit part of SI – 21. Option – Enter E. Press F4. 22. Amount Ind – Valid values are F-Fixed, V-Variable, C-Contra Balancing, T-Table Code. In our example we have to debit SB A/c 01725 by Rs.5000/- i.e. we have to debit the a/c by fixed amount, so in this field enter F. 23. Part Tran Type – Valid values are C-Credit and D-Debit. In our example we have to debit the a/c, so make it D. 24. Create Memo Pad – Y. 25. Currency – INR. 26. Fixed Amount – This field will be mandatory as we have made Amount Ind field as F. Enter Rs.5000/-. Press F4. System will bring part tran details screen. 27. Account Number – Enter the account, which you want to debit. In our example it’s 01725. Press Tab. 28. Amount Indicator – Enter P (Percentage). Press Tab. 29. Percentage to be applied – Enter 100. This is because, we want to debit full amount of Rs.5000/- from only one account no. 01725. (In case, we want to debit 30% of Rs.5000/- from one account and rest


[25]

70% (of Rs.5000/-) from another account, we need to enter 30 in this field and press Down arrow, enter account no, press tab, enter P, press Tab and enter 70 in the percentage field). 30. Press F4. 31. The cursor will come back to Option field. We have only completed Debit part of SI. To enter Credit part of SI, Enter E (which is already there in the field) and press F4. Credit part of SI – 32. Amount Ind – C (Contra balancing). This is because; we are entering contra part of the SI. 33. Part tran Type – C (Credit), because we want to credit Rs.5000/- to A/c No. 87433. 34. Create Memo Pad – Y. 35. Currency – INR. Press F4. 36. Account Number – Enter the account, which you want to credit. In our example it’s 87433. Press Tab. 37. Amount Indicator – Enter P (Percentage). Press Tab. 38. Percentage to be applied – Enter 100. This is because, we want to credit full amount of Rs.5000/- to only one account no. 87433. (In case, we want to credit 30% of Rs.5000/- to one account and rest 70% (of Rs.5000/-) to another account, we need to enter 30 in this field and press Down arrow, enter account no, press tab, enter P, press Tab and enter 70 in the percentage field). 39. Press F4. 40. The cursor will come back to Option field. Now that we have completed debit and credit parts of SI, we can save the SI. Press F10 to Commit/Save. 41. Note down the SI Serial No. and press F3 twice. You back in the main menu. VERIFICATION OF SI Menu Option SIM (Standing Instruction Maintenance) Steps – 1. Function – V (Verify). Press Tab. 2. SI Srl.No. – Enter SI Serila No. which you wish to verify. If you forgot to note the SI Serial No., you can press F2 to get the list of unverified SIs, select the one which you wish to verify. Press F4. The general details will appear on the screen. Check the details. Press F4. The cursor will appear on Option field with the Debit part of the SI on your screen. Check it. 3. Option – Enter P. Press F4. Check the account and other details. Press F3. 4.

Option – Press Down Arrow. The system will display credit details of SI. Press P (which is already displayed in the field) and F4. Check the account and other information. Press F3.

5. Option – Press F10 to commit/save. The SI is verified. Press F3 to come out of the menu option. How to enter SI for Draft? Menu Option – SIM Example – Enter SI, to prepare a draft of Rs.500/- (drawn on BO: Bhagya Nagar, Aurangabad, favoring Anant Jadhav) on the 1st day of every month, by debiting A/c 01725 (customer ID D10000411). Steps – 1. Function – A (Add). Press F4. 2. SI Class – C (Customer Induced) 3. Cust id – D10000411 4. SI Frequency – M-Blank-Blank-1-N 5. Execution time – D (Anytime During Day) 6. Next Execution Date – 10-12-2007 (enter appropriate date). Press F4. To Enter DD related transaction details 7. Option – E (Enter). Press F4.


[26]

8. Amount Ind – F (Fixed) 9. Part tran Type – C (Credit) 10.Create Memo Pad – Y 11.Currency – INR 12.Fixed Amount – 500. Press F4. 13.Account Number – DD. Press F4. 14.Amount Ind – P (Percentage) 15.Percentage – 100. Press F6. The system will bring ‘Issue of DD’ screen. Leave City Name as blank. 16.Drawn on – Bank Code – 024. Branch Code – 1005. 17.Payee Name – Anant Jadhav 18.Purchase A/c No. – 01725. 19.Purchaser Name – This will automatically appear. 20.Print Option – I (Immediate). Press F4. The cursor will appear in the A/c No. field of previous screen. Press F4. The cursor will appear in Option field. To enter commission on DD related transaction– 21.Option – E(Enter). Press F4. 22.Amount Ind – T (Table Code) 23.Part tran type – C (Credit) 24.Create Memo Pad – Y 25.Currency – INR 26.Fixed Amount – 500. Go to the ‘Amount Table Code’ field by pressing Tab. 27.Amount Table Code – Press F2. Go to list item DDCOM (Commision on DD/MT/TT). Select it by pressing Shift+F4.Press F4. 28.Account No. – Type COMM, press F2. Go to ‘INC COMM ON DRAFTS & TRANSFERS’, select it by pressing Shift+F4. 29.Amount Ind – P (Percentage) 30. Percentage to be applied – 100. Press F4 . The cursor will appear in Option field. To enter debit account details – 31.Option – E (Enter). Press F4. 32.Amount Ind – C (Contra Balancing) 33.Part tran type – D (Debit) 34.Create Memo Pad – Y 35.Currency – INR. Press F4. 36.Account No. – 01725 37.Amount Ind – P (Percentage) 38.Percentage – 100. Press F4 . The cursor will come back to option field. Press F10 to Commit/Save the SI. Verify the SI as explained in ‘How to verify SI paragraph’. When do SIs get executed ? a. SIs which have been marked as B (Day Beginning) in Execution Time will be automatically executed during BOD process. b. SIs which have been marked as A (After Business Hours) in Execution Time will be automatically executed during EOD process. c. SIs which have been marked as D (Anytime During day) will be executed when when we run SIE (Standing Instruction Execution) menu option first time during the day. d. SIs which have been marked as E (Every Time) will be executed as many times as we run SIE menu option. EXECUTION OF STANDING INSTRUCTIONS Menu option – SIE 1. Execution Time –Enter D or E. Press F4. 2. System will bring Print parameter acceptance form.


[27]

3. Fore/Background – Enter F. 4. Print Required – N. Press F10. Wait till until progress indicator (which is on the bottom-right corner of the screen) comes back to green. Press F3. The system generates execution report for all the SIs selected of the type mentioned in steps 1. Please see the report. Reports & Inquiries – SII – Standing Instruction Inquir y, SIETR –SIs Executed Today Report SIRP – Standing Instruction Register Printing.

CHEQUE BOOKS MAINTENANCE PERSONALIZED CHEQUE BOOKS At present request for personalized cheque books are being sent to Printing and Stationary Department through menu option “CBSCHQBK”. Cheque books are being sent by P&S Deptt. HO in verified stage. Some of the PCBs are received back and to avoid misue following procedure be adopted : 1)

PCBs will continue to be sent to customers directly at 275 identified centres in verified stage whereas the PCBs being sent to base branch other than the specified centres for onward delivery to customers will be sent by P&S Department HO in ‘I’ status I.e. “Issued but not acknowledged”. Branches have to obtain proper acknowledgement from the customer, feed the same in system so that the chque status is changed to ‘U’ (unused) status.

2)

A menu option ‘CHQSTAT’ has been customized for the branches to change the status of cheque from ‘U’ to ‘I’ ( issued but not acknowledged) for the situations where personalized cheque book sent to customer’s address, is returned to the base branch due to unavailability of customer ( or any other reason). Once the status is changed system gives message “Record updated successfully”. (TBD 52/2013)

CHEQUE BOOK ISSUE Issuer or Verifier of Cheque book Issue Process must hold the physical stock of Cheque Books. System will have this information through Inventory Movement Process. Menu Option – ICHB, Function – I, Enter A/C No. In the field ‘Cheque book Ack. Obtained?’ Type ‘Y’, if acknowledgement has been obtained, else type ‘N’. Press F4. Enter Cheque Type (select by pressing F2, say SB20 or CA100 or ANU-10) & press F4. System will list the available Cheque books with the issuer, if any. Select the Cheque book(s) to be issued with Shift+F4 & Commit with F10. VERIFICATION / CANCELLATION OF THE ISSUE OF CHEQUE BOOKS Menu Option – ICHBAU Function – V/X, Enter A/C No. or F2 to List Unverified Cheque Books, select with Shift+F4. Press F4. While verifying, Enter ‘Y’ in ‘Collect MICR charge’ field to recover Cheque book charges. Press F4 & Commit with F10. Another Chequebook cannot be issued in an a/c with unverified Cheque books. ON RECEIPT OF ACKNOWLEDGEMENT FORM (PNB 119) FROM CUSTOMER If ‘N’ was given at the field ‘Cheque book Ack. Obtained?’ while issuing Cheque book, then on receipt of acknowledgement (PNB 119) from the customer the same is to be marked & verified in the system.


[28]

System will not mark Stop Payments for unacknowledged Cheque leaves. Menu Option – CHBM, Function – A, Enter A/C No. Press F4. Select the Cheque books for which acknowledgement is to be marked Commit by F10. Verification/Cancellation has to be done with CHBM-V/X function. "CHBM" MENU -- ‘C’ FUNCTION – MARKING OF CAUTION Caution can be marked on the Cheque the status of which is UNUSED. That is to say that caution cannot be marked on a Cheque which has not been acknowledged Invoke menu option CHBM: Enter C in the Function Field, Press Tab, Enter Account No., Press Tab, Enter Begin Ch. No., Press Tab, Enter No. of Leave & Press F4, System will display equal number of Cheque as entered in No. of Leave column starting from the Begin Ch. NO. The system will also display the Current Status of Cheque and New Status of Cheque Caution can be unmarked by UNDO function through the same menu option i.e. CHBM It is to be noted that system allows payment of caution marked cheques. However, an exception Cheque Cautioned is raised at the time of its posting/verification INQUIRY ON CHEQUE BOOKS ISSUED IN AN A/C Menu Option – CHBI Give a/c number in which cheque book inquiry is to be done Name will be displayed automatically Purpose to view - User has to mention the details Enquiry is required.

for

which

the

cheque

book

INQUIRY OF ACCOUNT NO. FOR A GIVEN CHEQUE NUMBER Menu Option – INQACHQ. Enter Cheque No & Sol-ID. Press F4. Quit with F3 CHEQUE INQUIRY Cheque Book inquiry can also be made while working in any screen or any menu option without quitting from it. press F5 or click on Background at the menu option bar, the system will display the Background Menu. At the Background menu select the appropriate option, delete the number appearing in the Make your Choice field and enter the same again before pressing F4. CHBM screen will be displayed. Enter I (for inquire) & A/c No. & Press F4. System shall display the same screen under the title Menu Option CHBM. The Cheque book record can be exploded here too, for looking at status of Chequebook leaves. DO YOU KNOW THAT A MOBILE BANKING CUSTOMER CAN MAKE STOP PAYMENT OF HIS CHEQUES USING SMS MESSAGE SENT TO 5607040 MENU OPTIONS AT A GLANCE { CHEQUE-BOOK) ICHB Issue Cheque books For Issue, Verification, Cancellation And Printing Of Cheque books CHBM Cheque Book For Marking Acknowledgement, Caution, Revoking Caution, Maintenance Destroying Unused Cheque Leaves, Verification And Inquiry INQACHQ Inquire A/C Number For Inquiring Account Number From Cheque Number For A Cheque CHBIR Cheque Book Issued For Printing Cheque book Issue Register Register SPP/SPPAU Stop Payment To enter/cancel Stop Payments Processing PNBPRPT (Daily Report Part I / 5)


[29]

SECURITY FORMS INVENTORY MANAGEMENT IN CBS SYSTEM If any IMC entry (created by Ptg. & Sty. Dept.) remains outstanding beyond 15 days from the date of IMC, concerned branch(es) will get an alert at the time of ‘ Day End’ for next 5 days but on thje 20th day of IMC entry remaining outstanding branch will not be able to proceed with the ‘day-end’ process unless the relative IMC entry is dealt with. In case new branch (yet to be opened), uptill now security forms where being sent by the Stationary Department to the concerned Circle Office without creation of IMC entry. Now IT CBS has created one more inventory class/code CO/CO valid for department i.e. 399600. Before dispatch of inventory HO will create dummy IMC movement from 399600, DL/DL to 399600, CO/CO and only thereafter physical stock will be sent. On operationalisation of IMAUM of the branch HO will transfer the stock to new branch by using IMC option. IMPORTANT AT BRANCH LEVEL SYSTEM WILL NOT ALLOW TO BRING THE INVENTORY FROM EXTERNAL LOCATION ( I.E. ZZ/EXT) SINCE PRINTING AND STATIONARY DEPARTMENT IS DIRECTLY ENTERING THE SECURITY FORMS IN THE LOCATIONS OF BRANCHES. (ITD CBS 80/2013) RELATED MENU OPTIONS IMC IMI IMR ISIA ISI ISR ISRA IMAUM

INVENTORY MOVEMENT BETWEEN LOCATIONS INVENTORY MOVEMENT INQUIRY INVENTORY MOVEMENT REPORT INVENTORY INQUIRY, SPLIT AND MERGE (ALL) (other than the user location) INVENTORY INQUIRY, SPLIT AND MERGE (AT USER LOCATION) INVENTORY STATUS REPORT AT EMPLOYEE LOCATION INVENTORY STATUS REPORT (ALL) UPDATE WORK CLASS AND USER OF DOUBLE LOCK

CLEARING OPERATIONS OUTWARD CLEARING 1. In CBS all cheques sent to clearing house are sent after opening a zone each day and entering all the cheques under that zone. 2. All cheques are lodged by opening a Zone of specific latency period each day. 3. Latency means the number of days from the date of opening after which the system would allow to release the zone to shadow balance i.e. day when cheque amount credited to customer account. 4. Shadow balance reflects the amount which has been credited in the account but can not be withdrawn since it is under clearing. FLOW CHARTS – OUTWARD CLEARING: Open Zone Lodge cheques Verification Generate Reports Suspend Zone Revoke suspension of Zone Release cheques to shadow Regularize Zone Mark Pending cheques not to be regularized Revoke cheques marked pending earlier Transfer of sets from a zone to other Inquiry on clearing sets Inquiry on shadow balance


: : : : : : : : : : : : :

MCLZOH (O) OCTM (A) OCTM (V) PCLSO, PNBRPT MCLZOH (S) MCLZOH (V) MCLZOH (R) MCLZOH (G) MARKPEND REVPEND TROFSETS IOCLS ACSBIO

[30]

THE PROCESS FOR OPENING THE OUTWARD CLEARING ZONE 1. Menu MCLZOH, function O for Zone Open 2. Press TAB give date of zone, Press TAB & press F2 (it will show list of zones) 3. Bring arrow to the zone to be selected and press shift key & F4 4. Respective Zopne will be selected. Press F4 & than F10 Date of zone can be BOD or any future date. Now the cheques can be lodged. It is possible that more than one user can lodge instruments in a single zone or separate zones can be opened for different users as per requirement in the branch. 5. To lodge the instruments invoke menu option, OCTM FUNCTION A 6. Press tab BOD will be shown, change it if required and press tab, give desired zone name and Press F4 LODGEMENT OF INSTRUMENTS CAN BE OF 3 TYPES 1. One instrument with one account number to be credited. 2. Multiple instruments with & one account number to be credited. 3. Multiple account number to be credited with one instrument. FOR TYPE 1 MENU : OCTM Function A 1. Give date & name of zone press F4 A set number is generated. Note set no on the face of voucher 2. Put account number press Put amount press F6 3. Put instrument number press tab key. 4. Put sort code from the instrument i.e. combination of bank code & branch code press tab For LDD zone bank code is always 024 and sort code give branch distinctive number. 5. Amount is already populated there, press tab press F2 & select appropriate code (optional) 6. Press down arrow key (key board) 7. check if credit amount & instrument amount same. 8. Press F10 and go for another set. Continue the process till all instruments are lodged. FOR TYPE 2 MENU : OCTM Function A 1. Give date & name of zone pressF4. A set number is generated. Note the number on the Face of the voucher. 2. Put account number and press TAB put amount press F6 3. Put instrument number press tab key. 4. Put sort code from the instrument i.e. combination of bank code & branch code press tab. 5. Put amount of the instrument by altering the amount shown on the field, press down arrow key (key board) enter instrument number press tab sort code, amount of the instrument as before and continue with down arrow, if there are further cheques until all cheques are entered. Check if credit amount & instrument amount are same. 6. Now press F10 and go for another set. Continue the process till all instruments are lodged. FOR TYPE 3 MENU : OCTM Function A 1. Give date & name of zone press F4. A set number is generated. Note the number on the Face of the voucher. 2. Put account number and press TAB 3. Put amount press down arrow cursor will come to account number. Repeat as above and Continue until all account numbers are entered. Than press F6 4. Put instrument number press tab key. 5. Put sort code from the instrument i.e. combination of bank code & branch code press tab. 6. Put amount, press down arrow key ( key board)


[31]

7. Check if credit amount and instrument amount tallies. Press F10 After all cheques have been lodged 1. 2. 3. 4. 5.

Invoke menu MCLZOH Function I Give zone name and date & press F4 & press F6 twice Total value of cheques, number of instruments and vouchers will be shown. Prepare the imprest voucher accordingly. Modification before verification may be made through menu OCTM function M giving zone name, date and set number. 6. Modification after verification may be made by transferring the set to new zone by menu TROFSETS and then doing the modification process and retransfer of the set to the old zone by TROFSETS again. 7. Once the set is transferred to new zone set number will change.

VERIFICATION OF THE LODGED INSTRUMENTS MENU : OCTM Function V 1. Press TAB & zone date BOD will be default populated. Change if required & press TAB 2. Give zone name & press TAB and give set number Press F4 3. If there are more than one account number for single instrument press down arrow (key board) and view all the vouchers amount. Then press F6. View the instrument detail Press F10. 4. If one account number as multiple cheques, after viewing account number entry press F6. To view more than 2 instruments press down arrow key. Press F10 to commit. 5. Each set will be verified individually. 6. Use menu IOCLS giving zone name & date to check if all instruments are verified. 7. If no more instruments is to be lodged SUSPEND the zone through menu option MCLZOH (S) 8. Subsequently, if there is any requirement of addition of further instrument or modification of any entry the zone may be un-suspend through menu option MCLZOH (U). 9. If zone is ZERO latency i.e. same day credit is to be given to customer’s a/c than release to shadow balance menu MCLZOH (R). 10.In case of 1 day latency zone do this function next day morning after day being. 11.After release of shadow balance, the account will show higher balance, but effective balance available will be only the amount of clear balance. 12.If there are returns, after marking the same incase of ZERO latency regularize the zone i.e. menu Option MCLZOH (G) 13. For one day latency do it day after tomorrow, Once regularized the outward clearing zone will automatically be closed. ENQUIRIES REGARDING OUTWARD CLEARING CHEQUES - MENU – OIQ INWARD CLEARING Inward clearing cheques are also required to be lodged in a new zone every day. FLOW CHART - INWARD CLEARING Open Zone Lodge cheques Verification Tallying with BAR Amount Suspension of zone Revoke suspension Validation of instruments Posting of zone Close zone


: : : : : : : : :

MICZ (O) ICTM (A) ICTM (V) ICTM (I) ‘S’ sub option MICZ (S) MICZ (R) MICZ (V) MICZ (P) MICZ (Z)

[32]

PROCEDURE FOR OPENING INWARD CLEARING ZONE MENU – MICZ (O) 1. 2. 3. 4. 5.

Press Enter Enter Enter Press

TAB twice and press F2 and select zone & then press F4 the bar amount i.e. total amount of cheques received from clearing house. the number of instruments the number, if any and date F4 & F10.

ENTRY OF INWARD CLEARING CHEQUES MENU – ICTM – A 1. Press Tab Twice & specify t he zone name that you have opened & press F4 Fill up the details 2. The moment account number is filled up press transmit key and see whether the available amount permits passing of cheques ( this is indicated in the lower block of the screen). If available amount is less than cheque amount enter the cheque but keep it separately, so that return can be marked. 3. At carving required ? flag put ‘Y’ 4. At rejection flag put ‘N’. If it is to be returned put this flag as I 5. Press down arrow key for each cheque entry, After all cheques are entered press F10 6. Get back to menu MICZ function I 7. Put the zone name press F4 put S in option block & press F4. It will show whether all cheques have been entered. If there is short / excess claim then check the entries. Please handover the cheques to the clearing incharge for verification. ENTRY OF CASH ORDER IN INWARD CLEARING For cash order received in clearing in the block for instrument number put branch serial number e.g. 103 and not 103/06 after putting the instrument date press F6. It will go to next page. Put in alpha number and the printed cash order number i.e. alpha number and numerical number in the field for reference number and press F4. VERIFICATION OF INWARD CLEARING ENTRY 1. First of all check if total number of instruments and total amount of cheques received from clearing house is entered correctly or not. 2. This can be done through menu option MICZ, Function I specify the zone name press F4 3. Put ‘S’ in the option block press F4. Check if the bar credit amount tallies with clearing figure and customer/ office debit amount. 4. If not ensure all cheques have been posted and no cheque has been posted more than once. 5. If it is found correct, go for verification of individual entries through menu option ICTM, Function ‘V’ press F4 twice all entries are displayed in selection mode. 6. Use down arrow key to check all the entries and finally Press F10 for verification of all cheques together. If the balance available in the corresponding accounts in which cheques have been received is to be checked use Menu option ICTM function I for inquiry. 7. Specify zone name and date, Press F4 twice. The entries will be displayed. 8. By pressing down arrow key the >indicator moves down. Corresponding accounts available balance is displayed. 9. In case of insufficiency of balance press down arrow and see through the cheques details. 10.Accordingly decide which cheques are to be returned. Handover the cheques to CTO for making necessary modification for returning the cheque i.e. carving as N and rejection as I in menu ICTM function M. RETURN OF CHEQUE FROM INWARD CLEARING 1. While entering the cheque in ICTM option, mark a cheque returned by putting the ‘Rejection’


[33]

flag as I and Carving flag as ‘N’ 2. If not done subsequently also a cheque can be returned through Menu ption ICTM function M 3. Specify zone name press F4 give cheque number press F4. The entry page will appear, Press TAB key and move to carving boock make it ‘N’ & rejection ‘I’ and press F4. 4. Selection rejection code Press F4. 5. Modify charges if required. Accept by pressing F4. 6. Specify the presenting bank code (select from list available) Press F10 7. This requires verification by authorized official by menu option ICTM, Function V. RETURN CHEQUES FROM OUTWARD CLEARING 1. 2. 3. 4. 5. 6. 7. 8.

Open a zone ‘NMICR’ in menu option MICZ At BAR amount mention total amount of cheques received back as return from other banks. Enter number of instruments received back and press F4 and F10. Enter the cheques with menu option ICTM function A zone name NMICR. Make all entries as before only carving box tobe made ‘N’ and rejection ‘O’ press F4. Next page will ask for rejection code. select from list press F4. Next page will show the charges select the charge by down arrow and rectify the charge amount If required press F4 and F10. 9. This requires verification by authorized official by menu option ICTM, Function ‘V’ INQUIRY ON CLEARING RETURN BOTH INWARD AND OUTWARD Use menu REJREP . Give the clearing type as I for inward and O for outward and ill up the other details. INWARD CLEARING OPERATIONS – OTHER STEPS 1. After verification of all entries in inward clearing SUSPEND the zone Menu MICZ (S) After suspending the zone you cannot further add any instrument to the zone. Function ‘R’ may be used for revoking suspension if required. 2. Run the validation run before posting the menu MICZ, function V, it will ask for report file name mention it as iclg_Val.mrt The validation report will show which cheques will not be posted in the normal course. Take necessary steps for posting of these cheques. 3. Post the zone with menu option MICZ, Function P , if all entries are not posted from here it will give Transaction Id and give message that posting failed. Note the Transaction Id and post the left over entries through TM menu. Again post the zone and check if all entries are posted. 4. Finally close the inward clearing zone by menu MICZ function Z. LOCAL CHEQUES FOR ODD IN CLEARING 1. Best option is to collect the cheque in sundry- Bills through clearing. When zone is cleared, realize the bill from BM R function but change the realization account to the sundry bills account. 2. If ODD is credited directly then it requires portioning details which may not be available to the clearing In charge. Also the ODD will outstand in BM unnecessarily. IF MEMBER BANK/BRANCH DOES NOT PARTICIPATE IN CLEARING HOUSE 1. If the information is received before the zone is released to shadow balance, the sets pertaining to concerned Bank/Branch can be transferred to a new zone – opened for next date (With same Home clearing flag) through KMCLZOH-T option (also by TROFSETS option) verify again. 2. If information is received after the Zone is released to shadow balance, the instruments pertaining to concerned Bank/Branch should be marked pending with MARKPEND menu option. On regularization of Zone remaining instruments will be cleared and zone status shall remain partially regularised. 3. On clearance, use REVPEND menu option to revoke status of instruments marked as pending and run regularization process again (MCLZOH-G)


[34]

CLEARING LOCALITY REFERENCE CODE – ENHANCEMENT 1. The application provides a link between the branches and the clearing centre in which they participate. 2. In the present version the listing of branches is done, irrespective of whether they participate in clearing or not. 3. There is a provision for entering the clearing locality code while opening the outward clearing zone. 4. While entering any outward clearing instrument data, user will get only those branch lists whose clearing code matches with code in BRTM. MODIFICATION IN OCTM AFTER VERIFICATION Instrument lodged and verified in OCTM can be modified before release to shadow balance. System makes a check that even if a single modification is done in the set, the entire set needs to be verified again. MICR CODE MAINTENANCE IN THE SYSTEM MICR Code is a unique 9 digit number assigned by RBI to the branches of banks across India. constitution of MICR Code is as under: Ist three digits Mid three digits Last three digits

The

- City code of the branch - denote the bank code - denotes the reference branch code

Circle office ZC user or Data centre DC user has been given the powers to modify / enter MICR code through menu option ‘BRTM’ PNB Branches as well as other bank’s MICR can be updated by ZC/DC user as per procedure laid down in ITD CBS Circular no. 10/2014 dated 21.03.2014 SOME RELATED MENU OPTIONS FOR CLEARING OPERATIONS MENU OPTION MCLZOH

DESCRIPTION

PURPOSE

Maintain Outward Clearing Zones

For all Zone related Operations in Outward Clearing

OCTM

Outward Clearing Maintenance

For lodging,modifying,verification of O/W Clearing Cheques.

IOCLS

Inquire on O/W Clearing Sets

To know status of OW Verified/Unverified/Unbalanced

PCLSO

Print OW Clearing Schedule

To print O/W Clearing Schedule

DAYRPT

Reports Main Menu

Use Option 3 for Clearing Reports

MARKPEND

Mark Pending Instruments

For marking instruments pending for regularisation

REVPEND

Revoke Pending Instruments

For revoking instruments marked as pending for regularisation

TROFSETS

Transfer of Sets

To transfer OW Clearing Sets from one Open Zone to Another

OIQ

OW Clearing Inquiry


Transaction

Instruments

Clearing

Sets

Instrument base Inquiry

[35]

–

OPQ

OW Clearing Part Tran Inquiry

Voucher Based Inquiry

UNLKZ

Unlock OW Clearing Zone

TM

Transaction Maintenance

To unlock a locked zone due to abnormal logout To Post Transactions in the Accounts

REJREP

Rejected Advice

MICZ

Maintain Inward Clearing Zones

For all Zone related Operations in Inward Clearing

ICTM

Inward Clearing Maintenance

For lodging,modifying,verification of I/W Clearing Cheques.

UNIZ

Unlock IW Clearing Zone

DTCS

Display Transaction Code Summary

Instruments/

Reports

Transactions

To print Returning Schedules / Reports

To unlock a locked zone due to abnormal logout To view Transaction-Code wise summary of Inward Clearing Cheques

TRANSACTION MAINTENANCE AVAILABLE SUB OPTIONS: MENU OPTION "TM" OPT

OPT

DETAILS

OPT

DETAILS

Additional Details Grant/view TOD Details. Proxy Post Part Tran Purchase/Sale Details Partitioning Details

P R

Post Transaction Reset the Request

V

Verify

B

W

Show Components of Available Balance Other Details of Part Tran. E.g. Who entered and posted the transaction. Release Lien Details

8

Swift Details

F

Foreign currency Details

DETAILS D T

A N

C

Delete a Part Tran Copy Part Tran Summary * Copy Entire Part Tran

E

Enter entire Part Tran

H

K

Check Part Tran

G

L

List Part Tran.

J

I

Inquire on all the part Tran Modification of Part Tran

Z

M

Y

U

User Additional Details Print Voucher on Entry Show Part Tran Totals

O

SOME FIELDS ARE NOT MODIFIABLE A/c Number field – if after filling in details of transaction F4 (accept) has been pressed the a/c number in the transaction cannot be changed. Instrument type - cannot be changed in case of debit transactions. Instrument date - cannot be changed in case of debit transactions. The date is validated by the system for staleness TM --OTHER FUNCTIONS TO SEE THE JOINT HOLDER IN THE ACCOUNT WHILE POSTING THE VOUCHER.


[36]

In the Account number field in TM- enter the account number and explode (Ctrl + E) to open the ACI inquiry for the account. Use ‘A’ option and down arrows to see the joint holders. Explode (Ctrl + E) in account number field in any Menu in the system will open the ACI menu. From this menu open the ACLI ledger Inquiry menu with ‘G’ option. CHECKING BALANCE AVAILABLE IN THE ACCOUNT WHILE POSTING A VOUCHER TM-‘M’/’I’ FUNCTION – ‘B’ OPTION. GIVES SAME SCREEN AS ACCBAL. IN ACCBAL THE SHADOW BALANCE IS THE POSTED OUTWARD CLEARING AND THE FLOAT BALANCE ARE THE CHEQUES ENTERED IN TODAY’S CLEARING BUT NOT RELEASED TO SHADOW BALANCE. THE SYSTEM RESERVED AMOUNT GIVES THE INWARD CLEARING CHEQUES CARVED (ENTERED BUT NOT POSTED) BY THE SYSTEM. CREATION OF TRANSACTION TEMPLATE -- 'TTM' For a transaction of repetitive in nature, a template should be created so that it can be used every time to avoid creation of transaction again and again through TM. Menu option – TTM (Transaction Template Maintenance) Function – A (Add) to create a new template. Other functions are D-Delete, U-Undelete, M-Modify, IInquire & L-List of Templates. Temp. Id (Mandatory) – Enter id to be allotted to this template. It’s a free text field of 9 chars long. Particulars – Enter the particulars of template. It’s a free text field. Press F4. Type/Subtype (Mandatory)- Enter the type of transaction similar to TM. Enter C for cash or T for transfer. In the subtype field, enter the subtype similar to TM ; Press F4. The cursor will appear in Specify option field. If a new part tran is to be added, enter E in this field (which appears by default) and press F4. A/c No – Enter the account no. and press F11 twice. Enter the transactions details like amount, type of part tran (C-Credit or D-Debit), which is mandatory, Instrument type etc. similar to TM. Press F4. The cursor will appear in Specify option field. Fill up details of all the part trans as desired. Once all the part trans are entered, press F10 to commit/save the template. Press F3 to quit from menu option. After the template is saved, it can be used any number of times. USING TEMPLATE Menu option – TM (Transactions Maintenance) Function – C (Copy) Tran Id – Enter the template ID, which is already created through menu option TTM. Press F4. The system will display 1st part tran and cursor will be placed in Specify Option field. Specify Option - If the part tran is to be modified, enter M in this field and press F4; except a/c no, all the details of the part tran can be modified. Follow the procedure of TM for posting / verifying. SOME OPTIONS AVAILABLE IN 'SPECIFY OPTION' FIELD 1)

OPTION A (ADDITIONAL PART TRAN DETAILS) – Some transactions need additional details to be entered. During addition/posting/verification/inquiry, enter A and press F4 in this field to know additional details, some examples i. While issuing DD, system asks details like branch D.No on which DD is to be issued, Payee name, purchase a/c No/name, commission etc. These details are captured by the system as a part of additional details.


[37]

ii.

2)

3)

4)

5)

While crediting Term Deposit A/Cs, system asks flow code like Principal Inflow, Installment Inflow etc. These details are captured as a part of additional details. OPTION K (CHECK PART TRAN) This option can be visited during addition of a new transaction. After entering necessary fields, press F4 key to come to Specify options field, system may display a message at the status bar as ‘Warning: Exceptions Encountered’. visit the list of warning/exceptions by entering K and pressing F4 in this field. OPTION – L (LIST PART TRANS) This option can be used to see the list of all part trans. The lists displayed on the screen contain various details of every part tran like srl. No of the part train in the transaction, A/c No, Inst No. (if entered), Status of the part tran (like P for posted and V for verified & blank for entered but not posted/verified), Tran Dr. Amount, Tran Cr. Amount & Currency. In the bottom part of the screen, system also displays information like how many part trans are entered, posted & deleted. OPTION O (OTHER PART TRAN DETAILS) This option can be used to inquire about the details like users who have entered, posted and verified the part tran along with the date and time of the activity. OPTION B (SHOW COMPONENTS OF BALANCE) This option internally activates menu option ACCBAL. Can be used to know the details about the a/c entered in the part tran; like Clear Balance, Available Amount, Funds in Outward Clearing, total of amounts of cheques lodged in inward clearing, Drawing Power, Adhoc limit, Lien marked, Overdue liability etc.

6)

OPTION U (SHOW PART TRAN TOTALS) Can be used to know the total of all the Debit & Credit part trans. 7) OPTION W (RELEASE LIEN DETAILS) Can release lien(s) if they are already marked on the accounts opened under scheme types SBA, CAA, ODA, CCA, BIA, FBA & TDA. Release of Lien can be accessed only for debit part transactions. If the option is invoked, system may display all the active liens on the account. Select any record from the list o mark off the liens against the debit amount of the part tran. If the liens amount is grater than the debit amount, then lien is released partially. If the debit amount is greater than or equal to the lien amount then the entire lien will be marked off.

TM RELATED MENU OPTIONS MENU TM

DESCRIPTION TRANSACTION MAINTAINENCE

PURPOSE TO PUT THROUGH TRANSACTIONS IN ACCOUNTS TTM TEMPLATE MAINTENANCE TO PREPARE TEMPLATE OF VOUCHERS FOR FUTURE USE TEA TRANSACTION EXCEPTION FOR APPROVAL OF EXCEPTIONAL APPROVAL TRANSACTIONS TV TRANSACTION POSTING / FOR MASS POSTING /VERIFICATION OF VERIFICATION TRANSACTIONS ACLI LEDGER INQUIRY TO DISPLAY ACCOUNT LEDGER ACCBAL COMPONENTS OF BALANCE TO DISPLAY DETAILED BALANCE DETAILS FTI FINANCIAL TRANSACTION INQUIRY TO INQUIRE ON ANY TYPE OF TRANSACTIONS. ALSO TO LOCATE TRAN-ID FTR FINANCIAL TRANSACTION REPORT TO PRINT OUTPUT OF FTI VCHR Voucher Printing Can also be done through TM sub option Z) ADVC Advice printing (for customers) The SWO can generate the Cash payment long book by invoking menu option ‘DAYRPT’ option no.2 sub option no.2 and 3A. The long book will have record of all payments made by him during the day and 3A report shows details of cash receipts through CASHRCP menu option.


[38]

CASH PAYMENT THROUGH TOKEN SYSTEM - CBS Menu “TOKEN” The salient features of CBS Menu “Token” are as under: After running “Token” Menu in CBS Cashier shall enter the Transaction ID from the instrument presented to him/her for cash payment . The screen will populate the details such as Account Number, Instrument Type, Instrument Number, Amount, Tran Particular, User ID of maker (Entered User) & User ID of Checker (Posted User) and Status. After entering Transaction ID in the Token Menu, If the Tranasction is not found posted in the system, a message will be displayed that “The Transaction is not posted . Please post it first “. After posting all the details , the system allows user to enter token number. Token Number will be filled by the user which will be saved in the system and a massage will pop up ” Do you want to submit more records (Yes/No)”. In case any other token is to be entered in the system, user has to press “Yes” or otherwise press “No”. “Token “menu in CBS system has been enabled with the following functionalities: 1) 2) 3) 4) 5) 6)

7)

8)

Physical cash is to be opened as per existing procedure. Cash menu option “OCST/OXFT” is to be opened by the cash custodian in the branch. Cash distribution and related activities are to be carried out as per existing guidelines. All Cash receipts are to be entered in the system and system generated cash receipt is invariably to be issued to customer as per existing guidelines. Cash payments at SWO to be made as per existing guidelines. Cash payment at cashier counter based on token to be made by the designated person but they are required to capture the token on the system after tallying the cash payment details entered against the respective transaction number. At the end of day, empty the CDM bin, wherever provided and pass necessary voucher in the system as per guidelines. ABH will be allowed only if balance of CDM imprest account is made NIL. The branch has to execute CASHD option for feeding the closing cash balance of the branch. Close the cash in CBS and tally the physical cash with Cashier long book generated by the system and close the cash menu through CASHD. Each Cashier will print his/her Cashier‟s long book through a report available in DAYRPT 1/21.

TRANSFER OF FUNDS BETWEEN CBS BRANCHES IN NON-CUSTOMER ACCOUNTS. For transferring funds between CBS branches in Non-customer accounts (Office Accounts), a new menu option ÌSTRF - Inter-Sol Transfer of Funds' is available where the funds on account of Non-Customer accounts in CBS branches can be transferred to other CBS branches without involving TPOs/Advices. Only Transfer, Bank Induced (T/BI) type of transactions are allowed into the account opened for the specific purpose of transfer of funds between CBS branches for non-customer accounts through this menu option. The Branch Remitting the Funds to another CBS branch to the credit of a Non-customer Account should follow the procedure as under: All the transactions relating to transfer of funds to a CBS branch for the credit to a Non-Customer account should be routed through an account bearing number 3171160 - NONCUSTOMER INTER BRANCH FUNDS TRANSFER. (1) In order to put the transactions into this account invoke menu option ÌSTRF - Inter-Sol Transfer Transaction Menu'. (2) The system will display following details needed to be entered: i) Debit Account no: Enter the account number, which is to be debited. ii) Transaction Amount: Enter the amount of transaction in this field. iii) Credit Sol Id: This is the Sol-Id of the branch to which the funds are required to be remitted. iv) Tran Particulars: Enter the details of remittance in this field.


[39]

v) On entering all the aforesaid particulars press F4. vi) The system will create a transaction in entered stage and show the `TM - Transaction Maintenance' screen interface where post the transaction and note down the Tran Id. VERIFICATION OF THE TRANSACTION: The authorized officer is required to verify the transaction using menu option `TM - Transaction Maintenance' and giving function code as `V' followed by Tran Id. For modifying any transaction, invoke menu option `TM - Transaction Maintenance' and enter the Tran Id and press F4 and modify the transaction. i) On modification, the user is required to commit the transaction. ii) To make inquiry, invoke menu `TM - Transaction Maintenance' and the Tran Id and press F4. iii) The system will display the transaction. The Branch Receiving the Funds from another CBS branch to the credit of a Non-customer Account should follow the procedure as under: At the ABH of each day the system will automatically generate a report - Outstanding in Transfer of Funds Between CBS Br in Non-Cust A/c's where the details of all the outstanding transactions made by different sols into the account no: 3171160- NON-CUSTOMER INTER BRANCH FUNDS TRANSFER are available. i) Print this report every day and pass necessary transactions to the debit of account no: 3171160 - NON-CUSTOMER INTER BRANCH FUNDS TRANSFER which is an exact pointing type of an account and credit the Non-customer account as per the particulars mentioned in the report. The branches can also generate this report on any day using menu option `PNBRPT - 2/ 17' as per their requirements. FACILITIES AVAILABLE IN INTERSOL / BASE BRANCH ONLY - CCC 08/2014 S.No. 1 2 3 4 5 6 7 8 9 10 11 12

Facility available in Inter-sol Issue of Pass Book Issue of Statement of account Confirmation of deposit – CDR Issue of Debit Card Issue of IBS User Feeding of standing instructions Deposit in PPF in all branches Feeding in 15G/15H, change in address etc. in customer master Issue of demand draft Issue of TDS Certificate RTGS/NEFT with Incumbents permission after due diligence Submission of Life certificate

Facility non available in inter-sol Issue of cheque Book Change in name of customer master –CUMM Creation of Security Register maintenance Marking Lien (ALM) Freeze / Unfreeze account (AFSM) Feeding of standing instructions in PPF Adding / modification in nomination Transfer of Scheme code (ACXFRSC) Transfer of a/c from one sol to other(ACXFRSOL) Premature cancellation of FDR

PROXY POSTING While doing the End of day operations, system validates for any unposted or part posted transactions. If any unposted or part posted transactions are found then End of day operations cannot be carried out until the transactions are posted. The ends of day operations are done by the Data Base Administrator who may not be a part of regular branch operations. If any transaction is in unposted/part posted status, then it will be difficult for the Data base administrator to continue with the day end operations. In such scenario, he may have to either postpone the process, which may affect normal working next day, or he may have to initiate posting of transaction as a general user. Some times posting may involve granting of temporary overdrafts, which may not be within his discretion.


[40]

In order to overcome such a situation and to enable the Data Base Administrator to continue with his work, a feature “Proxy Posting” has been provided in Finacle. Proxy posting process will post the unposted/part posted transaction to an identified different account, and if the transaction is a debit transaction for a customer account that transaction will also place a lien on the original customer account. The next day, the general user can look into those transactions and reverse the proxy posted transactions. In UPM set up an user is authorised to proxy post a transaction. HOW TO POST PROXY TRANSACTION? If a debit part transaction to customer account is proxy posted, lien will be put for transaction amount on original account. To calculate the available amount of an account, total lien amount on the account will be subtracted. Total lien amount to be subtracted includes lien put by other modules also. Transactions to proxy account need additional details. After entering the normal details of the transaction in TM , invoke sub option “Y” in TM proxy posting which brings up the following screen: At the time of proxy posting the following details are to be filled up:-Proxy account – account to which the transaction should be posted. System populates by default an account number based on the SCFM set up. Which can be over ridden. Event id – Event id based on which the charges if any to be collected Value date – The value date the system should put while reversing the transaction Single reversal – Whether system should try for only one reversal or multiple reversal can happen for this proxy posting. If multiple reversal are permitted, the system will recover the amount whenever there is available funds in the account to the extent of amount recovered, the lien will be removed. Ref Account – If some account reference is indicated here, in SPTM menu, the record can be selected by indicating this account as one of the criteria selection or even generate a report. On F4 and F10 transaction main screen will proxy post the transaction. On commit the system will first try to post normally. In case posting does not go through only then system will try proxy posting. In case proxy posting also did not go through (say because of sufficient debits not posted) proxy details entered will be lost. Copy of part transactions, which is proxy-posted, is not allowed. Copy of transactions in which any part transaction has been proxy posted is also not allowed. The reference account accepted in proxy details can be used to inquire and take reports. REVERSAL OF PROXY POSTED TRANSACTION In order to reverse the transaction online invoke the menu SPTM – System Pointing type transaction maintenance - R . Using this option following activities can be done: -- Reverse transaction -- Verify reversal -- Generate reports -- Inquire There are various criteria for selecting record for reversal of proxy posted transaction. Once the criteria and F4 is given selected records based on the criteria shall be displayed. The following options are available at this point:--- and then . the transaction details can also be seen by key The screen displays information on various transactions that have resulted in reversal of the original transaction. From here and go to transaction maintenance screen to view further details, if required. QUOTING OF PERMANENT ACCOUNT NUMBER (PAN) As per guidelines quoting of permanent account number (PAN) may not be insisted upon for each transaction for purchase of demand draft, etc. of Rs.50000/- and above by debit to customer’s accounts if a customer has furnished PAN at the time of opening the account or subsequently. To meet above requirement of Reserve Bank of India and to enable to inquire before issuance of a demand draft, traveler cheque, mail transfer or telegraphic transfer etc of Rs.50000/- and above whether the customer has furnished PAN number in his account or not, a new menu option ‘PANINQ’ (PAN Inquiry) has been enabled. Each time a customer comes with the request for issuance of a demand draft, traveler cheque, mail transfer or telegraphic transfer of Rs.50000/- and above, invoke PANINQ option, enter the account number of the customer against the a/c number field and press F4. If the customer has already furnished his PAN number and the branch has captured it against the PAN/GIR number field in his CUMM and has verified CUMM, the system would display message at the bottom of the screen: “A/c No ____________ PAN / GIR No: ______________” If the system displays above message, do not insist for quoting of PAN number and issue the demand draft, traveler cheque, mail transfer or telegraphic transfer. If the customer has not already furnished the PAN number or he has furnished but the branch has not captured the PAN number against appropriate column in CUMM, the system would display following message at the bottom of the screen: “PAN/GIR number not found for this account number” In such case, insist the customer for quoting of PAN number. After obtaining the PAN number, capture the same against PAN/GIR number field through menu option CUMM in modify mode and verify modification. PANINQ menu option only enables to know if the customer requesting for purchase of demand draft, traveler cheque or for issuance of mail transfer / telegraphic transfer has furnished his PAN number and the same is available in the system. It does not restrict issuance of draft, traveler cheque, mail transfer or telegraphic transfer in case the PAN number of the customer is not available in the system. PAY ORDER—ISSUE AND PAYMENT Sr. NO ISSUE 01. 02. 03. 04

ACTION POINT

Issue of Pay Order Transaction Type

Always credit PO A/c (3161101) prefixed by sol id. T/CI or T/BI where pay order amount => Rs.50000/-

COMMISSION

Modify commission amt as displayed by the system, when required.

PRINTING

OF

PAY

ORDER


Initialize Ilinkweb before initiating print option. Ensure inventory is available at employee location initiating print option and printed serial number of PO as on the leaflet is same as is appearing on screen. If print is OK, press F10 followed by F3. If print is not OK, take 2nd print of the PO and move the PO earlier consumed to destroyed location through IMC.

[42]

06.

07.

S.NO

01. 02. 03. 04. 05. 06. 07. 08. 09. 10.

DDC to debit PO a/c to cancel PO issued after migration to Finacle. If PO is cancelled in cash, attach a cash receipt voucher for collecting cancellation charges alongwith the cash payment voucher. DDLOST option to mark PO as lost and DDD to issue a DUPLICATE ISSUE OF duplicate PO where date of issue is after the date of migration to Finacle. Pay order. Collect duplicate issue charges and prepare/print related voucher. CATEGORY ORIGINATING RESPONDING TRAN DESCRIPTION CODE TRANSACTIO TRANSACTIO TYPE N N ALLWD ALLOWED ALLOWED DD Demand Draft Credit Debit C/T TT Telegraphic Transfer Credit Debit C/T FEO FEO Tran Advice Credit Debit T BCADV BC/FOBC Realisation Credit Debit C/T Advice BPADV BP/BD Realisation Advice Credit Debit T CLADV Clg. Imprest Adjustment Credit Debit T Advice MISC Miscellaneous Advice Credit Debit T PRMDD Pre Migration DD Credit Debit T P/L Profit/Loss transfer to HO Both Credit & Both Credit & T Debit Debit UPLD Upload code for HO Both Credit & Both Credit & T balance Debit Debit CANCEL PAY ORDER

ISSUE OF DRAFTS ON CTS2010 FORMAT Following functionality is one time process Before issuing the draft through menu option user has to invoke the menu option . This menu option will select the type of inventory available with the branches. Type ‘A’ in the function field, the sol-id will be auto populated by the system. To make a selection, user needs to type NEW for printing the DD on CTS-2010 format or type OLD to print the DD on the non-CTS 2010 compatible (existing) format. Press F10 to commit , system will save the selection made. After selecting the proper inventory the user has to issue & print the draft using the menu options already available with them. The system will print the draft on the inventory type selected by the user till the user again executes the menu option DDCTS for changing the selection of inventory type. The user doesn’t needs to make the selection again at the time of printing of draft on next working day if the available inventory is same as selected by the user on the previous working day. However, if the inventory type is changed, user has to execute the menu option DDCTS again to select the available inventory. REMITTANCE OF FUNDS FOR VALUE RS.50,000/- AND ABOVE –ISSUANCE OF DEMAND DRAFT / CASH ORDER ETC.MECHANISM IN CBSFOR ISSUANCE OF DD THROUGH CASH


[43]

1.A check has been provided in the system to cease the issuance of DDs through Cash aggregating to or more than Rs. 50,000/- to the same purchaser on a given day. 2.The system performs the check based on the data entered in the field “Purchaser Name” while issuing a Demand Draft. 3. Some of the changes made are as under: i) While a DD is being issued through cash, the system will not allow to enter any spaces in between the characters in purchasers name. It will allow running character only. ii) While issuing multiple DDs to the same purchaser in a day, irrespective of the SOL (Service Outlet), the system will calculate the sum of amount of DDs already issued (if any) and the one to be issued and if the sum aggregates to or more than Rs. 50,000/- in a day, (including the current DD which is being issued) the system will not allow to issue the DD thro ugh cash. MIS on DD THROUGH CASH: a)

A report (DAYRPT 10/58) which will contain the record of DDs issued through cash on present day. The input to the report will be the purchaser name which was originally fed into TM menu while issuing the DD.

b)

For backdated data, report (PNBRPT 10/24) which will contain the record of DDs through cash on a given day. The input to the report will be the date and the purchaser name which was originally fed into the TM Menu while issuing the DD.

INLAND BILLS Bills are the integral part of the Banking Activities irrespective of the fact whether they are Inland Bills or Foreign Bills. The Bills can be classified in following two categories: i. Bills for Collection, whether clean or documentary, sight or usance, (where the lodger’s account is credited on realization of proceeds of bills) & ii. Bills for Purchase or Discounted, clean or documentary, sight or usance, (where the lodger’s account is credited before the realization of proceeds of bills) Further, the above mentioned bill types can be Outward or Inward. Finacle supports all types of bills mentioned above. The following activities relating to bills can be undertaken through Finacle. • • • • •

The The The The The

Bills Bills Bills Bills Bills

can can can can can

be be be be be

lodged for Collection/Purchase/Discounted. Purchased/Discounted subsequently, they are lodged. transferred from collection to purchase or vice versa. Realised, already sent for collection or purchased or discounted. marked protested, if the same has been returned unpaid.

As regards charging of commission, Bank/Other charges & Interest calculation (in case of purchase of Bills) is concerned, system automatically prepares the related transactions which can be modified in case of need. Various types of Bills Registers depending upon the type of bills have been defined in the system. While lodging a bills a user has to select a Register type and then sub register type under which the bill is to be lodged.


[44]

Using registers and sub registers user can handle Inward as well as Outward bills like Clean Bills (Cheques/DD), Documentary Bills, Sight or Usance. All Bills are required to be lodged and then depending upon the type of bills they can be purchased, discounted or negotiated. 1. Invoking the Option Type BM in the menu option field and press Enter, Press F2 to see the different functions that can be carried out through this menu option. The list will display the various functions that can be performed through this menu option. LODGE A BILL 1. Invoke menu option BM and press Enter key. 2. Enter Function. Select a function i.e. G for lodging a bill and press Tab key three times, the cursor will appear at the Reg. Type field. 3. Enter Register Type in which the bill is to be lodged. Or select the Register Type from the list which appears by pressing F2 and then press Shift+F4 key for selection. Here let us select Reg. Type as ODBC. Press Tab or Enter key to go on to next field i.e. Reg Sub Type. 4. Enter Reg Sub Type as DBILL or select the Reg. Sub Type from the list & Press F4 to go on to next block. 5. As soon as F4 key is pressed the cursor will go on to Lodger A/c field and system shall also display Bill id No. duly generated. If at this stage if Bill’s detail has not been entered and the user comes out of the screen this Bill id shall go waste. System shall generate a new Bill id no. if the user again starts to lodge the bill. Enter Lodger A/c number (in which the proceeds of the bill shall be credited on realization of ODBC) and press F11. The system shall display the customer id and the name of account holder and the cursor will appear at the Bill Amt. If the account number is not available or a new account shall be opened after realization of ODBC proceeds, then Lodger A/c field and next field can be left blank and in third field shown against the Lodger A/c, the name of the customer can be entered which the system shall accept. 6. Enter Bill Amt and press Tab to go on to the Date field. 7. Enter date of the bill being lodged and press Tab, the cursor will go on Drawee field. 8. Enter the drawee name in the last field and address in the fields provided and press Tab to go to the next field i.e. Coll. Br. 9. Coll. Br. This is the field where the Bank, Branch & Name of the Bank where the bill is being sent for collection is to be entered. Enter Bank’s Code as 024 for PNB, 001 for RBI, 002 for SBI etc. and Branch Distinctive Number of the branch where the bill is being sent for collection. The detail of the Bank Code & Branch Code can be selected from the list which is available by press F2. Further, if such detail is not available then the name of the bank can be entered in the last field. Press Tab and enter the Address of the collecting Bank, Branch. Press F4 to go to the field Drawer. 10. Generally, the drawer’s name shall be picked by the system from the Lodger A/c, but in case the drawer of the bill is different from the said account name then name & address of the drawer can be entered in the fields provided. Press Tab, the cursor will appear at the Lodger Ref. Field. 11. Enter Lodger Ref. i.e. customer reference number, if any, in the Lodger Ref. Field & press Tab to go on to the Field Carrier Code. 12. Enter Transporter Operator Code in Carrier Code field, from the list which can be seen by pressing F2. Carrier Code is the Goods Transport Co. Code, through which the drawer has sent the goods to the drawee. Press F6 to go on to next page & the cursor will appear at the field on Transit Period. 13. Transit Period: this is the normal transit period within which the proceeds should be realized if the period is more, then the same can be modified. Press Tab to go on to the next field i.e. Grace Period. 14. By default the grace period is given 3 days if the same is required to be modified that can be done. Press Tab to go on to the next field. 15. Tenor Desc is the field for displaying the usance period if the bill not otherwise payable than on demand, then sight is tenor which will appear here. Press Tab the cursor will move on to the


[45]

Due Date field. 16. Due Date is the date within which the bill should be realized. This is calculated on the basis of number of days of Transit Period plus Grace Period added to the Lodge Date. In case of Usance Bill this date shall be the date of tenor plus grace period. Press Tab to go on to the next field i.e. DC/DPG/Co-Acpt? 17. DC/DPG/Co-Acpt? This field is applicable in case the documents are presented under Documentary Credited of which the detail has been captured under IDCM in case of outward bill. In such case L can be entered for the documents presented under LC otherwise N is to remain. Press Tab for next field. 18. Bill Group Code: select the appropriate code from the list if the bill is Clean, Documentary, for ATM entries, Cheques for RCC. Press Tab to go on to next field. 19. Comm. Tbl. Code: Select the appropriate table code for charging the commission from the list which is available by pressing F2 Key & press Tab to go on to the next field TBR? 20. TBR? Enter Y if the bill is under Trade Bill Rediscounting scheme which is not relevant here. Press Tab to on to the field Non Pay/Acpt Dt. 21. Non Pay/Acpt Dt.: this field is applicable in case of usance bills only when the bill not accepted or has not been paid then the date of non acceptance or non payment is entered here under modification mode under the menu option BM only. Press Tab to go to the next field i.e. Invoice Dt. 22. Invoice Dt.: Enter the date of Invoice if submitted with the bill. Press Tab for the next field Transport Dt. 23. Transport Dt.: Enter the date of GR or RR i.e. the date on which the goods have been transported to the Drawee. Press F6 to go on to the next page, the cursor will appear at the Doc List Field. 24. Doc. List: Enter the detail of documents. If the documents are more which require more space to enter then Press Ctrl E the system will display 6 more lines to enter the detail. Press F4 and then Tab, the cursor will appear at OD Intr % field. 25. OD Intr.% : Enter OD interest chargeable to the party, if any. Press Tab, the cursor will appear at the next field i.e. Free Code 1 26. Free Code 1, 2 & 3 fields can be entered if applicable from the list available by pressing F2. Press Tab to go the field Rebate Date 27. Rebate Date enter the date upto which the rebate is to be allowed. Press Tab to go to Rebate % field. 28. Rebate % Enter the %of which the rebate is to be allowed. Press Tab to go to Rebate Amount Field. 29. Rebate Amount : Enter the amount if the rebate amount is absolute instead of percentage as explained in the previous field. Press Tab to go to Health Code field. 30. Health Code: Enter the applicable code from the list. The next two fields are not required to be entered in case of ODBC. Press F6 to come on to the first page of General Details of Bill. Press F4 to go to the Option Field. 31. Press F10 to commit & note down the Bill id no. in full. 32. Verify the Bill. VERIFICATION OF ODBC (BILL LODGED) Verification of Bill Lodged can also be done through the menu option BM by the user other than who has lodged it. 1. 2. 3. 4.

Invoke menu option BM. Enter V in the Function Field and press Tab 3 times to go to the Bill Id Field. Enter Bill Id number & Press F4, the cursor will appear at the Option Field as shown below. Enter M in the Option field and Press F4, the cursor will appear above the name of the Lodger A/c field. 5. Press F6 three times to visit the other screens of General Details of Bill & then Press F4 to come on to the Option field. Finally Press F10 to save/commit the verification. 6. Press F3 to come out of the BM screen.


[46]

LODGING OF CHEQUE IN ODBC To describe the procedure please look at the steps described above under the head HOW TO LODGE AN ODBC BILL above. The applicable steps have been described hereunder. Repeat steps 1,2,3 4. Enter Reg Sub Type as C-OTH or select the Reg. Sub Type from the list & Press F4 to go on to next block. 5. Follow the procedure as described at Step No. 5 above. However, in place of Bill amount we have to enter the Cheque Amount. 6. Repeat procedure as described at Step No. 6 however in place of Date of Bill, here it will be the date of cheque. 7. Repeat procedure as described at Step No. 7 above. 8. Repeat procedure as described at Step No. 8, however, in place of Drawee, the name shall be the Bank’s name on which the cheque is drawn. Follow the procedure as described at no. 9, 10, 11 under the head HOW TO LODGE AN ODBC BILL. 12. Field for Carrier Code. This is not applicable here. 13. Normal Transit Period in which the proceeds should be realized is displayed by the system. If required, this period can be changed. 24. Go to step no. 24 and enter the cheque no. and other details of cheque. 30. Press F6 to come on to the first page of General Detail & press F4 to come on to the Field. 31. & 32. Repeat steps. REALISATION OF ODBC BILL (Realisation proceeds received from our Bank’s Branch) For realizing a bill, we have to execute menu option BM. 1. Execute menu option BM. 2. Enter R in the Function field and Press Tab key three times or Press F4 once, the cursor will appear on Bill ID field. 3. Enter Bill ID of the bill to be realized & Press F4, a new screen will appear and the cursor will appear on the Tran Type field System by default will show the Bill Amount and Transaction Amount. Press Tab key 3 times to bring the cursor on the Other Bank Charge field. This field is applicable in case the proceeds have been received from other bank and they have deducted some charges, then the amount of charges can be entered here. This field is having (-) Minus Sign so System will automatically deduct charges, entered in this field, from the proceeds to be credited to the lodger’s account. Press Tab to go on the field Rebate. 4. Like Other Bank Charge, Rebate is also minus field, that means any amount entered here will be deducted from the proceeds of ODBC Bill to be credited to the Lodger’s Account. So if Rebate has been allowed to the Drawee of the Bill then that amount can be entered here. Press Tab key to go to OD Int Charged/Recd field. 5. In both the cases whether OD Int Charged or Received from the party’s party that will be an additional amount of bill. So system adds the amount charged/received on account of OD Interest. A Plus (+) sign is predefined before this field. Press Tab to go to the next field. 6. C Form Amount: Enter any amount received on account of non submission of C Form and in lieu there of some amount (as per drawer’s instructions) has been paid by the party’s party. This is a Plus field. Any amount entered in this field will be added to the Bills Amount. Press Tab to go to the next field. 7. Misc Amount: This is the field provided for the amount, if any, either less or more received then the Bill’s Amount, for any reason. Enter that amount which can be either added to the Bill’s Amount or deducted from the bill’s amount, by modifying the Minus or Plus Sign displayed in the field, as shown below, to be credited to the Lodger’s Account. Press F4, the system will display the transaction screen displaying the system generated


[47]

Transaction ID , as shown below: Note down this Transaction Id. 8. Enter L in the Option field and Press F4, the system shall display list of all the Part Trans it has generated Press F3 to come out of this page, the cursor will blink at Option Field. Press Down Arrow Key 9 times, the part tran screen will keep on changing and new screen for Debit part tran of Balance with Head Office (PNB) will appear. 9. Modify this part tran by inserting M in the Option Field and Press F4, the cursor will appear at the Account field. Mention here Non customer account where proceeds of the cheque has been parked i.e. 3171160 or 3171158 and press F4. 10. Enter S (for Additional Detail) in the Option Field and Press F4. The screen will show the amount of bill to be selected for reversal from office account number 3171160 or 3171158. Press shift+F4 on the appropriate correct amount for selection of the entry. 11 .Enter A in the Option Field for Accept & Quit, & Press F4. 12.The cursor will appear at the Option field of General Details of Bill. Press F10 to commit or save. 19.Verify this Realisation through other user. VERIFICATION OF BILL’S REALISATION 1. Execute menu option BM. 2. Enter V in Function Field and Press F4 once or Tab key 3 times the cursor will appear at BILL ID field. 3. Enter Bill Id . Of the bill REALISATION OF which is to be verified and Press F4 . All the particulars entered in General Detail of the bill will appear and cursor will appear at the Option Field. 4. Enter R in Option Field and Press F4, the system shall display the screen of Transaction Type and Bill Amount, Transaction Amt, Charges etc. Press F4 again the Transaction Part Tran screen will appear and cursor at the Option Field. If you want to visit all the part trans then press down arrow key and go to next part tran. Keep on doing that the user can visit all the part trans. Also he can see the list of transactions on entering L in the Option field and by pressing F4. 5. Having seen all the part trans the user can Accept the transactions by inserting A in the Option Field and pressing F4, the system shall display the cursor in the Option Field on the First Screen of General Details of Bill. 6. Press F10, to commit. The Bill stands verified. NOTE: THE SYSTEM SHALL NOT POST THE TRANSACTION IN CASE IT ENCOUNTERS ANY EXCEPTION IN THE ACCOUNT IN SUCH SCENERIO THE LODGERS ACCOUNT WILL NOT BE POSTED WITH THE PROCEEDS OF THE BILL. LODGE MASS INLAND BILLS (Outward or Inward) 1. Menu option BM function G Mass flag ‘Y’ 2. Choose the right Register Type and sub-type Note Mass-ID & First Bill-ID 3. Enter lodger a/c for first bill – F11. Enter Bill Amount, Date, Drawee details & collecting Bank Branch details, carrier code, documents list & other relevant field on the 3 pages & press F4 to come to Option Block. 4.Press Down Arrow – Note next Bill ID, Option M-F4 enter details of the next bill. 5. Repeat the process till all bills are lodged in the register 6. Press F10 to commit. VERIFY MASS INLAND BILL ( Outward or Inward) 1. Menu Option BM Function –V Enter Mass –ID, Register Type, Sub-Type, Press F4 2. Choose Option M & Press F4, visit all 3 pages with F6 to view first Bill Press F4 3. Down-Arrow and Repeat Process till all bills are verified 4. Press F10 to commit.


[48]

PURCHASE SINGLE INLAND BILLS (Odd) 1. First lodge the bills with BM-G using Register Type as ODD and proper sub-type (BILLS, CHEQUES, INSCR/LDD) 2. A Bill lodged in ODBC can be purchased only after transferring it to ODD Register-type (BM-T) 3. After lodging the bill, enter function –P and press F4 to purchase the Bill 4. Enter Margin percentage to be kept in Sundry-Margin Money A/C if any & press F4. System Will create Transaction Note Tran_ID 5. Option L- Press F4 to view all transactions, Press F3 to be back 6. If desired, modify the generated transaction for charges with Down-Arrow and M option 7. Press F10 to commit. REALISE / DISHONOUR SINGLE INLAND BILL (Outward or Inward) 1. 2. 3. 4. 5. 6. 7.

Menu Option BM Function R/N Enter Bill ID and Press F4 Enter other Bank charges, if any or modify any other applicable charges and Press F4 System shall create Transaction Note Tran –ID Option L, Press F4 to view all transactions, Press F3 to go back If required, modify the generated transaction for charges with Down-Arrow and M option to Accept Transactions and Quit enter Option A Press F4 If non customer account is involved press ‘S’ in option and Press F4 to select / dselect the record 8. Option ‘A’ F4 to accept and quit 9. Press F10 to commit. VERIFY PURCHASE / REALISATION / DISHONOUR OF SINGLE INLAND BILL 1. 2. 3. 4.

Menu Option BM function V Enter Bill ID and Press F4 Option P/R/N-F4 to verify purchase/Realization/ Dishonour of bill Option L- Press F4 to view all transactions, Press F3 to go back If Non customer account is involved use Option ‘S’ and press F4 to view additional Details 5. Press F10 to commit 6. Verify transaction status in TM. REALISE / DISHONOUR MASS INLAND BILLS ( OUTWARD / INWARD) 1. 2. 3. 4.

Menu option BM function R/N Mass flag ‘Y’ Register type, sub type press F4 Enter selection criteria to pick up outstanding bills. Press F4 Select Bill(s) to be realized ®.Dishonored (N) and shift F4 Press F4 Enter Option R/N-F4 to enter realization / dishonor details for first selected bill. Enter other bank Charges, if any or modify an y other applicable charges & press F4 5. System will create Transaction Note Tran-ID 6. Enter Option –L Press F4 to view all transactions, Press F3 to be back 7. If required, modify the generated transactions for charges with Down-Arrow & M option 8. Enter option A Press F4 to accept transactions and quit 9. If non customer account is involved use option ‘S’ and press F4 to select entries 10. Press F10 to commit. BILL TRANSFER FROM COLLECTION TO PURCHASE When a bill is sent for collection and later on request of the customer that it is to be purchased, the bill is required to be transferred from the existing register to the purchase register: 1. Invoke function T in BM menu option 2. Enter bill ID the bill to be purchased and F4 3. The purchase screen is displayed by default the system shows margin as 100% and entire amount of the bill in the margin field which can be modified if desired.


[49]

4. ON acceptance and commit the bill is purchased and transferred and a new number is allotted to the bill as purchase type 5. The process require verification. TALLYING OF BALANCES OF BILLS (1) BILLS FOR COLLECTION 1. Generate the report for all register types and sub register types through menu option BRCR (Balance report collection) 2. This report should be tallied with GL figures. 3. GL balances can be generated through menu option ACLI by giving account no. (say For ODBC- 3231201 etc.) 4. If there is any difference the same should be located through menu option PARTINQ/ PHINQ 5. The system displays bill wise debit and credit entries. (2) BILLS PURCHASED AND DISCOUNTED. 1. Generate report through menu option BRBPR 2. This report should be tallied with GL balances generated through BR. In case of any difference bills purchased under office accounts can be checked through menu option PHINQ. 3. For bills purchased under customer bill purchase account the individual bill entry can be Enquired ACLI by giving the relevant customer’s bill purchase account. BILLS MENU OPTIONS AT A GLANCE DESCRIPTIONS

OPTION BM BICN BRV

Bills Maintenance Bills Interest Calculation (non bill by bill) Bills Reversal i) To reverse the status of the bill , in case a wrong bill is selected for further processes to lodging and verification is also over. ii) If the bill has undergone more than one process, then also the status can be brought back to lodge process and then it can be even cancelled. BMCM Bill Message Code Maintenance BIDUMP Bill Dump MENU OPTIONS FOR SCHEDULES / REPORTS OPTION

DESCRIPTION

BCSI BCSO INWBI NPA BDTR BDR LCDDR BICR IPDCR BRRBPR

Bills / Cheques Covering schedule – Inter Branch Bills / Cheques covering schedule - Inter Bank Inward Bill Intimation Non – Payment Advice Bill due today but unpaid Bills pending or dishonoured bills Large amount cheques discounted Bills interest collected report Interest paid on Delayed collection of cheques Bill Register Report – Bills Purchased


[50]

BRCR BRBPR BRRCR LCDMR BP UBDTR LBDR IBADVP BIAIL BICS BIID BIIDU BINAL BINRD BIPAD BIRAL BIRCL BIRPC CHCS

Balancing Report – Collection Balancing Report – Bills Purchased Bills Register Report – Collection LargeAmt Cheque discounted – Monthly reporting Bills Printing Usance Bill Discounted Report Local bill Discounting Report Advice generation for Inland Bill Acceptance Intimation to Lodging Branch Bill Collection Schedule Bill Intimation to drawee Bill Intimation to Drawee (Usance Bill) Non Payment Advice to Lodging branch Non Payment Reminder to Drawee Payment Advice to Drawee Realisation Advice to Lodging Branches Bill Return Covering Letter Realisation Proceeds covering letter Cheques Collection Schedule

INQUIRIES RELATING TO BILLS OPTIONS

DESCRIPTION All events that happen on a bill are stored in the system and is available for BEHI enquiry at any point of time and can be viewed by giving a Bill Id. Enter ‘E’ or ‘C’ Bills Events and do an explode - to view transaction details for a particular event or History Inquiry contingent liability transaction

BLRTI

To inquire on any of the bills lodged in the system. Press Enter in the output screen to view next screen. User can go to Bill Maintenance screen in Inquiry mode by using Explode. Bill Register Type Inquiry : For parameter inquiry of registers

BPMI

Bills Parameter Master Inquiry

BI Bills Inquiry

FI

Fate Inquiry

GENERATION OF FORWARDING SCHEDULE FOR BILLS/CHEQUES LODGED UNDER ODBC, OUBC AND ODD DURING THE DAY.

A customized report in menu option 'DAYRPT'-8 (Inland Bills Report) is available:-17. 18.

Forwarding of ODBC OUBC - lodged during the day Forwarding Schedule For ODD - lodged during the day, which generates the forwarding schedule for bills/cheques, lodged under ODBC, OUBC and ODD during the day.


[51]

TERM DEPOSIT A/C - FLOW CHART TO OPEN STEP 1 2 3 4

5 6 7 8 9 10

11 12 13 14 15 16 17

18

OPENING OF FD/RD ACCOUNT - STEP BY STEP GUIDE Write OAAC at menu option and press enter At Customer ID field type Customer ID for which a/c will be opened, press At Scheme Code type appropriate code and Press F4 At Function type "O" if it is a new a/c or "R" if this is to be opened for renewal or "T" if this a/c is transferred from some other branch. If "R" is given at function press TAB and at A/c No. type the previous a/c to be renewed else Press F4. Mode of Operation: Press F2 and select appropriate one by Shift+F4, press Location Code: Press F2 and select appropriate one by Shift+F4, press F6 If any preferential interest (like additional interest to Senior Citizen or Staff be given) mention it at the field : Account Pref. Interest (Cr) then press F6 to go to next page At this page enter contact phone no. if any, then press F4 The cursor will be at option: Change G to "S" for scheme details and press F4 Enter Principal Amount of FDR (Monthly Installment for RD) and press TAB. Enter Period in Months/Days and press TAB. At value date it is automatically today's date. If any back-date effect is to be given, it can be given here press If nomination is to be regd. go to "Availing Nomination Facility?" and change it to "Y" and then press F4, Change the Option "S" to "N" and press F4 Nominee Name: Type Name of the Nominee, then address etc. and then press F4 If it is a joint a/c or a partnership a/c or Company A/c then change the option to "A" and press F4 to allow you to enter the joint a/c holder's name or authorised signatory's name Press down arrow key to enter the 2nd and subsequent names, then press F4 At option change it to "F" and press F4. Press Explode (Ctrl+E) to see the details of flow of interest. Press F4 twice. If it is a interest is to be paid at regular intervals to his SF or any other a/c, change the option to "C" and press F4. Now it will allow you to enter the a/c number to be credited at regular intervals. Lastly press F4 to come to the option block. Now at the option block press F10, the account number will be displayed.

FLOW CHART FOR VERIFICATION OF A/C OPENING STEPS 1 2 3 4 5 6 7 8

INVOKE MENU OPTION OAACAU AND PRESS At function Block type "V" and press and enter the A/c No. to be verified, F4 Press F11 to visit next pages and at the 3rd page Press F4 Change the option to "S" and Press F4, see the values entered and again press F4 Change the option to "N" and Press F4, see the values entered and again press F4 Change option to "A" (for joint a/c or partnership etc. a/c only) and Press F4, again press F4 Change the option to "F" press F4, see the values entered and then F4 twice. Change the option to "C" and press F4. Check the values entered then press F3 Press F10 finally. If the system displays any warning / exception, accept them by pressing F4. The a/c is verified. Press F3 to come back to main menu.

TERM DEPOSIT RELATED MENU OPTIONS AT A GLANCE MENU OPTIONS

PURPOSE

CUMM

CREATE CUSTOMER MASTER

OAAC

OPENING OF AN ACCOUNT

OAACAU

VERIFICATION OF AN ACCOUNT


[52]

TM

TRANSACTION MAINTAINENCE

DRP

DEPOSITS RECEIPT PRINT

INTRUN

DEPOSITS INTEREST CALCULATION

TDSCALC

TDS CALCULATION

HTDSIP

ISSUE OF TDS CERTIFICATE

RMTDS

REMITTANCE OF TDS

RFTDS

REFUND OF TDS

CAAC

CLOSING OF AN ACCOUNT

CAACAU

VERIFICATION OF AN ACCOUNT

ACM

ACCOUNT MAINTENANCE

ACDET

ACCOUNT BALANCE DETAILS

DN

DUE NOTICE

DUDRP

DEPOSITS RECEIPT PRINT [DUPLICATE]

FDOCD

FIXED DEPOSITS OPENING CLOSURE DETAILS

MDD

MATURITY PERIOD WISE LIST OF DEPOSITS

TDRCL

TD RENEWAL CONFIRMATION LETTER

HTDSPROJ

CRV OPTION FOR PROJECTED TDS

REDRP

REPRINT DEPOSITS RECEIPT

RELACI

RELATED ACCOUNTS LOOKUP FOR DEPOSITS

SDD

SCHEME WISE DISTRIBUTION OF DEPOSITS

TDEXT

EXTENSION OF TERM DEPOSIT

FOAAC

OPENING OF FLEXI RD

TDREN

RENEWAL OF TDS

TDCLS

CLOSURE OF TDS - WORK FLOW

PRFUPD

CORRECTION OF PREFERENCE INTEREST IN TD

RENEWAL OF MATURED FIXED DEPOSIT ACCOUNT MENU OPTION 'TDREN' • Renewal of Account with the same Account id • Simple interface for Renewal of an a/c Automatic Account Renewal - Maturity Amount, Principal amount, Fixed amount, Interest, Maturity amount + Additional amount, Residual amount remaining after taking care of customer instructions • Default population of TD a/c data to the renewed a/c during renewal • Auto Renewal grace period • A new Flow RF has been introduced for specifying Renewal instructions • Renewal history inquiry through multiple menus ACM/ACI – 8/ CRV/ RENHIST • Facility for printing Renewal Confirmation letter for renewals TDRCL.


[53]

•

In case it is required to issue a fresh FDR, the user will use menu option ACM(S) and make the print flag as ‘Y’. After verification of ACM a fresh FDR can be issued using DRP.

Renewal of TD a/c in the same currency – Same account id is retained. Each renewal is assigned with a unique serial number. The maximum number of renewals under the same account number is 999. Renewal parameters captured at the scheme level gets defaulted to the account which can be changed during tenure of the deposit. Renewal can be made for the M - Maturity value, F-Fixed amount, P -Principal component only, IInterest component only, A- Additional amount +Maturity value. A new column ‘Renewal Option’ has been introduced to capture the appropriate value for this in the scheme details of the account. This column is also available in the TDREN menu. A new column ‘Source for Additional Amount’ has been introduced to capture at the A/c level in Scheme details/TDREN menu to specify the funding account for Additional amount. In case of Renewal for (Maturity value + additional amount) or Fixed amount (less than the amount required for renewal), the funding for the differential amount can be through an operative account/cash. Renewal confirmation letter can be printed in lieu of Deposit receipt online or using TDRCL menu. A new column ‘Print Renewal Confirmation’ has been introduced for the user to specify the option for immediate print/printing later. Renewal Grace period can be specified. (i.e., batch renewal should consider the accounts for renewal after completion of grace period specified at the scheme level. For instance, if the deposit matures on 31st May 2005 and the scheme level grace period is 5 days, then the deposit will be considered for Auto renewal during batch process on 6th June 2005. During the grace period the customer has an option to close the deposit. For renewals with additional amount and fixed amount which is greater than the maturity value for the account, it is mandatory to enter the source (Funding) account for the additional funds If the renewal is for the maturity value and there are no payment instructions, lien regularisation or TDS shortfall recovery then no transaction will be created during renewal process. However, as part of maturity renewal if the GL sub head changes, then transaction will be created for the GL subhead effect The history record of the original account will have: o Part closure history, Transaction history, A/c open date, Open effective date, Date of closure, Maturity date, Interest Table code, Original deposit period, Original deposit amount, maturity amount, Renewal option, Amount of Overdue interest paid, Interest amount, TDS amount, Tran id & tran date of Renewal transaction, additional amount added/Fixed amount renewed from this account, the scheme under which the account is renewed. During renewal under a different scheme code, the following values are default populated from the new scheme: Int Paid, Int coll, Serv Chrgs, account turnover details, deposit type, and value for ‘break in steps of’ defaulted from the new scheme The W/tax percent is defaulted from the customer master, The values for the following fields are defaulted from the original account. • • • • • • • • • • • • •

Allow_Sweeps flag Acct Location Code Emp Id rpt code short name name mode of operation Sector Code chrg level Code nomination details w/tax flag Native language details Freeze Code


•

• • • • • • • • •

interest on TDS reqd ? = (if SRGPM flg = 'Y' then 'Y' else copy from orig a/c) spl category indicator. close on maturity flag. Repayment A/c. Print Nominee flag. Print Deposit Receipt flg. interest accrual Regularize overdraft during trf to OD a/c. Cash/Transfer/Clearing Limits auto renew flg, auto scheme code,

[54]

• • • •

Freeze Reason Code last freeze Date Last unfreeze Date Balance as on freeze date

auto renew gl subhead, auto renew int table code.

In the Renewed A/c. the Auto Renew option will be set to M – Maturity value renewal Batch renewal of TD accounts is enabled through TDBATCH option 1. Automatic Renewal. This will consider those accounts for which auto renewal is enabled The Renewal related parameters can be specified under Scheme Details tab of OAAC and ACM. During auto renewal, if the specified renewal option could not be executed due to insufficient funds or lien on the TD account, then renewal will happen for the net maturity value. For all renewal failures, the system generates a failure report. Only T & R type of Deposits can be renewed. Notice Deposits and Certificate of Deposits cannot be renewed Deposits cannot be renewed under ‘R’ type of deposit schemes, All operations on the account should be up to date including interest and TDS calculations, The renewal transactions are created during verification process. Hence, during online renewal if sufficient funds are not available in the source account during verification , the renewal will fail. In case of batch mode, if sufficient funds are not available the renewal will fail and a failure report with reason for failure will be generated In case of Fixed Amount Renewal, the shortfall amount, if any will be taken from the funding account and hence mandatory in such cases. There is no validation on the Renewal Deposit amount. In case of Maturity amount renewal, if there are no Payment instructions, lien regularisation or TDS/shortfall recovery no transactions will be created. TDREN can be processed for a single account at any time. As part of renewal it is possible to renew confirmation letter or defer it for printing later. As a consequence of this, the Renew function – R has been De Supported in Account opening and Account closure menus. HANDLING PREFERENTIAL INTEREST ( CR) IN TERM DEPOSIT ACCOUNTS. (ITD CBS 77/2013) As per new process, the system will check the eligibility of additional interest for Sr. citizen, Staff, Army/Navy/ air force group Insurance customers on the basis of customer data entered in the system and appropriate interest table code will be automatically populated while opening the term deposit account and branch user will not be able to enter any account preferential at the time of account opening/modification in the account For new term deposit account while opening new term deposit account, interest table code will be automatically populated in the system as described hereunder S. No. 1

Cases for Interest Fixed deposit Citizen

additional

Eligibility for additional interest

for

Appropriate interest table code for Sr.Citizen customers will be automatically populated on the basis of date of birth entered in customer master and the customer type as . Appropriate interest table code for staff schemes will be populated automatically on the basis of employee id in customer master.

Senior

2

Fixed deposit account for Staff Members

3

Fixed deposit accounts for Staff and Sr.Citizen

4

Additional interest for Army/Navy/ air force group


Appropriate interest table code for staff + Sr.Citizen will be automatically populated on the basis of date of birth entered in customer master and employee id in the customer master. Appropriate interest table code for Army/Navy/air force group Insurance accounts will be automatically populated on the

[55]

Insurance accounts

basis of respective code (AFGIS,ARGID, NAGIF) entered in remarks column while opening the account.

Ensure correctness of customer data entered in the system ( Date of Birth, Customer Type, Employee Id, Army/Navy/Air Force Insurance Group code) For existing Term Deposit Accounts The existing account will have interest preferential till its maturity date. Necessary modifications have been done in the system so that on maturity, at the time of auto renewal, interest rate codes of all these accounts will be modified/updated automatically as per the new created interest table codes before the renewal of the accounts and on the date of renewal the account preferential will be made Nil by the system. The modification / updation of newly created interest table codes in these accounts at the time of autorenewal will be based on customer profile i.e. whether the account is of Senior citizen, Staff, Staff in Sr. citizen category, Army/Navy/ air force group etc. (as eligibility criteria described above for new accounts) PROCEDURE FOR CORRECTION OF PREFERENTIAL INTEREST FOR TERM DEPOSIT A/C_- MENU OPTION – PRFUPD To facilitate the correction of preferential rate codes and interest to be given to the senior citizen and staff members, a new menu option PRFUPD has been customized in the CBS system. Detailed process is illustrated hereunder: 1. User has to enter menu option PRFUPD. 2. User has to enter the account number for which the preferential interest is to be corrected. After pressing F4, the system shall make the necessary modifications as per the category of customer, and the correct interest table code and the preferential interest shall be corrected as per the guidelines. For the accounts where the interest table code, and preferential shall be corrected from open effective date, a message shall pop up on the screen confirming that the INTTM has been modified and advising the user to verify the INTTM for the account. INTTM must be verified for the account For the accounts where change in the new interest table code as per the applicability shall be applicable after renewal, the system shall pass a message on the screen “Run PRFUPD after renewal of account”. For such accounts, the menu option PRFUPD must be run again after their renewal. At the time of ABH, the system will force the user to run PRFUPD for correcting the Intt table code and preferential. (ITD CBS 55/2014 dated 30.09.2014) TD RENEWAL CONFIRMATION LETTERS – 'TDRCL' TDRCL menu option is introduced to bulk print Renewal Confirmation letters. It will print Renewal confirmation letters only for accounts where the “Print Renewal Confirmation Letter” is chosen as L – Later. As part of this process, a hard copy can be generated. The Renewal date range is mandatory. All accounts that were initiated for renewal (Renewal BOD date) during the specified period will be processed. The Renewal confirmation letter can be generated for the accounts belonging to a SOL . Selection criteria available are Customer id, Currency code, range of Scheme codes, GL Subhead codes, Account range, date of renewal.


[56]

AUTO RENEWAL The new scheme has the facility by which, the customer can opt for the auto renewal facility in the account. For enabling the auto renewal facility, after the original account has been opened and Deposit Receipt printed, invoke ACM (M) mode, sub option S (Scheme details) and fill the following details: Print Receipt flag : N,  Press F6 from here and fill in the following particulars  U (Unlimited) ; N (No auto Renewal) Here select U (Unlimited option), which will auto renew the FD for unlimited number of times. If customer does not want auto renewal here select ‘N’ only. Max Renewal Allowed: This field will be applicable when Limited Auto Renewal option is being used. Here user can mentioned number of times auto renewal desired. In the field “Max Renewal Allowed / Done”, the max Renewal Allowed figure displays the number of times Renewal is allowed whereas Done field gives the number of times the FD has been renewed. Here, if the customers demand an auto renewal facility for limited no of times, fill in the number of times the auto renewal facility is required. If customer desires renewal option with principal + Interest mention ‘M’ and if customer desires auto renewal with Principal amount mention ‘P’. Renewal scheme code: Valid term deposit scheme code. Renewal GL Subhead code: 10100 Renewal Period: Mention renewal period for which customer desires Auto renewal Renewal Intt. Table code: TDGEN On pressing F4, the system will give a warning that the default scheme parameters have been changed. On the maturity date, the system will execute a batch job, which will renew the account automatically. As per guidelines, in case of Auto Renewal, no fresh FDR will be issued but a communication will be sent to the customer informing him about the details of the renewed FD. DAMODARANCOMMITTEE RECOMMENDATIONS-AUTORENEWAL OF TERM DEPOSIT (1)

(2)

(3)

(4) (5)

Where customer does not opt for auto renewal of FDR in the account opening form: If customer does not opt for auto-renewal of FDR, user has to enter (N) in the field auto-renewal in scheme detail on second page. Where customer Opt for renewal of FDR for Principal and Interest amount only: If customer opt for auto-renewal of FDR for both principal and interest, user has to enter (MMaturity value) in the field renewal option in scheme detail on second page and U in the field Auto-renewal. Where customer Opt for renewal of FDR for Principal amount only: If customer opt for renewal of FDR for principal amount only than user has to enter (P- Principal only) in the field renewal option in the scheme detail. Period for which Auto Renewal required(Months/Days): Period of which auto-renewal can be defined in the field renewal period in scheme detail. Number of times renewal required: The same can be entered in the field Max renewal allowed in scheme.

PREMATURE RENEWAL (EXTENSION) The extension of the existing account can be done using the menu OAAC (E) mode. In extension, the system will close the original account and open a new account. The extension shall be done from the BOD date and not with any retrospective date. EXTENSION OF DEPOSITS – 'TDEXT' Currently, the Extension of Deposit is being handled by premature closure of the existing deposit a/c without penalty and opening the account in Extension mode.


[57]

This process has been simplified through a new menu TDEXT. All other existing validations for extension continues Additional amount can be added during extension of deposits. Funding account of this additional amount can be in any currency. If the currency of funding code is different from the account currency, then rate code has to be specified. The scheme code and the interest table code can be changed during extension of deposits, As a consequence of this new functionality, the Extension Functions which are hither to available in Account opening (OAAC) and Account closure (CAAC) have been De Supported. The transaction relating to Extension of deposits is made during verification process. LIMITATIONS If the extended deposit is closed before maturity date of original deposit, interest penal interest is calculated only for the run period of the extended deposit and not from the open effective date of the original account. If TDS calculation is pending for the account it cannot be extended. PART CLOSURE OF TERM DEPOSIT Spectrum deposit scheme provides for part closure of the FDR opened under the maturity option (FDMPB, FDMSB, FDSUP, FDSUS) in the multiples of Rs. 1000/-. In case a customer demands the part payment of FDR, use CAAC menu and give the amount (in the multiple of Rs. 1000/-) that needs to be withdrawn in the amount field. The process will generate a report giving the details of the transaction and the interest applied on the amount part withdrawn. The process needs verification by an authorized official. In case part closure is sought for a deposit against which loan/OD has been provided. In such case shall first delete the SRM, make the part closure and recreate the SRM for the balance amount. The DP in the related Loan / OD account may also be suitably modified CREDIT OF MATURITY PROCEEDS AS PER MANDATE – AUTO CLOSURE OF FDR 1) 2) 3) 4)

Specify the ‘Repayment A/c. ID’ i.e customer account to which the proceeds Of FDR are to be credited on maturity while entering data in OAAC/ACM option(S) Set ‘Auto Closure’ flag to Y in scheme detail( 2nd page) in OAAC/ACM option(S) Modify ‘Auto-renewal flag’ as (N) in scheme detail (2nd page)in OAAC/ACM option(S) Run option 2 & 3 of menu option TDBATCH daily at any time without entering the account no.

System will automatically credit the proceeds of FDR on maturity date to the operative with the above mentioned steps.

account

DEPOSIT RECEIPT PRINTING The Deposit receipt will be printed on a new format. As such the person who is printing the deposit receipt shall ensure that the inventory related to deposit receipt has been transferred to the said user. DEPOSIT RECEIPT PRINTING - PROCESS Ensure Ilinkweb is running and security forms have been transferred print the Receipts, Menu – DRP. Enter Selection Criteria for FDRs to be printed and press F4. System displays all records in select mode. Deselect a record with Shift-F4, which is not to be printed. Press explode to see more details. Otherwise, press F4 to go to print parameter screen. The system will show the field Dr Print Ind? Default is S for system. (Replace M with S ). Press F4 again.


[58]

After printing of receipt, system seeks confirmation – Whether Print OK? Default value is ‘Y’. If yes, press F10. Else enter ‘D’ (destroyed) and/or ‘P’ (print again) and press F10. ‘D’ moves the used inventory to the destroyed location (not working at present) and makes available the next inventory for printing. ‘P’ is used to print again. ‘REDRP’ to Re-print and DUDRP to print duplicate receipt. CORRECTION OF TDS RATE CODE AND PAN NUMBER To ease the capturing of correct TDS rate code and PAN Number for the Customer Ids where no TDS Rate code is present or TDS rate code is present as TDSGE but pan number if blank a new menu option “TDSCODE” has been customized. List of customer Ids identified for the following cases: a) Customer Ids where PAN No. Is blank but TDS Rate Code is filled as TDSGE b) Customer Ids where both PAN No. & TDS Rate code are blank. Process to use this menu: 1) 2) 3) 4) 5)

Enter menu option TDSCODE System will display first record on the above identification criteria Customer ID (Protected) OLD TDS rate code – Already present in the system or blank, if not present New TDS Code – default it will appear as ‘TDSPN’ (Branch user has to enter correct TDS rate code and PAN Number otherwise same should be entered as ‘TDSPN’

Case 1 - If customer has not provided PAN Number then TDS Rate code =TDSPN Case 2 – If PAN Number has been provided than appropriate TDS rate code should be entered. 6) PAN/TAN Number : PAN Number or TAN Number of customer be captured. 7) Update = Y List of valid TDS Rate code TDS RATE CODE TDSCF TDSCR TDSF1 TDSGE TDSPN TDSZR TDNRC TDNRF TDNRS TDSNR

TDS RATE CODE DESCRIPTION TDS Cooperative society TDS Corporate body TDS – Firm TDS on resident individual /HUF/BOI/AOP TDS no pan card NO TDS deduction without PAN Number TDS Non resident Non domestic company TDS Non resident firm TDS Non resident cooperative society TDS on Non resident individual/HUF/BOI/AOP

TDS CALCULATION Menu-TDSCALCEnter a/c no. in BOTH ‘Account No. From’ & ‘Account No. To’ fields ‘N’ in Adhoc Run field. Report To is a mandatory field. Press F4. Enter ‘F’ in the Foreground/Background Menu, ‘N’ in ‘Print Required’. Press F10. Menu - PR. Type ‘T’ in option block and press F10. Note Tran-id. Type ‘Q’ to quit and press F4. Check with TM, whether TDS transaction has been posted successfully. Check TDS success/failure report in PR or DAYRPT 4-12.


[59]

CLOSURE OF A/C Menu CAAC-Enter Account no. & press F4. System should show ‘Intt Calculation up-to-date.’ Press F4 twice. Give the repayment account number if not already given and Press F10 to commit Closure Transaction Creation will now happen during verification of closure instead of closure itself. Verify Closure of a FD/RD ACCOUNT: Menu CAACAU- Enter Account no. Closed with CAAC & press F4 twice & Press F10. CLOSURE OF TERM DEPOSIT A/Cs - SOME POINTS The Potential Closure Transactions can be viewed during both Trial Closure and Closure on the last page of the screen displayed after committing the Closure. The transactions will consist of the Interest, TDS, Booking and Closure Part trans. including CI (Customer Instruction) payment distribution. This replaces the “Repayment Acct/Amt “ field literal which displayed CI payment distribution. A new field "Use Repayment A/c Only" has been added in the application. The value ‘Y’ for this field indicates that the Customer Instruction should be ignored and entire maturity proceeds after any lien/TDS/penalty recovery should be paid into the repayment a/c. If this field is ‘N’ then customer instruction, if any will be paid out first and the rest would go to the repayment a/c or sundry a/c. The Closure report will display the Actual Tran Ids only during Verification. If Interest/TDS is up to date then no Tran Ids will be displayed in the report. System verification of Closure which marks the “A/c Closed” flag of a/cs with Zero balance and all transactions posted to “Z” for closed. The literals “Penalty for Full Period?” is removed. The penalty during pre-part closure will always be for the full period. Whenever any interest is credited to the account either at the time of renewal or closure, total amount is credited to “Sundry before TDS” ac. After verification of Renewal/closure first run TDSCALC. It will check the TDS and then credit the proceeds to the specified account. Transactions during INTRUN and TDSCALC INTRUN = DR–Intt Accrued on Term deposit Etc.CR–Sundry before TDS – (3171118) TDSCALC = Dr-Sundry Before TDS.; Cr – Sundry TDS (3171108) Cr.- MBFD/SF TDS HANDLING IN FINACLE In Finacle, TDS deduction is automatic. All FD Accounts with common customer-ID, are clubbed Branch-wise to compute TDS eligibility. Deducted TDS for every account is credited in ‘Sundry-TDS’ Account and only net interest is credited to FD accounts. INQUIRE ON DEDUCTED TDS Menu-ACM, Function-I, Option-2. System will show record for TDS deducted, if any. Explode (CtrlE) to see complete Transaction in TM. For TDS details of previous years use Menu option IARM A new sub-option “I” has been introduced in the menu option “CUMM” which gives the Customer level TDS details – which was available only at the account opening level sub-option “2”. Also Available In CRV ( Customer Relationship View) TDS DEDUCTION WITH PAN OR NO PAN Two tax slabs have been created. 1) TDSPN for customers who have not submitted the PAN NO. 2) TDSGE for customer where PAN no. has been submitted. 3) On receiving the PAN No. the same may be entered on the 4th page of CUMM in the field PAN/GIR No, system will automatically modify the tax slab from TDSPN to TDSGE.


[60]

4) System will not allow to enter 15G/15H in the field tax exemption date in case where tax slab is TDSPN. 5) If a customer submits the PAN No. in between the financial year the system will recalculate the TDS already deducted at higher rate and the future TDS will be appropriated accordingly. AUTOMATIC-GENERATION OF FORM 15H/G WITH PARTICULAR FROM CBS Functionality has been developed in CBS to generate15H/G as under: Menu option: PNBRPT Option: 4 (TERM DEPOSIT REPORTS) Sub option: 43 (Download 15-G Form) 44 (Download 15-H Form) Enter: Cust_id Enter: Financial year: Enter start date: e.g. 01/04/2013 Enter end date : e.g. 31/03/2014 System will show Form 15H/G in menu option : PR The same can be printed for necessary action. REFUND THE DEDUCTED TDS Menu-RFTDS-Enter criteria for selecting accounts for refund of TDS, Transaction type and Press F4. System will display the records in ‘Select’ mode for refund. De-select the a/c with Shift-F4 for which refund is not intended. Enter the SB A/C no in ‘TDS Operative A/c’ field for credit of refund amount. Press F10. Note the transaction Id for further action. ALLOWING REFUND OF TDS IN OFFICE A/C By using the above option, the system generates a transaction debiting the Sundry-TDS account and crediting the operative account of the customer. It was necessary to mention operative account of the customer in case refund of TDS is sought. Finacle now supports refund of TDS (RFTDS) in Office A/c also. It can be made use of where Depositor do not have a savings account and Cash Refund cannot be made. For the purpose a new office account 31711332 - SUNDRY FD - REFUNDED TDS A/c opened. This account number can be used during the execution of menu option RFTDS. REMIT THE DEDUCTED TDS Menu-RMTDS-Select criteria for remitting TDS and go to “Remit Option (G/C) field and select “G”The system generates a report about the remittance to be done for the selected records. “C”- The system will accept a field as “Common Remittance Details”. This field is free text. Enter all information, which needs to store regarding remittance (like challan no., remittance date etc.) separated by a delimiter. Press F10. System will generate remittance report with Customer-wise TDS Details & Totals. To remit TDS, use Menu TM to debit the ‘Sundry-TDS’ A/c - 3171106 & issue Cash Order. PRINT TDS CERTIFICATES. Menu-HTDSIP-Enter criteria for selecting customers/accounts for inquiry on TDS or printing of appropriate certificates, Choose the relevant option from 1-8 & Press F4.


[61]

OVERDUE FD ACCOUNTS In Finacle, transfer of accounts to overdue category happens automatically on due dates as part of BOD process. Subsequent renewal or closure transactions happen from the relevant GL heads. Overdue Interest Rates codes are being defined and Interest Accrual on Overdue FD will take place. ACCOUNT INTEREST DETAILS INQUIRY – MENU - AITINQ The above menu shows the details of interest run/booking in the account. It can also be viewed through menu ‘ACM’ with sub-option ‘?’. Further navigation has been provided in above screen to ascertain the position of normal, penal, additional and other interests. Explode the screen. RELATED ACCOUNT LOOKUP FOR RENEWED DEPOSITS The menu option for related accounts lookup is RELACI and is useful to know what are the all links to an existing account. If an account is renewed 5 times and the customer is interested to know the details of all the 5 renewals, specify any one account (the existing or the renewed ones) and make a search for 'F' (forward), 'B' (backward), 'A' (both forward and backward) and 'M' (multiple links). The system will display all the linked accounts and furnish information like account number, a/c opened date, a/c closed date and deposit status. Alternatively, inquire the related a/c list by invoking ACM option - sub option '8'. REPRINT (REDRP) / PRINT DUPLICATE FIXED DEPOSIT RECEIPT (DUDRP) The menu option for reprinting a receipt is ‘REDRP’ and for duplicate printing is ‘DUDRP’. Reprinting/duplicate printing is possible only if the receipt has been printed at least once. In REDRP / DUDRP options, system displays the records listed for printing in de-select mode. Select the appropriate record (shift + F4) that is required to be re-printed. While printing duplicate FDR through DUDRP option, if any remarks in the ‘Remarks’ column have been made, the same gets printed on the fixed deposit receipt. Therefore, when duplicate FDR is issued through above option, enter following remarks in the ‘Remarks’ column: “Issued in lieu of original FD no._______ reported lost”. When a deposit receipt is printed from the system, system creates a record of the inventory number used, which can be inquired using ACM menu ‘K’ (denomination /receipt) details. For duplicate receipt printing, system keeps history of the earlier receipts. While printing duplicate receipt, the system creates a new record as a copy of the old record except the serial number and the lien amount. PENDING DEPOSIT RECEIPTS FOR PRINTING The menu option to inquire and print the pending deposit receipts for printing is ‘PENDDRP’. Before ABH every day, invoke this option to inquire the pending deposit receipts for printing. The system brings up selection criteria screen. Enter the a/c open date from/to as selection criteria and accept. The system brings up all deposit receipts that are pending for printing by default in select mode. On accept from here, the system brings up the print parameter screen. Take the printout. To see more details on the FD account, explode on any record. On explode the system takes to ACM screen for making further inquiry.


[62]

MARKING FIXED DEPOSIT RECEIPT AS LOST The status of a deposit receipt can be marked as lost by the status field in ‘K’ (denomination) details in ACM. REVERSAL OF ENTRY IN FD / RD ACCOUNTS Users are making reversal transaction with ‘TO’ flow_id, which is not correct procedure for reversing any wrong entry in FD/RD account as it creates problem in the proper behavior of the account after the transaction. IN CASE OF RD ACCOUNTS : Wrong installment either debit or credit can be reversed by creating a reversal transaction entry with the value date and same flow id (NI) which was used at the time of wrong credit/debit entry by entering flow id in A details. User may use PLIST menu option for checking the status of the installments. IN CASE OF FD ACCOUNTS: if a wrong credit/debit entry is made in the FD account, the same may be reversed manually by creating a reversal transaction with same value date and same flow id. System will credit the interest at the next interest application date. CLOSURE OF FLEXI RD- MAKER AND CHECKER CONCEPT 1) Closure of Flexi RD (By Operator) Menu option: FCAAC Function C/X/V - Use ‘C’ to close the account Account No: Enter the Flexi RD a/c no to be closed. Account Name: press F4 system will display the name of account holder automatically. Confirm : Enter Y to continue and press F4 2) Verification of closure of Flexi RD ( By Officer) Menu Option: FCAAC Function: V- To verify the a/c and press F4 Account No: Enter Flexi RD a/c no which needs to be verified Customer Name: Press F4, system will automatically populate the name of the account Holder. Mode: C -For cash payment T -For transferring the credit proceeds to operative a/c Repayment Acct: If mode is T than user has to specify repayment a/c id where proceeds needs to be credited. Confirm : Y and press F4 the following screen will appear. Now the accounts will be verified and system will display the transaction_id, please note and check the same. 3) Cancellation of closure of Flexi RD before verification: User can cancel the closure of Flexi RD if wrongly closed but before verification through menu option FCAAC. Enter function X to cancel the closure and press F4. Account No: Enter the account no. which needs to be cancelled. Name : On pressing F4 system will display the name automatically Confirm : Y to cancel the closure and press F4, system will cancel the closure process 4) Debit Transactions in Flexi RD: A check has been put in the system not to allow debit transactions in the system except workclass 100 only for rectifications of wrong entries if any with due care. System will display the following error message while doing debit transactions in Flexi RD accounts.


[63]

LOCKER MODULE IN FINACLE The Locker Module has been developed for handling the following locker activities 1) 2) 3) 4) 5) 6)

Maintenance of lockers Issue of lockers Surrender of lockers Migration of existing data for issued lockers Rent-collection (both regular and irregular) Reports generation.

The above functionalities have been provided through different menu-options. This module is almost independent of Finacle as it uses just one menu-option (TM) of Finacle. The whole module has been developed through scripting and hence it does not give a look and feel similar to Finacle, e.g., the accept-key and commit-key are the same in scripting. Hence the user should be careful while working on this module. MENU OPTIONS MENU LKPM LKTRM LKKM LKCM LKCHM LKRCM LKCPM LKREPM LKCMRPT

DESCRIPTION LOCKER PLACEHOLDER MAINTENANCE LOCKER TYPES AND RENT MAINTENANCE LOCKER KEY MAINTENANCE LOCKER CUSTOMER MAINTENANCE LOCKER TRANSACTION HISTORY MAINTENANCE LOCKER RENT – CHARGE COLLECTION MAINTENANCE LOCKER TYPE CHARGES MAINTENANCE LOCKER REPORTS LOCKER REPORTS

USER LEVEL DATA CENTRE DATA CENTRE BRANCH BRANCH BRANCH BRANCH BRANCH BRANCH BRANCH

INQUIRE LOCKER TYPES Locker type inquiry can be done. List of rent versions applicable to a locker type can be inquired from this option. LKKM ( LOCKER KEY MAINTENANCE ) Activity to be done through this menu : (1) (2) (3)

Assigning keys to locker number Exchange keys between two unoccupied lockers Freeze a locker

Assigning keys to locker Each cabinet in the branch is be assigned a two digit alpha code. The locker number is a 7 digit number with first two digits alpha and the next five digits as numeric whereas the minimum length key number is 3. Example of Locker No. –AA00001 Key Number -AA21. CBS FILED DESCRIPTION Function Sol id

Valid values are A-add, M-Modify, I-Inquire, D-Delete This identify the Service outlet of the user


[64]

Locker Type To identify the type of the locker Locker Number To identify the particular locker Key No. Key number corresponding to the locker While adding a locker number the values for locker number and key number may be prefixed with a two character cabinet code. The locker can be frozen by modify the value of freeze to “Y” either for official purpose (Purpose :O) or for customer related reason (Purpose :C), Freeze reason becomes mandatory then. Exchange keys between two unoccupied lockers The user shall invoke the option in modify mode and replace the old key number with the new key number. LKCM - (LOCKER CUSTOMER MAINTENANCE) Following activities can be done through this menu : (1) (2) (3) (4) (5) (6) (7) (1)

Capturing data for existing lockers Issue of new lockers Surrender of Locker Modification in locker Inquiry of a locker Marking risk classification & Joint account holder Break Opening of locker

Capturing data for existing lockers Invoke the menu option LKCM (Existing) mode. On invoking the option, the following screen shall be displayed. Here most of the fields are similar to the menu for issuance of a new locker. The additional field here is Amount in Arrear Field, where the user shall enter the amount (Rent+Penalty+Charges) in arrear as on the date of capturing the data. On filling in all the information and confirming its correctness, the user shall enter the confirm flag as Y and pressing F4 from here, a message will be displayed that Record added successfully. In case the advance rent has been deposited by the locker customer then a –ve (negative) value shall be filled in the Amount in Arrear filed.

(2)

Issue of new lockers A new locker can be issued to the customer using the menu option

LKCM (Add) mode.

Here the user shall enter Locker type, Locker No, operative account of the customer (for rent collection) and staff flag. On pressing F4 from here the above screen will display some additional fields. The field description for the above screen is as follows:Term Percent Rent

: YR (default populated) : 100% (default populated) can be modified for privileged customers. Privileged Flag : Y/N (in case privilege flag is Y then percent rate is to be modified and privilege date becomes mandatory. Code Word : Code word for operations Issue Date : Date of issue of locker Nominee (Y/N) : If Y then nominee details become mandatory. Remarks : Payment Mode (C/T) : C for cash, T for transfer Cust Id : Cust Id default populated from the operative account (needs to be modified if the Locker Holders cust id is different from Operative a/c holders’ cust id) In case suspense account number is entered in the operative


[65]

account, then user has to enter the Customer Id here. Cust Name : Name of the customer (default populated) Joint Holder : Name of the joint holders. Privilege date : It should be the last Privilege date. Privilege End Date: System will populate automatically five years later date from the date of privilege After entering all the required information, the user shall ensure the correctness of data and make the Confirm flag ‘Y’ and press F4 and the system will display the message that record added successfully Nomination Details Func (I/A/M/D): Function code. Valid values are A, I, M, D. detail of nominee can be added in mode, nominee details can be viewed in “I” mode, nominee details can be modified in “M” mode nominee details can be deleted in “D” mode. Under “D” mode nominee can be deleted or the nominees can be deleted at once, with the corresponding field values (delete all (Y/N) delete(Y/N)) 3)

4)

“A” and all and

Surrender / Modification / Inquiry of Locker Surrender, Modification and Inquiry in a locker are handled through LKCM (S), (M) and (I) mode.

the

same

Marking Risk Classification operations to the impaired persons, and the Joint holder names & Custid

display the

menu

option

name

of

In case of existing locker holders modify the locker details through LKCM “M” Option and enter the proper risk classification, Joint holder cust ID, Joint holder Name and Impaired witness 1,2,3 as required. 5)

Lockers closed by way of Break Opening New field is introduced for handling the lockers closed by way of Break Opening. Such lockers are to be surrendered by the menu option LKCM and set the Break Open flag to “Y”.

6)

Handling Discount/ Rebate in Locker Module Invoke menu option “LKCM” give Privileged as “Y” and then entering the Privilege date and Privilege end date. Thereafter the percent Rent can be modified to the appropriate percentage. For the new customers the function code is “A” and for the existing customers the percentage rent is to be modified using function code “M”. For Staff lockers, the staff flag is to be modified to Y. The percentage rent will be populated 50 % by the system

to

LOCKER RENT COLLECTION Branch user has the option to collect the rent for a single locker or for the SOL on a whole. Menu option for rent recovery is given below: LKRCM Locker rent will be recovered at fixed date i.e. on the first day of month in which it was leased out. The revised system will be applicable w.e.f. 01.05.2014. An automated batch job will run at branch level to recover the rent of the lockers. Advance rent can be collected at any time before the rent due date of locker.


[66]

FAILURE RECOVERY PROCESS – For recovery of rent in lockers where balance in related a/c is not available on Ist day of the month and deposited on 2nd day on wards, automated failover process shall be executed daily from data centre which checks the balance in a/c and tries to recover the rent. Menu- LKRRBAT has been withdrawn from branches. 2) Menu- LKRCM can be used for both rent recovery, advance rent, arrear recovery, advance receipt through cash and transfers. 3) Consolidated position of Rent in arrears (including penalty & other charges ) can be viewed and recovered from menu option LKRCM PARTIAL RECOVERY OF LOCKER RENT Partial amount can be recovered through menu option LKRCM in the multiple of Rs.One. Partial rent so collected should be apportioned from the arrear amount and system will show only the amount left to be recovered in arrear field (LKCM as well as in reports LKREPM 15,22 and 26). Rent so recovered can be viewed in history report LKREPM 23 USE MENU OPTION LKRCM FUNCTION – T User has to provide Locker Type, Locker Number and customer ID as input. For Cust ID, after providing the input at locker type and locker No. user may press F2 at cust id field. After selecting the cust id, press F4, the system will make all the rent related calculations internally and a POP-UP will display following information: 1. 2. 3. 4.

Last Due date. Total Arrear Advance rent paid Rent To Be Paid.

Press ‘Y’ to continue User has to select mode of payment (TRANSFER/CASH), by default the system will show ‘T’ (transfer) mode. User can select Cash mode ‘C’ and enter the partial amount received from the customer and press F4 to create the transaction. FLOW CHART – GENERATION OF LOCKER ARREAR STATEMENT MENU – LKREPM ->SELECT LCKSTAT-15 -> Enter branch SOLID -> Date from to date (If report is generated on 25-09-2014 than enter 01.09.2014 to 25.09.2014) Two reports will be generated: 1‐ Summary: Category‐wise Rent in arrears, Recovery during period, Locker leased,Lockers broken open etc. 2‐ Lockerwise Details : Locker No., Rent in Arrears, recovery made, Mobile No. & Address of the Customer etc Whenever the customer visits the branch to deposit the locker rent, the user can invoke the menu option LKRCM and recover the rent. OR Whenever the operative account has sufficient balance, the system will automatically recover the amount on the next execution of LKRRBAT. iv. In case of advance rent received in the locker, system will automatically to the applicable rent. LKRCM ( Locker Rent Charges Collection )

reduce the advance rent equal

LKRCM menu option can be used in the following cases:-


[67]

a) If customer does not have any operative account, by invoking this menu option, the due rent shall be displayed automatically by the system and the user has the option to recover the rent by Transfer or Cash mode. b) For recover advance Rent from the locker holder where the due date is still a future date, zero amount will be default populated. The user shall modify the field to the amount deposited and recover the amount in Cash or transfer. c) For recovery charges in the locker accounts user shall modify the Rent/Charge/Penal flag to C and fill in the amount to be recovered . LKOPS ( LOCKER OPERATIONS ) Whenever a customer operates the lockers, the details of the visit are recorded using the menu option LKOPS. The menu provides for recording IN time and OUT time for locker operations. Both of these times are to be recorded to complete the process. While entering the IN details, the user shall enter the Locker No and press F4, the system will display all the detail of the locker to be operated i.e. locker type, key No. Customer Id, customer name etc and will ask for entering Customer Id of the locker holder or the authorized person that will operate the locker. On entering Cust id, signatures attached with the cust id will be displayed. On completion of the locker operation the user shall record the time out by entering the OUT details. System will treat the operation completed when both IN and OUT details are entered into the system. CAUTION Before Day end the locker in charge shall ensure that the entire locker operated during the day have been marked OUT in the system. In case user fails to do so, system will not allow subsequent operations in the locker. CAPTURING SIGNATURES OF LOCKER HOLDER / AUTHORIZED SIGNATORY A utility is available in the locker module of Finacle through which, the signatures of the locker holder and authorized signatory (if required) can be captured into the system. In Finacle the locker is issued on the basis of Customer Id issued to customer. The Customer Id shall be having the same constitution as that in the locker. A separate “Image Access Code” LK has been created in the Finacle application. The user at the branch while scanning the signatures of the locker holder with Signcap tool shall specify the Customer ID of locker holder / authorized signatory and shall modify the Access code to LK. At the time of scanning the Description for Signature Column the name of the Locker holder / Authorized signatory and Locker No. is be entered.


[68]

REPORTS IN LOCKER MODULE LOCKER REPORTS (MENU-LKREPM) 1. KEY COFFER REGISTER 2.KEY REGISTER REPORT 3.NEW KEY INTERCHANGE REPORT 4.FREE LOCKER REPORT 5.FROZEN LOCKER REPORT 6.NOMINATION REGISTER 7.SURRENDER REPORT 8.LOCKER WITH FD DETAIL REPORT 9.LIST OF CUSTOMERS HAVING LOCKERS 10.LOCKER OPERATION DURING SPECIFIC PERIOD 11.NO. OF VISIT IN SPECIFIC PERIOD REPORT 12.LOCKER RENT RECEIVED REPORT 13.LOCKER WITH DUE DATE FALLING 14.LOCKER WITH RENT OVERDUE 15.LOCKER ARREAR STATEMENT 16.LIST OF LOCKER ENABLED BRANCHES 17.LOCKER DUE REMINDER -1 18.FREE LOCKER AT A CIRCLE 19.LOCKER SIGNATURE NOT CAPTURED 20.LOCKER SIGNATURE NOT VERIFIED 21.NO. OF LOCKER OPERATIONS IN A SET 22.LOCKER ARREAR STATEMENT FOR A SET 23.LOCKER LEDGER SHEET 24.HISTORY OF VISIT IN A LOCKER 25.LOCKER OPERATION AND CUSTOMER 26.MONTHLY STATEMENT OF LOCKER AS ON 28.LOCKER RISK 29.LOCKER DUE REPORT TWO 30.LOCKER DUE REPORT THREE 31.LIST OF CUSTOMER HAVING LOCKER IN 33.MONTHLY STATEMENT OF LOCKERS AS ON 34.LOCKERS IN OPERATIONAL STATE 35.REPORT FOR LOCKER RENT DUE IN NEXT MONTH (LKCMRPT) 1.REPORT OF LOCKER DETAILS NOTE: REPORTS FROM SL. NO. 1 TO 28 CAN ALSO BE GENERATED IN LIVE SERVER


[69]

LOANS & ADVANCES

FLOW CHART FOR OPENING OVERDRAFT & CASH CREDIT ACCOUNT

OPENING OF ACCOUNTS: 1.

2. 3.

4. 5. 6. 7. 8. 9. For For For For For

Create Customer – CUMM (if customer master does not exist) 'G' General Details 'E' Currency Details Verify Customer CUMM Open Account OAAC 'G' General Details 'S' Scheme Details 'V' MIS Code 'H' Limit History Details 'A' Additional Persons Details (for Guarantor etc.) Verify Account OAACAU Link Security SRM Verify Security SRM Issue Cheque Book ICHB Verify Cheque Book ICHBAU Transactions / Verification TM Modification to Account ACM Modification to Sanction limit/DP ACLHM Modification to Interest Rate Code INTTM Modification to Security Details/DP SRM sanctioning TOD TM -- (N) Option

CLOSURE OF ACCOUNTS •

Destroy unused cheque books

-Menu Option –CHBM/CHBD

•

Apply Charges /Verify Charges

-Menu Option – CACC

•

Apply Interest –

-Menu Option – INTRUN

•

Delink Security –

-Menu Option – SRM

•

Close Account –

-Menu Option – CAAC

•

Verify Closure –

-Menu Option – CAACAU

All the Loan accounts under the Credit Module of Centralised Banking Solutions (Finacle) application package are handled through various Scheme Codes. The scheme codes are maintained under specific for a Scheme Types. The following scheme types are used for various Nature of Advances as under: LAA – for Term Loan and Demand Loans CCA – for Cash Credit Accounts ODA – for Overdraft Accounts The account number for any account in credit module contains of 16 characters. The first four characters indicate the distinctive number of the branch to which the account pertains, followed by a two-character product code, which is specific to the scheme code and then the a/c number.


[70]

CASH CREDIT / OVER DRAFT A/Cs A/C OPENING •

Before opening of a Cash Credit/ Overdraft account, the Customer ID of the borrower must be created through the menu option - `CUMM’. • In case the Customer-ID is already created, the same may be used for opening of the account. • Menu option for opening CC/OD account is OAAC. Give Function as ‘O’, customer ID, scheme code, currency and GL subhead and Press F4. • System by default displays the General Details screen. Some other important fields are: PAY INTEREST?: Enter `Y’ if interest is to be paid in the account, else enter `N’. Although interest is not paid in loan accounts, the system by default populates `Y’ value in this account, which should be retained as this will facilitate refund of interest in the a/c by the system due to any reason COLLECT INTEREST?: By default populates `Y’ in this field, it be retained. CUSTOMER PREFERENTIAL INTEREST (Cr.)– It should be left blank. CUSTOMER PREFERENTIAL INTEREST (Dr.): In case some Debit Preferential Rate of Interest is allowed, over or below the applicable rate for the scheme, at the Customer (CUMM-È’-`Currency Details’) Level and parameter is set at the scheme level, the same differential is default populated here. The values can be over-ridden. In case the preferential rate is over the normal rate, positive value be assigned in this field. In case the preferential rate is below the normal rate, negative value be assigned in this field. ACCOUNT PREFERENTIAL INTEREST (Cr.): It should be left blank while opening loan a/c. ACCOUNT PREFERENTIAL INTEREST (Dr.): In case some Debit Preferential Rate of Interest is to be allowed at this account-level, over or below the applicable rate for the scheme, the differential percentage be specified here. In case the preferential rate is over the normal rate, positive value be assigned in this field. In case the preferential rate is below the normal rate, negative value be assigned in this field. INTEREST TABLE CODE: This is a mandatory field. The system by default populates ZERO in this field as per scheme level set up. Modify this field and assign an appropriate Interest Rate Code. Press F2 to list the valid codes and select the appropriate code by shift+f4. After entering all the relevant information in the `G’-General Details, press ‘F4’. Delete ‘G’ and enter ‘S’-Loan Scheme Details. Press ‘F4’ and enter the Loan Scheme Details. `S’- SCHEME DETAILS This is a Mandatory Sub-option. Dr. Balance Limit: The system by default populates maximum value in this field, which should be retained. Maximum Allowable Limit: Enter the amount of limit sanctioned in the account. Credit File No.: Enter the credit file reference number if any, in this field. Debt Acknowledgement Date – The date on which last acknowledgement of debt (Balance-cumSecurity Confirmation Letter) was obtained. The information in this field can also be filled in subsequent to the account opening. Cheques Allowed: system by default populates `Y’ in this field, which should be retained. Charges for Cheque Issued?: value in this field is set at `Y’, which should be retained. Availing Nomination Facility?: system by default populates `N’, which should be retained. A/c Health Code: This is a mandatory field. Enter valid health code of the account. Press F2 to select the valid health code by Shift+F4. FOR TRANSFERRED ACCOUNTS In case the account being opened is a transferred account, the following two fields must be filled: Interest Amount: Calculate the interest to be charged in the account from the date of transfer of the account from the previous branch till the account open date manually and enter that value in this field. At the time of next interest run, the system will calculate interest in the account from the current date of opening and add up the value entered in this field and debit the account accordingly. Dr./Cr.: Enter `D’ if the type of interest to be charged in the account is Debit.


[71]

In case the details in the above two fields i.e. Interest Amount and Dr./ Cr. fields are not filled during opening in Transferred Account, the transaction in respect of the transferred liability (i.e. Outstanding Balance received from the Transferring Branch) be value dated and date from which the interest is to be calculated / charged in the account, be entered in the `Value Date’ field in menu option –TM. After entering appropriate values of `S’- Scheme Details, Press `F4’. Delete ‘S’ and enter ‘V’-MIS Details in the Option field. Press ‘F4’ and enter the MIS Details. `V’-`MIS CODE MAINTENANCE’ It is a mandatory option. Enter various codes for MIS purposes here. The facility of listing (F2) is available for each of the fields and appropriate code may be selected by pressing Shift+F4. After filling up the appropriate values of ‘V’-`MIS Code Maintenance’, Press `F4’. Delete ‘V’ and enter `H’-`Limit History Details’ in the Option field. Press ‘F4’ and enter the `H’-Limit History Details. Press F6 and enter score card ID generated from PNB Score SME package in free text 6 field, Limit is renewed / fresh sanctioned. `H’- LIMIT HISTORY DETAILS Applicable Date: The system by default populates the current date. Limit Level interest: This field indicates whether the interest is to be charged at the limit level or at the account level. The default value in this field is ‘N’ which indicates that the interest will be charged as per the Interest Rate Code assigned in the field ‘Interest Rate Code’ in the `G-General Account Details’ of the account opening. Sanction Limit: Enter the value of limit sanctioned in the account. Supercede?: This field indicates whether previous limits need to be superceded. For fresh accounts this field is not applicable and ‘N’ is populated by default, which should be retained.Valid values ‘Y’ or ‘N’. Press F4 in the functional block and enter the appropriate values in the following fields: Sanctioned Date: Enter the date of sanction of existing limit. Expiry Date: Enter the date of expiry of the existing limit. Penal Int. From: Enter the number of months from the limit expiry date after which penal interest is to be charged. Document Date: Enter the date of documentation in the account. Review Date: Enter the account review date, if any. This date should be prior to limit expiry date. Security Description: Enter the description of the security available in the account. Remarks: Enter appropriate remarks in the account, if any. Sanction Level: Enter the valid sanction level code. (F2) Sanction Authority: Enter the valid sanctioning authority code. (F2) Sanction Ref.#: Enter the sanction reference number in this field. Status: (Display only) The valid values are:  A – Active, F – Future, S – Superceded, D – Deleted, I – Inactive. Cust. Dr Pref Int: (Display only) The debit interest preferential at the customer level. A/c Dr Pref Int: (Display only) The debit interest preferential at the account level.  Event: (Display) The name of the event is displayed here. The details are: Sanction limit operation & Drawing Power Operation Press F4. The system displays the Drawing Power Details screen. Applicable Date: (Display only) default populated. Sanction Limit: (Display only) default populated. Drawing Power Indicator: The valid values applicable for drawing power are: D – Derived, E – Equal, M – Maintained, P – Parent.


[72]

If the value in this field is set to D - Derived, the drawing power shall be derived from the Value of Security assigned in SRM. If value of this field is set to M – Maintained then the Drawing Power for the account is to be maintained separately for the account. Further absolute value of the drawing power has to be entered in the `Drawing Power’ field. If the value in the field is set to E – Equal then the system will assign the amount of sanctioned limit as drawing power for the account. If the value in this field is set to P- Parent then the drawing power in the account shall be derived from the Limit Node. Drawing Power %: It is mandatory to enter this field only if the Drawing Power Indicator field is set to P-Parent. Limit – ID: This field is mandatory only if the Drawing Power Indicator field is set to P-Parent. Drawing Power: If the Drawing Power Indicator is set to M Enter the value of drawing power. DACC Limit: Absolute/Percentage: The Drawings Against Clearing Credit Limit which is sanctioned as a part of the main limit if any is to be entered in this field. If the sanctioned limit is an absolute amount then enter the amount in the field ‘Absolute’ and if the sanctioned limit is a percentage of the main limit then enter the percentage in the ‘Percentage’ field. A/C Recalled: (Display only) Indicates if the amount is to be recalled. valid values ‘Y’ or ‘N ’. After filling up the appropriate values of `H’-`Limit History Details, press `F4’. Delete ‘H’ and enter À’-`Related Party Details’ in the Option field. Press ‘F4’. À’- RELATED PARTY DETAILS This is an optional sub-option. If the account is a joint account or more than one person is associated by way of guarantor or in any other form the details of such persons can be captured here. This is a multi record screen. By default the first record will be of the person who’s Customer-ID is associated with the a/c being opened. For giving information of other persons, press down arrow key. The information on other persons can be given by way of creating another Customer ID or by just giving the information in the relevant fields. This is a multi record screen. After filling up all pages Press F4 to come to option block. After filling up all details press F10 to commit. The system generates the account number, which should be verified through menu option-ÒAACAU’. VERIFYING CC / OD ACCOUNT OPENING  To verify a new account use OAACAU- Function ‘V’.  Modification of the account details is also possible through this menu option but, before verification of the account. For this, invoke the function-`M’-Modify in the function block instead of `V’.  Give the temporary account number and Press F4.  Use F11 to visit all pages and Press F4 to come to the Option Block.  Visit all screens of ‘G’ ,’S’ ,’V’, and ‘H’ details.  Press F4 to come to Option Block and Press F10 to commit. ATTACHING SECURITY WITH AN ACCOUNT After opening a Cash Credit / OD account, the next step is to attach security available in the account, both primary as well as collateral. These securities can be attached to the account through menu option ‘SRM’SECURITY REGISTER MAINTENANCE. Menu Option to be used is SRM –Function-‘A’. Give ‘A’ for account (or ‘N’ for Node) ,account number (Limit Id in case of ‘N’)and press F4. Give option ‘A’ and press F4.Fill up all the relevant details and press F4. If Insurance details have to be given give ‘N’ here in remark column mention premium amount paid with start date and end date & press F4. After filling up the details give ‘S’ and press F4.


[73]

If charge details have to be filled up give ‘C’ and press f4. After filling up the details give ‘S’ and press F4. Press F10 to commit.

TO VERIFY SRM RECORD Menu option SRM ; Function ‘V’. Give ‘A’ for account (or ‘N’ for Node), a/c no. and press F4. Verify the security, insurance and charge details and press F4. Press F10 to commit. PROCEDURE FOR FEEDING OF STOCK STATEMENT - Charging of penal interest in case of delay/non-submission of stock statement. When stock statement is received by the branch, user enter the stock statement under SRM menu option entering date of receipt of stock statement under receive date field and due date as next due date (Stock statement is valid till due date) Now, there may be four scenarios after first due date: 1. 2. 3. 4.

Stock Stock Stock Stock

statement statement statement statement

has been received on or before the next due date as entered in the account. not received before due date but received before month end date (Interest date). not received after due date till month end date (Interest application date. received after long delay. (received after more than say two months).

1. (Ideal condition, no Penal interest is to be charged) Stock statement is received on or before the Due Date :Stock statement is received on or before the due date, user is required to substitute the existing record with feeding receive date as date when stock statement is received. On verification due date will be replaced with next due date by the system as per frequency fed for the account, even if due date is not changed by the user. eg:- on receipt of Stock statement, SRM record has to be fed with receive date and due date. (Example – If due date is 10-11-2013 and if stock is received on or before 10-11-2013, then user is required to substitute the record with feeding receive date. In this case if the receive date is 0911-2013, after verification system will create new record and change due date as per frequency fed.) Interest Impact :- system will not charge penal interest in such cases. 2. Stock statement is received after the Due Date and before month end date (Interest application date) :Stock statement received after the due date. In such cases user is required to first modify the receive date of current SRM record and feed receive date as date of stock statement is received and verify the same, thereafter user is required to substitute the newly modified record. ( Example – If due date is 10-11-2013 and if customer submits the stock statement on 20-11-2013, then user is required to modify receive date of this record as 20-11-2013 and verify same and after it substitution of modified record must be done.) Interest Impact :- as submission of stock statement is delayed for the period of 10-11-2013 to 19-112013, on modification as stated above system will charge stock interest for the period of 10-112013 to 19-11-2013 on interest application for the month of November’13. 3. When stock statement is not received after the Due Date till month end date :Stock statement not received after due date till month end date, In this case to charge stock interest, user is required to make receive date as blank after due date and before month end date. IMPORTANT: In case stock statement is received after making the receive date as null/blank before month end date, user is required to fed the receive date through modification mode under SRM and substitute as stated the process under step 2 above. If stock statement is nor received in the month then receive date should remain blank. (Example - If due date is 10-11-2013, and if customer does not submits the stock statement after due date, then user is required to modify this record and make the receive date null/blank)


[74]

Interest Impact:- as stock statement is not submitted even after 10-11-2013 and receive date is blank, system will charge stock interest for the period of 10-11-2013 to 30-11-2013 on 30-11-2013. Again, If the stock statement is not received for long time (several months) then further no modification is required to be done (till next submission) and system will continue charge penal stock interest every month till the receive date remains blank. 4. When stock statement is received after long time (several months) after the Due Date :Stock statement received after long time (several months), user has to feed receive date in existing record (where receive date is blank) through modification mode under SRM and after verification of such record, user is required to substitute record as many times till due date comes as next month date (same can be checked after verification of substitution). FINANCIAL TRANSACTIONS IN CC / OD A/CS After opening and verification of the account, the normal cash/ transfer transactions to the account are to be entered through the menu option `TM’ and the clearing transactions are to be entered through the menu option ÒCTM’ and ÌCTM’. The procedure for entering / posting / verification of the transactions for this type of accounts is same as that of any other account. VALUE DATED TRANSACTIONS A value dated transaction in Cash Credit/ Overdraft accounts can be created through the menu option – TM. In the `Value Date’ field, by default the current date is populated. Change this date with the `Value Date’ on which this transaction is required to be posted in the account. The effect of putting Value Dated transaction in the account shall be: It will recalculate the products since the `Value Date’. In case the `Value Date’ is prior to Last Interest Run Date, the system shall pass an Ìnterest Adjustment’ entry during next interest run with value dating as `Last Interest Run Date’. In case adequate Effective Available Amount as on `Value Date’ is not available, during posting, the system shall raise an exception – Ìnsufficient Available Balance Excp Manager’ which can be overridden by an authorised user having minimum work class of Manager and above or an Instant TOD can be granted by that user. MODIFICATIONS / INQUIRY IN CC/OD A/Cs Once the account is opened and verified many activities may be required to be performed in the account. Illustrative list of such activities can be :--> • Modification of Account Details before Account-Verification • Modification of Account Details after Account-Verification • Modification of Interest Details • Review/ Renewal/Enhancement/ Reduction of the limits • Granting Temporary Overdrafts (TOD) in the account • Sanction of Ad-hoc Limit • Allocation of Drawing Power as a Parent Branch • Maintaining the Account where Drawing Power is allocated by other Branches • Interest Calculation before Account Closure • Earmarking drawing power. MODIFICATION OF ACCOUNT DETAILS AFTER ACCOUNT-VERIFICATION • •

For any modifications in the account except Limit and Interest Details, the menu option is ÀCMCustomer Account Maintenance’ is to be invoked and `M- Modify’ is to be entered in the option field. Following details can be modified: General details with sub option ‘0’


[75]

• • • • • • • • • •

Related party details with sub option ‘A’ Scheme details with sub option ‘S’ MIS codes with sub option ‘V’ The fields appearing in the sub options ‘0’, ‘A’, ‘S’ and ‘V’ are same as those appearing in the ‘G’, ‘A’, ‘S’ and ‘V’ of the menu option ‘OAAC’ respectively. The verification of any modification is to be done using the same menu option i.e. ÀCM- Customer Account Maintenance’ by some other user and function will be `V-Verify’. invoke the concerned sub options where modification/changes have been done and visit those information before giving a final commit. In order to know which information has been modified, invoke sub option ‘D – Audit inquiry’. The audit inquiry screen gives information on the tables, which are affected because of the modifications done. An explode from that place will show all the relevant fields with old value and new value. On visiting the applicable sub option accept (F4) and F10 for verifying the modification. Through ACM following sub options are available for inquiry:  Purge Details with sub option ‘P’  Limit history inquiry with sub option ‘H’  Account ledger inquiry with sub option ‘G’  Dependent account list with sub option ‘6’  Asset classification inquiry with sub option ‘Y’  Interest detail inquiry with sub option ‘?’

MODIFICATION OF INTEREST DETAILS Invoke a menu ÌNTTM’ for modifying any of the interest related parameters including pegging and preferential interest rates. Enter `M’-Modify in the function field and indicate the A/c number and accept to proceed further. 1) INTEREST TABLE CODE: Enter the appropriate Interest Table Code, in case any modification in Interest Rate is required. Press F2 for appropriate codes. 2) CUSTOMER PREFERENTIAL INTT (Cr.) & A/C PREFERENTIAL INTT (Cr.) default populated zero values be retained. 3) CUSTOMER PREFERENTIAL INTEREST (Dr.): If any Debit Preferential Rate of Interest is allowed to a customer over or below the applicable rate of interest, at the Customer (CUMM-È’-`Currency Details’) Level, the same differential is default populated here. The values can be modified here which will be effective at the account level. In case a reduction is to be allowed then the value should be preceded with a minus (-) sign. 4) ACCOUNT PREFERENTIAL INTEREST (Dr.) - In case any Debit Preferential Rate of Interest is to be allowed at the account level, over or below the applicable rate for the account, the differential is to be entered in this field. In case a reduction is to be allowed then the value should be preceded with a minus (-) . 5) IS INTEREST PEGGED?: Valid values for this field are `Y’ or `N’. If Interest Pegged Flag is set to ‘Y’ then, any changes in the subsequent versions of the Interest Table Code will not have any impact on the interest calculation from the start date till the end date. Else `N’ value should be assigned in this field. 6) START DATE: Enter the date from which the above mentioned interest rate shall be applicable. 7) END DATE: Enter the date up to, which the above mentioned interest rate shall be applicable. Multiple interest rates with various start / end dates can also be entered to an account by pressing down arrow key. The system will populate the next date in the field ‘start date’ in continuation to the ‘end date’ entered in the earlier interest record. After modifying the required information commit the record. This modification requires verification through menu ÌNTTM’ function - `V’-Verify.


[76]

HELP WINDOW FOR INTEREST TABLE CODES DURING A/C OPENING PROCESS FOR LOANS & ADVANCES For the convenience of branch users for selection of appropriate interest table code certain customization has been done in interest Rate code field under OAAC menu option and now on pressing F2 on Int Table code system will display all active interest table codes only. The new help window consisting of interest table codes along with its description, interest table code help flag, Present Base rate (if linked to Base Rate), Spread and net rate of interest (as on date) of interest table codes will be displayed. New column has been added in the help window i.e. help flag. This field is a identifier of segment of loan for which all the interest table code belongs. eg: for education loan related interest table code help flag is ‘ED’ This Help flag should be entered in interest table code field before pressing F2. system will display all interest table codes related to help flag on the top of the list and remaining interest table codes will be listed thereafter. . Eg :- if branch user feeds ED in interest table code field then system will display first interest table code related to ED (For Education loan) and then remaining all interest table. User can select appropriate interest table code by pressing Shift + F4 and can assign in the account. List of help flag for interest table codes is S.No.

Circular Sl. No.

Interest table code structure for Retail Segment Loans

1

1

2 3 4

2 3 4

5 6 7 8 9

5 6 7 8 9

10

10

1 2

3 4 5 6 7

8

Interest Table codes for Housing Finance to Individuals including NRIs / Flexible Housing scheme / Existing Fin Basket a/c Interest table codes for Earnest Money Deposit Scheme Interest Table codes for Personal Loan to Pensioners Interest Table codes for Loan against mortgage of Immovable Property Interest Table Codes For Car Loan Interest Table Codes For Two-wheeler Loans (PNB SARTHI) Interest Table codes for Personal Loan Interest Table codes for Education Loan Interest Table codes for Advance against Jewelry & Ornaments Interest Table codes for PNB BAGHBAN (Reverse Mortgage Scheme)

Help Flag HL

EM PP IM CA TW PR ED JW BA

Interest table code structure for other then Retail segment Loans 1A Interest Table codes for Agricultural Advances AG 1B Interest Table codes for Micro & Small Enterprises Advances SM (MSE) including Trading Advances covered under MSME Act Interest Table codes for Trading Advances not covered 1C under MSME Act SM 1D Interest Table Codes for Doctors Loan DR 2 Interest Table Codes for Tractor Loans TR 3A Interest Table Codes for Financing under Capital Investment RG Subsidy 3B Scheme for construction/ renovation/ expansion of rural RG godowns Interest Table codes for Advances for construction of Godowns as per FCI/CWC specifications 4A Interest Table Codes for Financing against pledge of WR


[77]

9

4B

10

5A 5b

11

6A

12

6B

13

6C

14

8

15 16

9A 9B

17

9C

18

10

19

11A

20

11B

21

12

22 23

14 16

24

&

warehouse receipts issued by CWC having forward sale contract with members/brokers of NMCE Interest Table Codes for Schemes for financing against pledge of warehouse receipts issued by Collateral Managers Intrest table codes for Advances to Food and agro-based processing units i.e. Rice Sheller units /Cold Storage Units / Seed Processing Units / Flour Mills/ Oil Mills, and (b) Advances to units engaged in Food and Agro processing activities like manufacturing/processing of Pulses, Dal, Suzi, Besan etc. & its allied activities provided that the advances are covered under Priority Sector in terms of PS&LB Division circular on Priority Sector Advances – Classification & Reporting issued from time to time) Interest Table codes for Advances under Self Help Group Scheme (SHGs) Interst Table Codes for Scheme for financing Micro-Financing Institutions (MFIs) for on-lending to individual members or SHGs/JLGs Interest Table Code for Scheme for Portfolio Buy Out of microfinance Receivables /other receivables of MFIs / NBFCs under direct agriculture Interest Table Codes for Advances to Film Production / Entertainment Industry Interest Table codes for Advances to Commercial Real Estate Interest Table Codes for Advance against future lease rentals (CRE CATEGORY) Interest Table Codes for Advance against future lease rentals (Non-CRE category) Interest Table Codes for Financing against assured future receivables (PNB Cash Flow Discounting) Interest Table Codes for Financing under Supply Chain Scheme Interest Table Codes for Financing dealer for purchase of vehicles from RMCs Interest Table Codes for Advances to ‘other categories of borrowers’ including NBFCs, Sugar units, Services Sector & advances to medium & large enterprises Interest Table Codes for Transport Operators

WR FA

SH SH

PB

FL CR CR CR FR SC VL

OC

Interest Table codes for Bank Premises

TO BP

17

Interest Table Codes for Exposure to Capital Market

CM

25

18

Interest Table Codes for DRI Advances

DI

26

19

Interest Table Codes for Clean Advances

CL

27

20

Interest Table Codes for Advance Against: **

GS

28

24

Interest Table Codes for Intermediary Agencies

IA

29

25

Interest Table codes for Term Loans to Exporters

EX

30

29

Interest Table codes for Advances to Members of Staff

ST

Master Table base Interest code –Risk rating base

MT

31


[78]

AUTOMATION OF REDUCTION OF DRAWING POWR ON MONTHLY BASIS UNDER OVERDRAFT SCHEMES - ODSAN The monthly Drawing power to be reduced every month will be arrived on the basis of Sanction limit divided by total number of months. The number of total months is taken from applicable date till expiry date entered in latest active limit under „H‟ details (Limit History details) of the account. As such DP can be checked through under noted formula:New DP = sanction limit – (sanction limit * no of months completed) months.

/ Total number of

The method to calculate the above terms i.e. sanction limit, no of months completed & Total months of limit is as given below :1. Sanction limit :- System will check the latest active sanction limit. 2. Total number of months:- system will check the difference between applicable date and expiry date in latest active limit and same will be taken as total number of months (remaining days will be treated as 1 month). 3. No. of months completed :- system will check the difference in months between system date (BOD date) and applicable date of latest active sanction limit and difference in months will be taken as no. of completed months. This process will be run from Data Centre in the last week of every month and Drawing power of all the eligible accounts will be reduced as stated above RENEWAL / REVIEW / ENHANCEMENT / REDUCTION OF CC / OD LIMITS Modification in sanctioned limit for an OD / CC account is required at the time of renewal/ review or enhancement/reduction in sanction limit. These changes be done through menu ACLHM- Account Limit History Maintenance. The function block of this menu has the following fields: FUNCTION: The valid functions:-- M (modify), I (inquire), V (verify), X (cancel), L (list). For modification in the limit details, enter `M’-Modify, A/C NO.: Enter the Account Number. OPERATION: This field has two operations `S’-Modifications to Sanction Limit and `D’-Modification to Drawing Power Details. Indicate `S’ to modify the Sanction Limit and Press F4 The system shows the existing sanctioned limits available for the account. Select the required limit by using the arrow Key. The cursor moves to Òption’ field, Enter `M’-modify in the Òption’ field and press F4. The system displays the `Sanction Limit Details’ screen with applicable date and previous / existing sanction limit. Make the required modifications in the following two fields: Applicable Date: Enter date from which the modified limit shall be applicable. Sanction Limit: Enter the values of the modified limit. Limit Level Interest?: default value as `N’ be retained. Supercede?: Except under òption’- A (Add) and C (Copy), this field is not accessible under rest of the options and value will always be `Y’. The effect of this field is that after commit, the previous limit gets superceded by the modified limit. Press F4. The following fields are available for modifications: Sanction Date: Enter the date of sanction of the modified limit. Expiry Date: Enter the date of expiry of the modified limit.


[79]

Penal Int. From: Enter the number of months/ days after the limit expiry date so that the system should start charging penal interest in the account after this period. Document Date: Enter the date of documentation. Review Date: This date should be lesser than the `Limit Expiry Date’. In case of `Review’, enter the next date of review. Security Description: It is a free text field. Enter the security description in the account. Remarks: It is a free text field. Enter the appropriate remarks. Sanction Level: Assign the appropriate sanction level code from the list available in this field. Sanction Auth: Assign the appropriate sanctioning authority code from the list available in this field. Sanction ref#: Enter 7 Digit PF number of recommending & sanctioning auth. Press F4 to accept and F10 to commit the modification. This modification requires verification by another user through menu option-ACLHMAU. In case of Ènhancement’, before invoking the menu option – ACLHM, modify the Maximum Allowed Limit’ field in `S-Scheme Details’ of the account through menu option – ACM with the enhanced value of the limit sanctioned. Get this modification verified through menu option – ACM. HANDLING SUBSIDY LINKED THROUGH RUNNING ACCOUNT In CC and OD accounts separate limits can be assigned to the account based on the rate of interest in a single account. The user feeds the limit details under ‘H’ details for limit sanctioned to the customer. In this case two separate limits to be fed. For example, if a borrower has been sanctioned Rs.100000/- limit where Rs.10000/- subsidy is available, the following steps have to be taken: STEP -1 Ist Limit equivalent to subsidy ( in this case Rs.10000/-) : While opening the account through OAAC, limit has to fed under ‘H’ details keeping ‘ Limit level int =Y”, ‘ Supercede = ‘N’ and sanctioned amount equival to the subsidy available for the account. The normal Int. Rate has to be kept as 0.00. STEP – 2 After opening of the account through OAAC and verification through OAACAU, another limit equal to (Total sanction limit minus amount of subsidy) is to be assigned keeping “ Supercede = N and limit level int =N through ACLHM. User to add second limit by giving ‘A’ (add) under option block. On enquiry system will show 2 active limits. System will apply interest @0.00% on the first limit i.e. on Rs.10000/- and for balance limit interest will be charged at the rate applicable as per data fed under ‘G’ details of the account or through INTTM. NOTE: After crediting the subsidy amount to main account, limit has to be modified through ACLHM, limit amount has to be kept net of subsidy amount and Supercede =Y and limit level interest as “N” in order to nullify the effect of subsidy and to charge interest on the whole limit. CLOSURE OF CASH CREDIT / OVERDRAFT ACCOUNT Before executing the account closure procedure the following steps must be followed: Execute menu option ÀCM- Customer Account Maintenance’ enter ‘M – Modify’ in the function block and enter the Account Number in the next field. Then enter ‘0 – General Account Details’ in the option field accept and go to next screen using F6. Modify the field ‘Pay Interest?’ from ‘Y’ to ‘N’. Get the modification verified. Ensure that all securities attached to the account are deleted through SRM and SRM is verified. Ensure that no standing instructions are outstanding where the Cash Credit/ Overdraft account is mentioned. Ensure that there are no pending transactions for the account in entered status for the account. Ensure that the Cheque Books issued in the account, have been destroyed.


[80]

Invoke menu option ‘CACC-Closure of Account Charge Collection’. In the Function field, enter `Z-Account Closure’, specify the Account Number and in the Àctual/ Trial’ field enter À’-Actual and press `F4’. The system displays the `Details of Charges to be Collected’ in the account. Press F10 to commit the Charge Collection during Account Closure. Verify this charge collection process -- menu option – CACCAU – Function: `V’-Verify. On verification, the system creates transaction to debit the charges into the account and post the same in the account. Transaction ID should be noted and post and verify the same menu option - TM. Invoke menu option ‘CAAC – Close An Account’, -- ‘Z, Enter the account number in the next field and accept. The system will force to run interest application while the cursor will be in the field ‘RUN INT. CALC. NOW’. The default value ‘Y’ shall be populated in this field. The system will also show certain important information on the account viz. Customer Id, A/c Opened Date, Account Balance, Lien Amount, Last Interest Date, Pending transactions, Pending Standing Instructions Transactions etc. On pressing F4 the system calculates the up-to-date interest and creates transaction for interest debit and posts the same in the account under closure. The interest entry shall be in the entered state if any exceptions are encountered. Press F3, print the interest application report through menu option PR and post and verify the interest transaction if it is in entered status through menu option TM. After the interest is applied to the account through menu option ‘CAAC’, the system will show the exact liability in the account on the day of closure as soon as the interest transaction is posted and verified. The account should be credited by the debit balance amount through menu option TM and the transaction should be posted and verified. When the account balance is zero, once again invoke menu option CAAC, enter Account Number and press F4 ensure that the field ‘RUN INT. CALC. NOW’ is default populated as ‘N’ and the field is protected. The system displays a message at the bottom of the screen that the interest calculation is up-to-date. After ensuring this, accept and commit account closure. VERIFICATION OF CLOSURE OF THE CASH CREDIT/ OVERDRAFT ACCOUNT The account closure is to be verified by a supervisory user through ‘CAACAU, The verifier has to enter ‘V – Verify’ in the function field. Enter account number in this field. On pressing F4 the system will display the information as detailed above. Accept the details and commit to verify the account closure process.

TERM LOAN / DEMAND LOAN A/CS The Scheme type for Loan Accounts is LAA Loans can be broadly classified as EMI & non-EMI loans. All loan transactions are linked to different types of flows. The nature of flow can be E – Equated installment, C-Collection, D-Demand, P-Disbursement, and T-Transfer. If it is a demand flow, then the demand type can B-Bank charges, I-Interest, O-Other charges, PPrincipal. For collection flows, adjustment can be in chronological order of demands raised or user defined offset sequence of demands. Interest liability can be maintained either in Loan account or in Loan Interest Office account. Similarly credits can be accepted to a common office account (Loan Payment a/c), and allow the system to apportion the recovery between various demands. After demands being raised, lien can be placed on operative account (LALIEN). Similarly recovery of demands can also be automated. During demand satisfaction, the lien, if placed earlier, with be removed (LADSP) Reversal of wrongly created transactions is possible.


[81]

Re-phasement of non-EMI loans can be done through ACM option. For EMI loans the rephasement is done through REPHASEI option. Classification of a loans according to the borrowers’ ability to service the loan is possible. Various reports available to inquire on the position of account (Total recoveries made, Total Overdue position, Sector wise classification, etc) (LAOPI / LAPOSR / LAGI) Loan account history regarding correspondence can be maintained through LAFHM. Interest calculation on loans through the option ACINT. TERM LOAN / DEMAND LOAN - OPENING OF ACCOUNT The menu option is OAAC. Verification of the account should be done using menu OAACAU. GENERAL DETAILS – SUB OPTION “G” ( 3 SCREENS ) - MANDATORY Mode of operation: This is MANDATORY & only an information field. This is displayed in TM Screen. Based on the value set up here and displayed during Transactions in TM. Account Mgr: This is the user ID created using UPM menu. If any value is mentioned here, it means that this account is looked after by that particular person. Many operations can be done based on this value like interest calculation, statement printing, inquiries etc. Customer preferential interest rates both debit and credit would be default populated if it is mentioned at customer level and the parameter is set at scheme for default population. The values can be over-ridden. ‘Account Preferential’ is another field through which special rates of interest can be specified to the account. Interest credit flag, Interest debit flag, Interest debit account, Interest credit account are not applicable in this case Interest table code is a mandatory field and must be changed from ZERO to applicable rate code. If the interest rate is fixed during the entire tenor of the account then value should be set as “Y” for the field “Account pegged?” If the value is set as “Y” for the above field, then enter value for the fields “Pegging review date” and “Pegging Frequency(Months/Days) ” Tax details are not applicable for Loan Accounts. SCHEME DETAILS – SUB OPTION “S” – (2 SCREENS ) - MANDATORY Loan amount is the amount of loan sanctioned. The system validates whether the amount indicated here is within the range mentioned at product level. Else an exception would be raised. Loan period is the tenor of the loan. The system validates for this value also based on the scheme level set up and appropriate exception would be raised. If the value is set as “Y” for the field “Hold In Oper A/c For Amount Due?” then lien on the operative account to the extent of ‘demand’ in the loan account can be marked by LALIEN menu. Value set for the field “Repayment Method” will decide how repayment will be made. If the value is set as “E”, then system recovers what is available in the operative account. If the value is “T” system creates a TOD and recovers the entire dues from the operative account. If the value is “N” then no recovery would be done. If the value is set to either “P” – Post dated cheques or “D” – Electronic clearing, then get a report on such accounts and all further processes is procedural. If the value is set as “Y” for field “Transfer in A/c”, then enter additional information in sub option “U” – un-computerized details. Fields on the 2nd Screen relate to various information relating to the account with regard to Refinance, Subsidy etc. No validations are done based on any of those fields. In order to handle subsidy based Term/Demand Loan Accounts where interest rates are slab-wise a new field “Int. Rate based on Loan Amount– Y/N” has been added in the Scheme Details of the OAAC menu option. The valid values are:


[82]

Y – Interest rate based on loan amount sanctioned N – Interest rate based on balance outstanding The value once set cannot be modified throughout the tenor of the loan, Applicable for the new accounts to be opened in the new version only A combination of the value set in this field as ‘Y’ and the LVSM – slab based code will result in the desired functionality MIS CODES – SUB OPTON “V” - MANDATORY Enter various codes for generation of accurate MIS here, by listing F2 in each field. Press F6 and enter (i) PNB Score Card ID in Free Text 1 if Retail Loan (ii) PNB SME Score Card ID in Free text 6 field. INTEREST DETAILS – SUB OPTION “I” – MANDATORY The system by default populate most of the values based on the set up done at scheme level. Which can be overridden. ‘Intt. Demand Effective Date’ should be entered in case of such Loan Accounts, where Intt. Becomes due after a particular period, e.g. Staff Loans on Simple Intt., Education Loan etc. Once the account is opened, then all these information will be the property of the account and system will not look into the scheme level any further for future processing on the account. REPAYMENT SCHEDULE – SUB OPTON “E” - MANDATORY Flow ID field can have value which is of Equated installment demand, Principal demand or Interest demand type. These flow IDs are created using flow code maintenance. If the account is opened under equated installment scheme then the system default populates the flow id based on the set up done at scheme level. If it is equated installment, system populates the EI amount based on the number of installments indicated which can be over ridden. An exception is also associated with this for doing necessary validations. Start date of the installment should always be greater than the account open date Enter the number of installments to arrive at the installment amount. Depending upon the parameter set at product level, enter the values for the field “number of installments”, and “amount”. In modify mode, then the original repayment schedule can be modified. The system does a validations if the number of installments and the tenor of the loan does not match and an exception would be raised. FEATURES There are two systems prevailing in the banking sector for calculation of interest on EI (Equated Instalments) based loan accounts: 1)

EI in Arrears – The interest for holiday period (moratorium period) is calculated and capitalised on the day of repayment start date and the EI is calculated accordingly. In other words, first instalment also include the portion of capitalised interest.

2)

EI in Advance – The interest for holiday period (moratorium period) is calculated and demand is raised from the 2nd instalment onwards. The first instalment is raised only for the principle.

In our bank, the system of EI in Arrears is prevailing. The same is set at product level by Data Centre in respective GSPM. Now the system will correctly calculate the demand as it will automatically rephase the account at the end of holiday period.


[83]

In case of EI based Loan accounts, the Equated instalment raised by the system is a combination of Principal and Interest amounts. In the existing version it has been observed that the system is raising Principal Demand on a different date and Interest Demand on a different date. In order to synchronise the raising of demands for Principal and Interest two new fields ‘Int Dmd Date’ and ‘Int Freq’ have been added. The new fields of the E - Repayment Schedule Details of the menu option OAAC/ACM following functions :

have

Int Dmd Date: This field refers to the Interest Demand Date where the date from which interest demand is to be raised by the system. In case of EI based loan accounts, the interest demands are to be raised along with the principal demand hence, the date of Principal & Interest Demand should be the same. In case of gestation period for commencement of repayment, following procedure be adopted: i) Enter the actual date from which the instalment repayment is to be commenced in the field ‘Flow Start Date’. ii) Enter the month end date of the month in which account is being opened in the field ‘Int Dmd Date’ and iii) Enter the actual date of commencement of repayment in the field ‘Interest Demand Effective Date’ in the I – Interest Details of the menu option OAAC. (same date as given in Flow Start Date) iv) Int Freq: The frequency entered in this field should be same as the frequency entered against the field ‘Flow Start Date’. DISBURSEMENT DETAILS – SUB OPTION “D” - OPTIONAL A disbursement schedule can be defined and the disbursement can be monitored . The system validates whenever a disbursement is made whether it is as per the disbursement schedule or not and appropriate exception would be raised if set up is done. In absence of such schedule, disbursements may be made in as many installments as required. MESSAGE MAINTENANCE – SUB OPTION “M” - OPTIONAL As a part of account opening, information can be noted, with regard to the account in the form of messages. These messages can be in the form of free text or through a coded mode. messages can be entered without the help of codes also. UNCOMPUTERISED DETAILS –SUB OPTION “U” – MANDATORY FOR TRANSFER-IN ACCOUNTS This information is required only if the value for the field “Transfer in A/c?” is “Y”. This information is stored till the account is verified and transactions are put through to the account and demands are uploaded to the system. Normally these information are captured in case of accounts which are transferred from another branch or when migration is done from one application to another application or from the manual system to computerised system. Enter all the relevant data during account opening itself as no further modification is possible once the account is opened. SOME IMPORTANT FIELDS : XFER EFFECTIVE DATE: Enter the date from which the account opened in `Transfer-In' mode should be made effective. This can be either the current date or any future date, by which all the details of the account are entered into the system and the account opening procedure is completed. In case any of the process of account opening in `Transfer-In' mode is not completed by the date entered in this field, the system will not allow any operations in the account.


[84]

LIABILITY AS ON XFER EFFECTIVE DATE: Enter the Principal Liability Outstanding as on the date of transfer in this field i.e. the balance outstanding in Principal A/c. DISBURSEMENT IN PREV. SCHDLS: Enter `0.00' in this field and if any other values are entered in this field then this will lead to wrong processing of the account opening and the system may not allow entry of any transactions into the account. SUM OF PRINCIPAL DEMAND RAISED: Enter `0.00' in this field and if any other values are entered in this field then this will lead to wrong processing of the account opening and the system may not raise appropriate demands in the account. CUMULATIVE NORMAL INTEREST: Enter the Cumulative Normal Interest Liability outstanding as on the date of transfer i.e. the interest outstanding in the simple interest accounts in this field. If there is no interest amount outstanding in the account then, '0.00' should be entered in this field. CUMULATIVE PENAL INTEREST: Enter the Cumulative Penal Interest Liability outstanding as on the date of transfer i.e. the penal interest charged to the account if any, in this field. If there is no penal interest amount is debited to the account then, `0.00’ should be entered in this field. CUMULATIVE ADDNL. INTEREST: As we do not charge any Additional Interest for Term Loan accounts, this field should be entered with the value `0.00'. TRANSFER IN INTEREST AMOUNT: This field is default populated with `0.00', which should not be altered. LAST INTEREST POSTED DATE: Ensure to enter the date up to which interest has been charged to the account. This date is very important, as the system shall henceforth calculate the interest in the account from this date onwards. In case of an account where no Interest is applied till the date of transfer of the account then the account opened date should be entered in this field. REPAYMENT SCHEDULE DATE: Ensure to enter the Original Account Opening Date as specified in the field À/c Open Date' under the `G'- General Details above. Any variation in the dates entered in the fields, À/c Open Date' under the option the `G'General Details and `Repayment Schedule Date' under the option Ù'- Uncomputerised Details, will result in transactions not being allowed to be entered into the account. LIMIT HISTORY DETAILS – SUB OPTION “H” - MANDATORY The details of the limits sanctioned and the drawing power are entered by this sub option. There are two different screens to capture the details. System by default populates the loan amount as sanctioned limit. The other two fields in the function block are not applicable for this scheme type. Interest details are not applicable for this scheme type Penal interest can be from the date of expiry or beyond the expiry date. A date which is earlier to expiry date can not be entered. Press `F4’, enter the appropriate values in the following fields: 1) Sanctioned Date 2) Expiry Date :Loan Repayment Period + Gestation Period, if any. 3) Document Date.


[85]

4) Security Description 5) Sanction Level 6) Sanction Authority 7) Sanction Ref 8) Status After entering the above information, press `F4’. The system opens up the Drawing Power Details screen. The values in the Applicable Date field are default populated and Sanction Limit is displayed. The cursor is positioned in drawing power indicator field. The valid values applicable in Drawing Power Indicator field are: D – Derived, E – Equal, M – Maintained, P – Parent Limit node. Assign È’-Èqual to Sanctioned Limit’ in this field for opening Term / Demand Loan accounts. It is mandatory to enter field of drawing power % only if the Drawing Power Indicator field is set to P-Parent. It is mandatory to enter field of limit – ID only if the Drawing Power Indicator field is set to PParent. 1) The value of drawing power of the account. The value entered in the Sanction Limit field is displayed if the Drawing Power Indicator field is set to E-Equal. 2) If the account has been recalled enter valid value as ‘Y’ otherwise ‘N’. DISBURSEMENT DETAILS – SUB OPTION “3” - OPTIONAL Loan can be disbursed entirely or a part of the amount during account opening process. However, margin cannot be collected from the borrower through this sub-option. If the transaction type is ‘cash’ , ‘credit a/c number’ should not be entered , if the transaction type is ‘Transfer’, then the user has to enter the account number to which the credit should be made. On F4 system shows sub option block from where F10 can be pressed. Verification of the account opening will create the necessary transaction. Once all the relevant data is entered commit from the option block. The system gives the account number, which has to be noted for verification. In addition, SRM record is to be created and verified for every TL/DL Account. OPENING OF LOAN ACCOUNTS IN TRANSFER-IN MODE STAFF HOUSING LOAN A/CS AND STAFF VEHICLE LOAN A/CS.

In Finacle separate accounts are to be opened for the different limits carrying different rates of interest i.e., in case of Housing Loans, three accounts are to be opened in the following manner: i. ii. iii.

Housing Loan account bearing interest at 5% simple interest p.a. Housing Loan account bearing interest at 11% simple interest p.a. Housing Loan account bearing interest at PLR compound interest – it may be clarified here that this account with interest at PLR is already migrated into Finacle. In case this is not migrated then, this account is also required to be opened manually. Similarly for Vehicle Loan accounts to staff members are also to be opened separately for various limits carrying different/zero interest rates. However, in case the entire principle amount is repaid then a single account is to be opened for the amount of Interest outstanding in the account. TERM LOAN ACCOUNTS WHERE INTEREST AMOUNT DETAILS ARE NOT AVAILABLE If the individual interest amounts could not be procured or not available, then it is suggested that entire outstanding interest amount may be migrated to new account opened in Finacle carrying lower interest rate (say 5% pa). This method is suggested in view of the fact that the repayment of the loan account carrying interest at lower rate will commence after the adjustment of the principle in the account carrying higher rate of interest (say 11% pa) and after adjustment of entire principle amount, the recovery of interest will commence.


[86]

TERM LOAN ACCOUNTS WHERE INTEREST AMOUNT DETAILS ARE AVAILABLE In case different interest accounts are maintained for different loan accounts or if the details of individual interest amounts are available, then the individual Interest transactions may be entered into the respective loan accounts. It may be noted that in Finacle, the interest amounts will be accounted for in the individual accounts i.e., the interest applicable to the loan account at 5% will be accounted for in the loan account at 5% and in the loan account at 11% will be accounted for in 11% account itself. IMPORTANT POINTS WHERE PRINCIPLE AND INTEREST AMOUNTS ARE OUTSTANDING - MENU OPTION - OAAC: While opening these types of loan accounts in transfer-in mode, it must be ensured that in the ‘G Details of OAAC – in the field – A/c Open Date’ enter the Original Account Opening Date. In the ‘S- Details of OAAC – in the field – Transfer in?’ delete ‘N’ and enter ‘Y’ and enter the other relevant information in the required fields. Then the date from which the interest repayment is to be commenced is to be invariably entered in the ‘I – Details of OAAC – in the field – Interest Demand Effective Date’. The amount of balance outstanding in the account should be entered in ‘U – Details of OAAC - in the field - Balance as on the Transfer Effective Date’. The amount of interest charged to the account is required to be entered in the field ‘Normal Interest’. If any penal interest is charged to the account, then the split up may be given in the fields ‘Normal Interest and Penal Interest’. Also enter the other fields with appropriate values. It may be ensured that in the field ‘Scheduled Repayment Date’ Original Account Opening Date is entered. In the ‘E – Details of OAAC’ two Repayment Schedules are to be entered as under: 1) First repayment schedule for the Principle amount with the Flow Id as ‘PRDEM’. In the field start date enter the date from which the repayment of principle is to be commenced and in the field ‘No.’ enter the number of installments in which the repayment of principle is to be made. Enter the frequency in the next field and then enter the installment amount in the field ‘Amount’. Then press ‘Down Arrow Key’ for entering the interest repayment details. 2) This repayment schedule for Interest amount, is to be entered with the Flow Id ‘INDEM’. The ‘Start Date’ is automatically populated by the system for commencement of repayment of interest, which should be checked for its correctness. In the field ‘No.’ enter the number of installments in which the repayment of Interest is to be made. Enter the frequency in next field and then enter the installment amount in the field ‘Amount’. Installment amount for Interest repayment should be segregated proportionately for different interest rates. ACCOUNTING PROCEDURE OUTSTANDING:

FOR

THE

A/Cs

WHERE

INTEREST

AND

PRINCIPLE

ARE

After opening the loan account in transfer-in mode and after getting the account verified, the following transactions are to be entered through menu option ‘TM’: i. Dr. Term Loan account with the amount of Principle + Interest charged to the account till last interest run date. In the field ‘Value Date’ enter the Original Date of Disbursement or the Original Account Opening Date. In the Additional details, enter the ‘Flow – Id as DISBT’ and the ‘Demand Date as the Original Principle Repayment Commencement Date. Cr. Upload /sundry account- with the above amount. ii. Post and verify the transactions. iii. Run the command ‘LAUPLDMD’ for uploading the demands. iv. Dr. Upload / suspense account – with the amount of recoveries made in the account Cr. Term Loan account – with the amount of recoveries made in the account giving the Flow – Id as ‘TRCOL’ in the additional details and also delete ‘N’ from the field ‘Last Part-tran’ and enter ‘Y’. v. Post and verify the transactions.


[87]

IMPORTANT POINTS WHILE OPENING THE A/Cs WHERE PRINCIPLE IS REPAID AND INTEREST AMOUNT IS OUTSTANDING - MENU OPTION - OAAC: While opening these types of loan accounts in transfer-in mode, it must be ensured that in the ‘G Details of OAAC – in the field – A/c Open Date’ enter the Original Account Opening Date. In the ‘S- Details of OAAC – in the field – Transfer in?’ delete ‘N’ and enter ‘Y’ and enter the other relevant information in the required fields. Then the date from which the interest repayment is to be commenced is to be invariably entered in the ‘I – Details of OAAC – in the field – Interest Demand Effective Date’. The amount of balance outstanding (i.e. Interest amount) in the account should be entered in ‘U – Details of OAAC - in the field - Balance as on the Transfer Effective Date’. The amount of interest charged to the account is required to be entered in the field ‘Normal Interest’. If any penal interest is charged to the account, then the split up may be given in the fields ‘Normal Interest and Penal Interest’. Also enter the other fields with appropriate values. It may be ensured that in the field ‘Scheduled Repayment Date’ Original Account Opening Date is entered. In the ‘E – Details of OAAC’ two Repayment Schedules are to be entered as under: 1) First repayment schedule for the Principle amount (which is already repaid) with the Flow Id as ‘PRDEM’. In the field start date enter the date from which the repayment of principle was commenced and in the field ‘No.’ enter the number of installments in which the repayment of principle was made. Enter the frequency in the next field and then enter the installment amount in which the repayment was made in the field ‘Amount’. The press ‘Down Arrow Key’ for entering the interest repayment details. 2) This repayment schedule for Interest amount is to be entered with the Flow Id ‘INDEM’. The ‘Start Date’ is automatically populated by the system for commencement of repayment of interest, which should be checked for its correctness. In the field ‘No.’ enter the number of installments in which the repayment of Interest is to be made. Enter the frequency in the next field and then enter the installment amount in the field ‘Amount’. ACCOUNTING PROCEDURE FOR THE ACCOUNTS WHERE INTEREST AMOUNT IS OUTSTANDING: After opening the loan account in transfer-in mode and after getting the account verified, the following transactions are to be entered through menu option ‘TM’: i. Dr. Term Loan account with the amount of Limit + Interest charged to the account till last interest run date. In the field ‘Value Date’ enter the Original Date of Disbursement or the Original Account Opening Date. In the Additional details, enter the Flow – Id as ‘DISBT’ and the ‘Demand Date’ as the Original Principle Repayment Commencement Date. Cr. Upload account- with the amount as above. ii. Post and verify the transactions. iii. Run the command ‘LAUPLDMD’ for uploading the demands. iv. Dr. Upload account – with the amount of Limit + recoveries made (if any) in the account Cr. Term Loan a/c - with the amount of Limit + recoveries made in the account giving the Flow – Id as ‘TRCOL’ in the additional details and also delete ‘N’ from the field ‘Last Part-tran’ and enter ‘Y’. v. Post and verify the transactions. MAINTENANCE OF SUCH ACCOUNTS The Flow-Id during the account maintenance period for these accounts should be ‘COLEC’ The credit transactions for these accounts should be first posted into the account carrying higher rate of interest. When the principle amount in the loan account carrying higher rate of interest is adjusted, the credits should then be posted to the loan account carrying lower rate of interest.


[88]

This aspect can be checked through the menu option ‘TM – Additional Details’ while entering the transaction itself, where the system shows the details of appropriation of the transaction amount i.e., whether the amount is adjusted to principle demand (PRDEM) or interest demand (INDEM) etc. If it is noticed that the system is adjusting the amount to interest demand (INDEM), before posting the transaction check if any other loan account carrying lower interest rate is outstanding in the borrower employees’ name. If any such account is outstanding then, post the transaction into that account. On complete adjustment of principle outstanding, enter the credit transactions into both the loan accounts carrying lower and higher rates of interest simultaneously by dividing them proportionately as explained above (in E – Details). FINANCIAL TRANSACTIONS IN TERM / DEMAND LOAN ACCOUNTS After opening and verification of the account, the transactions to the account are to be entered through the menu option `TM’ – Transaction Maintenance. On entering the required information in the menu option ‘TM’, the system populates a second screen where additional details such as ‘Flow-Id’ is required to be entered. The following fields form part of the additional details for Term/Demand Loan account transactions: i)

The Term/Demand Loan account number for which transaction is being done is displayed in Loan Account Id field. ii) The number of repayment schedule that is currently active for the account is displayed. iii) The overflow amount if any for the account is shown in Overflow Account field. The overflow amount is the collection (recovery) received over and above the total demands raised in the account till date or the advance recovery if any in the account. iv) FLOW – ID is a Mandatory Field. All the transactions in Term/Demand Loan accounts should be associated with a flow id. Select correct flow-id for the transaction being posted. VALUE DATED TRANSACTION If a value-dated transaction is put to a Term/Demand Loan account, the system will check if the value date is later than the date on which the currently active repayment schedule is specified to the account. If the value date is such that other demands and collections have already been posted after value date, the entire history of demands and collections is reworked and the database updated by the system to reflect the correct picture, which can be viewed by invoking the menu option ‘LAOPI’. The system will also re-calculate the interest in the account during the next interest run date and adjust the excess/less amount of interest if any charged to the account. The information regarding the adjustment of such interest can be taken from the interest application report generated by the system on the interest application date, which is available in the ‘PR’ menu option of the person invoking the interest application process. CLEARING TRANSACTIONS IN TERM/DEMAND LOAN ACCOUNTS All the clearing transactions in the Term/Demand Loan accounts should be routed through Sundries – General Account. Any direct credit of a clearing transaction to a Term / Demand Loan account and subsequent returning of the cheque will lead to incorrect overdue position in the account. REVERSAL OF TRANSACTIONS IN TERM / DEMAND LOAN A/Cs First step: Note down following details from the TM to be reversed: 1) Transaction Number 2) Part Tran Serial number 3) Amount of Transaction 4) Flow ID through ‘A’ details


[89]

5) Value date Second Step: Invoke the menu option TM and enter ‘A – Add’ in the Function field. Enter the Type/Sub Type field as ‘T/BI’ or ‘T/CI’ for Bank induced or Customer induced respectively and . Then enter the account number in which the transaction is to be reversed in the field A/c No and enter the amount of transaction, which is to be reversed in the field Amount. In the field type of part transaction enter ‘D – Debit’ if the credit entry is to be reversed or enter ‘C – Credit’ if the debit transaction is to be reversed. Thereafter enter appropriate particulars in the Particulars field and then enter the field Value Date field with the original transaction date and accept. The system will force the user to enter the Additional Details. In the Additional Details the field flow id should be same as of original Transaction which is going to be reversed.

The system identifies a transaction, as a reversal transaction whenever a debit or credit transaction is entered with same flow id as of original transaction and the transaction is value dated with that of the original transaction. The value in the field REVERSAL FLAG should automatically be changed to ‘Y’. Then the tran id of transaction to be reversed is to be entered in the REVERSAL TRAN ID field. This field consists of three parts, the first is reversal tran id i.e. the original tran id that is being reversed, and the second is the reversal part tran serial number and the third part is the date of original transaction. This field can be entered only if the Reversal Flag field is set to ‘Y’. The option of is available for the transaction id and Explode is available for the reversal date. On entering the required information accept and commit the transaction and get the transaction verified. The system will identify this transaction as a reversal transaction and the effective interest amount debited to the account will be adjusted by the system whenever the interest is run in the account. Similarly, the demands/ collections also get adjusted accordingly. LOAN DISBURSEMENT In Loan accounts, disbursement can be made either through menu option ‘TM’. In case disbursement is made through `LADISB’, the system automatically creates the transaction in the account, posts it and verifies it. Hence, no verification is required. Subsequent and multiple disbursements can also be handled through this menu option. The fields required to be entered in the menu option ‘LADISB’ are as under: FUNCTION: Enter the function code as ‘D – Disbursement’. A/C NUMBER: Enter the account number in which the disbursement is to be made. VALUE DATE: Enter the value date for the disbursement being made in the account. Then to go the next block. The system will display the information regarding Loan Amount, Loan Period, Loan Amount Disbursed and Amount Available for Disbursement in the account. TRAN TYPE: Enter the type of transaction. Valid values are ‘C’ – Cash and ‘T’ – Transfer. DISBURSEMENT AMOUNT: The amount to be disbursed during the process of account opening is to be entered in this field. CREDIT A/C NO. : The account to which disbursement is to be credited.


[90]

CRMS – CREDIT RATING MANAGEMENT There was no provision to capture External Credit Risk Rating details in CBS. In order to capture External Credit Risk Rating, a menu option CRMS has been customized. This provides capturing of data at four level i.e. customer level, Account level, Guarantor level and security level. User has to enter the following input under ‘Rating for’ field for selecting the level for which data is to be capture: 1. CU - Customer 2. AC – Account 3. GU – Guarantor 4. SC - Security User has to capture the external credit risk rating for each level, wherever applicable under the following fields available under CRMS menu option: 1. Rating type : Valid values are DLTR/DSTR/FR a. DLTR - Domestic long term rating b. DSTR - Domestic short term rating c. FR - Foreign rating 2. Rating Agency : This is a code based field and all the valid values will be displayed on F2 help key. 3. Rate code : This is a code based field and all the valid vales will be displayed on F2 help key based on ‘Rating Type’ and ‘Rating Agency’ 4. Rate Desc : Rate description will be displayed automatically on selection of Rate code. 5. Date of Rating: Date field. Actual date of Rating has to be fed. 6. Expiry of Rating Date field. Expiry date of rating has to be fed. For capturing of data for Customer (level – ‘CU’), Customer Id of the customer has to be fed thereafter Customer name will be displayed by the system. For feeding of external credit risk rating for an account (level – ‘AC’) or security attached with the account (level – ‘SC’) has to be fed under ‘Rating for’ field and aforesaid six fields has to be captured. For capturing of data for Guarantor (level – ‘GU’), where guarantor having external rating, guarantee type has to be selected. The guarantee type is a code based field and all the code available under ‘Guarantee cover code’ (under ‘V’ details – for fund based facilities) and ‘Guarantor Type’ (under NFDET menu for Nonfund based facilities) are displayed. System will allow capturing if the code selected under ‘Guarantee Type’ field has already been assigned under ‘Guarantee cover code’ for fund based facilities or under ‘Guarantee type’ field in menu option ‘NFDET’ for Non-fund facilities. Menu option – CRMS There can be following 5 valid Function Codes A – Add I - Inquire M – Modify D - Delete V - Verify A – Add (For type – CU) Here user has to input required data for a customer; help is available on F4 key press


[91]

Valid Data Fields are as under: Field

Inputs

Rate for

CU- Customer/AC- Account/GU-Guarantor/SC-Security

cust_id

to be filled for "Rate For" CU , may be filled for GU ( To be left blank for AC/SC)

Borrower Name

Auto Populated

Account Number

to be filled for AC/SC, may be filled for GU (to be left blank for "Rate For" CU)

Sol_id

Auto Populated

Guarantor Type

To be left blank for CU/AC/SC

in case of Rate for "GU", to be selected from drop down list on F2

Gurr_cust_id-Y/N

in case of Rate for "GU", to set as "Y" if Guarantor Customer details to be filled

Gurr_cust_id

in case of Rate for "GU", and Gurr_cust_id (Y/N) is "Y" then Guarantor Customer Id to be filled (Optional)

Guarantor Name

Auto Populated

Rtype

Rate Type :- DLTR-Domestic Long Term, DSTR- Domestic Short Term, FR- Foreign

Rating Agency

To be selected from drop down list on F2 (example CARE,CRISIL,ICRA etc)

Rate Code

To be selected from drop down list on F2

Rate Desc

Auto Populated

Date of rating

Date of Rating to be filled

Expiry of rating

Expiry date of the rating to be filled.

Guarantee Amt

To be left blank for CU/AC/SC

Guarantee Bank

In case of Rate for "GU" , Guarantee Amount is mandatory

In case of Rate for "GU" , to be filled where Guarantor type is "GUTBI - Bank/Insurance Co"

In Case of GU-Guarantor 1. Either of Account number or Cust_id can be filled (not both) 2. Guarantor details to be filled 3. Guarantee Amount and in case Guarantor type is "GUTBI - Bank/Insurance Co" Guarantee Bank field to be filled. A – Add (For type – GU - Guarantor) A – Add (For type – AC - Account) A – Add (For type – SC - Security)


[92]

I – inquiry (Input function code, Rate for, rating Type, Rating Agency and Cust_id or Account Number) M – Modify (Unverified record can be only modified by the entry user only, after Verification other user can also modify) V – Verify - Verification should be done with user other than the one who has Added/Modified. Verification is must after any of the operation (Add/Modify) D – Delete (Unverified record can be only deleted by the entry user only, after Verification other user can also Delete.) OPENING BACKEND PRINCIPAL SUBSIDY TERM LOAN ACCOUNTS OLAPS – PRINCIPAL SUBSIDY ACCOUNT OPENING – menu has been customized for opening of all new accounts, where backend principal subsidy shall be available. The unique feature of this menu option is that apart from opening the main TL account will be simultaneously open a ‘ Linked subsidy SB account’ and link it to the loan account. At the time of application of interest in loan account, system net off the subsidy amount parked in Linked Subsidy SB account. st

Effective 1 April, 2012 onwards, branches must use this menu option ONLY for opening any new term loan account under any backend principal subsidy scheme. OLAPS– PRINCIPAL SUBSIDY ACCOUNT OPENING: In the ‘Function Code’ field, main options are – A – Add, V – Verify and X – Cancel Function Code Customer ID Scheme Code

: : :

Enter ‘A’ to open a new account Assign the customer ID in this field Press F2 to get the list of scheme codes for which backend Principal subsidy features are enabled. Select the appropriate Code through

LIST OF TL-SCHEME CODES WHERE SUBSIDY FEATURES ENABLED S.NO. NEW SCHEME DESC SCHEME CODE 1 TLADS TL-DAIRY DEVELOPMENT (SUBSIDY) 2 TLASS TL-GOAT/SHEEP (SUBSIDY) 3 TLAMS TL-MINOR IRRIGATION (SUBSIDY) 4 TLAOS TL-AGRI MISC (SUBSIDY) 5 TLIMS TL-SSI-ABOVE 3 YRS REPAYMENT (SUBSIDY) 6 TLRRS TL-SP.CR-RETAIL TRADE (SUBSIDY) 7 TLRSS TL-SMALL BUSINESS (SUBSIDY) 8 TLHLS TL-HOUSING LOAN PUBLIC (SUBSIDY) 9 TLEIS TERM LOAN EQUATED INSTALMENT (SUBSIDY) Whether PMEGP A/c?

EI/ NON EI

NON NON NON NON NON NON NON EI EI

EI EI EI EI EI EI EI

Assigning the correct value in this field is “Very Important” Default value set as “N” which should be retained while opening the a/c except PMEGP. In case account is opened Under PMEGP scheme this flag MUST be modified to “Y”.

Impact of this flag is that when value is retained as ‘N’, the ‘Linked Subsidy SB Account’ will be opened by the system with GL Sub Head as ‘35600 – Subsidy Reserve Fund’. But when this flag is kept as ‘Y’, the ‘Linked Subsidy SB Account’ will be opened by the system with GL Sub Head as ‘10100 – Fixed Deposit’


[93]

After assigning the appropriate value in this field, press . The normal account opening page is opened with cursor on ‘G – General Account Details. All other relevant details, which are usually filled during normal account opening through ‘OAAC’, like ‘S – Scheme Details’, ‘H – Limit History Details’, ‘I –Interest Details’, ‘V – MIS Details’ and ‘E – Repayment Schedule Details’ shall also be filled as per existing guidelines of ‘OAAC’. However, special care should be taken while assigning values in the following fields : S – SCHEME DETAILS:

Repayment Method

The default value – E – Recover from operative a/c upto effective available balance has been set, which should be retained.

Operative A/C ID

A dummy ‘operative a/c – “00000RE00000001” shall be populated by the system, which should also be retained. As subsidy shall be available in these accounts, the value in this field is default populated as ‘Y’ Enter the subsidy amount eligible in the account

Subsidy Available ? Subsidy Amount Subsidy Agency

Select the appropriate ‘subsidy agency code’ from the list shown in this field.

After entering all the relevant details, press to commit the account –opening. The following message – “Record Added” along with Term Loan account number shall be displayed. Verification of Opening of Term Loan Account and Subsidy Linked SB Account: The ‘Verification’ should be done through menu option – OLAPS also. Give value in Function Code as “V” and press . Loan A/c ID field is populated. Give the ‘Loan A/c No.’ generated above in this field and press . Visit all the pages of ‘G – General Account Details’ followed by visiting other options like ‘S – Scheme Details’, ‘H – Limit History Details’, ‘I – Interest Details’, ‘V – MIS Details’ and ‘E – Repayment Schedule Details’. After verifying all these details, press to the verification of account opening. The following screen is opened with a Warning – Customer ID differs from Loan & Operative Account. Please ‘Accept’ it by pressing . The following page is opened confirming that the record has been verified. Now, both the Term Loan account as well as its Linked Subsidy SB account is verified VERY IMPORTANT: From the above page, press twice and the following message – “Account has been Verified Successfully” must be shown by the system. Please note that should be pressed twice, else the verification will be not be complete. In this context, it is informed that in the above process, system complete the following activities: 1. Verification of Loan Account 2. Verification of Linking Subsidy SB Account 3. Debit Freeze the Linked Subsidy SB Account 4. Linking of the ‘Linking Subsidy SB Account’ with the ‘Loan Account’ 5. Replacing the dummy ‘Operative A/c’ <000000RA00000001> at the term loan account level with its ‘Linked Subsidy SB A/c’


[94]

Please note that the account number of the ‘Linked Subsidy SB Account’ is internally generated by the system in consonance with the account number of the Term Loan account by appending “S” at the 9th place i.e. after the ‘Product Code’. To illustrate: Term Loan Account No. 015300SAS0000014

Linked Subsidy SB Account No. 015300SA00000014

Check both these account numbers through menu option – ACI. In Term Loan account, the Linked Subsidy SB account should be shown under option – ‘+ - Notional Pooling Account’ in ACI. Check Linked Subsidy SB account through ACI and ensure that it should show ‘Debit Freezed’. TRANSACTIONS IN TERM LOAN ACCOUNT All the transactions including disbursement, recovery, charges, etc. except subsidy related transactions, in loan account should be done through normal menu option – TM SUBSIDY RELATED TRANSACTIONS: Creating transaction for crediting the subsidy received from subsidy agency: As a first step, the subsidy received in the account has to be credited in ‘Linked Subsidy SB Account’. For doing subsidy related transaction, a new menu option –“TMPS – TRANSACTION FOR PRINCIPAL SUBSIDY” has been released. Every transaction in this account is to be done through this new menu option – TMPS. Please enter the values in TMPS as under: Field

Values to be assigned

Function code

Valid values are A – Add, V – Verify and X – Cancel. To add a record, enter ‘A – Add’ in this field

Loan Account No

Although the subsidy is being credited into ‘Linked Subsidy SB Account’, but branches must enter the ‘Term Loan Account’ in this field to which this subsidy relates. Please enter the complete 16 digits Term Loan account number. In no case, the Linked Subsidy SB Account should be entered in this field.

Tran Type

Enter ‘C’ to credit the subsidy in ‘Linked Subsidy SB Account’

After entering the above values, press . And following details should be entered in next screen: Field Subsidy Amount – INR Subsidy Agency Code Subsidy Recd Date

Lock in Period – Mnths Source Account Value Date


Values to be assigned Enter the amount of subsidy received Select the appropriate Subsidy Agency Code from the available on this field Enter the date on which subsidy is received. The date format should be DD-MM-YYYY Enter the number of months as per the ‘Lock in Period’ prescribed in the scheme Enter the account number which is to be debited Enter the ‘Date’ from which the effect of netting off the Subsidy Amount is to be given in loan account for charging of interest. The date format should be DD-MM-YYYY In case the subsidy is received subsequent to opening of loan account and effect of netting off is to be

[95]

given from the ‘Account Open Date, the value date given should be that of ‘Account Open Date’. In this case, system will re – calculate the interest from the beginning by giving the effect of Subsidy Amount. On pressing , the following message, showing that transaction has been added successfully, will be displayed by the system. POSTING/ VERIFICATION OF THE TRANSACTION FOR CREDITING THE SUBSIDY RECEIVED FROM SUBSIDY AGENCY: Field


Function code Loan Account No.

Enter ‘V to Verify the transaction

Tran Type

Please enter the complete 16 digits term loan account number in this field Enter ‘C’ to credit the subsidy in ‘Linked Subsidy SB Account’

On pressing F4 twice One more screen will opened showing Tran ID having posted it successfully. CAUTION: In no case the transaction in Linked Subsidy SB Account should be done through menu option TM. APPROPRIATION OF SUBSIDY IN TERM LOAN ACCOUNT: Guidelines for appropriating/ crediting this ‘Subsidy Amount’ into ‘Term Loan Account’ by debiting/ transferring it from the ‘Linked Subsidy SB Account’. There can be following scenarios for appropriating the subsidy into Term Loan Account: (i) Appropriation of Subsidy after the ‘Lock in Period’ and, (ii) Appropriation of Partial Subsidy Amount before the ‘Lock in Period’. (iii) Closure of Term Loan Account before Lock in Period. (iv) Refund of complete Subsidy Amount to Subsidy Agency. It is reiterated that all subsidy related transactions must be done through menu option – TMPS. appropriation of subsidy, the ‘Tran Type’ should be assigned as ‘D – Debit’.

For

IN NO CASE, SUBSIDY RELATED TRANSACTION SHOULD BE DONE THROUGH TM MENU OPTION. OLAPS: OPENING OF TERM LOAN ACCOUNT AND SUBSIDY LINKED SB ACCOUNT – RELATED ISSUES: In these guidelines, branches were advised to use a new workflow menu option – OLAPS. Based on the issues received it is observed that branches are not following the guidelines on opening of Term Loan account through OLAPS and its ‘Verification’, resulting issues like ‘Linked Subsidy SB Account’ is not opened/ Term Loan account and Linked Subsidy SB Account are not properly linked/ Linked Subsidy SB Account is not freezed / TMPS issues, etc. are encountered. Take utmost care at the following steps of account – opening process through OLAPS: •

During OLAPS – ADD process, after entering all the relevant details, press to commit the account – opening of Term Loan. Once the message – “Record Added” is shown by the system along with Term Loan account number, the user must press twice and ensure that cursor


[96]

comes out at menu option box. This last step ensures that all the account – opening activities have been ‘Entered’. •

During OLAPS – VERIFICATION process, after verifying all account – opening (OAAC) details of Term Loan, press to the verification of TL account opening. Thereafter, accept the Warning “Customer ID differs from Loan & Operative Account” by pressing . System shows message at bottom – ‘Record Verified’.

(I) APPROPRIATION OF SUBSIDY AFTER THE ‘LOCK IN PERIOD’: It is reiterated that all subsidy related transactions (Credit or Debit) must be done through menu option – TMPS. Hence, user must invoke this menu option for doing debit transaction. Field Description of TMPS Menu: Field


Function code

Valid values are A – Add, V – Verify and X – Cancel. To add a record, enter ‘A – Add’ in this field

Loan Account No.

Although the subsidy is being debited from ‘Linked Subsidy SB Account’, but branches must enter the ‘Term Loan Account’ in this field to which this subsidy relates. Please enter the complete 16 digits Term Loan account number. In no case, the Linked Subsidy SB Account should be entered in this field.

Tran Type

Enter ‘D’ to debit the subsidy in ‘Linked Subsidy SB Account’ and Press F4

On the date of appropriation of subsidy, system validates whether debit is happening before or after the Lock in Period on the basis of ‘Subsidy Receive Date’ and ‘Lock in Period’ that had been entered at the time when subsidy was credited into ‘Linked Subsidy SB Account’. The following values should be entered in these fields: Field Values to be assigned Close or Adj Debit

Closure Or Adjustment Debit can be C-Closure or D-Intermediate Debit. Since, subsidy is being debited after lock in period, select C – Closure so that system should simultaneously close the Linked Subsidy SB A/c also.

CLOSURE METHOD

Closure Adjustment Method can be P-Pro Rata or C-Complete. Enter C Complete only as the debit is happening after lock in period and press F4 (#)

ADJ

Linked Sub Acct

The corresponding Linked Subsidy SB Account is default populated by the system in this field.

Loan Acct No

The Term Loan Account is default populated by the system in this field.

Subsidy Adj Amt

System by default populates the subsidy amount outstanding in Linked Subsidy SB A/c.

Loan Adj Amt

System by default populates the subsidy amount outstanding in Linked Subsidy SB A/c.

Subsidy Refund Acct Subsidy Refund Amt

This field is protected by the system This field is also protected by the system


[97]

Now again press on which the system gives the message - “Debit Subsidy Added Successfully”. – (VERY IMPORTANT). (#) Important Note: After entering ‘C’ in Close or Adj Debit and Closure Adj Method fields and on pressing , system gives the following ‘Alert’ message – “Maintain value for Subsidy refund account in the variable SUB_REFUND_ACCT using SETVAR”. Ignore this message and press ‘OK’. TMPS – VERIFICATION: The Posting/ Verification of the subsidy – debit transaction has to be done by the authorized user through menu option - TMPS itself by entering the following values: Field


Function code

Enter ‘V to Verify the transaction

Loan Account No.

Please enter the complete 16 digits term loan account number in this field

Tran Type

Enter ‘D’ to verify the ‘Debit’ of subsidy in ‘Linked Subsidy SB Account’ and press .

On pressing F4 Twice system will generate Tran ID which is confirmation of subsidy appropriation. Please check that subsidy amount is transferred from Linked Subsidy SB Account to Term Loan Account and Linked Subsidy SB Account is “Closed” by the system. CAUTION: Please note that in no case the transaction in Linked Subsidy SB Account should be done through menu option – TM (ii) APPROPRIATION OF PARTIAL SUBSIDY AMOUNT BEFORE THE ‘LOCK IN PERIOD’: There can a requirement for appropriation of partial subsidy amount into Term Loan Account before the ‘Lock in Period’. The module has the flexibility of handling this requirement also and for which the branches must follow the procedure as detailed below. User must invoke the menu option – TMPS for doing debit transaction. ON THE SECOND SCREEN, THE FOLLOWING VALUES SHOULD BE ENTERED IN THESE FIELDS: Field Values to be assigned Close or Adj Debit

Since, partial subsidy amount is being debited before the lock in period, select DIntermediate Debit and press F4.

CLOSURE METHOD

This field gets protected by the system

ADJ

Linked Sub Acct


Loan Acct No Subsidy Adj Amt

Loan Adj Amt

The Term Loan Account is default populated by the system in this field. On pressing F4 as stated above, system gives a message – “Subsidy Adjustment Amount Cannot be 0”. Hence, enter the partial subsidy amount to be appropriated in this field. System will not accept the full subsidy amount outstanding in Linked Subsidy SB account This field also gets protected by the system

Subsidy Refund Acct Subsidy Refund Amt

This field also gets protected by the system This field also gets protected by the system

Now after giving values in Subsidy Adjustment Amount field, again press on which the system gives the message - “Debit Subsidy Added Successfully”. – (VERY IMPORTANT).


[98]

TMPS – VERIFICATION: The Posting/ Verification of the subsidy – debit transaction has to be done by the authorized user through menu option - TMPS itself by following the verification procedure. The Authorizing User must press again to confirm the subsidy appropriation. Please note that in this case, some subsidy amount shall remain outstanding in Linked Subsidy SB Account and system will allow the user to debit the same only after the Lock in Period. (III) CLOSURE OF TERM LOAN ACCOUNT BEFORE LOCK IN PERIOD: There can a scenario where the Term Loan is required to be closed before the Lock in Period and subsidy on pro – rata basis is required to be appropriated in Term Loan account. The present module has the flexibility of handling this requirement also, where in pro rata subsidy from the ‘Date of Subsidy Receipt’ till ‘Date of Appropriation’ (before Lock in Period) is credited into the Term Loan Account and balance subsidy is credited into a Subsidy Refund Account. As stated above, the user must invoke the menu option – TMPS for doing debit transaction. On the second screen, the following values should be entered in the respective fields: Field


Close or Adj Debit

Since, the entire subsidy amount is to be debited and Linked Subsidy SB account needs to be closed simultaneously before the lock in period, select C - Closure and press F4. System gives a Warning: “Closure is happening before Lock In Period. Closure Adjustment Method should be entered”

CLOSURE METHOD

Press OK to the above warning. The value in this field is default populated as ‘P – Pro rata’, which should be retained and again press F4. (#)

ADJ

Linked Sub Acct


Loan Acct No Subsidy Adj Amt

The Term Loan Account is default populated by the system in this field. On pressing F4 as stated above, system populates the full subsidy amount outstanding in Linked Subsidy SB account in this field.

Loan Adj Amt

System populates the ‘Pro rata’ subsidy amount which is required to be credited into Term Loan

Subsidy Acct

Refund

Enter a valid SB/ CA accounts into which the subsidy refund amount shall be credited by the system and press F4 finally.

Subsidy Amt

Refund

System populates the ‘Pro rata’ subsidy amount which is required to be refunded.

(#) Important Note: After entering values in Close or Adj Debit and Closure Adj Method fields and on pressing , system gives the following ‘Alert’ message – “Maintain value for Subsidy refund account in the variable SUB_REFUND_ACCT using SETVAR”. Ignore this message and press ‘OK’. TMPS – VERIFICATION: The Posting/ Verification of the subsidy – debit transaction should be done by the authorized user through menu option - TMPS itself by following the verification procedure. The Authorizing User must press again to confirm the subsidy appropriation.


[99]

(IV) REFUND OF COMPLETE SUBSIDY AMOUNT TO SUBSIDY AGENCY: The module can handled complete refund of Subsidy Amount to Subsidy Agency before Lock in Period. For this, in TMPS – Add mode, the following values should be assigned in Debit transaction: Field


Close or Adj Debit

Since, the entire subsidy amount is to be debited and Linked Subsidy SB account needs to be closed simultaneously before the lock in period, select C - Closure and press F4. System gives a Warning: “Closure is happening before Lock In Period. Closure Adjustment Method should be entered”

CLOSURE METHOD

ADJ

Press OK to the above warning. The value in this field should be modified to ‘C – Complete’ and again press F4.

Linked Sub Acct


Loan Acct No

The Term Loan Account is default populated by the system in this field.

Subsidy Adj Amt

On pressing F4 as stated above, system populates the full subsidy amount outstanding in Linked Subsidy SB account in this field.

Loan Adj Amt

This field gets protected by the system.

Subsidy Refund Acct

Enter a valid SB/ CA accounts into which the subsidy refund amount shall be credited by the system.

Subsidy Refund Amt

Enter the complete subsidy amount which is required to be refunded and press F4 finally.

TMPS – VERIFICATION: The Posting/ Verification of the subsidy – debit transaction should be done by the authorized user through menu option - TMPS itself by following the verification procedure explained above. The following page will open up. The Authorizing User must press again to confirm the subsidy appropriation OPENING A DEMAND LOAN ACCOUNT The Demand Loan Accounts are opened under the scheme codes defined under scheme type LAA as is done in the case of Term Loan Accounts. The procedure to be followed for opening is same as Opening a Term Loan Account. However, the details to be entered in the repayment schedule for a Demand Loan Account may vary, as the demands are required to be raised by the system on the date of maturity of the security. Therefore the fields to be entered in the sub option ‘E – Repayment Schedule Details’ of the menu option ‘OAAC’ will be as under: OPTION 'E' – REPAYMENT SCHEDULE: The system by default populates `PRDEM’ in the FLOW ID field, which should not be modified. In the field START DATE enter the due date of the security in the Demand Loan account. Then, enter ‘1’ in the NO. field, which denotes single installment. Specify the Frequency of repayment in the field FREQUENCY as under: 1st column: 4th column:

D – Daily, 2nd column : Should be left Blank, 3rd column : Should be left Blank Should be left Blank, 5th column: Should be left Blank

In the field AMOUNT enter the principle amount of the respective security i.e. the value of the security less margin if any. In case there are more than one security then, press arrow down key and repeat the process for the second and subsequent securities.


[100]

It must however be ensured that the repayment schedule starts with the earliest due date of the security and the due dates of the subsequent securities should be in the ascending order. There is no restriction on the number of repayment schedules being entered for an account except for the condition that the due dates should be in the ascending order. WORKING CAPITAL DEMAND LOAN ACCOUNTS The procedure for opening a Working Capital Demand Loan account is same as that of opening a Demand/Term loan account. The following deviations are to be followed in the procedure for opening a Working Capital Demand Loan Account. The Scheme Code for opening a Working Capital Demand Loan should always be ‘DLGEN – Demand Loan General’. However, if the interest charged/ the principle due in the WCDL Account is to be recovered automatically by the system from the connected Cash Credit Account then the following set up is required to be made in the ‘S – Scheme Details’ of the account opening: REPAYMENT METHOD: This field should contain any of the following values as per the requirement: E – For recovering the interest charged/principle due in the WCDL account from the Cash Credit account to the extent of available balance. T – For recovering the interest charged/principle due in the WCDL account by allowing a temporary overdraft in the Cash Credit account to the extent of shortfall. OPERATIVE ACCOUNT No.: Enter the connected Cash Credit Account number in this field from which the interest charged/principle dues in the WCDL account are to be recovered. The system will recover the interest as and when charged to the WCDL account from the Cash Credit Account when the aforesaid set up is made in the account opening and when a batch process is run using menu option LADSP. Similarly the system will also recover the principle dues in the WCDL account on the due date from the Cash Credit Account, unless the WCDL is rolled over before the due date. The procedure for the roll over of the WCDL account is given in the next chapter. As the repayment method for the WCDL account is different from any Demand Loan account, the details in the sub option ‘E – Repayment Schedule Details’ should be entered as under: FLOW ID – The system by default populates a PRDEM, which is applicable for the scheme. The flowId displayed by the system need not be modified. START DATE: Enter the date on which the repayment of WCDL amount falls due in this field. NUMBER: Enter the value ‘1’ in this field. FREQUENCY: In the first column of this field enter ‘D – Daily’ as the frequency for the account. All the other columns should be left blank. AMOUNT: Enter the Principle amount in this field. DEL: The system allows deletion of a wrong repayment schedule before verification of the account. In order to delete the record the valid value is Y else N. After entering all the other applicable fields, commit the account opening note down the account number and get the account verified. VERIFICATION OF A TERM / DEMAND LOAN ACCOUNT Invoke the menu option ‘OAACAU’ and enter `V’-Verify in the function field. However, Modification of the account details is also possible through this menu option but before verification of the account. For this, invoke the function-`M’-Modify in the function block instead of `V’. As a part of the verification process, all the sub options are to be visited,


[101]

Special attention should be paid while visiting certain important sub options viz. S – Scheme Details, E – Repayment Details, V – MIS Codes, H – Limit History Details, 3 – Disbursement Tran Details. On commit the system displays a message about the transaction details, which is created for disbursement of the loan amount (if disbursement is done as a part of the account opening process through sub option 3). Note down the transaction id for future reference and accept to verify the account number. MAINTENANCE OF TL & DL ACCOUNTS For maintenance of the loan accounts invoke menu ACM for modification of general information of the account except Limit and Interest details. In modification mode the following details can be modified: 1. 2. 3. 4. 5. 6. 7.

General details with sub option “0” Related party details with sub option “A” Scheme details with sub option “S” MIS codes with sub option “V” Repayment schedule with option “E” Disbursement schedule with option “D” Message maintenance with option “L”

These modifications needs to be verified through ACM (V) INTEREST RELATED MODIFICATIONS Invoke menu 'INTTM' for changing any of the interest related parameters including pegging and preferential interest rates. After modifying the required information, commit. verification to be done by same option same. LIMIT RELATED MODIFICATIONS The changes to the limits should be done through menu 'ACLHM'. This menu has two operations – modifications to sanction limit and modification to drawing power details. In the ACLHM menu option indicate operation as “S” or “D” Modification of the sanction limit will check whether the amount already disbursed will cover the new sanction limit or not. Supercede field is not accessible and value will always be “Y”. After modifying the details accept and commit. This modification requires verification. In order to modify the drawing power details the operation should be “D” in the first screen of ACLHM menu option. Accept from the function block to go to data block. After modifying the details accept and commit. The modification requires verification. REPHASEMENT OF A LOAN Re-scheduling the loan can be done in two ways. 1. Re-schedule loan 2. Correcting the schedule already given. This option is based on ‘Re-phasement ?’ Flag of ACM menu option. If the Rephasement Flag is ‘Y’, then choose option 1 otherwise choose re-schedule option 2. The re-phasement of the loan has to be done individually for non EI type of loans using the ACM – Account maintenance option. In modify mode invoke sub option “E” – Repayment schedule, cursor will be placed in the field “Rephasement?”.


[102]

Indicate a value “Y” here and . The system will show repayment schedule block make necessary changes and commit. Ensure that the total repayment amount is equal to the liability as on the date of rephasement. The start date for repayment should be greater than BOD date. The system will not insist for up to date calculation of interest care should be taken for arriving at the actual liability before rephasing the loan. This modification requires verification. After verification go in inquire mode and see the different repayment schedules for the account. The system by default shows the latest repayment schedule and the cursor will be in the dummy block of repayment schedule details. Explode from that position will show the previous repayment schedule. If there are more than 2 repayment schedules go on exploding from one schedule to another schedule till the original repayment schedule is displayed. The same procedure should also be followed for rephasement of EI based loan accounts on account of any reason other than changes in Interest Rates and/or Prepayment (Advance Recovery). REPHASEMENT OF EI TYPE OF LOAN A/CS-- MENU OPTION 'REPHASEI' The menu option REPHASEI has been modified to rephase the accounts where the scheme type is LAA and the scheme code must be of EI type. This menu option will rephase the accounts: i) where there is a change in the rate of interest applicable in the accounts ii) where there are pre-payments (advance recovery) in the accounts. In case of any other scenario where rephasement of an EI based account is required, the existing procedure of rephasing the account using menu option ACM – E - Repayment Schedule Details, as applicable to the Non-EI based loans is to be followed. FUNCTIONALITIY On executing the menu option REPHASEI, While there are no changes in the functionality of the fields Service Outlet, Scheme Codes, Currency Code, Product Group, Start A/c No. and End A/c No., the other fields where the functionality has been modified are as under: Adjust Amount/Period: Enter ‘A’ - For Changing EI amount and keeping period same, or enter ‘P’ For Changing period and keeping EI amount same. Interest Rate Change: Enter 'Y' if rescheduling is to be done for interest rate change, otherwise enter 'N'. Prepayment: Enter 'Y' if rescheduling is to be done due to prepayment, otherwise enter 'N'. Date Range From/To: Accounts for which either prepayment or interest rate change happened during the date range entered in these fields will be selected for rephasement. The same procedure should also be followed for rephasement of EI based loan accounts on account of any reason other than changes in Interest Rates and/or Prepayment (Advance Recovery). LOAN MODELING Prior to opening or during re-schedulement/ re-phasing of a loan account, there is a need to evaluate various options that are possible/ available and choose the one, which suits. This requirement has been addressed through menu option 'LAMOD' which will perform a What If Analysis for various scenarios. Typically a loan is characterized by the following variables and the requirement would be to know one of them given others. The variables are: 1. Loan period 2. EMI amount 3. Principal amount 4. Interest Rate LAMOD is the menu option that can compute the unknown variable based on the value of the others. Once the unknown parameter is computed the repayment schedule is also printed. LAMOD can be used to arrive at the instalment amount (or any other unknown parameter of a loan a/c–namely, Loan amt, intt. rate, no of instalments) given all the other parameters :


[103]

1) Once the unknown parameter is arrived upon, LAMOD the system will generate the repayment schedule also. 2) If the repayment date is after the loan sanction/disbursement date, the intermediate period is assumed as repayment holiday and only the interest component is calculated for such period 3) This tool can also be used for existing accounts that are being rephased to calculate the prepayment amount, changed instalment amount FEATURES On executing the menu option LAMOD, 2 options available in this menu 1. Loan Modelling 2. Loan Rescheduling LOAN MODELLING This option (1) is to be used for modelling a new loan account. The following fields need to be entered so as to be able to calculate the unknown loan parameter: Origination date - This is the loan account opening/disbursement date. It is defaulted to BOD date but it can have future/past dates also. Loan Amount, No. of Instalments, Interest Rate, Instalment Amount are the four basic loan parameters. Given any three the value of the fourth parameter can be calculated. All the other fields in the second part of the screen can either be entered, or the Scheme code can be specified and the other values will be taken from whatever has been setup at Scheme level. If the interest rate is not entered, then the interest rate is selected from the Scheme Code if entered for computation. If the Scheme code as well as other parameters are entered, then the defaulted values of the scheme are overridden with the values entered on the screen and computation is done accordingly. EI Payment Frequency, Compounding Frequency, may be entered as per the requirement. However, EI Formula Flg must always be ‘M – EMI formula’ which is applicable. Interest Base Method should always be ‘D – Daily’ while the No. of Days in a Year and Leap Year Adjustment as displayed may be retained. Once the unknown parameter of the loan is calculated, the amortization schedule can be seen with an explode from the first screen. On this second screen, the Installment Start Date can be entered (it will be defaulted to the loan origination date) . If the Installment Start Date is after one installment frequency from the Loan origination date (there is a holiday period) then the value of the field “Apply Full Period Interest” is not of any significance. However when there is no holiday period (the first installment is within one frequency of the loan origination date), then if Apply Full Period Interest = Y Then for a loan origination date - 10/12 , Instalment start date - 20/12 , An entire months interest will be computed for the 10days between loan origination and instalment start date. If the flag is set to “N” then only 10 days of interest will be computed. LOAN RESCHEDULING This option (2) is to be used for modelling an existing loan account for rescheduling/ rephasing. The following fields need to be entered so as to be able to calculate the unknown loan parameter: Account No – The account for which rescheduling has to be done, Reschedule Date – The date as of which rescheduling has to be effective. This date has to be greater than or equal to BOD date. Calc Int upto Reshdl. Dt - This field has relevance only if capitalize interest = Y, what this means is that if Calc Int upto Reshdl. Dt = Y, the interest upto current date will also be included in the rephasement principal. However if Calc Int upto Reshdl. Dt = N, this interest will not be included in the rephasement principal. However, if capitalize interest = N, then the value of Calc Int upto Reshdl. Dt is of no significance.


[104]

The following fields are displayed and can be manipulated for an account that has to be rescheduled. Given any of the three parameters, the fourth one is calculated. No. of Installments Interest Rate Installment Amount Prepayment Amount The other parameters are default populated from scheme level and the functionality is the same as for loan modeling. Details of Outstanding loan amount are available on explode from the field “Loan Outstanding” LAMOD LIMITATION In cases where the unknown variable is Interest Rate, modelling will be restricted only to cases where EI and Int. Calc frequency are same. Rephasement modelling cannot be done for an account with a multiple repayment schedules. INTEREST CALCULATION ON LOAN ACCOUNTS Interest Calculation depends mainly on the set up done at Scheme Level. System calculates interest which are of Normal, Penal and Additional. QIS and Stock statement interest are not applicable for Loans scheme type. Interest calculation is a process which is affected during the following events: i) ii) iii) iv) v) vi)

Account opening to arrive at the EMI Re-phasement of loan Demand creation (EMI type of accounts) Normal interest calculation through the menu option Upload of demands Account closure

A menu option LADGEN is provided which can be used to raise both principal and interest demand for loan accounts. Accrual and booking for loan accounts can be done through ACACCR and ACBOOK menu options respectively. SALIENT FEATURES The following changes are made for the merger of principal and interest demand generation of loan accounts: The new menu option LADGEN is provided which will generate both principal and interest demands based on the frequency set in the ‘E - Repayment Schedule’ details for principal and interest in the menu option OAAC/ACM. The option 'LAUPLDMD' generates principal demands only for Non-EI type of accounts. Interest demand frequency and next interest demand date will be captured in the menu option OAAC/ACM – E - Repayment Schedule Details. The corresponding fields present in G - General Details of OAAC/ACM not to be used for loan account interest calculation. On invocation of the menu option LADGEN, the following reports will be generated : 1) Detailed list of EI (Equated instalment) amount for the EI Based Loan accounts and the details of the Principal and Interest demand amounts for Non-EI based loan accounts sol, scheme and currency wise for the accounts processed. 2) Failure Report for the accounts where the demand generation has failed. 3) Interest Detail Calculation Report which is similar to the Interest Success Report generated through menu option ACINT. 4) OFTI – Post Report giving the details of the transactions created in the process.


[105]

FUNCTIONALITY OF MENU OPTION 'LADGEN' Valid values to be entered in the fields are as under :--> Report to - Name of the person to whom the report is to be addressed. Sol Set Id – Accounts selected for demand generation depends on the sol set id specified. By default Home Sol Id is populated which should not be modified. Currency Code, Scheme code, From Account, To Account – These are captured for filtering the accounts that are selected. Trial mode – Demand generation can be run in trial mode, if this flag is set to Y - yes. In trial mode only reports will be generated. The system will do all operations in trial mode except database commit. This utility is enabled to identify the error messages if any prior to actual run. Print Interest Details – This field will accept three values i.e., D – to print Detailed report / S – to print only Summary of Interest Report / N - No Interest report is required. The system generates both summary and detail report for interest calculated if the field is entered as D and generates only summary report if it is set to S and No Report will not be generated if it is set to N. Include NPA accounts – The valid values in this field are I - Include/ E - Exclude/ O - Only. The system will include NPA accounts if it is set to I, rejects NPA accounts if it is set to E and selects only NPA accounts if it is set to O. Include Disabled accounts. - The valid values in this field are I - Include/ E - Exclude/ O - Only. The system will include Disabled accounts if it is set to I, rejects Disabled accounts if it is set to E and selects only NPA accounts if it is set to O. Force Interest run - When Force interest run is set to Y - Yes, only interest calculation will be done till BOD date irrespective of the frequency specified and No Principal demands will be raised. Hence for all the loan accounts this menu option should be run by setting this flag as ‘N’. 1) 2)

In case of EI based Loan accounts where installment amount is a combination of principal and nterest parts, it must be ensured that the Force interest run flag is always set to ‘N’. However, for the purpose of rephasing of EI based loan accounts where it may be required that interest is run up-to-date, this flag may be set as ‘N’.

DEMAND GENERATION OF LOAN ACCOUNTS The menu option LADGEN will generate both Principal and Interest demands based on the frequency set in the Repayment schedule details of ACM. The frequency set can be different for principal and interest demands can be different for Non-EI based Loan accounts and if they are different, either principal or interest whichever falls due on the BOD date will be processed and demands will be raised accordingly. However, in case of EI based Loan accounts, the Flow start date & Frequency set up for Principal and the set up for the Interest in the Interest Demand date & Frequency should not be different. The important features/ limitations in demand generation process for the loan accounts :--> 1)

For Non-EI accounts, even if interest demand generation fails, principal demand will be raised. But for EI accounts, if one of the demand creations fails, no demands will be raised except where force interest run flag is set to Y. 2) Earlier for compounding of interest to happen correctly, it was expected that interest calculation for each frequency period was to be run through ACINT menu option separately. Presently, the menu option LADGEN will also work the same way as was in ACINT. This requirement can be achieved by running LADGEN with ‘Force interest run’ flag set to Y and by entering the date up to which the interest has to be calculated in the filed ‘Interest Till Date’. With Force interest run flag as Y, it will be mandatory to enter Value Date. If Force interest run is N, then value date will not be considered in demand generation.


[106]

IMPORTANT POINTS the ‘E – Repayment Schedule Details’ should be correctly filled especially in case of EI type of accounts, whether opening a fresh account or opening the account in Transfer In mode. Ensure that Disbursement is made in all the accounts (i.e. with flow_id = ‘DISBT’). Valid Interest Table Codes are not assigned in the accounts while opening accounts by the branch (normal as well as transfer-in) or while doing subsequent modification through INTTM. All the loan accounts with ‘0.00’ balance should be checked and if warranted, the account should be closed. While opening loan accounts in ‘Transfer In’ mode please ensure:---> Data in ‘U- Un-computerised Details’ should be entered correctly, particularly, ‘Repayment Schedule Date’ in ‘U- Un-computerised Details’ should be equal to ‘Account Open Date’ in ‘G – General Account Details’. The menu options – LAUPLDMD/ EIUPLDTI should be executed successfully i.e. ‘Procedure Completed’ message is shown by the system, The status of the account should be completed i.e. the ‘Last Part Tran Flag’ should be made .‘Y’. In Loan accounts where partial disbursement has been made and advance recoveries are received, the Demand Generation and Interest Application should be regularly checked. All the Interest Success Reports/ Interest Failure Reports/ Demand Generation Success Reports and Demand Generation Failure Reports should be saved and checked. All Failure Reports should be meticulously checked and corrective action be done. All ‘Revenue Related Reports’ in ‘RAUDIT’ should be regularly generated and checked. UPDATION OF FINACLE NEW VERSION 1) Multiple limits can be added/modified through ACLHM 2) Additions/Modifications through menu option INTTM can be viewed by the authoriser. 3) In the menu option SRM, the verifying authority can view the accounts pending for verification. 4) The values of security in SRM can be 0.00 now as required by the Asset Recovery Branches. 5) SRM cannot be attached on a matured FDR. 6) The system will prompt the user if a more than 1 SRM record is being added to an account. 7) If node/account is attached to a node of another branch through LNM, the system prompts a message. 8) LTL will display the list of nodes pertaining to the users’ home Sol_Id only. 9) ACS is enabled to list the accounts with – Sector Code, Sub-sector Code and Occupation Code. 10) In ACLHM under D – Drawing Power Details it is necessary to enter both the values in ‘DACC absolute & percentage’ fields for validation of DACC limits else the system shall not validate if only one value is entered. 11) Reversal of DI in excess of the original amount lying in the Sundry Provision NPA account has been restricted. ACCOUNT INTEREST DETAILS INQUIRY – ' AITINQ' The menu shows the details of interest run / booking in the account. It can be viewed through menu ‘acm’ with sub-option ‘?’. Navigation has been provided to ascertain the position of normal, penal, additional and other interests. By exploding the screen. Details of normal, penal, additional and overdue interest can be ascertained by simply exploding the screen


[107]

PRINTING OF INTEREST CERTIFICATE IN HOUSING LOAN An Interest Certificate may be issued to the borrower (s) who have availed housing loan from the bank for availing benefits under the provisions of Income tax act, for the complete financial year on actual basis. The above interest certificate be generated from Finacle Sysem as under: 1) For all housing loan accounts except the accounts (i) where repayment has not started; and (ii) rephasement has been done consequent upon expiry of moratorium period – The Interest Certificate be generated in MIS Server under ‘PNBRPT 3/56c’ by providing the following basic inputs: (a) 16 digit Housing Loan Account number (b) Period for which certificate is required. 2) For Housing Loan accounts (i) where repayment has not started; and (ii) re-phasement has been done consequent upon expiry of moratorium period – The Interest certificate be generated by invoking menu Option ‘INTCERT’ in Finacle. The interest certificates can be printed after invoking the menu INTCERT. Limitation of above menu is that previously printed records will not be printed in a subsequent run of a normal print request. These can be printed through a request for duplicate print. NEW REPORT – 'INTPROOF' This menu option is provided to generate report for a particular period for which interest run has already taken place. Menu ‘INTPROOF’. Proofing works for SB/CC/OD/CA types of accounts. Proofing is not applicable if recalculation happens across cycles in case of compounding, Proofing does not work for the DEBIT runs on migrated accounts for the period in the earlier versions. PRINTING OF INTEREST RATE CHANGE ADVICE-- 'INTADV' 1) 2) 3) 4) 5) 6)

On invoking the menu INTADV, the system will generate a letter addressed to the customer informing him the change in interest rate. Above facility has also been provided in the menu INTTM, where the interest rate code are changed, However to enable above facility set some parameters, which are as under in, sub-option ‘A’ of menu ‘ACM’. ‘Interest Change Advice Flag’ and ‘Interest Certificate Print Flag’ has to be set as ‘Y’ to avail this facility. These two flags will be defaulted to ‘Y’ for all existing Main account holders at the time of migration. If required, the advice can be generated for pegged accounts also during INTTM verification. The option of not taking the report at this stage is available.

LAFHM - LOANS FOLLOW-UP HISTORY MAINTENANCE History of correspondence made with the customer on the reminders sent for regularisation of the account, can be maintained in the system. The menu option to be invoked to input this information is ‘LAFHM – Loan Follow-up History Maintenance’. FUNCTION: The options available in this field are: A – Add, C – Copy, D – Delete, I – Inquire, L – List, M – Modify and U – Undelete.


[108]

A/C NO: Enter the account number NOTICE ID: The following Notice Ids are to be used for different purposes:-Notice Id REM1 REM2 REM3 NOTICE DATE: REMARKS:

Purpose For issuing first reminder in the account For issuing second reminder in the account For issuing third reminder in the account Enter the date on which the notice was sent. Enter the remarks if any, may be entered here.

On entering the required information and on accepting and committing, the system will generate the reminder for the account entered, which should be printed and dispatched to the borrower. GENERATION OF A COMMON REMINDER FOR ALL THE IRREGULAR A/Cs It is also possible to generate a common reminder in all the irregular Term/Demand Loan accounts through menu option ‘LAODR' – Loan Overdue Demand Reminder/Report’. After entering the required criteria, accept, enter the print parameters and commit. The system will generate the required report/reminder, which may be printed and the reminders may be dispatched to the concerned borrowers. It must be ensured that the correct and current address of the borrower is entered in the sub option ‘G – General Details’ of the menu option ‘CUMM – Customer Master Maintenance’ for the Cust Id of the borrower. Further, if the reminder is also required to be printed to the guarantor(s) in the account, then it must be ensured that the field ‘Print Loan Notice?’ is set to ‘Y’ and correct and current address is entered in the sub option ‘A – Related Party Details’ of OAAC/ACM menu options of the concerned account. SECURITY & BALANCE CONFIRMATION MAINTENANCE For entering the Date of Security and Balance Confirmation Letter obtained in an account invoke the menu option ÀCM- Customer Account Maintenance’ and the sub option ‘M – Modify’. In the option block enter ‘S’ and press F4. In the field ‘Debt Acknowledgement Date’ enter the Date of the Security and Balance Confirmation Letter and press F4 and F10. This Modification requires verification. RECALLED ACCOUNTS MAINTENANCE For marking a Term/Demand Loan account as RECALLED, invoke menu option ‘ACLHM – Account Limit History Maintenance’ sub option ‘M- Modify’, Enter the account number and value ‘D’ in the field ‘Operation’. Modify the A/c Recalled field in the next screen by substituting ‘N’ with ‘Y’ and commit. This modification requires verification. HANDLING TERM LOANS WHERE INTEREST IS PARKED IN OFFICE A/CS IN CBS The education loan/staff housing loan/staff vehicle loan a/c is to be opened under scheme code ‘TLRED, TLSHL and TLSVL, respectively, using menu option ‘OAAC’, as hither to. The normal procedure for opening the account in CBS is to be followed. However, the following parameters should be given special consideration during opening of the a/c;


[109]

S details - Debit Int. To - ‘O’ – office a/c is default populated, It should not be modified

Effect:- Interest will be debited to office a/c and not to loan a/c. The office a/c here means partitioned account, where simple interest is Parked, during the moratorium period in education loan and till the Start of repayment of interest in staff housing/vehicle loan. Rate of Interest: - Appropriate interest rate code may be assigned from ITD CBS circular issued from time to time. Regarding relevant interest rate code user may take help by assigning “flag code” followed by listing help through F2 key. E details –

--------------------------------------------------------------------------------------------------------------------Flow start date = Repayment start date - Future date i.e. month end date after the expiry of moratorium period. Effect: - System will raise the principal demand on reaching the date given in this field. Int. Demand date = Last day of month in which the a/c is opened in CBS. Effect: - To facilitate charging of simple interest from the date of first debit entry in the a/c, however, the interest will not be debited to loan a/c; instead it will be debited to partition account.


[110]

I details -

| Int. on Int. Demand Int. Demand Effective Date (*) Int. on Int. Demand - ‘N’ is default populated and should not be modified while opening the a/c. Effect: - Simple interest will be charged, No compounding of int. Int. Demand Effective Date – (*) • Education Loan - Month end date of the Moratorium period. • Staff housing/vehicle loan – Date of start of repayment of Interest after the full repayment of principal. Effect:- Interest will be charged but all the interest demands will be raised on the date given in this field, so penal interest will not be charged and a/c will not become irregular/NPA. Correction of wrong Interest Demand Effective Date:If the ‘Interest demand effective date’ is left blank or wrongly filled, the rectification may be done through menu option LAIDC, only if interest demands are unsatisfied. The verification of modification done through LAIDC has to be done through LAIDCAU only. This menu is applicable for account opened under scheme codes ‘TLSVL/TLSHL/TLRED’ and it can only be used before transfer of interest liability to main loan account. The guidelines were circulated vide ITD/CBS/Cir.No. 32/2008 dated 03-06-2008. Servicing of interest in education loan during the moratorium period:In education loan a/c, the borrower may pay the interest during the moratorium period. The issue can be handled as under: Execute the menu option ADINTREC with the recovery amount for the a/c and then create a normal transaction through menu option TM for crediting the proceeds to partition a/c no. 5711407 and giving the loan a/c no. in ‘G’ details of TM. If the interest recovery is wrongly credited to loan a/c: The entry should be reversed through TM keeping the Reversal Flag as ‘Y’ in A-details of the TM and give the Reversal tran_id - which is intended to be reversed and credit the proceed to partition a/c, as explained above.


[111]

Otherwise, the amount of monthly interest, to be charged, will decrease as the interest is charged on the basis of outstanding balance in a/c. However, user need not force recalculation of interest, the System will recalculate during next interest run. PHINQ: - The detailed enquiry of the partition a/c, where interest is parked/debited, w.r.t. to loan a/c, can be done through menu option PHINQ giving loan a/c no. and partitioned a/c no. as under: 5711407 for education loan 5711410 for staff housing loan 5711411 for staff vehicle loan The report can also be printed thru PHINQ from MIS server. LAXFRINT/PRELAX: The interest liability needs to be transferred to loan a/c through menu option PRELAX/LAXFRINT in the following scenarios: o o

Education loan - On start of repayment or if the borrower wishes to repay the principal before the end of moratorium, Staff housing/vehicle loan - on start of repayment of interest portion when principal have been paid in full.

This step is to be performed even if the interest have been serviced and partitioned a/c is showing ‘Zero’ balance. Effect: Execution of Prelax/Laxfrint modify the ‘Debit Int. To’ flag to ‘L’ from ‘O’ (i.e. to loan a/c from office a/c), which facilitate the debiting of the interest to loan a/c during next interest run. However, it is advised to charge up to date interest in the account before execution of PRELAX/ LAXFRINT. It is observed the field functionaries forget to transfer the interest parked in partitioned a/c to main loan a/c on due date. To obviate the problem, a report was customized and made available at PNBRPT 3/30. The report is indicative and it provides the following three lists: (1) (2) (3)

A/cs opened under scheme code ‘TLRED’ where LAXFRINT executed but ‘Int. on Int. demand’ flag is still ‘N’. A/cs opened under scheme codes ‘TLSHL & TLSVL’ where LAXFRINT executed but ‘Int. on Principal’ flag is “Y”. A/cs where LAXFRINT has fallen due but not executed.

The guidelines in this regard were circulated vide ITD/CBS/Cir. No. 31/2007 dated 01.05.2007. Rephasement of a/c after execution of PRELAX/LAXFRINT: In case of staff housing & vehicle loan, accounts are to be rephased after execution of Laxfrint and ‘Interest on Principal’ flag needs to be modified to “N” where principal amount have been repaid and interest is not to be charged on interest liability outstanding in the account. It is advised to charge up to date interest in the account before execution of PRELAX/ LAXFRINT/ rephasement. In case of education loan the rephasement is to be done through menu option ‘EDUEMI’. This menu will call ACM with rephase flag as ‘Y’ and user needs to fill the ‘E’ details with flow_id as ‘EIDEM’. The verification is to be done through menu option ‘ACM’. This will transfer the loan a/c to new scheme code ‘TLEDU’ and ‘Int on Int. Demand’ flag will be modified to ‘Y’. It is observed that branches forget to rephase the a/c after execution of LAXFRINT/PRELAX. To help the field functionaries, a report is made available at PNBRPT 3/35. This is an indicative report which provides the following two lists:


[112]

(1) (2)

List of A/cs where rephasement is due in next 31 days. List of A/cs where due date of rephasement has already expired and a/c remains unrephased.

The guidelines were circulated vide ITD/CBS/Cir. No. 19/2008 dated 23.02.2008. Classification of Education loan under Priority Sector:Beside other mandatory codes under V – details, the “Sub sector” code for individual borrower should be as under: 70070 - Studies in India up to Rs.10 lac 70075 - Studies Abroad up to Rs.20 lac Interest concession, where ever granted, is to be handled procedurally, by giving +/- numeric value in “A/c. Pref. Int.(Dr.)” field using menu option INTTM. However, it is to be noted that system can recalculate the interest only from the date of last rephasement. ENTERING GROUP CODES IN CBS (CARD CIR 08/2013) Use menu option - ‘CCLD’ i)

This menu option will capture the data customer wise. If account is in more than one SOL, the data is to be captured separately for each SOL.

ii)

Function code are A(Add), M(Modify), V(verify), X(Cancel), D(Delete), U(Undelete), and I (Inquire).

(iii)

If 2 digit code already entered use option modify and select 4 digit group codes as per details of code contained in above circular.

ACCOUNT CLOSURE PROCESS FOR A TERM / DEMAND LOAN ACCOUNT Before executing the account closure procedure the following steps must be followed: Execute menu option ÀCM- Customer Account Maintenance’ enter ‘M – Modify’ in the function block and enter the Account Number in the next field. Then enter ‘0 – General Account Details’ in the option field accept and go to next screen using F6. Modify the field ‘Pay Interest?’ from ‘Y’ to ‘N’. Get the modification verified. Ensure that all securities attached to the account are deleted through SRM and SRM is verified. Ensure that no standing instructions are outstanding where the Term/Demand Loan account is mentioned. Ensure that there are no pending transactions for the account in entered status for the account. On pressing F4 the system shall calculate the up-to-date interest and create transaction for interest debit and post the same in the account under closure. The interest entry shall be in the entered state if any exceptions are encountered. Come out of the menu option CAAC by pressing F3 print the interest application report through menu option PR and post and verify the interest transaction if it is in entered status through menu option TM. However if the interest is being debited to office account then, after interest calculation and post and verify the transaction to the office account through menu option TM and invoke menu option LAXFRINT for transferring the interest liability from office account to the loan account. After the interest is applied to the account through menu option ‘CAAC’, the system will show the exact liability in the account on the day of closure as soon as the interest transaction is posted and verified. The loan account should be credited by the debit balance amount through menu option TM and with flow id ‘COLEC’ and the transaction should be posted and verified.


[113]

When the account balance is zero once again invoke menu option CAAC, enter Account Number and press F4. Ensure that the field ‘RUN INT. CALC. NOW’ is default populated as ‘N’ and the field is protected. The system displays a message at the bottom of the screen that the interest calculation is up-to-date. After ensuring this, accept and commit account closure The account closure is to be verified through ‘CAACAU – Close An Account’ menu option. The verifier has to enter ‘V – Verify’ in the function field. On pressing F2 in the field ‘Account Number’ the system will list the accounts where verification of closure of the accounts is pending. The required account can be

Finacle Friendly a Handbook on Cbs

Recommend Documents