Skip to content

How to Do Stock Taking in a Shop: A Practical Guide for Nigeria

Learn how to do stock taking in a shop: full and cycle counts, count sheets, variance checks and common mistakes, so your stock records match the shelf.

By Ajinex Team · · 8 min read

In this article

Learning how to do stock taking properly is the difference between knowing your business and guessing at it. Every shop owner in Nigeria has a number in their head for what the shop is "worth" in goods. Very few have counted it.

Stock taking is simply counting what you physically have and comparing it to what your records say you should have. The gap between the two numbers is where your money is leaking: unrecorded sales, breakages, expired goods, supplier short-deliveries, and sometimes theft.

This guide walks through the whole process for a supermarket, provision store, pharmacy, boutique or spare-parts shop: how to prepare, how to count, what to do with the differences, and how often to repeat it. It works whether your records are in a notebook, a spreadsheet or inventory software.

Full count or cycle count?

There are two ways to count, and most shops need both.

A full count means closing the shop, or working before opening, and counting every single item. It gives you one clean, complete picture and a reliable stock value for your accounts, but it is disruptive and tiring.

A cycle count means counting a small section of the shop regularly, say 15 to 30 products every week, so that over a month or a quarter everything has been counted at least once and the important items several times. The shop stays open and you catch problems within days instead of months.

Full count Cycle count
How much is counted Everything A section or a list of items
How often Quarterly or at year end; monthly for pharmacies and electronics Weekly
Shop open? No, or before opening Yes
Best for Stock value for accounts, resetting after a bad period, handing over a shop Catching losses early, keeping records accurate between full counts
Who All staff plus owner One trusted person, rotated

A sensible rhythm for a small Nigerian shop: a weekly cycle count of fast movers and high-value items, and a full count every quarter. If you have never counted at all, start with a full count this month to set a baseline.

Preparing for a stock count

A badly prepared count produces numbers nobody trusts. Spend the day before on preparation.

Tidy and group the stock

Put the same items together, open half-sold cartons so you can count pieces, and move everything from under the counter to its proper place. Separate damaged, expired and display-only stock into its own area; you will count it, but it must not be mixed with sellable goods.

Freeze the records

Choose a cut-off moment, usually close of business the day before. Record every sale and every delivery up to that moment. Do not receive new goods during the count; if a supplier arrives, leave the delivery sealed and count it separately as "received after cut-off".

Prepare count sheets

Print or write a sheet listing every product, in the order it sits on the shelf, with a blank column for the count. If you use software, print the stock count sheet from the system.

Assign people and areas

Divide the shop into zones: shelf one, shelf two, fridge, store room, counter. Give each zone to a pair, one counting and one writing. Nobody counts the area they normally manage alone.

Decide on a blind count

In a blind count the counter does not see the expected quantity, so they cannot be tempted to write what the book says. Use them for anything expensive or easy to pocket.

Count sheet template

Here is a layout you can copy into a notebook or spreadsheet, one row per product.

SKU Product Unit Expected Counted Variance Cost price Variance value Counted by Notes
PK-MLK-400 Peak milk 400g Tin 72 69 -3 ₦2,100 -₦6,300 Chidi / Amaka 1 dented tin set aside
PAR-500-PK Paracetamol 500mg Pack 150 150 0 ₦450 ₦0 Ngozi / Tunde
HD-WIG-12 Human hair wig 12" Piece 8 7 -1 ₦38,000 -₦38,000 Owner / Amaka Investigate

Rules for filling it in:

  • For cartons, write the maths: "3 cartons × 40 + 17 loose = 137", not just "137".
  • Variance is counted minus expected. Negative means stock is missing; positive means you have more than the records say, which is also a problem.
  • Variance value is variance × cost price. This column tells you where to spend your attention.

If you use software, the sheet is produced for you, you type or scan in the counted quantities, and the variances and values are calculated automatically. In Ajinex the stock count tool also records who counted, when, and the adjustment that was posted, so the audit trail is kept.

The counting itself

  • Count in pairs. One counts aloud, one writes, both initial the sheet.
  • Count from left to right, top to bottom, in the same direction on every shelf, so nothing is skipped.
  • Use a barcode scanner if you have one; it is faster and removes transcription errors.
  • Do not estimate. If a shelf of sachets looks like "about 200", count it. If it is genuinely impractical (a sack of rice sold by the cup), weigh it and convert.
  • When a zone is finished, the owner or manager recounts five random items from it. If two or more are wrong, the zone is counted again.

A 300-product shop with two pairs of counters typically finishes in two to three hours. A 2,000-product supermarket is a full day with four to six people.

Investigating variances

The count is not the point. What you do with the differences is the point.

Sort by value, not by quantity

Sort the sheet by variance value and work from the top. The top ten lines usually hold most of the money.

Recount before you accuse

