How to manage your business's inventory: the practical guide to stop losing money

Managing inventory is solving a simple tension: having enough not to lose a sale, without having so much that you tie up money on the shelf. Everything else — spreadsheet, system, counting — is a tool to manage that tension. Whoever manages well knows, at any moment, what they have, what's selling, and what to restock before it runs out.

The good news is you can start without spending anything, with method and a spreadsheet. The bad news is that as the business grows, manual control starts failing at predictable points — and that's where ignoring the problem gets expensive. This guide covers the whole path: what to measure, how to organize, the mistakes almost everyone makes, and the clear sign of when to stop patching and move to something automated.

Start with the basics: you don't manage what you don't know

Before any tool, you need three pieces of information about each item you sell: how much you have, how much sells per period, and how long it takes to restock. Without these three numbers, any control is guesswork.

How much you have is the physical count — what's actually on the shelf, not what you think is there. How much sells is the sales pace: how many units per week or per month. How long to restock is the time between ordering from the supplier and receiving. With these three, you can already answer the question that matters: when do I need to reorder so I don't run out?

If you don't have these numbers today, that's the first job — before thinking about a system.

Organize by importance: not every item deserves the same attention

A common mistake is treating all products the same. In practice, a minority of your items accounts for most of your revenue — and that's where control needs to be rigorous. High-turnover, high-margin items deserve frequent counting and can never run out. Low-turnover ones can have looser control.

Split your products into three groups: the ones that absolutely can't run out (high turnover or high margin), the intermediate ones, and the long-tail ones (sell little, take up space). This keeps you from spending equal energy on an item that sells a hundred a month and one that sells two — and avoids the worst: letting the best-seller run out.

The numbers that tell you if your stock is healthy

A few simple indicators show whether control is working, without needing a system to calculate:

Inventory turnover is how many times you "turn over" the stock in a period. High turnover means the product sells fast — money circulating. Low turnover is money sitting on the shelf. You don't need the exact formula to start; you need to know which items turn fast and which are stuck.

Reorder point is the level at which you need to buy again. It depends on how much sells per day and how long it takes to restock. If an item sells five a day and the supplier takes ten days, you need to buy before reaching fifty units — otherwise you run out while waiting for delivery.

Stockout is when it runs out — and it's the most expensive indicator, because every stockout is a sale that went to a competitor. Idle product is the opposite: what's been sitting too long without selling, tying up capital. Good control keeps both low at the same time.

The mistakes almost everyone makes

A few holes show up in almost every business managing inventory by hand:

Trusting memory instead of counting. "I think there's still some" is the source of most stockouts. What counts is the counted number, not the impression.

Not deducting at the moment of sale. If you sell and only update control at the end of the day (or week), there's a window where the system says there's stock when there isn't. This leads to selling a product that's run out — and a frustrated customer.

Counting everything at once, now and then. The annual full count is tiring and error-prone. Better is rolling counts: counting a small group of items at a time, frequently, prioritizing the ones that turn most.

Mixing physical and online stock without integration. Whoever sells in-store and also online, with separate controls, almost always ends up selling online something already gone from the store. Both channels need to see the same number.

Spreadsheet or system: when each one serves

At the start, a spreadsheet works — and recommending an expensive system to someone with few items would be pushing a solution. A well-made spreadsheet, with the three basic numbers and the reorder point, manages a small, simple-operation business well.

The problem isn't the spreadsheet itself; it's what happens to it as the business grows. A spreadsheet doesn't warn you when an item hits the reorder point — you have to remember to look. A spreadsheet doesn't deduct on its own when you sell — it depends on someone entering it, without error, every time. A spreadsheet doesn't sync store stock with online sales. And when two people edit at the same time, control is lost.

Each of these failures costs a lost sale or a product sold that no longer exists. At the start, the cost is small. As volume grows, it stops being small.

The clear sign the spreadsheet has become the bottleneck

You don't need to guess when to change. There are concrete signs: you've already sold what you no longer had more than once; the count never matches what the spreadsheet says; you waste too much time updating by hand; the physical store and online sales live out of sync; or you simply no longer trust the number in there.

When these signs appear, the problem has stopped being "choosing the right spreadsheet" and become "the operation grew beyond what manual control can handle." Then a system that deducts automatically, warns at the reorder point, and keeps physical and online in sync stops being a luxury and becomes what keeps you from losing money every month.

Where Dilevate comes in

Most inventory management doesn't need us — it needs method, and much of this guide you apply on your own. Where we come in is at the point where manual no longer copes: when your operation has a rule of its own that off-the-shelf systems don't respect, when physical and online need to see the same stock in real time, or when you need a dashboard showing turnover, stockouts, and reorder without calculating by hand.

We build this kind of custom system — and the difference is that we understand the operation behind it, because we were in it for about ten years before developing software. It's not just making the system deduct; it's understanding how your inventory actually behaves. If manual control is already costing you sales, it's worth a conversation to see what makes sense in your case.