The same number in four places
Ask your sales head how much stock of a product you have and they give you one answer. Ask accounts and you get another. The warehouse says a third. The dealer’s order sheet shows a fourth. You are not the victim of dishonest people. You are the owner of several tools that were each bought to solve one problem, and none of them were ever introduced to each other.
What it costs
The cost mostly hides in people’s time. Take a hypothetical business with a team of 12 in sales support, accounts and dispatch. Suppose each person spends one hour a day re-entering or correcting data that already exists in another tool. That is 12 hours a day, around 260 hours a month. At an average loaded cost of ₹300 an hour, that is ₹78,000 a month, close to ₹9.4 lakh a year. And that is the visible part.
The invisible part is decisions made on stale numbers. A price change entered in one tool and not another produces invoices at the old rate. An order accepted against stock that was already committed produces an apology. A month-end close takes nine days instead of three because every figure has to be reconciled by hand.
Why it happens
Systems are bought one at a time, for one department, at the moment of one problem. Billing software came with the accountant. A spreadsheet came with the sales head. A messaging group came with the dealers. Each was a sensible choice then. Nobody was asked to design how they fit together, because nobody owns the whole.
The result is predictable:
- Master data, the list of products, prices and dealers, exists in several versions.
- Handovers between departments happen by people copying, not by records flowing.
- Errors are found late, at invoicing or at delivery, when they cost the most.
- Reports need a person to assemble them, so they arrive late and are argued about.
What changes it
First decide which tool is the record for each thing. One place holds the product list and prices. One holds the dealer master with credit terms. One holds stock. Everything else reads from it or is retired. This decision costs nothing and is where most of the value is.
Second, name an owner for each of those records. If the product list changes, one person changes it, and everyone else sees the change.
Third, map the handovers: order to dispatch, dispatch to invoice, invoice to collection. For each, ask whether a person is copying something that could flow automatically. Start with the handover that costs the most hours.
Then bring in integration work where it earns its place. Connecting tools so that data moves without re-typing is routine and often modest in cost compared with replacing everything. Sometimes the right answer is a single system. Sometimes it is connecting the three you have. A consultant who recommends replacement before mapping the handovers is selling, not advising.
A quick way to size the problem is to ask each team for the three things they re-type most often. Add up the hours, multiply by a loaded hourly cost, and put the total beside the cost of connecting those particular tools. That comparison, not a vendor’s brochure, should decide how much to spend.
What this does not fix
Connecting tools does not correct bad data; it spreads it faster. If your product list has duplicates and your dealer master has stale entries, tidy them first. It will not change habits: staff who prefer their own spreadsheet will keep one. And no integration compensates for the lack of a clear owner.
If you suspect the cost of disorder is rising as you add dealers, the scale-readiness check shows where your organisation is likely to strain first.