Free download
GST invoice format in Excel, free download
Two ready GST invoice templates for Excel, plus the same invoice in Word and PDF. Fill in the quantity and the rate, and the taxable value, the tax split and the grand total work themselves out.
- No email address, no signup, no watermark
- Live formulas do the GST split for you
- Every field Rule 46 asks for is already on it
Free files
Download the GST invoice format in Excel
The two workbooks are built for GST invoicing specifically: a supply-type cell, a GSTIN line for both parties, and HSN or SAC on every item line. The Word and PDF cards are the same invoice for when nothing needs to calculate.
What is a GST invoice format in Excel?
A GST invoice format in Excel is a spreadsheet that already carries the fields a tax invoice needs: your GSTIN, the buyer GSTIN, a consecutive invoice number, HSN or SAC codes, the taxable value, and the CGST, SGST or IGST split, worked out by formula rather than by hand.
A plain invoice and a GST invoice look similar until you check the fields. A GST invoice has to carry your GSTIN, the place of supply and a tax split that a plain bill never needs, and those fields are not optional once you are registered.
Both workbooks on this page start from that requirement rather than adding it later. The GSTIN line, the HSN or SAC column and the supply-type cell are built into the sheet, so filling in a bill means filling in a form that is already correct.
What differs between the two workbooks is scale, not correctness. The full sheet carries a GST rate per line, for a bill that mixes rates. The simple sheet carries one rate for the whole invoice, for a counter that sells at a single rate all day.
How do I create a GST invoice in Excel, step by step?
Download the sheet, fill in your business name, address, GSTIN and state once, and save that as a master file. For each bill, open the master, save it under the invoice number, then enter the buyer, the place of supply and the item lines. The sheet works out the tax.
Treat the first fill-in as a one-time setup rather than part of billing. Your business details do not change bill to bill, so a master copy with them already entered saves you retyping the same five lines on every invoice.
From there, each invoice is a fresh copy of the master, saved under its own invoice number. Keeping one folder per financial year, with the files named by number, is what keeps a series consecutive and makes a gap in it obvious the moment one appears.
The steps, in order
- Download the workbook and open it in Excel
- Fill in your business name, address, GSTIN and state, once
- Save that file as your master copy, before billing anyone with it
- For each bill, open the master and save it under the invoice number
- Enter the buyer name, address and GSTIN if they are registered
- Set the place of supply, which decides CGST plus SGST against IGST
- Type the item lines: description, HSN or SAC, quantity, rate and GST rate
- Check the totals, then type the amount in words and print or export as PDF
What fields does a GST invoice need in Excel?
Rule 46 of the CGST Rules sets the particulars a tax invoice must carry: your GSTIN and address, a consecutive invoice number, the buyer GSTIN where registered, HSN or SAC per line, quantity, rate, taxable value, place of supply and the tax split. Both sheets on this page carry every one.
None of these fields is a matter of house style. A bill missing the place of supply, or missing the buyer GSTIN on a business sale, is a bill the buyer may not be able to claim input tax credit against, which is the complaint that arrives a quarter later.
The sheet lays every field out once in the header block, so filling in a bill is a matter of typing values into a form that already has the right shape.
The fields on the sheet
- Your business name, address and GSTIN
- A consecutive invoice number, unique within the financial year
- The invoice date
- The buyer name and address, plus their GSTIN when registered
- The HSN code for goods, or the SAC code for services, per line
- Description, quantity and rate for each line
- The place of supply, with the state name and its code
- The tax split: CGST and SGST together, or IGST alone
- Whether reverse charge applies
- A signature block for the supplier
How does the sheet split CGST, SGST and IGST?
One supply-type cell decides the split. Set it to intra-state and a rate splits in half into CGST and SGST. Set it to inter-state and the same rate becomes IGST instead. The customer pays the same total either way; the tax just moves between the two heads.
Every tax cell on the sheet reads that one supply-type cell, so the two heads can never both be filled at once. That matters because a bill with CGST, SGST and IGST all carrying amounts is a bill somebody will have to reissue.
The round-off line is worth watching too. Tax at an odd rate on an odd taxable value lands on fractions of a paisa, so the sheet totals the exact figures first and then states the adjustment to the nearest rupee on its own line, rather than folding it quietly into the tax.
- Supplier
- Sample Stationery Mart, 12 College Road, Nagpur
- Supplier GSTIN
- 27DDDDD3333D1Z2
- Invoice number
- GST/2026-27/0087
- Invoice date
- 10-09-2026
- Buyer
- Sample Book Depot, Nagpur
- Buyer GSTIN
- 27EEEEE4444E1Z8
- Place of supply
- Maharashtra (27)
- Reverse charge
- No
| Description | HSN | Qty | Rate | Taxable value | GST rate | CGST | SGST | Line total |
|---|---|---|---|---|---|---|---|---|
| Ruled notebooks | 4820 | 50 | 40.00 | 2,000.00 | 12% | 120.00 | 120.00 | 2,240.00 |
| Ballpoint pens, box | 9608 | 20 | 90.00 | 1,800.00 | 12% | 108.00 | 108.00 | 2,016.00 |
| Total taxable value | 3,800.00 | |||||||
| CGST 6% | 228.00 | |||||||
| SGST 6% | 228.00 | |||||||
| Grand total | 4,256.00 | |||||||
Amount in words Four thousand two hundred fifty six rupees only
An illustration, not a real business. Both parties are in Maharashtra, so the 12% GST splits into CGST 6% and SGST 6% rather than becoming IGST.
Does it work for services, with SAC codes?
Yes. The HSN column on both sheets doubles as the SAC column: goods take an HSN code, services take a SAC code, and the rest of the row works the same either way. A single invoice can even mix goods and services, each carrying its own code.
Goods and services are classified differently under GST, but the invoice does not need two separate layouts for that. Quantity, rate, taxable value and the tax split behave identically whether the line is a product or a service.
What changes is only the code you type into that column and, for some services, the place of supply rule that decides where the tax is collected. A consultant billing a client in another state still fills in the same sheet, just with a SAC code and the client state as the place of supply.
When does a spreadsheet stop being enough for GST invoicing?
A spreadsheet cannot enforce a consecutive invoice number across two people billing at once, remember what a party already owes you, or turn a return into a credit note that carries the original invoice number and date. Invoice Saathi does the tax, the numbering and the ledger, then prints or shares the bill.
Numbering is usually the first thing that breaks. A folder of copied spreadsheets does not stop two people, or one person on two devices, from issuing the same invoice number twice, and once that happens the two bills share the only key that identifies either of them.
The ledger is the second thing a sheet cannot hold. It does not know what a party owes you, and it does not know that the bill you raised last month is the one a return now has to be credited against, carrying that invoice tax treatment forward rather than starting over.
The billing screen stays as plain as the spreadsheet: items and a total. Tax settings live in Setup, entered once, and the breakup appears on the printed bill.
Free to start, INR 2,500 or INR 5,000 a year.
Start freeFAQ
GST invoice format in Excel questions
Is this GST invoice format in Excel free to download?
How do I make a GST invoice in Excel?
What is the difference between a GST invoice and a GST bill format?
Does the sheet calculate CGST, SGST and IGST automatically?
Can I use this format for a service invoice with a SAC code?
What if I am not registered under GST?
Let the invoice number itself
The app does the tax split, the consecutive numbering and the amount in words, then prints to a counter roll or shares a PDF on WhatsApp. The spreadsheet stays where it is useful.
Start free