Why manufacturers lose stock accuracy to spreadsheet chaos

Ask most manufacturing businesses how much stock they have of a given item right now, and you'll usually get an answer with a pause in front of it. Not because nobody's counting — because three different people are counting, in three different files, and none of the three numbers agree.

How the mismatch actually builds up

It rarely starts as one big problem. It starts as a handful of reasonable-seeming shortcuts that stack on top of each other:

• Production logs finished batches into one sheet, updated at the end of the shift, not in real time.
• The warehouse team tracks dispatch separately, because they need their own working copy.
• Sales checks "available stock" by calling the warehouse directly, because the spreadsheet is a day behind by the time they see it.
• Returns and rejections get noted on paper first, then entered into the system "when there's time" — which, during a busy week, can mean several days later.

Each of these makes sense on its own. Together, they mean that at any given moment, there isn't one number for stock — there are three or four, each a little out of date in a different direction.

Why this matters more than it looks like it should

A stock mismatch doesn't just cause an awkward phone call. It cascades:

A sales rep quotes a delivery date based on stock that was already committed to a different order an hour earlier. A customer gets told something is in stock, then gets told the next day that it isn't. Production plans a batch assuming raw material is available, only to find out at the shop floor that it was used on a different job the stock sheet hadn't caught up on yet.

None of these are isolated mistakes. They're the predictable result of making decisions off a number that was already wrong by the time anyone looked at it.

What "one stock figure" actually requires

Getting to a single, trustworthy stock number doesn't usually require ripping out existing systems. It requires deciding, deliberately, which single record is the source of truth — and then making sure every other view (sales, warehouse, dispatch, accounts) reads from that record instead of keeping its own copy.

In practice, that means:

• Production updates stock the moment a batch is completed, not at the end of the shift — even a same-day lag is often enough to cause a conflict.
• Dispatch reduces stock the moment an order leaves, not when someone later reconciles the day's shipments.
• Sales sees the same number the warehouse sees, in real time, rather than calling to confirm it.
• Returns and rejections are entered as they happen, not batched for later — a "pending" status is often enough to prevent a false promise to a customer.

The underlying principle is simple: a stock figure is only useful if everyone making a decision is looking at the same one, at the same time. The moment there are two versions, someone is working off the wrong one — and they usually don't find out until it costs them a customer.

A real pattern worth checking for

One sign this is already happening in your business: if "let me check and get back to you" is a common response to a stock question, that's usually not caution — it's an admission that the number on screen isn't trusted enough to quote directly. That's a useful, honest signal. It means the fix isn't training people to trust the spreadsheet more. It's connecting the systems so the spreadsheet deserves to be trusted.

Where to start if you're not ready for a full system

You don't need a new ERP to make real progress here. The fastest win is usually connecting just two points: the moment stock is produced, and the moment it's dispatched. Those two updates, made automatic rather than manual, remove most of the daily mismatch — because most of the drift happens exactly there, in the gap between "it was made" and "it left."