Avant OneAvant One℠
  • Pricing
Sign InRequest a Demo
Back to the blog

Stock-Taking That Actually Reconciles (Nigerian Retail)

A stock count that does not reconcile tells you nothing. How Nigerian retailers run counts that produce a usable variance number instead of an argument.

Most retail stock counts in Nigeria produce a number nobody trusts. The count finishes, the variance looks alarming, somebody says the system is wrong, somebody else says the staff are wrong, and the figure gets quietly adjusted until it stops being embarrassing.

A count that ends in an argument has cost you a weekend and told you nothing. Here is what separates one that reconciles from one that does not.

The count is not the hard part

Counting is easy. The hard parts are everything around it.

You cannot count a moving target. If the shop is trading while you count, the count is wrong before you finish. Either close for the count, or freeze movement per section and count section by section — but a count taken across an open trading day on a single sheet will never reconcile, no matter how carefully people count.

The unit has to match. A crate of 24, a pack of 6, a single bottle. If purchasing buys in crates, the counter sells singles, and the count sheet says "cartons", your variance is a units problem pretending to be a theft problem. Fix the unit of measure before you count anything, and decide which unit the system holds as its base.

Two people, one responsibility. Whoever is accountable for the stock should not be the only person who counts it. This is not an accusation; it is how every workable control environment is built.

Full counts versus cycle counts

The annual full count is the one everyone knows and the one that works least well. It is disruptive, it takes a weekend, it produces a variance so large and so late that nobody can trace what caused it, and by the time you have investigated, the stock has moved again.

Cycle counting is almost always better. Count a slice continuously rather than everything occasionally:

Stock group Count how often Why
Fast-moving, high-value (airtime, premium spirits, phone accessories) Weekly Highest shrinkage exposure and fastest movement
Dated goods (dairy, drugs, baked goods) Weekly or fortnightly Expiry is a loss even with zero theft
Mid-range general lines Monthly Reasonable exposure, manageable effort
Slow-moving and bulky Quarterly Low movement, low risk

The arithmetic that matters: a weekly count on your top 200 SKUs surfaces a problem within seven days of it starting. An annual count surfaces the same problem up to a year later, by which time the cause is unknowable and the cash is gone.

Set a variance threshold before you count

Decide in advance what counts as a real discrepancy. Without a threshold, every count becomes a negotiation.

A workable approach: variance within a small tolerance on fast-moving low-value lines gets recorded and accepted; anything above tolerance, or any variance at all on high-value lines, gets investigated before the system is adjusted. The threshold should be in naira as well as units, because 2% of a bulk-rice line and 2% of a premium-spirits line are not the same event.

Never adjust the system to match the count without recording why. An adjustment with no reason attached is how a persistent leak becomes invisible — the numbers agree every month and the stock keeps disappearing.

Four things that produce phantom variance

These look like theft and usually are not:

  • Transfers in flight. Stock sent from one branch and not yet received at the other is counted nowhere, or counted twice. Multi-branch retailers lose more count accuracy to this than to anything else.
  • Goods received but not entered. A delivery accepted at the back door on a busy Saturday, entered on Monday, counted on Sunday.
  • Breakage and expiry with no write-off. Physically gone, still on the system. This is a process gap, not a loss event.
  • Returns and exchanges handled by hand. A swap that never reached the system leaves the record one unit out in two directions.

Fix those four and the remaining variance is worth investigating. Investigate before you fix them and you are chasing noise.

Expiry is a Nigerian retail problem, not an afterthought

For pharmacy, FMCG, food and drinks, the stock that will cost you money is not the stock that was stolen — it is the stock that will expire before it sells. A count that records quantity but not batch and expiry date tells you how much you have and nothing about how much of it is already a write-off in waiting.

If the system holds batch and expiry, a count also becomes an early warning: this much of this line expires within 60 days, so discount it now rather than writing it off later.

The system has to work when the network does not

A count done on paper and typed up later is two chances to make an error. But a count done on an app that needs connectivity in a warehouse with no signal is worse, because it stops entirely.

The practical requirement is counting offline on a phone, against the expected quantity, and reconciling when the connection returns. Same requirement as the till — in Nigeria this is not an edge case.

Where Avant One Commerce fits

Avant One℠ Commerce holds stock in the units you buy and sell, across every branch and warehouse, with batch and expiry tracking and movement history per SKU. Counts can run per location, transfers between branches are tracked so in-flight stock is not counted twice or missed, and the point of sale keeps working when the network drops so the count is not racing an unrecorded sale.

StockIQ reads your own movement history for reorder and demand signals, which is the other half of the job: knowing what you have is only useful if it changes what you buy next.

For what retail software costs here, see inventory and POS software costs in Nigeria. For choosing a platform, see the best inventory management software in Nigeria.

Frequently asked questions

How often should a Nigerian retailer do a stock count?

Continuously, in slices. Weekly on fast-moving and high-value lines, monthly on mid-range, quarterly on slow-moving — rather than one annual full count that surfaces problems too late to trace.

Should we close the shop to count stock?

Either close, or freeze and count one section at a time. Counting across an open trading day without freezing movement produces a variance you cannot reconcile.

What is an acceptable stock variance?

Set the threshold yourself, in naira as well as units, and before the count. The specific percentage matters far less than having decided it in advance so the count ends in a decision rather than a negotiation.

Why does our stock never reconcile across branches?

Usually transfers in flight — stock dispatched from one branch and not yet received at the other gets counted twice or not at all. Tracking transfers as their own movement, with a dispatched and a received state, removes most of it.

Is a count still useful if we do not track expiry?

Less useful than it looks. You learn how much you hold but not how much is already destined for write-off, which in food, drinks and pharmacy is often the larger number.

Know what is actually on the shelf

Inventory and stock movement across every location with the counter built in — no card terminal and no agency-banking account required.

Request a Commerce demoExplore Commerce
Avant OneAvant One℠

Six products for how Nigerian and African businesses actually run: customer service, sales, HR and payroll, inventory and point of sale, verification, and training. Take the one your team needs.

Platform

  • CX
  • Commerce
  • HR
  • Train
  • CRM
  • Risk
  • Solutions
  • Pricing
  • Features

Industries

  • Banking
  • Insurance
  • Healthcare
  • Telecom
  • Fintech & Payments
  • View all industries

Company

  • About Us
  • Nigeria
  • Case Studies
  • Compare Avant One
  • Start a Free Trial
  • Request a Demo
  • Avant Tech Nigeria

Trust

  • AI & Trust
  • Security & Compliance
  • Read reviews on G2

Resources

  • Blog
  • Glossary
  • Help Center
  • Sitemap
  • Robots.txt

Legal

  • Privacy Policy
  • Terms of Service
  • RCS Messaging Terms

© 2026 Avant Tech. Avant One℠ is a trademark of Avant Tech. All rights reserved.

Sitemap·Robots·Privacy·Terms·AI & Trust·Security & Compliance·Pricing·Help Center