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.