|
Forum Rules | Firearms Safety | Firearms Photos | Links | Library | Lost Password | Email Changes |
Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
Thread Tools | Search this Thread |
May 1, 2017, 01:59 PM | #1 |
Member
Join Date: September 18, 2010
Location: Ohio
Posts: 27
|
Looking for suggestions on how to keep a record of my firearms
Hello all -
I was wondering what do you use to track your firearms collection? I was looking at a couple third party programs, but might go the simple route of using a spreadsheet. What attributes would you recommend I record, outside of make, model, and serial number? Thanks in advance for your input... |
May 1, 2017, 02:35 PM | #2 |
Senior Member
Join Date: October 20, 2007
Location: Richardson, TX
Posts: 7,523
|
PICTURES.
Also, copies of all records should stored somewhere distant from the primary location where the firearms are stored. Do NOT store records where they could all be destroyed if the firearms storage location burns or floods, and DON'T put them on a portable device such as a laptop or phone—they could be stolen together with the device, and you don't want to give thieves a shopping list!
__________________
"Smokey, this is not 'Nam. This is bowling. There are rules... MARK IT ZERO!!" - Walter Sobchak |
May 1, 2017, 02:39 PM | #3 |
Staff
Join Date: September 25, 2008
Location: CONUS
Posts: 18,434
|
I use Excel. Here's a dummy copy of my spreadsheet:
Last edited by Aguila Blanca; July 24, 2017 at 11:21 AM. |
May 1, 2017, 03:05 PM | #4 |
Senior Member
Join Date: December 6, 2014
Posts: 6,432
|
I use a small book from Bianchi - not even sure if it is still made. In addition to what is shown in the spreadsheet above, they had an area to list any modifications (scope, custom grips, etc)
__________________
"I believe that people have a right to decide their own destinies; people own themselves. I also believe that, in a democracy, government exists because (and only so long as) individual citizens give it a 'temporary license to exist'—in exchange for a promise that it will behave itself. In a democracy, you own the government—it doesn't own you."- Frank Zappa |
May 1, 2017, 05:30 PM | #5 |
Senior Member
Join Date: January 2, 2017
Posts: 498
|
Sync your smart phone to google photos, Dropbox or some other cloud storage. Take a pic of the whole gun, its serial, all your goodies. Invaluable for insurance.
|
May 1, 2017, 06:06 PM | #6 |
Senior Member
Join Date: August 11, 2012
Location: Mountains of Appalachia
Posts: 1,598
|
I just have them listed with word on my computer and I have Carbonite to back it up in case of fire, theft or if the computer dies. I got Carbonite to safeguard my 10,000 pictures.
I have make, model, caliber, age of the gun and when I bought it along with where I got it and what I paid. I also keep the guns listed I have gotten rid of with where they went. |
May 1, 2017, 06:54 PM | #7 |
Senior Member
Join Date: April 12, 2017
Location: Ohio
Posts: 1,048
|
simple text file with model and SN, I don't record price or year bought.
compressed with 7zip and AES encrypted. sent as a file attachment to my self in my email. |
May 1, 2017, 07:30 PM | #8 |
Senior Member
Join Date: March 16, 2007
Location: Southern Arizona
Posts: 3,888
|
I keep an updated list with SN, Make, Model, Caliber, Estimated Value etc. in several places including my gun safe. In addition my insurance carrier requires such a list for the personal property rider I have the guns on - so it's available in their records.
|
May 1, 2017, 08:59 PM | #9 |
Senior Member
Join Date: September 15, 2002
Location: West, Texas
Posts: 280
|
Burnsoft
Makes a great gun,ammo, inventory app.
|
May 1, 2017, 09:05 PM | #10 |
Junior Member
Join Date: April 18, 2017
Posts: 6
|
Dang, y'all must have a lot of guns to need an app to keep track of them all!
Sent from my SM-G935P using Tapatalk |
May 1, 2017, 10:17 PM | #11 |
Senior Member
Join Date: April 18, 2017
Location: Southwest US
Posts: 148
|
Microsoft word, excel, notebook, piece of paper, the list goes on. . .
__________________
O LA VITTORIA, O TUTTI ACCOPPATI! |
May 1, 2017, 10:56 PM | #12 |
Senior Member
Join Date: April 27, 2017
Posts: 351
|
Well, I don't have a link to quote as a source for this,
but I've found a small bound notebook like you can get at most drugstores or stationary stores works fine, for me. I would recommend you make two copies, and store them separately. OOPS! No link for that, either, sorry. |
May 2, 2017, 05:02 AM | #13 |
Senior Member
Join Date: October 9, 1998
Location: Ohio USA
Posts: 8,563
|
Spread sheet works for me.
And, I try to keep all my original sales slips in the same box the guns came in. I started that practice too late for a lot of them, but, I really suggest doing it. I also email the spread sheet to myself and a copy to my wife - & - I keep a copy on Google drive. |
May 2, 2017, 06:53 AM | #14 |
Junior member
Join Date: May 20, 2014
Posts: 1,835
|
Spread sheet with my over 300 guns. No pictures however.
Last edited by peggysue; May 2, 2017 at 12:48 PM. |
May 2, 2017, 07:58 AM | #15 |
Senior Member
Join Date: February 9, 2007
Posts: 3,101
|
You can hyperlink photos to excel spreadsheed entries.
I'm sure Youtube has a dozen vids on it. |
May 2, 2017, 08:02 AM | #16 |
Senior Member
Join Date: July 20, 2016
Location: Upstate NY.
Posts: 901
|
I keep a spreadsheet with all the serial numbers and purchase prices (for insurance reasons). I also keep pictures of all my firearms.
Don't see why you'd need much more than that.
__________________
In God we trust. |
May 2, 2017, 12:01 PM | #17 |
Staff
Join Date: September 25, 2008
Location: CONUS
Posts: 18,434
|
As Chris B noted, it is possible to hyperlink photos to an Excel spreadsheet. If I knew how to do it, I would do so.
It's also possible to convert an Excel spreadsheet to a table to form the basis for an Access database. You can then create a form view with a single screen for each entry, including space for photos. I have Access on my computer, but I don't know how to use it or I would have gone this route. |
May 2, 2017, 12:04 PM | #18 |
Senior Member
Join Date: July 29, 2010
Location: The ATL (OTP)
Posts: 3,944
|
I still go “old school” Excel spreadsheet and photos in the safe deposit box.
__________________
A major source of objection to a free economy is precisely that it ... gives people what they want instead of what a particular group thinks they ought to want. Underlying most arguments against the free market is a lack of belief in freedom itself. - Milton Friedman |
May 2, 2017, 02:34 PM | #19 |
Senior Member
Join Date: June 19, 2012
Location: MS - USA
Posts: 899
|
I've been happy with the Gunlog app. I have it on my iPhone. Might cost a couple of bucks, but each firearm can be logged, serial #, description, photos, place of purchase, place of purchase, purchase price, and some other notes of your choosing can all be entered. It stores the info locally on your phone and doesn't get to the cloud or interweb. There are instructions for backing up the data on your computer.
I particularly like that it will store photos. Under each firearm, I typically have a photo of the whole gun, a closeup that shows the serial#, and a photo of the original receipt. Last edited by jmhyer; May 2, 2017 at 10:20 PM. |
May 3, 2017, 12:25 AM | #20 | |
Senior Member
Join Date: November 25, 2012
Location: Cascadia
Posts: 1,288
|
Quote:
depending on the gun it doesn't take many years for an original owners manual to get hard to find.
__________________
lightweight, cheap, strong... pick 2 |
|
May 3, 2017, 06:46 AM | #21 |
Senior Member
Join Date: December 16, 2013
Location: Eastern NC
Posts: 3,047
|
This free reloading software has a "firearms data base" section that can be used to keep an inventory:
http://www.huntingnut.com/index.php?name=PointBlank
__________________
One shot, one kill |
May 3, 2017, 12:52 PM | #22 |
Member Emeritus
Join Date: August 19, 2004
Posts: 7,133
|
Do whatever you choose, but I would strongly suggest NOT entering or keeping an electronic record in any computer or hackable/stealable electronic device.
I know it's easy, but.... Denis |
May 3, 2017, 04:59 PM | #23 |
Senior Member
Join Date: January 3, 2017
Posts: 1,583
|
A word document or a spreadsheet will work well if you keep track of all the data on each gun. Include accessories like sights, slings, cases, after market triggers and cleaning gear. Keep a copy on your computer, back it up to a CD Rom and keep a printed copy as well. A photo catalog showing close ups of the guns important features and accessories should be included in each document.
You do want multiple copies in case the others are destroyed. Electronic data is never permanent or secure. Keep printed copies in multiple places. One in your home fire safe and one in a safety deposit box and another with a trusted relative. |
May 3, 2017, 11:41 PM | #24 |
Senior Member
Join Date: March 30, 2014
Location: It changes.....a lot.
Posts: 356
|
I just use a hardback notebook and a pen.
KISS!
__________________
Airborne Rangers Lead The Way. |
May 4, 2017, 12:59 AM | #25 | |
Senior Member
Join Date: November 25, 2012
Location: Cascadia
Posts: 1,288
|
Quote:
a USB stick is tiny, "unhackable", and easily stored in a fire resistant safe... bout the best you can do actually. there is nothing out there that is completely secure.
__________________
lightweight, cheap, strong... pick 2 |
|
Thread Tools | Search this Thread |
|
|