Tag: how to create ledgers in tally

Here is a list of 100 practical ledger examples commonly used in Tally (ERP 9 / Prime), along with the correct group classification under which each ledger should be created. This is extremely useful for learners, accountants, and professionals managing accounts setup in Tally.

---

📘 Ledger Creation Examples in Tally with Group Classification

S.No	Ledger Name	Group in Tally
1	Cash	Cash-in-Hand
2	Axis Bank	Bank Accounts
3	SBI Current Account	Bank Accounts
4	Petty Cash	Cash-in-Hand
5	Ram Traders (Debtor)	Sundry Debtors
6	Shyam Suppliers (Creditor)	Sundry Creditors
7	Sales – Domestic	Sales Account
8	Sales – Export	Sales Account
9	Purchase – Raw Material	Purchase Account
10	Purchase – Capital Goods	Purchase Account
11	Rent Received	Indirect Incomes
12	Rent Paid	Indirect Expenses
13	Electricity Charges	Indirect Expenses
14	Salary Expenses	Indirect Expenses
15	Telephone Expenses	Indirect Expenses
16	Commission Income	Indirect Incomes
17	Commission Paid	Indirect Expenses
18	GST Payable	Duties & Taxes
19	GST Input CGST	Duties & Taxes
20	GST Input SGST	Duties & Taxes
21	GST Input IGST	Duties & Taxes
22	GST Output CGST	Duties & Taxes
23	GST Output SGST	Duties & Taxes
24	GST Output IGST	Duties & Taxes
25	Provident Fund Payable	Current Liabilities
26	TDS Payable	Duties & Taxes
27	TDS Receivable	Loans & Advances (Assets)
28	Provident Fund Employer Contribution	Indirect Expenses
29	Travelling Expenses	Indirect Expenses
30	Legal Fees	Indirect Expenses
31	Professional Charges	Indirect Expenses
32	Audit Fees	Indirect Expenses
33	Printing & Stationery	Indirect Expenses
34	Advertising Expenses	Indirect Expenses
35	Marketing Expenses	Indirect Expenses
36	Interest on Loan	Indirect Expenses
37	Interest Received	Indirect Incomes
38	Depreciation	Indirect Expenses
39	Loan from Director	Secured Loans
40	Loan from HDFC Bank	Secured Loans
41	Unsecured Loan from Friend	Unsecured Loans
42	Fixed Deposit	Bank Accounts / Investments
43	Share Capital	Capital Account
44	Drawings	Capital Account
45	Investments in Shares	Investments
46	Advance to Supplier	Loans & Advances (Assets)
47	Advance from Customer	Current Liabilities
48	Outstanding Rent	Current Liabilities
49	Prepaid Insurance	Current Assets
50	Insurance Premium	Indirect Expenses

---

✅ Continued — More Ledger Examples

S.No	Ledger Name	Group in Tally
51	Accrued Interest	Current Assets
52	Sundry Income	Indirect Incomes
53	Repair & Maintenance	Indirect Expenses
54	AMC Charges	Indirect Expenses
55	Car Fuel Expenses	Indirect Expenses
56	Vehicle Maintenance	Indirect Expenses
57	Office Equipment	Fixed Assets
58	Furniture & Fixtures	Fixed Assets
59	Computers	Fixed Assets
60	Land & Building	Fixed Assets
61	Machinery	Fixed Assets
62	ITC Reversal	Duties & Taxes
63	RCM Payable	Duties & Taxes
64	Freight Inward	Direct Expenses
65	Freight Outward	Indirect Expenses
66	Customs Duty	Direct Expenses / Duties & Taxes
67	Packing Material	Direct Expenses
68	Production Wages	Direct Expenses
69	Administrative Expenses	Indirect Expenses
70	Donation	Indirect Expenses
71	Penalty	Indirect Expenses
72	Bank Charges	Indirect Expenses
73	Bank Interest Paid	Indirect Expenses
74	Bad Debts	Indirect Expenses
75	Provision for Bad Debts	Provisions
76	Director’s Remuneration	Indirect Expenses
77	Security Deposit Paid	Loans & Advances (Assets)
78	Security Deposit Received	Current Liabilities
79	Office Rent Deposit	Loans & Advances (Assets)
80	Telephone Bill Payable	Current Liabilities
81	Office Advance	Loans & Advances (Assets)
82	ESI Payable	Current Liabilities
83	Income Tax Payable	Duties & Taxes
84	Income Tax Advance	Loans & Advances (Assets)
85	Dividend Payable	Current Liabilities
86	Dividend Received	Indirect Incomes
87	Partner’s Capital A/c	Capital Account
88	Partner’s Drawings A/c	Capital Account
89	Partner’s Current A/c	Capital Account
90	Salary Payable	Current Liabilities
91	Outstanding Expenses	Current Liabilities
92	Accrued Income	Current Assets
93	Advance Tax	Loans & Advances (Assets)
94	Bonus Paid	Indirect Expenses
95	Gratuity	Indirect Expenses
96	House Rent Allowance (HRA)	Indirect Expenses
97	Medical Reimbursement	Indirect Expenses
98	Loan to Employee	Loans & Advances (Assets)
99	Vehicle Loan Payable	Secured Loans
100	Temporary Imprest	Loans & Advances (Assets)

