How to Make a GST Invoice in Excel
An Excel invoice is the classic home for freelancers and small shops — familiar, free and quick to adapt. But a GST invoice demands arithmetic that Excel can do only if the formulas are set up correctly: taxable value, CGST, SGST, discounts and rounding.
This guide shows the Excel invoice structure that produces correct GST totals every time, the formulas that power it, and the formatting that makes it look professional. If you would rather skip formula maintenance, the Crafex invoice generator at the end does the arithmetic for you.
A working Excel invoice should be a single file you duplicate per customer — keeping a template and a filled example separate prevents formula drift.
Excel invoice layout that works
Start from a one-page layout: company header with GSTIN, invoice number and date, bill-to block, itemised table, tax computation block and payment terms. Keep a Template sheet and copy it for each invoice so proportions and formulas never shift.
- Header — logo, business name, GSTIN, address, phone, invoice number and date.
- Bill to — customer name, address and GSTIN.
- Items table — description, HSN, qty, unit price, taxable value.
- Tax block — CGST %, SGST %, IGST %, and the total.
- Footer — terms, bank details, thank-you note.
GST formulas for Excel invoices
Compute the taxable value as quantity × unit price, then apply the GST split. For a single GST rate you can use one table; for mixed-rate invoices, each line needs its own tax row.
- Taxable value = qty * unit_price (with a total row)
- CGST = ROUND(total_taxable / 2 * rate, 2)
- SGST = CGST (intra-state)
- IGST = ROUND(total_taxable * rate, 2) (inter-state)
- Grand total = ROUND(taxable + CGST + SGST + IGST, 2)
CRITICAL: rounding in the tax block
GST rounding to paise on each line, then totalling the rounded values, is the pattern GST return entries expect. If your total sums pre-rounded components, your invoice may differ from GSTR-1 by a paisa and fail matching with the buyer's 2B.
Use ROUND on the final CGST and SGST cells, not just on the display format.
Invoice numbering in the Excel template
Keep a RunningNo cell with a prefix like INV-2026-0001 and increment it manually — or better, generate it from the row count of an invoice log sheet so numbers stay sequential.
GST law requires sequential unique numbers, so a log sheet referencing the last number protects you from duplicates.
From Excel to PDF invoice
Set the print area to the invoice region and save each sheet as PDF for emailing and GST record-keeping. Alternatively, the Crafex invoice generator produces the same professional result instantly with GST arithmetic built in.
When to issue a credit note alongside an invoice
When a sale is returned, the price is corrected, or the supply is cancelled, a credit note reverses the original invoice's tax effect. Issue it with the same numbering discipline, referencing the original invoice number.
Keeping credit notes paired with their invoices keeps your GST returns self-explanatory and your ageing report accurate. Unmatched credit notes are the most common reason a return shows a discrepancy at reconciliation.
Enter the credit note in the same month as the event it reverses, never earlier and never into a fresh financial year, or the input credit trail breaks.
Designing a branded invoice that still complies
A branded invoice — your logo, accent colour and layout — is a sales asset, as long as compliance fields stay above the fold. Put GSTIN, number and date in the header zone and keep the tax block bottom-aligned so nothing drifts onto a second page.
Test every new design by printing to PDF and reading it as a buyer would. If a field is hidden behind a fold, it will be missed. A second page for the terms block is fine; a second page that splits the grand total is not.
Keep the mirror copy clean even when the customer copy carries the watermark — both go to the same filing system and the same tax officer.
The first invoice for a new business
The first invoice a new business issues sets the template for everything that follows. Set up the numbering series, the terms block and the tax computation once, and copy the pattern every time.
Invest the first hour in the format, and the business looks established from invoice one — buyers notice the difference. Choose the numbering scheme before the first sale: the simple yyyy-001 series or an alphanumeric scheme keyed to sales tiers.
Agree advance and due-date terms with your first three customers and print them on the invoices. Every term agreed at the start is a payment that arrives on time later.
E-invoicing zones where your invoice must go through the portal
If your turnover crosses the e-invoicing threshold, every B2B invoice must report to the GST portal's IRN registry before issue. The invoice carries the QR code and the IRN; without it, the buyer cannot claim the input credit and the supply is treated as not reported.
Confirm your threshold status each April — the limits change by notification and a business unwatchful of them discovers it at the first audit. Keep the e-invoice JSON with the invoice copy so reconciliations can match the portal records exactly.
When the IRN registry is down, the discipline is: generate the invoice on the portal-side timestamp once restored, and never issue a manual number that the portal cannot see.
Invoice numbering for export supplies
Export invoices follow a different lane: they carry the shipping term, the country of destination, and the LUT or bond number instead of the usual GST zone arithmetic. The tax block shows zero-rated status rather than a CGST–SGST split.
Number exports in a separate series so the books can tell the domestic and export flows apart at a glance. Keep the bill of lading number on the invoice and the invoice number on the bill of lading — the match is the export file's spine.
When the bank's export-realisation certificate arrives late, the invoice count stays the anchor for the GST export reporting; file it the month the goods ship, not the month the remittance lands.
Reconciling invoices with the GST summary
Monthly GST reconciliation is the ten-minute ritual that keeps an annual audit short: the sum of the month's invoices must equal the outward supply figure in the GSTR-1. Mismatches come from three places — cancelled invoices still included, credit notes not paired, and exempt lines mislabelled.
Rebuild the reconciliation from the invoice register rather than from the portal; the register is where corrections belong. Keep the cancellations in a separate list with the reason so the auditor sees a controlled system rather than a messy portal history.
When a buyer requests a re-issue with a new number, cancel the original on the portal the same day or the summary will carry a phantom line for months.
Payment terms that shorten your invoice cycle
The invoice does not get paid; the terms printed on it do. Standardise the term block — due on receipt, net 7, net 15 — and put the number where the buyer's accounts team sees it inside three seconds. A printed due date beats a negotiated date every month.
Offer the early-payment discount in the term block: 1% for payment within a week converts slow payers into your cheapest source of working capital. Chase against the printed terms, never against the memory of a call, and the ageing report stops being an opinion.
Automate the weekly chaser email by invoice number and due date; the credit list shrinks when every invoice carries a clock that visibly runs.
What makes an invoice legally valid in India
Under the GST law, a valid invoice must include the supplier's name, GSTIN and address, the invoice number and date, the recipient's name and GSTIN (if registered), an itemised description, HSN/SAC codes, taxable value, rate and amount of tax, and the total value.
An invoice without GSTIN details is not a valid tax invoice — it can be rejected as an input tax credit claim and attract penalties during audit. The Crafex generator builds every field automatically.
Digital invoice records and backup
The GST law requires invoices to be preserved for at least 8 years. Digital copies stored on your device or cloud are fully valid as long as they are legible and complete.
With Crafex, each invoice you generate is downloaded as a PDF — easy to archive, share with accountants, and retrieve during scrutiny.
Frequently asked questions
How do I calculate GST in an Excel invoice?+
Taxable value = qty × price. For intra-state supply, CGST = SGST = 9% of taxable for an 18% rate, rounded to 2 decimals. For inter-state, IGST = 18%. Round the final cells to keep totals GST-return accurate.
Can I make an invoice in Excel without formulas?+
You can, but hand arithmetic invites errors. If you do not want formula review each month, use a generator that computes GST for you.
How do I add multiple GST rates in one Excel invoice?+
Give each line its own tax rows: split the line's taxable value out, apply the rate, and total all CGST/SGST columns at the bottom.
Is an Excel invoice valid for GST filing?+
Yes — as long as it carries all mandatory fields (GSTIN, sequential number, HSN, tax split). It is the content, not the tool, that makes it GST-valid.
How do I make the invoice print on one page?+
Set the print area to the invoice range, choose A4 portrait with narrow margins, and enable 'Fit to 1 page wide'. Preview before saving as PDF.
Start creating with the free Invoice tool
Create professional GST invoices online in seconds.
Free Invoice GeneratorRelated search terms
Why you can trust this guide
Written by Crafex Finance Desk (GST & Billing Documentation Experts), last reviewed 2026-08-01. We update these guides when statutory rules and formats change. Where Indian regulations apply, we link the official sources below. Verify critical calculations against the current government notifications before relying on them.
A Crafex editorial guide for Indian professionals and businesses.