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 23 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

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

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

  • 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: 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 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 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 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