The sheet that everyone depends on
Your business runs on a spreadsheet. It started as a simple list of dealers and orders and has grown into twelve tabs with formulas that only one person understands. Two people sometimes open it at the same time and one overwrites the other. Last month a column was sorted without its neighbours, and a set of rates quietly attached themselves to the wrong dealers.
Spreadsheets are not the problem. They are a good tool, and many successful businesses were started on one. The problem is the point at which the business outgrows what a spreadsheet can hold safely.
What it costs
Take a hypothetical dealer network with 120 dealers and 400 orders a month. Imagine the price column shifts for one dealer’s group of fifteen items, and the error is not noticed for three weeks. If a 4 per cent under-billing applies to that dealer’s ₹3 lakh of monthly orders, that is ₹12,000 a month lost, and more if the dealer’s invoices are already settled.
A spreadsheet failure is also expensive in time. If the one person who understands the formulas is on leave for a week, orders still go out, but nobody dares change a rate or add a scheme. That is a dependency on a person, and it is the kind that slows a business exactly when it is trying to move faster.
Add the hours of copying between sheets, and the cost grows without a single dramatic failure.
Why it happens
A spreadsheet has no rules of its own. It does not stop you entering a text in a number field, deleting a formula or creating two rows for the same dealer. It has one version of the truth only if everyone works on the same copy, and in practice copies multiply by email and WhatsApp.
It also records only the present. If someone changes a rate, there is usually no history of who changed it, when and why. That matters when a dealer disputes a bill.
What changes it
You do not need to abandon the spreadsheet on a fixed date. You need to recognise the signs and act.
- More than one person edits it daily.
- The same data is copied into a second file.
- A mistake in it would have a financial effect.
- One person is the only one who can safely change it.
When two or more of these apply, move the key records, dealers, rates, orders and stock into a shared system with controlled access and a change history. Keep the spreadsheet for analysis, where it is excellent.
Before moving, tidy the data: one row per dealer, consistent names, rates with start dates. Moving a mess into a system gives you a faster mess. Agree who may change what, and write it down.
Then start with one flow, usually orders, and add others as the team gets comfortable. Run both side by side for a month so people trust the new record.
What this does not fix
A system will not make a poorly defined process better; it enforces whatever you give it. If your discount rules are inconsistent, the system will consistently apply inconsistent rules. Nor does it remove the need for judgement: someone still has to review exceptions.
Teams may resist, since a spreadsheet feels flexible and a system feels strict. That strictness is the benefit, but it needs explaining.
To see where else your business might be reaching its limits, take the scale-readiness assessment.