Every week I talk to small business owners who are still running their GST invoicing entirely on Excel. Some have been doing it for years. Most of them don't realise their Excel template is one wrong formula away from getting their client's ITC claim rejected. I'm going to show you the correct GST invoice format in Excel, give you the exact formulas to use, and — more importantly — show you the five silent mistakes that are costing people real money.
A textile trader in Surat was supplying fabric to a retailer in Pune. He'd been using the same Excel template for two years — downloaded it from some random blog in 2024, never touched it since. The template had CGST and SGST hardcoded into every formula. Surat to Pune is interstate. IGST should have applied, not CGST+SGST. His client's CA caught it during GSTR-2B reconciliation. The ITC claim of ₹83,000 was rejected. The trader had to issue credit notes, reissue all 47 invoices, and explain the discrepancy to the GST officer. Two months of headaches — all because of a hardcoded tax formula in an Excel sheet.
That story isn't rare. It's the most common Excel GST mistake I've seen. Let me walk you through how to do this right.
What Is a GST Invoice Format in Excel?
A GST invoice format in Excel is a spreadsheet template that replicates the mandatory fields of a tax invoice as defined under Rule 46 of the CGST Rules 2017. Unlike a printed bill book or a PDF generator, Excel lets you build your own layout — but it gives you zero compliance guardrails. There's nothing stopping you from entering the wrong tax type, skipping a mandatory field, or using a formula that rounds incorrectly.
When people search for a gst invoice format in excel free download, they usually want one of two things: a quick template they can fill in manually, or a formula-driven sheet that auto-calculates CGST SGST IGST correctly. I'll cover both — but first, let me show you exactly which fields must be in your Excel template under Indian GST law. Whether you call it a gst bill format in excel sheet or a tax invoice template, the mandatory fields are the same under Rule 46.
Mandatory Fields in Your GST Invoice Excel Template
Every GST invoice — whether you make it in Excel, Word, or a browser tool — must contain these fields as per Rule 46 of the CGST Rules. I've also marked which fields most downloaded Excel templates quietly skip:
| Mandatory Field | Rule 46 Requirement | Excel Templates |
|---|---|---|
| Supplier Name & Address | Full legal name as per GST registration | ✅ Usually present |
| Supplier GSTIN | 15-digit GSTIN of the supplier | ✅ Usually present |
| Invoice Number | Consecutive, unique within a financial year | ✅ Usually present |
| Invoice Date | Date of issue | ✅ Usually present |
| Buyer Name & Address | Full name and billing address of recipient | ✅ Usually present |
| Buyer GSTIN | Required if buyer is GST-registered | ✅ Usually present |
| Place of Supply | State code — determines CGST+SGST vs IGST | ❌ Frequently missing |
| HSN / SAC Code | Mandatory above ₹1.5 crore turnover | ❌ Frequently missing |
| Description of Goods/Services | Clear description of what's being supplied | ✅ Usually present |
| Quantity & Unit | For goods — quantity and unit of measure | ✅ Usually present |
| Taxable Value | Value before GST is applied | ✅ Usually present |
| Tax Rate | GST rate applied (5%, 12%, 18%, 28%) | ✅ Usually present |
| CGST / SGST / IGST Amount | Separate line for each applicable tax | ❌ Often hardcoded wrong |
| Total Invoice Value | Taxable value + all applicable taxes | ✅ Usually present |
| Signature / Digital Sign | Authorised signatory | ❌ Almost always missing |
As you can see, Place of Supply and HSN/SAC code are the two fields that make or break compliance — and they're the ones most Excel templates quietly skip.
The Correct Excel Formulas for GST Calculation
Here's the exact formula structure you should use in your GST invoice Excel template. This assumes your taxable value is in column D and your GST rate is in column E:
⚠️ Critical: You must check the Place of Supply before you decide which formula to use. If your business is in Maharashtra and your client is in Karnataka — that's interstate. Use IGST. Don't let Excel assume — it won't know unless you build an IF formula that checks the state codes.
Excel vs GSTInvoiceFree.in — Which Should You Use?
| Feature | Excel Template | GSTInvoiceFree.in |
|---|---|---|
| Cost | Free | Free |
| CGST/SGST/IGST auto-detection | ❌ Manual — you decide | ✅ Auto based on state |
| HSN/SAC code field | ❌ Missing in most templates | ✅ Built-in |
| Place of Supply field | ❌ Usually missing | ✅ Built-in |
| Invoice serial number tracking | ❌ Manual — easy to duplicate | ✅ Auto-sequential |
| Mobile usability | ❌ Painful on phone | ✅ Works on any device |
| E-invoice compatibility (2026) | ❌ Not compatible | ✅ Compliant format |
| PDF download | ⚠️ Formatting breaks | ✅ Clean PDF instantly |
| Risk of wrong tax type | 🔴 High — no validation | 🟢 Low — auto-validated |
The 5 Excel GST Invoice Mistakes That Get ITC Claims Rejected
These are not hypothetical. I've seen each of these happen with real businesses across India. Each one has a real consequence.
Hardcoded CGST+SGST for Every Invoice — Even Interstate Ones
Most Excel templates have CGST and SGST formulas hardcoded from the start. If you supply goods or services to a client in another state, IGST should apply — not CGST+SGST. Excel doesn't know where your client is. It just runs the formula you set up. If you don't change it manually every time, you'll apply the wrong tax for every interstate invoice.
No Invoice Serial Number Auto-Increment — Leading to Duplicate Numbers
GST law requires invoice numbers to be consecutive and non-repeating within a financial year. In Excel, nothing stops you from accidentally reusing INV-001 or skipping from INV-047 to INV-049. When you file GSTR-1, duplicate invoice numbers throw errors. And if a gap is noticed during audit, it raises a red flag that you may be suppressing invoices.
Missing HSN/SAC Code Column Entirely
A shocking number of Excel GST invoice templates downloaded from the internet don't have an HSN or SAC code column at all. If your turnover is above ₹1.5 crore, HSN codes are mandatory. If your buyer is filing GSTR-2A/2B reconciliation, they need the HSN code to match their purchase records. An invoice without an HSN code is technically non-compliant under Rule 46.
Excel Rounding Errors That Don't Match GSTN's Calculation
Excel's default rounding behaviour doesn't always match how the GSTN portal calculates GST. For example, on a taxable value of ₹1,847.33 at 18%, Excel might show ₹332.52, while GSTN calculates ₹332.52 — looks the same, but at scale across hundreds of invoices, small differences add up. During GSTR-3B reconciliation, even a ₹1 mismatch per invoice across 500 invoices means ₹500 discrepancy that you'll need to explain.
No Place of Supply Field — So CGST vs IGST Is Always a Guess
Place of Supply is the field that determines whether you charge CGST+SGST or IGST. It's a mandatory field under Rule 46. Most Excel templates don't have it — and when it's not there, you're making a judgment call every time. If you get it wrong consistently for certain clients, you're building up a pattern of incorrect tax application that will eventually surface in reconciliation.
Why I Built GSTInvoiceFree.in
I got tired of seeing small creators and shopkeepers get bullied by complex software or expensive CAs just to generate a simple, legal piece of paper they need to get paid. The Excel template situation is honestly worse than I expected when I started. Most of the templates out there are missing Place of Supply, have no HSN field, and have hardcoded tax formulas that will silently break the moment someone sends an invoice to a client in another state.
So I built a free, browser-based invoice generator that handles all of this automatically. You enter your details, it detects the correct tax type, calculates everything, and gives you a clean PDF in under 60 seconds. No Excel. No formulas. No risk of silent errors.
📋 2026 E-Invoice Update — Excel Is Not Compatible
As of 2026, businesses with Annual Aggregate Turnover (AATO) above ₹5 crore must generate e-invoices through the GSTN IRP portal. E-invoicing requires your invoice to be submitted in a specific JSON format and validated by the portal before it's issued. Excel templates cannot generate or submit JSON to the IRP. If your turnover is approaching ₹5 crore, you need to move away from Excel-based invoicing now — not after you cross the threshold. GSTInvoiceFree.in generates invoices in the correct compliant format.
Sample GST Invoice Format in Excel — What It Should Look Like
TAX INVOICE
Supplier: Mehta Textiles, 12 Katargam Road, Surat, Gujarat — 395004
GSTIN: 24AAAPM1234A1Z5 | State Code: 24 — Gujarat
Invoice No: MT/2026-27/001 | Date: 17 May 2026
Buyer: Sharma Retail Pvt Ltd, FC Road, Pune, Maharashtra — 411004
Buyer GSTIN: 27AABCS1234A1Z3 | Place of Supply: 27 — Maharashtra
Item: Cotton Fabric | HSN: 5208 | Qty: 100 metres
Rate: ₹500/m | Taxable Value: ₹50,000
IGST @ 5%: ₹2,500 (interstate — Maharashtra ≠ Gujarat)
CGST: NIL | SGST: NIL
Total Invoice Value: ₹52,500
Notice: Place of Supply is Maharashtra (27), supplier is in Gujarat (24). That's two different states = IGST applies. Not CGST+SGST. This is exactly what a hardcoded Excel template would get wrong.
Stop Risking ITC Rejections With Excel
GSTInvoiceFree.in auto-detects CGST, SGST, and IGST based on your client's state. No formulas. No guessing. Clean PDF in 60 seconds — completely free.
→ Generate My GST Invoice FreeFrequently Asked Questions
How to create GST invoice in Excel step by step?
Set up columns for invoice number, date, buyer GSTIN, item description, HSN/SAC code, quantity, rate, and taxable value. Add a tax section with separate rows for CGST+SGST (intrastate) or IGST (interstate). Always check the Place of Supply first before deciding which tax applies. Use formulas like =D10*(E10/2) for CGST and SGST, or =D10*E10 for IGST. That said, Excel has zero compliance validation — for error-free invoices, GSTInvoiceFree.in handles all of this automatically and free.
What is the GST invoice Excel formula for CGST, SGST and IGST?
For intrastate supply: CGST = Taxable Value × (Rate÷2), SGST = Taxable Value × (Rate÷2). For interstate supply: IGST = Taxable Value × Rate. In Excel with taxable value in D10 and 18% rate: use =D10*9% for CGST and SGST, or =D10*18% for IGST. Never hardcode one formula for all invoices — always check the Place of Supply first.
Can I make a GST invoice in Excel without software?
Yes, you can make a GST invoice in Excel without any paid software. You need to manually include all mandatory fields under Rule 46 of the CGST Rules 2017 — including GSTIN, invoice number, HSN/SAC code, Place of Supply, taxable value, and tax breakup. The risk is that Excel has no validation — it won't warn you if you apply the wrong tax type. For compliant invoices without the risk, GSTInvoiceFree.in is free and handles all validations automatically.
Is there a free GST invoice Excel template for freelancers in India?
Freelancers in India need a GST invoice format with SAC code (not HSN — SAC is for services), taxable value, and the correct tax type based on the client's state. Most downloadable Excel templates are built for goods traders and miss the SAC code field entirely. A better alternative is GSTInvoiceFree.in — it's browser-based, works on mobile, and auto-detects whether to apply CGST+SGST or IGST based on where your client is located.
How to add HSN code in GST invoice Excel?
Create a dedicated column labeled "HSN/SAC Code" next to your item description column. For goods, enter the 4-digit or 8-digit HSN code. For services, enter the SAC code. HSN codes are mandatory for businesses with turnover above ₹5 crore (8-digit) and ₹1.5 crore to ₹5 crore (4-digit). Missing HSN codes is a common reason for GSTR-1 errors and ITC rejection at your buyer's end.