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 in commonly understood types, such as deposit accounts, credit card accounts, current accounts, loan accounts or many other types of account.
The list of banks in which the State would have account in and possible list of banks from which citizens would pay the taxes and other fees using cheque will have to be created here.
Data Table
Sr. No.* | Bank Branch* | Account number* | Fund* | Account Type* | Description | Usage Type* | Pay to |
1 | HDFC Bank - Main City | 00063897421 | Municipal Fund | 45020 - Balance with Banks – Main Municipal Fund | 45022 - Other Scheduled Banks | RECEIPTS_PAYMENTS | Commissioner |
2 | SBI Treasury Branch, Kurnool | 844102001001VN | Municipal Fund | 45021 - Nationalised Banks | PD Account-001 | RECEIPTS_PAYMENTS | Commissioner, KMC |
3 | ICICI Bank | 02042417454076 | Municipal Fund | 45021 - Nationalised Banks | P.F. Secundary Edn.Staff | RECEIPTS_PAYMENTS | Commissioner |
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 Branch | Text | 25050 | Yes | The Bank Branch 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. |
2 | 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. |
3 | Fund | Text | 50 | Yes | The Fund indicate the Fund name against each bank account. This will facilitates in support to track the fund amount, receipts and utilization by individual bank account. Click on Fundsto view the Fund master data. |
4 | Account Type | Alphanumeric | 250 | Yes | The Account Type indicate the type of account which the state hold a account in a particular branch of the bank |
5 | Description | Text | 250 | No | A short description given to the account type |
6 | 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. |
7 | Pay To | Text | 100 | No | The “Pay To” indicates payments to made to a particular bills 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 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. |
Entity Specific Checklist
This checklist covers the activities which are specific to the entity.
Sr. No. | Activity | Example |
|---|---|---|
1 | The Fund Name should not contain any special characters | Municipal Fund : [Allowed] #Municipal Fund! : [Not allowed] |