Shop inventory: how to do it 5 times faster with software (practical guide)

Sunday, 7 am. The shop is closed, the whole team is there, with hand-printed sheets. You count, you write, you get the wrong line, you count again. At 7 pm, the counting is done. But the real work begins: copying the sheets into Excel, calculating the values, comparing with the theoretical stock... which is itself wrong. Three weeks later, the result comes in: "about 600,000 FCFA is missing". Nobody knows on which items, or why. And everyone is already dreading the next stock count.

Inventory is the most hated task in retail. Yet it's one of the most useful moments of the year: it's the only time you measure the reality of your stock, and therefore your losses, your theft and the reliability of your figures.

The good news is that the painful part of inventory isn't the counting. It's everything around it: preparing the sheets, copying, calculating, comparing, hunting for discrepancies. And that's exactly what software eliminates.

This guide explains step by step how to organise a fast, reliable shop inventory with software, how to handle discrepancies, and how to move to cycle counting so you never have to endure the "big Sunday" again.

This article follows on from our guide Stock management for shops in Cameroon: the method to stop stock-outs and theft.

Why inventory is mandatory (and useful)

The accounting obligation

OHADA accounting law, applicable in Cameroon, defines a physical inventory as the record of all the company's assets, with their nature, quantity and value at the inventory date. In practice, a physical stock count must be carried out at least once per financial year, at year-end. The text of the Uniform Act is available on the Ministry of Finance website. Your accountant needs it to prepare your financial statements and your DSF: badly counted stock means a wrong result, and therefore wrong tax.

The benefit for your shop

Beyond the obligation, the inventory answers three essential questions:

• How much am I really losing? The gap between theoretical and actual stock is your shrinkage: theft, breakage, errors.
• Are my figures reliable? If your theoretical stock is wrong, so are your restocking alerts.
• What's sitting idle? The inventory reveals items that are damaged, expired or unsold for months.

Why a manual inventory takes so long

Let's break down a "paper + Excel" inventory for a shop with 800 items. The times below are indicative estimates, which vary depending on your organisation:

Three problems emerge:

1. More than half the time isn't counting. It's copying and calculating, which add nothing and create errors.
2. Every copy adds errors. A 6 read as a 0, a shifted line, and the discrepancy you spend hours looking for doesn't exist.
3. The result arrives too late. When you discover a discrepancy three weeks later, nobody remembers anything.

What software changes: inventory in 4 stages

With stock management software, the same inventory follows a different process:

That's 4 to 5 times less time, and above all a result available the same day, while discrepancies can still be explained. Let's look at each step in detail.

Step 1: prepare the inventory (the week before)

Good preparation is half the battle.

Choose the date and time

• Ideally outside opening hours for a full inventory: early morning, evening or a closing day.
• Avoid busy periods (holidays, back to school) and delivery days.
• Let your suppliers know: no deliveries during the inventory.

Tidy up and group items

• Group identical items in the same place. The same product scattered across three aisles is a guarantee that one will be forgotten.
• Set aside damaged, expired or returned items in a separate area: they'll be counted separately.
• Process pending documents: enter all receipts, sales and returns before the inventory. The theoretical stock must be up to date.

Divide the shop into zones

Divide your space into numbered zones: aisle 1, aisle 2, display, storeroom, depot. Each zone will be counted by one team. In the software, each count will be linked to its zone, so you know exactly where a discrepancy is.

Check the barcodes

• Most manufactured products already carry a barcode (EAN). Check that they're recorded in your software.
• For items without a barcode (bulk, local products, repackaged items), print your own labels from the software. It's a one-off investment that will also serve at the till all year round.

Prepare the equipment

No need for expensive equipment: an Android smartphone with its camera is enough to scan. For large volumes, a Bluetooth handheld scanner speeds up counting even further. Charge the phones the day before, and check that the counting app works offline: an outage in the middle of the inventory must not block or lose anything.

Step 2: count (on the day)

Freeze the theoretical stock

When the inventory starts, the software takes a snapshot of the theoretical stock at that precise moment. This is the reference against which the counts will be compared. Some software even lets you count one zone while the shop stays open, freezing only the movements in that zone.

Organise the teams

• Pairs: one counts and scans, the other checks. Two people make fewer mistakes than one, and pairing limits temptation.
• One zone per pair, assigned in the software.
• Mix the teams: avoid having a salesperson count, alone, the aisle they're responsible for day to day.

Count fast and accurately

For each item: scan the barcode, enter the quantity, confirm. The software displays the item's name and photo, which avoids confusion between similar products (two sizes, two scents, two pack sizes).

Good habits:

• Count aisle by aisle, left to right and top to bottom, always in the same direction, so nothing is missed.
• For sealed boxes, enter the number of boxes and let the software convert to units (if the pack size is configured).
• Count damaged or expired items separately, with the reason: they must not be confused with saleable stock.
• Mark finished zones in the software. The manager sees progress in real time.

Track progress

From a phone or computer, the manager can see which zones are counted, in progress or still to do, and which items haven't been counted yet. They can rebalance the teams along the way.

Step 3: handle discrepancies (the same day)

This is where software saves the most time. As soon as a zone is finished, the discrepancy report is available: for each item, the theoretical stock, the counted stock, and the discrepancy in quantity and value.

Sort discrepancies by value

Always start with the largest discrepancies by value. A discrepancy of 2 units on a phone matters far more than one of 20 on bags of sweets. It's the direct application of the ABC method presented in our stock management guide.

