Tools aren't stock in the usual sense. You don't use them up and you don't reorder them at a level. What you need to know about a tool is which one it is, where it lives, who has it now, and whether it's fit to use. So a tool inventory list has one row for each tool, not for each kind: an ID marked on the tool itself, its home, its condition, who it's checked out to and since when, and the date its next calibration or service is due. The things tools consume, blades, bits and abrasives, are ordinary stock and go on a separate sheet with reorder levels. Below is a list for a made-up workshop, how to run check-out without it becoming a chore, and the file.
The short version
- One row a tool, with an ID engraved or labeled on it.
- A home for every tool: cabinet, drawer, wall rack.
- Checked out to, and since. Cleared when it comes back.
- Condition, with "out of use" for anything unsafe.
- A due date for calibration or service, where a tool has one.
- Blades, bits and consumables go on a stock sheet, not here.
- TaroStack keeps the consumables as stock, by place. More below.
An example list
| Tool | ID | Where it lives | Condition | Checked out to | Since | Service due |
|---|---|---|---|---|---|---|
| Cordless drill, 18 V | T-014 | Cabinet 1 | Good | |||
| Torque wrench, 3/8 in | T-022 | Cabinet 2, drawer 1 | Good | Feb 1, 2027 | ||
| Digital caliper, 6 in | T-027 | Cabinet 2, drawer 1 | Good | R. Akana | Nov 14 | Dec 15, 2026 |
| Angle grinder | T-031 | Cabinet 1 | Guard cracked: out of use | |||
| Ladder, 8 ft | T-040 | Wall rack | Good | Job: Kona site | Nov 10 | Jan 10, 2027 |
Five tools, bought for $507.00. The dates in the last column are this workshop's own schedule.
The ID is what makes it a list of tools and not of tool types. Two identical drills are T-014 and T-015. Engrave it or use a label that survives the work. A list that says "drill" can't tell you which drill is missing.
A home. "Cabinet 2, drawer 1" means anyone can put the caliper back, and anyone can see that it's gone.
Condition. The grinder's row is the one that prevents an injury. A tool that isn't safe gets marked out of use on the list and tagged on the tool, on the same day.
Check-out that people will do
A check-out log fails when it takes longer than the job. Three ways that work in a small shop:
| Method | How | Good for |
|---|---|---|
| The list itself | Type a name and date in the row. Clear it on return | A few people, one shop |
| A whiteboard by the cabinet | Tool ID and name. Wipe it on return | People who won't open a spreadsheet |
| Tags | A tag with the person's name hangs on the tool's empty hook | Shadow boards and wall racks |
Whichever you use, look at it weekly. A tool out for three weeks to "Job: Kona site" is either still needed there or lost there. The ladder in the example has been out since November 10.
Calibration and service
A torque wrench or caliper that's out of calibration gives wrong answers with no sign that anything is wrong. For any tool whose reading you rely on, record when it was last checked and when it's next due, and take it out of use if the date passes. The file's "days until due" column counts down. How often to check is set by the maker's instructions and by any standard or customer requirement you work to. A log for the checks themselves is in scale calibration log, and for servicing machines in equipment maintenance log template.
Consumables are a different list
Drill bits, saw blades, sanding discs, welding wire, fasteners and gloves are used up. They need what any stock needs: a quantity on hand, a level to reorder at and a supplier. Don't mix them into the tool list. A layout is in manufacturing inventory spreadsheet, and setting the levels in reorder point example.
Once a year
Walk the list with the tools in front of you. Every row is either seen, checked out to a name, or written off. Add what was bought and never listed. The value column, what you paid, is what your insurer will ask for after a break-in.
Get the list
Download the tool inventory list. One sheet and a read-me: a row for each tool with its ID, home, condition, who has it, the next service date and the days until it's due. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The tool list holds up well in a spreadsheet, because tools change slowly. The trouble is the other list. Bits and blades leave the cabinet a few at a time, nobody subtracts them, and the job stops on a Friday afternoon for want of a $4 blade. The tools were all accounted for. What they needed to run wasn't.
How TaroStack does it
TaroStack is for the consumables side: the stock that runs out.
Each consumable is an item, with its stock by place: the cabinet, the van, the second shop.
A reorder list in days of cover, with each supplier's lead time and minimum, and reorder points suggested from how fast things really go.
Counting works on a phone with no signal. A count shows what each difference is worth.
Every adjustment carries a reason: broken, lost, used on a job and not recorded.
Receiving records what arrived and what it cost.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Blades left in the cabinet | The last number typed | Kept current |
| When to reorder | When the drawer is empty | Days of cover |
| What's in the van | Unknown | Stock at that location |
| What was lost this quarter | Unknown | Adjustments by reason |
TaroStack doesn't check tools in and out to people or track calibration dates: keep the tool list for that. Stock, counts and reordering are on every plan, from $9.99 a month (50 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
