I’ve decided it is time for me to do an inventory of my gun collection. This would be for insurance and I’m thinking about doing an Excel spreadsheet, but am wondering if there is one “out there” already. I also wonder about any commercial database-type software. I’m not an FFL dealer, so I don’t need anything too elaborate.
Do any of you fellow gun enthusiasts have an inventory or info that may help me in my quest?
Make everything easy. Don’t build super database just for inventory.
Excel / Word table is a good thing.
I do it differently. For me the most important are paperwork and pictures and this is what you mostly need .
I have a separate folder for each firearm and I keep copies of every document related to the firearm and pictures of it.
Serials number needed the most is on purchase or transfer receipt plus on the pictures.
There is a form called “Personal Firearms Record - Form P3312.8”. This may or may not suffice for insurance, but it will contain the information necessary to satisfy DOJ if you have to file a stolen or lost firearm report. Separate from this I have a photo inventory (MS Word or PowerPoint works well). Two pix of each firearm - overall and the serial number. After creating these documents, I filed them in my safe and erased/deleted/scrubbed them from my computer.
This. I used that form as a model for an Excel spreadsheet and expanded to include fields like when/where bought and when/where sold. I have pics of everything and I never dispose of paperwork like receipts and such.
If you have a sportsmans warehouse near you, they have firearm records books for free that have all of the relevant information you need for insurance of to keep a record an case if loss to fire or theft. I keep a copy of all of them in two different places in case of a house fire.
I read this at first and just thought a simple Excel file with relevant data would be good. Somebody above mentioned PowerPoint and that’s a great idea, as you can have one asset per slide with relevant information and you can paste in pictures of the asset as well as receipts very easily. I may actually do that myself, great idea.
We had a deal with an insurance company regarding some tools and equipment stolen from our garage. It was pictures, not necessarily, of the equipment but you could see the generator and saw in the background that sealed the deal.