Billing software vs Excel: when to switch and how to move in 30 days

Excel is not the problem; scale is. A single-person business raising a dozen invoices a month can run on a spreadsheet for years. The trouble starts when a second person edits the file, when invoice numbers get reused, or when GST is split wrongly and you find out during a notice. This guide explains the honest tipping points, what to look for in billing software, what it should cost, how to keep control of your data, and a 30-day plan to switch without a mess.

Where Excel genuinely works

Before anyone tells you to buy software, be clear about what Excel does well. It is free if you already have it, everyone knows it, and you can shape it exactly how your trade works. A freelancer with five clients, a consultant billing monthly retainers, or a small trader who raises a bill of supply twice a week has no real need for anything more.

Excel remains a good fit when all of these are true: one person does all the billing, you raise fewer than 20 invoices a month, all your customers are in one state (so no IGST decisions), you do not sell on credit to more than a handful of people, and you are comfortable maintaining the formulas yourself. If that describes you, spend your money on a better template and a backup habit, not on subscriptions. The rest of this post is for the moment when one of those conditions stops being true.

The five signs Excel has stopped working

Invoice numbering breaks

Rule 46 of the CGST Rules requires every tax invoice to carry a consecutive serial number, unique for the financial year, up to 16 characters. In Excel, the number is a cell you type. Two people open the file, both raise INV-0231, and now two different customers hold the same invoice number. Or someone deletes a row, and INV-0187 never existed, which is awkward when the GST officer asks for it. Once you have a second person billing, or you bill from two locations, manual numbering is a liability. The rules are covered in detail in invoice numbering rules in India.

GST is computed wrongly

The classic mistake: a Surat trader sells to a Mumbai buyer and the template, built for local sales, splits 18% into CGST 9% and SGST 9%. It should have been IGST 18%. The customer cannot claim credit properly, the GSTR-1 is wrong, and the fix is a credit note and a fresh invoice. Templates also break when a rate changes (the September 2025 rationalisation moved many items to 5% or 18%), when you sell a mix of goods at different rates on one bill, or when someone types 18 in a cell that expected 0.18. See CGST vs SGST vs IGST and place of supply for the rules a tool should apply automatically.

The ledger drifts

Your invoices are in one sheet, receipts in another, and the customer outstanding is a SUMIF that someone edited in March. You send a reminder for ₹42,000 and the customer replies with a screenshot showing they paid ₹15,000 of it in February. Every such reply costs you goodwill. When receivables no longer match what customers say they owe, the spreadsheet has become a source of disputes rather than a record.

You cannot answer simple questions

How much did Customer X buy last year? Which items sold most in Q2? Who owes more than ₹50,000 for over 60 days? In Excel, each of these is a fresh pivot table someone has to build. In a billing tool, they are reports that already exist.

Compliance paperwork takes days

Preparing GSTR-1 data from a spreadsheet means sorting invoices by B2B and B2C, by state, by rate, and matching each purchase bill for input credit. If that takes your CA two days every month and they charge you for it, the software has already paid for itself.

What to look for in a billing tool

There are dozens of billing tools in India, from free mobile apps to full accounting suites. Judge them on what you will use daily, not on the feature list.

Do not pay for what you will not use. E-invoicing matters only above ₹5 crore aggregate turnover; inventory with batch and expiry matters only if you stock pharma or food. A tool with 300 features you do not need is slower to use for the five that you do.

Test with real data. Enter ten of last month's invoices, one credit note, one inter-state sale and one bill with two GST rates. If any of these needs a workaround, move on.

Free vs paid: what you actually get

Free tools come in three flavours. Some are free forever with limits on volume (a fixed number of invoices or customers a month). Some are free trials that convert to a subscription. Some are free because you are the product: your data is used to sell you loans or your customers see ads. Read the plan page and privacy policy before entering a single customer.

A reasonable annual price for a small business billing tool in India is between ₹1,500 and ₹6,000. Above that you are usually paying for accounting, inventory and multi-branch features. Prefer one-time or fixed-term passes over auto-renewing subscriptions if your cash flow is uneven; a card that auto-debits ₹4,999 in a lean month is a real irritation.

Compare cost against time. If billing software saves your accountant 4 hours a month at ₹500 an hour, that is ₹24,000 a year, well above the cost of most tools. If it saves you nothing because you had a working template and few invoices, stay on Excel.

Data ownership and the right to leave

This is the section most people skip and regret. Before you move to any tool, answer four questions.

1. Can I export everything? Customers, vendors, items, invoices with line items, receipts and ledgers, in CSV or Excel, at any time, without asking support. If the answer is "contact us", assume no.
2. What happens when I stop paying? The good answer is read-only access plus export. The bad answer is your data disappears in 30 days.
3. Where is the data stored and who can see it? Indian small businesses are covered by the Digital Personal Data Protection Act, 2023; your customers' names, phone numbers and addresses are personal data you are responsible for.
4. Can I download PDFs of every invoice in bulk? GST law requires you to keep records for 72 months from the due date of the annual return for that year (Section 36 of the CGST Act). Do not rely on a vendor being around that long.

Whatever tool you use, keep a monthly export in a folder you control. It takes two minutes and makes the tool replaceable, which is exactly the leverage you want.

Worked example: a Kochi electronics shop counts the cost

Kochi Circuit House sells CCTV kits, networking gear and does installations. The owner and one helper raise about 90 invoices a month from an Excel template. Here is what a month of Excel actually costs them, with the numbers.

