Tag: rate-wise GST report in Tally Prime

  • How to Check HSN and GST Rate Wise Stock Items in Tally Prime: Step-by-Step Guide with Report Analysis and Practical Examples

    For every GST-registered business in India, accurate reporting of HSN (Harmonized System of Nomenclature) codes and GST rates for stock items is essential for compliance and audit readiness. Tally Prime makes this process simple through in-built reporting tools that allow users to analyze inventory according to HSN codes and applicable GST rates.

    In this comprehensive guide, we’ll explain how to check HSN- and GST-rate-wise stock items in Tally Prime, how to configure them correctly, and how to generate analytical reports to ensure your filing and reporting are accurate.

    This article will cover step-by-step instructions, tables for easy reference, and important tips for smooth GST management in Tally.


    What Are HSN Codes and Why Are They Important?

    HSN (Harmonized System of Nomenclature) is a globally accepted system for classifying goods under a standardized structure. In India, it helps determine the GST rate applicable to specific products.

    HSN DigitsApplicabilityDescription
    4 digitsBusinesses with turnover below ₹5 croreUsed for B2C and small-scale reporting
    6 digitsBusinesses with turnover above ₹5 croreUsed for B2B and export reporting
    8 digitsUsed for international tradeHighly detailed classification

    Example:

    • HSN for Computers: 8471
    • HSN for Steel: 7208
    • HSN for Plastic Goods: 3923

    Using accurate HSN codes ensures proper GST filing, invoice accuracy, and reduced chances of penalties during audits.


    Step-by-Step: How to Enable and View HSN & GST Rate-Wise Stock Items in Tally Prime

    Let’s go through a complete walkthrough of how to check and analyze GST-related stock details in Tally.


    Step 1: Enable GST in Tally Prime

    Before viewing HSN or GST rate reports, GST must be enabled in the company settings.

    Path:
    Gateway of Tally → F11 (Features) → Statutory Features → Enable Goods and Services Tax (GST) → Yes

    Then, set the following:

    • Set/alter GST details: Yes
    • Enable HSN/SAC details: Yes

    Once enabled, enter your GSTIN, registration type, and state.


    Step 2: Assign HSN and GST Rate to Each Stock Item

    To view stock reports by HSN or rate, you need to configure each item properly.

    Path:
    Gateway of Tally → Inventory Info → Stock Item → Alter/Create

    Now, enter the following details under Statutory Information:

    • HSN Code: (Example – 8471)
    • GST Rate: (Example – 18%)

    Repeat this for each product in your stock list.

    Tip: You can also use the “Copy HSN from Stock Group” feature if multiple items belong to the same category.


    Step 3: Record Sales and Purchase Transactions

    After HSN and GST setup, record regular Sales and Purchase vouchers with proper stock items.

    Tally automatically tracks HSN, tax rate, and tax amount for each entry.

    Example Transaction:

    Item NameHSN CodeQuantityGST RateValue (₹)
    Laptop84712 pcs18%80,000
    Mouse847110 pcs18%5,000
    Printer84431 pc18%10,000

    Step 4: Generate HSN Summary Report

    To view HSN-wise details for all stock items:

    Path:
    Display More Reports → Statutory Reports → GST → HSN/SAC Summary

    This report displays data for sales and purchases grouped by HSN.

    Report Fields:

    FieldDescription
    HSN CodeCode linked with stock item
    DescriptionProduct/Service name
    UQCUnit Quantity Code (e.g., Nos, Kg, Ltr)
    Total ValueValue of goods sold/purchased
    Taxable ValueAmount subject to GST
    Integrated, Central, State TaxDetailed GST breakup

    Tip: Use Alt + F12 (Range Filter) to display data for specific months or transactions.


    Step 5: View GST Rate Wise Stock Report

    If you wish to see stock items grouped by GST rate rather than HSN:

    Path:
    Display More Reports → Statutory Reports → GST → Rate-wise Analysis

    This report groups all stock items under 0%, 5%, 12%, 18%, and 28% GST slabs.

    GST RateItems IncludedTaxable Value (₹)Total GST (₹)
    0%Books, Food Items12,0000
    5%Essentials18,000900
    12%Appliances40,0004,800
    18%Electronics95,00017,100
    28%Luxury Goods15,0004,200

    This report is especially useful for:

    • Checking compliance with GST slabs
    • Detecting incorrect item categorization
    • Preparing data for GSTR-1 filing

    Step 6: Drill Down to Item-Wise and Voucher-Wise Details

    From the HSN Summary or Rate-Wise Report, press Enter on any line to open Item-Wise Analysis.

    You can view:

    • Item name and stock quantity
    • Voucher references
    • Party name
    • GST breakup (CGST, SGST, IGST)

    This helps cross-verify your sales and purchase data before filing GST returns.


    Step 7: Export the Report for Analysis or Filing

    You can export the HSN Summary or Rate-wise Report to Excel or PDF for easy sharing.

    Path:
    Alt + E → Export → Excel / PDF / HTML

    This exported file helps in:

    • Reconciliation with GST portal data
    • Sharing details with accountants
    • Maintaining audit trail

    Example Report View in Tally (Summary Table)

    HSN CodeDescriptionGST RateTaxable Value (₹)CGST (₹)SGST (₹)IGST (₹)Total (₹)
    8471Computers & Accessories18%85,0007,6507,6500100,300
    8443Printers18%10,000900900011,800
    3923Plastic Goods12%20,0001,2001,200022,400
    7208Steel Products18%15,0001,3501,350017,700

    Common Issues and Solutions

    IssuePossible ReasonSolution
    HSN not appearing in reportHSN not set for itemEdit stock item and assign correct HSN
    GST rate mismatchWrong rate setupCheck “Taxability” in item setup
    Tax calculation not showingGST not enabledEnable GST in Statutory Features
    Items grouped incorrectlyMissing classificationReclassify items under correct stock groups

    Additional Tips for Accuracy

    1. Regularly Update HSN Codes: GST Council occasionally revises codes. Always keep your item list current.
    2. Use Stock Groups for Bulk Assignments: Assign HSN and tax rates at group level for efficiency.
    3. Cross-Verify Tax Reports: Compare Tally’s HSN summary with GSTR-1/3B filings for accuracy.
    4. Backup Data Monthly: Keep secure backups for each return period.
    5. Audit with Range Filter: Use date filters to check monthly or quarterly HSN transactions.

    Benefits of Using HSN & GST Rate Reports in Tally

    BenefitDescription
    ComplianceEnsures correct tax filing and avoids penalties
    TransparencyEasy visibility of stock and tax classification
    ReportingSimplifies preparation for GST returns
    AccuracyDetects incorrect item coding
    EfficiencySaves manual effort during reconciliation

    Conclusion

    Checking HSN and GST rate-wise stock items in Tally Prime is not only useful for compliance but also crucial for business accuracy. With features like HSN Summary, Rate-wise Analysis, and Voucher Drill-Down, you can track every item’s tax classification and value in just a few clicks.

    By properly setting up HSN codes and GST rates for each stock item and using analytical reports regularly, you can ensure 100% accuracy in your GST filings and inventory management.


    Disclaimer:
    The data, tax rates, and report examples shared in this article are for educational purposes only. GST rates and Tally versions may change periodically. Users are advised to verify the latest updates in Tally Prime and the official GST notifications before implementation.