Tag: tally prime accounting

  • Tally Multi GST Rate Entry in Tally Prime – Step-by-Step Guide with Examples for Tally Interview

    In modern business accounting, it’s common for companies to deal with products or services taxed at different GST rates. For example, a company may sell two categories of products:

    • Category 1: 18% GST
    • Category 2: 12% GST

    If you are a Tally user or preparing for a Tally interview, knowing how to handle multiple GST rate entries is crucial. In this guide, we will explain step-by-step how to enter multiple GST rates in Tally Prime.


    What is Multi GST Rate Entry?

    Multi GST Rate Entry in Tally Prime refers to the ability to record transactions with different GST rates in a single invoice or voucher. This is useful when your company sells products or services under different GST slabs.

    Benefits of Multi GST Rate Entry

    • Reduces manual effort of creating multiple invoices
    • Ensures accurate GST calculation for all categories
    • Simplifies reporting for GST returns
    • Commonly tested in Tally interviews

    Scenario Example

    Suppose your company sells:

    Product CategoryGST RateSale Amount
    Electronics18%₹50,000
    Stationery12%₹20,000

    You want to record both sales in a single invoice.


    Step-by-Step Procedure in Tally Prime

    1. Enable GST in Tally Prime

    1. Go to Gateway of Tally → F11: Features → Statutory & Taxation
    2. Enable Goods and Services Tax (GST)
    3. Set GST details like state, GSTIN, and registration type

    2. Create GST Ledgers

    1. Navigate to Accounts Info → Ledgers → Create
    2. Create GST ledgers for each rate:
      • CGST 9% (for 18% GST)
      • SGST 9% (for 18% GST)
      • CGST 6% (for 12% GST)
      • SGST 6% (for 12% GST)

    Tip: Tally automatically calculates CGST and SGST based on GST rate selected.


    3. Create Stock Items

    1. Navigate to Inventory Info → Stock Items → Create
    2. Enter details for each product:
      • Name
      • Unit of Measure
      • GST rate (e.g., 18% for Electronics, 12% for Stationery)

    4. Record Sales Voucher with Multi GST Rates

    1. Go to Accounting Vouchers → F8: Sales
    2. Select Party Name (customer)
    3. Add stock items with respective GST rates
    4. Tally will calculate GST automatically for each category
    5. Verify tax amount for each GST rate

    Example Voucher Table

    ProductQuantityRateAmountGST RateCGSTSGSTTotal
    Electronics105,00050,00018%4,5004,50059,000
    Stationery10020020,00012%1,2001,20022,400
    Total70,0005,7005,70081,400

    5. Verify GST Report

    • Navigate to Display → Statutory Reports → GST → GST Liability
    • Check CGST and SGST separately for each GST rate
    • Ensure all entries are accurately reflected

    Key Points for Tally Interview

    • Always mention stock items assigned with correct GST rates
    • Explain CGST and SGST calculation
    • Demonstrate multi GST rate entry in a single invoice
    • Show how to verify using GST reports in Tally Prime

    Conclusion

    Handling multiple GST rates in Tally Prime is essential for accurate accounting in businesses dealing with diverse products or services. By mastering Multi GST Rate Entry, you can save time, ensure compliance, and impress in Tally interviews.

    💡 Pro Tip: Always double-check GST ledgers and stock items before recording the voucher to avoid errors in GST calculation.

    Tally Interview Questions & Answers – Multi GST Rate Entry

    Q1: What is Multi GST Rate Entry in Tally Prime?

    A1: Multi GST Rate Entry allows you to record transactions where different GST rates apply to different products or services in a single invoice. For example, electronics may have 18% GST, while stationery has 12% GST. Tally automatically calculates CGST and SGST for each category.


    Q2: How do you enable GST in Tally Prime?

    A2: To enable GST in Tally Prime:

    1. Go to Gateway of Tally → F11: Features → Statutory & Taxation
    2. Enable Goods and Services Tax (GST)
    3. Enter GST details such as state, GSTIN, and registration type
      This allows Tally to manage GST for all transactions.

    Q3: How do you record a sales transaction with multiple GST rates?

    A3: Steps to record multi-GST rate sales:

    1. Create stock items with respective GST rates.
    2. Create GST ledgers for CGST and SGST at different rates.
    3. Go to Accounting Vouchers → F8: Sales, select customer, and add products with their GST rates.
    4. Tally calculates GST automatically for each item.

    Q4: How can you verify that GST is calculated correctly for multiple rates?

    A4: You can verify GST calculations in Tally Prime by:

    1. Navigating to Display → Statutory Reports → GST → GST Liability
    2. Checking CGST and SGST totals for each GST rate
    3. Drilling down into vouchers to ensure correct GST amounts for each product category

    Q5: Why is knowledge of Multi GST Rate Entry important for Tally interviews?

    A5: Multi GST Rate Entry is commonly tested in Tally interviews because it shows:

    • Understanding of GST concepts
    • Ability to record complex invoices
    • Accuracy in financial reporting
    • Practical knowledge of Tally Prime accounting features

  • Outstanding Report in Tally Prime | Complete Guide with Credit Sales Entries

    Tally Prime is one of the most popular accounting software used by businesses of all sizes. One of its most important features is the Outstanding Report, which helps users track credit transactions efficiently. Whether you are a Tally user, an accountant, or preparing for a Tally interview, understanding this report is crucial.


    What is an Outstanding Report in Tally Prime?

    The Outstanding Report in Tally Prime shows all pending credit transactions with customers (receivables) and suppliers (payables). It helps in monitoring who owes you money and whom you owe, along with due dates and balances.

    Key Features:

    • Tracks pending receivables (debtors)
    • Tracks pending payables (creditors)
    • Shows credit sales and purchase entries
    • Displays due dates and aging of outstanding amounts

    Importance of Outstanding Report

    PurposeExplanation
    Monitor Credit SalesTrack which customers have pending payments and how much they owe.
    Track PaymentsMonitor pending payments to suppliers to avoid late fees.
    Financial PlanningHelps in forecasting cash inflow and outflow for business planning.
    Interview PreparationCommonly asked in Tally interviews to test your knowledge of accounting features.

    Credit Sales Entries in Tally Prime

    Credit sales are sales made on credit, where payment is received at a later date. Recording credit sales in Tally Prime ensures that:

    • The transaction is reflected in the Outstanding Report automatically.
    • You can track amount due from each customer.
    • It helps in maintaining proper accounts receivable management.

    Example of Credit Sales Entry

    DateParty NameInvoice NoAmountStatus
    01-Sep-2025ABC TradersINV001₹50,000Pending
    05-Sep-2025XYZ EnterprisesINV002₹30,000Pending
    10-Sep-2025PQR IndustriesINV003₹25,000Paid

    This table shows how each credit sale is recorded and tracked in the Outstanding Report.


    How to Generate Outstanding Report in Tally Prime

    Follow these steps to view the report:

    1. Open Tally Prime.
    2. Navigate to Display → Statements of Accounts → Outstandings.
    3. Choose the type of outstanding:
      • Receivables (Money to receive from customers)
      • Payables (Money to pay to suppliers)
    4. View the list of parties with pending balances and due dates.
    5. Drill down into individual ledgers to see detailed transactions.

    Additional Tips:

    • Filter report by age of outstanding (0–30 days, 31–60 days, etc.)
    • Export report in Excel or PDF for easy sharing or record-keeping
    • Regularly check to avoid overdue payments

    Benefits of Using Outstanding Report

    BenefitExplanation
    Easy TrackingKeep track of credit sales and purchases effortlessly.
    Reduces ErrorsMinimizes manual calculation mistakes.
    Better Cash Flow ManagementHelps plan finances and avoid liquidity issues.
    Professional AccountingMaintains a structured and professional accounting system.

    Conclusion

    The Outstanding Report in Tally Prime is a must-know feature for anyone handling accounts. It not only simplifies tracking credit transactions but also helps in financial planning and interview preparation. Mastering this report ensures that you stay on top of your receivables and payables, improving efficiency in accounting operations.

    💡 Pro Tip: Always update credit sales and purchase entries regularly to maintain an accurate Outstanding Report.