HSN/SAC Summary
📄 HSN/SAC Summary Report
The HSN/SAC Summary Report provides a consolidated view of sales and purchase transactions grouped by HSN (Harmonized System of Nomenclature) or SAC (Service Accounting Code). It is primarily used for tax compliance—especially for GST filing—by summarizing taxable values, tax rates, and tax amounts per HSN/SAC code.
🎯 Purpose of the Report
-
To track goods and services sold or purchased by their respective HSN/SAC codes.
-
To simplify GST returns filing (e.g., GSTR-1 or GSTR-2) by providing HSN/SAC-wise summaries.
-
To ensure compliance with statutory reporting requirements.
-
To identify tax liabilities for each category of goods/services.
📌 Key Data Fields
| Field | Description |
|---|---|
| HSN/SAC Code | Unique code representing the product or service category. |
| Description of Goods/Services | Name and description as per GST classification. |
| UQC (Unit Quantity Code) | Standard unit of measurement (e.g., pcs, kg, ltr, hrs). |
| Total Quantity | Total number of goods/services supplied. |
| Total Taxable Value | Value of goods/services before taxes. |
| Tax Rate (%) | GST rate applicable to the item/service. |
| IGST Amount | Integrated GST amount (for inter-state transactions). |
| CGST Amount | Central GST amount (for intra-state transactions). |
| SGST/UTGST Amount | State or Union Territory GST amount (for intra-state transactions). |
| Total Tax Amount | Sum of applicable GST amounts. |
| Total Invoice Value | Total amount including tax. |
🔍 Filter & Search Options
-
Date range selection.
-
Filter by HSN/SAC Code.
-
Filter by Customer/Vendor.
-
Filter by Branch/Warehouse.
-
Filter by Tax Rate.
📊 Insights Provided
-
Total taxable value and tax amount per HSN/SAC code.
-
Transaction volumes for different goods/services categories.
-
Tax rate analysis to identify high-revenue tax slabs.
-
Helps in detecting incorrect or missing HSN/SAC codes in records.
📤 Export & Automation
-
Exportable in Excel, CSV, and PDF formats for GST filing.
-
Can be integrated with GST return modules in the ERP.
-
Option for automatic monthly generation to align with GST filing schedules.
✅ Benefits
-
Ensures GST compliance and simplifies return filing.
-
Saves time by avoiding manual tax calculations.
-
Reduces risk of penalties due to incorrect HSN/SAC reporting.
-
Helps in audits with a ready reference of code-wise tax details.
📈 Example Layout
| HSN/SAC Code | Description | UQC | Qty | Taxable Value | GST Rate | IGST | CGST | SGST | Total Tax | Invoice Value |
|---|---|---|---|---|---|---|---|---|---|---|
| 8471 | Computers & Laptops | Nos | 120 | ₹2,400,000 | 18% | ₹0 | ₹216,000 | ₹216,000 | ₹432,000 | ₹2,832,000 |
| 9983 | IT Support Services | Hrs | 500 | ₹500,000 | 18% | ₹90,000 | ₹0 | ₹0 | ₹90,000 | ₹590,000 |
| 8703 | Motor Cars | Nos | 5 | ₹5,000,000 | 28% | ₹0 | ₹700,000 | ₹700,000 | ₹1,400,000 | ₹6,400,000 |