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. This format 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.
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.