Training By Himanshu

Tag: Tally training material

  • 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

  • 100 Sample Voucher Entries for Tally ERP and Tally Prime

    If you’re learning Tally ERP or TallyPrime and want to master voucher entry, you’re in the right place. In this article, we’ve compiled 100 real-world voucher entry examples covering all essential transaction types used in accounting.

    Whether you’re a student, trainer, or accounting professional, this ready-to-use dataset will help you:

    • Understand how various vouchers are recorded
    • Practice manual entry in Tally
    • Prepare for job interviews or accounting tests
    • Use it as a base to create Tally import-ready data

    The examples include:

    • Payment, Receipt, Journal
    • Purchase & Sales entries
    • Contra transactions
    • Credit/Debit Notes
    • Payroll Vouchers

    💾 Bonus: You can download the complete Excel file for free and use it to practice directly in Tally.

    🔸 1–15: Payment Vouchers

    DateVoucher TypeParticularsDebitCredit
    01-04-2024PaymentRent A/c Dr.₹15,000To Cash A/c
    02-04-2024PaymentElectricity Exp. A/c Dr.₹3,500To Bank A/c
    03-04-2024PaymentInternet Charges A/c Dr.₹1,200To Cash A/c
    04-04-2024PaymentTelephone Exp. A/c Dr.₹800To Bank A/c
    05-04-2024PaymentSalaries A/c Dr.₹60,000To Bank A/c
    06-04-2024PaymentOffice Supplies A/c Dr.₹2,000To Cash A/c
    07-04-2024PaymentRepairs A/c Dr.₹1,500To Cash A/c
    08-04-2024PaymentStationery A/c Dr.₹1,000To Bank A/c
    09-04-2024PaymentAudit Fees A/c Dr.₹5,000To Bank A/c
    10-04-2024PaymentTransportation A/c Dr.₹2,500To Cash A/c
    11-04-2024PaymentCleaning Exp. A/c Dr.₹700To Bank A/c
    12-04-2024PaymentPetrol A/c Dr.₹1,800To Cash A/c
    13-04-2024PaymentAdvertising Exp. A/c Dr.₹4,500To Bank A/c
    14-04-2024PaymentSoftware License A/c Dr.₹8,000To Bank A/c
    15-04-2024PaymentTravel Expenses A/c Dr.₹6,000To Bank A/c

    🔸 16–30: Receipt Vouchers

    DateVoucher TypeParticularsDebitCredit
    16-04-2024ReceiptCash A/c Dr.₹25,000To ABC Ltd.
    17-04-2024ReceiptBank A/c Dr.₹45,000To Sales A/c
    18-04-2024ReceiptCash A/c Dr.₹10,000To Mr. Sharma
    19-04-2024ReceiptBank A/c Dr.₹20,000To Services Income A/c
    20-04-2024ReceiptBank A/c Dr.₹30,000To Debtors A/c
    21-04-2024ReceiptCash A/c Dr.₹8,000To Commission Income A/c
    22-04-2024ReceiptBank A/c Dr.₹12,000To ABC Traders
    23-04-2024ReceiptCash A/c Dr.₹6,000To Rent Received A/c
    24-04-2024ReceiptBank A/c Dr.₹15,000To Interest Income A/c
    25-04-2024ReceiptCash A/c Dr.₹5,000To Consultancy Income A/c
    26-04-2024ReceiptBank A/c Dr.₹50,000To Mr. Rajesh
    27-04-2024ReceiptBank A/c Dr.₹18,000To Mr. Thomas
    28-04-2024ReceiptCash A/c Dr.₹2,500To Misc. Income A/c
    29-04-2024ReceiptBank A/c Dr.₹60,000To Sales A/c
    30-04-2024ReceiptBank A/c Dr.₹40,000To Sundry Debtors

    🔸 31–45: Journal Vouchers

    DateVoucher TypeParticularsDebitCredit
    01-05-2024JournalDepreciation A/c Dr.₹7,000To Machinery A/c
    02-05-2024JournalInterest A/c Dr.₹1,500To Accrued Interest
    03-05-2024JournalOutstanding Exp. A/c Dr.₹2,000To Salary A/c
    04-05-2024JournalPrepaid Rent A/c Dr.₹1,000To Rent A/c
    05-05-2024JournalProvision for Tax A/c Dr.₹5,000To Tax Payable A/c
    06-05-2024JournalCapital A/c Dr.₹25,000To Bank A/c
    07-05-2024JournalDrawings A/c Dr.₹3,000To Cash A/c
    08-05-2024JournalSalary A/c Dr.₹60,000To Outstanding Salary
    09-05-2024JournalRent A/c Dr.₹12,000To Outstanding Rent
    10-05-2024JournalCommission A/c Dr.₹4,000To Payable A/c
    11-05-2024JournalPenalty Charges A/c Dr.₹500To Vendor A/c
    12-05-2024JournalInput GST A/c Dr.₹2,000To Output GST A/c
    13-05-2024JournalInterest Receivable A/c Dr.₹1,200To Interest Income A/c
    14-05-2024JournalBad Debts A/c Dr.₹5,000To Debtors A/c
    15-05-2024JournalAccrued Income A/c Dr.₹3,500To Income A/c

    🔸 46–60: Purchase Vouchers

    DateVoucher TypeSupplierDebit (Purchase)Credit (Supplier)
    01-06-2024PurchaseABC Traders₹10,000ABC Traders
    02-06-2024PurchaseXYZ Pvt. Ltd.₹25,000XYZ Pvt. Ltd.
    03-06-2024PurchasePQR Industries₹12,500PQR Industries
    04-06-2024PurchaseEcom Sales₹15,000Ecom Sales
    05-06-2024PurchaseTech Supplies₹8,000Tech Supplies
    06-06-2024PurchaseOffice Deals₹6,000Office Deals
    07-06-2024PurchasePaper Mart₹3,500Paper Mart
    08-06-2024PurchaseBilling Solutions₹9,000Billing Solutions
    09-06-2024PurchaseCentral Traders₹20,000Central Traders
    10-06-2024PurchaseArora Equipments₹11,000Arora Equipments
    11-06-2024PurchaseSkytech Supplies₹17,000Skytech Supplies
    12-06-2024PurchaseDelta Electronics₹19,500Delta Electronics
    13-06-2024PurchaseOffice Mart₹4,500Office Mart
    14-06-2024PurchaseSunrise Solutions₹13,000Sunrise Solutions
    15-06-2024PurchaseVision Traders₹7,500Vision Traders

    🔸 61–75: Sales Vouchers

    DateVoucher TypeCustomerDebit (Customer)Credit (Sales)
    16-06-2024SalesMr. Arjun₹20,000Sales A/c
    17-06-2024SalesABC Corp₹30,000Sales A/c
    18-06-2024SalesRamesh Agencies₹15,000Sales A/c
    19-06-2024SalesIT World₹12,000Sales A/c
    20-06-2024SalesBright Retail₹10,000Sales A/c
    21-06-2024SalesJay Traders₹5,000Sales A/c
    22-06-2024SalesNitin Stores₹18,000Sales A/c
    23-06-2024SalesEasyTech₹25,000Sales A/c
    24-06-2024SalesCool Mart₹9,000Sales A/c
    25-06-2024SalesElectro Point₹6,000Sales A/c
    26-06-2024SalesHonest Retail₹11,000Sales A/c
    27-06-2024SalesSagar Traders₹13,500Sales A/c
    28-06-2024SalesMax Systems₹7,500Sales A/c
    29-06-2024SalesB2B Supplies₹17,000Sales A/c
    30-06-2024SalesMohit Traders₹22,000Sales A/c

    🔸 76–85: Contra Vouchers

    DateVoucher TypeParticularsDebitCredit
    01-07-2024ContraBank A/c Dr.₹10,000To Cash A/c
    02-07-2024ContraCash A/c Dr.₹5,000To Bank A/c
    03-07-2024ContraBank A/c Dr.₹15,000To Bank A/c (Transfer)
    04-07-2024ContraPetty Cash A/c Dr.₹3,000To Bank A/c
    05-07-2024ContraCash A/c Dr.₹7,000To Bank A/c
    06-07-2024ContraBank A/c Dr.₹4,000To Petty Cash A/c
    07-07-2024ContraBank A/c Dr.₹20,000To Cash A/c
    08-07-2024ContraBank A/c Dr.₹10,000To Bank A/c
    09-07-2024ContraCash A/c Dr.₹2,000To Bank A/c
    10-07-2024ContraPetty Cash A/c Dr.₹1,000To Bank A/c

    🔸 86–90: Debit Note Vouchers

    DateVoucher TypeParticularsDebitCredit
    11-07-2024Debit NoteABC Traders A/c Dr.₹2,000To Purchase Return A/c
    12-07-2024Debit NoteXYZ Pvt. Ltd. A/c Dr.₹3,000To Purchase Return A/c
    13-07-2024Debit NoteEcom Sales A/c Dr.₹1,500To Purchase Return A/c
    14-07-2024Debit NoteCentral Traders A/c Dr.₹2,500To Purchase Return A/c
    15-07-2024Debit NoteVision Traders A/c Dr.₹1,200To Purchase Return A/c

    🔸 91–95: Credit Note Vouchers

    DateVoucher TypeParticularsDebitCredit
    16-07-2024Credit NoteSales Return A/c Dr.₹3,000To Arjun A/c
    17-07-2024Credit NoteSales Return A/c Dr.₹2,000To ABC Corp A/c
    18-07-2024Credit NoteSales Return A/c Dr.₹1,500To IT World A/c
    19-07-2024Credit NoteSales Return A/c Dr.₹2,500To Jay Traders A/c
    20-07-2024Credit NoteSales Return A/c Dr.₹1,000To Cool Mart A/c

    🔸 96–100: Payroll Vouchers

    DateVoucher TypeParticularsDebitCredit
    21-07-2024PayrollSalary A/c Dr.₹40,000To Bank A/c
    22-07-2024PayrollWages A/c Dr.₹15,000To Cash A/c
    23-07-2024PayrollBonus A/c Dr.₹5,000To Bank A/c
    24-07-2024PayrollProvident Fund A/c₹4,000To Bank A/c
    25-07-2024PayrollGratuity A/c Dr.₹2,500To Bank A/c

    ✅ The Excel file contains all 100 Tally voucher entries

    Tally Voucher Entries 100 ExamplesDownload

    ✅ How to Do Voucher Entry in Tally – Step-by-Step Guide

    Tally uses voucher entries to record all business transactions—like purchases, sales, expenses, payments, etc.—following double-entry accounting.

    🧾 Step 1: Open Tally and Select Company

    • Launch TallyPrime or Tally ERP 9.
    • From the Company Info screen, either:
      • Select an existing company, or
      • Press Alt + F3 to create a new company (enter name, address, financial year, etc.).

    🧾 Step 2: Enable Required Vouchers (Optional)

    Some vouchers like Debit Note, Credit Note, or Payroll may not appear by default.

    • Go to: Gateway of Tally → F11: Features → Accounting Features
    • Enable:
      • Use debit/credit notes
      • Maintain payroll
      • Enable GST/TDS if required

    🧾 Step 3: Create Ledger Accounts (If Not Already Created)

    You need ledger accounts for customers, suppliers, expenses, income, etc.

    • Go to: Gateway of Tally → Accounts Info → Ledgers → Create
    • Example:
      • ABC Traders under Sundry Creditors
      • Sales A/c under Sales Accounts
      • Bank A/c under Bank Accounts
      • Salary A/c under Indirect Expenses

    🧾 Step 4: Go to Accounting Vouchers

    • Gateway of Tally → Vouchers
    • You’ll see a vertical menu with voucher types.

    Use shortcut keys to select the voucher type:

    Voucher TypeShortcut Key
    PaymentF5
    ReceiptF6
    JournalF7
    SalesF8
    PurchaseF9
    Debit NoteCtrl+F9
    Credit NoteCtrl+F8
    ContraF4
    PayrollCtrl+F4

    🧾 Step 5: Enter the Voucher

    Example: Entering a Payment Voucher

    1. Press F5 for Payment
    2. Date: Enter the date of transaction (e.g., 01-04-2024)
    3. Account: Select the expense or ledger being paid (e.g., Rent A/c)
    4. Amount: Enter the amount
    5. By Account: Select the mode of payment (e.g., Bank A/c or Cash A/c)
    6. Enter narration (optional): e.g., “Rent for April 2024”
    7. Press Enter and accept with Ctrl + A to save

    🧾 Step 6: Repeat for Other Transactions

    Use the shortcut keys to enter:

    • Receipts for money received
    • Sales/Purchase for goods/services sold or bought
    • Contra for cash deposit/withdrawals between bank & cash
    • Journal for non-cash adjustments
    • Credit/Debit Notes for returns
    • Payroll for salary processing

    🧾 Step 7: Verify Entries in Day Book or Ledger

    • Go to Display → Day Book to review all transactions
    • Use Alt + F1 for detailed view
    • You can also go to Display → Account Books → Ledger to see specific ledger-wise details

    📝 Example Voucher Entry

    Rent Paid ₹15,000 by Cash

    • Voucher Type: Payment (F5)
    • Debit: Rent A/c Dr. ₹15,000
    • Credit: Cash A/c ₹15,000
    • Narration: “Rent paid for April”

    ✅ Tips:

    • Use Tab to move between fields.
    • Use Ctrl+A to save quickly.
    • Maintain narrations for clarity.
    • You can configure GST in vouchers if enabled in features.

    📘 Want to Practice These Tally Voucher Entries Like a Pro?

    If you’re just starting out or aiming to sharpen your skills in Tally ERP 9, TallyPrime, GST, and Microsoft Excel, I highly recommend checking out this step-by-step practical training course 👇
    🔗 https://www.iturninstitute.in/course/tally-erp-9-tallyprime-gst-microsoft-excel-training-basic-to-advanced/

    Designed for students, job seekers, and working professionals alike, this all-in-one course will teach you how to:

    • Handle real-world accounting tasks confidently
    • Manage payroll, inventory, and GST filings
    • Build clean Excel reports for MIS and data analysis

    🎥 18.5 hours of guided video lessons
    📄 20+ downloadable templates and real data
    📊 Based on the latest industry practices
    🏅 Certificate of Completion included

    Learn at your own pace, and start applying these skills immediately—whether in interviews, internships, or your current job.

    Top rated products