---

✅ Notes:

• Always ensure to enable GST in Tally for auto-ledger creation of Input/Output tax ledgers.
• Classify advance ledgers correctly depending on whether they are receivable (Assets) or payable (Liabilities).
• For accurate reporting, avoid using Miscellaneous Expenses unless absolutely required.

Download 100 Examples of Ledger in Excel and XML

📥 How to Import This into Tally Prime / ERP 9:

✅ Option 1: Manual Copy-Paste into Tally via Excel

1. Open the Excel file.
2. Manually create ledgers in Tally using this list as a reference.
3. Use “Multiple Ledgers” creation to save time.

✅ Option 2: Import via XML (Advanced Users)

1. Open Tally (ERP 9 or Prime)
2. From Gateway of Tally, press Alt + O (Import)
3. Choose Masters
4. In “Import File Name”, enter the path to the downloaded XML file
   • Example: C:\Users\YourName\Downloads\Tally_100_Ledger_Import.xml
5. Press Enter to start import

✔️ All 100 ledgers will be created in your selected company.

---

🧾 How to Create Ledger in Tally (ERP 9 & Prime)

✅ Step 1: Open Tally

• Open Tally ERP 9 or Tally Prime
• Select or create your Company where ledgers need to be added

---

✅ Step 2: Gateway of Tally > Accounts Info > Ledgers

For Tally ERP 9:

1. Gateway of Tally → Accounts Info
2. Select Ledgers
3. Choose Create (under Single Ledger for one-by-one creation)

For Tally Prime:

1. Press Alt + G and search Create Ledger
2. Or go to Gateway of Tally → Create → Ledger

---

✅ Step 3: Fill Ledger Details

You’ll now see the Ledger Creation Screen. Fill the following fields:

Field	What to Fill
Name	Name of the ledger (e.g., “Axis Bank”)
Alias	(Optional) Short name or reference
Under	Select the Group (e.g., “Bank Accounts”)
Inventory Values	Select Yes if applicable (for stock ledgers only)
GST Applicable	Yes / No based on ledger use (for taxable ledgers)
Opening Balance	If applicable, enter amount with Dr/Cr selection

Use arrow keys to move between fields and press Enter to confirm.

---

🔁 Step 4: Repeat for Each Ledger

• Repeat the same steps for all the 100 ledgers.
• For batch creation, use “Multiple Ledgers” option:
  • In ERP 9: Gateway of Tally → Accounts Info → Ledgers → Multiple Ledgers → Create
  • In Prime: Go to Create → Ledgers (Multiple) or search from Go To (Alt + G)

---

💡 Example: Creating a Ledger for “Axis Bank”

Field	Entry
Name	Axis Bank
Under	Bank Accounts
Opening Balance	₹50,000 Dr (if available)
GST Applicable	No

Press Enter until Tally saves the entry.

---

🛠️ Tips for Accurate Ledger Entry

• Cash Ledger: Only one is allowed per company. Default is “Cash”.
• Sundry Debtors/Creditors: Used for customer and vendor ledgers.
• GST Ledgers: Enable GST and set proper tax rates under “Statutory Details”.
• Fixed Assets: Use for machines, furniture, etc., to calculate depreciation.
• Direct vs Indirect Expenses:
  • Direct = used in production (e.g., Freight Inward)
  • Indirect = post-production/admin expenses (e.g., Salary, Rent)

---

📌 Shortcut Keys You’ll Use

Function	Key
Create Ledger	Alt + C
Multiple Ledgers	Alt + H
Save Entry	Ctrl + A
Search (Tally Prime)	Alt + G
Company Selection	Alt + F3

---