GST Bill Format: Samples and a Free Excel Template

The three bills an Indian shop issues, with what goes where, and an Excel template that works out CGST, SGST and IGST for you.

Excel (.xlsx), also opens in Google Sheets. Fill in the yellow cells; type each item's GST rate.

Which bill do you need?

You areSelling toIssue
A regular GST dealerA walk-in customerTax invoice (retail). Under ₹200, if the customer doesn't want one, a single invoice at day end covers all such sales.
A regular GST dealerA registered businessTax invoice with the buyer's GSTIN (B2B)
In the composition scheme, or selling exempt goodsAnyoneBill of supply, with no GST on it

The full list of what an invoice must show, the current GST rates and the HSN digit rules are on the GST invoice generator page.

Not sure which one to issue? Read tax invoice or bill of supply.

1. Retail tax invoice (B2C, same state)

For a customer at the counter. Seller and customer are in the same state, so the 5% GST is split into 2.5% CGST and 2.5% SGST. The customer's name and address are optional below ₹50,000.

Sample
Sample General Store

12 Market Road, Noida, Uttar Pradesh

GSTIN: 09XXXXXXXXXXXXX

TAX INVOICE

No. INV/26-27/0142

Date: 20 Oct 2026

Customer: Walk-in · Place of supply: Uttar Pradesh (09)

#ItemHSNQtyRateGSTTaxable
1Toothpaste 150 g33062 Nos90.005%180.00
2Shampoo 340 ml33051 Nos220.005%220.00
3Bath soap 100 g34014 Nos35.005%140.00
Taxable value₹540.00
CGST 2.5%₹13.50
SGST 2.5%₹13.50
Total₹567.00

Rupees Five Hundred Sixty Seven Only

Tax payable on reverse charge: NoAuthorised signatory

2. B2B tax invoice (to another state)

For a registered buyer: their GSTIN goes on the bill. The buyer is in Delhi and the seller in Uttar Pradesh, so the whole 18% is IGST, and the place of supply is shown with the state name and code.

Sample
Sample Electronics Traders

45 Sector 18, Noida, Uttar Pradesh

GSTIN: 09XXXXXXXXXXXXX

TAX INVOICE

No. TI/26-27/0031

Date: 20 Oct 2026

Bill toSample Cooling Services

8 Lajpat Nagar, New Delhi

GSTIN: 07XXXXXXXXXXXXX

Place of supplyDelhi (07)
#ItemHSN/SACQtyRateGSTTaxable
1Split air conditioner 1.5 ton84152 Nos32,000.0018%64,000.00
2Installation99872 Nos1,500.0018%3,000.00
Taxable value₹67,000.00
IGST 18%₹12,060.00
Total₹79,060.00

Rupees Seventy Nine Thousand Sixty Only

Tax payable on reverse charge: NoAuthorised signatory

3. Bill of supply (composition dealer)

A dealer in the composition scheme cannot charge GST, so the bill has no tax columns. Rule 5 of the CGST Rules requires the words "composition taxable person, not eligible to collect tax on supplies" at the top.

Sample

Composition taxable person, not eligible to collect tax on supplies

Sample Stationers

3 College Road, Noida, Uttar Pradesh

GSTIN: 09XXXXXXXXXXXXX

BILL OF SUPPLY

No. BOS/26-27/0087

Date: 20 Oct 2026

Customer: Walk-in

#ItemHSNQtyRateAmount
1Notebook, 200 pages482010 Nos40.00400.00
2Ball pen960810 Nos10.00100.00
Total₹500.00

Rupees Five Hundred Only

Authorised signatory

The shops, GSTINs and prices above are made up. GST rates are examples from the slabs in force since 22 September 2025: check your own item's rate by its HSN code.

Questions

Is there a fixed GST bill format?

No. Rule 46 of the CGST Rules lists the details a tax invoice must carry, not a layout. Any format is fine as long as every required detail is on it.

Can I make GST bills in Excel?

Yes. The free template here works out the taxable value, CGST, SGST or IGST and the totals. You still have to keep the invoice numbers in sequence yourself and add up your sales for the GST return.

What is the difference between a tax invoice and a bill of supply?

A tax invoice shows the GST charged on the sale. A bill of supply has no tax on it: it is issued by a dealer in the composition scheme, or for exempt goods. A composition dealer must print "composition taxable person, not eligible to collect tax on supplies" at the top.

Do I need the buyer's address on a retail bill?

For a buyer who is not registered, only when the taxable value is ₹50,000 or more, or when the buyer asks for it. Then the bill also needs the delivery address and the state name and code.

Billing for a particular trade? See billing for kirana stores, medical stores, clothing shops and other types of business.

Stop typing bills into Excel

BillSakha numbers every bill, picks up GST from each product, keeps stock and customer accounts, and gives you GST reports at month end.

14-day free trial · Cancel anytime · No setup fees