The most common cause of a variance is a counting or writing error. Recount every item with a significant variance before doing anything else.

Then check the paper trail

For the variances that remain, work through the usual suspects in order:

  1. Sales not recorded. Check the sales records and receipts for that product around busy days.
  2. Deliveries not recorded, or short-delivered. Compare supplier invoices to what was booked in.
  3. Returns, breakages, expiries and samples not recorded. Ask staff; often nobody wrote it down.
  4. Unit confusion. A carton booked as one piece, or a piece booked as one carton, produces large, strange variances that look like theft and are not.
  5. Transfers to another branch that were not recorded at one end.
  6. Theft. When everything above has been ruled out, especially for small, high-value items, this is what remains. Our guide on How to Prevent Staff Theft in a Shop covers how.

Adjust the records and write down why

Once you are satisfied, adjust the book or system to the counted quantity and record the reason next to each adjustment. In six months you will want to know whether that -₦38,000 was breakage or something worse. Software keeps this as a movement history with the user and the reason attached.

How often should you count?

  • Weekly cycle counts of 15 to 30 items: top sellers, high-value items, anything that was wrong last time, plus a few random picks.
  • Monthly full counts for pharmacies and chemists (expiry dates and PCN inspections make this worth it), electronics and phone accessory shops, and any shop with recent losses.
  • Quarterly full counts for most general retail, boutiques and provision stores.
  • Always before you hand a shop to a new manager, before you sell the business, at your financial year end, and after a flood, fire or burglary.

Common stock taking mistakes

  • Counting with the shop open and no cut-off. Sales made during the count make every number wrong by an unknown amount.
  • Letting staff count their own area alone. Not because everyone is dishonest, but because the count then proves nothing.
  • Writing the expected quantity as the count. This is why blind counts exist.
  • Ignoring positive variances. More stock than expected usually means a sale was recorded against the wrong product, so another product is short somewhere.

What changes when you use software

The method does not change; the labour does. The count sheet is generated from the product list, expected quantities come from a system that already knows every sale, purchase, return and transfer, and barcode scanning replaces writing. Variances and their values are calculated instantly, sorted, and posted as stock adjustments with a reason and the name of the person who made them. Multi-branch shops count each branch separately and the owner sees all of them on one dashboard. Investigating a variance means opening the product and reading its movement log, not digging through a notebook.

That is why shops that move from paper to software usually move from an annual count to weekly cycle counts: it stops being a chore. The stock count and audit features are described at Stock management software for shops and warehouses in Nigeria, pharmacies should look at Pharmacy software for pharmacies and patent medicine stores in Nigeria for expiry tracking that fits into the count, and if you are still deciding between a spreadsheet and software, Ajinex vs Excel: why shops in Nigeria outgrow spreadsheets sets out the trade-offs.

Stock taking also feeds your accounts: the closing stock value from a full count is what turns sales and purchases into a real gross profit figure. In a combined system like Ajinex the adjustment posts to the books automatically. The wider routine around counting, recording sales and reorder levels is in How to Manage Inventory for a Small Business in Nigeria.

Frequently asked questions

How do you do stock taking in a small shop?

Prepare the day before by tidying the shelves, separating damaged goods and recording all sales and deliveries up to a cut-off. Print or write a count sheet listing every product. Count in pairs before opening, write the physical count next to each item, then compare to the expected figure, recount anything with a large difference, investigate what is left, and adjust your records with a written reason.

What is the difference between a stock take and a cycle count?

A stock take, or full count, counts every item in the shop at once, usually with the shop closed. A cycle count counts a small group of items every week while the shop stays open, rotating through everything over a month or quarter. Full counts give you a complete stock value; cycle counts catch problems early. Most shops should do both.

What is stock variance and what causes it?

Stock variance is the difference between the counted quantity and the quantity your records expected. Common causes, roughly in order, are counting errors, unrecorded sales, unrecorded or short deliveries, unrecorded breakages and expiries, confusion between cartons and pieces, unrecorded branch transfers, and theft. Recount first, then check the paper trail, before concluding anything.

Can inventory software do stock taking for me?

It cannot count the shelves for you, but it removes most of the paperwork. It generates the count sheet, lets you scan barcodes instead of writing, calculates variances and their value instantly, posts adjustments with a reason and a user name, and keeps a movement history for each product so you can investigate differences quickly.

Next step

Set a date for your first full count this month, and put a weekly 20-minute cycle count in the calendar after it. When you want the count sheets, variances, movement history and audit trail handled for you, start a 30-day free trial of Ajinex at the sign-up page, no card required, or see how the stock audit tools work at Stock management software for shops and warehouses in Nigeria.

Ajinex Team

The people who build Ajinex, writing from what we learn supporting supermarkets, pharmacies, restaurants and wholesalers across Nigeria. Questions? Talk to us.

Chat with support