Firearms Logs


February 25, 2011, 09:14 PM
I see a lot of posts that talk about what kind of guns you have, how much ammo you have, etc… I think that many people don’t like to keep a record of the guns they own, because they are afraid “Big Brother” is going to find it and come after them. While I am concerned about this, slightly, I know that it isn’t likely, and don’t let it bother me. If you want a list to keep track of your firearms, you’re more than welcome to use the one I have created. This Excel 2007 Spreadsheet keeps track of Firearms owned, Firearms you have sold, Firearms you wish to buy, Accessories you own, Accessories you wish to own, and Amounts of Ammunition you have, versus how much you can store in ammo cans you have, or whatever. Something like this could come in handy if your firearms are ever stolen, or destroyed in a fire, or even lost on a boating accident.

If you want, you can check it out, by downloading it here (

First and Foremost, if you download this, it is a .zip compressed file, so you must first decompress the file. To do this, Right Click on the file you downloaded, and click on “Extract”.

If you actually intend on using the file to keep an accurate list of your firearms, I would recommend you add some kind of security to the document. Office 2007 makes it easy to password protect a document. (see the first image to locate where to do this)

On the first tab, under the section “Type” I have it setup to put “Pistol”, “Shotgun”, “Rifle”, and “Full Auto”. If you do this, you will be able to use the chart on the last tab, “Charts”, to see what portions of your firearms are which.

In the “Ammo” tab, it is set up so that you can put any type of ammunition in the “Caliber” section (ie 9mm Luger, 7.62x39, 12 Gauge, etc…), as well as the amount of rounds you have. There is a chart under the “Charts” tab that covers this as well, giving you a visual depiction of how much ammo you currently have (Blue Bar), in comparison to how much ammunition you have the ability to store (RED BAR). This helps me visually keep track of how much ammo I have, needed to buy, and project costs for myself. I use a calculator to find my “cost per shot” to estimate prices. The “Rounds to Buy”, “Cost to Replenish”, and “Current Value” are calculated based upon the other information given in that tab.

If you intend to use the charts on the “Charts” tab, you will have to click on one of the charts, and press “Alt+F5”. This will update all of the charts with the updated data after you make any changes. If you do not do this when you look at the chart, you will not be viewing the up to date data.

How many of us keep a detailed list of Firearms, Ammo, and Accessories we own?

If you enjoyed reading about "Firearms Logs" here in archive, you'll LOVE our community. Come join today for the full version!
February 25, 2011, 09:34 PM
Forgot to add the pics...

February 25, 2011, 09:38 PM
BIG BROTHER IS WATCHING!!! lol, no but i don't have a list per say but i do know what i have and how much of it mostly cause it ain't alot lol.

February 26, 2011, 12:26 AM
Yup, have an excel doc. full of pistols, rifles & shotguns. Along with condition, latest book price, serial number, Make & Model, and any accessories the gun has with it.

Its a great list but it needs to be updated frequently based on my buying & selling of guns.

Never really logged too much ammo, already got it sorted into containers with the caliber marked, for when I need it.

February 26, 2011, 06:52 AM
The only information I track is reloading information (times fired, load data, casting data, etc.....) otherwise I see no need to involving paperwork with my hobby.

February 26, 2011, 06:08 PM
I keep a plain ol ordinary spiral pad in a 3 ring binder for each gun I shot with from the day I bought them and they date back to 1979 to 2010. Every time I got to the range I make remarks about what I did, range from where I shot, WX conditions, etc.. I find it helps me remember what the heck I did. I do it right at the range so I don't forget to log the daily events or forget to do it when I go home.

Ala Dan
February 26, 2011, 06:11 PM
detailed log of everything

February 26, 2011, 06:20 PM
i don't keep a list ......but i do email myself from one email account to another each time i purchase a new firearm with the serial number and description....

i also do this with serial numbers on electronics and such.....

decent and free and will be needed if even stolen.....

as far as government watching etc......they would have to know to look and which accounts etc....tho im not really worried about it

** problem with lists on my home PC or paper list is that it may be taken if house is robbed.....

February 26, 2011, 10:32 PM
I keep a spreadsheet that tracks round count on each firearm with notes on the side like "replaced firing pin at X number of rounds" or "replaced recoil spring at Y number of rounds".

I have another spreadsheet where I track ammo expended per range trip by caliber. It multiplies the price per round by # shot and adds up how much the range trip cost. I started keeping that one after the wife complained about how much I spent on ammo.

The reason she was complaining was that I tend to buy centerfire in bulk; once I showed her how long it was taking me to use up that bulk purchase and that 95% plus of my shooting is 22LR she quit complaining.

February 26, 2011, 10:42 PM
I have a list of all my firearms related things, which shows how much I've spend (too much!), and a spreadsheet (ironically using the same exact table format as the one shown) that keeps track of how much ammo I have, have shot, and what the specific ammo is, also showing how many rounds have been fired through each firearm. I was keeping a log of all my range trips, but decided to just consolidate that to the spreadsheet.

February 26, 2011, 10:44 PM
I shoot and reload so often, I couldn't take the time to update the chart

Digger Odell
February 26, 2011, 11:32 PM
I do keep a detailed list of each firearm. Make,model, serial no., type of ignition (flint,perc,or cartridge), weight, barrel length,capacity,if rifle or shot gun type of action, any identifying marks & cost. A brief description overall.
For reasons of loss or for family info if ever needed.

It has me saying I need MORE to help fill in the blank PAGES!! :D

February 27, 2011, 11:28 AM
Digger,I like the way you think!More pages,more guns,YUP.
I'm not a paper work kinda of guy,but I do keep a detailed list of my firearms.I have inherited guns from relatives,and include a little history about a few of them.This is mostly for whoever inherits them after I'm gone.Logging ammo is just too much work,but I do try to inventory my reloading components so that I can watch for bargins on things that I'm short of. Lightman

Digger Odell
February 27, 2011, 05:22 PM
Hi lightman!
Yes, when my wife might look in the safe & wants to know if anything was added, I keep telling her that the space in the safe shrinks & is like my suit when it stays in the closet, it has a tendency to shrink & doesn't fit when I go to use it. :evil: :D She shakes her head & walks away. :D
With the ammo & such I just do a visual.
Have fun!! :)

