Training By Himanshu

Tag: Accounting in Tally

  • 100 Ledger Examples in Tally with Correct Groups – Complete Guide for Beginners

    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.NoLedger NameGroup in Tally
    1CashCash-in-Hand
    2Axis BankBank Accounts
    3SBI Current AccountBank Accounts
    4Petty CashCash-in-Hand
    5Ram Traders (Debtor)Sundry Debtors
    6Shyam Suppliers (Creditor)Sundry Creditors
    7Sales – DomesticSales Account
    8Sales – ExportSales Account
    9Purchase – Raw MaterialPurchase Account
    10Purchase – Capital GoodsPurchase Account
    11Rent ReceivedIndirect Incomes
    12Rent PaidIndirect Expenses
    13Electricity ChargesIndirect Expenses
    14Salary ExpensesIndirect Expenses
    15Telephone ExpensesIndirect Expenses
    16Commission IncomeIndirect Incomes
    17Commission PaidIndirect Expenses
    18GST PayableDuties & Taxes
    19GST Input CGSTDuties & Taxes
    20GST Input SGSTDuties & Taxes
    21GST Input IGSTDuties & Taxes
    22GST Output CGSTDuties & Taxes
    23GST Output SGSTDuties & Taxes
    24GST Output IGSTDuties & Taxes
    25Provident Fund PayableCurrent Liabilities
    26TDS PayableDuties & Taxes
    27TDS ReceivableLoans & Advances (Assets)
    28Provident Fund Employer ContributionIndirect Expenses
    29Travelling ExpensesIndirect Expenses
    30Legal FeesIndirect Expenses
    31Professional ChargesIndirect Expenses
    32Audit FeesIndirect Expenses
    33Printing & StationeryIndirect Expenses
    34Advertising ExpensesIndirect Expenses
    35Marketing ExpensesIndirect Expenses
    36Interest on LoanIndirect Expenses
    37Interest ReceivedIndirect Incomes
    38DepreciationIndirect Expenses
    39Loan from DirectorSecured Loans
    40Loan from HDFC BankSecured Loans
    41Unsecured Loan from FriendUnsecured Loans
    42Fixed DepositBank Accounts / Investments
    43Share CapitalCapital Account
    44DrawingsCapital Account
    45Investments in SharesInvestments
    46Advance to SupplierLoans & Advances (Assets)
    47Advance from CustomerCurrent Liabilities
    48Outstanding RentCurrent Liabilities
    49Prepaid InsuranceCurrent Assets
    50Insurance PremiumIndirect Expenses

    ✅ Continued — More Ledger Examples

    S.NoLedger NameGroup in Tally
    51Accrued InterestCurrent Assets
    52Sundry IncomeIndirect Incomes
    53Repair & MaintenanceIndirect Expenses
    54AMC ChargesIndirect Expenses
    55Car Fuel ExpensesIndirect Expenses
    56Vehicle MaintenanceIndirect Expenses
    57Office EquipmentFixed Assets
    58Furniture & FixturesFixed Assets
    59ComputersFixed Assets
    60Land & BuildingFixed Assets
    61MachineryFixed Assets
    62ITC ReversalDuties & Taxes
    63RCM PayableDuties & Taxes
    64Freight InwardDirect Expenses
    65Freight OutwardIndirect Expenses
    66Customs DutyDirect Expenses / Duties & Taxes
    67Packing MaterialDirect Expenses
    68Production WagesDirect Expenses
    69Administrative ExpensesIndirect Expenses
    70DonationIndirect Expenses
    71PenaltyIndirect Expenses
    72Bank ChargesIndirect Expenses
    73Bank Interest PaidIndirect Expenses
    74Bad DebtsIndirect Expenses
    75Provision for Bad DebtsProvisions
    76Director’s RemunerationIndirect Expenses
    77Security Deposit PaidLoans & Advances (Assets)
    78Security Deposit ReceivedCurrent Liabilities
    79Office Rent DepositLoans & Advances (Assets)
    80Telephone Bill PayableCurrent Liabilities
    81Office AdvanceLoans & Advances (Assets)
    82ESI PayableCurrent Liabilities
    83Income Tax PayableDuties & Taxes
    84Income Tax AdvanceLoans & Advances (Assets)
    85Dividend PayableCurrent Liabilities
    86Dividend ReceivedIndirect Incomes
    87Partner’s Capital A/cCapital Account
    88Partner’s Drawings A/cCapital Account
    89Partner’s Current A/cCapital Account
    90Salary PayableCurrent Liabilities
    91Outstanding ExpensesCurrent Liabilities
    92Accrued IncomeCurrent Assets
    93Advance TaxLoans & Advances (Assets)
    94Bonus PaidIndirect Expenses
    95GratuityIndirect Expenses
    96House Rent Allowance (HRA)Indirect Expenses
    97Medical ReimbursementIndirect Expenses
    98Loan to EmployeeLoans & Advances (Assets)
    99Vehicle Loan PayableSecured Loans
    100Temporary ImprestLoans & 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

    Tally 100 Ledger ImportDownload XML File in Zip
    Tally 100 Ledger exampleDownload Excel File

    📥 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:

    FieldWhat to Fill
    NameName of the ledger (e.g., “Axis Bank”)
    Alias(Optional) Short name or reference
    UnderSelect the Group (e.g., “Bank Accounts”)
    Inventory ValuesSelect Yes if applicable (for stock ledgers only)
    GST ApplicableYes / No based on ledger use (for taxable ledgers)
    Opening BalanceIf 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”

    FieldEntry
    NameAxis Bank
    UnderBank Accounts
    Opening Balance₹50,000 Dr (if available)
    GST ApplicableNo

    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

    FunctionKey
    Create LedgerAlt + C
    Multiple LedgersAlt + H
    Save EntryCtrl + A
    Search (Tally Prime)Alt + G
    Company SelectionAlt + F3

    Top rated products

  • Step-by-Step Guide to Ledger Creation in Tally

    Step-by-Step Guide to Ledger Creation in Tally

    Creating a ledger in Tally is a fundamental part of accounting, as all financial transactions are recorded through ledgers. In TallyPrime, ledgers are created under Groups (like Capital Account, Sales, Purchase, Cash-in-Hand, etc.).

    🎯 What is a Ledger in Tally?

    A Ledger in Tally is a record of all transactions related to a specific account, such as a bank account, customer, supplier, or expense type.

    Every transaction in Tally must be linked to at least two ledgers.

    🛠️ Steps to Create a Ledger in TallyPrime

    🔹 Method 1: Single Ledger Creation

    1. Gateway of Tally → Create → Accounts Info → Ledgers → Create (Single Ledger)
    2. Fill in the following fields:
      • Name: Name of the ledger (e.g., Cash, State Bank of India, Rent A/c).
      • Alias (Optional): Short name for easier reference.
      • Under: Select the appropriate group (e.g., Cash under Cash-in-Hand, SBI under Bank Accounts, Rent under Indirect Expenses).
      • Inventory values are affected?: Choose Yes only if you’re creating stock-related accounts.
      • Opening Balance: If any, enter it with the correct sign (Dr/Cr).
    3. Press Ctrl + A to save.

    🔹 Method 2: Multiple Ledgers Creation

    1. Gateway of Tally → Create → Accounts Info → Ledgers → Create (Multiple Ledgers)
    2. Select group as “All Items” or a specific group (e.g., Sundry Debtors).
    3. Enter ledger names, group, and opening balances for each.
    4. Press Ctrl + A to save.

    📋 Common Ledger Examples with Groups

    Ledger NameGroupOpening BalanceNature
    CashCash-in-Hand₹10,000 DrAsset
    State Bank of IndiaBank Accounts₹25,000 DrAsset
    Purchase A/cPurchase Accounts₹0Expense
    Sales A/cSales Accounts₹0Income
    Rent Paid A/cIndirect Expenses₹0Expense
    Electricity ChargesIndirect Expenses₹0Expense
    Capital A/cCapital Account₹1,00,000 CrLiability
    Raj TradersSundry Creditors₹15,000 CrLiability
    Om EnterprisesSundry Debtors₹8,000 DrAsset

    🧾 Explanation of Some Ledgers

    1. Cash Ledger

    • Group: Cash-in-Hand
    • Used to record all cash transactions.
    • Only one cash ledger can be created in Tally.

    2. Bank Ledger (e.g., State Bank of India)

    • Group: Bank Accounts
    • Used for bank-related transactions like deposits, withdrawals, cheques, etc.

    3. Customer Ledger (e.g., Om Enterprises)

    • Group: Sundry Debtors
    • Used when you sell goods/services on credit.

    4. Supplier Ledger (e.g., Raj Traders)

    • Group: Sundry Creditors
    • Used for purchases made on credit.

    5. Indirect Expenses (e.g., Rent, Electricity)

    • Group: Indirect Expenses
    • Used to record operational expenses not directly linked to production.

    6. Sales & Purchase Ledger

    • Group: Sales Accounts / Purchase Accounts
    • Required to record daily sales and purchases.

    ✅ Important Notes

    • Avoid duplicating ledger names.
    • Ensure the “Group” selected is correct—Tally uses this for reporting.
    • You can alter, display or delete a ledger anytime through:
      • Gateway of Tally → Alter / Display / Delete → Ledgers

    📌 Practical Example Scenario

    Let’s say you’re starting a business with ₹1,00,000 capital and opening a bank account with ₹25,000 and keeping ₹10,000 as cash.

    You purchase goods worth ₹15,000 on credit from Raj Traders and sell items worth ₹8,000 to Om Enterprises on credit.

    You pay ₹2,000 for Rent and ₹1,000 for Electricity.

    Here’s how you’d create ledgers:

    1. Capital A/c (Under Capital Account, Cr ₹1,00,000)
    2. Cash (Under Cash-in-Hand, Dr ₹10,000)
    3. State Bank of India (Under Bank Accounts, Dr ₹25,000)
    4. Raj Traders (Under Sundry Creditors, Cr ₹15,000)
    5. Om Enterprises (Under Sundry Debtors, Dr ₹8,000)
    6. Purchase A/c (Under Purchase Accounts)
    7. Sales A/c (Under Sales Accounts)
    8. Rent Paid (Under Indirect Expenses)
    9. Electricity Charges (Under Indirect Expenses)

    🧠 Pro Tips

    • Use Alt + G → Chart of Accounts to see all created ledgers.
    • Regularly back up your company data after creating or modifying ledgers.
    • Use Gateway of Tally → Display → Account Books → Ledger to view ledger reports.

    Here are 10 interview questions on the topic of Ledger Creation in Tally, suitable for beginner to intermediate levels:

    ✅ Interview Questionnaire: Ledger Creation in Tally

    1. What is a ledger in Tally? Why is it important in accounting?

    Expected Answer: A ledger is an account used to record all financial transactions related to a specific item or party. Every transaction in Tally is recorded using ledgers, making them essential for maintaining accurate accounts.

    2. How do you create a single ledger in TallyPrime?

    Expected Answer:
    Path: Gateway of Tally → Accounts Info → Ledgers → Create (Single Ledger)
    Fill in fields like Name, Under Group, Opening Balance, etc., then press Ctrl + A to save.

    3. What is the difference between Single Ledger and Multiple Ledger creation in Tally?

    Expected Answer:
    Single Ledger allows creation of one ledger at a time with detailed input.
    Multiple Ledger allows creation of several ledgers on one screen quickly under the same or different groups.

    4. Which group will you select while creating the following ledgers?

    a) Cash
    b) State Bank of India
    c) Rent Paid
    d) Raj Traders
    e) Om Enterprises

    Expected Answer:
    a) Cash-in-Hand
    b) Bank Accounts
    c) Indirect Expenses
    d) Sundry Creditors
    e) Sundry Debtors

    5. Can you create more than one cash ledger in Tally? Why or why not?

    Expected Answer: No, Tally allows only one cash ledger under the “Cash-in-Hand” group because cash must be tracked centrally for compliance and reporting.

    6. What happens if you select the wrong group while creating a ledger?

    Expected Answer: Reports and financial statements will be inaccurate. For example, if Rent Paid is placed under Assets instead of Expenses, it will distort profit & loss calculations.

    7. What is the significance of ‘Opening Balance’ in ledger creation? How do you decide if it’s debit or credit?

    Expected Answer: Opening Balance shows the existing amount in the account.
    Assets and Expenses usually have Debit (Dr) balances, while Liabilities and Incomes have Credit (Cr) balances.

    8. How do you display or alter an existing ledger in Tally?

    Expected Answer:
    Path: Gateway of Tally → Accounts Info → Ledgers → Alter / Display
    Select the ledger from the list to modify or view.

    9. Name five common groups used while creating ledgers in Tally.

    Expected Answer:

    1. Capital Account
    2. Bank Accounts
    3. Cash-in-Hand
    4. Sundry Debtors
    5. Indirect Expenses

    10. What are the consequences of duplicating ledger names in Tally?

    Expected Answer: Tally does not allow exact duplicates, but similar names may cause confusion and errors in data entry, misreporting, and incorrect voucher classification.

    Watch Video on Create Ledger in Tally ERP 9

    Install the No 1 Free Training App

    On sale products