BulkSilver.co
Independent physical-silver buying guides. Compare the delivered cost, not a screenshot.
Home / Blog / How to Track a Silver Stack: Inventory Fields, Cost Basis and a Year-End Review
Ownership · records

How to Track a Silver Stack: Inventory Fields, Cost Basis and a Year-End Review

A simple inventory system for physical silver: which fields to record, how to track cost per lot, why invoices matter for taxes and insurance, and a year-end checklist for December.

Published November 5, 2026Prices intentionally not frozenEducational guide
Quick answer

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.

Checking prices? Compare the delivered total.
Silver Gold Bull → Money Metals → Kitco → Bullion.com →
Partner links. We may earn a commission. Compare premiums, shipping, payment fees and the final checkout total; inventory and pricing change.

Lot summary calculator

Enter up to three lots. The output shows total fine ounces and weighted average cost per ounce across them.

Hypothetical defaults. An average is a summary; for taxes, ask a professional how lots should be identified when you sell.

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

FieldExampleWhy it matters
Lot ID2026-07-ALinks the record to the invoice and the physical items
Purchase date2026-07-14Determines holding period
Dealer / sellerDealer name or "local shop"Provenance and returns
Invoice numberFrom the confirmationProof of purchase
Product10 oz bar, brand, serialWhat a buyer will ask about
Quantity5Count check
Fine ounces50.00The number that is priced
Product subtotalFrom invoiceCost component
Shipping, fees, taxFrom invoicePart of total delivered cost
Total delivered costSum of the aboveCost per lot
Spot reference at purchaseOptionalLets you see the premium you paid later
Storage location"Safe, shelf 2" or a codeFind it; insurance
Condition / packagingSealed tube, assay cardResale quote
DispositionSold 2027-03-02, buyer, proceedsCloses 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.

  1. Reconcile the count. Physically count each storage location and compare it with the spreadsheet.
  2. Close sold lots. Make sure every sale this year has a date, buyer and proceeds.
  3. Gather this year's invoices and sale receipts for your tax preparer.
  4. Check insurance. Compare your total fine ounces with your coverage and any limits for bullion.
  5. Inspect condition. Note any toning, spotting or packaging damage, and replace desiccant.
  6. 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)

LotDateProductQtyFine ozSubtotalShip/fees/taxTotalLocation
2026-10-B2026-10-1210 oz bar, brand X, serials in notes440.00$1,380.00$20.00$1,400.00S2

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.

Price and risk note. This page describes general record-keeping practices for educational purposes. It is not tax, legal or insurance advice. Tax treatment depends on your circumstances and current law; consult a qualified professional. Bullion prices move, and physical silver can trade below your purchase price.

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.

Keep going

Dealer comparison

Compare live bullion options before you buy

Dealer premiums, shipping thresholds and inventory change. Compare the final delivered price before placing an order.

Silver Gold Bull → Money Metals → Kitco → Bullion.com →

Affiliate disclosure: we may earn a commission if you buy through these links, at no added cost to you. Dealer inclusion here is not a guarantee that any one dealer has the lowest price for your order.