Tag: Complete Guide

  • Tally Prime – Ledgers and Groups

    What is a Ledger?

    • Ledger is like a detailed record or account that tracks all transactions related to a specific item or entity.
    • Think of it as a notebook where you write down everything that happens related to one thing, like all the money you spend on rent or all the sales you make.

    Examples:

    • Cash Ledger: Tracks all cash transactions (money coming in and going out).
    • Sales Ledger: Tracks all the sales made by the business.
    • Salary Ledger: Tracks the payments made to employees.

    What is a Group?

    • Group is a category that helps organize ledgers in Tally Prime.
    • It’s like a folder where similar types of ledgers are kept together. This makes it easier to manage and find them.
    • Groups help Tally Prime understand what kind of transactions are recorded in each ledger.

    Examples:

    • Capital Account: This is a group of ledgers involving owners’ investment in the business.
    • Sundry Debtors: These are the various individuals or firms from whom the business has to recover.
    • Fixed Assets: A group containing ledgers for items owned by the business, like furniture or any type of machinery.

    Why Use Ledgers and Groups?

    • Organized Record-Keeping: By using ledgers and groups, you can keep your financial records organized and easy to understand.
    • Accurate Reporting: Tally Prime can generate accurate financial reports, like balance sheets and profit & loss statements, based on the information in ledgers.
    • Simplifies Management: Groups help you manage similar accounts together, making it easier to analyze the financial health of the business.

    Ledgers as a Diary:

    This is how one can understand what a ledger is. A ledger is just like a diary where one writes everything concerning a particular subject. For example, you have a daily journal where you write down all your daily expenses. For example, you have a daily journal in which you write down all your expenses each day. Every page may be allocated to various spends one makes, such as food, travel, or entertainment.

    Groups as Categories:

    Now, these pages in your diary will be divided based on sections or categories. For example, you can have “Food,” another “Travel,” and another “Entertainment.” Then within each category, there are those sheets of pages where you write down the specifics.
    In accounting, these categories are termed “Groups”, with the sheets being “Ledgers.”


    Example:

    For example, one group could be “Expenses,” while sub-ledgers might include “Rent,” “Groceries,” or “Utilities.” All the transactions related to each particular expense would then be noted in its corresponding ledger.

    Expenses (Group)
    ├── Rent (Ledger)
    ├── Salary (Ledger)
    └── Utilities (Ledger)

    In Tally Prime, there are a total of 28 predefined groups. These groups are used to classify and organize ledgers according to their nature and purpose. Here’s a breakdown:

    15 Primary Groups

    These are the main groups under which all other groups and ledgers are classified.

    1. Capital Account
    2. Reserves & Surplus
    3. Loans (Liability)
    4. Current Liabilities
    5. Current Assets
    6. Fixed Assets
    7. Investments
    8. Branch/Divisions
    9. Miscellaneous Expenses (Asset)
    10. Suspense Account
    11. Sales Accounts
    12. Purchase Accounts
    13. Direct Incomes
    14. Direct Expenses
    15. Indirect Incomes

    13 Subgroups

    These subgroups are categorized under the primary groups:

    1. Sundry Creditors (Under Current Liabilities)
    2. Sundry Debtors (Under Current Assets)
    3. Cash-in-Hand (Under Current Assets)
    4. Bank Accounts (Under Current Assets)
    5. Loans & Advances (Asset) (Under Current Assets)
    6. Duties & Taxes (Under Current Liabilities)
    7. Provisions (Under Current Liabilities)
    8. Stock-in-Hand (Under Current Assets)
    9. Deposits (Asset) (Under Current Assets)
    10. Secured Loans (Under Loans (Liability))
    11. Unsecured Loans (Under Loans (Liability))
    12. Branch/Division (Under Capital Account)
    13. Suspense Account (Under Current Liabilities)

    Custom Groups

    • You can also create custom groups based on specific business needs. These custom groups can be placed under any of the primary groups listed above.

    Activity :

    After Company Creation > Gateway to Tally > Under Masters > H: Chart of Accounts > Groups :

    Here’s a detailed explanation of all 28 groups in Tally Prime, along with examples of ledgers that fall under each group:

    1. Capital Account

    • Purpose: Tracks the owner’s equity or investment in the business and any withdrawals.
    • Examples:
      • Capital Ledger: Represents the owner’s investment.
      • Drawings Ledger: Tracks money withdrawn by the owner for personal use.
      • Amutha Capital a/c
      • Owner Name Capital A/c

    2. Reserves & Surplus

    • Purpose: Represents accumulated profits retained in the business or any reserves.
    • Examples:
      • General Reserve Ledger: A reserve fund for future contingencies.
      • Profit & Loss Account: If there’s a profit carried forward from previous years.

    3. Loans (Liability)

    • Purpose: Tracks borrowed funds that the business needs to repay.
    • Examples:
      • Bank Loan Ledger: Records loans taken from banks.
      • Debenture Ledger: Tracks money raised through debentures.

    4. Current Liabilities

    • Purpose: Represents short-term obligations or debts that the business must pay within a year.
    • Examples:
      • Sundry Creditors Ledger: Money owed to suppliers or vendors.
      • Outstanding Expenses Ledger: Expenses that have been incurred but not yet paid.

    5. Current Assets

    • Purpose: Represents assets that can be converted into cash within a year.
    • Examples:
      • Sundry Debtors Ledger: Tracks amounts receivable from customers.
      • Cash Ledger: Records all cash transactions.

    6. Fixed Assets

    • Purpose: Represents long-term assets that the business owns, like property, machinery, etc.
    • Examples:
      • Building Ledger: Tracks the value of buildings owned.
      • Machinery Ledger: Represents the value of machinery used in the business.

    7. Investments

    • Purpose: Tracks investments made by the business in other companies, stocks, bonds, etc.
    • Examples:
      • Shares Ledger: Records the purchase of shares in other companies.
      • Government Bonds Ledger: Tracks investments in government bonds.

    8. Branch/Divisions

    • Purpose: Used to track accounts for different branches or divisions within the same company.
    • Examples:
      • Branch A Ledger: Records transactions specific to Branch A.
      • Division 1 Ledger: Tracks transactions related to a specific division within the company.

    9. Miscellaneous Expenses (Asset)

    • Purpose: Represents expenses that are deferred and written off over a period of time.
    • Examples:
      • Preliminary Expenses Ledger: Records expenses incurred during the formation of the company.
      • Deferred Revenue Expenditure Ledger: Expenses to be written off gradually.

    10. Suspense Account

    • Purpose: Used temporarily for transactions where the correct ledger is not yet determined.
    • Examples:
      • Suspense Ledger: Any uncertain or incomplete transactions are recorded here temporarily.

    11. Sales Accounts

    • Purpose: Tracks income earned from selling goods or services.
    • Examples:
      • Domestic Sales Ledger: Records sales made within the country.
      • Export Sales Ledger: Tracks sales made to customers outside the country.
      • Sales A/c
      • Cash Sales A/c
      • Credit Sales A/c

    12. Purchase Accounts

    • Purpose: Tracks the cost of goods or services purchased by the business.
    • Examples:
      • Local Purchases Ledger: Records purchases made from local suppliers.
      • Import Purchases Ledger: Tracks purchases made from foreign suppliers.
      • Purchase A/c
      • Cash Purchase A/c
      • Cash Sales A/c
      • Purchase Return A/c

    13. Direct Incomes

    • Purpose: Represents income directly related to the core business activities.
    • Examples:
      • Commission Received Ledger: Tracks commission earned from sales.
      • Service Income Ledger: Records income from services provided.
      • Professional Charges A/c
      • Consulting Fees A/c
      • Service Charges A/c

    14. Direct Expenses

    • Purpose: Represents expenses directly related to the production or purchase of goods.
    • Examples:
      • Freight Inwards Ledger: Tracks transportation costs for bringing goods into the business.
      • Raw Material Ledger: Records the cost of raw materials used in production.
      • Carriage inwards A/c
      • Wages A/c

    15. Indirect Incomes

    • Purpose: Represents income from activities not directly related to the primary business operations.
    • Examples:
      • Interest Received Ledger: Tracks interest earned on deposits or investments.
      • Rental Income Ledger: Records income from renting out property or equipment.
      • Rent Received A/c
      • Interest Received A/c
      • Commission Received A/c

    16. Indirect Expenses

    • Purpose: Represents expenses not directly related to the production of goods but necessary for running the business.
    • Examples:
      • Rent Ledger: Tracks payments made for renting office space.
      • Salary Ledger: Records payments made to employees.
      • Telephone Charges A/c
      • Bank Charges A/c
      • Rent Charges A/c
      • Electricity Expenses

    17. Sundry Creditors (Under Current Liabilities)

    • Purpose: Tracks amounts owed to suppliers or vendors.
    • Examples:
      • Raja Suppliers Ledger: Records money owed to Raja Suppliers.
      • Kumar Traders Ledger: Tracks amounts payable to Kumar Traders.
      • Balram A/c
      • Rajan A/c

    18. Sundry Debtors (Under Current Assets)

    • Purpose: Tracks money receivable from customers who purchased goods or services on credit.
    • Examples:
      • Suresh & Co Customer Ledger: Records amounts receivable from Customer Suresh & Co
      • Ramu A/c Ledger: Tracks money owed by Ramu A/c

    19. Cash-in-Hand (Under Current Assets)

    • Purpose: Tracks all cash transactions of the business.
    • Examples:
      • Main Cash Ledger: Records cash held by the business.
      • Petty Cash Ledger: Tracks small cash expenses.

    20. Bank Accounts (Under Current Assets)

    • Purpose: Tracks all transactions related to bank accounts.
    • Examples:
      • HDFC Bank Ledger: Records transactions with HDFC Bank.
      • ICICI Bank Ledger: Tracks transactions with ICICI Bank.

    21. Loans & Advances (Asset) (Under Current Assets)

    • Purpose: Represents loans given by the business to others.
    • Examples:
      • Advance to Supplier Ledger: Records advance payments made to suppliers.
      • Loan to Employee Ledger: Tracks loans given to employees.

    22. Duties & Taxes (Under Current Liabilities)

    • Purpose: Tracks amounts related to taxes and duties payable to the government.
    • Examples:
      • GST Ledger: Records Goods and Services Tax collected and payable.
      • Income Tax Ledger: Tracks the business’s income tax liability.

    23. Provisions (Under Current Liabilities)

    • Purpose: Represents amounts set aside for future expenses or liabilities.
    • Examples:
      • Provision for Taxation Ledger: Tracks amounts set aside for tax payments.
      • Provision for Doubtful Debts Ledger: Records provisions made for bad debts.

    24. Stock-in-Hand (Under Current Assets)

    • Purpose: Tracks the value of goods in stock.
    • Examples:
      • Finished Goods Ledger: Records the value of finished goods in inventory.
      • Raw Materials Ledger: Tracks the value of raw materials in stock.

    25. Deposits (Asset) (Under Current Assets)

    • Purpose: Represents deposits made by the business that are expected to be returned.
    • Examples:
      • Security Deposit Ledger: Tracks deposits given for securing premises or equipment.
      • Fixed Deposit Ledger: Records fixed deposits made with banks.

    26. Secured Loans (Under Loans (Liability))

    • Purpose: Tracks loans that are backed by collateral or security.
    • Examples:
      • Mortgage Loan Ledger: Records loans taken against property.
      • Car Loan Ledger: Tracks loans secured against a vehicle.

    27. Unsecured Loans (Under Loans (Liability))

    • Purpose: Tracks loans that are not backed by any collateral.
    • Examples:
      • Personal Loan Ledger: Records personal loans taken by the business.
      • Overdraft Ledger: Tracks overdraft facilities provided by banks.

    28. Branch/Division (Under Capital Account)

    • Purpose: Tracks accounts for different branches or divisions within the same company.
    • Examples:
      • Branch A Capital Ledger: Records the capital allocated to Branch A.
      • Division 1 Capital Ledger: Tracks the capital allocated to a specific division.
    GroupLedger NamePurpose
    Capital AccountCapitalOwner’s investment in the business.
    Capital AccountDrawingsOwner’s withdrawals for personal use.
    Capital AccountPartner A CapitalCapital contribution by Partner A.
    Capital AccountPartner B CapitalCapital contribution by Partner B.
    Reserves & SurplusGeneral ReserveAccumulated profits set aside for future use.
    Reserves & SurplusProfit & Loss A/CProfits or losses carried forward.
    Reserves & SurplusRetained EarningsProfits retained in the business.
    Reserves & SurplusDividend ReserveAmount reserved for dividend distribution.
    Loans (Liability)Bank LoanLoans taken from banks.
    Loans (Liability)DebenturesFunds raised through debentures.
    Loans (Liability)Loan from DirectorsLoans taken from company directors.
    Loans (Liability)Mortgage LoanLoans secured against property.
    Current LiabilitiesSundry CreditorsAmounts payable to suppliers or vendors.
    Current LiabilitiesOutstanding ExpensesExpenses incurred but not yet paid.
    Current LiabilitiesDuties & TaxesTaxes payable (e.g., GST, VAT).
    Current LiabilitiesSalary PayableSalaries due but not yet paid.
    Current LiabilitiesTDS PayableTax Deducted at Source yet to be paid to the government.
    Current LiabilitiesGST PayableGoods and Services Tax payable.
    Current LiabilitiesProfessional Tax PayableProfessional tax due for payment.
    Current LiabilitiesProvident Fund PayableProvident fund contributions due.
    Current AssetsSundry DebtorsMoney receivable from customers.
    Current AssetsCashTracks all cash transactions.
    Current AssetsHDFC Bank A/CTransactions related to HDFC Bank.
    Current AssetsICICI Bank A/CTransactions related to ICICI Bank.
    Current AssetsAdvance to SuppliersPayments made in advance to suppliers.
    Current AssetsPrepaid InsuranceInsurance premiums paid in advance.
    Current AssetsPrepaid RentRent paid in advance.
    Current AssetsPetty CashSmall cash expenses.
    Current AssetsAdvances to EmployeesMoney advanced to employees.
    Current AssetsBills ReceivableBills that are due for payment from customers.
    Current AssetsFixed DepositMoney deposited in fixed-term accounts.
    Current AssetsInvestments in SharesInvestments in company shares.
    Fixed AssetsBuildingValue of buildings owned by the business.
    Fixed AssetsMachineryValue of machinery used in the business.
    Fixed AssetsFurniture & FixturesValue of office furniture and fixtures.
    Fixed AssetsComputersValue of computers and IT equipment.
    Fixed AssetsVehiclesValue of vehicles owned by the business.
    Fixed AssetsOffice EquipmentValue of office equipment (e.g., printers, fax machines).
    Fixed AssetsLandValue of land owned by the business.
    Fixed AssetsAir Conditioning EquipmentValue of AC units installed in the office.
    Fixed AssetsTools & EquipmentValue of tools used in manufacturing or operations.
    InvestmentsShares in ABC Ltd.Investment in shares of ABC Ltd.
    InvestmentsMutual FundsInvestments in mutual funds.
    InvestmentsGovernment BondsInvestments in government bonds.
    InvestmentsFixed DepositsFixed deposits with banks.
    InvestmentsReal Estate InvestmentInvestments in real estate properties.
    InvestmentsInvestment in Subsidiary CompanyInvestment in a subsidiary company.
    InvestmentsInvestment in Partnership FirmInvestments in a partnership business.
    Sales AccountsLocal SalesIncome from sales within the country.
    Sales AccountsExport SalesIncome from sales outside the country.
    Sales AccountsSales of ServicesIncome from services provided.
    Sales AccountsSales of GoodsIncome from the sale of goods.
    Sales AccountsSales ReturnsReturns of sold goods.
    Purchase AccountsLocal PurchasesCost of goods purchased from local suppliers.
    Purchase AccountsImport PurchasesCost of goods purchased from foreign suppliers.
    Purchase AccountsPurchase of Raw MaterialsCost of raw materials purchased for production.
    Purchase AccountsPurchase of Office SuppliesCost of office supplies purchased.
    Purchase AccountsPurchase ReturnsReturns of purchased goods.
    Purchase AccountsFreight InwardsCost of transportation for purchased goods.
    Direct IncomesCommission ReceivedIncome from commissions earned on sales.
    Direct IncomesService IncomeIncome from services provided.
    Direct IncomesRoyalty IncomeIncome from royalties.
    Direct IncomesInterest on Loans GivenInterest earned on loans provided by the business.
    Direct IncomesDividend ReceivedDividends received from investments.
    Direct ExpensesFreight InwardsTransportation costs for bringing goods into the business.
    Direct ExpensesRaw Material PurchasesCosts of raw materials used in production.
    Direct ExpensesPower & FuelExpenses for power and fuel used in production.
    Direct ExpensesWagesWages paid to labor directly involved in production.
    Direct ExpensesFactory RentRent for factory premises.
    Indirect IncomesInterest ReceivedIncome from interest earned on deposits.
    Indirect IncomesRental IncomeIncome from renting out property or equipment.
    Indirect IncomesMiscellaneous IncomeIncome from other sources not directly related to core business.
    Indirect IncomesProfit on Sale of AssetsGain from the sale of fixed assets.
    Indirect IncomesDiscount ReceivedDiscounts received on purchases.
    Indirect ExpensesRentExpenses related to renting office space.
    Indirect ExpensesSalaryPayments made to employees.
    Indirect ExpensesOffice ExpensesGeneral office expenses (e.g., stationery, utilities).
    Indirect ExpensesTelephone ExpensesCosts of telephone and internet services.
    Indirect ExpensesTravel ExpensesExpenses for business travel.
    Indirect ExpensesAdvertising ExpensesCosts related to marketing and advertising.
    Indirect ExpensesProfessional FeesPayments made to professionals (e.g., lawyers, accountants).
    Indirect ExpensesInsurance PremiumCosts of insurance for business assets.
    Indirect ExpensesRepairs & MaintenanceCosts of maintaining and repairing business assets.
    Indirect ExpensesBad DebtsAmounts written off as unrecoverable debts.
    Branch/DivisionsBranch ATracks transactions specific to Branch A.
    Branch/DivisionsBranch BTracks transactions specific to Branch B.
    Branch/DivisionsDivision 1Records transactions related to Division 1.
    Branch/DivisionsDivision 2Records transactions related to Division 2.
    Miscellaneous ExpensesPreliminary ExpensesExpenses incurred during the formation of the company.
    Miscellaneous ExpensesDeferred Revenue ExpenditureExpenses to be written off gradually over time.
    Miscellaneous ExpensesPromotional ExpensesExpenses for promoting new products or services.
    Miscellaneous ExpensesLegal FeesLegal costs that are amortized over time.
    Secured LoansMortgage LoanLoans secured against property.
    Secured LoansCar LoanLoans secured against a vehicle.
    Secured LoansEquipment LoanLoans secured against business equipment.
    Secured LoansTerm LoanSecured long-term loan.
    Unsecured LoansPersonal LoanLoans taken without any collateral.
    Unsecured LoansOverdraftBank overdraft facility.
    Unsecured LoansLoan from FriendsUnsecured loans taken from friends.
    Unsecured LoansLoan from RelativesUnsecured loans taken from relatives.
    Suspense AccountSuspenseTemporary account for uncertain or incomplete transactions.
    Stock-in-HandFinished GoodsValue of goods that are ready for sale.
    Stock-in-HandRaw MaterialsValue of raw materials held in inventory.
    Stock-in-HandWork in ProgressValue of unfinished goods in the production process.
    Stock-in-HandPacking MaterialsValue of materials used for packing goods.
    Deposits (Asset)Security DepositDeposits made for securing premises or equipment.
    Deposits (Asset)Fixed DepositMoney deposited in fixed-term accounts.
    Deposits (Asset)Rental DepositDeposit paid for renting premises.
    Deposits (Asset)Telephone DepositDeposit paid for telephone services.