Why I Log Every Precious Metals Purchase (Most Stackers Skip This)

Most stackers focus on the buying — finding the best premiums, the right dealer, the perfect coin. But here’s what separates a smart stacker from someone who’s just collecting metal: knowing your numbers. Every purchase, every ounce, every dollar you paid.

This is my complete tracking system — the exact spreadsheet columns I use, the free tools I rely on, and a tax strategy called specific identification that most stackers have never heard of. That last part can save you real money when you sell.

Why the IRS Makes This Non-Optional

Let me paint you a picture. You’ve been stacking for a few years. You’ve got a mix of Silver Eagles, Gold Maples, some constitutional, maybe some bars. Spot runs up and you decide to sell some of your Eagles. Your dealer sends you a 1099-B, and now the IRS wants to know your gain. You’re sitting there trying to remember — did I buy those in 2021 or 2022? Was spot at $24 or $28? Was it APMEX or JM Bullion?

If you can’t answer those questions with documentation, you have a problem. You either have to guess — which could mean overpaying taxes — or you could potentially underreport, which is worse.

Here’s the reality: the IRS classifies gold, silver, platinum, and other precious metals as collectibles. Not stocks, not bonds — collectibles. That classification comes with a maximum long-term capital gains rate of 28%, compared to the 20% max on most long-term stock gains. Precious metals are taxed harder. And if you’ve held for less than a year, it’s short-term — taxed as ordinary income at whatever your bracket is.

Your holding period is determined entirely by your purchase date. No purchase date on record means you lose the argument with the IRS. That’s why tracking isn’t optional. It’s the foundation.

What to Record for Every Purchase

These aren’t arbitrary fields. Each one serves a specific purpose.

Purchase date. The most important field. It establishes your holding period, determines whether a future sale is short-term or long-term, and ties the transaction to a specific tax year.

Item description. Be specific. Don’t write “silver coin” — write “2022 American Silver Eagle 1 oz.” The more specific, the better, especially when you have multiple years or versions of the same coin.

Quantity. How many units? One tube of Eagles is 20 coins — log them as 20 individual ounces, not as one tube. You may sell them individually later.

Vendor or dealer. APMEX, JM Bullion, SD Bullion, local coin shop — log it. If you ever need to pull order history to verify a date or price, knowing the dealer gets you there fast.

Total price paid. This is your cost basis, and it includes everything — coin price plus shipping plus any fees. People forget shipping constantly. If you paid $1,850 for a Gold Eagle plus $12 shipping, your cost basis is $1,862. That matters when you calculate your gain.

Price per ounce. A calculated field: total price divided by troy ounces. Lets you see your average acquisition cost across your whole stack over time.

Optional: payment method (some dealers charge a credit card fee), and a notes field for context like “monster box deal” or “local coin shop find.”

That’s the complete log. It takes about 60 seconds per purchase, and future you will be grateful.

The Two Tools I Actually Use

I use two tools together. They each do something different.

Tool 1: Google Sheets. This is my master record. I own it, I control it, it never goes away if an app shuts down or a website changes. My sheet has two tabs — one for purchases and one for sales. Every transaction goes in within 24 hours of placing the order, while I still have the confirmation email open.

The purchase tab has all the fields above. The sales tab mirrors it but adds sale date, sale price, and a formula that automatically calculates my gain or loss and flags whether it’s short-term or long-term based on the dates.

Tool 2: APMEX Portfolio Tracker. This handles the real-time side. Once I log a purchase into the sheet, I add it to APMEX too. It pulls live spot prices and shows what my current portfolio is worth at market. This is where I go when I want to know what my stack is worth today — not what I paid, but what I could potentially get for it. You can also feed this data into aggregators like Empower’s net worth tracker if you want a complete financial picture.

The two tools together give you a complete picture: cost basis from the sheet, current market value from the tracker.

Specific Identification: The Strategy Most Stackers Miss

Here’s the part worth paying close attention to.

