Seven signs your spreadsheet inventory has become the risk

A spreadsheet is not a bad tool. It is a good tool that stops being true the moment more than one person depends on it. The failure is rarely a dramatic loss — it is a slow drift between three versions of the same number.

These are the seven symptoms we see most often in a 20–100 person distributor or manufacturer. None needs a six-month project to fix. The first step is naming which one is actually costing you money.

1. Two people can name a different stock figure for the same item

One person keeps the stock sheet; another keeps the purchasing sheet; a third has the “real” number in their head. Nobody is lying. They are reading different files.

The test is simple: ask three people for the on-hand quantity of your fastest-moving item, separately, and compare. If the answers differ, the problem is not counting accuracy. It is that there is no single record.

2. Month-end is a reconciliation project

If closing the month takes more than two days, the ledger is being reconstructed rather than read. A typical symptom is a spreadsheet that exists only to explain the difference between the stock sheet and the accounting system.

The fix is not a better reconciliation. It is removing the second source of truth, so the stock movement and the cost entry are the same transaction.

3. A stock count always produces a surprise

A count that matches is boring. A count that is off by 3% every time is a process problem: unrecorded issues, deliveries booked after the fact, or returns that never re-entered stock.

Before buying software, write down the last three variances and their cause. If the cause is “we forgot to record it”, software with a reservation and movement log will help. If the cause is theft, software will only tell you sooner.

4. Purchase orders live in email

The order is a PDF attached to a thread; the delivery note is a photo; the invoice is a separate email. Matching them means searching a mailbox.

This is the point where a 20-person company starts paying for goods it never received, or pays twice for the same delivery, because the evidence is scattered. A three-way match does not need a big system — it needs the three documents to reference each other. See the three-way match article.

5. Nobody can answer “who changed this?”

A price was edited. A quantity was overwritten. A supplier was deleted. The spreadsheet has no history beyond the last save, and the last save could have been anyone with the link.

An audit trail is not a compliance nicety. It is how you settle an argument with a customer without escalating it, and how you notice a pattern before it becomes a loss.

6. Access is a shared password or a shared link

If the stock sheet is protected by “everyone uses the same login”, then a departed employee still has access and nobody can prove who did what. This is also the point where a spreadsheet becomes a data-protection problem, not only an operational one.

The minimum is individual accounts, a role per person, and an offboarding step that actually disables the account. If the tool cannot do that, it is not ready for a second employee.

7. You are afraid to change the formula

The workbook works, mostly, and one person understands why. Every change is a risk, so nothing changes. That is the clearest sign the spreadsheet has become the constraint on the business rather than a record of it.

What to do first

Do not start with a software selection. Start with the one chain that hurts: usually purchase order → receipt → stock → invoice. Write down each hand-off, who does it, and where the record lives. You will find that most of the pain is in two hand-offs, not in the whole business.

1. Pick one item family and one supplier.
2. Trace a single order from requisition to payment, on paper.
3. Mark every point where a number is copied by hand.
4. Replace the worst copy with a single record, even if the rest stays manual for now.

That is also the right way to evaluate a platform: ask it to run that one order end to end, with the same people, before you import anything else.

The honest trade-off

A single system costs something a spreadsheet does not: setup time, a monthly fee, and the discipline to record the movement when it happens. If your volume is low and one person genuinely owns the process, a spreadsheet may still be the right tool. The moment a second person depends on it, the trade flips.

If you want to see what the single-record version looks like for a distributor, the distributor overview walks the chain, and the price list shows what that footprint costs.