Stock Doesn't Match Your Spreadsheet? Shutter at 9:50

2026-10-29

It is 9:50 on a Saturday. The shutter is still down and the lights are half on.

You stand in front of the board-game shelf with your laptop balanced on a crate of shrink wrap. The spreadsheet says you have eleven copies of the cooperative one with the lighthouse on the box. You count the shelf. Four. You check behind the till and under the counter. You even look in the stockroom, in case you moved them and forgot.

Still four.

Seven copies are missing, and you don't know where they went.

The number you stopped trusting

This is not the first time. Last month it was the card sleeves. The month before, the sheet claimed you had plenty of a puzzle you had definitely sold out of.

So you do what many small shop owners quietly do. You keep two counts. One lives in the spreadsheet. The other lives in your head, and it is the one you actually believe.

That works until it doesn't. Today a customer is coming at ten to pick up a birthday gift she reserved online. You said yes because the sheet said yes.

You stand there with a small, cold feeling in your stomach. It isn't panic. It's the feeling of not being able to rely on your own records.

What it quietly costs

Nobody tells you that a wrong stock number is rarely one big disaster. It is a hundred small taxes.

You reorder something you already have, and cash sits on a shelf for months. You don't reorder something you're almost out of, and a regular leaves empty-handed. You promise a customer something and then write the apologetic message at lunch.

Then there are the Sunday evenings you spend with a pen and a clipboard, counting boxes instead of resting. You tell yourself it's a one-off. It never is.

Underneath it all sits a quieter thought: a real shop would know what it has.

You do run a real shop. But the sheet makes you feel like you're guessing.

The customer at the door

At 10:02 she taps on the glass, holding a paper bag with a bow already on it. You unlock the door and smile, because that is the job.

Then you tell her the truth, because it's easier than the alternative. You say the reserved copy is there, and you have it in your hands. What you aren't sure about is the other one she asked about, for her brother.

She shrugs and says that's fine, she'll take whatever you have. She is kind about it.

You watch her walk out and realise the stress was never really about her. It was about the sheet, and the fact that you couldn't answer a simple question quickly: what do I have, and what should I order?

The small turning point

Around noon, in the gap between customers, you open the spreadsheet and look at it properly.

You don't see a mistake. You see a pattern. Sales are typed in sometimes. Deliveries are typed in sometimes. A return got entered twice. A bundle was sold as one thing and counted as three. The numbers aren't wrong because you're careless. They are wrong because the sheet was never built to be a calm place to keep them.

That is a relief, in a strange way. It means the problem isn't you.

It also means it can be fixed. Not with a bigger, scarier system or a monthly subscription, but with something simple. One place for what comes in and what goes out, a number that updates itself, and a quiet signal when something is running low.

That is about all it takes. You don't need to be an organised person. You need a setup that keeps up with you.

A different Saturday

Picture the same morning a few months from now.

You arrive at 9:30 and make tea. You open one sheet, and it matches the shelf. You don't count anything. You just glance, the way you'd glance at a clock.

One line is highlighted, telling you the lighthouse game is getting low. You send the supplier an order over your coffee, and it takes less time than finding a pen.

At ten, the shutter goes up. A customer asks if you have a certain puzzle. You say "let me check", and you check, and you give an honest answer in five seconds. Not hopeful, not apologetic, just certain.

Sunday evening is yours. The clipboard stays in the drawer.

The shop is the same size and the stock is the same stock. What's changed is that your head is quieter. You're no longer carrying the second count around.

If this sounds like your Saturday

If you read this and thought "that's my shelf and my sheet", a plain Excel tracker might be the next step. We made one for exactly this: Never Sold Out by Surprise – Inventory & Reorder Tracker. It comes with reorder alerts, stock value and a simple dashboard, plus a sample version to look at and a blank one to make your own. There is a short PDF guide, and no subscription.

It comes with a 30-day money-back promise: if it doesn't help, you get a full refund, no questions.

You don't have to fix everything this week. But the next time you stand in front of a shelf and the number doesn't match, it's worth knowing it doesn't have to stay that way.

An illustrative story, written with AI assistance.