Searching for export 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.
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.
Export and commercial invoices carry more than a domestic bill
An export invoice is still a tax invoice, with the ordinary field set, plus the content the shipment and the bank need. The endorsement about whether the supply is made on payment of integrated tax or under a letter of undertaking belongs on it, and the wording matters because it decides how the refund is claimed.
On top of that it generally carries the currency and the conversion basis, the port of loading and destination, the terms of delivery, the buyer and consignee where those differ, and the shipping bill details once known. The commercial invoice customs and the buyer's bank work from is usually this same document.
The place of supply on an export is outside India, so the domestic CGST/SGST versus IGST question does not arise in the usual way — but the invoice still has to say so rather than leaving it blank.
Because the details are tied to a shipment rather than to a customer record, exporters tend to keep the most elaborate templates and get the most value from a system that stores the recurring parts.
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.
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.
Reverse charge, exports and the supplies that behave differently
Not every supply is a straightforward taxable sale. Some notified supplies put the tax liability on the recipient rather than the supplier. Exports and supplies to an SEZ can be made under a bond or LUT without payment of tax, or with tax and a refund claimed afterwards. Composition dealers cannot charge tax at all and must say so on the bill.
Each of these changes what the invoice has to say — the reverse charge marking, the LUT reference, the "composition taxable person" declaration. They are not exotic cases; most businesses hit at least one.
The fields are on the invoice in Billixo whether or not you use them, so the day you need one you are not looking for a workaround.
What a GST invoice legally has to carry
Rule 46 of the CGST Rules sets out what a tax invoice must show, and it is a longer list than most invoice templates carry. Getting one field wrong does not usually cost you anything the day you raise it — it costs your customer their input credit months later, which is a harder conversation.
The fields are:
- Your name, address and GSTIN
- A consecutive invoice number, unique within the financial year
- The date of issue
- The customer's name, address and GSTIN where they are registered
- Place of supply, and the state code, for inter-state supplies
- HSN or SAC against every line
- Description, quantity, unit, rate and taxable value per line
- Rate and amount of CGST, SGST/UTGST, IGST and cess, shown separately
- Whether tax is payable on reverse charge
- Signature or digital signature of the supplier or an authorised person
Billixo fills these in from the customer and product records rather than asking you to remember them, which is the only reliable way a busy counter gets them all right every time.
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.
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.
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
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.
Do I need an HSN code on every line?
Every line needs its HSN for goods or SAC for services. How many digits you must show has depended on turnover and has been tightened over time, so check the requirement currently applying to you — but "none" has not been an option for a registered supplier for a long time.
Can I change an invoice after I have issued it?
No. Once it has gone to the customer you issue a credit note or a debit note referencing the original invoice. Editing the original leaves two different versions of one invoice number in two different sets of books, and the mismatch surfaces at reconciliation.
Is it really free?
Yes. The Free plan is ₹0, needs no card and has no expiry. It has volume limits and leaves out the paid conveniences — watermark-free PDFs, GST return exports, the AI features, extra logins — but the invoices it produces are real GST invoices, and you can export your data from it whenever you like.
Do I need to install anything?
No. It runs in a browser, on a laptop, desktop or phone, so there is nothing to install, nothing to update and nothing tied to one machine. If the office computer dies, you sign in from another one and everything is there.
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