SMEPro
How to Manage Shop Inventory Without Internet: A Practical Guide for Nigerian Retailers
The Three Things Every Inventory System Needs
Whether you're using a notebook, a whiteboard, or an app, every inventory system — no matter how simple — needs to track just three things:
1. **What came in** (stock received from suppliers) 2. **What went out** (items sold or removed) 3. **What's left** (current stock on hand)
If your system tracks these three things accurately, you have real control over your shop. If it doesn't, you're guessing — and guessing costs money.
The Two-Column Count: A Simple Weekly Check
You don't need software to know what's really on your shelves. The **two-column count** is a manual technique many experienced shop owners already use, even if they've never given it a name.
Here's how it works:
1. Take a sheet of paper (or a page in your notebook) and draw two columns for each item: **Expected** and **Actual**. 2. In the "Expected" column, write down what your records say you should have — starting stock plus what came in, minus what you've sold. 3. Physically count the item and write the real number in the "Actual" column. 4. Compare. If the two numbers match, you're clean. If they don't, you've found a discrepancy — while it's still small and easy to trace.
Do this weekly for your fastest-moving or highest-value items, and you'll catch problems long before they become big losses.
Spotting Discrepancies Early — And What Usually Causes Them
A discrepancy is simply the gap between what your records say and what's actually on the shelf. The key to managing it isn't fancy tools — it's keeping a **basic running total**.
Every time stock comes in, add it. Every time you sell something, subtract it. If you do this consistently, your running total should always match a physical count. When it doesn't, the cause is almost always one of three things:
- **Theft** — either from customers or, more commonly, internally - **Miscounting** — human error during a sale, delivery, or stock check - **Spoilage or damage** — especially relevant for perishables or fragile goods
The earlier you catch the gap, the easier it is to figure out which of these three it is — and to fix it before it repeats.
How Often Should You Recount? A Simple Rule of Thumb
Not every item needs the same attention. A good rule of thumb: **the faster an item sells, the more often you should physically recount it.**
- **Fast-moving items** (daily or near-daily sales): count weekly - **Medium-moving items** (weekly sales): count every two weeks - **Slow-moving items** (monthly or occasional sales): count monthly
This way, you're not wasting time recounting things that barely move, but you're staying sharp on the items where a small error can quickly snowball into a real loss.
The Bottom Line
You don't need internet, and you don't need an app, to run tight inventory control. What you need is consistency: track what comes in, what goes out, what's left — and check your numbers against reality on a schedule that matches how fast your stock moves. Get that right, and you'll catch problems while they're still small.
Want this running automatically instead of by hand? See how SMEPro tracks it offline.
[CTA: Start Your Free Trial → -> auth#signup]