Bank Account

Introduction

A bank account is a financial account maintained by a State in which the financial transactions between the bank and a customer are recorded. Each bank sets the terms and conditions for each type of account it offers, which are classified into commonly understood types, such as deposit accounts, credit card accounts, current accounts, loan accounts or many other types of account.

The list of banks account in which the ULB holds an account in various banks will have to be created here.

Data Table

Sr. No.*	Bank Branch*	Bank Branch Code*	Account number*	Fund*	Account Type (COA Grouping)*	Description	Usage Type*	Pay to
1	HDFC Bank - Main City	HDFC147	00063897421	Municipal Fund	45020 - Balance with Banks – Main Municipal Fund	45022 - Other Scheduled Banks	RECEIPTS_PAYMENTS	Commissioner
2	SBI Treasury Branch, Kurnool	SB0012	844102001001VN	Municipal Fund	45021 - Nationalised Banks	PD Account-001	RECEIPTS_PAYMENTS	Commissioner, KMC
3	ICICI Bank	ICIC550	02042417454076	Municipal Fund	45021 - Nationalised Banks	P.F. Secondary Edn.Staff	RECEIPTS_PAYMENTS	Commissioner

Sr. No.*

Bank Branch*

Bank Branch Code*

Account number*

Fund*

Account Type (COA Grouping)*

Description

Usage Type*

Pay to

HDFC Bank - Main City

HDFC147

00063897421

Municipal Fund

45020 - Balance with Banks – Main Municipal Fund

45022 - Other Scheduled Banks

RECEIPTS_PAYMENTS

Commissioner

SBI Treasury Branch, Kurnool

SB0012

844102001001VN

Municipal Fund

45021 - Nationalised Banks

PD Account-001

RECEIPTS_PAYMENTS

Commissioner, KMC

ICICI Bank

ICIC550

02042417454076

Municipal Fund

45021 - Nationalised Banks

P.F. Secondary Edn.Staff

RECEIPTS_PAYMENTS

Commissioner

The data given in the table is sample data.

Procedure

Data Definition

Sr No	Column Name	Data Type	Data Size	Is Mandatory?	Definition/ Description
1	Bank Branch	Text	50	Yes	The Bank Branch location is the name of the branch of the bank which is registered with Central Bank. It helps to identify any specific branch of the bank
2	Bank Branch Code	Alphanumeric	50	Yes	A unique code that identifies the bank branch, this will help the user to easily identify the bank branch
3	Account number	Alphanumeric	20	Yes	The Account number is a Bank Account number in which State holds a bank account. With the bank account number, the bill payment can be made to the correct account, also while doing the RTGS fund transfer the amount can be transferred to the respective firms or individual account
4	Fund	Text	50	Yes	The Fund indicate the Fund name against each bank account. This will facilitate in support to track the fund amount, receipts and utilization by individual bank account. Click on to view the Fund master data
5	Account Type (COA Grouping)	Alphanumeric	250	Yes	The Account Type indicates the type of account which the state hold an account in a particular branch of the bank. This is also selected from the list of minor or sub minor codes under “450” Major head
6	Description	Text	250	No	A short description is given to the account type
7	Usage Type	Text	250	Yes	The Usage type indicates a bank account is used for, whether a particular account is used to make payments or used for collection purpose and used for both receipt & payment purpose
8	Pay To	Text	100	No	The “Pay To” indicates payments to be made to a particular bill or paying the relevant government department all the statutory remittances like Provident fund, TDS, etc using the particular bank account

Sr No

Column Name

Data Type

Data Size

Is Mandatory?

Definition/ Description

Bank Branch

Text

Yes

The Bank Branch location is the name of the branch of the bank which is registered with Central Bank. It helps to identify any specific branch of the bank

Bank Branch Code

Alphanumeric

Yes

A unique code that identifies the bank branch, this will help the user to easily identify the bank branch

Account number

Alphanumeric

Yes

The Account number is a Bank Account number in which State holds a bank account. With the bank account number, the bill payment can be made to the correct account, also while doing the RTGS fund transfer the amount can be transferred to the respective firms or individual account

Fund

Text

Yes

The Fund indicate the Fund name against each bank account. This will facilitate in support to track the fund amount, receipts and utilization by individual bank account. Click on to view the Fund master data

Account Type (COA Grouping)

Alphanumeric

250

Yes

The Account Type indicates the type of account which the state hold an account in a particular branch of the bank. This is also selected from the list of minor or sub minor codes under “450” Major head

Description

Text

250

A short description is given to the account type

Usage Type

Text

250

Yes

The Usage type indicates a bank account is used for, whether a particular account is used to make payments or used for collection purpose and used for both receipt & payment purpose

Pay To

Text

100

The “Pay To” indicates payments to be made to a particular bill or paying the relevant government department all the statutory remittances like Provident fund, TDS, etc using the particular bank account

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 branch within the State.
Start filling the data starting from serial no. and complete a record at once. repeat this exercise until 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.