Searching for transport bill 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.
Why the file is usually the thing that breaks
The failure is nearly always the same, and it is never the layout. Two people work from two copies of the file, the numbering collides, and a month cannot be reconciled. Or a formula in one row gets flattened by a typed-in figure and nobody notices for six weeks.
A spreadsheet is excellent at arithmetic and poor at being a system of record, because nothing in it is authoritative. Any cell can be any value, and the file has no opinion about which version of itself is the real one.
That is the actual argument for a billing system, and it has nothing to do with how the invoice looks.
Transport, taxi and freight bills
Goods transport is the one area of billing where the tax may not be yours to charge at all. A goods transport agency's services frequently fall under reverse charge, which means the recipient pays the tax and the transporter's invoice says so explicitly rather than showing a tax amount.
So the declaration is the most important thing on the document: whether tax is payable by the supplier or by the recipient under reverse charge, and under which option. Getting that line wrong means either you have charged tax you should not have, or nobody has paid it.
The rest is consignment detail — consignor and consignee with their GSTINs, the goods and their weight, origin and destination, the vehicle, the consignment note number and date, and the freight with any detention or loading charges itemised. An e-way bill may be required for the movement and is a separate document from the invoice, not a replacement for it.
Passenger transport is different again: a taxi or tour bill is a service invoice with a SAC, and the treatment depends on how the service is supplied and through whom. Check your own position rather than copying a goods-transport template.
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.
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.
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.
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.
Credit notes, debit notes, and fixing a wrong invoice
An issued tax invoice is not something to edit. If the value was too high, or goods came back, the correction is a credit note that references the original invoice. If it was too low, a debit note. Both carry their own numbers and both appear in your return.
There is a deadline on the credit note that matters: the adjustment has to be declared by the return for the relevant month of the following financial year, or by the annual return, whichever comes first. Past that, the note exists commercially but the tax cannot be adjusted.
Software that lets you quietly retype an invoice raised last month is not doing you a favour.
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.
What "free" means here, exactly
The Free plan costs nothing, needs no card, and has no expiry date. It is not a trial that turns into a bill; it is a plan you can run a small business on indefinitely.
What it gives you:
- Real GST invoices with the full Rule 46 field set
- Customers and products, with HSN/SAC held against each
- A daily and monthly invoice allowance, generous enough for a small operation
- One login
- Export of your own data, whenever you want it
What it does not give you:
- A watermark-free PDF
- GSTR-1 and GSTR-3B export
- The AI features — bill scanning, HSN lookup, the assistant
- Extra team logins, bulk import, recurring invoices and reminders
Every new account also gets the full paid feature set for its first 14 days, so you can see what the ceiling looks like before deciding whether you need it. When that ends nothing is charged and nothing is deleted — the account simply settles onto Free.
Start free now — it takes an email address and about a minute.
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
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.
Can I keep using Excel for my invoices?
Yes, and plenty of small businesses reasonably do. The point at which it stops working is specific rather than vague: a second person starts billing, the volume passes roughly twenty a month, or you need to answer "what is outstanding" and file a return from it. Until then a carefully built spreadsheet is a legitimate tool.
What is the difference between a tax invoice and a bill of supply?
A tax invoice is issued on a taxable supply and shows the tax separately so the buyer can claim input credit. A bill of supply is issued where no tax is being charged — an exempt supply, or a composition dealer — and must not show a tax amount at all. Issuing the wrong one is a compliance error, not a presentation choice.
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.
Can more than one person use it?
On the paid plans, yes — team logins with their own credentials. The Free plan is a single login, which suits a one-person operation and is usually the first limit a growing business hits.
Try it — the demo is the product
There is no sales call and no scheduled demo, because a recorded walkthrough of somebody else’s data tells you nothing about your own. Open an account instead and raise a real invoice for a real customer; it takes about a minute and costs nothing.
Open the software demo → — sign in, or create a free account from the same screen.
See full details on the home page → — features, the AI, pricing and the answers to the usual questions.
Related pages