Skip to the content

Guide

How to keep stock records for a provision shop

A shop that knows what is on its shelves runs out less often, orders at the right time and can see which goods really make money. Here is a simple way to do it with a pen and a book, and how Jeimba does the same job for you.

Why write your stock down

Without a record, three things go wrong quietly:

  • A fast seller runs out and you only notice when a customer asks for it.
  • Money sits in goods that do not sell, and you cannot see which ones.
  • Goods go missing, and nobody can say when it started.

A weekly count fixes all three. It takes about an hour for a small shop.

What to write for each item

Use one line per item. These six columns are enough. The figures below are examples only.

Example stock record
Item Cost Selling price Reorder at Counted Book said
Rice 5kg bag GH₵ 62 GH₵ 75 5 9 9
Cooking oil 1L GH₵ 34 GH₵ 41 8 6 7
Gari 1kg GH₵ 9 GH₵ 12 10 14 14
Bottled water 750ml GH₵ 2 GH₵ 3 24 30 36

"Counted" is what you find on the shelf. "Book said" is what your record says should be there. When the two differ, as with the cooking oil and the water above, you have found something to look into.

The weekly count, step by step

  1. Pick one day and time, for example Monday before you open. Keep it the same every week.
  2. Count one shelf at a time. Finish a shelf before you start the next.
  3. Write the number you counted next to what the book says.
  4. Where they differ, write why. Common reasons: sold but not written, broken or spoiled, taken for home use, counted wrong.
  5. Correct the book to the number you counted.
  6. Circle every item at or below its reorder level. That is your shopping list.

If goods leave the shop for your own home, write them down as own use. Otherwise they look like missing stock.

How to set a reorder level

Ask two questions: how many do I sell in a day, and how many days does my supplier take to deliver?

Say you sell about 2 bags of rice a day and your supplier delivers in 3 days. You will sell about 6 before new stock arrives. Add a few spare for a busy day, and reorder when you have 8 left.

Fast sellers need a higher level. Items that sell once a month need a low one. Change the levels when you see you ran out, or when stock piled up.

Deal with slow stock

If an item has not sold for a month or two, money is sitting on your shelf. You have three choices: sell it at a smaller profit, put it with a fast seller as a pair, or stop ordering it. Check the expiry date on food and drinks first.

Mistakes to avoid

  • Counting only when stock feels low. Count on a fixed day, even when things look fine.
  • Writing a delivery days later. Write it when it arrives, with the cost you paid.
  • Having one person receive goods, sell them and count them with nobody checking. Let a second person do the count now and then.
  • Leaving the book at home. Keep it at the shop.

How Jeimba does this for you

Jeimba is a till, a stock book and a set of reports in one place. When you record a sale, it takes the item off your stock. When goods arrive, you add them. Every morning it shows what is running low, using the reorder level you set for each item.

  • A stock-take screen where you type what you counted. It shows the difference, so you do not do the sums.
  • It works on a phone, a tablet or a computer, and keeps selling when the internet is off.
  • If you have more than one shop, each has its own stock.

One shop is free, with no card needed. The free plan holds up to 10 products; if you stock more, you can choose a paid plan later. Your records stay either way. Jeimba helps you keep records, but the counting and checking are still yours to do.

Common questions

How often should I count my stock?

Count everything once a week, on the same day and time. Count the fast sellers, like water, bread and cooking oil, more often, because they run out first.

Do I need a computer to keep stock records?

No. A book and a pen work. A phone is enough if you use an app. The important part is the weekly count, not the tool.

My count never matches my book. Is that normal?

Small differences are normal at the start. Write down the difference and the reason each week. If the same item is short again and again, look at who handles it and how it is recorded.

What is a reorder level?

It is the number at which you order more of an item. Set it so that you do not run out before the new stock arrives.

Let Jeimba keep the count.

Free for one shop, no card needed. Upgrade when you need more.