From Excel Bills to GST Invoices: Moving a Shop’s Billing in One Afternoon

Moving a shop from Excel billing to proper GST invoices takes about an afternoon: export your customers and items, import them, raise one invoice, print it, then keep the spreadsheet open for a month as a safety net. The hard part is not the software. It is deciding what to do with the untidy data you already have.
What your Excel sheet already gets right
If you have been billing from a spreadsheet for years, it fits your business in ways no product will out of the box. You know which customers get which rate, which items go together, and where the shortcuts are. Keep that. The aim is to stop retyping the same things, not to start again.
What it cannot do
A spreadsheet cannot keep an unbroken invoice number series when two people use it. It cannot stop a formula being overwritten. It cannot produce a GSTR-1 export. And it will not survive the laptop it lives on, which is the failure nobody plans for.
Getting your data across
Two lists matter: customers and items. Everything else can be rebuilt as you go.
- Put customers in one sheet: name, address, state, GSTIN where you have one, phone.
- Put items in another: name, HSN code, rate of GST, selling price.
- Fix the state column first. It drives whether a sale is CGST and SGST or IGST, and free-text states are the single most common import failure.
- Deduplicate by phone number for customers and by name for items.
- Import, then spot-check twenty rows against the original.
Do not import five years of old invoices. Start the new system at the beginning of a month or quarter, and leave history where it is.
Your first compliant invoice
Raise one real invoice for a real customer and look at it properly. Your GSTIN, theirs, the place of supply, the HSN, the tax split, the running number. If anything is missing, fix the settings before invoice two, not after invoice two hundred.
Printing on a thermal printer
Most counters print on 58mm or 80mm rolls, and the narrow one is tight for GST detail. Check the layout on real paper before you commit, and if the HSN column is being cut off, move to 80mm rather than shrinking the font. We went into this in thermal printer billing for a small Indian shop.
Keeping the spreadsheet as a backup
For the first month, enter the day’s totals in the old sheet as well. It takes two minutes and it means a bad week costs you nothing. After a month of the totals matching, stop.
If you are choosing between tools rather than just moving off Excel, free billing software against Tally, Vyapar and Zoho compares them.
Once the billing is in order, the question that usually follows is whether you need to register at all. Do you need GST registration to sell on your own website answers that. If the invoices need to come out of a website rather than a counter, that is e-commerce work.
Do I have to import old invoices?
No, and it is usually a mistake. Start the new system at a period boundary and keep the old records readable where they are.
What if my item list has no HSN codes?
Add them before importing. Guessing at the import stage means fixing them one invoice at a time later.
Can two people bill at the same time afterwards?
In a proper system yes, and that alone is usually the reason to move. In a shared spreadsheet it is how numbers get duplicated.
How long before I can stop using Excel entirely?
A month of totals matching is enough confidence for most shops.
Want a hand with the move?
Send us your customer and item sheets. We will tell you what needs cleaning before anything is imported.