Sheet 1 — Tax Invoice (Intra-State) — CGST + SGST
- Full invoice header with Seller, Buyer & Ship-To details
- 10 editable line items with HSN/SAC, Qty, Unit, Rate, Discount %
- Each item has its own GST rate (mix 5%, 12%, 18%, 28% freely)
- Auto-calculated: Taxable Value → CGST (½) → SGST (½) → Line Total
- GST Rate-Wise Summary Table — auto SUMPRODUCT formula groups all items by slab (5% / 12% / 18% / 28%), showing Taxable, CGST, SGST, Total GST and Invoice Value per slab
- Grand Total box with Taxable, CGST, SGST, Cess & Round-Off
- Bank details + Terms & Conditions + Signature block
Sheet 2 — Tax Invoice (Inter-State) — IGST only
- Same professional layout, adapted for inter-state supplies
- Full IGST (no split) with slab-wise IGST summary
- Pre-filled with industrial goods sample items
Sheet 3 — How To Use
- Step-by-step instructions covering editing, GST rate entry, printing, adding rows, and GSTIN format
How to fill:
- 🟡 Amber cells = type your data (company, items, rates, GST %)
- 🟢 Green cells = auto-calculated (do not edit)
- Enter GST rate as decimal:
0.05= 5%,0.18= 18%,0.28= 28% - The slab-wise summary updates automatically when you change any rate