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.
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.
As per Rule 46 of the CGST Rules, 2017 — every field is required for a valid tax invoice
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 formula in the CGST column (H) is: =IF($B$3="Intra-State", F*G%/2, 0). The SGST column (I) mirrors this formula. The IGST column (J) is: =IF($B$3="Inter-State", F*G%, 0).
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 (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 formula would be: =IFERROR(VLOOKUP(B5, Products!$A:$B, 2, 0), "") — where B5 is the item description and the Products sheet has items in column A and HSN codes in column B.
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.
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.
At some point, every growing business outgrows Excel invoicing
Excel formulas break when you copy rows, insert columns, or accidentally overwrite a cell. myBillPlease calculates GST server-side — there is nothing to break. Every invoice is mathematically correct.
Managing sequential invoice numbers in Excel is manual and error-prone. myBillPlease auto-increments invoice numbers, never skips a number, and flags if a number is missing — critical for GST filing.
Excel invoices require manual data entry into the GST portal. myBillPlease exports GSTR-1 JSON files that you upload directly — no re-entry, no errors, no missed invoices.
Instead of typing customer GSTIN and address every time, myBillPlease stores them. Type 3 letters of the customer name and all details auto-fill. Saves 2-3 minutes per invoice.
Excel invoices need to be exported to PDF and manually sent. myBillPlease sends invoices directly via WhatsApp and email from the invoice screen — one click, done.
Excel on mobile is painful. myBillPlease works on any phone browser — create invoices at a customer's site, in the warehouse, or anywhere. No laptop required.
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.
myBillPlease auto-calculates CGST, SGST, and IGST based on place of supply. No formulas, no errors, GSTR-1 ready export. Free to start.
Try Free Invoice Generator