Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
A Fund is used to capture activities/ group of activities for which separate books of accounts are required to be maintained. The concept of Funds brings accountability and better transparency
Various Funds are set up in ULB for meeting certain objectives. Income and expenditure under these funds are to be identified and disclosed separately.
Fund Accounting is a self-contained accounting with its own assets, liabilities, revenues, expenditures and fund balance.
Sr. No*
Name*
Code*
Identifier
Level*
Parent Fund
1
Municipal Fund
01
1
0
Nil
2
Grant Fund
02
2
0
Nil
3
Public Fund
03
3
0
Nil
4
Pension Fund
04
4
0
Nil
Data given in the table is a sample data.
Sr No
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Name
Text
50
Yes
To indicate the Fund name, if there are multiple funds and by following the Fund Accounting method to record the transaction user can select a particular Fund
2
Code
Numeric
50
Yes
The unique code gives to the individual fund
3
Identifier
Numeric
50
No
A single character or number which is used as a unique identification for the fund. This identifier is used in the voucher number format
4
Level
Numeric
50
Yes
The Funds can be defined in the tree structure, so the Level indicates the structure in which the funds would be set up. Root nodes will be level 0 and the next level funds will have value as 1 and the next level as value 2
5
Parent Fund
Text
50
No
If the ULB’s using multiple Funds then a Hierarchy of “Parent-Child “can be set up for the Fund, so under each Parent Fund multiple child funds can be set up
Download the data 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 different types of Funds on the basis of ULB’s functions.
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.
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.
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
This checklist covers the activities which are specific to the entity.
Sr. No.
Activity
Example
1
The Fund Code that is defined by the state team should be numeric and Unique.
01
2
The Fund Name should not contain any special characters
Municipal Fund : [Allowed]
#Municipal Fund! : [Not allowed]
A contractor is a person or firm who undertakes a contract to provide materials or labour to perform a service or do a job.
Contractors are basically who takes up the works which are awarded by the State or a ULB for a set period. For Example Construction of New Roads/Bridges, Maintenance of Parks etc.
Sr. No*
Name*
Contractor Code*
Permanent Address*
Correspondence Address
Registration No.*
Contact Person*
Email ID
Mobile No.*
PAN No.
GST/TIN No.
GST registered State/UT
Bank Name
Bank Account No.
IFSC Code
1
Rakesh
RAK00123
#141/25 2nd Cross koramangala Bangalore
#62 5th main road
ITPL Bangalore
NIL
Rakesh
Rakesh@gmail.com
98XXXXXX45
AFRXXXX64N
NIL
NIL
ICICI
000XXXX1234
ICICI0XXXX97
2
ABC Constructions
ABC00143
#1/1 8th Main JP Nagar Bangalore
NIL
Z12345KA2020PTC097654
Mahesh
contact@abcconstruction.com
987XXXXXX65
PNBXXXX78U
22AAAAA0000A1Z5
22AAAAA0000A1Z5
HDFC
987XXXXX64
HDFC0XXXX51
Data given in the table is a sample data.
Sr No
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Name
Text
50
Yes
The register Name of the Company/Firm or an Individual Person Name, this will help the user to easily identify the contract assigned and also while generating the bills
2
Contractor Code
Alphanumeric
50
Yes
A unique code that identifies the contractor of the works
3
Permanent Address
Alphanumeric
250
Yes
Company/Firm permanent address or an Individual Person permanent address, this will help the user to send the hard copy document to the contractor. Example, A signed hard copy of the contract
4
Correspondence Address
Alphanumeric
250
No
Alternative address of a Company/Firm or an Individual Person Alternative address
5
Registration No
Alphanumeric
21
Yes
Company/Firm registered number, it’s a unique number assigned by the Registrar of Companies
6
Contact Person
Text
100
Yes
Details of a contact person of an individual or a Company/Firm. This will help the user to contact a person in case of any information required
7
Email ID
Alphanumeric
250
No
Company/Firm email Id or an individual person email Id, with the email Id the contractor, can receive the notification related to works and payments
8
Mobile No
Alphanumeric
12
Yes
Company/Firm Mobile number or an individual person mobile number, the contractor can receive SMS alerts after the bills are processed
9
PAN No
Alphanumeric
10
No
Company/Firm registered PAN number or an individual person PAN number
10
GST/TIN No
Alphanumeric
15
Yes
GST/TIN No: Company/Firm registered GST/TIN number is a Tax Identification Number
11
GST registered State/UT
Alphanumeric
15
Yes
The company/Firm has multiple businesses with the state or union territory a separate registered GST number is a Tax Identification Number
12
Bank Name
Text
50
No
Company/Firm Bank Name in which they hold the account or an individual person Bank account name which he/she holds the account
13
Bank Account No
Alphanumeric
25
No
Company/Firm Bank Account number or an individual person Bank Account number. 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
14
IFSC Code
Alphanumeric
11
No
The Bank IFSC code pertaining to the bank account of the Company/Firm or an Individual person holding a bank account, the IFSC code will be a validation check for the bank account provided by the contractor and useful for the user while doing a bill payment via RTGS
Download the data 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 different types of contractors.
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.
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.
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
This checklist covers the activities which are specific to the entity.
Sr. No.
Activity
Example
1
The Contractors Code should be alphanumeric and unique
RAK00123
2
The Email ID should be valid Id, email Id should contain the Company/Firm name or an individual personal name before the “@” and the “XXXXX.com” after the “@”
ABCLtd@xeror.com
Financial Module (FM) is a key module that is built on coexistence with DIGIT which enables municipalities to create and manage financial transactions like budget, revenue demand, receipt, advances, deposits, bills, payments, asset creation (capitalization), fund transfer and also reconciliations and reporting.
FM enables municipalities to maintain financial records of ULBs following established procedures and practices. Financial Module is a fund based double-entry accrual accounting system designed in line with the National Municipal Accounting Manual.
The financial module enables users to -
Posting of General Ledger
Bill Processing: Generation of bills for varied items such as purchases, works, and salaries
Payment Processing: Payments are processed based on the type of expense type
Receipts Processing - from other DIGIT modules or from any other third party application
Service Wise, Bank account mapping - Configurable
Collection Remittances - Configurable mode of collection wise
Budgeting: Upload Budgets, Budgetary Controls, Budget Enforcement & Budget Re-appropriations
Asset Management: Asset Categorizations, Depreciation, Capitalization & Improvement, Revaluation, sale and disposal
Contra Entry, Bank-reconciliation, Deduction Management & period End Activities.
Deduction Management - processing statutory and non-statutory deductions and its remittances.
Financial Management
Budget Reports
Accounting Reports
Deduction Reports
Revenue Reports
MIS Reports
A Bank is a financial institution licensed to receive deposits and make loans. Bank Offers Internet Banking Services, Mobile Banking Services, Accounts, Loans, Financial Services such as currency exchange and safe deposit boxes.
There are several different kinds of banks including retail banks, commercial or corporate banks, and investment banks. In most countries, banks are regulated by the national government or central bank.
The list of banks in which the ULB would have an account in and a possible list of banks from which citizens would pay the taxes and other fees using cheque will have to be created here.
List of RBI published banks.
None
List of RBI published banks
Functions shall represent the various functions or services carried out by the ULBs. Functions are provided through various responsibilities centres called Departments.
Functions of the ULB can have three levels within it.
The first level under this group represents various functions both obligatory and discretionary. Identified as 0 in the template.
The second Level in function would represent the particular type of service under a function, known as “Function Description”. Identified as 1 in the template
The third level will represent a particular cost centre, Known as “Cost Centre”, which provides the service. Identified as 2 in the template.
*Sr. No.
*Name
*Code
*Level
Parent Type
Parent Code
1
General Administration
10
0
Nil
Nil
2
GENERAL ADMINISTRATION: Administration
1011
1
General Administration
10
3
General Department
101100
2
GENERAL ADMINISTRATION: Administration
1011
4
Public Works
20
0
Nil
Nil
5
PUBLIC WORKS: Roads and Pavement
2021
1
Public Works
20
6
Roads and Building Maintenance
202101
2
PUBLIC WORKS: Roads and Pavement
2021
Data given in the table is a sample data.
Sr No
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Name
Text
250
Yes
To indicate the Function name, User can select a particular function code while recording a transaction in the system. This will facilitate in generating a report at the function level
2
Code
Alphanumeric
50
Yes
The unique code is given to the individual function. Child functions have to follow number pattern starting with the parent code
3
Level
Numeric
50
Yes
As per NMAM, the Function can be defined in the tree structure, so the Level indicates the structure in which the function would be setup. Root nodes will be level 0 and the next level funds will have value as 1 and the next level as value 2
4
Parent Type
Text
250
No
If the ULB’s using multiple Functions then a Hierarchy of “Parent-Child “can be set up for the Function, so under each Parent Function a multiple child function can be set up
5
Parent Code
Alphanumeric
50
No
The unique code representing the parent type function
Download the data 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 different types of Function in the ULB.
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.
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.
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.
This checklist covers the activities which are specific to the entity.
Sr. No.
Checklist Parameter
Example
1
The Function Name should not contain any special characters
General Administration : [Allowed]
#General Administration! : [Not allowed]
2
The Function Code that is defined by the state team should be alphanumeric and Unique.
10, 1011 or 101100
A chart of Accounts (COA) is a listing of the Ledger codes that a State or ULB’s has identified and made available for recording transactions in its general ledger. COA is a standard data which need to be set up as per the National Municipal Accounting Manual or Respective State-wise manual. Click here for NMAM manual. The COA definition can consist of 3 or 4 levels of hierarchy. Ex: Major->Minor->Detailed (3 levels) or Major->Minor->Sub Minor->Detailed (4 Levels). It is up to the state to define the levels required depending on the reporting needs. Detailed code is the node or the level at which the transaction is done.
Sr. No*
Major Code*
Major head Description*
Minor Code*
Minor Head Description*
SubMinor Code
SubMinor Head Description
Detailed Heads (Ledgers)*
Ledger Code*
Type
Account Detail Type
Function Required
Budget Required
1
110
Tax Revenue
110-01
Property Tax
110-01-01
Property Tax - General Tax
Property Tax - General Tax - Residential
110-01-01-01
Income
Yes/No
Yes/No
2
210
Establishment Expenses
210-10
Salaries and Wages
Basic Pay
210-10-01
Expenses
Yes/No
Yes/No
3
350
Other Liabilities
350-11
Employee Liabilities
Salaries Unpaid
350-11-01
Liabilities
Drawing Officer
Yes/No
Yes/No
4
410
Fixed Assets
410-20
Buildings
Office Building
410-20-02
Assets
Yes/No
Yes/No
Data given in the table is a sample data.
Sr No
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Major Code
Alphanumeric
50
Yes
The Major Code can be any number of digits, (though NMAM suggest the first 3 digits) of the GL Code to be the Major code, this will help in collating the reports at the Nation level
2
Major head Description
Text
250
Yes
The short name given to the Major code to easily identify the Account Name for individual code
3
Minor Code
Alphanumeric
50
Yes
The Minor Code can be any number of digits, the digits are configurable. The Minor code will help in collating the reports at the State level. Also, the State has the flexibility to define the minor codes
4
Minor Head Description
Text
250
Yes
The short name given to the Minor code to easily identify the Account Name for individual code
5
SubMinor Code
Alphanumeric
50
No
The SubMinor Code can be optional, State/ULB can set up a sub minor level code based on their requirement, this would help in facilitating the additional level of reporting and also detail transaction-level information (The SubMinor code is not listed in NMAM manual)
6
SubMinor Head Description
Text
250
No
The short name given to the SubMinor code to easily identify the Account Name for individual code
7
Detailed Heads (Ledgers)
Text
250
Yes
The short name for the Ledger Code, wherein users use this account head name while posting the transactions into the system
8
Ledger Code
Alphanumeric
50
Yes
A General Ledger Code (GL Code) is a string of 7 to 9 digit numeric characters assigned to each financial entry in a State/ULB ledger. A GL Code can be assigned to different debit or credit entries to make accounting transactions
9
Type
Text
250
No
The Type indicates the Income, Expenses, Liabilities and Assets which are mapped to each individual GL code. User can easily identify the GL code by this mapping
10
Account Detail Type
Text
250
No
The account details type is the subsidiary ledger, The Suppliers, Contractors and Employees are standard subsidiary ledger. This will help the user to identify the subsidiary ledger details while processing any bill transaction in the system
11
Function Required
Text
250
No
A GL Code can be linked for the validation of the Function, the user while posting a transaction can select a particular function to which transaction will be linked and this will facilitate easy Function wise reporting
12
Budget Required
Text
250
No
A GL Code can be linked for the validation of a Budget. User can have a validation check while posting a transaction into the system, this will facilitate to track the amount usage
Download the data 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.
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.
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.
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
This checklist covers the activities which are specific to the entity.
Sr. No.
Checklist Parameter
Example
1
The Major, Minor and Sub minor Description Name should not contain any special characters
Tax Revenue : [Allowed]
#Tax Revenue! : [Not allowed]
2
The Ledger Codes that are defined by the state team should be alphanumeric and Unique
110-01-01-01
A supplier is a person or business that provides a product or service to another entity. The role of a supplier in business is to provide high-quality products.
A supplier may also be referred to as a vendor who supplies required materials or a product to the State or ULB for the works which need to be executed. (Example: materials for street light, cable wires for street light etc)
Sr. No*
Name*
Permanent Address*
Correspondence Address
Supplier Code*
Contact Person*
Email ID*
Mobile No.*
PAN No.
Registration No
GST/TIN No.
GST registered State/UT
Bank Name
Bank Account No.
IFSC Code
1
ABC Supplies
#5 6th main cross opp to ICICI bank Punjab
NIL
ABC134
Ramesh
abcsupplies@gmail.com
98XXXXXX21
APRFN9561B
Nil
22AAAAA0000A1Z5
NIL
ICICI
2XXXX1234XX4
ICICI00XXXX7
2
Suresh Traders
10 main road Punjab
#62 5th main road ITPL Punjab
MB0099
Rakesh
sureshtraders@xyz.com
98XXXXXXX95
ARIZG9874C
AYR145U
22BBBBA0000A1Z5
22BBBBA0000A1Z5
HDFC
98XXXXX5X4
HDFC00XXX51
Data given in the table is a sample data.
Sr No
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Name
Text
250
Yes
The register Name of the Company or an Individual Person Name, this will help the user to easily identify the supplier to raise a Purchase Order and also while generating the bills.
2
Permanent Address
Text
250
Yes
Company permanent address or an Individual Person permanent address, this will help the user to send the hard copy of a Purchase order to the Supplier.
3
Correspondence Address
Text
250
No
Alternative address of a Company or an Individual Person
4
Supplier Code
Text
50
Yes
A unique code that identifies the supplier of the goods
5
Contact Person:
Text
250
Yes
Details of a contact person of an individual or a Company, the user can contact the supplier to get the information and status of the delivery of the goods ordered.
6
Email ID
Text
250
Yes
Company email Id or an individual person email Id, with the email Id the supplier can receive the notification related to purchase order and payments.
7
Mobile No
Alphanumeric
12
Yes
Company Mobile number or an individual person mobile number, the supplier can receive SMS alerts after the bills are processed.
8
PAN No
Alphanumeric
10
No
Company registered PAN number or an individual person PAN number
9
Registration No
Alphanumeric
21
No
Company/Firm registered number, it’s a unique number assigned by the Registrar of Companies.
10
GST/TIN No
Alphanumeric
15
Yes
Company registered GST/TIN number is a Tax Identification Number is a unique 15-digit number.
11
GST registered State/UT
Alphanumeric
15
Yes
The company/Firm has multiple businesses with the state or union territory a separate registered GST number is a Tax Identification Number.
12
Bank Name
Text
50
No
Company Bank Name in which they hold the account or an individual person Bank account name which he/she holds the account
13
Bank Account No
Alphanumeric
25
No
Company Bank Account number or an individual person Bank Account number. 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.
14
IFSC Code
Alphanumeric
11
No
The Bank IFSC code pertaining to the bank account of the Company or an Individual person holding a bank account, the IFSC code will be a validation check for the bank account provided by the contractor and useful for the user while doing a bill payment via RTGS.
Download the data 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 different types of suppliers.
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.
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.
This checklist covers the activities which are specific to the entity.
Sr. No.
Activity
Example
1
The Supplier Code should be alphanumeric and unique
ABC134
2
The Center or State comes up with various government programs called schemes (Yojana) from time to time. These schemes could be either Central, state-specific or joint collaboration between the Centre and the states.
Schemes and sub-schemes defined by the Centre or state government to be associate with a fund and for a time. Similar Sub scheme shall be defined under a scheme.
Sr. No*
Scheme Code*
Scheme Name*
Fund*
Description
Start Date*
End Date*
1
10
AMRUT
Grant Fund
Amrut
01/05/2018
01/06/2021
2
20
Swachh Bharat Mission
Grant Fund
Swachh Bharat Mission
01/06/2017
01/07/2020
3
30
Finance Commission
Municipal Fund
Finance Commission
01/03/2016
30/04/2019
4
40
Housing for All
Municipal Fund
Municipal Fund
01/04/2016
31/03/2021
Data given in the table is a sample data.
Sr. No.
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Scheme Code
Numeric
50
Yes
A unique code assigned to individual Scheme
2
Scheme Name
Text
250
Yes
The indicate Name of the Scheme, this will facilitate the user to record the transaction against the individual scheme and also helps in tracking the utilization of the Scheme
3
Fund
Text
250
Yes
4
Description
Text
250
No
A Short description provided to individual schemes
5
Start Date
Date
N/A
Yes
The Date on which the Scheme Started, this will help to facilitate the receiving of funds from Central Sponsored Schemes and State-Sponsored Schemes
6
End Date
Date
N/A
Yes
The Date on which the Scheme will End, this will help to facilitate the end date by when the funds from Central Sponsored Schemes and State-Sponsored Schemes need to be utilized
Download the data 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 different types of Schemes on the basis of ULB’s functions.
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.
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.
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
This checklist covers the activities which are specific to the entity.
Sr. No.
Activity
Example
1
The date format should be as per example and the Start date should be greater than the current date and end date
DD/MM/YYYY : [Allowed]
YYYY/DD/MM : [Not allowed]
2
The name should be unique and should not contain any special characters
AMRUT : [Allowed]
#AMRUT! : [Not allowed]
Sub schemes are defined under the schemes by the Centre or state government to be associate with a fund and for a time. The Sub scheme shall be defined under a scheme.
Sr. No.
Scheme Code*
Sub Scheme Name *
Sub Scheme Code *
Valid From *
Valid To *
Department Code
Initial Estimate Amount
1
10
Storm Water Drains
1003
01/05/2018
01/06/2021
PHS
2500000
2
20
Solid Waste Management- SWM
SBM02
01/06/2017
01/07/2020
TP
1000000
3
30
Street Lights
5001
01/03/2016
30/04/2019
TP
2000000
Data given in the table is a sample data.
Sr No
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Scheme Code
Alphanumeric
50
Yes
2
Sub Scheme Name
Text
50
Yes
The Sub Scheme Name will facilitate the user to record the transaction against the individual sub-scheme and also helps in tracking the utilization of the sub-scheme
3
Sub Scheme Code
Alphanumeric
50
Yes
A unique code assigned to individual Sub Scheme
4
Valid From
Date
N/A
Yes
The Date on which the Scheme Started, this will help to facilitate the receiving of funds from Central Sponsored Schemes and State-Sponsored Schemes
5
Valid To
Date
N/A
Yes
The Date on which the Scheme will End, this will help to facilitate the end date by when the funds from Central Sponsored Schemes and State-Sponsored Schemes need to be utilized
6
Department Code
Text
250
No
7
Initial Estimate Amount
Numeric
50
No
The initial Estimate Amount approved amount under the sub-scheme can be updated while creating the sub-scheme master record. This will facilitate the user in utilizing the amount within the estimated amount
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 sub schemes with 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.
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.
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
This checklist covers the activities which are specific to the entity.
Sr. No.
Activity
Example
1
The date format should be as per example and the Start date should be greater than the current date and end date.
DD/MM/YYYY : [Allowed]
YYYY/DD/MM : [Not allowed]
2
The name should be unique and should not contain any special characters
AMRUT : [Allowed]
#AMRUT! : [Not allowed]
3
The scheme name mapped should be as per the scheme master entity
AMRUT, SWM
The debit or credit balance of a ledger account brought forward from the old accounting period to the new accounting period is called opening balance. This will be the first entry in a ledger account at the beginning of an accounting period. The opening balance is being captured based on Department, fund, function etc are based on how the system is configured.
If a ULB is using another accounting system, firstly ULB should close financial statements in that system. Then the closing balance of the accounts should be updated as an opening balance in the new application.
Data given in the table is a sample data.
Download the data 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 the Ledger Codes for which opening balance need to be entered.
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.
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.
This checklist covers all the activities which are common across the entities.
This checklist covers the activities which are specific to the entity.
The Sub-ledger category provides details behind entries in the general ledger used in accounting, which is also called subsidiary ledgers. The total of the Sub-ledger would match the line item amount on the general ledger. This corresponding line item in the general ledger is referred to as the controlling account.
Any other type of Sub-ledgers other than standard Sub-ledgers available in the system is to be created here. Standard sub-ledger available in the system is Contractor, Supplier and Employee.
Download the data 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 different types of sub-ledger category.
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.
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.
This checklist covers all the activities which are common across the entities.
This checklist covers the activities which are specific to the entity.
A deduction master is defined to create a reference between ledger codes and to the standard and statutory deductions that are deducted in various creditor bills. By defining this deduction master, accounts department can process the remittance of all the deductions done for a time period at once and keep track of the same.
An example of a deduction is what is deducted from salary bill as income taxes.
Data given in the table is a sample data.
Download the data 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 different types of deduction.
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.
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.
This checklist covers all the activities which are common across the entities.
This checklist covers the activities which are specific to the entity.
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 account which the ULB holds an account in various banks will have to be created here.
Data given in the table is a sample 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.
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.
This checklist covers all the activities which are common across the entities.
This checklist covers the activities which are specific to the entity.
A Bank branch, banking centre is a retail location where a bank offers a wide array of face-to-face and automated services to its customers.
The list of banks branches(under Bank list from master) in which the ULB would have an account in will have to be created here.
Data given in the table is a sample 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 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.
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.
This checklist covers all the activities which are common across the entities.
This checklist covers the activities which are specific to the entity.
The Email ID should be valid Id, email Id should contain the Company/Firm name or an individual personal name before the “@” and the “” after the “@”
To indicate the Fund name against each scheme. This will facilitate in support to track the scheme funds, receipts and utilization by attaching scheme code to the financial transaction. Click on to view the Fund master data
A unique code assigned to individual Scheme, this will facilitate the user to assign the sub-scheme under the individual scheme and also helps in tracking the utilization of the Scheme. Click on to view the scheme master data
The sub-scheme can be linked to the individual department, so user while recording the transaction can assign the department. Click for the master data
Sr No*
Financial Year*
Department*
Fund Code*
Function Code*
Account Code*
Subledger Category
Entity
Debit
Credit
1
2020-21
Account Branch
01
000300
4101010
NIL
NIL
1000000
2
2020-21
Street Light
01
202406
3301010
NIL
NIL
2000000
3
2020-21
Street Light
01
202406
3401002
Contractor
MH003
1000000
Sr No
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Financial Year
Number
10
Yes
The Financial year indicates the year for the which the opening balances will be entered for the GL accounts. This can be the opening balance of the year or the date from which the system is going live
2
Department
Text
250
Yes
A department indicates to which the GL code is linked, the user while entering the opening balance can select a particular department to which amount will be entered
3
Fund Code
Alphanumeric
50
Yes
A GL Code can be linked for the validation of the Fund Code, the user while entering the opening balance can select a particular fund code to which amount will be entered
4
Function Code
Alphanumeric
50
Yes
A GL Code can be linked for the validation of the Function Code, the user while entering the opening balance can select a particular function Code to which amount will be entered
5
Account Code
Alphanumeric
50
Yes
A General Ledger Code (GL Code) is a string of 7 to 9 digit numeric characters assigned to each financial entry in a State/ULB ledger. A GL Code can be assigned to different debit or credit entries to make opening balances. A detailed GL code to be provided to update the opening balance
6
Subledger Category
Text
250
No
The Sub Ledger type indicates if the GL code is linked to a sub-ledger account which is contractor, supplier and employee then the user can select the sub-ledger type while entering the opening balances. Click SubLedger Category for the master details
7
Entity
Alphanumeric
50
No
When the Sub Ledger is linked to the individual entity, the user can select an entity while entering the opening balances. So when a sub-ledger is “Contractor” then the value here will be “Contractor code”
8
Credit
Number
50
No
If the opening balance for a Financial year or a period of a particular GL account is a credit Balance then the user needs to update the amount under the Credit column
9
Debit
Number
50
No
If the opening balance for a Financial year or a period of a particular GL account is a Debit Balance then the user needs to update the amount under the Debit column
Sr. No
Checklist Parameter
Example
1
Make sure that each and every point in this reference list has been taken care of
Sr. No.
Activity
Example
1
The Amount cannot be entered in both the Debit and Credit column for a particular GL code.
Debit:100000 [Allowed]
Debit:10000 Credit:10000 [Not Allowed]
2
If for a particular account code the data is captured at sub-ledger level then the Sub-ledger and entity should be selected,
Account Head: Security Deposit
Subledger Type: Contractor:
Entity: Cont003 (Test Contractor)
Sr No.
Name*
Description*
1
Telephone
Telephone
2
Other Creditors
Other Creditors
3
ULB and Other Dept
ULB and Other Departments
Sr. No.
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Name
Text
50
Yes
The Name indicates the sub-ledger category, this will facilitate the user to record the transaction at the Sub-ledger level. (Example: While creating a bill, user can select the Sub-ledger details as a contractor to whom the bill need to be paid and the same can be recorded under the sub-ledger GL code which is mapped to the contractor)
2
Description
Text
50
Yes
A short description provided to the name of the Sub-ledger
Sr. No
Checklist Parameter
Example
1
Make sure that each and every point in this reference list has been taken care of
Sr. No.
Activity
Example
1
The name should be unique and should not contain any special characters
Contractor : [Allowed]
#Contractor! : [Not allowed]
Sr. No*
Deduction Name*
Deduction Code*
Subledger Category
Account Code*
*Remitted To
IFSC Code
Account No
Description
1
CPF Deduction
CPF
Employee
3502003 - CPF Deduction
Central Provident Fund Board
UBIN0XXXX69
2XXXX1234XX4
CPF Deduction
2
TDS Deduction
TDS
Contractor
3502001 - TDS Deduction
Central Government
ICICI00XXXX7
6XXX97156XX5
TDS Deduction
3
TDS from Employees
TDS Employees
Employee
3502008 - TDS Employee
Central Government
HDFC00XXX51
9XXXX759691XX7
TDS from Employees
Sr No
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Deduction Name
Text
250
Yes
The name for the deduction head, wherein users use this deduction head name while posting the transactions into the system and also user can generate an individual report using the deduction name.
2
Deduction Code
Alphanumeric
20
Yes
A unique code that identifies the deduction name, this will help the user to easily identify the deduction type while doing a transaction.
3
Subledger Category
Text
250
No
The Subledger type is the value which will tell the party type associated with the deduction. This will be aligned with the standard set of sub-ledger types in DIGIT like - Contractor, Supplier and Employee. Example: When payment to be made for a contractor, TDS deduction is done and “Contractor” would be mapped to the sub-ledger type. Click SubLedger Category for the master details
4
Account Code
Alphanumeric
50
Yes
A particular GL code would be mapped for the deduction code, these accounts codes would be used in the transaction when a deduction needs to be made. If the sub-ledger type is present then the GL code has to be a control code of that sub-ledger. If sub-ledger type is blank, then the GL code mapped will be a non-control code
5
Remitted To
Text
250
Yes
The “Remitted To” represent the relevant government department to which all the statutory remittances like Provident fund, TDS, CPF and ESI etc are deducted and remitted as per the Act. So while making the payment the “Pay To” will be set to this value
6
IFSC Code
Alphanumeric
11
No
The Bank IFSC code pertaining to the bank branch to which the payment will be made for this particular deduction
7
Account No
Alphanumeric
25
No
The Bank account number represents the account number to which all the deduction which are made would be remitted
8
Description
Text
250
No
A short description shows the deduction details for which the remittance made to the relevant government department
Sr. No
Checklist Parameter
Example
1
Make sure that each and every point in this reference list has been taken care of.
Sr. No.
Activity
Example
1
Deduction Code should be unique and no special character is allowed.
CPF : [Allowed]
#CPF! : [Not allowed]
2
The format of the Account Code to be 7 to 9 digits numeric and unique no repetitive code should be entered. Only detailed account code should be listed here and this should be an active code in the COA master.
Click on Chart of Accounts for master details.
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
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 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
Sr. No
Checklist Parameter
Example
1
Make sure that each and every point in this reference list has been taken care of
Sr. No.
Activity
Example
1
The Fund Name should not contain any special characters
Municipal Fund : [Allowed]
#Municipal Fund! : [Not allowed]
Sr. No.
Bank*
Bank Code*
Branch Name/Location*
Branch Code*
MICR
Address*
Contact Person
Phone Number
Narration
1
STATE BANK OF INDIA
SBI
SBI Treasury Branch, Kurnool
006305
518002007
COLLECTOR COMPLEX DISTT KURNOOL ANDHRA PRADESH
Branch Manager
0408743462
Operating Current Accounts
2
KOTAK MAHINDRA BANK
KKBK
Ucon Plaza Kurnool
7849
518064002
Ucon Plaza, Park Road Kurnool
Branch Manager
0812756943
Nationalized Bank
3
ANDHRA BANK
ANDB
KRISHNANAGAR (KURNOOL)
001430
518011010
80/112 Aabbas Nagarabbasnagar,Kurnool 518002
Branch Manager
022-2261759
Nationalized Bank
Sr No
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Bank
Text
100
Yes
The Bank Name defines the name of the bank in which the individual or an organization hold the different type of accounts. Click here for the list of RBI published banks
2
Bank Code
Alphanumeric
50
Yes
The Unique code which represents each bank
3
Branch Name/Location
Text
50
Yes
The Branch Name/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
4
Branch Code
Alphanumeric
50
Yes
A unique code that identifies the bank branch, this will help the user to easily identify the bank branch
5
MICR
Alphanumeric
50
No
The MICR Code is used in Local clearing (this will be in the bottom portion of the cheque). IFSC Code used for RTGS, IMPS and NEFT transactions in India
6
Address
Alphanumeric
50
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 the cheque book
7
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 and when required by the customer
8
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
9
Narration
Text
250
No
A short narration which represents the bank and branch
Sr. No
Checklist Parameter
Example
1
Make sure that each and every point in this reference list has been taken care of
Sr. No.
Activity
Example
1
The Branch Code should be unique
006305, 7849
Once the SubLedger Category is created the Subledger master need to be defined. The Subledger master will help to record the transaction at the most detailed level. Subledger category is referred to as “Account detail type” here.
With recording the transaction at the Subledger level, the detail reports can be generated.
Sr. No
Account detail type*
Name*
Code*
Narration
1
Telephone
0999784563
001
Telephone Number
2
Other Creditors
Park Welfare Society
Park Welfare
Park Welfare
Data given in the table is a sample data.
Sr No
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description
1
Account Detail Type
Text
100
Yes
The Account detail type indicates the name of the subledger category name, this will help the user to identify the subledger account while recording the transaction
2
Name
Alphanumeric
50
Yes
The name of the subledger master, wherein the user will record the transaction at the most details level
3
Code
Alphanumeric
50
Yes
The unique code gives to the Subledger master
4
Narration
Text
250
No
A short narration provided to the subledger master
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 subledger master details.
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.
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.
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
This checklist covers the activities which are specific to the entity.
Sr. No.
Activity
Example
1
The name should be unique and should not contain any special characters
Telephone : [Allowed]
#Telephone! : [Not allowed]