An untracked collection can't be insured, can't be sold efficiently, and is almost certainly worth a different number than the one in your head — and a nine-column spreadsheet fixes all three in a single weekend. Collectors procrastinate on inventory because it feels like homework. It is. It's also the highest-leverage homework in the hobby, because every future decision — sell, hold, insure, trade — starts with knowing what you own and what it's worth.
The nine columns that matter
- Card name — plus enough detail to be unambiguous.
- Set and collector number — "Umbreon VMAX 215/203" is a different card from 095/203 by four figures.
- Variant/finish — holo, reverse, 1st edition, stamp. Variant confusion is the number one cause of collections being misvalued.
- Condition — NM/LP/MP/HP, graded where applicable with cert number. Be honest; our condition guide covers what those grades actually mean at sale time.
- Quantity.
- Price paid — the column everyone skips and everyone later wishes they had. It's your cost basis for taxes and the only cure for "I'm definitely up overall" self-deception.
- Date acquired.
- Current market price — with a "last updated" date.
- Physical location — "Binder 3, page 12" or "Slab box A". The column that turns a spreadsheet into a findable collection instead of a list of rumors.
That's it. Resist adding fifteen more columns on day one; unfinished perfect systems lose to finished simple ones every time.
Apps or spreadsheets?
Collection apps earn their place at the intake step: scanning cards with your camera beats typing, and automatic price refreshes are genuinely useful. Their weaknesses are structural — export limits, subscription walls in front of your own data, and the blunt fact that apps get discontinued and take your records with them.
The setup that ages best: a spreadsheet as the source of truth, an app as the scanner. Scan new acquisitions in an app if you like the workflow, then export or transcribe into your sheet. A sheet is yours forever, filters and sorts however you think, and attaches to an insurance claim without a subscription. If you only keep one system, keep the sheet.
How often to reprice
- Quarterly is the right default for a static collection. Card prices move, but not so fast that monthly updates repay the effort.
- Monthly if you're actively selling, because stale prices turn directly into mislistings.
- Always, immediately, before any big sale or trade — reprice the specific cards involved that day. And when you eventually sell in volume, sequencing matters more than you'd think; our collection exit strategy guide covers why.
- Sealed product gets repriced from current market too, not from what you paid — the Pack Value Calculator shows live sealed prices alongside what the box would actually return if ripped, which is a usefully sobering pair of numbers to store in the sheet.
Record the date every time you refresh. A valuation without a date is trivia.
The insurance angle: records or it didn't happen
If your collection is worth real money, your spreadsheet is half of an insurance claim. The other half is evidence that connects the list to reality:
- Photos — binder pages spread open, slab labels legible, boxes shelved. Re-shoot after major acquisitions.
- Receipts and order confirmations for significant purchases, saved to the same folder.
- Cert numbers for every graded card, which are independently verifiable.
- An off-site copy. Cloud storage counts. A meticulous inventory that burns in the same fire as the binders documents nothing.
Insurers pay claims on documentation, not on grief. Whether you need a policy at all — and when a homeowners rider stops being enough — is its own decision, covered in our guide to insuring a card collection.
FAQ
What's the best app to track a card collection?
The one you'll still be using in month three — scanning speed and clean export matter more than any feature list. Whatever you pick, keep a spreadsheet you own as the master copy.
How do I value my collection accurately?
Recent sold prices for your actual variant and condition, not listing prices and not near-mint prices for a played card. Expect realizable cash to run 15% or so below market after fees.
Is tracking worth it for a small collection?
If everything you own fits one binder and none of it clears $50, a photo of each page is plenty. Start the sheet the day one card makes you nervous to lose.