Why Your Inventory Spreadsheet Is Lying to You

If you make physical products and manage your inventory in a spreadsheet, there’s a comfortable lie at the centre of your operation. The spreadsheet feels like it knows what’s going on. It has numbers in it. The numbers match what you put in. It responds correctly when you type.

But a spreadsheet does not know what you have. It knows what you last told it. Those are not the same thing.

This distinction doesn’t matter at very small scale, when you make six products and check everything by hand before every sale. It starts to matter a lot earlier than most people expect. Here are five specific ways it fails.

1. It doesn’t update itself when you make or sell something

When you fulfil an order, does your spreadsheet automatically deduct the components you used? It doesn’t. You have to open it, find the right rows, and type new numbers.

In practice, this happens later - at the end of a busy day, the next morning, or whenever you remember. In the gap between the sale and the update, your spreadsheet says you have stock you’ve already sold. If a second customer orders the same item in that window, you have a problem.

For single-product sellers who make to order one at a time, this gap is manageable. For anyone with a catalogue of twenty or more products, selling across multiple channels, the lag is constant. The spreadsheet is always slightly behind. Your decision-making is always based on slightly stale data.

2. Formula errors accumulate silently

Spreadsheets don’t validate their own logic. A formula can be wrong - referencing the incorrect cell, using the wrong range, silently dropping a row when you insert one above it - and it will still return a number. The number will look plausible. You will believe it.

There is a well-known example from academic research where an incorrect cell reference in a macroeconomic spreadsheet shaped government austerity policy for years before anyone caught the error - not because the formula crashed, but because the wrong number looked right.

Your situation is lower stakes, but the pattern is identical. You add a new material to your stock list. You copy a formula from the row above. The cell reference shifts and now you’re tracking the wrong item. The counts drift slowly. Two months later you can’t understand why you keep running short on a specific component.

The spreadsheet never tells you something is wrong. It just returns a number.

3. It can’t alert you before you run out

A spreadsheet is reactive. It shows you what you ask it to show you. It has no concept of “this is getting low - warn the user.”

The moment you discover you’ve run out of a critical material is usually the moment it matters most: you’ve just confirmed an order, you’re halfway through a production run, or a customer is waiting for a reply to a stock enquiry. The discovery is always inconvenient because the spreadsheet had no way to tell you earlier.

Real inventory systems let you set a minimum level per item and show you what’s approaching that level - on a dashboard, in a view, in a report - before you hit zero. The reorder happens before the crisis, not after.

4. Multiple locations don’t work

Where is your stock? If you’re a food producer, the answer might be: some at home, some at the commercial kitchen. If you’re a craft seller, it might be: most in the workshop, a travel kit for fairs, a small stock of finished goods at a friend’s shop. If you’re a small manufacturer, it might be: raw materials in stores, work in progress on the bench, finished goods in dispatch.

A spreadsheet handles this one of two ways. Either you have a single stock count that ignores location (which means you can be “in stock” overall but the item you need is in the wrong place), or you have separate columns or tabs per location (which multiplies your data entry and creates reconciliation problems every time you move anything).

Neither is a real solution. In dedicated inventory software, locations are a first-class concept. Stock is always at a location. Movements between locations are tracked. You can query how much you have right now at this specific location, not just in total.

5. It can’t answer “can I make this?”

This is the failure mode that causes the most expensive mistakes.

You get an order, or a wholesale enquiry, or you’re about to start a production run. You need to know: with your current stock, do you have enough of every ingredient to complete it?

In a spreadsheet, answering this question requires manually cross-referencing your stock counts against your recipe, checking each ingredient line by line, and doing the arithmetic yourself. For a simple product with four ingredients this takes a few minutes. For a product with twelve ingredients, some of which are shared with other products currently being made, it’s a twenty-minute exercise - and you can still get it wrong.

Software with recipe support answers this in one click. Open the product, ask “can I make this?”, enter the quantity, and it tells you immediately: yes, or no - and if no, exactly which materials are short and by how much.

This is the capability that prevents the most painful mistakes in practice: the oversold order, the partial shipment, the customer who was told “yes, we have stock” when the real answer was “not quite.”

When a spreadsheet is fine

To be fair: a spreadsheet is genuinely adequate for very small catalogues at low volume. If you make three products from a dozen materials, sell mostly to order one at a time, and reconcile your counts manually at the end of each week, the errors are manageable.

The problem is that spreadsheets don’t scale gracefully. They work at five products and start failing at thirty. The failure is gradual - a slow accumulation of small inaccuracies and manual steps that increasingly cost time and money - and by the time it’s clearly not working, the underlying data is already suspect.

The switching objection

The usual hesitation is: “I know my spreadsheet isn’t perfect, but setting up new software is a big project.”

This used to be a fair point. Inventory software historically came in one of two forms: cheap and inadequate (basic stock counters with no recipe or BoM support) or capable and expensive (ERP systems that take weeks to configure and charge hundreds of pounds per month, indefinitely).

That gap has narrowed. There is now software built specifically for small producers - with recipe costing, multi-location stock, and the “can I make this?” check - that costs a one-time fee and takes less than an hour to set up. The question worth asking is whether your current spreadsheet is costing you more than the switch would.

---

Kitted is production management software for small manufacturers and makers. Recipe-aware stock tracking, multi-location support, and the “can I make this?” check. One purchase, no subscription. Download the free 30-day trial.