Build a GST workings sheet with HSN/SAC codes, multi-rate lines, intra-state vs inter-state splits, and reverse-charge support. Out comes a clean PDF plus a 4-sheet XLSX ready for your accountant or GSTR-3B prep.
01 — What you create
Drop in line items with HSN/SAC and GST rate. The tool splits each line into CGST/SGST or IGST based on supply type, handles reverse-charge separately, and rolls up by rate and HSN.
GST CALCULATION SHEET
GST Workings — May 2026
Period: May 2026 · Outward supply
REGISTERED ENTITY
Sonchoy Studio Pvt Ltd
GSTIN: 29ABCDE1234F1Z5 · Karnataka (29)
TAXABLE
INR 390,000
TOTAL GST
INR 64,440
CGST+SGST
INR 47,160
IGST
INR 10,800
LINE ITEMS
* RCM line — GST payable by recipient, excluded from line total.
Scanned invoices, multi-page batches, multi-currency stacks, and direct push into your accounting system. Free for 30 days, no card required.
Try Premium FreeFree 30 days · no credit card · cancel anytime
02 — How it works
A clean workings sheet is what your CA wants at the end of the month — line items with HSN, rate, taxable value, and the CGST/SGST/IGST split. This tool produces exactly that, in PDF for the file and XLSX for the upload.
HSN/SAC, description, quantity, unit price, discount. Pick the GST rate from the dropdown and flag intra-state, inter-state, or export.
Intra-state splits 50/50 into CGST + SGST. Inter-state goes to IGST. Export is zero-rated. Reverse-charge lines exclude GST from the line total.
PDF has summary cards, line items, rate-wise summary, HSN/SAC summary, and an RCM block. XLSX has Summary, Line Items, By Rate, and By HSN sheets.
03 — Built for compliance
Intra-state lines split GST 50/50 into CGST and SGST. Inter-state lines go fully to IGST. Both are tracked in the rate summary.
Each line carries its HSN (goods) or SAC (services) code, the rate, and the description. The HSN summary rolls everything up for the workings file.
Flag any line as RCM. GST is calculated as normal but excluded from the line total — and called out separately in its own block.
Rates 0%, 0.25%, 3%, 5%, 12%, 18%, 28% — the full Indian GST slab — plus a 0% option for exempt and zero-rated supplies.
Automatic rollups by GST rate and by HSN/SAC code. Useful for cross-checking against GSTR-1 table 12 (HSN summary) and table 9 (rate-wise).
PDF: summary cards, line items, rate summary, HSN summary, RCM block. XLSX: Summary, Line Items, By Rate, By HSN — all numeric, ready for pivots.
Bulk OCR, batch invoicing, multi-party e-signing, redaction, audit logs — pdfFiller picks up where Sonchoy ends. Free for 30 days, no credit card.
Run 100+ invoices, statements, or conversions in one go.
Turn paper invoices into searchable, exportable data.
Multi-party signatures with full audit trails.
Mask sensitive ledger lines before sending to auditors.
04 — Common questions
The Invoice Generator produces a single tax invoice for one customer. This Calculation Sheet is a workings document — many lines across one period, grouped by rate and HSN, sized for GSTR-1 / 3B prep and accountant hand-off. Different purpose; same tax engine underneath.
Intra-state supplies (same state for supplier and place of supply) attract CGST + SGST, each at half the total rate. Inter-state supplies, or supplies to SEZ / overseas, attract IGST at the full rate. The tool splits this automatically based on the supply type you pick per line.
Under reverse charge, GST is payable by the recipient instead of the supplier. The supplier raises an invoice without GST; the recipient self-invoices and pays GST directly to the government, claiming ITC. The tool flags RCM lines, excludes GST from the line total, and reports the RCM liability in its own block.
HSN (Harmonised System of Nomenclature) for goods; SAC (Services Accounting Code) for services. Businesses with turnover over ₹5 crore must use 6-digit codes; smaller businesses 4-digit. The tool stores whatever you enter — there's no built-in code lookup.
The CGST/SGST/IGST split is India-specific. For single-rate VAT (UK, EU, Australia, etc.), use the VAT Calculator PDF Export tool instead — same engine, simpler split. The XLSX from this tool can be retooled for any jurisdiction if you ignore the SGST/IGST columns.
PDF (single document with summary cards, line items table, rate summary, HSN summary, and RCM block — auto-paginated) and XLSX (4 sheets: Summary, Line Items, By Rate, By HSN). All numeric columns are real numbers — no pre-formatted strings.
05 — Related tools