Free template · Billing
GST invoice format (free Excel download)
A clean tax invoice for Indian businesses. Pick intra-state or inter-state and the sheet works out CGST + SGST or IGST for every line.
- Free, no sign-up
- Formulas included
- Excel, Google Sheets & LibreOffice
Template preview
- Bill to
- Om Auto Parts, Chakan, Pune · GSTIN 27PQRST6789K1Z2
| Item | HSN | Qty | Rate | Taxable | CGST 9% | SGST 9% | Total |
|---|---|---|---|---|---|---|---|
| Machined brackets | 8708 | 200 | 450 | 90,000 | 8,100 | 8,100 | 1,06,200 |
| Mounting plates | 7326 | 100 | 250 | 25,000 | 2,250 | 2,250 | 29,500 |
| Total | 1,15,000 | 10,350 | 10,350 | 1,35,700 |
Preview with sample data
What it includes
- Supplier name, address and GSTIN
- Invoice number (unique, up to 16 characters) and date
- Customer name, address and GSTIN
- Place of supply (state name and code)
- Description, HSN code, quantity, unit and rate
- Taxable value, GST rate and tax amounts
- Whether reverse charge applies
- Signature of the supplier or authorised person
How to use it
- Add your company details, GSTIN and the customer’s details.
- Choose intra-state (CGST + SGST) or inter-state (IGST).
- Enter items, HSN codes, quantities and rates. Taxes and totals fill in automatically.
Questions
Good to know
What must a GST invoice contain?
Supplier and customer details with GSTINs, a unique invoice number and date, place of supply, HSN codes, quantity, taxable value, the tax rate and amounts, whether reverse charge applies, and a signature.
When do I charge CGST + SGST and when IGST?
Charge CGST + SGST when the supplier and the place of supply are in the same state. Charge IGST when they are in different states.
How long can a GST invoice number be?
Up to 16 characters, using letters, numbers, hyphens or slashes, and unique for each financial year.
Done with paperwork?
Mera Udyog handles attendance, salary, quotations, invoices and HR records for you. Try it free for 7 days.
7-day free trial · No credit card needed