GST Invoice Format Excel: Free Download with Auto-Calculation
A ready-to-use GST invoice Excel template with CGST/SGST/IGST auto-split formulas, HSN code column, and print layout. Covers all 16 mandatory fields as per the CGST Act.
On this page
Key takeaways
- A valid GST tax invoice needs all 16 fields under Rule 46, including GSTIN, sequential number, HSN/SAC and a CGST/SGST or IGST split.
- Use a Supply Type dropdown so CGST and SGST each take half the rate intra-state, and IGST takes the full rate inter-state.
- HSN digits depend on turnover: 4 below Rs 5 crore, 6 up to Rs 50 crore, 8 above; wrong codes cost Rs 50 per invoice.
- Set the sheet to A4, define the print area and hide gridlines so the invoice prints cleanly on one page.
Why You Need a Proper GST Invoice Excel Template
Most small business owners start with a basic Excel spreadsheet to create GST invoices. It works — until it doesn't. A missing field, a wrong formula, or an incorrect CGST/SGST split can get your invoice rejected by your buyer's accounts team or flagged during a GST audit.
The problem with generic Excel invoice templates is that they were not built with Indian GST rules in mind. They skip mandatory fields, show total tax as a single line without breaking it into CGST and SGST, and do not handle the IGST scenario for inter-state sales. A GST-compliant invoice template needs to handle at least three different tax scenarios automatically.
We have built a GST invoice format Excel template that covers all 16 mandatory fields under Rule 46 of the CGST Rules, auto-calculates CGST/SGST for intra-state sales and IGST for inter-state sales, includes an HSN/SAC code column, and prints cleanly on A4 paper. This guide explains what is in the template, how to use it, and when you should consider switching to proper billing software.
If you are already generating more than 20 invoices per month, we recommend trying our free online invoice generator instead — no Excel required, and it handles GST calculations automatically.
16 Mandatory Fields in a GST Tax Invoice
As per Rule 46 of the CGST Rules, 2017 — every field is required for a valid tax invoice
- Supplier's legal name — must match your GST registration exactly
- Supplier's GSTIN — 15-digit alphanumeric number
- Supplier's address — registered address from your GST certificate
- Invoice number — unique sequential number, max 16 characters
- Invoice date — date of supply or issue of invoice
- Recipient's name — buyer's trading name or legal name
- Recipient's GSTIN — required for B2B invoices; optional for B2C
- Recipient's address — delivery or registered address
- Place of supply — state name and code that determines CGST/SGST vs IGST
- HSN code or SAC code — 4-digit minimum for turnover above Rs 5 crore, 2-digit for others
- Description of goods or services — clear item description
- Quantity and unit — number of units and unit of measurement (Nos, Kg, Ltr, etc.)
- Unit price (taxable value) — price before GST
- GST rate — percentage (0%, 5%, 18%, or 40% under GST 2.0)
- Tax amount — broken into CGST + SGST for intra-state, or IGST for inter-state
- Total invoice value — taxable value + GST amount + any cess
Excel Formulas for GST Auto-Calculation
The most important feature of a GST invoice Excel template is the tax calculation formula. Here is how the logic works in the template:
Step 1 — Taxable value: Each line item has a Quantity column (D) and a Unit Price column (E). The taxable value in column F is calculated as =D*E. This is the value before GST.
Step 2 — GST rate lookup: Column G holds the GST rate as a percentage (5, 18, or 40). The template uses a dropdown list so you cannot accidentally type an invalid rate.
Step 3 — Intra-state vs inter-state split: This is where most templates fail. The template uses a cell at the top called "Supply Type" — you select either "Intra-State" or "Inter-State" from a dropdown. A hidden helper cell converts this to 1 (intra) or 0 (inter).
For intra-state sales (same state as buyer), GST splits equally into CGST and SGST. The CGST column (H) is worked out for you. The SGST column (I) mirrors this formula. The IGST column (J) is: the template's formula.
Step 4 — Row total: Column K totals each line: =F+H+I+J
Step 5 — Invoice totals: At the bottom, CGST total is =SUM(H:H), SGST total is =SUM(I:I), IGST total is =SUM(J:J), and grand total is =SUM(K:K).
Rounding: Indian GST invoices round tax amounts to the nearest rupee for each tax head separately — not the combined total. Use =ROUND(F*G%/2, 2) for CGST and SGST to round to 2 decimal places. This matches how GSTR-1 calculates values.
HSN Code Column — Why It Matters and How to Use It
HSN (Harmonised System of Nomenclature) codes are mandatory on all GST invoices above certain turnover thresholds. The rules as of 2026:
Turnover below Rs 5 crore: 4-digit HSN code required on B2B invoices. B2C invoices are exempt from HSN requirement.
Turnover Rs 5 crore to Rs 50 crore: 6-digit HSN code required on all invoices (B2B and B2C both).
Turnover above Rs 50 crore: 8-digit HSN code required on all invoices.
For services, the equivalent is SAC (Services Accounting Code). SAC codes are 6 digits and start with 99. Example: SAC 998314 is for management consulting services.
In the Excel template, column C is dedicated to HSN/SAC codes. We recommend maintaining a separate product list sheet in the same workbook with HSN codes pre-filled for each product — then use a VLOOKUP in column C to pull the HSN code automatically when you enter the product name.
The template does that lookup for you, where B5 is the item description and the Products sheet has items in column A and HSN codes in column B.
Penalty for wrong HSN codes
Wrong or missing HSN codes attract a penalty of Rs 50 per invoice under Section 125 of the CGST Act, up to a maximum of Rs 25,000 per year. If you are not sure of the HSN code for a product, use the GST calculator which includes HSN code lookup.
Print Layout — Getting the A4 Format Right
A GST invoice that looks good on screen but prints badly is a problem. Here is how to set up the print layout correctly in Excel for an A4 GST invoice:
Page setup: Go to Page Layout > Size and select A4 (21 cm x 29.7 cm). Set all margins to 1.5 cm. This gives enough margin for binding and looks professional.
Print area: Select the exact cells that form your invoice and go to Page Layout > Print Area > Set Print Area. This ensures only the invoice prints, not your formula helper cells or product list.
Scaling: If the invoice does not fit on one page, use Page Layout > Scale to Fit and set Width to 1 page. Height can be automatic.
Headers and footers: Insert your company logo in the print area itself (not in the header/footer section) for better control. Add page numbers via Insert > Header and Footer if you expect multi-page invoices.
Gridlines: Under the Sheet tab in Page Setup, uncheck "Print gridlines" for a cleaner invoice. Draw borders manually on your invoice cells instead.
Borders: Select your invoice table and apply borders via Format > Cells > Border. Use a heavier border for the outer boundary and thinner lines between rows.
The template we provide comes with all these settings pre-configured. Open it, enter your company details in the designated cells, and it is print-ready immediately.
When Excel Is Not Enough — What myBillPlease Does Better
Why We Built a Better Alternative to Excel
We built myBillPlease because we watched small business owners lose hours every month to Excel invoice management — tracking invoice numbers in a separate sheet, manually splitting CGST and SGST, re-entering data in the GST portal, chasing customers for payments with no visibility into which invoices were paid.
The Excel template we offer is genuinely useful for businesses that invoice fewer than 10 times per month. But if you are beyond that, the myBillPlease invoice generator takes 60 seconds to create a fully compliant GST invoice, handles CGST/SGST/IGST automatically based on place of supply, and stores every invoice for your GSTR-1 filing.
We have a free plan with no invoice limit for the first 30 days. No credit card required. Try it here.
Frequently asked questions
- Can I use an Excel template to create a valid GST tax invoice?
- Yes, an Excel-based GST invoice is legally valid as long as it includes all 16 mandatory fields under Rule 46 of the CGST Rules — supplier GSTIN, invoice number, date, HSN codes, taxable value, CGST/SGST or IGST amounts, and total value. The format does not matter; the content does. However, Excel templates require manual maintenance and are prone to formula errors. For B2B invoices above Rs 5 crore turnover, e-invoicing via IRP is mandatory regardless of your tool.
- What is the formula for CGST and SGST in Excel?
- For intra-state supply, CGST = Taxable Value x (GST Rate / 2) / 100. In Excel: =F5*G5/2/100 where F5 is the taxable value and G5 is the GST rate percentage. SGST uses the same formula. CGST and SGST are always equal — both are half of the total GST. For inter-state supply, use IGST = Taxable Value x GST Rate / 100. Never apply both IGST and CGST/SGST on the same invoice line — it is one or the other depending on whether the supply is intra-state or inter-state.
- What GST rates should I use in the Excel template in 2026?
- After the GST 2.0 reform effective September 22, 2025, India has four slabs: 0%, 5%, 18%, and 40%. The old 12% and 28% slabs are abolished. Most goods and services fall under 5% or 18%. The 40% rate applies only to luxury goods, tobacco, and aerated beverages. Update your Excel template's GST rate dropdown to include only these four values and remove 12% and 28%. If you previously had products at 12%, they now fall at either 5% or 18% depending on the category.
- Is HSN code mandatory on every GST invoice in Excel?
- HSN codes are mandatory on B2B invoices for all registered taxpayers. For B2C invoices, the requirement depends on turnover — businesses below Rs 5 crore are exempt from showing HSN on B2C invoices, but must include 4-digit HSN on B2B invoices. Businesses above Rs 5 crore need 6-digit HSN on all invoices. Businesses above Rs 50 crore need 8-digit HSN. Service providers use SAC codes instead of HSN codes. The penalty for missing or wrong HSN codes is Rs 50 per invoice under Section 125 of the CGST Act.
- How do I handle multiple GST rates in one invoice in Excel?
- When an invoice has items with different GST rates — say, one item at 5% and another at 18% — each line item must show its own GST calculation. The total invoice then shows a consolidated CGST, SGST, and IGST section at the bottom. In Excel, use a SUM formula grouped by GST rate: CGST for 5% items = SUMIF(G:G, 5, H:H), and CGST for 18% items = SUMIF(G:G, 18, H:H). Show these as separate lines in the tax summary. This matches how GSTR-1 expects the data — tax broken down by rate.
- Can I create a GST invoice in Excel without a registered GSTIN?
- If you are not GST-registered, you cannot issue a GST tax invoice — you must issue a regular invoice or bill of supply without showing GST separately. GST registration is mandatory only if your annual turnover exceeds Rs 40 lakh for goods (Rs 20 lakh for services, Rs 10 lakh for special category states). Below these thresholds, you can use a simple invoice without any CGST or SGST fields. Once you cross the threshold and register, switch to a GST-compliant format with all 16 mandatory fields.
