GST invoice format in Excel

A tax invoice laid out with the details Indian GST rules ask for: supplier and recipient GSTIN, invoice number and date, place of supply, HSN or SAC code, quantity, rate, discount and taxable value for each line. Choose Intra-state or Inter-state once and every line splits tax into CGST and SGST, or charges IGST, at the rate you pick. Totals are rounded to the rupee with the round-off shown.

Templates

GST invoice format (Excel) (Excel spreadsheet): A GST tax invoice format in Excel with GSTIN, HSN/SAC, place of supply and automatic CGST and SGST, or IGST for inter-state supplies.
Invoice (Excel) (Excel spreadsheet): An auto-calculating invoice in Excel: line items, subtotal, discount, tax, total, amount paid and balance due, laid out to print on one page.
Quotation (Excel) (Excel spreadsheet): A price quotation format in Excel with line items, discount, tax and total that calculate themselves, plus validity date and acceptance terms.

How to use these templates

Enter your business name, address, GSTIN and state code, and the customer’s details and place of supply.
Set Supply type: Intra-state when you and the place of supply are in the same state, Inter-state when they differ.
Add each item with its HSN or SAC code, quantity, rate and any discount, and choose its GST rate from the dropdown.
Write the amount in words, sign it, and save it as PDF for the customer.

Getting a GST invoice right

Number invoices in one consecutive series per financial year, up to 16 characters, for example GST/26-27/0001.
Intra-state supplies charge CGST and SGST (or UTGST) at half the rate each; inter-state supplies charge the full rate as IGST.
GST rates were rationalised in September 2025, with most goods moving to 5% or 18% and a 40% rate for luxury and sin goods. Check the current rate for each HSN or SAC code before you issue.
For sales to unregistered buyers, write URP in place of the GSTIN, and include their address and state when the value is above the threshold that applies.
Mark Reverse charge Yes when the recipient pays the tax, and keep the "Original for recipient" copy separate from duplicate and triplicate copies for goods.

Frequently asked questions

Is this GST invoice format valid?

It includes the fields a tax invoice needs under the GST rules. Check it against your own requirements, especially e-invoicing if your turnover makes it mandatory.

How do I switch between CGST/SGST and IGST?

Change Supply type at the top to Inter-state. Every line then charges IGST instead of splitting the tax.

Does it write the amount in words?

Excel has no built-in function for Indian number words, so there is a cell to type it. The total is rounded to the rupee for you.

Can I use it for services?

Yes. Put the SAC code in the HSN/SAC column and leave quantity as 1 with the fee as the rate.