Warehouse and Stock Management: Simple Systems

A small shop's two classic pains are each other's opposites: "the customer wanted it, turns out it was out of stock" (the lost sale) and "the warehouse is full, the money sleeps" (dead capital). The two's shared cause is the same: the stock is managed "by feel." The owner's memory is not a system; especially as the range grows.

Stock management looks like a complex corporate topic; in fact for a small business it is three simple questions: what is there (the exact balance), when to order (the minimum threshold) and what is not moving (the dead stock). This article builds that trio along the road from spreadsheet to software.

Level 1: The smart spreadsheet (0 cost, this week)

For a start, Google Sheets is fully sufficient; the condition is structure: each product one row (the SKU/code, name, purchase price, sale price, current balance, minimum threshold, supplier), every movement logged (an in/out sheet; the balance computed by formula, not written by hand) and a colour signal (conditional formatting: balance ≤ minimum → red). Even a system this simple solves two big pains: the "is it in stock" question gets answered in seconds and the ordering moment sits in plain sight. The SUMIFS family is the daily bread here.

The minimum-level rule: the system's heart

Every product must have one number: when the balance falls below it, place the order. The simple calculation: the average daily sales × the lead time (days) × a safety factor (1.3–1.5). An example: a product selling 2 a day, arriving in 10 days → the minimum ≈ 2×10×1.4 = 28 units. The formula is not perfect (it knows neither the season nor the campaign), but it is far more precise than "feel" — and most importantly: it takes the ordering decision out of daily deliberation and turns it into a rule. Adjusting the factor by season on seasonal goods is normal practice.

Level 2: Software; when and which?

The spreadsheet's boundaries are known: multi-channel selling (the shop + the marketplace + Instagram) cannot keep the balance in sync, the barcode/speed need arises, and errors grow when the team works in parallel. Those are the switch signals; the address is three classes: the till-accounting systems (in the local market, solutions merged with the NKA; retail's natural road), the e-commerce platforms' stock module (if the selling is online) and the standalone inventory programs (for multi-channel sync). The selection criterion is not the feature list but integration: does it talk to your sales channels and your till? A system that does not talk begets a second "hand spreadsheet."

The stocktake: the ritual of reconciling with reality

The number in the system and the count on the shelf drift apart with time (errors, damage, loss); the stocktake is that drift's measure. The workable rhythm for a small business: a full count quarterly/annually (scale-dependent) + periodic partial counts (one category each week; the "cycle count" approach; continuous small accuracy instead of one day's great torment). The discrepancies journal matters too: where is the loss (the category, the period)? A repeating pattern is a process problem; the entrance of the fix map.

Dead stock: the silent money-eater

Goods unmoved for months are a double cost: the tied-up money + the space/aging. The management rules: the age report (a list by last-sale date; possible in the spreadsheet too), the movement categories (A: fast, B: normal, C: slow; the ordering behaviour per category) and the exit plan (for the Cs: bundle offers, discount windows, campaign material). A psychological note: selling dead stock "at a loss" feels heavy; but the sleeping money's opportunity cost (the fast goods not bought with it) is usually bigger than the discount's loss. Look with numbers, not feelings.

Sources and further reading

Where to verify the source

For the till-accounting integration requirements:

• The State Tax Service: the NKA-accounting link

Continuing the topic

The operations line's neighbouring articles:

• Order management
• The online register and POS
• Choosing delivery
• Sheets: the starting tool
• Other articles on this topic

This weekend's two-hour investment: the spreadsheet structure + a minimum threshold for every product. From Monday, the "is it in stock" question and the ordering panic become the system's work; your work is selling.