Does every stocktake eat a full day, and does the register still never match what’s on the shelves? The cause usually lies in how the process is set up, not in how well the person running it plans. Here are the basics, five concrete ways to speed things up, and which method suits which situation.
Plenty of companies spend an entire day on their equipment stocktake. Laptops, monitors, tools, cameras, furniture: the more items you manage, the bigger the job of checking the register against what’s actually there.
Most of that time, though, isn’t lost in the counting itself. It comes from how records are kept day to day and how the count is organized. This article covers the basic stocktake process, then walks through concrete ways to cut the time it takes and compares the main methods and where each one fits.
An equipment stocktake is the process of going through your register (the list of what you own) and confirming, item by item, that each piece of equipment is physically there. Unlike a stocktake of goods for sale, it has no direct link to revenue. It is, however, the foundation for knowing accurately what the company owns.
It serves three main purposes.
Some companies run stocktakes as part of asset management for accounting. But even from a day-to-day operations point of view, a stocktake is well worth doing. When the register drifts away from reality, waste builds up quietly: equipment that should be there can’t be found, so someone buys another one, and items that were never returned go unnoticed.
The basic process is simple.
These four steps are the same whether you have 50 items or 5,000. The trouble is that, in practice, steps 3 and 4 balloon out of control.
On paper, the steps don’t look hard. Stocktakes still become a dreaded annual event because three conditions are built into the way most teams work. How well the person in charge plans the day matters less than you might think.
Registering newly purchased equipment gets put off. So does removing items that were thrown out. When you’re fitting it in around everyday work, that’s just what happens. Before long, the register reflects how things looked six months or a year ago.
Start a stocktake in that state and the job stops being a check and turns into rebuilding the register. For every item you look at, you have to find out whether it was in the register and whether the model number is right. No wonder it takes so long. In effect, you are catching up on a whole year of maintenance in a single day.
Equipment gets lent out, taken off-site, and moved between departments and locations. Yet the register usually only records where an item was when it was first entered.
As a result, nobody on the floor can tell whether an item they couldn’t find is really lost or just borrowed. “Sales probably took it.” “Maybe it went to last month’s trade show.” The time spent going around asking about each hunch adds up, and it can end up taking longer than the checking itself.
You tick boxes on a paper list out on the floor, then go back to your desk and type it all into Excel. Doing the work twice doubles the time, every re-entry introduces copying errors, and you often don’t notice missed items until the next day or later.
If several people share the work, someone also has to merge everyone’s files. “Person A’s list hasn’t come in yet.” “Two people checked the same item.” Sorting that out means there’s still another round of work waiting after the physical count is done.
You can go in determined to finish faster this year, but as long as these three conditions are in place, the time it takes won’t change much. Address them, and the time drops noticeably.
The heavier the stocktake, the more likely an organization is to try to fix it by adding people on the day. But extra hands only speed up the physical count. They do almost nothing for tracking down discrepancies or updating the register. The biggest opportunities lie before and after stocktake day, not on the day itself.
Here are five concrete ways to cut the time a stocktake takes. You don’t need to adopt them all at once. Each one helps on its own.
Whether a stocktake goes well is mostly decided before it starts. To keep the day focused purely on checking, get these four things done first.
The fourth point is often overlooked, yet it has a big effect on accuracy. If one person counts an item as present because the box is there and another opens the box to check the contents, the same stocktake ends up mixing records made to different standards, and you can’t trust the discrepancies you find later. Deciding in advance how to handle borderline cases (for example, whether an accessory counts as a separate item) also keeps people on the floor from getting stuck.
Having everyone check everything looks thorough, but in practice it creates both duplicates and gaps. In any area where everyone assumes someone else has looked, it can turn out that nobody did.
Divide the space into areas by floor, room, or shelf, and assign each one to a single person (or a fixed pair). It becomes clear who checked which area, and tracing a missed item becomes easy. When you draw the areas, split them by walking distance rather than item count. That tends to even out how long each person takes.
If you work in pairs, having one person read items aloud while the other records them keeps things moving. If you use the scanning approach described next, though, one person can handle it alone and there’s no need to pair up.
The surest way to eliminate re-entry is to finish the record right where you check the item. Put QR code or barcode labels on your equipment, scan them with a smartphone to mark them as checked, and you no longer need paper or a separate round of typing into Excel. By the time you’ve made one pass through the site, the record is already complete.
Scanning has side benefits too. When people record by eye and by hand, they mix up items with similar model numbers or check the same item twice. Reading a code identifies each item uniquely. Who checked it and when is also recorded automatically, so nobody has to figure out later whose record is whose.
Labels aren’t only for stocktakes. They also work for recording check-outs and check-ins and for building up a usage history. If you think of them as something you put on just for the stocktake, they feel like a chore. Put them on first as your everyday recording tool, and the stocktake becomes a by-product of labels that are already there.
The biggest time sink in a stocktake is the moment someone says “one item is missing” and everyone starts searching. Checking stops, people from other areas get pulled in, and the whole count ends up 30 minutes behind because of that one item.
When an item can’t be found, just record it as unconfirmed and leave the search for later. Once every area has been checked, go through the unconfirmed list in one go. A good number of those items will turn out to have been found in another area or to have been checked out all along, and the number you actually need to search for should be much smaller.
If you’ve produced an accurate list of discrepancies, you can consider that day’s stocktake a success. You don’t have to take on finding every last item the same day. If you have an accurate picture of what’s really there, the stocktake has done its job.
Counting every item in a single day once a year is the hardest approach because a whole year of discrepancies builds up. For gaps that go back a year, there may no longer be anyone at the company who remembers what happened.
Split the scope and rotate through it (say, meeting rooms and loan equipment this month, tools and furniture next month), and each round becomes much lighter. When discrepancies do turn up, they’re recent, so the cause is easier to pin down, and the register never drifts far from reality.
Even if you keep a full annual count for accounting reasons, adding a quarterly check of just your high-value items and the ones that leave the building most often will visibly reduce the discrepancies you find on the day. The full count itself also no longer involves rebuilding the register; it becomes a matter of checking.
There are three broad ways to run a stocktake. Which one suits you depends on how many items you have, how many locations, and how often you count.
| Method | Accuracy | Time required | Setup cost | History kept |
|---|---|---|---|---|
| Visual check + paper list | Depends on the checker’s focus. Missed items and double counts are common | Long (checking on the floor, then re-entering) | Almost none. Print the list and start | Only the paper. Comparing with past counts is manual |
| Excel register | Depends on data entry rules. Filters and formulas make discrepancies easy to find | Medium (notes on the floor, entered later in bulk) | Low. You can start with an existing file | Traceable if you keep a file per count. Lost if you overwrite |
| Barcode/QR + dedicated system | High, because each item is identified uniquely | Short (what you record on the floor is the result) | Takes effort to apply labels and do the initial registration | Checker, date and time, and result are stored automatically |
The biggest advantage of a visual check with a paper list is that you can start the same day you decide to. If you have a few dozen items all kept in one place, it works perfectly well. The downsides are that results live only on paper, so it’s hard to look up how last year went, and that errors creep in during re-entry. The more items you have, the more the re-entry outweighs the checking.
An Excel register lets you total and filter, which makes finding discrepancies far easier. It costs nothing extra, so for many companies it’s the practical choice. Where it tends to break down is conflicts when several people edit at once, and the habit of falling back on smartphone notes or paper on the floor and typing it all in later. Many teams also end up with files multiplying per person and per count until nobody knows which one is current.
Barcode/QR with a dedicated system comes with the upfront work of applying labels. Whether that feels like a burden is the deciding factor. Once the labels are on, though, checking and recording become one step in every stocktake that follows, and the history builds up by itself. If you have more than 100 items, equipment spread across locations or rooms, or frequent lending, the upfront effort pays for itself early on.
See what checking with QR labels looks like in the actual app.How QR label printing and scanning workIf you’re considering a dedicated system, don’t compare feature lists. Picture what will actually happen on stocktake day as you compare, and you’re less likely to choose badly. There are four criteria.
Stocktakes happen out in warehouses and offices. If you need dedicated handheld scanners, or an app has to be installed and set up on every device, every extra helper on the day means more preparation. Whether people can work from the browser on their own smartphones makes a real practical difference.
For area assignments to work, everyone’s records need to land in the same place in real time. If each person keeps a separate file to be merged later, the merging comes back as a new burden. Check that the system is designed so records don’t conflict when people work simultaneously.
What you need at the end of a stocktake is a list of discrepancies: what was found and what wasn’t. It also matters whether the tool shows what share of all items has been checked (coverage). With that, you can see mid-count which areas haven’t been touched yet and decide how to spend the time left.
Bring in a tool used only for stocktakes, and you end up with a system people touch once a year, and every stocktake starts with relearning how it works. If the system you already use to record check-outs and check-ins also handles stocktakes, the register stays current and the stocktake becomes a full review of records you keep anyway. That takes care of the first two of the three reasons described earlier.
Here is one example of an equipment management system whose stocktake features are built to meet these four points.
Werp™ is a cloud-based equipment management system that runs entirely in the browser. There’s no app to install, and you run stocktakes from the same screens you use to register, book, and lend equipment.
In stocktake mode, you mark items as found by scanning them or ticking them off. Your team can work at the same time, so there’s no need to split files by person and merge them later. When you finish, you get a discrepancy report listing found and missing items, along with the share of all items that were checked (coverage rate).
Day-to-day check-outs and check-ins run on the same register, so the step of rebuilding the register for a stocktake disappears entirely.
If your current register lives in Excel, you can bring it in as is with CSV import. Rather than switching the whole company over at once, a more realistic approach is to run a single stocktake in one area first and see whether the flow of the day works for your team.
The Free plan needs no credit card and has no time limit.Try a stocktake on the Free planThree things turn stocktakes into a heavy annual chore: the register isn’t updated day to day, equipment movements aren’t recorded, and you check in one place and record in another. The work itself is just comparing the register with what’s physically there. At heart, it’s a simple job.
The way to speed it up lies in how you organize it, not in adding people on the day. Prepare ahead to reduce the work on the day, assign areas to owners, record on the spot, follow up discrepancies in one batch afterward, and split the scope into regular rounds. Even adopting these five one at a time will steadily cut the time it takes.
There’s no single right method. With a few dozen items in one place, a paper list works fine. Excel works well too, as long as people stick to the entry rules. Once your item count grows, lending and moving equipment becomes routine, and you need to keep a history, that’s the time to consider labels and a system. The test is whether the method matches your item count and how often you count, and whether you can keep doing it the same way next year.
Set up in 5 minutes. Free forever — no credit card required.