Where Did the Stock Go? The Tuesday Morning Count in the Back Room

2026-10-13

Tuesday, 8:20 am. The shutters are still half down, and you're standing in the back room with a clipboard and a cold coffee.

The label says twelve. The shelf says four. The spreadsheet on your laptop, the one you updated on Friday, says nine.

You count again. Four.

Somewhere between Friday and now, five jars of something went out the door, or were miscounted, or were never added in the first place. You don't know which. And in forty minutes, the first customer will ask for exactly that item.

The kind of tired that doesn't show

Let's call her Mara. She is an illustration, not a real person, but you may know her. She runs a small shop with a few hundred items, three suppliers, and a spreadsheet that began as a tidy list two years ago.

Now the file has tabs called "Stock", "Stock NEW" and "Stock final2". Some rows are coloured yellow. Nobody remembers what yellow meant.

Nobody sees the real cost of this. It isn't one big disaster. It's a hundred small ones:

• The reorder you placed a week too late, because you only noticed when the shelf was bare.
• The box of slow sellers you ordered "just in case", still sitting there, holding your money.
• The supplier call where you can't say what you need, only that you need "more of the usual".
• The Sunday evening you spend with a pen, counting, when you wanted to be anywhere else.

Underneath it all sits a quiet, nagging thought: a real business would know what it has.

The phone call that said it out loud

At 10:15, the supplier picks up. Mara asks for a delivery date for the thing she's out of.

"Three weeks," the voice says. "Maybe two, if you order today."

She looks at the clipboard. Three weeks. If she had ordered on the day the shelf was half empty, it would have arrived on time. But half empty is not something her spreadsheet could tell her. It only knew what she remembered to type.

She hangs up and doesn't say anything for a moment. It isn't anger. It's a flat kind of recognition: the problem isn't that she's careless. She's been asking her memory to do a job that a simple system should do.

The small realisation

That evening, on the walk to the tram, she thinks it through.

She doesn't need software with forty menus. She doesn't need a warehouse system built for companies with a night shift. She needs something much smaller:

• One clear list of what she sells and who supplies it.
• A way to note what comes in and what goes out, as it happens.
• A line that says: below this number, it's time to order.

That's most of it. The rest is just seeing it in one place instead of in her head.

It turns out the dread had never been about the counting. It was about not trusting the numbers. Once you can trust the numbers, the counting becomes a quick check instead of a verdict.

A different Tuesday

Picture the same back room a few weeks later.

It's 8:20 am. The coffee is still warm. You glance at one screen and see the handful of items that are running low. Not all four hundred. Just the ones that matter today.

Next to each one is a suggestion, grouped by supplier: this much from the first, this much from the second. You read it, adjust one number because you know a market is coming up, and send the orders before the shutters go up.

The clipboard stays on its hook.

When the first customer asks for that item, you say "yes, it's right here." And if they ask for something that's truly out, you know it, you know when it's coming, and you can say so calmly instead of apologising with your face.

Sunday evening? It's just Sunday evening. Dinner, maybe a film. The stock can wait. It's not going anywhere without you noticing.

Nothing about this makes the business glamorous. It simply makes it quieter. Fewer surprises means more attention for the parts you actually enjoy: the products, the people who come in, the next idea.

If you recognise the back room

If the clipboard, the yellow rows and the "three weeks" phone call feel familiar, there's a gentle next step.

We made the Lagerbestand & Nachbestell-Tracker, a German-language Excel template with an item master list, stock in and out, reorder levels, order suggestions per supplier and a simple dashboard. It comes with sample data, so you can see how it behaves before you put your own items in. It was made with AI, checked automatically and refined by real use. It organises your stock; the buying decisions stay with you.

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

Have a look at the Lagerbestand & Nachbestell-Tracker

An illustrative story, written with AI assistance.