Tool inventory spreadsheet: free template and what to record

Oct 8, 2026 · 5 min read

Quick answer

A tool inventory spreadsheet lists every tool you would replace if it went missing, one row per tool, with a tag number, brand, model, serial number, category, who it is assigned to, where it is kept, purchase date and cost, warranty end, condition and the date it was last seen.

Most contractors find out what their tool list is worth on the worst day: after a van is broken into, when the insurer asks for an itemized list with serial numbers, and nobody has one. A tool inventory spreadsheet is the cheapest insurance against that day, and the foundation for any tool tracking you do later.

This guide gives you a free template, the columns worth keeping, and how to build the list in an afternoon.

Download the tool inventory template

Tool inventory template (Excel): with category and condition drop-downs, an example row and a How to use tab.
Tool inventory template (CSV): the same columns for Google Sheets.

What goes on the list

List every tool you would replace if it went missing. That usually means power tools, test equipment and meters, ladders, laser and layout tools, press and crimping tools, generators and compressors, specialty tools, and batteries and chargers if you buy them separately.

Leave off consumables: drill bits, blades, fittings, fasteners, tape. They are managed by quantity, not one by one, and putting them on a tool list buries the items that matter.

For hand tools, list kits rather than individual screwdrivers, unless a single tool is expensive enough to replace on its own.

The columns and why each one matters

Column	Why it matters
Tool tag	Your number for the tool, on a label on the tool. Everything else hangs off it.
Tool	Plain description: hammer drill, insulation tester, 28 ft extension ladder.
Brand and Model	What to order if it is lost, and what a warranty claim needs.
Serial number	The detail police reports, insurance claims and warranty claims ask for first, and the one nobody can find afterwards.
Category	Power tools, test equipment, ladders and so on, for filtering and counting.
Battery platform	M18, 20V MAX, LXT: so you buy batteries that fit.
Assigned to	The person responsible for the tool now.
Location	The shop, van or job where it is kept.
Purchase date and Purchase cost	For warranty dates, replacement budgets and your accountant.
Warranty end	So a covered repair is not paid for. Many cordless tools carry multi-year warranties that are easy to forget.
Condition	New, good, fair, needs repair, out of service.
Last verified	The date someone physically saw the tool. The column that tells you how stale the list is.
Notes	Accessories, receipt location, anything unusual.

How to build it in an afternoon

Start in the shop. Work shelf by shelf and list everything before moving on.
Tag as you list. Give each tool its tag number and put the label on it there and then. Our guide to asset tags for equipment covers label materials that survive vans and job sites.
Photograph serial numbers. A phone photo of the serial plate is faster than typing it and settles any argument later.
Do one van at a time. Catch each tech when the van is back, and list what is in it with them.
Fill purchase dates and costs from receipts later. Do not let missing receipts stop the count.
Set Last verified to the date of the count for everything you saw.

Keeping it current

A tool list is accurate on the day it is made and drifts every day after. Three habits slow the drift:

Update the row when a tool is bought, lost, retired or reassigned, not at year-end.
Recount twice a year. Walk the shop and the vans and update Last verified. Anything not seen in two counts is probably gone.
Keep a copy off site, so it survives the theft or fire you made it for.

What a spreadsheet cannot do

A spreadsheet answers what do we own well. It answers who has it badly, because when a tool moves, the Assigned to cell is overwritten and the previous holder disappears. It cannot tell you who had a tool before it went missing, and with several people editing it, the file drifts quickly.

For day-to-day movements, pair the list with a tool sign-out sheet. When you need both in one place, with the history of every handoff, the tool tracking system guide compares the next steps.

How AssetCenter fits

The template's columns match an AssetCenter asset record, so the spreadsheet is also your import file. Paste it into the import template, validate the rows, and the import can create the categories, people and locations in it. Add a custom field such as Battery platform to the category first, and a column with the same name imports into it. From then on, scanning a tool's label to assign it records each handoff on the tool's timeline instead of overwriting a cell. See tool tracking software for contractors.

AssetCenter tracks individual tools, not consumable quantities, so keep bits, blades and fittings in a stock system.

Frequently asked questions

What should a tool inventory list include?

At minimum a tag number, description, brand, model, serial number, who has it, where it is kept, purchase date and cost. Add warranty end, condition and a last-verified date to make it useful for claims and audits.

Should I record serial numbers for every tool?

For every tool you would report stolen or claim on, yes. Serial numbers are what make a stolen tool identifiable and a warranty claim possible, and they are almost impossible to recover after the tool is gone.

How often should a tool inventory be updated?

Update rows as tools are bought, lost or reassigned, and recount the whole list at least twice a year.

Next step: list the shop and one van

Download the tool inventory template, list the shop and one van, and tag every tool as you go. Then put the tool sign-out sheet at the door so the list stays true between counts.

By Jeremy Francis

Founder & CEO, AssetCenter

Keep reading

Oct 8, 2026