Introduction

A Bank branch, banking center is a retail location where a bank offers a wide array of face-to-face and automated services to its customers.

A bank branch typically consists of a collection of tellers who can aid in withdrawing money, depositing checks and cash and more.

Data Table

Sr. No.	Bank*	Branch Name/Location*	Branch Code*	MICR	Address*	Contact Person	Phone Number	Narration
1	STATE BANK OF INDIA	SBI Tresury Branch, Kurnool	006305	518002007	COLLECTOR COMPLEX DISTT KURNOOL ANDHRA PRADESH	Branch Manager	0408743462	Operating Current Accounts
2	KOTAK MAHINDRA BANK	Ucon Plaza Kurnool	7849	518064002	Ucon Plaza, Park Road Kurnool	Branch Manager	0812756943	Nationalized Bank
3	ANDHRA BANK	KRISHNANAGAR (KURNOOL)	001430	518011010	80/112 Aabbas Nagarabbasnagar,Kurnool 518002	Branch Manager	022-2261759	Nationalized Bank

Note: Data given in the table is a sample data.

Procedure

Data Definition

Sr No	Column Name	Data Type	Data Size	Is Mandatory?	Definition/ Description
1	Bank	Text	250	Yes	The Bank Name defines the name of the bank in which the individual or a organization hold the different type of accounts. Click here for the list of RBI published banks.
2	Branch Name/Location	Text	250	Yes	The Branch Name/Location is the name of the branch of the bank which is registered with Central Bank. It help to identify any specific branch of the bank.
3	Branch Code	Alphanumeric	50	Yes	A unique code that identifies the bank branch, this will help the user to easily identify the bank branch.
4	MICR	Alphanumeric	50	No	The MICR Code is used in Local clearing (this will be in bottom portion of the cheque). IFSC Code used for RTGS, IMPS and NEFT transactions in India.
5	Address	Alphanumeric	250	Yes	It's the address of the bank where the account is held by the State, the address is likely printed on a bank statement or in cheque book.
6	Contact Person	Text	100	No	A contact person who acts as a channel of communication between the bank and the customer, a contact person is the one who provides relevant information as when when required by the customer.
7	Phone Number	Alphanumeric	12	No	A phone number is the registered number of the bank, wherein a customer can contact a bank representative for any kind of banking related information.
8	Narration	Text	250	No	A short narration which represents the bank and branch.

Steps to fill data

Download the workflow template attached to this page.
Have it open and go through all the headers and understand the meaning of them by referring 'Data Definition' section.
Make sure all the headers, its data type, field size and its definition/ description is understood properly. In case of any doubt, please reach out to the person who has shared this document with you to discuss the same and clear out the doubts.
Identify all bank branches in the state which holds the bank account.
Start filling the data starting from serial no. and complete a record at once. repeat this exercise till the entire data is filled into a template.
Verify the data once again by going through the checklist and taking care of each and every point mentioned in the checklist.

Checklist

The checklist is a set of activities to be performed once the data is filled into a template to ensure data type, size, and format of data is as per the expectation. These activities have been divided into 2 groups as given below.

Common Checklist

This checklist covers all the activities which are common across the entities.

Sr. No	Checklist Parameter	Example
1	Make sure that each and every point in this reference list has been taken care of.	Checklist

Entity Specific Checklist

This checklist covers the activities which are specific to the entity.

Sr. No.

Activity

Example

1

The Branch Code should be unique

006305, 7849

2

The Bank Name should not contain any special characters

ICICI Bank: [Allowed]

#ICICI Bank! : [Not allowed]

Bank Branch