Excel for Indian Small Business: The Operating Manual

Last updated: 27 June 2026

Most Indian small businesses already own Excel — and it is more than enough to run invoicing, GST calculations, payroll, inventory tracking and cash flow for a business turning over up to ₹5–10 crore a year. You do not need costly ERP software on day one. This guide shows you exactly what Excel can do and points you to step-by-step articles for each task.

Key takeaways

• Excel handles every core business task — invoicing, GST, payroll, sales reports, inventory — without add-ons, if you set it up right.
• The gap between "Excel user" and "Excel power user" is roughly 25 formulas and a handful of techniques: pivot tables, data validation, and basic macros.
• The biggest risk with Excel is not the software — it is unsaved files, unprotected sheets and no backup. A few free habits fix this.
• Excel 2010 and later includes all the features this guide covers. You do not need Microsoft 365 for any of the techniques below.
• When your business grows past ~₹10 crore or you employ 20+ people, a move to accounting software becomes worthwhile. Until then, Excel wins on cost and familiarity.

Fact box. India has over 6.3 crore MSMEs. The vast majority use Excel or a spreadsheet as their primary business tool — not ERP. The problem is rarely the tool; it is using the tool poorly. (Source: Ministry of MSME, Udyam data 2025.)

Why Excel still makes sense for most Indian SMBs

When someone suggests you "just buy" accounting software, there are three things they overlook:

1. You already have Excel. Many Windows laptops ship with a trial or starter version of Office, and perpetual licences (Excel 2021) cost a one-time fee rather than a subscription.
2. You already know Excel (partly). Even basic familiarity means you can read, edit and share files without training.
3. Most accounting software is overkill — and subscription-priced. If your transactions per day are in the tens, not hundreds, you do not need automation for automation's sake.

The right question is not "Excel or software?" — it is "Am I using Excel as well as I should?" This guide answers that.

What tasks can Excel handle for a small business?

Excel covers every core operational task a small Indian business needs:

"Intermediate" means: you know SUM, IF, VLOOKUP (or XLOOKUP), and basic formatting. This guide covers all of it.

How do I set up Excel for business use?

Setting up properly from the start saves hours later. Do these four things:

1. Use one workbook per financial year

Keep a master workbook (e.g. FY2026-27-Business.xlsx) with separate sheets: Sales Register, Purchase Register, Cash Book, Stock Ledger, Payroll. A new financial year = a new workbook (copy the structure, clear the data).

2. Freeze header rows and use named tables

Select your data range, press Ctrl+T to convert to a Table. Named tables expand automatically when you add rows, and formulas written against them are readable: =SUM(Sales[Amount]) instead of =SUM(D2:D500).

3. Lock input cells and protect sheets

Put reference data (GST rates, item master, customer list) on a separate sheet. Lock those cells, protect the sheet with a password. Let users edit only the data-entry area. See our full guide on protecting Excel workbooks ».

4. Back up daily — automatically

Enable AutoSave (Microsoft 365) or set AutoRecover to every 5 minutes (File → Options → Save). Keep a copy on Google Drive or an external drive. See our backup guide ».

Fact box. The single most common cause of lost business data in small offices is not a virus or hardware failure — it is an Excel file that was never saved after a crash, or that was saved over by mistake. AutoSave + a cloud backup folder costs nothing and takes 5 minutes to set up.

The 25 formulas that run a business

You do not need to know every Excel function. Twenty-five formulas cover 95% of business tasks. The most important are:

• SUM / SUMIF / SUMIFS — totals with conditions (e.g. sales for customer "Sharma Traders" in April)
• IF / IFS — decisions (e.g. if state = "MH", use SGST; else use IGST)
• VLOOKUP / XLOOKUP — look up a GST rate from a rate table by HSN code
• ROUND / ROUNDUP / ROUNDDOWN — tax amounts must be rounded correctly
• DATE / EOMONTH / NETWORKDAYS — due date tracking (TDS 7th, GSTR-1 11th)
• IFERROR — handle missing lookups gracefully instead of showing #N/A
• CONCATENATE / TEXTJOIN — build invoice numbers, GST invoice references
• COUNTIF / COUNTA — count invoices, track how many items are below reorder level

Full details with examples in: 25 Excel Formulas Every Indian Business Owner Needs »

