GST HSN/SAC Summary and GSTR export (India)
Group your outward supplies by HSN/SAC code and download an invoice-wise CSV to prepare your GST return from.
This report is for companies in India. It groups your posted sales by HSN or SAC code, with the CGST, SGST and IGST that were actually charged. Open GST HSN/SAC Summary under Accounts > Reports. It needs access to Reports, and appears in the Reporting Center when your company's country is India.
Run the summary
- Set From and To. They start as 1 January of this year and today.
- Click Run Report.
You see two cards, Total Taxable Value and Total Tax, and a By HSN / SAC Code table with HSN/SAC, Quantity, Taxable Value, Tax Breakdown (for example "CGST: 90.00 ยท SGST: 90.00") and Total Tax, with a Total row.
Before you rely on it:
- Give each item an HSN or SAC code in the item form. See Add a product or service. A line is only included if it has an item with a code and a tax category.
- If nothing qualifies you see "No HSN/SAC-coded sales in this range. (Set an HSN/SAC code on your items to see them here.)"
- Only posted invoices dated in the range count. Credit notes are not subtracted.
- The tax split is worked out again from the saved tax category and the customer's state, the same way it was when the invoice posted, so it matches what is in your books. See How tax is calculated.
Download the GSTR export
Click Download GSTR Export (CSV) to download a file named like gstr-outward-supplies-DATE.csv for the same date range. It has one row per posted invoice with these columns: Invoice Number, Invoice Date, Recipient Name, Recipient GSTIN, Place of Supply (State Code), Place of Supply (State Name), Taxable Value, CGST, SGST, IGST, CESS, Invoice Value.
This is a starting point for your accountant, not a filing. Legasum does not connect to the GST portal and does not produce the portal's JSON format. The file has one row per invoice, so an invoice that mixes several tax rates is not split by rate the way the portal's invoice sheet expects.
The recipient's GSTIN comes from the Tax Registrations tab on the customer. See Add and manage customers.
Good to know
- A branch-restricted role gets the HSN/SAC summary for their branches, with a notice, but cannot download the GSTR export, because a GST return is for the whole registration.
- Legasum has an e-invoice and e-way bill placeholder that always reports itself as not configured; it never produces an IRN.
- For total tax by component without the HSN breakdown, use the Tax Summary.