Introduction
A chart of Accounts (COA) is a listing of the names of accounts 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 setup as per the National Municipal Accounting Manual or Respective State wise manual. Click here for NMAM manual.
Data Table
*Sr. No | *Major Code | *Major head Description | *Minor Code | *Minor Head Description | SubMinor Code | SubMinor Head Description | Ledger Code | *Detailed Heads (Ledgers) | *Ledger Code | Type | Account Detail Type | Function Required | Budget Required | Active for Posting |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 110 | Tax Revenue | 01 | Property Tax | 01 | Property Tax - General Tax | 01 | Property Tax - General Tax - Residential | 110-01-01-01 | Income | Yes/No | Yes/No | Yes | |
2 | 210 | Establishment Expenses | 10 | Salaries and Wages | 01 | Basic Pay | 210-10-01 | Expenses | Yes/No | Yes/No | Yes | |||
3 | 350 | Other Liabilities | 11 | Employee Liabilities | 01 | Salaries Unpaid | 350-11-01 | Liabilities | Drawing Officer | Yes/No | Yes/No | Yes | ||
4 | 410 | Fixed Assets | 20 | Buildings | 02 | Office Building | 410-20-02 | Assets | Yes/No | Yes/No | Yes |
Procedure
Data Definition
Major Code: The Major Code is the first 3 digits of the GL Code which is as per NMAM specifications, this will help in collating the reports at the Nation level.
Major Head Description: The short name given to the Major code to easily identify the Account Name for individual code.
Minor Code: The Minor Code is the first 5 digits of the GL Code which is as per NMAM specifications, this will help in collating the reports at the State level. Also State has the flexibility to define the minor codes.
Minor Head Description: The short name given to the Minor code to easily identify the Account Name for individual code.
SubMinor Code:
SubMinor Head Description:
Ledger Code: The Ledger Code is the last 2 digits of the GL Code which is as per NMAM specifications, which will help to identify the detailed head code that is used for posting the transactions.
Detailed Heads (ledger): The short name for the Ledger Code, wherein users use this account head name while posting the transactions into the system.
Ledger Code: A General Ledger Code (GL Code) is a string of 7 to 9 digit numeric characters assigned to each financial entry in an State/ULB ledger. A GL Code can be assigned to different debit or credit entries to make accounting transactions.
Type: 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.
Account Detail Type: 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.
Function Required: A GL Code can be linked for the validation of the Function, user while posting a transaction can select a particular function to which transaction will be linked and this will facilitate easy Function wise reporting.
Budget Required: 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.
Active for Posting: The Active for posting will allow the user for posting the transaction to the particular GL Code, if the GL Code is Inactive then the transaction cannot be processed.
Steps to fill data
Identify the GL Codes that exists at a ULB level.
Collect the above information and feed it below the “COA” sheet accordingly.
The description should be short and precise for the Name of the GL code.
The format of the GL Code to be 7 digits numeric
The respective mapping with the GL code with the Major code should be as per code structure
The Type should be clearly specified against the individual GL code.
Active for Posting: To indicate “Yes” or “No” in the column if the particular GL code is active for posting the transaction.
Validations
All the fields with * sign are mandatory to be filled in. Without this information, the system configurations cannot be executed.
The GL Code should be numeric and unique no repetitive code should be entered.
Attachments
Refer to “Chart of Account” in the uploaded template.
For sample data reference, refer to the uploaded “sample date” file.