GST invoice format in Excel
Free Excel template with formulas for amount, CGST, SGST, IGST, round-off and total. No macros.
What the Excel template does
- Grey cells are for you to fill; the rest calculates by itself
- Switches between CGST + SGST and IGST from the two GSTINs
- Prints on one A4 page
Excel vs the online version
Excel cannot write the amount in words, the HSN summary or a UPI QR code, and you must copy the file for every bill. The online version does all of that and repeats your last invoice in one tap.
| Your Business Name Address, City - PIN GSTIN/UIN : Your 15-digit GSTIN State Name : Your State, Code : 00 | Invoice No. INV/1/2026-27 | Dated DD-MMM-YYYY | |||||
| Buyer (Bill to) Buyer Name Address, City - PIN GSTIN/UIN : Buyer's GSTIN Place of Supply : Buyer's State (00) | e-Way Bill No. · Vehicle No. · Terms of Delivery | ||||||
| Sl | Description of Goods | HSN/SAC | GST Rate | Quantity | Rate | per | Amount |
|---|---|---|---|---|---|---|---|
| 1 | Product name | HSN | 18 % | 10 PCS | 100.00 | PCS | 1,000.00 |
| Output IGST @ 18% | 180.00 | ||||||
| Total | 10 PCS | ₹ 1,180.00 | |||||
| Amount Chargeable (in words): INR One Thousand One Hundred Eighty Only | |||||||
| HSN/SAC summary · Taxable value · Tax rate · Tax amount · Tax is payable on Reverse Charge : No | |||||||
| Terms & Conditions · UPI QR to pay | Bank details · for Your Business Name · Authorised Signatory | ||||||
Make this invoice now. Free, no sign-up, works on your phone.
Open GST Bill Format →