Chart of Accounts & Ledger Creation
Prerequisite: Day 11 - Company Creation
🎯 Learning Objectives:
- Understand 28 Predefined Groups in TallyPrime (15 Primary, 13 Sub-groups)
- Select correct groups for Capital, Debtors, Creditors, Expenses
- Create single and multi-ledgers
- Enter and verify opening balances
2. What is this?
Simple Layman Definition: Chart of Accounts & Ledger Creation is an essential component of TallyPrime Basics, providing structured operational procedures to ensure commercial compliance and financial clarity.
Professional Accounting Definition: Chart of Accounts & Ledger Creation represents a standardized accounting and enterprise resource management methodology governed by Indian Accounting Standards (Ind-AS) and statutory regulatory mandates in TallyPrime.
| Aspect | Details & Practical Relevance |
|---|---|
| Primary Purpose | To systematically process, control, audit, and report chart of accounts & ledger creation transactions with maximum financial accuracy and operational efficiency. |
| Where It Is Used | Implemented across corporate enterprises, SME trading houses, manufacturing plants, distribution networks, and chartered accountancy firms in India. |
| Who Uses It | Senior Accountants, Tally Operators, Accounts Executives, Finance Controllers, and Tax Auditors. |
| Why It Matters in Accounting Jobs | Mastery of Chart of Accounts & Ledger Creation is directly tested in accounting employment interviews and required in day-to-day corporate accounts administration. |
📌 Real-Life Workplace Example:
A registered trading firm in Mumbai executes chart of accounts & ledger creation to maintain real-time compliance with suppliers, clients, and GST authorities.
3. Why is this Important?
- Why Businesses Use It: Prevents revenue leakage, optimizes capital utilization, satisfies statutory audits, and preserves accurate corporate ledger history.
- Why Accountants Need It: Provides a structured protocol to record entries correctly on the first attempt without risking post-audit adjustments.
- Why Required in TallyPrime: TallyPrime automates report compilation, GST triangulation, and ledger balancing when Chart of Accounts & Ledger Creation is configured properly.
- What Problem It Solves: Eliminates manual calculation errors, reconciles discrepancy gaps, and prevents non-compliance penalties under tax regulations.
- What Happens If Not Used Correctly: Incorrect handling causes erroneous financial statements, misleading management reports, and statutory penalties under GST/Income Tax Acts.
4. When is it Used?
Executed whenever relevant commercial events occur during the daily billing, payment, inventory movement, or period-end closing cycles.
⚖️ Decision-Making Rule:
Whenever evaluating this transaction, verify whether it represents an Asset, Liability, Revenue, or Expense. Apply double-entry rules strictly: Total Debits must equal Total Credits before confirming in TallyPrime.
5. How Does it Work?
The operational flow for Chart of Accounts & Ledger Creation follows a clear sequential procedure:
1. Source Document Verification
➔
2. Identify Debit & Credit Ledgers
➔
3. Input in TallyPrime
➔
4. Audit & Reconcile Reports
- 1. Verify authorization and underlying source document (invoice, challan, advice, or receipt).
- 2. Identify the applicable accounts or inventory items affected by the chart of accounts & ledger creation transaction.
- 3. Apply appropriate accounting rules, tax slabs, or inventory valuation parameters.
- 4. Navigate to the designated menu in TallyPrime and input mandatory master/voucher parameters.
- 5. Verify arithmetical balance, GST/TDS tax calculations, and bill-wise reference allocations.
- 6. Accept and save the entry; verify report reflections in Trial Balance, Stock Summary, or Day Book.
6. Accounting Logic & Journal Entry
Representative Transaction
Double-Entry Standard
"Created new ledger 'Godrej Appliances' under Sundry Creditors with ₹1,20,000 opening credit balance."
Identified Accounts: Godrej Appliances (Sundry Creditor) | Opening Balance (Equity/Liability)
Applied Rule: Credit opening balances of creditors and liabilities; Debit opening balances of debtors and assets.
Applied Rule: Credit opening balances of creditors and liabilities; Debit opening balances of debtors and assets.
| Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
| Difference in Opening Balances | ₹1,20,000 | |
| To Godrej Appliances A/c | ₹1,20,000 |
(Being opening balance entered from previous financial year balance sheet.)
Why This Logic Works: The primary account is debited to recognize asset addition or operating expense; the bank account is credited to reflect the reduction in liquid funds.
7. TallyPrime Practical Execution (Step-by-Step)
1
Open Gateway of Tally
Launch TallyPrime
Load Active Company
2
Open Target Function
Press Alt+G (Go To) or select required menu for Chart of Accounts & Ledger Creation
3
Select Mode / Voucher
Press designated shortcut key (e.g. F2 for Date, F4-F9 for Vouchers)
4
Input Party / Account
Select Debit and Credit ledgers or relevant item masters
5
Verify Values & Tax
Ensure invoice value, quantity, and statutory duty match source bills
6
Enter Bill-wise Reference
Allocate New Ref, Agst Ref, or Advance with credit terms
7
Save & Verify
Press Ctrl+A to save; inspect Trial Balance or Day Book to audit posting
8. Field-by-Field Screen Breakdown
| Field Name | Meaning & Significance | What to Enter | Accounting / Compliance Rule |
|---|---|---|---|
| Date | Effective transaction date | Current transaction date |
Must fall within active Financial Year |
| Particulars | Target ledger account | Applicable master ledger |
Select from pre-configured Chart of Accounts |
| Amount | Monetary transaction value | Exact invoice/voucher value |
Must balance exactly between Dr and Cr |
| Narration | Audit transaction description | Description for Chart of Accounts & Ledger Creation |
Document voucher/instrument numbers for audit trail |
| Tax / Duty | Statutory deduction or tax | Applicable GST/TDS head |
Auto-computed or selected as per tax rate |
9. Real-World Business Case Scenarios
🏢 Indian Corporate Scenario:
Zenith Enterprises (Noida, UP) maintains computerized accounting for Chart of Accounts & Ledger Creation across its trading operations with monthly turnover of ₹45 Lakhs.
10. Dedicated Practice Set & Tally Datasets
📝 Practical Assignment: Master Ledger Creation Practice Set (Exact Tally Groups & Opening Balances)
Create these 16 Ledgers in TallyPrime and verify that Difference in Opening Balances is exactly Zero.
| Ledger Name | Parent Group Under | Sub-Group | Opening Balance | Bill-by-Bill? |
|---|---|---|---|---|
| Capital Account | Primary | Capital Account | ₹5,00,000 Cr | No |
| Cash in Hand | Current Assets | Cash-in-Hand | ₹75,000 Dr | No |
| State Bank of India Current A/c | Current Assets | Bank Accounts | ₹3,50,000 Dr | Yes (BRS) |
| HDFC Bank Overdraft A/c | Current Liabilities | Bank OD A/c | ₹1,00,000 Cr | Yes |
| Anil InfoTech (Vendor) | Current Liabilities | Sundry Creditors | ₹1,27,500 Cr | Yes (30 Days) |
| Mahendra InfoTech (Vendor) | Current Liabilities | Sundry Creditors | ₹76,200 Cr | Yes (30 Days) |
| Sun Micro Pvt Ltd (Vendor) | Current Liabilities | Sundry Creditors | ₹54,000 Cr | Yes (15 Days) |
| Deepak Creation (Customer) | Current Assets | Sundry Debtors | ₹1,55,000 Dr | Yes (30 Days) |
| Metro Retail Hub (Customer) | Current Assets | Sundry Debtors | ₹92,000 Dr | Yes (45 Days) |
| Office Furniture & Fixtures | Primary | Fixed Assets | ₹1,40,000 Dr | No |
| Air Conditioners & Electricals | Primary | Fixed Assets | ₹85,000 Dr | No |
| Computers & Printers | Primary | Fixed Assets | ₹1,10,000 Dr | No |
| Sales Account | Primary | Sales Accounts | ₹0 | No |
| Purchase Account | Primary | Purchase Accounts | ₹0 | No |
| Shop Rent Expense | Indirect Expenses | Indirect Expenses | ₹0 | No |
| Staff Salaries & Allowances | Indirect Expenses | Indirect Expenses | ₹0 | No |
🔍 Checking Effect & Report Verification in TallyPrime:
Navigation Path:
Gateway of Tally → Chart of Accounts → Ledgers (View Group-wise Hierarchy)
(Shortcut: Press Alt + G → Type 'Statistics' → Drill down into voucher type)
Audit Checkpoint: Check that Total Debits strictly equal Total Credits (₹10,07,000 Dr = ₹10,07,000 Cr) with zero 'Difference in Opening Balances'.
🟢 Level 1 – Basic Knowledge & Mechanics (5 Questions)
Q1: Under which group should Bank Overdraft ledger be created?
Standard Solution & Accounting Treatment:
Bank OD A/c (grouped under Current Liabilities).
Bank OD A/c (grouped under Current Liabilities).
Q2: Which two ledgers are automatically created by TallyPrime upon company creation?
Standard Solution & Accounting Treatment:
Cash Account (under Cash-in-hand) and Profit & Loss Account (Primary).
Cash Account (under Cash-in-hand) and Profit & Loss Account (Primary).
Q3: What happens if you set 'Maintain balances bill-by-bill' to Yes?
Standard Solution & Accounting Treatment:
Tally prompts for bill reference (New Ref, Agst Ref, Advance, On Account) and tracks individual invoice aging.
Tally prompts for bill reference (New Ref, Agst Ref, Advance, On Account) and tracks individual invoice aging.
Q4: Under which group should Carriage Inward be placed?
Standard Solution & Accounting Treatment:
Direct Expenses (charges directly against Trading Account Gross Profit).
Direct Expenses (charges directly against Trading Account Gross Profit).
Q5: Under which group should Carriage Outward be placed?
Standard Solution & Accounting Treatment:
Indirect Expenses (charges against Profit & Loss Account Operating Profit).
Indirect Expenses (charges against Profit & Loss Account Operating Profit).
🟡 Level 2 – Intermediate Practical Voucher Problems (5 Questions)
Q1: Create a customer ledger 'Zenith Electronics' with a credit limit of ₹2,00,000 and 45 days credit period.
Standard Solution & Accounting Treatment:
Gateway of Tally → Create → Ledger → Zenith Electronics → Under: Sundry Debtors → Bill-by-Bill: Yes → Credit Period: 45 Days → Specify Credit Limit: ₹2,00,000.
Gateway of Tally → Create → Ledger → Zenith Electronics → Under: Sundry Debtors → Bill-by-Bill: Yes → Credit Period: 45 Days → Specify Credit Limit: ₹2,00,000.
Q2: How do you rectify an opening balance mistake after creating 20 ledgers in TallyPrime?
Standard Solution & Accounting Treatment:
Gateway of Tally → Alter → Ledger → Select the ledger → Modify Opening Balance at the bottom → Save with Ctrl+A.
Gateway of Tally → Alter → Ledger → Select the ledger → Modify Opening Balance at the bottom → Save with Ctrl+A.
Q3: Explain the difference between Sundry Debtors and Sundry Creditors groups.
Standard Solution & Accounting Treatment:
Sundry Debtors represents trade customers from whom money is receivable (Current Assets); Sundry Creditors represents suppliers to whom money is payable (Current Liabilities).
Sundry Debtors represents trade customers from whom money is receivable (Current Assets); Sundry Creditors represents suppliers to whom money is payable (Current Liabilities).
Q4: Under which group should 'Outstanding Audit Fees' be placed?
Standard Solution & Accounting Treatment:
Current Liabilities or Provisions.
Current Liabilities or Provisions.
Q5: Under which group should 'Prepaid Insurance' be placed?
Standard Solution & Accounting Treatment:
Current Assets (under Loans & Advances or Current Assets).
Current Assets (under Loans & Advances or Current Assets).
🔴 Level 3 – Job & Industry Audit Scenarios (5 Questions)
Q1: You enter all opening balances from last year's audited Balance Sheet, but Tally displays 'Difference in Opening Balances: ₹45,000 Cr'. How do you troubleshoot this?
Standard Solution & Accounting Treatment:
1. Calculate whether total assets exceed liabilities + capital by ₹45,000. 2. Verify whether prior year Closing Stock or Cash balance was omitted. 3. Check if an asset balance was mistakenly entered with 'Cr' or liability with 'Dr'.
1. Calculate whether total assets exceed liabilities + capital by ₹45,000. 2. Verify whether prior year Closing Stock or Cash balance was omitted. 3. Check if an asset balance was mistakenly entered with 'Cr' or liability with 'Dr'.
Q2: How do you create multiple ledgers quickly in TallyPrime without opening them one by one?
Standard Solution & Accounting Treatment:
Gateway of Tally → Chart of Accounts → Ledgers → Press Alt+H (Multi-Masters) → Select 'Multi Create' → Select Under Group (e.g. Indirect Expenses) → Enter ledger names and opening balances in tabular format → Save with Ctrl+A.
Gateway of Tally → Chart of Accounts → Ledgers → Press Alt+H (Multi-Masters) → Select 'Multi Create' → Select Under Group (e.g. Indirect Expenses) → Enter ledger names and opening balances in tabular format → Save with Ctrl+A.
Q3: What is the consequence of selecting 'Purchase Accounts' instead of 'Direct Expenses' for custom clearance freight?
Standard Solution & Accounting Treatment:
Custom freight will be merged into the Purchase Account total instead of being isolated in a dedicated freight ledger, hindering cost breakdown analysis.
Custom freight will be merged into the Purchase Account total instead of being isolated in a dedicated freight ledger, hindering cost breakdown analysis.
Q4: How should a Security Deposit of ₹1,00,000 given to a commercial landlord be grouped?
Standard Solution & Accounting Treatment:
Deposits (Asset) under Current Assets, not under Rent Expense.
Deposits (Asset) under Current Assets, not under Rent Expense.
Q5: How do you enable Credit Limits feature in TallyPrime?
Standard Solution & Accounting Treatment:
Gateway of Tally → Alter → Ledgers or press F11 / F12 to configure credit limits, then specify limit amount on debtor master.
Gateway of Tally → Alter → Ledgers or press F11 / F12 to configure credit limits, then specify limit amount on debtor master.
⚡ Industry Challenge Scenarios (2 Complex Cases)
Challenge 1: Configure a partner's capital account and drawings account: Capital ₹10,00,000 and Drawings ₹1,50,000. How are they set up and displayed?
Detailed Professional Solution:
Create 'Partner Capital A/c' under Capital Account (Opening: ₹10,00,000 Cr). Create 'Partner Drawings A/c' under Capital Account (Opening: ₹1,50,000 Dr). In Balance Sheet, Capital Account net total will show ₹8,50,000 Cr.
Create 'Partner Capital A/c' under Capital Account (Opening: ₹10,00,000 Cr). Create 'Partner Drawings A/c' under Capital Account (Opening: ₹1,50,000 Dr). In Balance Sheet, Capital Account net total will show ₹8,50,000 Cr.
Challenge 2: A loan of ₹5,00,000 was taken from director Mr. Verma: ₹2,00,000 repayable in 6 months, ₹3,00,000 repayable after 3 years. How should ledgers be structured?
Detailed Professional Solution:
Create 'Mr. Verma Short-Term Loan' under Current Liabilities / Loans (Liability) for ₹2,00,000; create 'Mr. Verma Unsecured Long-Term Loan' under Unsecured Loans for ₹3,00,000.
Create 'Mr. Verma Short-Term Loan' under Current Liabilities / Loans (Liability) for ₹2,00,000; create 'Mr. Verma Unsecured Long-Term Loan' under Unsecured Loans for ₹3,00,000.
11. Practical Company Simulation Scenario
🏢 Company Case Study: Sharma Enterprises Pvt. Ltd.
Financial Year: 01-Apr-2026 to 31-Mar-2027 | Location: Delhi (State Code: 07)
Starting Balances: Cash in Hand ₹75,000 | State Bank of India ₹3,50,000 | Capital ₹5,00,000 | Anil InfoTech (Creditor) ₹1,27,500 | Deepak Creation (Debtor) ₹1,55,000
Dated Transaction Schedule for TallyPrime:
- 01-Apr-2026: Settle pending payment to Anil InfoTech of ₹1,27,500 against Bill # P-106 via SBI Bank cheque # 500101.
- 02-Apr-2026: Collect ₹1,55,000 from Deepak Creation against Bill # 102 deposited directly into SBI Current Account.
- 04-Apr-2026: Execute transaction for Chart of Accounts & Ledger Creation valued at ₹45,000.
- 07-Apr-2026: Paid monthly shop rent ₹25,000 by cheque and stationery ₹2,400 in cash.
- 10-Apr-2026: Audit voucher postings in Day Book and confirm that no entries remain unallocated.
12. Expected Reports & Verification Keys
| Voucher Type | Debit Account | Credit Account | Amount (₹) | Audit Verification Key |
|---|---|---|---|---|
| F5 / F6 / F7 | Target Expense / Asset A/c | Bank / Cash / Creditor | ₹45,000.00 | Reflected in Day Book & Statistics register |
13. Common Mistakes & How to Avoid Them
❌ WRONG: Executing Chart of Accounts & Ledger Creation under incorrect ledger group in TallyPrime
✅ CORRECT: Verify group classification in Chart of Accounts before recording entry
❌ WRONG: Omitting narration and source document reference numbers
✅ CORRECT: Always input invoice, challan, or cheque numbers in the narration field
❌ WRONG: Failing to select bill-wise reference details for debtor/creditor entries
✅ CORRECT: Always allocate against specific bill numbers to avoid 'On Account' ambiguity
❌ WRONG: Recording transactions without verifying applicable GST/TDS rates
✅ CORRECT: Confirm tax rates against latest CBIC notifications or party PAN status
❌ WRONG: Bypassing bank date allocation during reconciliation
✅ CORRECT: Input actual date from bank passbook statement to preserve BRS accuracy
14. Job-Oriented Interview Questions & Answers
Basic Interview Questions
1. What is the role of Chart of Accounts & Ledger Creation in financial accounting? ▾
2. Which menu in TallyPrime provides access to Chart of Accounts & Ledger Creation? ▾
3. Why is accurate source documentation mandatory for this topic? ▾
4. How does TallyPrime prevent unbalanced entries here? ▾
5. What is the consequence of selecting the wrong ledger group? ▾
Practical Interview Questions
1. Explain the step-by-step Tally procedure to configure Chart of Accounts & Ledger Creation. ▾
2. How do you verify that Chart of Accounts & Ledger Creation has been correctly posted? ▾
3. Which shortcut key is most vital when executing this task? ▾
4. How do statutory taxes integrate with Chart of Accounts & Ledger Creation? ▾
5. What report is reviewed by management to inspect this area? ▾
Scenario-Based Interview Questions
1. Your auditor notices a mismatch in Chart of Accounts & Ledger Creation during year-end finalization. How do you resolve it? ▾
2. A client requests an instant statement for Chart of Accounts & Ledger Creation. How do you generate it? ▾
3. An entry for Chart of Accounts & Ledger Creation was recorded with the wrong date. How do you correct it? ▾
15. Examination & Knowledge Assessment
16. Quick Revision & Key Takeaways
⚡ Essential Points to Remember:
- Core Concept: Chart of Accounts & Ledger Creation is an essential component of TallyPrime Basics, providing structured operational procedures to ensure commercial compliance and financial clarity.
- Accounting Law: Every transaction impacts at least two accounts in opposite directions (Dr = Cr).
- Master Navigation: Gateway of Tally → Vouchers or Masters → Save with
Ctrl + A. - Audit Verification: Always cross-reference Day Book postings against physical source bills.
- Compliance Focus: Adhere strictly to Indian Accounting Standards and GST/TDS provisions.
💡 Golden Takeaway: Always audit your entries before closing the day. Accurate bookkeeping today prevents severe audit and tax liabilities tomorrow!
17. Calculation Formulas & Logic
📐 Applicable Formula:
Financial Equilibrium: Total Debits (Dr) = Total Credits (Cr) | Net Value = Gross Amount - Discounts + Applicable Taxes
18. Practical Execution Checklist
Daily Practical Task Milestones (Saved in Browser)
0 / 5 Completed