Example GST invoice table in Excel with HSN, taxable value and CGST plus SGST columns and an invoice total

GST

GST Invoice Format in Excel: Column Layout, Formulas and Mandatory Fields

Read More

Example GST invoice table in Excel with HSN, taxable value and CGST plus SGST columns and an invoice total

GST

GST Invoice Format in Excel: Column Layout, Formulas and Mandatory Fields

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.

Find the right HSN or SAC code and GST rate

Browse all 1,289 HSN and SAC headings by chapter, check the GST rate, and bill with the correct code.

Best Accounting Software in India

Built by CAs for Indian businesses. Create invoices, automate GST, track expenses, and run your accounts faster with AI + cloud.

No subscription required.

Best Accounting Software in India

Built by CAs for Indian businesses. Create invoices, automate GST, track expenses, and run your accounts faster with AI + cloud.

No subscription required.

Best Accounting Software in India

Built by CAs for Indian businesses. Create invoices, automate GST, track expenses, and run your accounts faster with AI + cloud.

No subscription required.