Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

*Sr No

*Financial Year

*Department

*Fund

*Function

*Type

Major Code

Minor Code

*Account Code

Account Head

Sub Ledger Type

Entity

Credit

Debit

Narration

1

2020-21

Account Branch

Municipal Fund

Account Central Cell

Asset

410 - Fixed Assets

41010 - Land

4101010

NIL

NIL

NIL

1000000

Opening Bal - Lan

2

2020-21

Street Light

Municipal Fund

Anti Mosquito Operation

Liability

330- Secured Loans

33010 - Loans from Central Government

3301010

NIL

NIL

NIL

2000000

Opening Bal - Loans

Procedure

Data Definition

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

  • Financial Year: The Financial year indicates the year for the which the opening balances will be entered for all the GL accounts.

  • Department: A department indicates to which the GL code is linked, user while entering the opening balance can select a particular department to which amount will be entered.

  • Fund: A GL Code can be linked for the validation of the Fund, user while entering the opening balance can select a particular function to which amount will be entered.

  • Function: A GL Code can be linked for the validation of the Function, user while entering the opening balance can select a particular function to which amount will be entered.

  • Type: The Type indicates the IncomeLiabilities, Expenses, Liabilities Assets and Assets Equity which are mapped to each individual GL code. User can easily identify the GL code by this mapping.

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

  • Minor Code: The Minor Code can be any number of digits, the digits are configurable. The Major code will help in collating the reports at the State level. Also State has the flexibility to define the minor codes.

  • Account 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 opening balances.

  • Account Head: The short name for the Ledger Code, wherein users use this account head name while entering the opening balances.

  • Sub Ledger Type: 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.

  • Entity: When the Sub Ledger is linked to the individual entity, user can select a entity while entering the opening balances.

  • Credit: If the opening balance for a Financial year or a period of a particular GL account is a credit Balance then user need to update the amount under the Credit column.

  • Debit: If the opening balance for a Financial year or a period of a particular GL account is a Debit Balance then user need to update the amount under the Debit column.

  • Narration: A shot narration given while entering the opening balance.

...

  • 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 Type Assets and liabilities should be clearly specified.

  • The Length of the Department, Fund and Function Name should not exceed 50 characters.

Attachments

  • Refer to “Opening Balance Tab” in the uploaded template.

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

View file
nameSample Data - Opening Balance.xlsx
View file
nameTemplate - Opening Balance.xlsx