The short answer

Replace the yearly shutdown count with cycle counts: count a small part of the warehouse every working day, so every bin is counted several times a year. Freeze only the bins being counted, for the few minutes it takes, after posting every move that touches them. Count blind, recount lines outside tolerance, and post each approved difference as a stock adjustment at cost.

Key takeaways

  • Rank items into A, B and C classes; 1,200 bins counted monthly, quarterly and twice a year means 23 bins a day.
  • Start with a daily target your team can always meet, since a small daily count beats a postponed large one.
  • Give counters the bin and the item, not the expected figure, and ask for one stated unit.
  • Have someone who did not count approve it, with a reason for every difference.
  • Count each van’s stock at the end of every day, before the cash, so a shortage is found the same day.

Why the shutdown count is the wrong tool

A full count once a year means closing the doors, paying overtime and counting in a rush. The result is one accurate day, followed by eleven months of drift that nobody sees. When the count finally shows a large shortage, it is too late to find out when or why it happened.

Cycle counting turns the problem around. You count a small part of the warehouse every working day, so every bin is counted several times a year, and each difference is fresh enough to trace.

Decide what to count, and how often

Not every bin deserves the same attention. Count most often where errors cost most: fast movers, high-value items, items that are easy to confuse, and anything that has shown differences before. Slow, cheap items can wait. A simple way to start is to rank items into three classes and give each class its own cycle.

TipStart with a daily target your team can always meet; a small count done every day beats a large one that keeps being postponed.

Freeze the bin, not the warehouse

Warehouses close for a count because of cut-off: if goods move while you count, the book figure and the shelf figure describe different moments. You get the same accuracy by freezing only the bins you are counting, for the few minutes it takes to count them.

  1. Post every receipt, pick and transfer that touches the bin before you start.
  2. Take the book quantity for the bin at that moment.
  3. Hold picks and put-aways for that bin until the count is entered.
  4. Count, enter the result, and release the bin.
  5. Count early in the day or between picking waves, when the bin is quiet.

TipIf a pick is urgent while a bin is frozen, post the pick first and count the bin after it, rather than letting stock move mid-count.

Count blind, by unit and by lot

Counters who can see the book quantity tend to find it. Give them the bin and the item, not the expected figure, and compare afterwards. Ask them to count in one stated unit, pieces or cartons, so a carton of 24 is never entered as 24 cartons.

For lot-tracked goods, count each lot separately and note its expiry date. A bin that is right in total but wrong by lot will still send the wrong carton out next week.

Recount before you approve

Set a tolerance for each class, then send any line outside it for a second count by a different person. Most large differences turn out to be a miscount, a carton in the wrong bin, or a receipt nobody posted. A recount finds these before they reach the books.

Approval should sit with someone who did not count, and every difference should carry a reason. A count approved without reasons tells you the stock is wrong but not why.

TipTrack count accuracy as the share of counted lines within tolerance: if 46 of 50 lines match, accuracy is 92%.

Post the difference, then find the cause

Once a count is approved, post the difference as a stock adjustment at cost, so the shortage or surplus shows in the books in the month it was found. Do not carry it on a spreadsheet until year end.

Then look for the pattern. Repeated differences on one item usually come from a process, not from theft, and fixing the process is what makes the next count clean.

  • Picks entered in cartons that left as pieces, or the reverse
  • Returns put back on the shelf without being received
  • Transfers or van loads moved but never posted
  • Receipts put in a different bin from the one recorded
  • Damaged goods thrown away without an adjustment

Vans and branches count too

Every place that holds stock needs a count cycle, not only the main warehouse. Branch warehouses can follow the same class plan on a smaller scale. In van sales, count the van’s stock at the end of every day before the cash, so a shortage is found on the day it happens and the rep can still explain it.

Checklist: Cycle count checklist

  • Rank items into A, B and C classes
  • Set a daily count target the team can meet
  • Post every move for a bin before counting it
  • Hold picks on the bin until the count is entered
  • Count blind, in one stated unit
  • Count lot-tracked items lot by lot
  • Recount every line outside tolerance
  • Approve with a reason for each difference
  • Post adjustments in the month they are found

In Axon Suite

How Axon Suite handles it

Axon Suite opens a count for a whole warehouse or a single bin, and only one open count can cover the same stock. Counters enter what they find against what the books held when the sheet was filled, a reviewer with the Approve level on cycle counts approves it or sends it back with a reason, and closing posts the differences as one stock adjustment at cost. A lot- or serial-tracked item cannot be closed without its lot or serial number on the line.

Feature

Cycle counts that post the difference

Open a count for a warehouse or a single bin and fill the sheet from what the books hold. Counters enter what they find, a reviewer approves, and the difference posts as one adjustment at cost.

Open: Cycle counts that post the difference
Feature

Stock on hand at any day’s close

Pick a date and Axon Suite rebuilds stock on hand as it stood at that day’s close, from the movements themselves. Narrow it by warehouse, category or item, and open the stock card to see every movement behind the figure.

Open: Stock on hand at any day’s close
Feature

Buy by the carton, sell by the piece

Each item keeps its stock in one base unit and has its own conversions to every other unit it is traded in. A line in cartons lands in stock as pieces, and the numbers always agree.

Open: Buy by the carton, sell by the piece
Feature

Five costing methods per item

Each item carries one of five costing methods: weighted average, FIFO, first expiry (FEFO), standard or specific cost. Every issue is valued by that method and posted to the ledger, and voiding a document reverses it at the cost it was recorded at.

Open: Five costing methods per item

Before you go

Questions owners ask

Do we still need a full count at year end?

Many auditors accept a well-run cycle count programme in place of a full count, but ask yours before you drop it. Keep the record of every count, recount and approval to show them.

How long should one bin count take?

A few minutes for most bins. If counts take much longer, the bin holds too many items or lots, and splitting it helps both counting and picking.

Who should approve differences?

Someone who did not count and does not run that shelf, usually a supervisor or the finance team, with the right to approve given by role rather than by job title.

Glossary

Terms in this guide

Open the glossary

See your own van sale reach the ledger in 30 minutes.

Chat on WhatsApp