Everything worth knowing about gst invoice in excel: what the invoice legally has to carry, where most software gets the tax split wrong, and how to raise one for free without installing anything.
Why gst invoice in excel takes longer than it should
Count the steps in the way most small businesses bill today: open the template, copy the last invoice, change the number, change the party, retype the items, work out the tax, check the total, save as PDF, attach to WhatsApp, remember to note it in the sheet.
Ten steps, of which one is actual commercial thinking. The other nine are transcription — and transcription is where errors come from, not just delay.
A billing system earns its place by collapsing those nine into one: pick the customer, pick the items, send. Everything else is derived.
What Billixo does for gst invoice in excel
- Compliant invoices by default. Every Rule 46 field is on the invoice — GSTIN, HSN/SAC, place of supply, the tax split shown separately, a consecutive numbering series that restarts on 1 April.
- Tax worked out, not chosen. CGST/SGST or IGST follows from the place of supply against your registration state. There is no dropdown to get wrong.
- Customers and products remembered. GSTIN, state, HSN, rate and default tax sit on the record, so the second invoice to the same party is three clicks.
- A PDF a customer can read. Clean, printable, with your own logo and details on the paid plans.
- WhatsApp and email sharing. The way most Indian businesses actually deliver an invoice, built in rather than bolted on.
- Stock that moves as you bill. Inventory decrements on sale, with low-stock warnings before you run out mid-order.
- Payments and receivables. Record part payments, see what is overdue and by how long, and chase it with a written reminder rather than an awkward call.
- Recurring invoices. Anything billed on the same day every month goes out on its own.
- GSTR-1 and GSTR-3B summaries. The month closes as a download rather than a project.
- AI bill scanning. Photograph a supplier bill and it becomes a draft purchase record, lines and tax included.
- Proforma invoices and quotations. The document before the invoice, in the same series discipline.
- Bulk import and export. CSV and Excel in, CSV, Excel and JSON out — including on the free plan.
Raising a GST invoice, start to finish
- Pick the customer. Their GSTIN, state and place of supply come with them; a new one takes twenty seconds to add and is remembered afterwards.
- Add the lines. Products carry their own HSN, rate and tax, so a line is a name and a quantity.
- Look at the tax. CGST and SGST, or IGST, already split and totalled from the place of supply — check it rather than compute it.
- Save. The invoice number is issued from the series automatically, so there is no gap and no duplicate.
- Send it. WhatsApp, email, or download the PDF — usually before the customer has left the counter.
- Forget about it. It is in the GSTR-1 summary, in your receivables, and in the stock movement, without a second entry anywhere.
Paper, Excel, and when to stop
There is nothing wrong with a bill book while a business is small. The point at which it stops working is specific and recognisable: when you cannot answer "who owes me money and for how long" without an afternoon, or when two people are billing and the numbering has gone.
Excel lasts longer and fails more expensively, because it looks like it is working right up until the return does not tie out. A spreadsheet does not enforce a numbering series, does not know the place of supply, and does not stop the same invoice number being used twice on two laptops.
The move does not have to be expensive — the free plan exists precisely so the decision is not about money.
Counter billing versus considered billing
These are two different jobs and software that pretends otherwise serves one of them badly. A retail counter needs the same three items billed forty times an hour with a queue watching. A distributor raising a fifty-line invoice against a purchase order needs accuracy and a document that survives scrutiny.
Billixo is built for the second, and fast enough for the first: saved products, remembered customers, keyboard-driven entry, and no page that has to load before you can type the next line.
If your bottleneck is genuinely a queue at a shop counter and nothing else, a dedicated POS is the honest recommendation. If your bottleneck is the month, this is the right shape of tool.
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.
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.
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.
Who this actually suits
It fits a business that raises between a handful and a few hundred invoices a month and would rather not think about GST between the 10th and the 20th: traders, distributors, retail counters, workshops, agencies, consultants, contractors and manufacturers who sell on invoice.
It fits less well if you need deep manufacturing costing, multi-currency consolidation, or payroll — those are different products, and pretending otherwise wastes your evaluation time.
If you are not sure which side of that line you fall on, the free plan answers it in an afternoon at no cost. Start free now.
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.
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
Does it split CGST, SGST and IGST automatically?
Yes, and not from a dropdown. The split is derived from the place of supply on the customer record against the state of your GST registration, so an inter-state sale becomes IGST whether or not anyone remembers to say so.
Can I put my own logo and business details on the invoice?
Yes, on the paid plans — logo, business details, terms and signature block. The free plan produces the same compliant invoice with a small watermark on the PDF.
Can I send the invoice on WhatsApp?
Yes. WhatsApp and email sharing are built in on the paid plans, so the invoice reaches the customer from the same screen you raised it on rather than through a download-and-attach detour.
Can I move my existing customers and products in?
Yes. Bulk import from CSV or Excel on any paid plan, and export back out in CSV, Excel or JSON at any time, including on Free. Most people bring their party and item lists across in one pass and carry outstanding invoices as opening balances.
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.
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