firearms inventory software

[nrobe50]

where can i find firearms inventory software. I have a mess.

 

[GunnyGene]

where can i find firearms inventory software. I have a mess.

I just use an Excel spreadsheet, but I don't buy and sell/trade a lot either.

 

[hittman]

Bing is your friend.

I also use a simple Excel spreadsheet. The key, for me at least, is to log purchased items and sold items the same day of the transaction.

https://www.bing.com/search?q=firearm+inventory+software&qs=AS&pq=firearm+inventory&sk=AS3&sc=8-17&cvid=A1E0444E33314DD69AC0E9998C2327B7&FORM=QBLH&sp=4

https://rapidgunsystems.com/?utm_source=bing&utm_medium=cpc&utm_campaign=Generic_RapidGunSystems_BMM&utm_term=%2BFirearm%20%2BSoftware&utm_content=Generic_Firearms_BMM

http://www.nmcollectorsoftware.com/support/screenShots.html

 

[Pps1980]

Another vote for Excel. Much more flexible than off-the-shelf software. The downside is you have to set it up in the first instance. But you can do things like add photos to linked pages and create a solid insurance document.

 

[wwb]

Got a digital camera?

I take a GOOD photo of each firearm, then add make, model, serial number, and condition to each photo using photoshop.... but you can actually do it in Microsoft Paint. Then, in a text file, I list make, model, serial number, condition, and Blue Book value for each one, referencing the Blue Book edition (currently using the 33rd edition.... time for a new one).

Burn a couple CDs, or load the photos and text file on a pair of flash drives.... one copy at home, one at my insurance agent, and the original on the computer.

 

[Pat-inCO]

Just don't let it get "on the cloud".

 

[Ale-8(1)]

I use an Excel spreadsheet. I have columns for Manufacturer, Model Name, Model Number, Serial Number, Action Type, Caliber/Gauge, Capacity, Barrel Lgth, Sights, Finish, Stock/Grips, Weight, Condition, Date Manufactured/Shipped, Date Purchased, Comments. I usually have them sorted by Manufacturer, Model Name, Model Number, but can sort by whatever characteristic I'm interested in at the time. I don't have columns for "price paid" or "value" but occasionally note this in the Comments.

My wife and both my sons each have a copy.

Works for me.

:mrgreen:

 

[AJGUNNER]

This is what I use. Basic, simple and easy to use---ad and delete as needed and I can fit some decent info in each box by making the print smaller. A copy is on the computer, a copy is on a thumb drive in the safe, a copy is in the safe deposit box, a copy is in my personal file with the insurance company and I keep a printed copy around here and there. Under the value column, I usually keep a reasonable replacement value which would include custom work, leather, scope, etc to = a real world replacement value if I was to go over to Cabelas and replace all of it tomorrow. Hopefully if I were to drop dead unexpectedly, this would help someone with liquidation---I hope my wife never sells all my stuff for what I told her I paid for it. :lol:

If someone that has been using postimage can tell me how to rotate a picture, I would certainly appreciate it.

For those that are electronically/technology challenged like me, shoot me a PM if you want a copy of it to print out.

 

[Aqualung]

I use Excel as well.

Whatever you use, be sure to keep inventory and pictures. Also think about making a permanent marking in a hidden area to aid identification.

Having some firearms stolen from camp this year has reinforced the importance of being able to provide accurate information to the PD and insurance company.

Aqualung

 

[Jeepnik]

Excel. Simple to use, and if you want to include more data or remove any data it's quick and easy.

 

[coach]

I just set up a Word table quite similar to what ajgunner did. I didn’t include optics, condition or accessories but I think I’ll go back and amend it. I love excel but a simple table works fine.

 

[AJGUNNER]

I also have photos of each showing condition, including a close up of each serial number. These are stored on the same thumb drives I keep spread out in various locations. Call me anal, but I even did a similar inventory sheet for holsters. When you add up 4-5 pages of holsters you would be surprised what the total adds up to---even more so when you list the actual replacement cost for each. If/when you ever have a loss be it fire or theft, you will be real happy to have a list. :)

 

[GunnyGene]

I just set up a Word table quite similar to what ajgunner did. I didn’t include optics, condition or accessories but I think I’ll go back and amend it. I love excel but a simple table works fine.