Errors: last quarter they raised three invoices to Bengaluru and Chennai customers with CGST/SGST instead of IGST. Each needed a credit note, a fresh invoice and a phone call to the customer's accountant. Roughly 2 hours each, so 6 hours a quarter, or 2 hours a month.

Duplicates: two duplicate invoice numbers found during GSTR-1 preparation in the last six months, each taking the CA about an hour to sort out and amend. Call it 20 minutes a month averaged.

Collections: outstanding is tracked in a separate sheet updated weekly. Two customer disputes a month over "we already paid this", 45 minutes each, so 1.5 hours a month, plus one payment of ₹18,500 that was simply forgotten and collected four months late.

GST preparation: the CA spends about 5 hours a month rebuilding B2B, B2C and rate-wise summaries from the sheet and bills ₹600 an hour for it, so ₹3,000 a month.

Add it up: about 4 hours a month of the owner's time (say ₹400 an hour, so ₹1,600) plus ₹3,000 of CA time is ₹4,600 a month, or ₹55,200 a year. Against that, a billing tool at ₹2,500 to ₹5,000 a year, plus perhaps 20 hours of one-time migration effort, is not a hard decision. The point is not that software is cheap; it is that Excel at 90 invoices a month is not free.

Note the flip side: the owner's brother runs a small repair counter with 8 invoices a month. For him the same arithmetic gives perhaps 20 minutes of monthly pain. He should stay on Excel.

Migration steps from Excel

Do not try to move everything at once. Move master data first, then balances, then start billing. Old invoices stay in Excel.

Step 1: Clean the customer list

Export your customers to a sheet with these columns: name, GSTIN, billing address, state, PIN, phone, email. Remove duplicates ("Sharma Traders" and "Sharma Traders Pvt Ltd" are probably one customer). Validate every GSTIN; a wrong GSTIN means the customer cannot claim credit. The state code in the GSTIN (first two digits) must match the state in the address, because that is what decides IGST vs CGST/SGST. Do the same for vendors.

Step 2: Clean the item list

For each item or service: name, HSN or SAC code, unit, GST rate, default selling price. Check the rate against the current schedule, especially after the 2025 rationalisation. Use 4-digit HSN if your turnover is up to ₹5 crore and 6-digit above. This is also the moment to retire items you have not sold in a year. See HSN and SAC codes explained if the codes are a mess.

Step 3: Fix the cutover date and opening balances

Choose the 1st of a month, ideally the start of a quarter. As on that date, list every unpaid invoice per customer and every unpaid purchase bill per vendor, with invoice number, date and balance due. Enter these as opening balances, one line per invoice so that ageing (0 to 30, 31 to 60, over 60 days) works from day one. Total the opening receivables and payables and match them to your Excel; investigate every rupee of difference before you continue.

Step 4: Continue the invoice series

Do not restart numbering from 1 in the middle of a financial year. If your last Excel invoice was KCH/26-27/0412, the first invoice in the new tool should be KCH/26-27/0413. If the tool cannot start from a given number, that is a red flag.

Step 5: Run parallel for one week, then stop

Raise the first week's invoices in both places, compare totals and GST splits, and then commit. Running parallel for months is how migrations die; a week is enough to catch template problems.

Step 6: Archive Excel

Save the final Excel workbook as read-only with the cutover date in the file name, export PDFs of all old invoices into a dated folder, and back both up to two places. You are not deleting anything; you are freezing it.

A 30-day switch plan

If you have staff, train the person who bills, not just yourself. Write a one-page sheet: how to add a customer, how to raise an invoice, how to record a receipt, and who to ask.

Common mistakes

Restarting invoice numbers mid-year. Two series in one financial year invites questions in an audit. Continue the sequence.

Importing customers without state codes. Every inter-state invoice then defaults to CGST/SGST. Fix state before the first bill.

Entering opening balances as one lump sum per customer. Ageing becomes useless, and you cannot tell which invoice a part-payment settled.

Choosing a tool by feature count. The five features you use daily matter more than the 200 you will never open.

Not testing export before paying. Discovering you cannot leave is expensive.

Migrating during the busiest month. Do not switch in the last week of March or in the middle of Diwali season.

Expecting the tool to do accounting. A billing tool records sales, purchases and money received. Your books, bank reconciliation and returns are still your CA's job, or a separate accounting system. Read bookkeeping basics for small business to see where billing ends and accounting begins.

Deleting the Excel files. Keep them for at least the statutory period; they are your records for those years.

How VyaparKit helps

VyaparKit is a toolkit for the documents and ledgers side of this problem, not full accounting software, and it does not file returns or reconcile your bank. The GST invoice tool splits CGST/SGST and IGST by place of supply and numbers invoices in a financial-year series, with saved customers and items. The customer ledger and outstanding statement give you ageing and a statement to send on the 1st. Purchase bills carry an ITC flag that feeds a GST report your CA can use. If your old records live in bank PDFs, bank statement to Excel converts text-based statements so you can match receipts before setting opening balances. The free plan is limited by count each month, so try it with real bills before deciding whether Pro is worth it for you.

Next steps

• Count last month's invoices and note every GST error or duplicate; if it is under 20 invoices and zero errors, stay on Excel for now.
• Shortlist two tools and test each with ten real invoices, including one inter-state sale.
• Clean your customer list with GSTIN and state, and your item list with HSN/SAC and rate.
• Set a cutover date on the 1st of next month and prepare opening balances per unpaid invoice.
• Archive the Excel workbook as read-only and schedule a monthly export from the new tool.