
Many small businesses still bill from an Excel sheet. A GST invoice in Excel is perfectly acceptable as long as it carries every field the CGST Rules require and the numbering stays unique. This guide gives you the layout, the formulas and the mistakes to avoid. If you would rather not build it yourself, use the free GST invoice generator instead.
Header block: what goes at the top
Supplier name, address and GSTIN
Invoice number and invoice date
Buyer name, address, GSTIN and state
Place of supply and whether tax is payable on reverse charge
Item table: the column layout
Use one row per item with these columns: serial number, description of goods or services, HSN or SAC, quantity, unit, rate, discount, taxable value, GST rate, CGST amount, SGST amount, IGST amount and line total. Keep the total row below the table with taxable value, total tax and the invoice value in figures and words.
Formulas for CGST, SGST and IGST
Taxable value: quantity x rate - discount
Same state: CGST = taxable value x (GST rate / 2) and SGST the same amount
Another state: IGST = taxable value x GST rate
Invoice total: taxable value + CGST + SGST + IGST (+ cess)
Add one cell that compares the supplier state and the place of supply, and let it switch between CGST plus SGST and IGST. This single check prevents the most common tax-split error.
Common mistakes in Excel invoices
Duplicate or skipped invoice numbers, which breaks the unique-series rule
Wrong HSN or GST rate typed by hand. Check codes with our HSN code finder.
Overwritten formulas that silently change totals
No place of supply, so the tax split cannot be verified
When to move beyond Excel
Once you issue many invoices a day, share billing between users or need e-invoicing and e-way bills, a spreadsheet becomes the bottleneck. Read about invoicing software and e-invoicing software, or see the tax invoice format for the required fields.