You can link Word and Excel data, you know.

Anyway, I also use Excel for a variety of other things; my wood shop tools, my wife's collection of stuff she collects, antique furnishings, stuff I've built, etc. Basically anything that's worth more than $200, or is a family heirloom. Some of it is tagged with who gets it when I/we croak.

 

[nrobe50]

I don't have excell but i guess i could spring for it. was really looking for some easy way to keep track of things without spending a 100 bucks...............thanks for the input

 

[nrobe50]

i found google sheets. I have to play with it a bit but I think it will work for me

 

[yooper1]

I don't have excell but i guess i could spring for it. was really looking for some easy way to keep track of things without spending a 100 bucks...............thanks for the input

No need to pay for Microsoft Excel or office.

Open Office is free and has the same ability plus it will read documents already made with any Microsoft program and Adobe pdf programs

https://www.openoffice.org/product/index.html

Open office comes with a bunch of programs (like Word; Powerpoint; Excel comparable programs).

The equivalent to Excel is the program / part called "CALC" in Open Office.

 

[yooper1]

Google sheets (or anything Google offers) is EVIL.

And google itself has been known to spy; share without your permission and who knows what eles they do.

Google = BAD

 

[Ruger45]

Whats wrong with just writing it down in a book the old way. LOL

 

[Specs]

If you are running Windows you probably have Microsoft Works. Works is OK, just create a database. I use Excel.
Everything I own is in the database room by room inventory with model and serial numbers. I mean things like computers, appliances, furniture, even the toaster. I maintain a gun inventory as a separate inventory file. Additionally I have photos of everything I own including wall by wall room by room.
When I lived in KY the possibility of a tornado or fire destroying it all was my concern. Here in central FL we have tornados and hurricanes. I have a full set on my computer plus 2 flash drives, one on my desk, and one in the bank safe deposit box. I update as things change.

 

[blume357]

Index Cards.....?
Then again, I use a Filemaker data base I created... a long time ago before the people managing filemaker hired a bunch of ex windows geeks... now to create a data base in filemaker you have to attend and pay for web classes to even figure out how to start.

 

[Ka6otm]

If you use an Excel spreadsheet, you can port it over to an app on iPhones called "numbers" and then password it there.

Numbers has no backdoor for the password, so it's fairly secure if you pick a good password to begin with.

Uppercase letters, lowercase letters, numbers and special ASCII characters make up a password with billions of possible combinations.

 

[Mobuck]

I'm willing to risk the loss of a few for the advantage of not having some "twidget" access the entire inventory.

 

[Ruger45]

I'm willing to risk the loss of a few for the advantage of not having some "twidget" access the entire inventory.

Agreed.. I'll just keep my info the old way with pencil and paper. :wink:

 

[Ale-8(1)]

I had a paper list for years. It suited my purposes

Then my wife, the spreadsheet queen, finally nagged me into an Excel file. She put it together in about an hour with my input on what I wanted to include. When she showed me how simple it was to add data columns and do sortation, I was hooked.

She's gonna drag me into the twentieth century yet.

:lol: :wink: :lol:

 

[nrobe50]

just tried open office. looks like it will work fine for me......paper and pencil is fine for some but I need to be able to add/delete and keep everything in alphabetical order. My accumulation has gotten a little out of hand.

thanks for all the imput

 

[Jeepnik]

Whats wrong with just writing it down in a book the old way. LOL

Because I have a hard time reading my own writing, and other find it impossible. I learned to type in Jr. High School as a defense against teachers complaining they couldn't read my writing.

I'm a southpaw. But due to a teacher with a yardstick (she used it liberally) I was force to write right handed.

 

[WendyZXZ]

Being on Macs here we use Apple Numbers which is the Apple counterpart to Excel, but also export everything to Excel(Copy of 2011 Office for Mac) and PDF.

 

[wunbe]

You really going to list the cost -- for your wife to see?

wunbe

 

[nrobe50]

It took a while but its done. Open office spreadsheet works like a charm. thanks for all the input.

 

[Ale-8(1)]

Nice thing about filling in a spreadsheet is doing a complete inventory.

"Hmmmmm, I don't recall that one . . . or that one . . . and where the heck is my . . . "

:mrgreen: :wink: :mrgreen: