Stock Count App: Stop Manual Errors and Missing Items

How to count stock using your phone or notebook

An app to count stock is a tool that allows you to record the quantity of every item in your shop to ensure your physical goods match your records. You can use your smartphone to scan barcodes or manually enter numbers to track items like bags of rice, cartons of milk, or beauty products in your store.

Stock counting, or stocktaking, is the process of physically verifying the quantities of all items you have for sale. In busy markets like Alaba in Lagos, Makola in Accra, or River Road in Nairobi, losing track of even a few items can quickly eat into your monthly profits. This guide explains how to perform an accurate count today using simple methods.

How to organize your shop for a count

Before you even open an app or pick up a pen, your shop must be organized. A disorganized shop leads to double-counting or missing items entirely. Follow these steps to prepare:

• Group similar items: Place all 1kg detergent brands together. Do not have some on the front shelf and some hidden in the back store if you can avoid it.
• Clear the aisles: Make sure there is enough space to move. In a small kiosk or container shop, this might mean moving some crates outside temporarily during the count.
• Label your shelves: Even if it is just a piece of masking tape with a name, labeling helps ensure you are recording the count for the correct product.
• Separate damaged goods: If a bag of flour is torn or a tin of tomato paste is dented, move it to a 'damages' section. Do not count it as sellable stock.

5 steps to perform an accurate stock count today

You do not need expensive equipment to start. You can use a notebook, a basic spreadsheet on your phone, or a dedicated application. Here is the process to follow:

1. Choose your counting time

Never try to count stock while customers are buying. You will get confused and lose track of what was sold mid-count. The best time is early in the morning before the market opens, or late in the evening after you have locked up. In Nigeria, many shop owners use 'Sanitation Saturdays' or public holidays for full counts.

2. Use the 'Two-Person' rule

If you have a shop assistant, work together. One person should be the 'Counter' who physically touches and counts the items. The other should be the 'Recorder' who writes the numbers down. This reduces the chance of the counter forgetting the number while reaching for a pen.

3. Count in one direction

Start from the entrance and move clockwise around the shop. Go from the top shelf to the bottom shelf. Once a shelf is finished, mark it with a small piece of paper or a chalk mark so you know it has been handled. This prevents you from skipping a section or counting the same crates of soda twice.

4. Record the unit of measure

Be very specific. Are you counting individual sachets, or are you counting full cartons? If you have 5 full cartons and 4 loose sachets, record it exactly like that: '5 Cartons + 4 Units'. In Ghana and Nigeria, where 'breaking bulk' is common, this is the only way to stay accurate.

5. Compare with your sales records

Once the physical count is done, compare it to what your records say you should have. If your records say you should have 50 loaves of bread but you only count 45, you have a 'shrinkage' problem that needs investigation.

A worked example for your shop

For example, let us look at a shop owner in Nairobi selling bags of sugar. The owner started the week with a certain amount of stock and recorded every sale.

• Opening Stock (Monday morning): 100 bags (1kg each).
• Stock Received (Tuesday delivery): 50 bags.
• Total stock to account for: 150 bags.
• Sales recorded (Monday to Saturday): 120 bags.
• Expected Closing Stock: 150 - 120 = 30 bags.

On Sunday morning, the owner performs a physical count. They find 28 bags on the shelf. The owner now knows there is a discrepancy of 2 bags (30 expected minus 28 counted). This could be due to theft, unrecorded sales, or giving out a bag on credit without writing it down. In local currency, if each bag is 200 Ksh, the owner has lost 400 Ksh in profit that week. Doing this math regularly helps you spot these leaks before they become a crisis.

Common stocktaking mistakes to avoid

Even the most careful shop owners make mistakes. Here is how to spot and fix them early:

• Forgetting the back store: Many owners count what is on the shelves but forget the stock sitting in the overhead loft or the back room. Always check every corner of your premises.
• Counting items in transit: If you have paid for a delivery of 10 bags of cement but they are still on the truck or at the depot, do not include them in your physical count until they are inside your gate.
• Ignoring 'Goods on Credit': If a regular customer took a carton of milk on credit but it hasn't been paid for, that carton is no longer on your shelf. If you didn't record the credit sale, your count will look wrong.
• Guessing numbers: Never look at a stack of crates and say 'that looks like ten.' Physically touch every crate to ensure the ones at the bottom are not empty.

Moving from paper to a digital app

While a notebook is a good start, it becomes difficult to manage as your business grows. Writing down 200 different items every week takes hours and leads to human error in the math. This is where using a digital tool becomes helpful. You can see your profit and stock levels instantly without using a calculator.

One option for business owners who want to move away from manual counting is AurionBook, a SaaS application for small and medium business owners in Africa to manage sales, track inventory, calculate profits, and monitor debtors.

Regardless of whether you use a notebook or an app, the most important thing is consistency. Set a schedule—whether it is daily, weekly, or monthly—and stick to it. Knowing exactly what is on your shelves is the only way to grow a profitable business in Nigeria, Kenya, or Ghana.