公開日
How to do a warehouse stocktake: a step-by-step guide
Plan, count and reconcile a warehouse stocktake without losing days of trade, plus how cycle counting keeps stock right between full counts.
A stocktake is a physical count of the stock in your warehouse, checked against what your records say you have. In Australia many businesses do a full stocktake around the end of the financial year on 30 June, and 3PLs often count for clients on request. Done badly, it shuts the warehouse for a weekend and still leaves numbers nobody trusts. Done well, it is quick and the differences are small enough to explain.
Full stocktake or cycle count?
| Full stocktake | Cycle count | |
|---|---|---|
| What is counted | Everything, in one go. | A small set of locations or products at a time, on a rolling schedule. |
| Disruption | Usually stops receiving and dispatch while you count. | Little: counts fit around normal work. |
| How often | Once or twice a year. | Daily or weekly, so every location is counted several times a year. |
| Best for | Year-end figures and resetting a warehouse with poor records. | Keeping records accurate all year and catching problems early. |
Most well-run warehouses do both: cycle counts all year, and a full count when the accountant or a client needs one.
Before the count
- Pick a date and tell clients and carriers when receiving and dispatch will pause.
- Process every open inbound and outbound so the system is up to date.
- Tidy the floor: put away loose stock, label unlabelled cartons, and move returns and damaged stock to their own area.
- Check every location has a readable label, and every product has a barcode.
- Split the warehouse into zones and assign a pair of counters to each.
- Decide how to count cartons and inners so everyone counts in the same unit.
During the count
- Freeze stock movements in the counted area.
- Count blind: counters see the location and product, but not the quantity the system expects. Showing the expected number makes people find it.
- Scan the location, then each product, and enter the quantity. Scanning stops counts being recorded against the wrong item or shelf.
- Count each location once, and mark it done so nobody counts it twice.
- Record batch numbers and expiry dates where you track them.
After the count: reconcile
Compare the counted quantity with the system quantity for each location and product. Recount anything that differs before you change a record, ideally with a different person. Many differences turn out to be stock in the wrong location rather than missing stock: the total for the product is right, but it sits on the next shelf.
For what is left, find the cause: a pick from the wrong location, an inbound received short, a damaged item thrown out without a record, or a unit-of-measure mix-up between cartons and units. Then adjust the records, and fix the process that caused it so it does not happen again.
Stocktake and the end of the financial year
For tax, Australian businesses generally need to know the value of their trading stock at the end of the income year, and can value each item at cost, market selling value or replacement value. Small businesses may be able to use simplified trading stock rules, which can mean no stocktake is needed when the change in stock value over the year is small. Check the current ATO rules with your accountant before you plan a count around them.
Make the next stocktake easier
- Scan every movement, so stock rarely ends up somewhere the system does not know about.
- Run cycle counts, starting with fast movers and high-value items.
- Keep one location per pallet or bin, and label everything.
- Use a WMS that counts by location and lists the differences for review.
In EZwarehouse a stocktake can cover a whole warehouse or part of it. Staff count with a phone or scanner, the system compares counted and expected quantities by location, and the differences are listed for review before anything changes. See inventory tracking.
よくある質問
How often should a warehouse do a stocktake?
Most businesses do a full stocktake once or twice a year, often around 30 June, and cycle count a few locations every day or week in between.
What is a blind count?
A blind count is when counters are not shown the quantity the system expects. They record what they actually see, which gives a more honest count.
Can we keep shipping during a stocktake?
With a full stocktake it is safest to stop movements in the area being counted. With cycle counting you only freeze the few locations being counted, so the rest of the warehouse keeps working.
What is an acceptable stocktake variance?
It depends on your products and value, but every difference should have a reason. Recount first, then look for the cause before adjusting the record.