Excel runs a remarkable share of Indian business. A stock sheet, a sales sheet, a dues sheet, a staff sheet and a dozen others, often built by the owner's nephew years ago and updated by whoever has time. It is flexible, cheap and familiar.
It also breaks in quiet ways. A formula gets overwritten. Two people edit two copies. The sheet that matters lives on one laptop. And none of the sheets talk to each other, so a sale updates the sales sheet but not stock or dues.
01Signs you have outgrown Excel
- Several versions
- of the same sheet, such as "stock final", "stock final 2" and "stock Oct new"
- Figures that do not agree
- between sheets
- One person
- who understands the sheets, and everything stops when they are away
- Hours each month
- spent copying data between sheets for GST or reports
- No record of who changed what,
- or when
- A file too large
- to open quickly or share on WhatsApp
If three or more apply, it is time to move.
02What usually lives in the sheets
| Sheet | What it holds | Where it goes |
|---|---|---|
| Sales or bills | Invoice list, often with GST | Sales invoices |
| Dues | Customer balances and old bills | Customer records |
| Stock | Items, quantities, rates | Items and stock on hand |
| Purchase | Supplier bills | Purchases and suppliers |
| Staff | Names, salaries, attendance | Staff records and attendance |
| Projects or jobs | Orders, status, due dates | Projects and tasks |
03Clean the sheets first
The quality of your new system depends on what goes in. Before the cut-off:
Customers and suppliers
- One row per party. Merge duplicates.
- Separate columns for name, phone, GSTIN, state and address. A single "details" column with everything typed together cannot be used.
- Check GSTINs on the GST portal. A wrong digit means wrong tax and returns that do not match.
Items
- One name per item, used the same way everywhere. "CP tap", "C.P. Tap" and "cp-tap" are one item.
- Unit, HSN code and GST rate for each.
- Remove items you no longer sell.
Balances
- Each customer's balance on the cut-off date, with the list of unpaid bills behind it if you have it.
- Each supplier's balance, the same way.
- Stock quantity for each item, from a count on or near the cut-off date.
A dues sheet kept for years collects dead rows. In a Surat textile agent's 9,000-row sheet, hundreds of rows may belong to parties who have closed their accounts, with more duplicates. Two days of cleaning before the move saves weeks of confusion after it.
04Pick a cut-off date
The first of a month, ideally the start of a quarter. From that date, new work goes into the software. The sheets stay as they are, as a record up to the cut-off.
05Move in order
- Items with units, HSN and GST rates
- Customers and suppliers with their details
- Opening balances: customers, suppliers, stock, cash and bank
- Staff, with leave balances
- Open orders and jobs still in progress
How the data goes in depends on the software. Ask the vendor what can be brought in from spreadsheets and in what format before you commit. Where data has to be typed, split the work across people and days.
06Check before you go live
- Total of customer balances in the software equals the total in the sheet.
- Total of supplier balances, the same.
- Stock value and quantity, the same.
- A few individual customers, picked at random, show the right balance and bills.
07Stop the sheets coming back
The biggest risk after a move is that people go back to Excel because it feels quicker. Prevent it:
- Make the old sheets read-only
- after the cut-off date.
- Ask for figures from the new system
- in every meeting and call.
- Find out why
- someone is keeping a side sheet. Usually it is a report they need and cannot find. Show them where it is, or add it.
- Give everyone their own login,
- so the system is theirs to use. See roles and access.
Excel still has a place for one-off analysis, such as a pricing study or a budget. Exporting data from your system into Excel for that is fine. The record of what happened should live in one system.
08Formulas and reports you will miss
Owners often worry about losing the formulas and summaries they built in Excel: a dues summary by salesperson, a monthly sales total by item, a margin column. List them before the move. For each, check where the same answer comes from in the new system. Most will be standard views, such as dues by customer or stock by item. A few may not exist; decide whether you really use them, and if you do, keep a small export to Excel for that purpose.
09Examples by size
A three-person electrical contractor in Bhopal
Jobs, bills and dues in four sheets. Moved over a weekend: 120 customers, 300 items, open bills and a stock count.
A 25-person garment exporter in Tiruppur
Order sheets by buyer, a stock sheet for fabric and trims, a staff sheet. Moved at the start of a quarter with a week of cleaning, one person owning the move, and the sheets locked on day one.
10For larger businesses
When many people have built their own sheets over the years, list every sheet in use before you start, with its owner and purpose. Some will move to the new system, some will become reports, and some can stop. That list becomes the plan.
MatruOS reads Excel sheets and CSV files in your own layout: it matches your column names to the right fields, even when they are named your own way, and brings customers, suppliers, items, deals, invoices and bills across for you to check before they go live. See Move from Excel and CSV to MatruOS.