Asset and inventory management: what asset inventory management counts, and where inventory and asset management differ
- Variance in units (negative is a shortfall)
- -86
- What the shortfall cost you to replace
- $1,075
- Count accuracy, percent of expected found
- 96.4
The arithmetic on these sheets is your own count: units, unit cost and reorder point in, variance and value out. Nothing is estimated and no industry average is applied to your numbers. Where a page states an outside figure it names the document it came from and links to it.
Asset inventory management is knowing what you own, where it is, and whether it is still there. For a small business that usually means a list somebody built once and nobody has walked since: laptops that left with a leaver, tools that moved van, spare parts nobody can find so a second one gets bought. The job is not the list, it is the walk that proves the list, and the arithmetic that says what the gap is worth. This page is about doing that walk on a schedule you can actually keep.
Open the Inventory spreadsheet template Free to use. No account, no card, no trial clock.
Draw the boundary before you count
Decide what counts as an asset here: a value floor, or a category such as every powered tool and every laptop. A boundary you can state is the difference between a count you finish and a list that grows until nobody walks it.
Walk it and record what is actually there
Go location by location and enter what you find, not what the list says. The point of the walk is the disagreement between the two, so record the found figure first and reconcile afterwards rather than ticking off a printout.
Price the gap and decide what happens to it
Every line that is missing has a unit cost, so the variance has a value. That figure is what tells you whether this is a rounding error or a control problem, and it is the number worth taking to whoever owns the budget.
Put the walk on a date somebody owns
An asset list decays at the speed of staff changes, so the reconciliation that matters is not the annual one, it is the one triggered by a leaver. Give the walk a date in the calendar and a named owner, and add a rule that anyone leaving hands their line items back before the last day. A quarterly walk with that rule attached finds far less missing than an annual walk without it.
Stock counts: what people ask before the first one
How often should a small business walk its asset inventory? Often enough that a missing item is still traceable to a person or a job. For most small businesses that is quarterly for tools and vehicles-mounted stock, and annually for fixed kit like desks and machines. The schedule matters more than the frequency: a quarterly walk that happens beats a monthly one that does not.
What is the difference between asset inventory and stock inventory? Stock is what you consume or sell and expect to run down; assets are what you keep and expect to still have. They are counted the same way and the arithmetic is identical, which is why Stocktaka holds both, but the reason for counting differs: stock tells you what to reorder, assets tell you what you have lost.
Do I need barcodes to do this properly? No, and for most small businesses barcodes are the thing that stops the project rather than the thing that saves it. A list with a location and a reorder point, walked on a date you keep, is worth more than a barcode system nobody finished rolling out. Add labels later if the count gets too slow to do by eye.
Should assets and consumable stock live in the same list? They can share a tool and should not share a list. The columns differ, the rhythm differs and the question differs: stock asks how many are left, an asset asks who has it. This site holds both because the arithmetic of the count is identical, but the two are kept as separate locations with separate schedules.
Will the Asset inventory management fit what you count?
Tell us what you are counting and how you count it today, and we will tell you whether Stocktaka fits before you pay for anything.