You own more stuff than you can hold in your head. Stock on shelves, tools in vans, boxes of fittings in the back room. The day you stop tracking it, you start paying for it: the part you rebuy because the first one hid in a drawer, the job that stalls at 2pm because the last box ran out.
More than 40% of small businesses still track inventory by hand. Most of the advice written for them comes from retail software companies and assumes you run a shop with a checkout. This guide assumes less. You have stock, maybe tools, maybe a van or two, and you want to know what you have without losing an afternoon a week to it.
Below: the three ways to track inventory, the honest limits of each, and the time math nobody shows you.
What keeping track of inventory means
Good tracking answers three questions at any moment: what do you have, where is it, and how much is left. Answer those three and the rest follows. You reorder on time, you stop buying duplicates, and your records match your shelves.
Whatever method you pick, the work comes down to four habits:
- A list of every item, with a name your team recognises and a photo where confusion is possible.
- A record of movements. What came in, what went out, who took it.
- A minimum quantity on anything you reorder, so you restock before the shelf is empty instead of after.
- A count on a schedule, to catch the gap between your records and reality before it grows.
The method decides how painful these four habits are. Here are your three options.
Method 1: pen and paper
A whiteboard in the stockroom, or a printed count sheet on a clipboard by the door.
It works when you have under 20 items, one location, and one pair of hands touching the stock. You start today, it costs nothing, and there is no setup to learn.
It breaks when a second person needs the numbers. Paper lives in one spot, updates by hand, and remembers nothing about last month. A coffee spill is a database crash.
Fine for a market stall or your first month. Past that, you spend more time keeping the sheet alive than the sheet saves you.
Method 2: a spreadsheet
One row per item, columns for quantity, location and minimum. Pick Google Sheets over Excel: it saves to the cloud on its own, and your team reads the same file from any device instead of emailing versions around.
It works when you track under 100 items, one or two careful people update it, and your stock moves at a calm pace. With a tidy sheet you run in ten minutes.
It breaks in four predictable ways:
- Typing is the weak link. Every count goes in by hand, and manual entry runs around a 3% error rate. Across a few hundred movements a month, that is real money ordered wrong, counted wrong, or hunted for on a shelf where it never was.
- Two people, one cell. Someone overwrites a teammate's update, and you find out the day the shelf disagrees with the sheet.
- The sheet shows the past. It tells you what stock looked like the last time someone typed, which by Friday is fiction.
- No memory of who and when. When 40 bags become 12, the spreadsheet has no idea who took 28. You get to ask everyone.
The right starting point for most small businesses, and the wrong endpoint for almost all of them. Adopt it with a retirement plan.
Method 3: an inventory app
An app moves the work from typing to scanning. You point your phone at a barcode, the item comes up, you adjust the quantity with a tap. Everyone reads the same live count, from the office, the van or the site.
Accountants call this perpetual inventory: the count updates with every movement instead of waiting for the next big recount. In practice it changes four things:
- Scanning replaces typing. The camera reads the exact code every time. The typo problem disappears rather than shrinks.
- One count, shared. Nobody overwrites anybody. The number on your phone is the number in the warehouse.
- Alerts replace vigilance. Set a minimum per item and the app warns you before you run out. A spreadsheet waits for you to come looking.
- Every movement keeps a name. When something goes missing, you know where to start asking, and people look after what carries their name.
Costs: decent apps start free for small catalogs and run 20 to 50 dollars a month beyond that. Setup is an afternoon: scan or import your items, create your locations, set your minimums. HomyScan works this way, with your phone as the scanner.
The right move past roughly 100 items, two users, or a second location. Below those marks, the spreadsheet holds.
The time math nobody shows you
Vendors say "save time" and never show the arithmetic. Here it is, with the assumptions visible so you can redo it with your numbers.
Say your business logs 60 movements a week. Deliveries in, parts out to jobs, tools taken and returned. A modest, active week. In a spreadsheet, one movement means finding the row, updating the quantity, and noting who took what: about 40 seconds when you focus. By scan, the same movement takes about 5 seconds: point, tap, done.
| At 60 movements / week | Spreadsheet (type) | HomyScan (scan) |
|---|---|---|
| One movement | ~40 seconds | ~5 seconds |
| A week | ~40 minutes | ~5 minutes |
| A year | ~50 hours | ~4 hours |
Your volume differs, so count your own movements for one week and run the math. The gap stays wide at any volume, and it widens as you grow, because typing scales with movements and scanning barely does.
Which method fits you
| Your situation | Use this |
|---|---|
| Under 20 items, one person | Paper, or a simple spreadsheet |
| Under ~100 items, 1-2 careful people, slow-moving stock | Spreadsheet |
| 100+ items, a team, or several locations and vans | Inventory app |
| Tools and equipment that leave with people | App with check-in and check-out |
Two signs you've outgrown your current method
You no longer trust your own numbers, or keeping them costs more than an hour a week. Either one means move up a level.
Set up your tracking in five steps
The setup is the same whatever you picked.
List everything once
Walk the stockroom, the shelves, the vans. Every item gets a name and a quantity. With an app you scan as you walk; with the template you type as you go. Budget an afternoon and bring coffee.
Name items so the newest hire finds them
"DeWalt 18V drill" beats "drill 3". Add a photo where two items look alike. The test: anyone on the team locates any item without asking you.
Set a reorder point on what you consume
The plain-words formula: what you use during the time a new order takes to arrive, plus a margin for bad weeks. You burn two boxes of screws a week and delivery takes two weeks? Reorder at five.
Log movements when they happen
In by delivery, out by job, same day. The habit beats the tool here: a movement logged on Thursday for something taken on Monday is a count you already can't trust.
Count on a schedule
A full stock take once or twice a year, where you close the doors and count everything. Between those, cycle counts: one shelf or one van this week, another next week. Small and often beats one heroic weekend, because you catch errors while they are still small and the business never stops.
Skip the typing with HomyScan
When the spreadsheet starts costing you more than an hour a week, HomyScan turns your phone into the scanner, and the four habits run themselves.
- Scan a barcode to add, find or adjust an item
- One live count everyone shares, no overwrites
- Low-stock alerts before the shelf is empty
- Check-in / check-out so tools come back
- Import your spreadsheet, every row becomes an item
- Works offline; syncs when you reconnect
Questions owners ask
What's the easiest way to keep track of inventory?
For a handful of items, a simple spreadsheet. Past about a hundred items or a second user, scanning with an inventory app takes less of your week than typing into a sheet.
Can I track inventory in Excel or Google Sheets for free?
Yes. A spreadsheet gives you an item list, a movement log and a low-stock view. It holds up to roughly a hundred items and one or two careful users. Past that, the four failure modes above start costing you.
How often should I count inventory?
Cycle counts of one shelf or one location weekly or monthly, and a full stock take once or twice a year. Frequent small counts catch errors early; one annual marathon catches them after they cost you.
What's a reorder point?
The quantity at which you reorder an item: your usage during the supplier's lead time, plus a safety margin. Set one on every consumable and you stop discovering empty shelves at 2pm.
When should I switch from a spreadsheet to an app?
When you stop trusting the sheet, when a second person starts editing it, or when maintaining it eats more than an hour a week. Whichever arrives first.