The Ammunition Ledger: nine sheets for Excel and Google Sheets

RC-08 · Records · New

The Ammunition LedgerAmmo Inventory and Round Count Spreadsheet

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.

9 sheets
Excel
Google Sheets
Example workbook

$12 Instant download

Sold and delivered through Etsy. Range Doctrine does not process payments on this site.

In Short

Log what you buy and log what you shoot. The Ammunition Ledger keeps the counts: stock by caliber, cost per round, reorder flags, round count per firearm, and service intervals that flag themselves.

Why It Is Different

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 that flags itself

Set how often each firearm is cleaned or serviced. The ledger marks DUE SOON and SERVICE DUE.

Real cost per round

Price paid includes tax and shipping, so cost per round is what the round really cost.

Range ammo handled

Shooting ammunition a range or a friend supplied? Mark it, and the round count rises without your stock falling.

Nothing to break

No macros, no add-ons, no account. Dropdowns keep names identical, which is where most home made spreadsheets go wrong.

What You Get

Start Here. Set up in four steps
Dashboard. Stock and service at a glance
Stock. One row per caliber, up to 30
Firearms. One row per firearm, up to 40
Purchases. Lots, storage and true cost
Range Log. Firearm, caliber, rounds, malfunctions
Adjustments. Counts, handloads, gifts
Service Log. Cleaning, springs, parts, gunsmith work
Lists. The choices behind every dropdown

What you download

The Ammunition Ledger, blank and ready to set up
The Ammunition Ledger Example, with a season of sample entries
Both in one zip. Opens in Excel 2010 or later, Excel for Microsoft 365, and Google Sheets

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

A Closer Look

Dashboard: rounds on hand, value, calibers to reorder, firearms due service

Stock by caliber with average cost per round and months of supply

Round count per firearm, with service due flags

Range Log: every entry adds to the firearm and comes off the caliber

Dropdowns keep caliber and firearm names identical on every sheet

Instant download

The Ammunition Ledger, $12

Buy on Etsy

Range Doctrine makes printable records, apparel and goods for the culture around shooting and hunting. We do not sell firearms, ammunition, firearm parts, or anything that attaches to a firearm. See the full catalog →