Ammo Inventory Spreadsheet – Free Download

Pinterest LinkedIn Tumblr +
Print Friendly, PDF & Email

Last Updated on December 12, 2020

I wanted to give away this free ammo inventory spreadsheet. Hopefully, it helps some of you out there keep track of how much ammo you have on hand and what’s left to acquire to meet your prepping goals.

As we Preppers do our thing of planning, prioritizing, and eventually acquiring supplies, skills, and knowledge at some point you might need a hand organizing everything you have. There might be one or two of you out there with a set up as they have in the picture for this post, but the rest of us need some help. For most people this is simple and if you are really anal retentive, you have colored charts, lists, binders, and 3 x 5 cards to keep all of your supplies organized. That isn’t me.

For some things, it is simple to keep most prepping items in one place. Food storage, for example, has a pantry to go into, and as long as we have and keep an organized pantry or another system so we know what we have, everything is fine. If I am running low on supplies I can go to the pantry, check my inventory levels, and adjust as necessary. Or like this evening, I saw that a few new cans of soup had not been put away correctly and needed to find the right spot for them. OK, really who’s anal now?

Water storage is another easy one because that rarely changes or moves. I have several places where water is stored, but outside of rotating the stored water for freshwater every six months, we don’t need to keep as close an eye on that. Long term fuel storage is another one that is fairly easy.

There are some survival items that will get used like duct tape, medical supplies, and camping/backpacking gear but most of these items are used frequently enough that I am purchasing more on a frequent basis, so again, keeping track isn’t that urgent because anything I would need multiples of, I usually already have or routinely pick up when I am out shopping for anything related to prepping.

Do you know exactly how much ammo you have on hand? Try our ammo inventory spreadsheet.

When it comes to items like food and ammunition, we are generally looking to stock up on as much as we need and knowing where we are in that process takes a little organizational skill. For ammunition you need for that survival firearm, the easiest way to do this for me was to write everything down on a list and track how much I have on hand, what my desired quantities were, how far to my goals and how much money I would be looking to outlay to reach those goals. Additionally, I wanted to keep track of all of this because unlike food in the pantry, I have ammo all over the place.

The Ammo Inventory Spreadsheet System

You can find inventory spreadsheets out on the internet, but I just quickly created my own one day after I got a wild hair and grabbed all of the ammo I had in various places and decided to count it. If you are looking for a good place to purchase ammo, I have had great experiences with

Up until that time, I would just buy a box or several hundred rounds of whatever calibers I had on hand, or had just purchased. I had a rough idea of how much I had, but nothing precise, and I was worried that I might be buying the wrong things. It was time to track my ammo.

Screenshot of the ammo inventory spreadsheet.
Excel is a great tool for keeping track of inventory.

After I had a big pile of ammunition in various boxes and configurations weighing down my kitchen table, and sorting it into calibers (and smiling proudly) I started separating the handgun ammo into ball and hollow-point. Some spreadsheets go so far as to separate by manufacturer, but for me, that wasn’t important.

I simply wanted to know how much I needed to have and what was on hand. The Spreadsheet was pretty simple; I listed all of the caliber types I had, entered the quantity of each, and created a column for what my goal was. For instance, my goal for each handgun was to have 1000 rounds of ammo.

I then created a simple formula to subtract the on-hand count from the goal to give me a variance. When I did this for all my calibers, I could easily sort the spreadsheet on the variance column to see what I needed the most. Now, when I go to the gun show, I know that I really need more .30-.06 ammo than 9 HP for example so I can make an informed purchase.

I also added some other fields like the average cost for a box so I would know how much cash (roughly) I was still looking to spend to meet my goals. The prices change all the time, so what is in the spreadsheet might not be accurate. Everything is open and you are free to change this as you see fit if you think this could help you.

The spreadsheet is on our Resources page in the “Downloads” section and if you have any lists you have created yourself and want to share, please let me know.

0 0 votes
Article Rating

About Author

Freedom-loving American doing what I can to help prepare and inform others. Editor and creator of The Prepper Journal 2013-2017, 2020 -

Notify of
Newest Most Voted
Inline Feedbacks
View all comments

Great topic. I developed a similar sheet but didn’t think to add a “cost” column . I saw the handwriting on the wall late last year and bought up a lot of 22lr and 9mm every time I found it on sale. Your plan is better; I’m literally still paying for my lack of a plan last year, but I’m glad I did it. I always have a full bag of ammo at the range because I have about twice as much as my plan .

Pat Henry

Thanks very much for the comments mkegaffer and glad the spreadsheet was useful. I just went to the range myself last week and was glad to see the prices are almost back to the latest normal. Still more expensive than I would like, but not as insane.


Gregory P

I want to thank you for all of this articles. I just got into prepping about 6 months ago and I think I have made a good start on everything except food. I have already done a spread sheet on the amount of ammo I have but didn’t think to set a goal or calculate the price. I do have a lot of 9MM as we have 3 weapons that fire that caliber and I have a ton of 22LR. I have less than 1000 rounds of various shotgun shells. What type of shotgun shells do you recommend and what… Read more »


I started this last year as well. I’d rater list a sell count but it is sufficient to say that my ammo will long outlast me. sports mans guide . com is a great place.

Pat Henry

Thanks Kirk! I’ll have to check out Sportsman’s Supply when I am buying next time.

Would love your thoughts, please comment.x