Excel billing · GST reference

The bill format in Excel — columns, formulas, and a worked example.

Exactly how to structure a GST-ready bill in Excel, with a filled example you can copy straight into a spreadsheet. Then a plain look at when Excel is enough — and when it starts costing you more time than it saves.

Reviewed July 2026
5 min read
CA Anil Agarwal & the TatvaBooks team

Why Excel is where most billing starts

Excel costs nothing extra if you already have it, everyone knows how to use it, and for a handful of bills a month it genuinely works. The trouble isn't Excel itself — it's that a GST-compliant bill has specific mandatory fields and a tax calculation that has to be exactly right every time, and a spreadsheet enforces neither.

Below is the column structure that works, a worked example, and — honestly — the point at which most businesses find Excel starts costing more time than it saves.

Column structure for a GST bill in Excel

Set these up as columns in your item table, left to right:

Column	What goes in it
Sr. No.	Simple running count for the line item.
Description	What was sold — be specific enough for the buyer to recognise it.
HSN/SAC	Required on the invoice if you're GST-registered.
Qty	Units sold — Nos, Kg, Ltr, etc.
Rate	Price per unit, before tax.
Taxable value	= Qty × Rate, minus any discount. Formula, not typed.
CGST / SGST or IGST	Tax rate and amount — decided per invoice by state.
Line total	= Taxable value + tax. This is what the row is worth.

Above the item table, add a header block with your business name, address and GSTIN; the buyer's name, address and GSTIN; an invoice number and date; and the place of supply. Below the table, total the taxable value and each tax column, then spell out the total in words.

A worked example

Here's the same structure filled in for an intra-state sale — a Jaipur-based seller billing a Jaipur-based buyer for stationery supplies at 12% GST.

Anand Stationery Mart

MI Road, Jaipur, Rajasthan — 302001

GSTIN: 08CCCCC2222C3Z7

Invoice No: ASM/026

Date: 02-Jul-2026

Sr.	Description	HSN	Qty	Rate	Taxable value	CGST 6%	SGST 6%	Line total
1	A4 Copier Paper (500 sheets)	4802	40 Reams	₹250	₹10,000	₹600	₹600	₹11,200

Grand total: ₹11,200.00

Amount in words: Rupees Eleven Thousand Two Hundred Only

You can copy this structure directly into a new Excel sheet — set the Taxable value, CGST, SGST and Line total columns as formulas so you only ever type the description, quantity and rate.

When Excel is enough — and when you outgrow it

Excel keeps working fine right up until one of these shows up. Be honest with yourself about which column you're already in:

	Excel	TatvaBooks
More than one person billing	Two people editing the same sheet, or separate sheets — invoice numbers collide or skip.	Every user shares one sequential number; no clashes, ever.
GST filing	You re-total the sheet by hand or with a second formula pass before every GSTR-1.	Every invoice already sits in your GSTR-1/3B workings — nothing to re-total.
Formula errors	One dragged-down formula, one manually overtyped cell, and the tax total is silently wrong.	GST is computed by the system on every line — there's no cell to break.
GSTR-2B / ITC matching	Not possible from a spreadsheet — you're checking purchases against 2B by eye.	Purchases reconcile against GSTR-2B automatically before you file.
Backup & access	One file, one laptop — email it around and versions drift.	One live copy, backed up, with your CA seeing the same books you do.

If none of these apply to you yet, Excel is a perfectly reasonable place to stay. The moment one does, moving your billing to GST billing software usually pays for itself in the first return cycle — free to start on the Solo plan (₹0), with the Business plan (₹599/month) adding inventory and multi-user access.

Generate this bill without maintaining a template

Instead of keeping an Excel template updated every time a GST rate or rule changes, TatvaBooks generates the same GST-correct bill for you automatically — the CGST/SGST vs IGST split, HSN lookup and running invoice number are all handled. See it laid out field-by-field on the GST bill format page.

Frequently asked questions

What is the bill format in Excel for GST?

A GST-ready Excel bill needs columns for serial number, item description, HSN/SAC code, quantity, rate, taxable value, CGST+SGST (intra-state) or IGST (inter-state), and line total — plus a header block with your GSTIN, the buyer's GSTIN, invoice number, date and place of supply. See the column structure and worked example on this page.

Can I make a free GST bill in Excel?

Yes — set up the columns above with SUM and multiplication formulas for taxable value and tax, and you have a working GST bill. It's genuinely free and fine for very low invoice volumes. The catch is everything manual: choosing CGST+SGST vs IGST yourself each time, keeping invoice numbers sequential across users, and re-entering the same data at GST filing time.

How do I calculate GST in an Excel bill?

Taxable value = Quantity × Rate (minus any discount). For intra-state sales, split the GST rate equally into CGST and SGST — e.g. an 18% item is =Taxable_value*9% in both the CGST and SGST columns. For inter-state sales, apply the full rate once in a single IGST column. Line total = Taxable value + tax. The formulas are simple, but every one of them is a place a typo or a dragged-wrong-direction cell can silently create a wrong invoice.

When should I move from Excel to accounting software for billing?

Three signals: more than one person is raising bills (numbering collisions), you're filing GST returns and re-totaling the sheet by hand each time, or you've had even one formula error reach a customer. At that point the manual steps Excel needs — CGST/SGST vs IGST decisions, sequential numbering, GSTR-2B matching — are exactly what software like TatvaBooks automates.

Is there a downloadable Excel bill template?

Rather than hand you a static file to maintain and re-download every time GST rules change, we've laid out the exact column structure and a worked example on this page — copy it straight into a new Excel sheet. Or skip the spreadsheet entirely: TatvaBooks generates the same GST-correct bill automatically, with no template to keep updated.

What's the difference between an Excel bill and a GST tax invoice?

They can be the same document — a tax invoice is just a bill that carries every field GST law requires (Rule 46): sequential invoice number, both parties' GSTIN, HSN codes, and the correct tax breakup. An Excel sheet is a valid tax invoice only if you've included all of those fields correctly on every single row. See our full GST bill format guide for the complete field list.

Keep going.

Formats

On the product

GST reference

Free on Solo · no card · no template to maintain

Stop maintaining an Excel bill format — generate it automatically.

Enter the buyer and items once; TatvaBooks works out the GST split, HSN codes and invoice numbering for you. Free to start.

Request beta access See GST billing software