Plan the count

Decide four things before anyone picks up a scanner.

  • The date. Pick a quiet day. Not the week after a sale.
  • Freeze or not. If you stop selling and packing while you count, the numbers cannot move. If you keep trading, count one shelf at a time and finish each shelf before the next one is touched.
  • Who counts what. Give each person whole locations, not half a shelf. One name per location.
  • What counts. Everything you own and could sell: shelves, returns, goods waiting to be packed. Stock held for a customer is still yours until it leaves.

Full count or rolling counts

A full count covers every location in one go. It is simple to explain and gives you one clean number on one day. It also takes the whole team off normal work.

Rolling counts (also called cycle counts) cover a few locations each day or week, so every location is counted in turn. Each count is small and you find problems sooner. Start with the shelves that hold your fastest sellers and your dearest items.

Many small sellers do both: rolling counts through the year and one full count at the year end.

Count by location

Count location by location, not product by product. Walk the shelves in order and you cannot miss a bin or count it twice.

  1. Give every shelf or bin a code and a printed label. Shelves with no label get missed.
  2. Scan the location label.
  3. Scan each product you find there, or type its SKU. Set the quantity you can see.
  4. Count what is on the shelf, not what the screen says. Cover the screen if it helps.
  5. Put loose items back in the right place before you move on.

Recount the differences

Compare your counts with your records. Where they differ, send a second person to count that location again. Do not show them the first count.

Most differences go away on the second look: a box on the wrong shelf, a pack of ten counted as one. Only the differences that survive a recount are real.

Fix the numbers

Now change the records to match the shelf. Keep a trail: what the record said, what you counted, who counted, and the date. A correction with no trail is a number nobody can trust later.

Find out why they were wrong

Correcting the number is half the job. A difference will come back unless you find the cause. Look at the movements for that product and ask:

  • Was a delivery booked in with the wrong quantity?
  • Was an item picked from a different shelf from the one the system sent you to?
  • Was a return put on a shelf without being booked in?
  • Was stock moved between shelves and not recorded?
  • Was it damaged, binned or given away without a record?

Fix the habit that caused it, not only the count.

What your accountant needs at year end

Your accounts need a figure for the stock you hold on your year-end date. Give your accountant the count, the date you counted and the value.

HMRC accepts the lower of cost and net realisable value as a basis for valuing stock. It describes net realisable value as the estimated selling price less the costs to complete and sell. It says net realisable value may be less than cost because of deterioration, obsolescence or changes in demand. So value your stock at what it cost you, and tell your accountant about anything damaged, out of date or unlikely to sell at its cost.

Ask your accountant how they want the list. By product, with quantity and unit cost, is usual.

Doing it in Zobook

Fast Counting is the count screen. Scan the location label (or type the code), and the location’s current stock appears. Scan each product, or search by SKU or barcode, and set each quantity with minus and plus. Choose the condition when you count graded stock. Then “Confirm & Store Count” writes the difference as count and adjustment movements and sets the quantity at that location. “My Recent Activity” lists your recent counts.

To see what a shelf holds without changing anything, scan it, read the list, then cancel.

The Locations page lists every shelf or bin in every warehouse and shop. Search part of a code, and open a location to see its current stock. You can create locations one at a time or in ranges, such as rows 1 to 10 and shelves A1 to A7.

Location Labels prints barcode labels for locations to a Zebra label printer. Filter by Printed or Unprinted, and print one, several or all unprinted. The cards show how many locations are printed.

After a count, open the product and its “Sales & stock in / out” history. It has a Stock checks card with the net correction for the dates you choose, and each stock check row shows the location and what was counted. The warehouse movement log shows every move with the date, quantity, locations and who did it. That is where you look for why a count was wrong.

Questions

How often should I do a stock-take?

There is no single right answer. Count often enough that a difference is still easy to trace. Rolling counts on your busiest shelves each week, and a full count at your year-end date, suit many small sellers. Ask your accountant about the year-end date.

Can I count while I am still trading?

Yes, if you count one location at a time and finish it before stock moves. Do not count a shelf while someone is picking from it. If the numbers must be exact on one day, stop picking and packing while you count.

Who should do the count?

Pick careful people who know the stock. If you can, have the person who recounts be someone other than the first counter, so the same mistake is not made twice.

What should I do with damaged stock?

Count it separately from good stock and keep a note of it. Tell your accountant. HMRC says stock may be worth less than cost because of deterioration or obsolescence, and then it is valued at net realisable value.

Sources

Prices

Starter

£49 a month
or £490 a year

For a small business with one stock room.

  • Up to 3 users
  • 1 warehouse
  • 2 sales channels
  • Up to 1,000 orders a month
Start free trial

Scale

£449 a month
or £4,490 a year

For busy teams with many warehouses.

  • Up to 25 users
  • All your warehouses
  • All sales channels
  • Up to 15,000 orders a month
Start free trial

Prices are per month and exclude VAT. Every plan starts with a 30-day free trial. Pay yearly: 12 months for the price of 10.