How to start stock records for a small shop

Many people picture stock records as "big software, complicated reports and a separate accountant", and that is why they put it off for years. In a small shop, though, records start with three questions: what is on the shelves now, what sold today and what arrived. If you can answer those three questions the same way every day, you are already keeping stock records.

The whole system in one equation

The heart of stock records is a simple formula: closing stock = opening stock + receipts − sales. Everything else is just a convenient way of writing that equation down.

For example, a 100 g tea pack stood at 40 units in the morning, 60 more arrived during the day and 55 were sold. By evening you should have 40 + 60 − 55 = 45 on the shelf. You count and find 43. So two units are either unrecorded or missing. The job of records is to show that gap on the same day, not six months later.

Step 1: count everything once

After closing, or on a day off, count all your goods and set up a table (Excel or a plain notebook) with these columns:

• item name, always spelled the same way;
• unit of measure: pieces, kg, litres, boxes;
• current quantity;
• purchase price;
• selling price.

Count shelf by shelf, left to right, and mark each finished shelf with a slip of paper so you do not count the same goods twice.

Step 2: record deliveries and sales

Two simple rules are enough. First, when goods arrive you enter them straight away, checking them against the delivery note. Second, sales are entered at the end of the day as one total per item. Take them from till receipts, notebook entries or Telegram orders, depending on where you sell. In a shop that sells 30 to 50 different items a day, this takes 10 to 15 minutes.

Once a week, compare the figures in the table with what is really on the shelf. Even if you start by counting only 10 or 15 key items rather than the whole shop, you will learn whether the system works.

What you will see in the first week

After a week the table starts to show three useful things. First, which goods are running low and when to reorder them. Second, how much money is sitting in the stockroom as goods: multiply quantity by purchase price on each line and add up the results. Third, which items have not moved for weeks. These are small discoveries, but they replace "roughly" and "I feel like" with real figures. Instead of "we probably have enough flour", you can say "12 sacks, about one and a half sacks a day, enough for around eight days", and you order in good time rather than when the shelf is already empty.

The most common mistakes

• One product is written under different names: "Sugar", "Granulated sugar", "Sugar 1 kg". The balance then splits in two.
• Deliveries are left for "later" and forgotten.
• Returned, spoiled or broken goods are not written off.
• The shop stays open during the count, so the figures keep moving.
• Goods taken home or given to relatives never reach the records. That is also an outflow, so enter it on a separate "own use" line.

Conclusion

Do not add extra columns at the start. If your records are simple you will keep them every day; if they are complicated you will drop them after three days. Once you carry several hundred items, add internal codes, minimum stock and expiry dates one at a time. And when Excel stops coping, you can start thinking about software.

Good records are not a perfect system but a simple habit repeated daily. If your balances are already tangled, starting from zero can feel heavy. The AniqHisob team can run a stock count in your shop, confirm the opening balances and leave a clear routine for keeping the records afterwards.