Key takeaways
What this article covers, in order:
- How does "filing from Excel" usually work?
- Excel and GST software, side by side
- Where Excel genuinely wins
- Where does Excel quietly cost you money?
- So which one should you use?
- Moving off Excel without losing your history
It's 9:40 pm on the 10th. The sales register has 212 rows, two of them have the customer's GSTIN in the wrong column, and the VLOOKUP against GSTR-2B is showing #N/A for a supplier you know filed. If that sounds familiar, you already know the answer. Excel is fine for GST when you have a handful of invoices and one careful person. Once you're reconciling GSTR-2B every month or sharing the file with a CA, software saves real hours, and with free plans around, cost isn't a reason to stay on spreadsheets anymore.
How does "filing from Excel" usually work?
Most offices that file from Excel do something like this. They keep a sales register with invoice number, date, customer GSTIN, place of supply, taxable value, rate and the CGST/SGST/IGST split. At month-end someone sorts it into the GSTR-1 sections (B2B, B2C large, B2C small, credit and debit notes, HSN summary, documents issued). Then they either type those numbers into the portal's online forms, or paste them into the government's offline tool to make a JSON file and upload that.
For ITC, they download GSTR-2B, paste it into another sheet, and match it against the purchase register. Finally they work out GSTR-3B (outward tax, eligible ITC, net payable) and key it into the portal.
It's legal. Plenty of businesses do it well. The real question is how much of your month it eats, and how sure you are of the result.
Excel and GST software, side by side
| Excel | GST software | |
|---|---|---|
| Upfront cost | Usually already on your laptop | Free plans exist; paid tiers for more volume |
| Monthly time at 50–100 invoices | Several hours of copying, sorting, checking | Mostly review time |
| GSTIN and format checks | Only if you build the formulas | Built in |
| Sorting into GSTR-1 sections | By hand | From the invoice data |
| HSN summary | Pivot table, easy to get wrong | From your item list |
| GSTR-2B matching | VLOOKUP on invoice numbers, breaks on small format differences | Matched, mismatches listed |
| Filing | Type on portal, or offline tool plus upload | Some software files directly |
| Interest and late fee | Seen on the portal at the last step | Some software shows the portal's figure before filing |
| Working with a CA | Emailing versions back and forth | Same books, separate logins |
| Version control | "GST_Aug2026_final_v3_REAL.xlsx" | One set of books |
| Flexibility | Anything you want | Limited to what the software offers |
Where Excel genuinely wins
Let's give spreadsheets their due. If you raise five invoices a month and buy almost nothing, a simple sheet plus the portal's online form is quick and costs nothing. Excel is also better for one-off analysis, like working out margin by customer or testing a price change, which most GST software won't do. Everyone in your office already knows it. And there's no vendor, no plan, no limit.
If that's you, carry on. Just add a few validation formulas (a 15-character check on GSTINs is a good start) and keep a backup somewhere other than your desktop.
Where does Excel quietly cost you money?
It's rarely one big disaster. It's small leaks, every month.
The ITC you didn't notice you'd lost
Your supplier writes "INV/0045". Your sheet says "INV-45". The lookup fails. Now you either skip ITC you're entitled to, or claim it without being able to show it in GSTR-2B. Spread that across 40 suppliers and you have a problem that never shows up as a single number.
Right total, wrong section
A credit note typed as a negative invoice. A B2B sale missing the buyer's GSTIN, so it lands in B2C. An inter-state sale with CGST and SGST instead of IGST. The totals still tie, so nobody spots it until your customer rings because the invoice isn't in their GSTR-2B.
The sheet wasn't ready, so you filed late
Excel filing depends on one person finishing one file. If Priya is down with fever on the 19th, GSTR-3B slips. Late GSTR-3B means 18% a year interest on tax paid in cash, plus a daily late fee (₹50 a day, or ₹20 for a nil return, subject to caps). Check the current figures on the GST portal.
Two versions of the truth
You email the file to your CA on Monday. They correct it on Wednesday. You've added three more invoices to your copy in the meantime. Which one do you file?
Your evenings
Say month-end GST takes you six hours. That's six hours a month not spent selling, making or collecting. Over a year it adds up to more than a working week.
So which one should you use?
Ask yourself three things. Do you have more than about 20 B2B invoices or purchase bills a month? Is a meaningful chunk of your tax saved through ITC that depends on matching GSTR-2B? Does more than one person touch the GST numbers?
A yes to any one of these and software will probably save you more than it costs, especially if a free plan covers your volume. Three noes, and Excel plus the portal is a perfectly reasonable choice for now.
Moving off Excel without losing your history
You don't have to throw your spreadsheets away. Here's how we'd do it.
- Pick a clean start date. The 1st of a month works; the start of a quarter is better.
- Import your masters first: customers and suppliers with GSTINs, and items with HSN/SAC and rates.
- Enter opening balances for receivables, payables and bank as on that date.
- Run one month in both. Prepare the return in Excel and in the software, and if the summaries match, file from the software.
- Archive the old sheets. You'll want them for any assessment, and your filed returns are on the portal regardless.
One caution. If your old sheets have known problems, such as ITC claimed on bills that never showed up in GSTR-2B, talk to a CA before carrying those numbers forward. Fixing it may need corrections in a later return, and the timing matters.
How HelloBooks helps
HelloBooks Free is meant for the business that's outgrowing a spreadsheet but doesn't want another monthly bill. It's ₹0 with no card and no expiry, and gives you unlimited GSTR-1 and GSTR-3B filing for one GSTIN, filed directly to the GST portal from inside HelloBooks. No offline tool, no JSON upload. GSTR-2B reconciliation with ITC tracking replaces the VLOOKUP sheet, and the invoices, bills and quotes you create feed the return. P&L, Balance Sheet, Cash Flow and AP/AR aging come along with it, and 2 users means your CA works in the same books rather than a copy.
The free limit is 200 transactions a year. If you're over that, or you want Excel export and Tally sync, those are on Pro at ₹499/month. More on GSTR-1 filing, GSTR-2B reconciliation and HSN/SAC codes.
FAQs
Is it legal to file GST returns using Excel?
Yes. Excel is only where you prepare the numbers. You still file on the GST portal, either by typing into the online forms or uploading a JSON file made with the government's offline tool.
Is the GST offline tool the same as GST software?
No. The offline tool turns data you've already prepared into an uploadable file. It doesn't keep books, match GSTR-2B or track ITC from month to month.
Will my Excel data import into GST software?
Customer, supplier and item lists usually import from Excel or CSV without much fuss. Old invoices are often better left in your archive, with only opening balances carried in.
How long does switching take?
For a small business with tidy masters, a few hours of setup and one month running both side by side.
I only file nil returns. Do I need either?
Not really. Nil filing on the portal takes a couple of minutes. Software starts to help once real activity begins and you want books and GST in one place.
Keep Excel for the analysis it's good at, and let software do the monthly grind.
Start free — GST filing included, no card. Try HelloBooks Free
