How to track rounds fired (without a spreadsheet or app you don't trust)

Most shooters don’t actually know their round counts. We have a guess. “I’ve put about two thousand through it.” Two thousand or four? It matters — for maintenance, for wear, for knowing when a barrel is past its prime — and the methods most of us use to track don’t really give us the answer.

This is a practical look at what works, what doesn’t, and how to start counting in a way that doesn’t ask you to give up control of your data.

What round count actually means

Two numbers, really.

Per-firearm round count. Total rounds fired through this gun, accumulated across every range session you’ve put it through. Useful for service intervals, for knowing when a barrel is approaching its expected life, and for the basic question of “how worn in is this thing.”

Per-barrel round count. If you swap barrels — common with bolt rifles, AR-pattern uppers, and a lot of competition setups — the firearm’s count and the barrel’s count are different numbers. The firearm has been around longer than any single barrel. The barrel has its own life that the firearm’s logbook can’t tell you.

There’s also last-shot date — when did you last fire this firearm? — which isn’t a count, but is a question you should be able to answer in two seconds and usually can’t.

The paper notebook

This is where I started, and where a lot of shooters live. Pen, small notebook, range bag.

What it does well: capture in the moment, no batteries, no surveillance. You write the date, the firearm, the rounds, the conditions, the load, the notes. Nothing leaves your bag.

What it can’t do:

• Add anything up. If you want to know your round count for a specific firearm, you flip every page that mentions it and do mental arithmetic. Nobody actually does this; we estimate.
• Surface a last-shot date. Same problem. Flip until you find the last entry.
• Find a session from last spring. You know it’s in there. You can’t find it.
• Survive being lost. The only copy is in the bag.

I kept a notebook for years. I have a stack of them. The data is in there. I just can’t get it out.

The spreadsheet

The next step most shooters take is Excel, Google Sheets, or Numbers. A sheet for sessions. Maybe a sheet per firearm. Formulas to roll up.

What it does well: flexibility. You own the file. Free.

Where it falls down:

• Multi-barrel logic is a pain. Modeling “this barrel was on this firearm for sessions A through F, then I swapped it” with formulas alone is brittle.
• Out-of-service tracking has no clean place. A firearm at the gunsmith for two months should pause its tracking. In a spreadsheet, you mark it however you remember to mark it.
• Mobile entry is clumsy. Phones and spreadsheets are a long-running argument.
• Last-shot date is doable but ugly. A MAX(IF(...)) array formula every time.
• Your private spreadsheet probably isn’t private. If your file lives in OneDrive, iCloud, or Google Drive — and it almost certainly does, even if you don’t remember turning it on — then a third party with very different incentives than you has it. The “private spreadsheet at home” feels private. It usually isn’t.

If a spreadsheet works for you, good. Use it. Just check whether it’s actually local-only before you call it private.

What an actual tracking system looks like

The thing the notebook can’t do and the spreadsheet does poorly. The list:

• Quick to log. A range session entry takes under a minute. If it doesn’t, you’ll skip days.
• Adds up automatically. Round counts update themselves. So does last-shot date. You never copy a number from one place to another.
• Searchable history. “What load did I run last spring through the precision rifle, at 600 yards?” should be answerable in seconds.
• Per-firearm and per-barrel. Both numbers, separately, no formulas required.
• Out-of-service tracking. A firearm at the gunsmith comes off the active list and goes back on with one click.
• Genuinely private. No third-party analytics on what you logged. No AI services touching it. No data warehouse mining patterns across users. No exit-bound investors making decisions about your data in a board meeting you weren’t invited to.
• Yours to take with you. Full export, anytime, in a format you can read.

How Shooting Log Pro does it

That list is the spec for Shooting Log Pro. I built it when I got tired of working around my notebook.

• Sessions take a minute or two to enter. Round counts roll up across firearms and across barrels separately. Last-shot date is right there on every firearm.
• Out-of-service is a real concept: send a firearm to the gunsmith, mark it out of service with a reason, get it back, mark it in service. The history is preserved.
• Privacy isn’t a feature — it’s the design. No third party touches your firearm or session data. No third-party analytics, no error tracking on what you log, no AI services, no ad networks. Hosted in the US. Hard delete on account close. Full CSV export anytime.
• I run it. No outside investors. No exit plan. The Continuity Commitment spells out exactly what happens to your data if I ever shut it down or am acquired.

There’s a 14-day trial. No credit card to start. Two minutes to log your first session.

If you’ve been keeping a notebook, you can keep it. The notebook is a fine capture tool at the range. Use the app for the part the notebook is bad at — telling you what’s in it.