Account Master (Chart of Accounts)

Account Master (Chart of Accounts)

Account Master - User Guide

1. Introduction ๐Ÿ“

The Account Master (or Chart of Accounts) is the fundamental blueprint of your ERP’s financial architecture. Every transactionโ€”whether a customer receipt, raw material purchase, asset depreciation, or payroll runโ€”flows through these accounts. It establishes the organizational structure required for statutory compliance, tax reporting, and executive management decisions.

โ„น๏ธ

Key Objectives of Chart of Accounts:

  1. Financial Framework: Defines the ledger heads where funds, assets, liabilities, revenues, and expenses are tracked.
  2. Reporting Foundation: Feeds the general ledger, Trial Balance, Profit & Loss statement, and Balance Sheet.
  3. Transaction Controls: Governs accounting behavior (TDS deductions, overdraft limits, bank fund transfers, and visual match-offs).

This module is primarily used by Chief Financial Officers, Senior Accountants, and Financial Controllers.


2. Structure & Classification ๐Ÿท๏ธ

The Hierarchical Structure (Main & Sub-Accounts)

  • Main Account (Level 1): Primary accounting ledger identified by a unique 6-digit code (e.g., 100100 - Bank Accounts).
  • Sub-Account (Level 2): Granular subdivision linked under the main account (e.g., 100100-000001 - State Bank of India Current Account).

Classification Attributes

Every account is mapped to three key reporting dimensions:

  • Account Type: Defines functional role (e.g., Bank, Cash, Sundry Debtors, Sundry Creditors, TDS, Direct Expense, Indirect Income).
  • Balance Sheet Group (BSPL Group): Governs statutory grouping on the Balance Sheet or P&L (e.g., Current Assets, Term Loans).
  • MIS Group: Secondary categorization tailored for internal managerial reporting and cost-center evaluation.

3. Account Controls & Indicators โœจ

  • ๐Ÿ›ก๏ธ TDS Applicable: Prompts for automated tax deduction at source whenever the account is debited in purchase bills or vouchers.
  • ๐Ÿ“‰ Allow Negative Balance: Allows accounts (such as Bank Overdraft facilities) to operate with a negative book balance without blocking postings.
  • ๐Ÿ’ธ Transfer of Funds (TOF): Flags bank accounts eligible for internal liquidity transfers in the Transfer of Funds module.
  • ๐Ÿ“Š Trial Balance Dashboard: Toggles visibility in high-level executive dashboard summaries.

4. Bulk Utilities & Management Tools ๐Ÿ› ๏ธ

A. Bulk Account Import (AccountMstImport)

For rapid onboarding or initial ERP implementation:

  • Navigate to Chart of Accounts > Import.
  • Download the standardized Excel template.
  • Fill in Main Account codes, Sub Account codes, account names, types, and group codes.
  • Upload the spreadsheet to create hundreds of ledger heads in seconds with structural validation.

B. Bulk Update MIS Name (AccountMstBulkUpdateMisName)

  • Management frequently updates internal reporting descriptions without wishing to disrupt statutory accounting names.
  • Download the existing Chart of Accounts with current MIS Names into Excel.
  • Update the MIS Name column.
  • Re-upload the workbook to execute mass updates across all ledgers instantly.

C. Transaction Type Master & Bulk Update (AccountMstTrnType)

The Transaction Type Master is the operational bridge between business modules and accounting:

  • Automatically maps accounting ledgers to system transaction types (e.g., Sales Account, Purchase Account, Sales Return, Round-Off, Profit for the Year, Profit Brought Forward).
  • Supports Bulk Updating of transaction type accounts via Excel to maintain configuration integrity during financial year transitions.

5. Deletion & Modification Preventions ๐Ÿ›ก๏ธ

To prevent ledger corruption and maintain statutory audit compliance, the system enforces strict safeguards:

๐Ÿšซ Deletion Restrictions

An account cannot be deleted if:

  1. It has Opening Balances registered in the Opening Balance Master.
  2. It has Opening Outstanding records in the Opening Outstanding Master.
  3. It has transactions in Vouchers, Journal Vouchers, Sales Invoices, Purchase Bills, or Debit/Credit Notes.
  4. It is mapped as a control account in the Transaction Type Master (e.g., Profit for the Year).
  5. A Main Account has active Sub-Accounts linked to it (all sub-accounts must be cleared first).

โœ๏ธ Modification Rules

  • Code Lockdown: Once an account is utilized in any accounting voucher, its numeric code cannot be modified.
  • Mandatory Audit Trail: If AuditTrail is active in the company parameters, modifying account names or classifications requires entering a mandatory change justification note.

6. Related Reports ๐Ÿ“Š

  • ๐Ÿ›๏ธ Financial Statements (Trial Balance / P&L / Balance Sheet): Comprehensive financial reports grouped by BSPL or MIS hierarchies.
  • ๐Ÿฆ Cash & Bank Book: Daily transactional ledger for all cash and bank accounts.
  • ๐Ÿ“‹ Audit Trail Report: Detailed forensic record of all Chart of Accounts modifications.

7. Best Practices / Tips ๐Ÿ’ก

  • Standardized Coding Scheme: Adopt a structured 6-digit numbering convention (e.g., 1xxxxx for Assets, 2xxxxx for Liabilities, 3xxxxx for Equity, 4xxxxx for Revenue, 5xxxxx for Expenses).
  • Keep MIS Names Intuitive: Use descriptive, plain-language MIS Names so department managers can understand their cost reports without needing accounting codes.
  • Link Transaction Types Promptly: Always ensure system transaction types (especially Profit for the Year) are mapped before attempting financial year-end closing or carry forwards.