Diane runs operations at a plumbing supplies distributor: 45 employees, 6,200 active SKUs, two warehouses 30 miles apart. When I first sat in her office she opened a spreadsheet and said, “Every quarter we count. Every quarter the numbers are wrong. Then we spend a week arguing about who is wrong.”
That arguing cost her $180,000 in write-offs the year before we met. Not theft, not damage. Just inventory where the shelf and the system disagreed, and nobody could prove which one was right.
The count was never the problem. The paperwork timing was.
We stood at three receiving docks for two days. A truck arrives at 7:40 a.m., paperwork gets signed, product is on the shelf by 11:15. But the receiving clerk only typed the receipt into the system at 4:30 p.m., because that is when he had a quiet moment.
For five hours the shelf said 120 units and the system said zero. Sales sold from the shelf. The system sold from zero. One product, two truths, and a picker standing in the aisle guessing.
Fixing that single habit took six weeks. Here is what actually changed on the floor:
- Receiving typed at the dock on a tablet, before the pallet moved. Fifteen seconds per line instead of a five-hour delay.
- Short shipments got flagged the same hour, so the credit request to the supplier went out while the driver was still in the yard.
- Cycle counts moved to 40 SKUs a day, picked by movement volume. The quarterly full count that nobody trusted disappeared entirely.
Why a big warehouse project would have failed here
Diane had already been quoted a full warehouse management rollout with handheld scanning, bin locations, and six months of training. She almost signed it. I asked her one question: which of your 6,200 SKUs are you actually wrong about?
We tested 300 items. Only 41 were wrong, and 38 of those traced back to receiving timing or to returns sitting on a bench. The other 5,859 were fine. She almost spent six figures fixing a problem that lived in one afternoon habit.
This is where ERPNext Consulting came in, and the scope was deliberately narrow. No bin locations. No barcode hardware on day one. Three configuration changes, one tablet at the dock, and a daily report that listed every item where the shelf and the system had drifted more than 2 units.
What the numbers looked like after 12 months
Write-offs dropped from $180,000 to $22,000. The remaining $22,000 was mostly genuine damage and expired stock, which is a cost you can plan for. Cycle count time went from 9 people for 3 days, four times a year, to one person for 45 minutes each morning.
The part Diane cares about most is not the savings. It is that her warehouse manager stopped dreading the first Monday of every quarter. Nobody argues about inventory when the record is updated at the moment the event happens.
If you want to test this in your own business this week, pick 20 items that move fast. Compare the shelf to the system before lunch, then watch your receiving process for one full day and note the time gap between the truck arriving and the entry being typed. That gap is your real inventory accuracy problem, and it is usually measured in hours, not dollars.