If your collection lives in a shoebox, a camera roll, and your memory, you don't really know what you own — or what it's worth. A good tracking system fixes three things at once: it tells you what you have, what it's worth right now, and whether your flips are actually making money after fees. Here's a system that holds up whether you have 50 cards or 5,000.
1. Log the seven fields that actually matter
Most people over-complicate this. You don't need 30 columns — you need the handful that let you find a card, value it, and prove ownership. For every card, capture:
| Field | Why it matters |
|---|---|
| Player & year | The core identity of the card. |
| Set / parallel | A base card and a /25 parallel are wildly different in value. |
| Card number | Removes all ambiguity when you look it up or sell it. |
| Condition or grade | Raw (est. grade) vs. slabbed (PSA 9, BGS 9.5, etc.). |
| Purchase price | Your cost basis — you can't calculate profit without it. |
| Current value | Update from recent comps (eBay sold, 130point, market apps). |
| Location | Box A, binder 3, at PSA — so you can actually find it. |
That last one is the field everyone skips and everyone regrets. "Where is it?" is the question you ask most once a collection grows.
2. Keep a grading submission log — separate from your inventory
The moment you send cards to PSA, BGS, SGC or CGC, they leave your shelf and enter a black hole for weeks or months. A submission log is how you keep control. Track:
- Submission number & date sent — your reference for the whole batch.
- Service level (e.g. Value, Regular, Express) and the per-card cost.
- Declared value per card.
- Date returned and the grade received.
Not sure which grader to send to? See our companion guide: PSA vs BGS vs SGC vs CGC — which grading company to use.
Why bother? Because grading is a bet. A $30 raw card that comes back a PSA 10 might be worth $200; the same card at PSA 8 might be worth $35 — a loss once you count the grading fee. Logging every submission is the only way to learn your own gem-rate and stop submitting cards that don't pencil out.
3. Calculate real profit per flip — after every fee
The number that fools people is "I bought it for $40 and sold for $90 — nice, $50 profit." That's not your profit. On most marketplaces your true math looks like this:
| Line | Example |
|---|---|
| Sale price | $90.00 |
| Marketplace + payment fees (~13%) | −$11.70 |
| Shipping & supplies | −$5.00 |
| Grading cost (if slabbed) | −$18.00 |
| Original purchase price | −$40.00 |
| Actual net profit | $15.30 |
That "$50" flip was really $15.30. Track it honestly across every sale and a pattern emerges fast: which players, sets, and price tiers actually make you money — and which just feel productive.
4. Update your portfolio value once a month
Pick one day a month, refresh the "current value" column from recent comps, and total it. Two minutes of discipline gives you something most collectors never have: a real, dated net-worth line for the hobby, and a chart of whether the collection is climbing or sliding. It also makes insuring your collection and estate conversations trivial.
Spreadsheet, app, or printable — which is right?
All three work; they fit different people:
- Spreadsheet — infinitely flexible and free, but you build (and maintain) every formula, and it's clumsy at the kitchen table or a card show.
- App — convenient scanning, but you're locked into their fields, often a monthly fee, and your data lives on their servers.
- Printable PDF — write by hand or fill on a tablet in GoodNotes/Notability, zero subscription, and it doubles as a physical record that travels with the cards.
Want the whole system done for you?
The Card Vault is an 8-page printable PDF built around exactly this system: a clean collection inventory, a dedicated PSA/BGS/SGC grading submission log, a buy/sell profit tracker that nets out fees for you, plus wishlist, set-completion and a monthly portfolio-value sheet. Print unlimited copies at home or fill it on a tablet. Instant download, one-time $6, no subscription.
Get the Card Vault — $6 →Collect Pokémon, One Piece or Magic instead? See The TCG Vault. Comics? The Comic Vault. Browse all three at The Vault.
FAQ
How often should I update my card tracker?
Log new pickups and sales the same day — it takes seconds and stops the backlog that makes people quit. Refresh values and total your portfolio once a month.
Is it worth tracking a small collection?
Yes — small collections are the easiest time to start, before the backlog exists. The habit is what scales; the collection catches up to it.
Should raw and graded cards go on the same sheet?
Inventory them together (with a condition/grade column) so your total value is in one place, but keep the grading submission log separate — it tracks cards that are in transit and the economics of the bet, which is a different question from "what do I own."