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
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
The data given in the table is sample data.
Procedure
Data Definition
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 Funds 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
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.
Common Checklist
This checklist covers all the activities which are common across the entities.
Entity Specific Checklist
This checklist covers the activities which are specific to the entity.
1
The Fund Name should not contain any special characters
Municipal Fund : [Allowed]
#Municipal Fund! : [Not allowed]
Attachments
Configuration Data Templateconfiguration-data-template-bank-account.xlsx - 10KB
Sample Datasample-confugration-data-bank-account.xlsx - 10KB
Last updated
