What the list is for
An equipment inventory list is the record of what you own and rent long-term: one row per machine or tool worth tracking. It gets used for more than people expect:
Insurance
Your inland marine or contractor's equipment policy is written from a schedule of equipment. After a theft or a fire, the claim is only as good as the serial numbers you can produce.
Buying decisions
Before you buy a second rotary hammer, the list tells you whether you already own one sitting in a van.
Taxes and the books
Your accountant needs purchase dates and prices for the fixed-asset register.
Day-to-day tracking
Once every item has a number and a home, you can start recording where it goes.
What goes on it, and what doesn't
Track by item, not by kind: two identical generators are two rows, because they go to different jobs and break at different times.
On the list
- Powered equipment: generators, compressors, welders, saws, pumps, light towers
- Expensive or shared tools: lasers, press tools, core drills, pipe threaders, test meters
- Anything that needs an inspection: harnesses, lanyards, ladders, extinguishers, lifts
- Trailers, attachments and long-term rentals
Off the list
- Consumables: blades, fasteners, wire
- Anything you'd replace without thinking about it
- Each tech's own hand tools
- Anything you count by the box: that's a stock list
The columns worth keeping
Twelve columns cover almost every contractor. Here they are as they look in a spreadsheet:
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Name | Asset number | Category | Location | Serial number | Make | Model | Purchase date | Purchase price | Engine hours | Barcode | Notes |
| 2 | Portable generator 7500W | EQ-101 | Generators | Main yard | 2024-03-15 | 1899.00 | 412 | Example row: replace with your own | ||||
| 3 | Rotary hammer | EQ-102 | Power tools | Van 2 | Example row: replace with your own | |||||||
| 4 | Full-body harness | EQ-103 | Fall protection | Main yard | 2025-01-10 | Example row: replace with your own |
And why each one earns its place:
| Column | Why |
|---|---|
| Name | What people call it: “7500W generator,” not “GEN-PRT-7500-B.” |
| Asset number | Short, unique and written on the item: EQ-101. It's what people say on the phone. |
| Category | Generators, Power tools, Fall protection. Keep it to ten or so, or it stops being useful for sorting. |
| Location | Its home or where it is now: the yard, a vehicle, a jobsite. One place per item. |
| Serial number | The one thing police, insurers and the manufacturer will all ask for. |
| Make and model | Two columns. You need the model for parts, manuals and recalls. |
| Purchase date and price | Two more. For the insurance schedule, the books and the repair-or-replace question. |
| Engine hours | For anything with an hour meter. The last reading and when it was taken. |
| Barcode | If it already carries a rental sticker or an old asset tag, its number, so a scan can find it. |
| Notes | Everything else: attachments that go with it, who to call for service, a known fault. |
Free equipment inventory template (CSV)
The template has exactly those columns and three example rows to overwrite. It opens in Excel, Google Sheets or Numbers. Save it as CSV when you're done, and it imports into FlowNext as it is.
Free CSV
Equipment inventory template
A CSV with the columns worth keeping, for Excel or Google Sheets. Imports into FlowNext as it is.
Download the equipment inventory templateTaking the first count
- 1 Pick a quiet day and one person. A Saturday morning at the yard, with the vans parked, does most of it.
- 2 Start from what you already have. The insurance schedule, the fixed-asset list from your accountant and old receipts give you most rows before you walk anywhere.
- 3 Walk it, place by place. Yard, shop, each vehicle, each active jobsite. Find every item on the list and add the ones that aren't.
- 4 Number as you go. Write or label the asset number on each item while it's in your hand. A number that's only in the spreadsheet can't be matched to the machine later.
- 5 Photograph the serial plates. Faster than typing them on site, and the photo is proof for an insurer.
- 6 Chase the gaps the same week. Anything on the old list you couldn't find goes to the foremen by name while people still remember.
For a small contractor, 40 to 150 rows is typical. It's a day's work, not a project.
Keeping it true
The list goes stale in three ways, and each needs a habit:
New gear arrives
Whoever unpacks it adds the row and numbers it before it goes out. Make it part of receiving.
Gear leaves for good
Sold, scrapped or stolen: mark it retired with the date instead of deleting the row. You'll want the history at claim or tax time.
Gear moves
The location column drifts first, because the move happens on site and the spreadsheet is in the office. A weekly check catches it; recording each move prevents it.
Count the whole list once a year, ideally just before the insurance renewal.
When a spreadsheet stops being enough
The spreadsheet is a fine list. It's a poor tracker, because only the person at the computer can update it. When the location column is wrong more often than right, or you're keeping a second sheet for inspections, it's time to move the updates to the equipment itself.