GST Invoice Format in Excel: Free Template + When to Switch to Software

If you're searching for a GST invoice format in Excel, you're probably trying to get a compliant bill out the door without wading through accounting software you don't need yet. Fair enough — here's a free template that has the fields GST actually requires, plus a quick explainer so you're not guessing at what's mandatory.

Download the free GST invoice Excel template →

What has to be on a GST invoice

Under GST rules, a tax invoice needs to include:

• Invoice number and date — sequential, unique for the financial year
• Supplier details — your business name, address, and GSTIN
• Recipient details — customer name, address, and GSTIN (if they're registered)
• HSN or SAC code — HSN for goods, SAC for services. Mandatory once your turnover crosses the applicable threshold, and good practice even below it
• Description, quantity, and rate for each item or service
• Taxable value — the amount before tax
• Tax breakup — CGST + SGST for an intra-state sale, or IGST for an inter-state sale (not both)
• Place of supply — determines whether CGST/SGST or IGST applies
• Total invoice value, ideally with the amount in words for larger invoices

Miss the GSTIN, HSN code, or tax breakup and the invoice usually gets rejected by the recipient's accountant, or flagged during a GST reconciliation. The template above has all of these fields already laid out, with example values in the first row so you can see the expected format.

CGST + SGST vs. IGST — the part people get wrong

This trips up more people than anything else on the invoice:

• Selling within your own state? Split the tax into CGST and SGST, usually equal halves (e.g., 9% + 9% for an 18% total rate).
• Selling to a different state? Charge IGST at the full rate instead (e.g., 18%), and leave CGST/SGST blank.

Get this wrong and the invoice is still technically incorrect even if the total tax amount is right — the split matters for how the tax is credited between states.

Where the Excel template starts to break down

A spreadsheet works fine for the first few invoices. It usually stops working around the same three points:

1. You can't tell who's actually paid. Excel doesn't track payment status — you're either keeping a separate list or scrolling back through old sheets trying to remember if invoice #47 got settled.
2. Numbering gets messy. Once you're editing old invoices, duplicating tabs, or working across two devices, invoice numbers start colliding or skipping.
3. Multi-currency and reminders become manual work. If you bill international clients, or want to nudge someone about an overdue payment, there's no automation — it's on you to notice and follow up.

None of that means you did anything wrong using a template — it's the right tool for the first invoice or the first ten. It's just not built to scale past that.

If you outgrow the spreadsheet

(Disclosure: I run Simple Billing, so take this as a biased but honest recommendation.)

When the spreadsheet starts costing you more time than it saves, Simple Billing does the same GST-compliant invoice — CGST/SGST/IGST split, HSN codes, the works — but adds what Excel can't: a first invoice in under 2 minutes, automatic payment-status tracking, PDF delivery by email or WhatsApp, and support for 160+ currencies if you bill outside India. There's a free plan, so you can try it on a real invoice before deciding whether it's worth switching.

If you're sticking with the spreadsheet for now, that's a perfectly reasonable call — just bookmark this page for the field reference, and revisit software once tracking payments manually starts eating more time than it's worth.