Sales Invoice HSN Summary
📄 Sales Invoice HSN Summary Report
The Sales Invoice HSN Summary Report provides a summary of sales transactions grouped by HSN (Harmonized System of Nomenclature) or SAC (Service Accounting Code) based specifically on issued sales invoices within a given period. It helps businesses analyze tax liabilities, ensure GST compliance, and prepare HSN-wise data for statutory filings like GSTR-1.
🎯 Purpose of the Report
-
To consolidate sales invoice data by HSN/SAC codes.
-
To ensure correct tax classification of goods and services sold.
-
To assist in GST return filing with accurate HSN/SAC summaries.
-
To give tax rate-wise sales insights for business decision-making.
📌 Key Data Fields
| Field | Description |
|---|---|
| HSN/SAC Code | The classification code for goods/services sold. |
| Description | Name and description of the item/service category. |
| UQC (Unit Quantity Code) | Standard unit of measurement (e.g., pcs, kg, hrs). |
| Total Quantity | Total quantity sold for that HSN/SAC code. |
| Total Taxable Value | Sales value before taxes. |
| Tax Rate (%) | GST rate applicable to that HSN/SAC category. |
| IGST Amount | Integrated GST amount (inter-state sales). |
| CGST Amount | Central GST amount (intra-state sales). |
| SGST/UTGST Amount | State/Union Territory GST amount (intra-state sales). |
| Total Tax Amount | Total GST amount for that HSN/SAC code. |
| Total Invoice Value | Total value including tax. |
🔍 Filter & Search Options
-
Date range (invoice date).
-
HSN/SAC code.
-
Customer.
-
Branch/Warehouse.
-
Tax rate slab.
📊 Insights Provided
-
HSN/SAC-wise tax liability for sales invoices.
-
Tax rate contribution to overall revenue.
-
Sales quantity and value trends by product/service category.
-
Helps detect missing or incorrect HSN codes on sales invoices.
📤 Export & Integration
-
Exportable to Excel, CSV, or PDF for GST filing.
-
Can be linked with GST return generation modules in the ERP.
-
Option to auto-generate monthly or quarterly summaries for compliance.
✅ Benefits
-
Streamlines GST return preparation (e.g., HSN summary in GSTR-1).
-
Reduces risk of tax mismatches during audits.
-
Provides quick insights into product/service category performance.
-
Ensures complete GST compliance.
📈 Example Layout
| HSN/SAC Code | Description | UQC | Qty | Taxable Value | GST Rate | IGST | CGST | SGST | Total Tax | Invoice Value |
|---|---|---|---|---|---|---|---|---|---|---|
| 8471 | Laptops & Desktops | Nos | 50 | ₹1,000,000 | 18% | ₹0 | ₹90,000 | ₹90,000 | ₹180,000 | ₹1,180,000 |
| 9983 | IT Consulting Services | Hrs | 200 | ₹300,000 | 18% | ₹54,000 | ₹0 | ₹0 | ₹54,000 | ₹354,000 |