Searching for sales invoice format in excel usually means one of two things: you need to raise a bill today, or the file you have been using has started to go wrong. Both are below — the correct content first, then an honest look at when a file stops being enough.
A format is a layout. An invoice is a record.
A template gets the first bill out of the door, and for a business issuing two or three a month that is a perfectly reasonable answer. Nobody needs software to send three invoices.
What a file cannot do is remember. It will not stop you reusing a number, it will not notice that a customer was billed twice, and it will not tell you in April what was still unpaid in February. Every one of those is a matter of record-keeping rather than of layout.
So the useful way to read this page is: get the content right first, because that is a legal question, and only then decide whether a file or a system should hold it.
The sales invoice is the one the return is built from
Every outward supply you make becomes a line in GSTR-1, and GSTR-1 is assembled from your sales invoices. So the quality of the invoice decides how much work the return is.
Three fields do most of that work. Place of supply, because it decides IGST against CGST/SGST and a wrong one puts the supply in the wrong state. The customer's GSTIN, because B2B supplies are reported invoice by invoice while B2C is reported in summary, and a missing GSTIN silently moves a supply from one to the other. HSN per line, because the summary table is built from it.
The numbering has to be consecutive and unique within the financial year, with no gaps you cannot explain. A cancelled invoice stays in the series as a cancelled invoice; it does not get its number reused.
Getting those right at the point of billing is the difference between a return that exports in a minute and a fortnight of reconciliation in the following month.
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.
Moving a year of billing off a spreadsheet
- Decide a cut-off date — the start of a month or a quarter is easiest to reconcile against.
- Tidy the spreadsheet first: one row per invoice, no merged cells, GSTINs in their own column.
- Import your customer list, then your item list. Fix what the import reports rather than what you think it got wrong.
- Enter the outstanding invoices only — the unpaid ones. Settled history can stay in the file; you need the balances, not the archive.
- Set the next invoice number to carry on from the last one you issued, so the series stays consecutive across the move.
- Issue everything from the cut-off date onwards in the new system, and keep the old file read-only as an archive.
- Reconcile one month both ways before you stop maintaining the file.
The numbering rule, which is where templates fail first
The invoice number has to be a consecutive serial, unique within the financial year, not more than sixteen characters, and made only of letters, numbers, hyphens and slashes. One series, or clearly separated series if you genuinely need more than one — but each consecutive in itself.
A file cannot enforce any of that. The number is typed, which means it can be repeated, skipped or quietly rolled back when yesterday's invoice is edited into today's. A duplicate is not found at billing time; it is found at return time, in the month after the one it happened in.
The other half of the rule is that a cancelled invoice keeps its number. Deleting the row and reusing the number leaves a gap in your books and a figure in your customer's, and reconciling that is a long afternoon.
This is the single most practical argument for a system over a file, and it has nothing to do with features.
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.
CGST, SGST and IGST — worked out, not chosen
Whether a sale attracts CGST and SGST or IGST is not a preference. It follows from the place of supply: same state as your registration means the tax splits into central and state halves, a different state means one integrated tax at the combined rate.
That sounds simple and goes wrong constantly, because it is a dropdown in most billing software and a dropdown is something a tired person clicks past. In Billixo the split is derived from the state on the customer record against the state on your registration, and it changes the moment either does.
The consequence of getting it wrong is real: an IGST invoice raised as CGST/SGST has to be credited and reissued, and if the return has already gone in, amended.
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.
Bill scanning, in practice
The single largest time cost in most small businesses is not raising invoices — it is entering purchases. A photograph of a supplier bill goes in and a structured draft comes out: supplier, GSTIN, line items, rates, tax split and total.
You check it. That is the workflow, and it is deliberate: an extraction you did not read is a liability, not a saving. But checking a filled form takes fifteen seconds and typing one takes three minutes, and that difference compounds over a month of purchases.
A note for accountants and CAs
If you are the person who has to make sense of a client’s billing at the end of the month, what you need from their software is narrow and specific: a complete outward supply summary, correct place-of-supply treatment, HSN present on every line, and an export you can open without repair.
Billixo produces GSTR-1 and GSTR-3B summaries and exports to CSV, Excel and JSON. Client-side, the invoice fields cannot be skipped, which removes the category of problem where the data was never captured in the first place.
The price, plainly
Free is ₹0 and stays ₹0. The paid plans are bought for a fixed term, paid once, with no auto-renewal and no card kept on file — when a term ends the account drops back to Free until you decide to buy again.
There is no per-invoice charge, no per-user surprise on the free plan, and no feature that is technically included but practically throttled. What the plan says you get is what you get.
Compare the plans on the home page, or just start free now and look at the ceiling from the inside.
Reliability, backups and getting your data out
Cloud billing software is only as good as its worst day. Two things matter more than any feature list: that your data is backed up somewhere you can reach, and that you can export it in a format something else can read.
Exports here are CSV, Excel and JSON, on every plan including the free one, covering customers, products, invoices and payments. That is the honest test of whether software respects you — not what it promises, but what it lets you take when you leave.
Frequently asked questions
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.
Can I get my data back out?
Yes, on every plan including the free one — CSV, Excel and JSON. Records you cannot export are not records you own, so this is not a paid feature.
Is a template invoice legally valid?
A document is valid if it carries the content the law requires, whatever produced it — a printed book, a spreadsheet or a system. The format is not the issue; the missing fields are. Most free templates are short of place of supply, an HSN or SAC per line, or the tax heads shown separately, and any one of those makes the document deficient.
Will my accountant be able to work with it?
That is what the GSTR-1 and GSTR-3B summaries are for. They export in formats a practitioner can open and reconcile without repairing the file first — which, in practice, is most of what a CA wants from a client’s billing software.
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.
See it working on your own bills
The fastest way to judge billing software is to bill with it. Photograph one supplier invoice, raise one sales invoice, and look at the PDF your customer would receive.
Open the software demo → — free account, no card, about a minute to set up.
More details on the home page → — what it does, what it costs, and where the limits are.
Related pages