How to Create a GST Invoice in Excel (Step-by-Step Guide)

A GST invoice is more than just a bill — under Indian GST law it is a legal document that must contain specific details. Get the format right and your customer can claim input tax credit (ITC) smoothly; get it wrong and you risk penalties and rejected claims. This guide walks you through creating a fully GST-compliant invoice in Excel, step by step.

What every GST invoice must include

The CGST Rules (Rule 46) require a tax invoice to show:

• Your business name, address, and GSTIN
• A unique, consecutive invoice number (up to 16 characters) and the invoice date
• The customer's name, address, and GSTIN (if they are registered)
• The place of supply and the state code
• The HSN/SAC code for each item or service
• Description, quantity, rate, and taxable value of each item
• The tax rate and amount, split into CGST + SGST (or IGST)
• Whether tax is payable on a reverse-charge basis
• The signature of the supplier or an authorised signatory

Miss any of these and the invoice may not be valid for input tax credit.

Step-by-step: build a GST invoice in Excel

1. Set up the header. In the top rows, add your company name, address, GSTIN, and contact details. On the right, leave cells for the invoice number, date, and place of supply.
2. Add a "Bill To" block. Create labelled cells for the customer's name, address, GSTIN, and state.
3. Create the item table. Add columns for S.No, Description, HSN/SAC, Quantity, Rate, Taxable Value, GST %, CGST, SGST, and Total.
4. Add the formulas. Set Taxable Value to Quantity multiplied by Rate. For an 18% item, CGST and SGST are 9% each — so each tax equals Taxable Value times 9% (or Taxable Value times GST% divided by 2).
5. Total everything up. Below the table, use SUM formulas to total the taxable value, CGST, SGST, and the grand total.
6. Finish the invoice. Add the amount in words, your bank details, terms, and a signature line. Save it as a PDF before sending so the numbers cannot be changed.

CGST + SGST, or IGST?

This trips up a lot of people. It depends on the place of supply versus your own state:

• Same state (intra-state): split the GST into CGST + SGST, half each.
• Different state (inter-state): charge a single IGST at the full rate.

So an 18% GST item is 9% CGST + 9% SGST for a local sale, or 18% IGST for an inter-state sale.

Common mistakes to avoid

• Repeating or skipping invoice numbers — they must be a clean, consecutive series.
• Charging CGST + SGST on an inter-state sale (or IGST on a local one).
• Leaving out the HSN/SAC code or the place of supply.
• Editing an invoice after sending it — always send a non-editable PDF.

The faster way: use a free template

Building the formulas from scratch takes time, and it is easy to make a mistake. Instead, you can download our free GST Invoice Template — it already includes every required field and calculates CGST, SGST, and the total automatically. Just fill in your details and send it.

If you do not need GST, or you bill international clients, our general invoice template works too.

Summary

A compliant GST invoice needs your GSTIN, a unique invoice number, the place of supply, HSN/SAC codes, and the correct CGST/SGST or IGST split. Set it up once in Excel with formulas — or save the effort and start from a ready-made template.