A1:J24fxIF ROUND SUM
GST Invoice — the first rows of the actual spreadsheet
GST Invoice
The opening rows of the file you get — sample data included, not a mock-up.

Business template

GST Invoice

HSN/SAC per line, CGST and SGST or IGST worked out from the supply type, and a rounded total.

$12one payment, yours to keep
  • ✓Instant download
  • ✓Every later version free
  • ✓Commercial use
  • ✓No watermark
41
live formulas, each one recalculated and checked
10
columns: Description, HSN/SAC, Qty, Rate, Taxable value, GST %, CGST, SGST, IGST, Line total
12
figures worked out for you

Need more than one? All 11 Business templates for $39 — $133 bought separately. All 70 for $99.

Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print landscape on one page wide. Version 1, updated 20 November 2026.

There are free templates. Why this one?

There are, and some are fine. The difference is what has been checked. This file was built from scratch, then every formula in it was recalculated by a separate checker that compares each result against an independently worked-out answer — 41 of them here. A template that looks right and totals wrong is worse than no template at all, and that is the usual failing of one downloaded from a search result.

It also opens with sample rows already filled in, so you can see every formula working before you touch it, and it is set up to print without fighting the page setup. No watermark, and you can use it commercially.

About this GST Invoice template

A GST tax invoice has to show the tax split correctly or it causes problems for you and your customer. This Excel template takes each line's quantity, rate and GST rate and works out the taxable value.

Choose Intra-state or Inter-state once at the bottom. Intra-state supplies split the GST equally into CGST and SGST; inter-state supplies charge it all as IGST. The totals show taxable value, each tax, the round-off and the total payable, with space for invoice number, GSTINs and place of supply.

Good for

  • →Small businesses and freelancers registered for GST
  • →Shops billing customers with goods at different GST rates
  • →Service providers invoicing with SAC codes

What it works out for you

Invoice total

  • →Taxable value
  • →CGST
  • →SGST
  • →IGST
  • →Round off
  • →Total payable

What is inside the GST Invoice template

The table has 10 columns. Calculated columns fill themselves in; the rest are yours to type over.

  • →Description
  • →HSN/SAC
  • →Qty
  • →Rate
  • →Taxable value
  • →GST %
  • →CGST
  • →SGST
  • →IGST
  • →Line total

Settings in the “Invoice details” box

  • →Invoice number
  • →Invoice date
  • →Place of supply
  • →Supply type
  • →Seller GSTIN
  • →Buyer GSTIN

How to use the GST Invoice in Excel

Set the supply type at the bottom: Intra-state splits each line's GST into CGST and SGST, Inter-state charges it all as IGST. Blank line rows stay blank.

The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.

Shaded, boxed cells below the table are settings the formulas read from. Change those first — every row that depends on them updates at once.

Functions and formulas it uses

Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.

IFROUNDSUM

Questions about the GST Invoice

How does it decide between CGST/SGST and IGST?

From the Supply type cell. Intra-state puts half the GST in CGST and half in SGST. Inter-state puts the full amount in IGST. Change the cell and every line recalculates.

Can lines have different GST rates?

Yes. Each line has its own GST % so you can mix 5%, 12% and 18% items on one invoice.

Is this a substitute for e-invoicing?

No. Businesses above the e-invoicing threshold must generate invoices through the government portal. This template suits businesses that are not required to e-invoice.

What you get with the GST Invoice

  • ✓41 formulas, every one recalculated and checked
  • ✓Opens with sample rows already filled in
  • ✓Excel, Google Sheets and LibreOffice Calc
  • ✓Set up to print landscape, one page wide
  • ✓Commercial use, no attribution needed
  • ✓Every later version included free

Get the GST Invoice for $12

One payment. The file downloads straight away, and every later version of it is yours at no extra cost.

Buying a few? All 11 Business templates for $39, or all 70 for $99.

More business templates

See all Business →