How to Make a GST Invoice in Excel

Open a new workbook and name the first sheet Invoice; reserve a second sheet called Template that you never edit. Every new bill is a copy of Template, which protects the layout and formulas from accidental drift.

Freeze the top rows so the company block stays visible while you scroll a long item list, and set the column widths once — description, HSN, qty, rate, taxable value, GST percent and line tax.

Each row holds quantity and unit rate in their own cells, and the taxable value cell runs =C5*D5 (qty × rate). Let the sheet compute, never type the number.

Priya's sheet carries 25 units of stationery at ₹320: the taxable value cell returns ₹8,000, and the tax rows on top of it produce CGST ₹200, SGST ₹200 and a total of ₹8,400 at the 5% slab.

Key the slab rate in one cell — say 5% — and build every tax formula on that cell, so switching a rate never means editing formulas. The subtotal row sums the taxable column, and the grand total row closes the document.

Round the final tax cells with ROUND(...,2), not display formatting. Display rounding leaves the stored decimal intact, and the total then differs from GSTR-1 by paise that break the match.

When one bill mixes a 5% item and an 18% service, per-line tax columns are the answer: add GST percent, CGST, SGST and IGST columns to the item table, and let the totals row sum each column.

The same stationery order plus a ₹4,000 design fee at 18% yields line tax of ₹400 and ₹720, a GST total of ₹1,120 and a grand total of ₹13,120 — every slab visible for filing.

The GSTIN belongs in the header next to the business name, because it is a mandatory field and the buyer's system validates it against the GST database. For registered B2B customers add a Bill To block with their GSTIN; for B2C sales leave it blank.

A place-of-supply field on the invoice helps the buyer classify an inter-state transaction, and a payment-format line with bank and UPI details removes the last excuse for delay.

GST law requires sequential unique numbers within the financial year. Give the workbook a Numbers sheet used as a log, with a running cell that each new invoice reads and advances by one.

Format the running number with a year prefix — INV-2026- — and paste the value into the invoice as text, so a later edit can never silently reuse a number.

Select the invoice range, set it as the print area, and switch page setup to A4 portrait, narrow margins and Fit to 1 page wide. Set Print Titles so the header row repeats if the item list spills onto a second page.

Row heights change after edits, so open the print preview before a batch send — a column leaking past the page edge looks careless on a formal tax document.

Save each invoice as a PDF with the number in the filename — INV-2026-0042.pdf — so the folder is the archive index. PDF export locks fonts and layout, unlike mailing the .xlsx and letting the client edit totals.

Email the PDF and drop a copy into the month's folder; GST records must survive at least 8 years, and named PDFs make retrieval automatic.

Hand-typed totals that ignore rounding, tax cells without formulas, merged cells hiding a value, and numbers typed instead of pulled from the log are the errors that break GST filing.

An HSN typed into an unvalidated cell quietly fails the buyer's system check, so put data validation dropdowns on the HSN and GST percent columns, and protect the log sheet from edits.

Excel is dependable, but each invoice still means copying the file, updating the number and checking the print area. The Crafex invoice generator does the identical job — items, GST splits, totals, PDF — in under a minute, entirely in the browser.

When fifteen invoices are needed before lunch, the generator is the practical choice; where the worksheet is the office habit, the formulas above keep it GST-accurate.