Tag: tally prime ledgers

  • 100 Essential Ledger Accounts for a Logistics Company with Tally Prime Groups & Setup Guide

    ✅ What Are Ledgers?

    Ledgers in accounting are books or digital records where all financial transactions related to a particular account (e.g., fuel expense, customer, vendor) are recorded.


    🧾 100 Ledger Names for a Logistics Company (Categorized)

    🔹 Assets (Group: Assets)

    Ledger NameGroup
    1. Cash in Hand | Cash-in-Hand
    2. Cash at Bank – ICICI | Bank Accounts
    3. Cash at Bank – HDFC | Bank Accounts
    4. Accounts Receivable – ABC Pvt Ltd | Sundry Debtors
    5. Accounts Receivable – XYZ Logistics | Sundry Debtors
    6. Fixed Assets – Office Equipment | Fixed Assets
    7. Fixed Assets – Vehicles | Fixed Assets
    8. Fixed Assets – Computers | Fixed Assets
    9. Fuel Inventory | Stock-in-Hand
    10. Tyres Inventory | Stock-in-Hand
    11. Prepaid Insurance | Current Assets
    12. Prepaid Maintenance | Current Assets
    13. Input GST | Duties & Taxes
    14. TDS Receivable | Current Assets
    15. Advances to Staff | Loans & Advances (Asset)

    🔹 Liabilities (Group: Liabilities)

    Ledger NameGroup
    1. Accounts Payable – DEF Transporters | Sundry Creditors
    2. Accounts Payable – LMN Fuel Suppliers | Sundry Creditors
    3. TDS Payable | Duties & Taxes
    4. GST Payable | Duties & Taxes
    5. Loan – HDFC | Secured Loans
    6. Loan – ICICI | Secured Loans
    7. Provident Fund Payable | Current Liabilities
    8. ESI Payable | Current Liabilities
    9. Salary Payable | Current Liabilities
    10. Bonus Payable | Current Liabilities

    🔹 Income (Group: Indirect Incomes)

    Ledger NameGroup
    1. Freight Income – Domestic | Sales Accounts
    2. Freight Income – International | Sales Accounts
    3. Loading Charges Income | Indirect Incomes
    4. Warehousing Income | Indirect Incomes
    5. Handling Charges Income | Indirect Incomes
    6. Demurrage Income | Indirect Incomes
    7. Detention Charges Received | Indirect Incomes
    8. Packaging Income | Indirect Incomes
    9. Customs Clearance Income | Indirect Incomes
    10. Other Miscellaneous Income | Indirect Incomes

    🔹 Expenses (Group: Indirect Expenses)

    Ledger NameGroup
    1. Fuel Expense | Indirect Expenses
    2. Vehicle Maintenance | Indirect Expenses
    3. Toll Charges | Indirect Expenses
    4. Insurance – Vehicle | Indirect Expenses
    5. Insurance – Office | Indirect Expenses
    6. Driver Salary | Indirect Expenses
    7. Cleaner Salary | Indirect Expenses
    8. Staff Salary | Indirect Expenses
    9. Bonus Expense | Indirect Expenses
    10. Conveyance | Indirect Expenses
    11. Office Rent | Indirect Expenses
    12. Godown Rent | Indirect Expenses
    13. Electricity Charges | Indirect Expenses
    14. Water Charges | Indirect Expenses
    15. Telephone Expenses | Indirect Expenses
    16. Mobile Expenses | Indirect Expenses
    17. Internet Expenses | Indirect Expenses
    18. Postage & Courier | Indirect Expenses
    19. Printing & Stationery | Indirect Expenses
    20. Legal & Professional Fees | Indirect Expenses
    21. Audit Fees | Indirect Expenses
    22. Bank Charges | Indirect Expenses
    23. Loading & Unloading Expense | Indirect Expenses
    24. Packaging Expense | Indirect Expenses
    25. Demurrage Charges Paid | Indirect Expenses
    26. Detention Charges Paid | Indirect Expenses
    27. Security Charges | Indirect Expenses
    28. Repairs – Building | Indirect Expenses
    29. Repairs – Equipment | Indirect Expenses
    30. Repairs – Vehicles | Indirect Expenses
    31. Training Expenses | Indirect Expenses
    32. Marketing & Advertisement | Indirect Expenses
    33. Business Promotion | Indirect Expenses
    34. Licenses & Permits | Indirect Expenses
    35. IT Support Charges | Indirect Expenses
    36. Software Subscription | Indirect Expenses
    37. ERP Charges | Indirect Expenses
    38. Interest on Loan – HDFC | Indirect Expenses
    39. Interest on Loan – ICICI | Indirect Expenses
    40. Penalty Charges | Indirect Expenses
    41. Miscellaneous Expenses | Indirect Expenses

    🔹 Customers (Group: Sundry Debtors)

    Ledger NameGroup
    1. ABC Pvt Ltd | Sundry Debtors
    2. XYZ Logistics | Sundry Debtors
    3. JKL Exporters | Sundry Debtors
    4. MNO Traders | Sundry Debtors
    5. PQR Enterprises | Sundry Debtors
    6. STU Distributors | Sundry Debtors
    7. VWX Manufacturers | Sundry Debtors
    8. BCD Retailers | Sundry Debtors
    9. HIJ Warehousing | Sundry Debtors
    10. LMN Shipping | Sundry Debtors

    🔹 Vendors (Group: Sundry Creditors)

    Ledger NameGroup
    1. Diesel Supplier – Reliance | Sundry Creditors
    2. Diesel Supplier – HP | Sundry Creditors
    3. Spare Parts Supplier – ABC Auto | Sundry Creditors
    4. Tyre Supplier – MRF | Sundry Creditors
    5. Insurance – ICICI Lombard | Sundry Creditors
    6. Mechanic – Local Garage | Sundry Creditors
    7. Transport Union Fees | Sundry Creditors
    8. Toll Vendor – FASTag | Sundry Creditors
    9. Loading Labor Contractor | Sundry Creditors
    10. Internet Provider – Airtel | Sundry Creditors
    11. Security Contractor | Sundry Creditors
    12. Advertising Agency | Sundry Creditors
    13. Accounting Consultant | Sundry Creditors
    14. Legal Advisor | Sundry Creditors

    📌 How to Create a Ledger in Tally Prime

    Steps:

    1. Gateway of Tally → Create → Ledger
    2. Enter:
      • Name of the ledger (e.g., “Fuel Expense”)
      • Group (e.g., “Indirect Expenses”)
      • Enable GST/TDS/Bank details if required
    3. If there’s any opening balance, enter it (positive for assets, negative for liabilities)
    4. Press Ctrl + A to save

    💼 When to Enter Opening Balances?

    • For Sundry Debtors/Creditors → Opening balance is the amount pending to be received/paid at the start of books.
    • For Cash/Bank → Enter the actual balance on the start date.
    • For Loans or Liabilities → Enter the outstanding amount as a negative balance.
    • For Assets like vehicles → Enter the book value at the time of starting Tally.

    ✅ Maintaining ledgers with proper groups ensures accurate reporting, correct GST calculations, and easy audit trail.


  • 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

    📥 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