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
- Open the Excel file.
- Manually create ledgers in Tally using this list as a reference.
- Use “Multiple Ledgers” creation to save time.
✅ Option 2: Import via XML (Advanced Users)
- Open Tally (ERP 9 or Prime)
- From Gateway of Tally, press
Alt + O(Import) - Choose Masters
- In “Import File Name”, enter the path to the downloaded XML file
- Example:
C:\Users\YourName\Downloads\Tally_100_Ledger_Import.xml
- Example:
- 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:
- Gateway of Tally → Accounts Info
- Select Ledgers
- Choose Create (under Single Ledger for one-by-one creation)
For Tally Prime:
- Press
Alt + Gand search Create Ledger - 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)
- In ERP 9:
💡 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 |
Top rated products
-
Excel VBA/Macro Masterclass: Automate Excel, Boost Productivity : Classroom /Live Class Training
Original price was: ₹8,500.00.₹6,500.00Current price is: ₹6,500.00. -
Little Monk Buddha Statue Set
Original price was: ₹1,299.00.₹134.00Current price is: ₹134.00. -
Master Excel, Access, Macros & SQL – All in One Course
-
Google Calendar Mastery Training: Learn to Streamline Your Schedule in Just 1 Hour
Original price was: ₹999.00.₹949.00Current price is: ₹949.00. -
Mark & Mia Woven Sleeveless Party Frock – Navy Blue
-
Mastering MS Excel (Pen Drive Course) – Learn Excel Anytime, Anywhere
Original price was: ₹4,999.00.₹1,299.00Current price is: ₹1,299.00. -
Casio MJ-12GST GST Calculator
-
Google Drive Mastery: Learn to Streamline Your Digital Workspace in 27 Minutes
Original price was: ₹999.00.₹949.00Current price is: ₹949.00. -
Shilajit Energy Sips – Natural Energy Boost









