Sanchit A & Co · Chartered Accountants

HSN Summary Builder · GSTR-1 Table 12 & GSTR-9 Table 17

Drop your GSTR-1 JSON files from Tally, or your sales register. You get HSN-wise, rate-wise summaries split into B2B and B2C, with the errors the portal will reject flagged before you upload. Everything runs in your browser; no file leaves your computer.

Step 1

Turnover bracket

Sets the minimum HSN digits checked on every line. Services (SAC 99xxxx) are checked for UQC "NA" and zero quantity.

Step 2

Upload

GSTR-1 JSON files

One or all twelve months at once. Tally GSTR-1 export, offline-tool JSON, old or new (B2B/B2C split) HSN format.

Sales register (Excel / CSV)

Item-wise register with an HSN column, or the columnar Tally register with one column per sales ledger (GST 5%, GST 18%, Exempt…).

Not on Tally, or HSN not set up in your masters? Fill the template and upload it in the Sales register box.

Result

HSN summary Sample data

Checks follow the GSTR-1 HSN table rules: minimum HSN digits by turnover, B2B and B2C reported separately, UQC from the portal list, valid GST rates, and tax matching taxable value × rate. Review flagged lines before filing; this tool does not replace professional review. © Sanchit A & Co, Chartered Accountants.

Before you start

How to build your HSN summary

Five steps, about two minutes. You can reopen this guide anytime from “How to use this tool”.

1

Pick your turnover bracket

Up to ₹5 Cr needs 4-digit HSN codes. Above ₹5 Cr needs 6 digits. The checks use this setting.

2

Get your files from Tally

  • GSTR-1 JSON (recommended): in TallyPrime open GSTR-1 for the month, click Export (Ctrl+E) and choose JSON. Repeat for each month.
  • Sales register: export the Sales Register to Excel. Item-wise with an HSN/SAC column works best; the columnar register with one column per sales ledger also works.
  • Other software or Excel billing: click Download sales register template, fill one row per item per invoice, and upload it.
  • Upload both to compare your books with what was filed.
3

Upload

Drop all monthly JSONs together, or the register file. For a register, confirm the column matches. If there is no HSN column, enter the HSN, UQC and rate against each sales ledger, then click Build summary.

4

Review the flags

Open the Checks tab and fix lines in Tally, then export and upload again.

Red: portal will rejectAmber: likely to be questionedOK

The Reconciliation tab shows where the HSN table doesn't match the invoices.

5

Export

Table 12 · B2B and B2C go into GSTR-1. GSTR-9 · Table 17 is the annual summary. Use Download Excel for all tabs, or Copy table to paste one into Excel or the offline tool.

Your files are read inside your browser. Nothing is uploaded to any server.

Get the HSN Summary Right the First Time

We build and review HSN summaries for GSTR-1 Table 12 and GSTR-9 Table 17,
and keep rate-wise reporting tied back to your sales register.

© Sanchit A & Co, Chartered Accountants · FRN 044661N | All rights reserved. | Built on Imbibe ItWeb