Track every purchase as a lot: date, dealer, invoice number, product, quantity, fine ounces, total delivered cost and storage location. Keep the invoice. Fine ounces tell you what you own; delivered cost per lot tells you your cost basis when you sell; location and photos support insurance claims. Review it once a year, ideally in December, and keep a copy somewhere other than where the silver is stored.
Lot summary calculator
Enter up to three lots. The output shows total fine ounces and weighted average cost per ounce across them.
Why bother tracking a silver stack
Physical silver does not come with a brokerage statement. No one else records what you bought, what you paid, or where it is. A simple inventory solves four problems at once:
- Selling. You know exactly what you have and can quote it to a buyer accurately.
- Taxes. You can document what you paid for each lot.
- Insurance. You can show what was lost, with invoices and photos.
- Estate planning. Someone else can understand your holdings if they ever need to.
It also keeps you honest about the size of your position in fine ounces, which is the number every price comparison and every buyer ultimately uses.
The fields to record
| Field | Example | Why it matters |
|---|---|---|
| Lot ID | 2026-07-A | Links the record to the invoice and the physical items |
| Purchase date | 2026-07-14 | Determines holding period |
| Dealer / seller | Dealer name or "local shop" | Provenance and returns |
| Invoice number | From the confirmation | Proof of purchase |
| Product | 10 oz bar, brand, serial | What a buyer will ask about |
| Quantity | 5 | Count check |
| Fine ounces | 50.00 | The number that is priced |
| Product subtotal | From invoice | Cost component |
| Shipping, fees, tax | From invoice | Part of total delivered cost |
| Total delivered cost | Sum of the above | Cost per lot |
| Spot reference at purchase | Optional | Lets you see the premium you paid later |
| Storage location | "Safe, shelf 2" or a code | Find it; insurance |
| Condition / packaging | Sealed tube, assay card | Resale quote |
| Disposition | Sold 2027-03-02, buyer, proceeds | Closes the lot |
A spreadsheet is enough. Keep one row per lot rather than per coin; for bars with serial numbers, list serials in a notes column.
Cost basis and the tax angle
When you sell silver for more than you paid, the gain is generally taxable. The IRS says that net capital gains from selling collectibles, such as coins, are taxed at a maximum 28% rate, and that an asset held more than one year generally produces a long-term gain or loss (IRS Topic 409). How specific bullion products are treated, what counts in your cost, and how lots are identified when you sell part of a stack are questions for a tax professional. Your job as a record-keeper is to make those questions easy to answer.
- Keep every invoice, digital or paper, and link it to the lot ID.
- Record shipping, fees and tax paid as separate fields, not just the total.
- When you sell, record which lot the items came from, the date, the buyer and the proceeds.
- Keep receipts for selling costs such as shipping to a buyer.
Some dealer purchases of certain products and quantities are reported by the dealer to the IRS. Ask the buyer at sale whether they will issue a form, and keep a copy.
Photos, locations and the second copy
Photograph each lot when you receive it: the items, serial numbers on bars, and the packing slip. Store photos and your spreadsheet somewhere other than where the silver lives, such as an encrypted cloud folder or a drive kept elsewhere. A safe that holds both your silver and its only records protects neither if it is stolen or damaged.
For storage locations, many owners use codes rather than plain descriptions, so the inventory itself does not become a map. Make sure one trusted person knows how to find and read the records. The safe planning guide covers weight and space when you are sizing storage.
A December year-end review
The end of the year is a natural checkpoint. A 20-minute review once a year keeps records accurate.
- Reconcile the count. Physically count each storage location and compare it with the spreadsheet.
- Close sold lots. Make sure every sale this year has a date, buyer and proceeds.
- Gather this year's invoices and sale receipts for your tax preparer.
- Check insurance. Compare your total fine ounces with your coverage and any limits for bullion.
- Inspect condition. Note any toning, spotting or packaging damage, and replace desiccant.
- Back up the file to your second location.
If you are planning to sell next year, the review is also a good time to note which formats you would sell first. How to sell close to spot and what to expect when selling will help you prepare.
A sample row (hypothetical)
| Lot | Date | Product | Qty | Fine oz | Subtotal | Ship/fees/tax | Total | Location |
|---|---|---|---|---|---|---|---|---|
| 2026-10-B | 2026-10-12 | 10 oz bar, brand X, serials in notes | 4 | 40.00 | $1,380.00 | $20.00 | $1,400.00 | S2 |
All values are invented. The point is that one row tells you what you own, what it cost, and where it is.
Common record-keeping mistakes
- Recording piece counts but not fine ounces.
- Recording only the product price and forgetting shipping, fees and tax.
- Keeping invoices in email only, with no backup.
- Never marking lots as sold, so the inventory drifts from reality.
- Writing storage locations in plain language in a file anyone could open.
Tracking by format makes selling easier
Add a format column (bar, round, sovereign coin, junk silver) and a brand or product column. When it is time to sell, buyers quote by format and product, not by your average cost. A quick filter that shows "all 10 oz bars" or "all Eagles" lets you request accurate quotes in minutes. It also shows at a glance whether your stack has drifted toward one format, which can matter when you want to sell part of a position without breaking up large bars.
If you store silver in more than one place, add a subtotal of fine ounces per location so you can compare each location with its insurance limit.
A simple valuation column
It is tempting to add a live "current value" column. If you do, keep it simple: fine ounces multiplied by a spot reference you enter manually, labeled with the date. Remember that what a buyer will pay is a bid, which is usually below spot for many products and above it for some. A realistic valuation column uses a recent dealer bid for each format rather than spot alone. The long-term storage bar guide explains why format choices affect that bid years later.
Check more than one dealer shelf
A useful comparison starts with the same product size, quantity tier and payment method. The dealer review pages below are the stable jump-off points; current inventory and final checkout totals remain the source of truth.
Affiliate links on dealer pages may earn BulkSilver.co a commission without changing your price.
Use the existing BulkSilver tools
Frequently asked questions
What should I record for each silver purchase?
Date, dealer, invoice number, product, quantity, fine ounces, product subtotal, shipping, fees and tax, total delivered cost, storage location and condition. Add sale details when you sell.
How is silver taxed when I sell it?
The IRS says net capital gains from selling collectibles such as coins are taxed at a maximum 28% rate, and that assets held more than one year generally produce long-term gains or losses. Ask a tax professional how your specific products and lots are treated.
Should I keep invoices for silver I bought years ago?
Yes. Invoices document your cost and support insurance claims. Store copies somewhere other than where the silver is kept.
Is a spreadsheet good enough to track silver?
For most individual stackers, yes. One row per lot with the fields above, plus photos and invoices, is enough.
How often should I count my silver?
At least once a year. December works well because it lines up with gathering tax documents and reviewing insurance.