Multi GST Rate Billing Format

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 […]

🔄 Published Jul 2026

Trusted by 6,00,000+ CA professionals across India

⬇ Available Downloads

Excel Format (Editable) 🔒

XLSX Pro 15 KB ✏️ Editable

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

Get Unlimited Access with Pro Membership

Download unlimited formats, get editable files, and access premium CA resources.

  • Unlimited downloads
  • Editable Word / Excel formats
  • Premium CA toolkit access
  • GST / ROC / Audit templates
  • Priority format updates
  • AI drafting tools (coming soon)
₹99
per month
₹1,499
lifetime
👑 Upgrade to Pro

What is Included in This Format?

This format includes a professionally structured template ready for immediate use. Fields are clearly labeled for easy customization.

Disclaimer: This format is provided for general information only. Please review applicable laws and professional requirements before use.