How do pivot tables help with sales reporting?

A pivot table turns a flat sales register into an instant summary — by product, by customer, by state, by month — in about 30 seconds. You click, drag, and drop fields; no formulas needed.

For a business filing monthly GSTR-1, a pivot on your sales register gives you the rate-wise breakup (taxable value at 5%, 18%, 40%) that you need to fill the return accurately.

Full step-by-step: Pivot Tables for Sales Reporting »

What are macros, and do I need them?

A macro is a recorded sequence of steps that Excel replays with one click. If you do the same formatting, printing or copy-paste task every day, a macro eliminates it.

You do not need to write code. Excel's macro recorder (Developer tab → Record Macro) captures your actions and turns them into a reusable button.

Examples relevant to Indian SMBs:

• One-click formatting of an invoice before printing
• Auto-copy of this month's transactions to a new sheet
• Batch-print 50 invoices in one go

Full guide: Excel Macros for Accounting: A Gentle Intro »

How do I keep data clean and prevent entry errors?

Data validation is Excel's built-in tool to enforce rules on a cell — only numbers, only dates, only values from a dropdown list. Combined with dropdowns for items, customers and states, you eliminate most typos before they happen.

Practical uses:

• A dropdown for "State" (28 states + 8 UTs) ensures your IGST vs SGST split is always right
• A number-only cell for quantity prevents someone typing "12 pcs" instead of 12
• A date-only cell for invoice date stops a wrong-format entry

Full guide: Data Validation and Dropdowns for Clean Data Entry »

When should I switch from Excel to accounting software?

Excel starts to strain when:

• You are processing 50+ invoices per day and reconciling manually takes hours
• You need multi-user access (two people editing the same file simultaneously)
• Your auditor or CA wants automatic bank reconciliation
• You have crossed the e-invoicing threshold (₹5 crore turnover) and need IRP integration

Below these thresholds, Excel is genuinely sufficient. Above them, accounting software pays for itself in time saved. Full comparison: Excel vs Accounting Software: When Should You Switch? »

All articles in this cluster

How Ankeshan helps: Ankeshan is an Excel add-in built for Indian SMBs — it automates GST invoicing, payroll, and compliance reports inside the Excel you already use, without replacing your existing workbooks. It is launching soon; join the waitlist.

Frequently asked questions

Which version of Excel do I need for business use? Excel 2010 and later covers everything in this guide — pivot tables, data validation, macros, table formatting, VLOOKUP. You do not need Microsoft 365, though cloud features like AutoSave and co-authoring require it.

Can I create a GST-compliant invoice in Excel? Yes. A GST invoice in Excel is legally valid provided it contains all mandatory fields: supplier GSTIN, invoice number, date, HSN/SAC codes, item description, quantity, rate, taxable value, GST rate, CGST/SGST or IGST amount, and place of supply. See our invoicing guide.

Is Excel safe for storing customer and financial data? Excel files can be password-protected and encrypted. The risks are accidental deletion, sharing the wrong file, and no audit trail. Use sheet protection, keep backups, and never email a file with sensitive data without encrypting it. Full guide: Protect and Share a Workbook »

How many transactions can Excel handle? Each sheet holds 1,048,576 rows — far more than any SMB needs in a year. Performance slows with complex formulas across tens of thousands of rows, but for typical SMB volumes (under 5,000 invoices/year) Excel is fast and stable.

Can two people edit the same Excel file at the same time? With Microsoft 365 and a file saved to OneDrive or SharePoint, yes — real-time co-authoring is available. With a local file, only one person can edit at a time; others get read-only access.

Do I need a CA to set up my Excel templates? No. The templates and guides here are self-contained. Your CA reviews the output (returns, reports) — you do not need them to set up your spreadsheets.

Sources

• Ministry of MSME — Udyam Registration data, 2025
• CBIC — GST rate notifications (current slabs: Nil / 5% / 18% / 40%, effective 22 Sep 2025)
• Income Tax Department — Section 43B(h) MSME payment rules
• Microsoft Support — Excel table, data validation, and macro documentation

General information only, not professional advice. Verify tax rates and thresholds on official portals before filing. Reviewed by a Chartered Accountant; last updated 27 June 2026.

Related: GST in Excel » · Invoicing in Excel » · Payroll in Excel » · Compliance Calendar 2026-27 »