GSTR-1 HSN Summary Worksheet (Table 12) in Excel Format
GSTR-1 asks for a summary of outward supplies by HSN code, with quantity, taxable value and tax split. This worksheet lets you build that summary from your sales register, check it against the invoice-level data, and export it before uploading.
| HSN code | Description | UQC | Total quantity | Taxable value, intra-state | Taxable value, inter-state | GST rate (%) | CGST | SGST | IGST | Total value | |
|---|---|---|---|---|---|---|---|---|---|---|---|
Rs 43,200 | Rs 43,200 | Rs 129,600 | Rs 1,416,000 | ||||||||
Rs 23,400 | Rs 23,400 | Rs 70,200 | Rs 767,000 | ||||||||
Rs 17,100 | Rs 17,100 | Rs 55,800 | Rs 590,000 | ||||||||
Rs 13,500 | Rs 13,500 | Rs 49,500 | Rs 501,500 |
Rows and rates are illustrative. Use one row per HSN, UQC and rate combination, and tie the totals to your outward supply register and the tax values on the return. Check the required HSN digit length for your turnover band.
Want the HSN summary generated from ERP data?
An optional review of your item master and invoice lines to produce Table 12 automatically.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Group your outward supplies by HSN, unit of measure and tax rate, then enter total quantity and the taxable value split between intra-state and inter-state supplies. The worksheet computes CGST and SGST on the intra-state value, IGST on the inter-state value, and the total value for each row. Add or delete rows, and export to Excel or CSV. Compare the totals against the tax figures in your sales register and in GSTR-1 tables 4 to 11.
Rules behind Table 12
Table 12 summarises outward supplies by HSN. Taxpayers must report the HSN code at a prescribed digit length: a lower length for smaller turnover and a higher length for larger turnover. Quantity is reported in the unit quantity code (UQC) from the standard GST list, such as NOS, KGS or MTR. Values in the HSN table should reconcile to the invoice-level data, and the portal may flag differences between them.
- One row per HSN, UQC and rate
- CGST and SGST split equally on intra-state value
- IGST on inter-state value
- Quantity in a valid UQC
Worked example
For motors under HSN 850110, intra-state value of Rs 4,80,000 at 18% yields CGST of Rs 43,200 and SGST of Rs 43,200. Inter-state value of Rs 7,20,000 at 18% yields IGST of Rs 1,29,600. The row total is the taxable value of Rs 12,00,000 plus Rs 2,16,000 of tax, which is Rs 14,16,000. The weighted average tax rate in the summary should equal your blended rate and will differ from 18% if rows use mixed rates.
Common mistakes
Teams most often use different units for the same HSN across invoices, which creates several rows for one item. Others use a shorter HSN than required, or an HSN that differs between master data and invoice. Mismatched totals between Table 12 and the invoice tables cause portal errors. Fix master data first, then generate the summary from the ERP with a standard query rather than keying it.
Frequently Asked Questions
How many digits of HSN are required in GSTR-1?
The required length depends on aggregate turnover. Smaller taxpayers report a lower digit length and larger ones a higher length, as notified. Check the current rule on the GST portal. Using the higher length for all lines is generally accepted and avoids future mismatch.
What is UQC?
UQC means unit quantity code, a standard list of units used in GST returns, such as NOS for numbers, KGS for kilograms and MTR for metres. Pick the closest code and use it consistently across invoices and in the HSN summary.
Do I need to report HSN for services?
Services are reported using SAC codes in the same table. Enter the SAC in the HSN column and use OTH or the relevant unit where quantity is not meaningful. Confirm how your accounting software exports service lines.
Why does my HSN summary not match my invoices?
Typical causes are credit notes not netted in, different rates under the same HSN, rounding at line level, and invoices filed in a different period. Reconcile by HSN and rate, then by invoice, and fix master data to prevent repeats.
Netray can help build an ERP query that produces the HSN summary directly from invoice lines, with a check against the sales register totals.
Related Tools
GST Outward Supply Sales Register Worksheet
Editable sales register that splits tax into CGST, SGST and IGST per invoice and totals the monthly liability.
Country & TaxGST Invoice Calculator (CGST, SGST, IGST)
Enter quantity, rate, discount and GST rate to get taxable value, CGST/SGST or IGST, cess and the rounded invoice total.
Country & TaxGST Tax Invoice Format Template for Indian Manufacturers
A fill-in GST tax invoice with the mandatory fields for a manufacturer: GSTIN, HSN, place of supply, taxable value and CGST/SGST/IGST lines.
Country & TaxIndia GST Return Due Dates Reference
Searchable table of GST returns, who files them and the usual due date, for Indian manufacturers and accountants.
Country & TaxIndia GST E-Invoice Readiness Checklist
A tick-box checklist covering e-invoice applicability, IRP reporting, IRN and QR code handling, cancellations and ERP configuration for Indian GST taxpayers.
More Country & Tax tools
See all- E-Way Bill Requirement Checklist (India)
- GST Reverse Charge Mechanism Reference (India)
- GST Tax Liability Set-Off Calculator (ITC Utilisation)
- GST Composition Scheme vs Regular Scheme Calculator
- GST Blocked Input Tax Credit Reference (Section 17(5))
- Tally Prime Manufacturing Journal Checklist
- Tally Stock Item Import Template (Excel)
- Busy Accounting GST Setup Checklist
- Delivery Challan Format Template for Goods Movement in India