February 27, 2011, 05:30 PM

February 27, 2011, 06:11 PM
I had to keep a "bound book" when I had a C&R and then a regular FFL. When I discontinued the licenses, I had to send the "bound book" in to the ATF, but I kept a copy and simply continued the entries in the same format for guns that I acquired later. These are just records for myself (and for insurance purposes, should the need ever arise). Of course, for NFA items, records and retained paperwork are absolutely essential.

February 27, 2011, 06:19 PM
When I was actively buying curious on my 03FFL, of course I logged them, I had to. Now, since the license I had expired and I haven't bought any curious on my new license the need to create a record has not come up yet and with the current prices, I don't think it will until after 2012 unless something really sweet shows up.

I am working though on an inventory of what is in the safes so I can find curious and non curios. Not a lot of detail, I'd just like to find stuff.


February 27, 2011, 07:44 PM
I have Logs where I keep track of ammunition both on hand and used during range sessions. I also record each gun in its own file with both spreadsheets and photos.

February 28, 2011, 02:59 AM
I keep track of rounds fired in what guns and that is about it. Its easier to just take a look and see what ammo I have on hand.

February 28, 2011, 03:23 AM
I keep track of ALL my firearms and EVERY bullet i have in my gun safe. only thing i dont keep track is of how many bullets i shoot out of my guns! ( i need start doing that)

February 28, 2011, 10:50 AM
In the Corps, I logged everything at the range for my rifle.

Now all I do is have pictures, a description, and my serial number for the rider on my insurance in case anything happens.

February 28, 2011, 11:49 AM
I keep a paper log (bound book) of C&R acquisitions as required by law, but I also keep a spreadsheet of the models, serial numbers, and a link to a photo of all my guns. Realistically in the event of theft or property destruction having all that information available is a great help.

This spreadsheet I keep in an encrypted volume (I use a free/open source utility for this called TrueCrypt) which is synced with a Dropbox account (Dropbox is an online storage service that mirrors a local directory). Since they're mirroring an encrypted file no one can read it without the password, but the reality is that if the house burns down, or the guys stealing the guns also stole my computer, the file is still safely mirrored off-site for retrieval.

I do only keep track of the guns themselves though. Bullets, magazines, etc are just kept organized. I have considered though starting to keep a database of guns/ammos used at the range and the group sizes shot at various ranges. Seems like a good way to plot performance with certain guns and notice when you're plateauing and need to move to longer distances or practice with different gun types.

February 28, 2011, 09:38 PM
i keep a list of the firearms i own currently. once i sell one, it comes off the list. i do not have my list password protected. if uncle sam wants the info badly enough, i am sure they could come up with some way of getting it. i am absoloutly cetain they have some of the best computer hackers on the planet working for them!

March 1, 2011, 09:44 AM
i am absoloutly cetain they have some of the best computer hackers on the planet working for them!

Hackers are good at getting through security systems and finding flaws in programs. Things like buffer overflows or SQL injection. Mostly tricky ways to make code execute remotely.

Cryptography is about the algorithm. A properly encrypted file using a modern algorithm like AES would take all the computers on the planet millions of years to break through. It's not a matter of having a "hacker" good enough - it's about the math. No matter how much money you feel like throwing at it, you can't make 2+2 equal 5 :).

And yes, I'm qualified. I've got a degree in Computer Science ;).

If you enjoyed reading about "Firearms Logs" here in archive, you'll LOVE our community. Come join today for the full version!