Report this item to Etsy

Ammo Inventory Spreadsheet, Round Count Tracker, Excel and Google Sheets Ammunition Log, Firearm Maintenance and Range Log

Price:$12.00

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by RangeDoctrine
  • Digital download
  • Digital file type(s): 1 ZIP

Know what is on the shelf, what it cost, when to reorder, and which firearm is due for service. One workbook for Excel and Google Sheets.

Log what you buy and log what you shoot. The Ammunition Ledger keeps the counts.

WHAT IT DOES

Stock by caliber. Rounds on hand, what you paid per round on average, what the stock is worth, and how many months it lasts at the rate you have been shooting.

Reorder flags. Set a target and a reorder point per caliber. The ledger marks REORDER and BELOW TARGET for you.

Round count per firearm. Every range entry adds to the right firearm and comes off the right caliber.

Service intervals. Set how often each firearm gets cleaned or serviced. Log the service and the round count at that date fills itself in. The ledger marks DUE SOON and SERVICE DUE.

Malfunctions per 1,000 rounds. A plain number for whether a firearm or a magazine is getting worse.

Range ammo handled properly. Shooting ammunition a range or a friend supplied? Mark it, and the round count goes up without your stock going down.

THE SHEETS

01 START HERE. Set up in four steps, and what every sheet is for.
02 DASHBOARD. Rounds on hand, value, calibers to reorder, rounds fired this year, spend this year, firearms due service. Stock and service at a glance.
03 STOCK. One row per caliber, up to 30.
04 FIREARMS. One row per firearm, up to 40.
05 PURCHASES. Price paid includes tax and shipping, so cost per round is what the round really cost. Lot numbers and storage location.
06 RANGE LOG. Date, firearm, location, caliber, rounds, load, malfunctions, notes.
07 ADJUSTMENTS. Physical counts, finished handloads, gifts, rounds given away.
08 SERVICE LOG. Cleaning, springs, parts, gunsmith work, cost.
09 LISTS. The choices behind every dropdown. Add your own.

BUILT TO STAY RIGHT

Dropdowns keep caliber and firearm names identical across every sheet, which is where most home made spreadsheets go wrong. White cells are yours to type in. Grey cells calculate. No macros, no add ons, no account to create, nothing that stops working after an update.

WHAT YOU DOWNLOAD

One zip file holding two workbooks:
- The Ammunition Ledger, blank and ready to set up
- The Ammunition Ledger Example, the same workbook with a season of sample entries so you can see every sheet working first

Opens in Excel 2010 or later and Excel for Microsoft 365. For Google Sheets, upload the file to Google Drive and open it with Google Sheets. Instructions are inside.

This is a spreadsheet file. Nothing prints or ships. It records. It does not advise on storage, quantities or the law where you live.

Digital download, so no returns. If a sheet does not behave, message me and I will fix it.

Pairs with The Owner's Record, the printable record of the firearms themselves, and The Handloader's Record for the ammunition you load.

Designed in Live Oak, Florida.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Firearm Inventory

Firearm Log

Reloading Spreadsheet

Reloading Log Book

Listed on Sep 16, 2026
One favorite
Homepage Art & Collectibles Prints Digital Prints