GST invoice format in Excel
A ready GST tax invoice: HSN/SAC on every line, and CGST + SGST or IGST that calculate themselves. Download the Excel file, or fill the same layout online and get a PDF.
.xlsx · works in Excel, Google Sheets and LibreOffice · free, no signup
What the template includes
The fields a GST tax invoice normally carries, in the order a buyer and their accountant look for them.
- Supplier name, address and GSTIN
- Your legal name, address and 15-character GSTIN.
- Invoice number and date
- A unique number that runs in sequence for the financial year, and the date of issue.
- Recipient name, address and GSTIN
- The buyer's details; their GSTIN only if they are registered.
- Place of supply
- The state that decides whether CGST + SGST or IGST applies.
- HSN or SAC code
- HSN for goods, SAC for services, on every line.
- Taxable value
- Quantity × rate for each line, before tax.
- CGST + SGST or IGST
- Half the GST rate each for a supply within your state; the full rate as IGST for another state.
- Total and signature
- The amount payable and the signature of you or an authorised signatory.
How to use it
- Fill the yellow cells: your details, the buyer's details, invoice number, date and place of supply.
- Choose Intra-state (same state, CGST + SGST) or Inter-state (another state, IGST).
- Add each item with its HSN or SAC code, quantity, rate and GST %. The taxes and totals fill in.
- Save it as a PDF and send it, or make the same invoice online with a UPI QR code.
Questions
Is this GST invoice template free?
Yes. The Excel template is free to download and use for any business, with no signup and no watermark.
Does the Excel template calculate GST?
Yes. Enter quantity, rate and GST % on each line and choose whether the supply is within your state or to another state. The sheet works out the taxable value, CGST and SGST (or IGST) and the totals.
When do I charge CGST and SGST instead of IGST?
CGST and SGST apply when you and the place of supply are in the same state; each is half the GST rate. IGST applies when the place of supply is in another state, at the full rate.
Can I make the GST invoice online instead?
Yes. Open the GST template in Invoiceful's editor, fill it in your browser and download a PDF with an optional UPI QR code. Nothing is uploaded to a server.
Is the template valid as a tax invoice?
It includes the fields a GST tax invoice normally needs. Rules can change and depend on your business, so check the current government guidelines for anything specific to you.
More on GST invoices: required fields explained, the Excel layout field by field, and invoicing without a GST number.
This template is a layout, not tax advice. Check the current GST rules for anything specific to your business.
Stop fighting your invoice software. Send your first invoice now.
One page. Real-time preview. PDF in seconds. No signup. Open it in another tab and try it — see what we mean.