If you run more than one crew, you already know the pattern. A saw goes to a site on Tuesday, gets lent to somebody on Thursday, and by the following week nobody can say where it is with any confidence. Eventually you buy another one. Most contractors are not losing tools so much as losing track of them, which costs the same money and feels worse.
What most crews do now, and where each one breaks
Memory
Works up to about a dozen tools and one crew. It fails the moment two people both half-remember the same thing differently, and it fails completely when the person with the memory is on holiday.
A paper sign-out sheet on the container door
Genuinely good while it lasts, which is about a month. It gets rained on, someone takes a tool at 6am without writing it down, and there is no way to answer “where is the plate compactor” without physically walking to the container.
The group chat
Everything is in there somewhere, which is the same as nothing being in there. Try scrolling back four weeks to find who took the laser level.
A plain spreadsheet list
Closer, and this is where most people stop. The problem is that a list tells you what you own, not what is happening. If someone edits the “assigned to” cell in place, last week's answer is gone forever. You need a list and a log.
What you are actually buying when you buy an app
Tool tracking software is a real category and for some outfits it is the right call. Be clear about the trade though, because the price on the pricing page is rarely the whole cost:
- A monthly fee, usually per user. Add the foreman and three crew and a $15/month product is $60/month, forever, whether or not anyone opens it.
- Adoption on a phone, on site. The app only works if a person with cold hands actually opens it before throwing a tool in a truck. This, not the software, is where most rollouts die.
- Signal. Plenty of sites have none. Anything that needs a live connection to record a check-out will quietly stop being used.
- Another login to hand round — and to take back when someone leaves.
The four questions any system has to answer
Strip away the software and this is the whole job. If your method answers these four, it works. If it does not, no amount of features will save it.
| Question | What that means in practice |
|---|---|
| Who has it? | A person's name, not “the north site”. Sites do not lose things; people do. |
| Where is it? | Job site and, ideally, which truck or container. |
| When is it due? | Back on the shelf, or due for service. A generator that dies mid-pour costs more than the service did. |
| What happened? | A dated record. This is the one people skip, and the only one that settles an argument. |
Doing it in a spreadsheet, properly
A spreadsheet is a perfectly good answer for most contractors, provided you set it up to answer those four questions rather than just listing what you own.
1. One row per tool, with these columns
Tag or ID, name, category, make and model, serial number, status, assigned to, job site, location, purchase cost, purchase date, service due. The serial number matters more than people expect — it is what an insurer and a police report both ask for.
2. Give every tool a tag
A number written on the tool in paint pen is enough. 000114 is
unambiguous in a way that “the big Makita” is not, and it makes the
spreadsheet searchable by something people can read off the tool itself.
3. Keep a separate log sheet, and never overwrite history
When a tool changes hands, append a row to a log: date, tool, action, from, to. Then update the status on the main sheet. The list tells you where things are now; the log tells you how they got there. Overwriting a cell destroys the only evidence you have.
4. Make check-out take seconds, not minutes
This is the whole game. If signing a tool out takes longer than walking off with it, people will walk off with it. Whatever you build, the check-out step has to be short enough to do while holding a coffee.
5. Use a barcode, not a description
A tag written in paint pen is fine, but a printed barcode or QR sticker is better, because it removes typing from the one step that has to be fast. A USB barcode scanner costs about $25, plugs into a laptop and behaves exactly like a keyboard — it “types” the tag into whatever field is focused, so it works with any spreadsheet without configuring anything. If your laptop or phone has a camera, most modern browsers can read the code directly with no hardware at all.
This matters more than it sounds. Scanning is the difference between a stock-take being one walk round the container and being an afternoon.
6. Put service dates in the same place
Service is not a separate system. It is a date column on the same row, ideally colour-coded so anything due inside 30 days is obvious without filtering.
The habit is harder than the tool. Every method here works on paper. The ones that survive are the ones where recording a movement is faster than not recording it. Optimise for that above every feature.
When a spreadsheet is genuinely the wrong answer
It would be easy to end by saying a spreadsheet always wins. It does not. Be honest about these:
- Several people need to update it at the same time, from different places. This is the real limit. A shared file syncs; it does not merge two simultaneous edits gracefully.
- You are scanning barcodes at volume across hundreds of items daily. At that point the scanning workflow is the product and you want software built around it.
- You need live visibility — someone in an office wanting to know, right now, what is on which truck without ringing anyone.
If two or three of those describe you, buy the software. If none of them do — and for a lot of contractors running two or three crews, none of them do — you are paying a subscription to solve a problem you do not have.
A ready-made version
Everything above can be built from a blank spreadsheet in an afternoon, and if you enjoy that, genuinely do. We also sell it already built: one Excel file with a dashboard on top that does the check-out log, the service dates, and straight-line depreciation, and runs entirely offline with no account and no monthly fee.
It is $79 once, and there is a live demo you can click through without buying anything or handing over an email address.