When you sell precious metals — say, a Gold Eagle — and you’ve bought that same coin multiple times at different prices, the IRS lets you choose which specific coin you’re selling. This is called the specific identification method, and it’s one of the most powerful tools available to a stacker who has kept good records.

Here’s a real example using current prices. Say you bought three 1 oz Gold Eagles over the past few years:

Coin A: January 2022 — $1,900
Coin B: August 2023 — $2,100
Coin C: March 2025 — $3,800

Gold is now at $4,500 and you want to sell one coin. How you handle this can make a serious difference.

Default (First In, First Out): If you don’t specify, the IRS defaults to FIFO. You’re selling Coin A at a gain of $2,600. Coin A is long-term, so you’re in the collectibles bracket at up to 28%. On a $2,600 gain, that could mean $728 in federal tax. Real money.

Specific Identification — minimize the gain: You identify Coin C, bought in March 2025 for $3,800. Your gain drops to $700. You just cut your taxable gain by $1,900 — potentially over $500 in tax savings on a single coin.

Specific Identification — tax loss harvesting: Say gold pulls back to $2,000. Coin B, bought at $2,100, is now at a loss. You sell it, realize the loss, and use it to offset gains from other sales that year — stocks, real estate, other metals. Then you buy back in. This is a standard strategy in stock investing, and it applies to precious metals too.

None of this is tax evasion. The IRS explicitly allows specific identification for collectibles. It’s the same method investors use with stocks and ETFs. It’s completely legitimate and built into the tax code.

The critical catch: you must identify the specific lot at the time of sale — not after. You can’t sit down in April doing tax prep and decide which coin you sold in October. The documentation has to exist when the transaction happens.

In practice, this means when you sell, you log it immediately on your sales tab: date, item, proceeds, and which specific lot you’re selling. Some people email themselves — a timestamp in your inbox works. Some screenshot the spreadsheet and text it to themselves. The method doesn’t matter as much as the timing. The record has to predate or match the sell date.

If you don’t have records, specific identification is gone. You’re stuck with FIFO, and the IRS picks for you. With gold around $4,500, first-in-first-out on coins bought years ago means maximum gains and maximum tax. Good records unlock this strategy. Bad records hand the IRS your wallet.

If You Haven’t Been Tracking — Reconstruct What You Can

If you’re just starting, don’t panic. Here’s how to fill the gaps.

Every major online dealer has order history. Log into APMEX, JM Bullion, SD Bullion, wherever you’ve bought — most have years of transaction history. Pull every order, note the date, item, quantity, and price paid. That gets you most of the way there.

For local coin shop purchases, check your bank or credit card statements for the date and amount. If you remember the shop, call them — some keep records. At minimum, a bank statement with a date establishes when you spent the money, even if the itemized detail is gone.

For gifts or inherited metals, the rules are different. Gifted metals generally carry over the original giver’s cost basis. Inherited metals typically get a stepped-up basis to the fair market value at the date of inheritance — which often means little to no taxable gain. That’s a significant benefit worth knowing about.

If you have gaps you simply can’t fill, document what you do know and consult a tax professional. A CPA who understands collectibles can help you establish a defensible position.

Action Items

Start the spreadsheet. Open Google Sheets and add columns for date, item description, quantity, dealer, and total price paid. That’s your foundation.
Reconstruct past purchases. Dealer order history, bank statements, credit card records. Even partial records are better than none.
Add a sales tab. When you sell, log the date, item, proceeds, and which specific lot you’re selling. That’s how you claim specific identification.
Add your holdings to a portfolio tracker like APMEX so you have real-time value alongside your cost records.
For significant sales, talk to a CPA who understands collectibles. The tax code here is nuanced, state taxes vary, and the documentation requirements are real. A one-hour conversation with the right person can save you far more than it costs.

The stacking community spends a lot of time on premiums, dealers, and spot price timing. The people who actually build wealth with metals are the ones who also know what they own, what they paid, and how to sell intelligently.

Your spreadsheet is part of your stack. Treat it that way.

This is not financial advice.