Recount only what's problematic

With the manual method, whole aisles are often recounted. With software, you recount only the items with a significant discrepancy, ideally by a different pair. A good share of discrepancies disappear on recounting: an item stored elsewhere, an entry error, a box forgotten in the storeroom.

Look for an explanation before concluding it's theft

For each confirmed discrepancy, check the item's movement history in the software:

• a receipt recorded twice, or not at all;
• a sale entered against the wrong item (two sizes, two colours);
• breakage or expiry never recorded;
• a transfer between shops entered on one side only.

Only once these leads have been exhausted do you talk about unknown shrinkage. And if the same item or the same zone comes up at every inventory, you know precisely where to strengthen controls.

Approve the adjustments

Once the discrepancies have been analysed, the manager approves the inventory. The software automatically adjusts the theoretical stock to the actual stock, recording each adjustment with its reason. This is essential: stock adjustments must always be tracked and approved by a responsible person, never made quietly.

Step 4: value and hand over

The software automatically calculates the stock value at the inventory date, based on the items' purchase cost. The valuation method (weighted average cost or first in, first out, depending on your accounting choice) should be decided with your accountant, then configured once.

You then send your accountant:

• the valued stock statement by item and by family;
• the discrepancy report with the adjustments and their reasons;
• the list of written-down items (damaged, expired, obsolete).

All of this comes out in a few clicks, in Excel or PDF format. Your accountant has nothing left to re-enter.

Moving to cycle counting: the end of the "big Sunday"

The annual inventory remains necessary for the year-end close. But the real revolution is cycle counting: counting a small number of items, regularly, throughout the year.

The principle

Each week, the software suggests a list of 20 to 50 items to count, prioritising:

• A items, high-value or fast-selling, counted most often;
• items whose stock is abnormally low or negative in the system;
• items that showed a discrepancy at the last count;
• items vulnerable to theft (small, expensive, easy to hide).

The count takes 15 to 30 minutes, is done on a smartphone, during quiet hours, without closing the shop.

The benefits

• Discrepancies are detected within days, not at the end of the year. People still remember what happened.
• Stock stays reliable all year round, and so do your restocking alerts.
• The annual inventory becomes a formality: most items have already been checked recently.
• Surprise counts are a deterrent: when everyone knows any item can be counted in any week, "oversights" decrease.

Classic mistakes to avoid

1. Counting during a delivery or a busy period. Ongoing movements distort everything.
2. Leaving documents unrecorded. A receipt from the previous day not entered creates a false surplus.
3. Confusing similar items. Barcode scanning and the item photo eliminate most of these errors.
4. Adjusting without looking for the explanation. Correcting stock without understanding the discrepancy guarantees it will come back.
5. Having an aisle counted only by the person in charge of it. Mix the teams.
6. Waiting weeks to analyse. The point of software is to analyse on the same day.
7. Depending on the internet connection. Choose a counting tool that works offline and syncs afterwards.

Features to demand for your inventories

• ✅ Counting by barcode scanning on an Android smartphone
• ✅ Label printing for items without barcodes
• ✅ Counting by zones with several teams in parallel
• ✅ Snapshot of theoretical stock when the inventory starts
• ✅ Discrepancy report in quantity and value, sorted automatically
• ✅ Targeted recounting of significant discrepancies
• ✅ Movement history per item to explain discrepancies
• ✅ Adjustments approved with reasons by the manager
• ✅ Automatic valuation using the method chosen with your accountant
• ✅ Cycle counts with a count list suggested by the software
• ✅ Offline operation during counting
• ✅ Excel and PDF exports for the accountant

To compare the solutions on the market, see our comparison of the 7 best sales management software in Cameroon. If you manage several shops or depots, or if your items require special handling (retail and wholesale, multiple pack sizes), our article custom or standard software: which should you choose? will help you decide. For budget, see our guide to management software prices in FCFA.

FAQ

Do you need to close the shop to do the inventory? For the full annual inventory, it's preferable: stock doesn't move during the count. For cycle counts, no: you count a few items during quiet hours, and the software handles ongoing sales.

Is a smartphone really enough to scan? Yes, the camera of a recent Android smartphone reads barcodes very well. A Bluetooth handheld scanner becomes worthwhile beyond a few thousand items to count, to go faster.

What about items without barcodes? Print your own labels from the software. You'll use them for the inventory, but also at the till every day, which speeds up sales and reduces errors.

How long does it take to move from a paper inventory to a software inventory? The longest part is the first one: recording the items and their barcodes, and doing a reliable opening inventory. Allow a few days of preparation. After that, each inventory is much faster.

Will the first inventory with software reveal a lot of discrepancies? Often, yes. That's normal: you're measuring reality for the first time. Treat this first result as your starting point, and track how it changes at subsequent inventories.

Conclusion: count for less time, understand more

Inventory doesn't have to be a dreaded annual ordeal. With software, counting is done by scanning, copying and calculations disappear, discrepancies are analysed the same day, and cycle counting keeps your stock reliable all year round. You no longer spend your Sunday counting: you spend an hour understanding where your goods are going.

At Alivaon, in Douala, we design stock and inventory management software built for Cameroonian shops: counting by scanning on a smartphone, label printing, zone and cycle counts, an instant discrepancy report and offline operation. It integrates with your till/POS, your DGI-compliant invoicing and your sales management.

👉 Prepare your next inventory with Alivaon: free demo, reply within 24 hours