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:
- Financial Framework: Defines the ledger heads where funds, assets, liabilities, revenues, and expenses are tracked.
- Reporting Foundation: Feeds the general ledger, Trial Balance, Profit & Loss statement, and Balance Sheet.
- 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:
- It has Opening Balances registered in the Opening Balance Master.
- It has Opening Outstanding records in the Opening Outstanding Master.
- It has transactions in Vouchers, Journal Vouchers, Sales Invoices, Purchase Bills, or Debit/Credit Notes.
- It is mapped as a control account in the Transaction Type Master (e.g., Profit for the Year).
- 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
AuditTrailis 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.,
1xxxxxfor Assets,2xxxxxfor Liabilities,3xxxxxfor Equity,4xxxxxfor Revenue,5xxxxxfor 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.