Out of Stock Again: Tracking Inventory and Reorder Points in Excel

2026-10-12

It's 7:40 on a Tuesday morning. Your coffee is still too hot to drink, and a new order notification is glowing in the corner of your screen. Twelve of the linen notebooks, the ones people keep reordering.

You already know before you walk to the shelf. You go anyway. Two notebooks sit there, leaning against each other like they're embarrassed.

You open the spreadsheet you made last spring. The cell says 14. The shelf says 2. Somewhere between that number and this shelf, a few orders, a returned box and one Saturday-night restock never made it into the file.

The thought arrives, as it always does: I really should have caught this.

The quiet tax of "I think we have some"

Nobody warns you about this part of running a small business. The products are fun. The customers are kind. But underneath it all sits a low hum of uncertainty: do I have enough?

So you answer it by feel. You glance at shelves. You say "I think we're fine" a lot. You order a bit extra of everything "just in case", and then your cash sits in boxes in the spare room, while the one item that actually sells out is the one you didn't order.

It costs you in small, unglamorous ways:

• The apologetic email to a customer: "Sorry, it'll be two more weeks."
• The rush order from the supplier, with the rush fee you swore you'd never pay again.
• The Sunday evening spent counting boxes instead of resting.
• The faint feeling that a real business would know its own numbers.

None of it is a disaster. That's what makes it so easy to live with. It's just a constant, low-grade tiredness.

The spreadsheet that only works when you're perfect

You did try. Of course you did. There's a file called stock_FINAL and another called stock_FINAL_neu. They started clean and hopeful. Then a busy week came, you skipped three days of updates, and from that point on the file was a historical document rather than a tool.

The real problem was never the effort. It was that the sheet could only tell you what you had, and only if you'd been perfect. It never tapped you on the shoulder and said, this one is getting low, and your supplier takes ten days.

That's the whole difference between a list and a system. A list waits for you to look. A system speaks up before you have to.

The moment it clicks

Picture a different Tuesday.

You're not panicking. You're half-reading a message from a friend, when you notice something in the corner of your inventory file: one row has turned a soft amber. The notebooks. Not empty, not even close. Just time to think about reordering.

You realise you didn't have to remember anything. You didn't count a shelf or do mental arithmetic about lead times. The file noticed, and told you at the one moment when telling you was still useful.

It's a strange, quiet kind of relief. Not excitement. More like putting down a bag you'd been carrying so long you forgot it had weight.

What a normal Monday feels like after

Monday morning, 9:15. You open one file and see one page. A short list of what needs ordering this week. A number for what your stock is currently worth, so you know how much cash is sitting on shelves. Everything else is green, which means everything else is fine.

You place two supplier orders in ten minutes. You don't hover over them. You don't add a "just in case" box of something that hasn't moved since June.

When a customer asks, "Do you have twelve of those?", you can answer in the time it takes to look up. "Yes, they'll ship tomorrow." Or, just as calmly: "Give me until Thursday, a restock is already on its way." Either answer sounds like someone who knows their business, because you do.

On Sunday evening, nobody counts boxes. The spare room is just a spare room again.

It doesn't have to be a big system

Here's the part that surprised us when we thought about it: this doesn't require warehouse software, a monthly subscription, or a weekend learning a new platform. For a small shop, a freelancer selling a few products, or a studio with a stockroom, what matters is a simple setup that is consistent and that tells you when to act. The tool should carry the remembering, so you don't have to.

That's the idea behind the Small Business Inventory & Reorder Tracker we made at blixwerk. It's an Excel file with automatic reorder alerts, stock value and a simple dashboard. It comes with a filled-in sample so you can see how it behaves, a blank template for your own products, and a PDF guide. There's no subscription; you buy it once and it's yours.

If you recognised yourself at 7:40 on that Tuesday, standing in front of a shelf that disagrees with your spreadsheet, you can take a look here:

Small Business Inventory & Reorder Tracker (Excel)

No rush. The notebooks will be fine. But the next time an order comes in, it would be nice to already know the answer.

An illustrative story, written with AI assistance.