Tool Inventory Template

[rcarmac]

I had several requests for my Tool Template Spreadsheet. Unfortunately, the uploading of spreadsheets is not allowed.

But here is a link. It is not any great, but hopefully it can help you get started inventorying your tools.

ShareFile

smithsinnett.sharefile.com

 

[Douglas Robinson]

While I have an Excel spreadsheet. I like yours better. It work for both a sell off and for insurance purposes, just like was mentioned. I now have to add serial numbers.

 

[Mike Davis]

Thanks Robert. That is very comprehensive.

 

[rcarmac]

While I have an Excel spreadsheet. I like yours better. It work for both a sell off and for insurance purposes, just like was mentioned. I now have to add serial numbers.

I hope it works out for you. Make it what works for you

 

[Douglas Robinson]

I am thinking of adding a column for related accessories, or a way to associate other rows, showing accessories, to the primary tool.

 

[rcarmac]

If you input the year you purchased the tool and then scroll to the far right past the end of the worksheet, it totals up how much you spent per year. You may or may not want to know that.

I have a column for the purchase value and then the out of pocket cost. I did this for a couple of reasons. Say you purchased something at klingspor that retails for $10. That’s what I put as the purchase value. But if you are DQ qualified you get a 10% discount. So the purchase value is $10 but my out of pocket was $9. Similar, if you are like me, you get a lot of items on your wish list as a gift. So a tool might have the purchase value of $50 but it was a gift or raffle prize and my actual out of pocket is technically 0.

Maybe too complex of a way to look at it.

 

[rcarmac]

I am thinking of adding a column for related accessories, or a way to associate other rows, showing accessories, to the primary tool.

I thought about that but got to complex when doing values. I want to know the cost of the tool and the cost of accessories separately not together. But agree that linking all lathe accessories together with the lathe might be useful.

 

[Douglas Robinson]

There are also things like a Festool router and then the edge guide.

 

[rcarmac]

My spreadsheet can’t support things like Festool. You have to purchase the premium package and move the decimal to the right if you want to add those expensive things to it

 

[Douglas Robinson]

If you input the year you purchased the tool and then scroll to the far right past the end of the worksheet, it totals up how much you spent per year. You may or may not want to know that.

I have a column for the purchase value and then the out of pocket cost. I did this for a couple of reasons. Say you purchased something at klingspor that retails for $10. That’s what I put as the purchase value. But if you are DQ qualified you get a 10% discount. So the purchase value is $10 but my out of pocket was $9. Similar, if you are like me, you get a lot of items on your wish list as a gift. So a tool might have the purchase value of $50 but it was a gift or raffle prize and my actual out of pocket is technically 0.

Maybe too complex of a way to look at it.

I get that. I have items like an MFT I got for free, and my Cyclone that I got for $300 in 2007. So I see the value in putting in the retail price and my cost. Then adding replacement cost is an intersting item. Some things depreciate and others like Bridge City tool appreciate.

 

[Hmerkle]

Thank you Robert,
That is VERY well thought out.

 

[Vanilla Gorilla]

Thanks for posting this, it's something I have not thought about!

 

[rcarmac]

I get that. I have items like an MFT I got for free, and my Cyclone that I got for $300 in 2007. So I see the value in putting in the retail price and my cost. Then adding replacement cost is an intersting item. Some things depreciate and others like Bridge City tool appreciate.

The replacement cost line item I put mainly for insurance purposes. So if I had to go out and buy my exact shop from scratch how much would it be so I can make sure it’s insured for that.

 

[Douglas Robinson]

So I went to the shop tonight to work on my inventory. Some observations:

I have a LOT of stuff!

I have done a poor job of sorting through my stuff since the move. Router bits and accessories are in too many places. Same for Lathe accessories.

I need to build that fancy wall-hung tool cabinet I have be planning as I have hand planes, scraper, chisels, files and measuring tools need a quality home.

Still have lots of small stuff to inventory, e.g. drill bits, wrenches, hammers, screw drivers, etc.

 

[rcarmac]

good job on getting started

 

[Douglas Robinson]

Having done a rough list years ago (which I cannot find) I am finding that the tools that are no longer made harder to guesstimate their value. I have to look for comparable replacements. I am definitely going to take pictures of each item. But I have questions. Like why do I have 3 Wixey angle devices?