Cost Basis and Record Keeping for Bullion
Ask a long-time stacker what their average cost per ounce is and you will get one of two answers. Either a precise figure, or a vague shrug and a story about a shoebox. The difference between those two people is not intelligence or discipline in the market. It is whether they wrote things down at the moment of purchase.
Cost basis is simply what you paid, including the costs of acquiring it. It is the number every other useful calculation depends on: your unrealised gain, your true average price, whether a dealer offer is good, and in many jurisdictions the amount of tax you owe when you sell. Getting it wrong is expensive in a quiet, invisible way.
What belongs in the cost basis
The metal price is only part of it. A complete basis includes everything you had to spend to get the item into your possession.
- The purchase price of the item itself, including dealer premium over spot
- Shipping and insured delivery charges
- Any sales tax or VAT you were charged and cannot reclaim
- Payment surcharges — card fees, wire fees, currency conversion spreads
- Assay or authentication costs if you paid for them at acquisition
The fields to record for every purchase
You do not need accounting software. You need consistency. Every single acquisition should capture the same handful of facts, because a partial record is only slightly better than none.
- Date of purchase
- Item description: metal, product, mint or brand, year if relevant
- Quantity and gross weight
- Fineness or purity
- Total price paid, in the currency you actually paid in
- Seller name and a reference number or receipt
- Where the item is stored
Average cost versus specific identification
When you sell part of a holding, you have to decide which units you sold. Two conventions dominate. Average cost treats every ounce of a given product as interchangeable and uses the mean price you paid across all of them. Specific identification treats each purchase lot separately, so you can choose to sell the lot with the highest cost basis and reduce your reported gain.
Specific identification is usually the more favourable method, but it only works if your records are good enough to prove which lot went out the door. That is the practical reason to log purchases as separate lots rather than as one running total. Tax treatment varies significantly by country, and this article is general information rather than tax advice — check your local rules or speak to an accountant before relying on either method.
Rebuilding records you never kept
If you are years into stacking with nothing written down, do not let perfect be the enemy of useful. Reconstruct what you reasonably can, mark the rest as estimated, and start keeping proper records from today.
Bank and card statements are the best source, because they carry dates and amounts even when the receipt is long gone. Dealer accounts often keep a full order history going back years and can usually export it. Email searches for order confirmations recover a surprising amount. For metal bought privately or with cash, use the historical spot price on the approximate date plus a typical premium for that product, and flag the entry as an estimate so you never mistake it for a documented figure.
Storage, insurance and the estate question
Good records serve a second purpose that most people only think about too late. If something happens to you, whoever handles your affairs needs to know that the metal exists, what it is, and where it is. A holding nobody knows about is a holding that gets lost.
Keep a summary of your holdings somewhere your executor can find it, separate from the metal itself. Note storage locations in general terms rather than writing a burglary map. If you have insurance on the collection, your itemised list is exactly what the insurer will ask for after a loss, and an unsupported claim is a claim that gets reduced.
Where an app helps
A spreadsheet works perfectly well and costs nothing. The reason many stackers move to a dedicated tracker is that the spreadsheet stops being maintained. Manually refreshing spot prices, recalculating melt values and re-deriving average cost is tedious enough that people quietly stop.
BullionTally stores each purchase as a lot with its own cost basis, applies live spot prices automatically, and shows unrealised gain per item and across the whole portfolio. Your holdings data stays on your device, there is no mandatory account, and your portfolio is never sold or shared. If you would rather keep using a spreadsheet, that is fine too — the important thing is that something, somewhere, records what you paid.
Track your stack with BullionTally
Privacy-first tracking for gold, silver, platinum and palladium — live spot prices, 153 currencies, and your holdings stored on your device.