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 the supplier is unregistered and GST is payable under Reverse Charge, do not use a regular tax invoice. Use the self invoice format under GST (RCM) Excel template instead.

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.

FAQ

Is a hand-written or Excel GST invoice legal?

Yes. GST law does not require special software — the invoice can be printed, hand-written, or generated from Excel, as long as it contains every mandatory field (GSTIN, invoice number, date, place of supply, HSN/SAC, taxable value, and the correct GST split). The format matters, not the tool.

What is the difference between CGST + SGST and IGST?

CGST + SGST applies to intra-state sales (buyer and seller in the same state), split half and half. IGST applies to inter-state sales (different states) and is charged as a single tax at the full rate. The place of supply determines which one you charge.

How many copies of a GST invoice do I need?

For the supply of goods, three copies: original for the buyer, duplicate for the transporter, triplicate for your records. For services, two copies: original for the buyer and duplicate for your records.

Can I use this Excel invoice template for GSTR-1 filing?

Yes. The template captures every field required for GSTR-1 return filing — invoice number, date, GSTIN of the recipient, taxable value, and CGST/SGST/IGST amounts. You can enter each invoice into the template and use it as a source for your monthly return.

What if I buy from an unregistered supplier?

Then you need a self invoice under Reverse Charge, not a regular GST tax invoice. Use the self invoice format under GST (RCM) Excel template.