Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 25 Next »

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

*Detailed Heads (Ledgers)

*Ledger Code

Type

Account Detail Type

Function Required

Budget Required

Active for Posting

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

Yes

2

210

Establishment Expenses

210-10

Salaries and Wages

Basic Pay

210-10-01

Expenses

Yes/No

Yes/No

Yes

3

350

Other Liabilities

350-11

Employee Liabilities

Salaries Unpaid

350-11-01

Liabilities

Drawing Officer

Yes/No

Yes/No

Yes

4

410

Fixed Assets

410-20

Buildings

Office Building

410-20-02

Assets

Yes/No

Yes/No

Yes

Procedure

Data Definition

  • Sr No: Defines the serial no of the line item.

  • Major Code: 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.

  • 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 can be any number of digits, the digits are configurable. The Minor code 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: The SubMinor Code can be optional, State/ULB can setup a subminor 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)

  • SubMinor Head Description: The short name given to the SubMinor code to easily identify the Account Name for individual code.

  • Ledger Code: The Ledger Code 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 State level.

  • Download both the attached template and to updated all the details as per the above information in the empty template provided. The sample data template can be used as a reference to fill in the data.

  • Read through all the information above before updating the template with relevant information.

Validations

  • All the fields with * sign are mandatory to be filled in. Without this information, the system configurations cannot be executed.

  • The format of the GL Code to be 7 to 9 digits numeric and unique no repetitive code should be entered.

  • The respective mapping with the GL code with the Major & Minor code should be as per NMAM code structure

  • The Type Income, Expense, Assets and liabilities should be clearly specified against the individual GL code.

  • The Length of Account Name should not exceed 150 characters.

  • The Length of Account Description should not exceed 250 characters.

  • Function Required: To indicate “Yes” or “No” in the column if the particular GL code.

  • Budget Required: To indicate “Yes” or “No” in the column if the particular GL code.

  • Active for Posting: To indicate “Yes” or “No” in the column if the particular GL code is active for posting the transaction.

Attachments

  • Refer to “Chart of Account” in the uploaded template.

  • For sample data reference, refer to the uploaded “sample date” file.

  • No labels