The layout is the easy part of gst bill format in excel. What makes a document a valid tax invoice is its content and its numbering, and that is where almost every free template falls down. This page covers both, and then offers you a way to stop maintaining the file at all.
What has to be on the document
This is the part a design-led template usually misses, because it was built to look like an invoice rather than to be one.
A tax invoice has to carry your name, address and GSTIN; a serial number unique within the financial year; the date of issue; the customer's name, address and GSTIN where they are registered; the place of supply on an inter-state supply; the HSN or SAC against each line; the description, quantity, unit, rate and taxable value; CGST, SGST/UTGST, IGST and cess shown separately rather than rolled into one tax figure; whether reverse charge applies; and a signature or digital signature.
A document with a total and a single "tax" box looks like an invoice and is not one. That is worse than something obviously informal, because nobody checks it until the return does not reconcile.
Rates, turnover limits and e-invoicing thresholds all move. Nothing on this page states a current figure for that reason — check the notification in force for your own turnover before you rely on one.
Tax invoice, bill of supply, or neither
These are three different documents and using the wrong one is a compliance error rather than a formatting preference.
A tax invoice is what a registered supplier issues on a taxable supply, and it shows the tax separately so the buyer can claim input credit. A bill of supply is what you issue when no tax is being charged — an exempt supply, or a supplier under the composition scheme — and it must not show a tax amount at all. A receipt or an informal "bill" is neither, and gives the buyer nothing to claim.
If you are registered and charging tax, the document is a tax invoice and it needs the full field set. If you are under composition, a tax invoice is the wrong document and showing tax on it is the specific thing you must not do.
The time limit for issuing matters too and differs between goods and services; check the rule that applies to your supply rather than assuming the invoice can follow the payment.
Doing this in Excel: what works and what will bite
Excel is genuinely good at this up to a point. The arithmetic is reliable, the layout is yours, and everyone already has it. If that is where you are starting, a few habits make the difference between a spreadsheet that lasts a year and one that goes wrong in a month.
Keep the data and the document apart: one sheet of invoice rows that you never format, one sheet that renders a chosen invoice for printing. Hold customers and items on their own sheets and pull them in by lookup rather than retyping, because a customer whose GSTIN is typed forty times is a customer whose GSTIN is wrong somewhere. Lock every formula cell and leave only the inputs open. Never let two people hold two copies.
What Excel cannot do, however carefully it is built, is guarantee a number. There is no mechanism that stops a cell being overtyped, no record of who changed what, and nothing that enforces the next number in the series. That is not a formula problem; a spreadsheet simply has no authoritative state.
So the honest reading is: build it properly, use it while it suits you, and treat the day two people need it at once as the day to move.
What you get here instead of a file
- Every mandatory field present, because the document is built from records rather than typed into a layout.
- One numbering series, issued centrally, consecutive, restarting each financial year — so a number cannot be used twice.
- Customers stored once with GSTIN, address and state, so the details are right on the fortieth invoice too.
- Items stored once with HSN or SAC, rate and tax.
- The tax derived, not chosen — CGST and SGST or IGST, from the place of supply against your registration state.
- A clean PDF to print, email or send on WhatsApp.
- An answer to "what is unpaid", which no template has ever been able to give.
- Your data exportable to CSV, Excel and JSON at any time, on every plan including the free one.
- Free — ₹0, no card, no expiry.
From a template to a proper invoice in about five minutes
- Start free now — an email address and a password, no card.
- Enter your business name, address and GSTIN once. These are the fields you have been retyping.
- Add a customer with their GSTIN and state, or import your whole list from the spreadsheet you already have.
- Add the items you sell with their HSN or SAC codes and rates.
- Set the invoice number your series should carry on from, so there is no gap and no restart.
- Raise the invoice. The number, the tax split and the totals are already filled in.
- Download the PDF, or send it straight to the customer.
What goes wrong between the file and the return
The return is where billing errors become visible, and they arrive in a predictable order.
Place of supply recorded wrong, so a supply is reported in the wrong state and the tax head is wrong. A missing customer GSTIN, which silently moves a B2B supply into the B2C summary where it cannot be claimed. HSN codes left blank on some lines, so the summary table cannot be built. A combined tax figure that has to be unpicked line by line. And duplicated or missing invoice numbers, which is the one that takes longest to resolve.
None of these is hard to avoid at the moment of billing. All of them are expensive to fix a month later, because by then the customer has their copy and may have filed against it.
That asymmetry — cheap to prevent, costly to correct — is the real case for capturing an invoice properly the first time.
Keeping the document for as long as you have to
Invoices and the records behind them have to be retained for a prescribed period, counted from the due date of the annual return for the relevant year rather than from the invoice date — so the obligation runs well past the point most people have stopped thinking about it. Check the period currently in force for your own case.
That has a practical consequence for how you store them. A laptop, a phone and a folder of PDFs are not a retention plan: the horizon is years, and it outlasts most hardware and most staff.
Where the records are kept electronically, they have to remain accessible and readable for the whole period — which means a format you can still open and a copy somewhere other than the machine that made it.
This is dull and it is also the thing that is actually asked for when it is asked for. Records held in one place, exportable in full, cost nothing to keep and a great deal to reconstruct.
HSN and SAC codes, and how many digits you need
Every line on a tax invoice needs an HSN code for goods or a SAC for services. How many digits depends on your aggregate turnover in the preceding financial year — smaller businesses report fewer digits than larger ones, and B2B and B2C invoices are treated differently.
Because the requirement is tied to turnover and has been tightened in stages, the practical answer is to store the fullest code you can against each product once, and let the software report at the level required. A six-digit code can always be truncated; a two-digit one cannot be expanded.
Billixo keeps the code on the product record and carries it onto every line automatically, and its AI HSN lookup will suggest one from a plain description when you genuinely do not know.
Invoice numbering: one unbroken series per year
The invoice number has to be consecutive, unique within the financial year, and no more than sixteen characters of letters, numbers, slashes and hyphens. Gaps invite questions. Duplicates cause them.
This is the single most common reason a spreadsheet-based billing setup fails an audit: two people billing on two machines, both starting from the last number they remember. A system that issues the number centrally cannot make that mistake.
The series restarts on 1 April, and Billixo restarts it for you rather than waiting to be told.
The AI, and what it is actually for
The useful application of AI to billing is not a chatbot. It is the twenty minutes a day spent retyping things that already exist on paper.
- Scan a supplier bill. Photograph it; the lines, the GSTIN, the tax and the totals come back as a draft you check rather than a form you fill.
- Find the HSN code. Describe the product in plain words and get a code to confirm, instead of scrolling a list of eleven thousand.
- Ask about your own numbers. "What is outstanding over sixty days?" answered from your data, not a manual.
- Write the reminder. A polite, specific chase for an overdue invoice, ready to send on WhatsApp.
Nothing is sent anywhere until you ask for it, and the platform runs on whichever model it has been configured with — including one hosted on your own server.
Where this fits in a working day
Morning: yesterday’s supplier bills get photographed and become purchase records. Through the day: invoices go out as goods do, shared on WhatsApp before the customer has left. End of the week: the receivables list says who to call. End of the month: the GST summary is a download, not a project.
None of that requires a new habit, which is the point. A billing system that needs discipline to work is one that stops working the first busy week.
Free, and what it costs you instead
Free software usually costs you something that is not money: your data held hostage, an export that does not work, ads inside your invoice, or a "free" tier so narrow it is a demo with a login screen.
The line here is drawn differently. Export works on the free plan — CSV, Excel and JSON — because data you cannot get out is not data you own. The invoice is a real compliant invoice, not a sample. The limits are on volume and on the conveniences, not on whether the thing works.
Start free now. If it does not suit you, take your data with you.
Where your data lives
On the server this platform is installed on. Every record carries a company identifier and every query is scoped to the signed-in account at the framework level, so one business cannot read another’s data by any route, including a crafted one.
Sign-in is rate limited, sessions can be restricted to one device per user, and passwords are stored hashed. Exports are available on every plan, free included: if you ever want to leave, your data leaves with you.
Frequently asked questions
Is the invoice free here?
Yes. The Free plan is ₹0, needs no card and does not expire. It produces a complete tax invoice with every legally required field, with limits on volume and a small watermark on the PDF. Plenty of one-person businesses run on it indefinitely.
Can I put my own logo and design on it?
On the paid plans, yes — logo, business details, terms and a signature block. The free plan produces the same compliant document with a small watermark on the PDF.
Will my existing invoice numbers carry on?
Yes. You set the number the series should continue from when you start, so there is no gap and no restart in the middle of a financial year. That is usually the first thing to get right when moving off a file.
What happens to my data if I stop paying?
Nothing is deleted. The account settles back onto the Free plan: the paid conveniences switch off, the volume limits return, and every invoice, customer and product you created stays exactly where it is — including the export.
Does it work on a phone?
Yes. It is a browser application that adapts to the screen, so the same account works from a desktop at the counter and a phone in the market. There is no separate app to keep in step.
Start free, decide later
You do not have to choose a plan to begin. Start on Free, use it for as long as it suits you, and upgrade only when a limit actually gets in your way — never automatically, and never because a countdown ran out.
Open the software demo → — or create the free account from the same page.
Read the full details → on the home page, including pricing and the AI features.
Related pages