Guide · stock control for small businesses

How to do a stock count

A stock count (a stocktake, or physical inventory count) is counting what is really on the shelves and comparing it with the quantity in your records. Each difference becomes an adjustment, so the records are right again and the value of the stock is true.

Prepare → count in pairs → recount the big differences → find the cause → adjust

Full count or cycle count

Most shops still use a physical inventory system that just reconciles stock to actual counts at the end of the financial year. That is the full count: everything, on one day, often with the shop closed.

Probably the most common and necessary stock control is cycle counting, which is the regular counting of small parts of the inventory and the investigation of the reasons for any errors found. The two methods work well together.

Full countCycle count
What is countedEvery item, at onceA few items each day or week
How oftenOnce a year, often at the year endAll year; each item several times
The shopClosed or quiet for a dayStays open
Errors foundUp to a year after they happenedWithin weeks, when the cause is still easy to find
Best forA small stock, the year-end figure for the accountsMany items, steady record accuracy

How to do a full stock count, step by step

Before the count

  1. Enter every document. Tell everyone that all shipping and receiving documents from the day before the count must be forwarded to the office that day, for immediate data entry. A delivery that is on the shelf but not in the records shows as a difference that is not real.
  2. Stop the movement. Goods that arrive during the count wait in a marked area and are entered after it. Count when there is no significant activity in the shop, such as during a weekend.
  3. Tidy up. Consolidate items stored in several places, which eases the counting task. Put open boxes together and mark damaged goods.
  4. Divide the shop. A physical inventory count is usually taken by using a tag affixed to each shelf; give each team a map of the shop with the section that they are responsible for counting.

During the count

  1. Count in pairs. A team of two people is assigned a part of the shop for counting, one person counting and the other writing the count on a tag.
  2. Count blind. Give the counters a list of items and places, but not the quantities in the records. A counter who knows the expected number tends to find it.
  3. Check the units. Have an experienced person verify all units of measure. A box of 12 entered as 12 boxes is an error of 132 units.
  4. Count the empty places too. An item with zero in the records can still be on a shelf, and an item with stock in the records can be gone.

After the count

  1. Recount the big differences. When the count and the record differ by more than your tolerance, send a second team. The obvious next step is to recount the item to see if there was a counting mistake.
  2. Find the cause. If a counter finds a large difference, its cause must be investigated and fixed, so that the mistake will not occur again. If everyone thinks an item count is low, the answer may just be that it was never received. Look also for sales that were not recorded, returns put back on the wrong shelf, and theft.
  3. Adjust the records. Enter the counted quantities. There is also an accounting entry to record any quantity adjustments found during a physical count: the missing units, at their cost, lower the profit of the period.

Cycle counting: count a little every day

Which items, and how often? ABC analysis is an inventory management technique that can become useful here. The counts should focus on high-value or fast-selling goods, although the entire stock should be reviewed regularly. Cycle counters may only need to count for a short period each day; over the year, each item has then been counted and checked several times.

Worked example: a cycle count plan for 1,200 items

ClassItemsCounts a yearCounts
A (top 10 % by sales value)120121,440
B (next 20 %)2404960
C (other 70 %)84021,680
Total1,2004,080

With 250 working days, that is 4,080 ÷ 250 = 16.3, so about 17 items a day: half an hour for one person. Every A item is checked each month, and the shop never closes for a count. Get the class of each item from the ABC analysis tool.

Worked example: the result of one count

ItemRecordCountedDifferenceUnit costValue
Paint roller 25 cm646403.200.00
Wood screws 4×40, box219212−74.50−31.50
Masking tape 25 mm140141+11.10+1.10
Step ladder, 3 steps99038.000.00
Drill bit set2522−312.00−36.00

The net difference is −66.40 at cost. Record accuracy is the share of counted items whose record matches the count within your tolerance. With a tolerance of 2 %, three of the five items pass (the tape is 1 in 140, 0.7 %): an accuracy of 60 %. Without a tolerance, two of five match exactly: 40 %.

The screws are 3.2 % short and the drill bits 12 %. Recount both. If the recount agrees, look for the cause before you adjust: a drill bit set that sells for many times its cost is the kind of item that walks out of a shop.

Five mistakes that spoil a stock count

  1. Counting while goods move. A delivery put on the shelf during the count is counted, but its receiving is entered later, so the item shows a surplus that is not real.
  2. Estimating instead of counting. Counters may estimate the number of items in a box rather than counting each item, because of the time needed to make a detailed count. Count it, or weigh it.
  3. Adjusting without a cause. An adjustment makes the record right today. Only the cause makes it stay right.
  4. Counting once a year only. Errors build up for months, and nobody remembers the delivery that was never entered. The errors in the records will be quickly detected during cycle counts and cleared out of the system.
  5. Mixing up similar items. Two sizes of the same screw give one item too many and the other too few. The counts will be much more accurate if an experienced person identifies the items being counted.

Stock counts in Golden Inventory System 5

In System 5 a stock count is a document for one location. Each line has the item and the counted quantity.

Questions

How often should a small business count its stock?

A full count once a year, for the year-end accounts, and cycle counts in between: the A items monthly, the B items quarterly and the C items twice a year.

How long does a full stock count take?

It depends on the number of items and the number of people. Count a sample of 50 items first and time it, then multiply: that gives the hours, and the number of teams you need to finish in one day.

Do barcode scanners help?

Yes. Bar coding is the most reliable and error-free way to inventory data collection: a scan does not misread an item code, and it does not swap two sizes of the same product.

Can I skip the yearly full count?

A yearly physical inventory count can be dropped if accurate perpetual inventory records are kept. Check with your accountant first: some auditors still want a year-end count.

What is a good record accuracy?

Aim for 95 % of items within tolerance or better. Start by measuring it: the first cycle counts usually show a lower figure, and it rises as the causes are fixed.

What do I do with damaged goods found in the count?

Count them apart, then write them off or return them to the supplier. Do not leave them in the sellable stock, or the reorder point will think they can be sold.

Count, approve, and the stock is right

Golden Inventory System 5 is a Windows program that you pay for once: $99 for up to 5 users, $199 for any number. Stock counts, transfers and work orders are in the Stock tab.