Skip to content
Free tool · no sign-up

Invoice Format in Excel — Free GST Bill Template

A ready GST tax invoice in Excel: fill the yellow cells and the amounts, GST and grand total work themselves out. Or make the bill online and print it.

GST invoice format in Excel

  • Supplier, buyer, GSTIN and place of supply
  • 12 item rows with HSN, qty, rate
  • GST at 0, 5, 18 or 40% per line
  • CGST / SGST split and grand total
Download Excel templateOr make the invoice online →Free · no sign-up · works in Excel and Google Sheets

A GST tax invoice must show the supplier's and recipient's names, addresses and GSTINs, an invoice number and date, the place of supply, each item's description, HSN code, quantity and value, the tax rate and amount, and the total. This format has every one of those fields.

What is in the Excel invoice format

Supplier and buyer blocks with GSTIN and state, invoice number and date, customer PO number, and twelve item rows. Each row works out the taxable value from quantity × rate, the GST at the rate chosen (0, 5, 18 or 40%), and the line total; the foot splits the tax into CGST and SGST for a sale within the state.

Rules for a valid tax invoice

Number invoices in one consecutive series per financial year, up to 16 characters. Show IGST instead of CGST + SGST when the supplier and the place of supply are in different states. Businesses above ₹5 crore turnover must also generate an e-invoice (IRN and QR code) for B2B sales.

Common questions

Questions people ask.

What should a GST invoice format contain?

Supplier and recipient names, addresses and GSTINs, invoice number and date, place of supply, item description, HSN code, quantity, value, tax rate and tax amount (CGST/SGST or IGST), total, and the signature of the supplier.

Can I make a GST invoice in Excel?

Yes. An Excel invoice is valid as long as it carries the details the GST rules require and is numbered in sequence. Above ₹5 crore turnover, B2B invoices must also be reported for an e-invoice IRN.

Is this invoice format free to use?

Yes — download the Excel template, edit it and use it for your business. No sign-up.

How is GST calculated in the template?

Taxable value = quantity × rate; GST = taxable value × rate %; within the state the GST is split equally into CGST and SGST, across states it is charged as IGST.

Which GST rates does the template use?

The slabs in force from 22 September 2025: 0%, 5%, 18% and 40%.

Other free tools

Doing this for every item, every day?

A calculator is the right tool once. When it is every item in the store, it belongs in the system that already knows the numbers.