Inventory Management Basics for a Small Business

A hardware shop owner once told us his stock register was 'about right'. Then we asked him how many 20mm PVC elbows he had. He walked to the back, came back, and said 'enough'. Enough is not a number, and that is where most small-business inventory trouble starts.

Inventory management sounds like something for warehouses with forklifts. For a shop with three hundred products, it is really just three promises: every item that comes in gets recorded, every item that goes out gets recorded, and once in a while you check the record against the shelf. Break any one of those and the numbers drift.

Start with what you are actually counting

Before any software or spreadsheet, decide what counts as one 'item'. A shirt in three sizes and two colours is either one product or six, and you have to pick. Our rule of thumb: if you would reorder it separately or it sells at a different rate, it is a separate item. Everything else is just a note in the name.

Then decide the unit. Rice is bought in 25 kg bags and sold by the kilo. Cable is bought in coils and sold by the metre. If your purchase unit and sale unit differ and you don't record the conversion, your stock will look wrong from the first week. We go deeper on this in the post on setting up your product catalog.

Record movements, not just totals

The most common mistake we see is typing a fresh closing stock number into a sheet every month. It tells you where you are but never why. If the number is lower than expected, you can't tell whether it was theft, a billing miss, a damaged lot or a wrong entry.

Stock should move because a document moved it. A purchase bill adds stock. A sales invoice or a POS bill reduces it. A sales return adds it back, and a purchase return takes it out again. When every change has a document behind it, a mismatch becomes a trail you can follow instead of a mystery.

• Purchase bill: stock goes up, and the cost price is recorded
• Sale (invoice or counter bill): stock goes down
• Sales return: stock comes back, if the goods are resaleable
• Purchase return: stock goes down, and the supplier owes you credit
• Manual correction: rare, and always with a reason written down

Know your fast, slow and dangerous items

Not every product deserves the same attention. A handful of fast movers usually bring in most of your sales, and running out of them hurts. A long tail of slow items quietly ties up cash. And some items are dangerous in a different way: expensive, small, and easy to walk out of the shop.

Give the fast movers a minimum level and check them often. Check slow ones monthly. Count the expensive small things weekly. You don't need a clever formula, just a different rhythm for different items. The next step after that is setting reorder points, which we cover in low stock alerts and reorder points.

Count the shelf on a schedule

Records drift. Someone gives a customer a free sample, a box gets damaged in the rains, a bill gets made for the wrong size. The only cure is to compare the record with the shelf regularly. Small shops do well with a rolling count: a few categories each week instead of a shutdown for one big stocktake.

1. 1Pick a section, say all electrical fittings, and note the system quantity for each item
2. 2Count the physical quantity without looking at the system number first
3. 3Write down every difference, even a single piece
4. 4Look for the cause before you correct anything: a missed bill, a return, a damaged piece
5. 5Correct the record with a short reason, and fix the habit that caused it

That last step is the one people skip. If you keep correcting the same item and never ask why, you are cleaning the floor while the tap is still running. There is a fuller walk-through in stock audits: finding and fixing mismatches.

Watch the money in your stock

Stock is cash in another shape. Say you buy ₹2,00,000 of goods and only half sell this month. You haven't lost anything, but your bank balance doesn't know that, and the next supplier payment will still be due. Seeing the value of what you hold, at cost, helps you decide whether to buy more or wait. We explain what that number does and doesn't tell you in stock valuation at cost.

In Billy, products and stock sit next to your sales and purchases, with low-stock items and stock value at cost on the same screens you already use for billing. That matters because the best inventory system is the one your staff doesn't have to remember to update; it updates because they billed something.

Keep it boring

Good inventory management is dull. The same person receives goods the same way every time, checks them against the supplier's bill, and only then does the purchase get entered. Sales are billed before goods leave the counter, not after. Returns come back through a document, not through someone's pocket.

If you want your billing and stock set up around the way your shop actually works, including odd units or a long catalogue, we can help through our services page. And if you are just starting, pick three habits from this post, do them for a month, and see how many surprises are left.