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 → adjustMost 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 count | Cycle count | |
|---|---|---|
| What is counted | Every item, at once | A few items each day or week |
| How often | Once a year, often at the year end | All year; each item several times |
| The shop | Closed or quiet for a day | Stays open |
| Errors found | Up to a year after they happened | Within weeks, when the cause is still easy to find |
| Best for | A small stock, the year-end figure for the accounts | Many items, steady record accuracy |
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.
| Class | Items | Counts a year | Counts |
|---|---|---|---|
| A (top 10 % by sales value) | 120 | 12 | 1,440 |
| B (next 20 %) | 240 | 4 | 960 |
| C (other 70 %) | 840 | 2 | 1,680 |
| Total | 1,200 | 4,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.
| Item | Record | Counted | Difference | Unit cost | Value |
|---|---|---|---|---|---|
| Paint roller 25 cm | 64 | 64 | 0 | 3.20 | 0.00 |
| Wood screws 4×40, box | 219 | 212 | −7 | 4.50 | −31.50 |
| Masking tape 25 mm | 140 | 141 | +1 | 1.10 | +1.10 |
| Step ladder, 3 steps | 9 | 9 | 0 | 38.00 | 0.00 |
| Drill bit set | 25 | 22 | −3 | 12.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.
In System 5 a stock count is a document for one location. Each line has the item and the counted quantity.
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.
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.
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.
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.
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.
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.
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.