Free Precious Metals Inventory Spreadsheet

A clean, simple way for gold & silver stackers and coin collectors to catalog every coin and bar, track cost basis, and see current value at a glance. Excel + a printable PDF — no email, no signup.

⬇ Download Excel template ⬇ Printable PDF

100% free · no email required · works offline · your data stays on your device

Preview of the GoldPayroll precious metals inventory Excel template, showing columns for metal, description, quantity, fine ounces, purchase date, dealer, cost, and auto-calculated value and gain, with yellow spot-price cells.
A look inside the template — type your coins and bars, drop today’s spot into the yellow cells, and total ounces, value, and gain calculate automatically. Click to enlarge.

What's inside

Auto valuation

Enter today's gold & silver spot once and every holding's value, total fine ounces and unrealized gain calculate automatically.

Cost basis & gain

Log what you paid per lot and instantly see your gain or loss versus current spot — no formulas to write.

Gold, silver, coins & bars

Works as a silver stacking spreadsheet, a gold tracker, or a full coin collection inventory — eagles, maples, rounds, kilo bars, junk silver.

Private & offline

It's just a file on your computer. Nothing is uploaded, which makes it a solid home inventory for insurance or estate records.

How to use it

  1. Download the Excel template (or the printable PDF for a paper copy).
  2. Type today's gold and silver spot price into the two highlighted cells.
  3. Add one row per holding — metal, description, quantity, fine ounces per unit, and what you paid.
  4. Your totals, current value and gain update automatically. Done.

Want it automatic?

Skip the manual spot updates. The free live Vault Report pulls current prices for you, generates a professional print-ready PDF and a fold-and-file summary card, tracks your stack over time, and awards collectible Stackers Club rank seals as your stack grows.

Open the free vault → Want it on every device? Add a free account to sync.

Questions

How do I track my silver stack in a spreadsheet?
Download the free Excel template, enter one row per coin or bar (metal, description, quantity, fine ounces per unit, and what you paid), and put today's spot price in the two highlighted cells. The sheet auto-calculates your total fine ounces, current value and unrealized gain.
Is it really free?
Yes — the Excel template and the printable PDF are completely free, with no email address and no signup required.
Does it update prices automatically?
The spreadsheet uses a spot price you type in, so it works offline and keeps your holdings private. For automatic live prices, a PDF report and cross-device sync, use the free live Vault Report.
Can I use it as a coin collection inventory?
Definitely. It handles coins, rounds and bars in both gold and silver, and doubles as a home inventory for insurance or estate documentation. See the full Stackers Club if you'd like to earn rank seals for your stack.