The technician is on site, the customer is watching, and the part the spreadsheet says you have isn't on the shelf. Finding out at that point usually means a second trip.
Most small and mid-size businesses track stock in a spreadsheet. Someone updates it when a delivery arrives, and someone else is supposed to update it when parts go out to a job. That second update rarely happens on time. A technician grabs a few fittings on the way out and means to tell the office later, and the note turns up at the end of the week on a crumpled delivery slip, if at all.
So the spreadsheet drifts. Every so often someone does a full count and fixes the numbers, and the drift starts again the next morning. The file only stays right if people stop their work to type numbers into it, and the work comes first.
Most businesses we see keep stock in more than one place, and the vans are the place nobody counts. Each technician's van is a small warehouse, and parts move between it and the shop all day. Every move is another update someone has to remember.
When nobody trusts the count, technicians keep a private stash in their van and the office over-orders just in case. Cash sits on the shelves as stock you didn't need, while the part you did need still runs out because nobody saw it getting low.
Stock changes when the work happens. When a technician closes a job on their phone and records the parts used, those parts come off their van's stock. When parts go from the warehouse to a van, someone taps or scans the transfer and both locations update. Nobody retypes numbers into a spreadsheet at the end of the day.
For each item you set a reorder point, the level at which you want to buy more. The software watches that level across every location, vans included, and puts the item on a reorder list when it drops below.
The system groups the reorder list by supplier and fills in quantities from the rules you set. Someone reviews the draft purchase order and sends it. When the delivery arrives, it's received against that order and the quantities go to the right location. Ordering becomes a short review of a list the software has already built, instead of a weekly search through emails.
Stock problems often start when a job is estimated. If estimates live in a separate spreadsheet, a job can be booked for parts you don't have. With both in one system, a scheduled job reserves its materials, and the reorder list counts what upcoming jobs will use along with what has already gone out.
Materials were one of the first things we automated in our engineering case study, where jobs kept being over-ordered or under-budgeted. Estimating and ordering from the same data stopped that.
You'll still do physical counts to catch damage and mistakes. Once stock updates as work happens, a count mostly confirms the numbers instead of replacing them. Technicians start relying on the system instead of their own stash, and the extra stock gradually comes off your shelves.
If your team finds out what's missing on the job site, book a call. Tell us where your stock is kept and how a part gets from the supplier to a job today, and we'll show you which steps can be automated and where to start.