GST invoice format in Excel: the columns that matter
Most GST invoice spreadsheets fail for one reason: the tax is stored as text, or the taxable value and the tax share a single column. Neither is visible until an accountant rejects the bill at filing time, weeks after you issued it. The format below keeps the taxable value, CGST, SGST, IGST and the total in separate numeric columns with live formulas between them, so the arithmetic is never something you retyped by hand. Type a quantity and a rate and everything downstream recalculates. This guide covers the columns, the two rules that break most spreadsheets, and how to tell a genuine .xlsx from a picture of one.
The column layout that survives an audit
Order matters less than separation. The rule your accountant cares about is that the taxable value is stored on its own and the tax is computed from it, never typed alongside it. A combined column like "₹1,180 incl. 18% GST" cannot be reconciled and is the single most common reason a claim is rejected. This format carries the fields below as distinct, numeric columns.
| Column | What goes in it | Common mistake |
|---|---|---|
| Invoice No. + Date | A consecutive number and the date of issue | Reusing a number after a cancellation |
| Supplier + Recipient | Both GSTINs where the buyer is registered | Leaving the recipient GSTIN blank |
| Particulars + HSN/SAC | Description and the code, per line | HSN left blank on service lines |
| Qty × Rate | Numbers, not formatted text | Rate typed as "250/-" instead of 250 |
| Taxable value | The pre-tax amount for the line | Including tax, which breaks every formula below it |
| CGST / SGST / IGST | Rate as a bare number, amount as a formula | Typing "18% GST" — a formula cannot read text |
| Total invoice value | Sum of line totals plus tax | Retyped by hand instead of summed |
| Amount in words | Required above ₹1,00,000 | Typed from the total — Excel cannot spell it out |
How the auto-calculation actually works
Each tax cell is a formula pointing at the taxable value and the rate cell for that line, so changing a quantity updates the tax, the line total, every subtotal and the invoice total in one pass. That is what makes the workbook worth having: you are not maintaining a template, you are maintaining the inputs. The two rules that break this are simple — the rate must be a bare number with no percent sign and no text, and the taxable value must not include tax. Break either one and Excel silently treats the cell as text, the formula returns an error, and the failure looks like nothing at all until someone totals the column six weeks later.
Why HSN and SAC codes belong in the file
HSN for goods, SAC for services, and the digits you must declare depend on your annual turnover: two digits at ₹5 crore and below, four digits up to ₹25 crore, and six digits above that. Keeping a separate code column per line is what lets you produce a compliant invoice for a customer who needs to claim input tax credit — and it is also what lets your accountant reconcile your returns against your books without retyping anything. The HSN and SAC finder on this site lists both, searchable by description.
What Rule 46 requires on every invoice
Whether the supply is to a registered business or a walk-in customer, Rule 46 of the CGST Rules sets out the particulars a tax invoice must carry: a consecutive invoice number, the date of issue, supplier and recipient details including GSTIN where applicable, a description of supply, the HSN or SAC code, quantity and rate per line, the taxable value, the rate and amount of tax, and the total invoice value. Amount in words is required for invoices above ₹1,00,000. Missing any one of these is the most common cause of a buyer being unable to claim credit.
| Particular | Required | Notes for an Excel template |
|---|---|---|
| Consecutive invoice number | Yes | Keep it numeric so Excel cannot reorder it |
| Date of issue | Yes | Real date format, not text |
| Supplier GSTIN and address | Yes | Prefilled once, then reused |
| Recipient GSTIN | When registered | Needed for the buyer to claim ITC |
| HSN / SAC code | Yes | Its own column per line item |
| Taxable value, tax rate, tax amount | Yes | Three separate columns, never combined |
| Total invoice value | Yes | A formula summing the lines |
| Amount in words | Above ₹1,00,000 | A field to type into, not a formula |
How to tell a real .xlsx from a picture of one
A surprising number of "free Excel templates" online are images or PDFs with a spreadsheet look, or workbooks where every number is stored as text. Check three things before you rely on one. Click a total and look at the formula bar: a working file shows =SUM(...), a fake one shows the number. Try sorting the lines by amount — text sorts 9 before 10. And check a tax cell: it should be a formula referencing the rate cell, not a typed figure. This workbook passes all three, and that is the difference between a template you can use for years and one you rebuild every quarter.
How to use this tool
- Download the .xlsx and open it in Excel, Google Sheets or LibreOffice.
- Fill in your supplier details and GSTIN once — the buyer GSTIN stays blank for walk-in customers.
- Enter each line with a description, HSN or SAC code, quantity and rate as plain numbers.
- Add the GST rate for that line as a bare number, 18 rather than "18% GST".
- Check the taxable value, CGST/SGST/IGST and the total recalculate as you type.
Example scenario
A design consultancy bills a Delhi client ₹1,18,000 including 18% GST. The taxable value resolves to ₹1,00,000, CGST is ₹9,000 and SGST is ₹9,000 — intra-state, so IGST stays empty. Enter a rate of 12% instead and the line total, both tax heads and the invoice total move together. The amount in words is the one field to retype, because a spreadsheet cannot spell the new total out for you.
Note: This is a blank format, not a filed return. Check the current HSN digit requirement against your turnover and your accountant is the authority on your specific case.
Frequently asked questions
Is this a real Excel file or an image of a spreadsheet?
It is a real .xlsx workbook. Amounts are stored as numbers with a number format rather than as text, so you can sort, filter and pivot the sheet, and your accountant can total it independently of anything we generated. The tax columns are live formulas — type a quantity and a rate and the taxable value, CGST, SGST, the line total and every subtotal recalculate.
Which GST columns does the format include?
Taxable value, CGST, SGST, IGST and the total invoice value are all separate columns. Keeping the taxable value separate from the tax is the point — a single combined tax column forces your accountant to back-calculate the base, which is where mismatches come from at filing time. For an inter-state supply, fill IGST and leave CGST and SGST empty; for an intra-state supply, do the reverse.
Why does my downloaded template stop calculating?
Almost always because the GST rate is typed as text. Write 18, not "18% GST". A cell containing text cannot be used in a calculation, and that single habit is the most common reason a working template goes dead. The rate also has to be a bare number, not a percentage formatted as text.
Do I need to enter HSN or SAC codes?
Yes, and the format gives each line its own column. A goods line needs an HSN code and a service line needs a six-digit SAC code. How many digits you must declare depends on your turnover — 2 digits at ₹5 crore and below, 4 digits up to ₹25 crore, and 6 digits above that. The HSN and SAC finder on this site lists both.
Is the format compliant with GST rules?
Yes. It follows Rule 46 of the CGST Rules: a consecutive invoice number and date, supplier and recipient details with GSTIN, a description of supply, HSN or SAC code, quantity and rate, the taxable value, the tax rate and amount, and the total invoice value. There is also a field for the amount in words, which is required for invoices above ₹1,00,000. Note that the amount in words is a field for you to type into — Excel cannot spell a number out in words on its own, so fill it in from the total.
Can I open this in Google Sheets or LibreOffice?
Yes. It is a standard .xlsx file, so it opens in Microsoft Excel, Google Sheets and LibreOffice Calc. The formulas use ordinary cell references rather than anything Excel-specific, so the totals behave the same in all three.
Do I need an account or a payment to download it?
No. There is no signup step and nothing to pay. The file is generated on your device and handed to your browser as a download, with no watermark and no account needed.
Should I use a template or just generate the invoice online?
Use the template when you will issue many invoices and want to keep your own layout, or when you need to edit figures after issuing. Generate the invoice online when you want it done for you — you enter the details once and the tax is computed for you. Many people keep the template for records and generate the invoice itself for each bill, which is a sensible split.