Need Guitar Inventory Template

Lost_N_Austin · August 1st, 2008, 10:10 PM

Does anybody have a recommendation for keeping an inventory of your guitars and guitar gear? I'm looking for something that will let me keep track of some important aspects of my "Stuff'.
Cost (What did it cost)
Source (Pawn, guitar store, hand me down, gift)
Current value (What's it worth?)
Serial number (What is it and where is it located?)
Images - (Pictures)
Heir - (Who gets it?)
Where it is located (Who borrowed it?)

You know, a way to keep track and a possible tool for insurance or recovery in case of a disaster.

Prefer Free! Would consider an inexpensive one. Maybe Excel based.

ANYBODY solved this problem yet?

Thanks in advance. (I searched for one on the net and on the TDPRI board)

L_N_A

gibsonjunkie · August 2nd, 2008, 07:19 AM

Sounds like an Excel Spreadsheet to me. I have one with a lot of that data, but not all of it. You can even draw a link to phtots.

BAW4742 · August 2nd, 2008, 07:56 AM

Sounds like you have the template already.

In the first row list the things you want to track in separate columns as titles. Then start listing your equipment in rows below that. It's pretty easy to do in Excell. And easy to update or modify later by adding columns.

I made up one several years ago and have added to it as I wanted to keep track of different things.

jhundt · August 2nd, 2008, 10:17 AM

remember to include fields relating to "current value" which give the date of the last valuation, and the source ie. a professional appraisal, listed selling prices for a similar instrument, blue-book reference, etc.

August 1st, 2008, 10:10 PM	#1 (permalink)
Lost_N_Austin Tele-Afflicted Join Date: Feb 2004 Location: Some Beach Age: 67 Posts: 1,464	Need Guitar Inventory Template Does anybody have a recommendation for keeping an inventory of your guitars and guitar gear? I'm looking for something that will let me keep track of some important aspects of my "Stuff'. Cost (What did it cost) Source (Pawn, guitar store, hand me down, gift) Current value (What's it worth?) Serial number (What is it and where is it located?) Images - (Pictures) Heir - (Who gets it?) Where it is located (Who borrowed it?) You know, a way to keep track and a possible tool for insurance or recovery in case of a disaster. Prefer Free! Would consider an inexpensive one. Maybe Excel based. ANYBODY solved this problem yet? Thanks in advance. (I searched for one on the net and on the TDPRI board) L_N_A __________________ Don't try to paint someone else's barn.

August 2nd, 2008, 07:19 AM	#2 (permalink)
gibsonjunkie Tele-Holic Join Date: Jan 2006 Location: Bloomfield, Connecticut Age: 55 Posts: 741	Sounds like an Excel Spreadsheet to me. I have one with a lot of that data, but not all of it. You can even draw a link to phtots. __________________ The early bird gets the worm, but the second mouse gets the cheese...

August 2nd, 2008, 07:56 AM	#3 (permalink)
BAW4742 Tele-Afflicted Join Date: Apr 2008 Location: Maryland's Eastern Shore Age: 52 Posts: 1,155 4 Photos	Sounds like you have the template already. In the first row list the things you want to track in separate columns as titles. Then start listing your equipment in rows below that. It's pretty easy to do in Excell. And easy to update or modify later by adding columns. I made up one several years ago and have added to it as I wanted to keep track of different things.

August 2nd, 2008, 10:17 AM	#4 (permalink)
jhundt Friend of Leo's Join Date: Mar 2003 Location: Netherlands Age: 55 Posts: 3,669 10 Photos	remember to include fields relating to "current value" which give the date of the last valuation, and the source ie. a professional appraisal, listed selling prices for a similar instrument, blue-book reference, etc.