TCG collections get messy fast: hundreds of numbered cards per set, multiple rarities of the same card, sealed product sitting in a closet, and a want-list that lives in your head. A good tracking system fixes all of it — it tells you exactly which cards you own, how close you are to completing a set, what it's all worth today, and whether your buys and sells actually make money after fees. Here's a system that scales from one binder to a whole shelf.
1. Log the fields that actually matter for a TCG card
Sports cards and TCG cards need slightly different tracking. With Pokémon, One Piece or Magic, the same card exists in many forms — and the rarity and print are usually what drive the value. For every card, capture:
| Field | Why it matters |
|---|---|
| Card name | The core identity — Charizard, Luffy, Black Lotus, etc. |
| Set & set code | "Charizard" spans dozens of sets; the set is half the value. |
| Collector number | e.g. 4/102 — removes all ambiguity when you look it up or list it. |
| Rarity / variant | Holo, reverse holo, full art, alt art, secret rare, 1st edition — this is where value lives. |
| Language & edition | Japanese vs. English, 1st edition vs. unlimited — very different markets. |
| Condition or grade | Near Mint, Lightly Played, or slabbed (PSA 10, CGC 9.5, etc.). |
| Purchase price & current value | Your cost basis vs. recent comps — you can't see profit without both. |
| Location | Which binder, box, or deck — so you can actually find it. |
The rarity/variant field is the one sports-card trackers get wrong for TCG. A base Charizard and an alt-art Charizard from the same set share a name but can differ 100x in price. Capture the exact print or your value column is fiction.
2. Track set completion, not just individual cards
Half the fun of a TCG is chasing a full set — and set completion is its own kind of value. A master-set checklist turns a vague "I have a lot of Scarlet & Violet cards" into a concrete "142 of 198, missing these 56." That does three things:
- Stops duplicate buys — you stop accidentally re-buying cards you already have.
- Focuses your want-list — you know exactly which cards to hunt at the next show or online.
- Surfaces hidden value — a near-complete set is worth more sold together than card-by-card, and you can only see "near-complete" if you're tracking against the full checklist.
Keep a simple set-by-set completion sheet: set name, total cards, owned count, and the specific gaps. Update it every time you add a card.
3. Don't forget sealed product
TCG collectors hold something sports-card collectors usually don't: sealed product — booster boxes, elite trainer boxes, collection boxes, sealed packs. It appreciates differently from singles and is easy to lose track of because it sits in a closet, not a binder. Track sealed inventory separately with:
- Product & set (e.g. Scarlet & Violet 151 booster box).
- Seal status — factory sealed, resealed, or opened.
- Purchase price and date, and current market value.
- Quantity — sealed product is where "I think I have two of those" turns into real money you can't account for.
Sealed product is often the quietest-appreciating part of a collection. If it's not on a sheet, it's not in your net worth.
4. Calculate real profit per flip — after every fee
The number that fools people is "I paid $60 and sold for $120 — nice, $60 profit." That's not your profit. On most marketplaces your true math looks like this:
| Line | Example |
|---|---|
| Sale price | $120.00 |
| Marketplace + payment fees (~13%) | −$15.60 |
| Shipping & supplies (toploader, team bag, mailer) | −$5.00 |
| Grading cost (if slabbed) | −$18.00 |
| Original purchase price | −$60.00 |
| Actual net profit | $21.40 |
That "$60" flip was really $21.40. Track it honestly across every sale and a pattern emerges fast: which sets, rarities and price tiers actually make you money — and which just feel productive.
5. Update your portfolio value once a month
Pick one day a month, refresh the "current value" column from recent comps (TCGplayer market price, eBay sold, 130point), and total it — singles and sealed together. Two minutes of discipline gives you 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 trade negotiations trivial.
Spreadsheet, app, or printable — which is right?
All three work; they fit different collectors:
- Spreadsheet — infinitely flexible and free, but you build (and maintain) every formula and checklist, and it's clumsy at a table or a card shop.
- App — convenient scanning and price sync, 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 your binders.
Want the whole system done for you?
The TCG Vault is a printable PDF built around exactly this system for Pokémon, One Piece and Magic: a clean card inventory with rarity/variant and language fields, a set-completion tracker, a dedicated sealed-product log, a buy/sell profit tracker that nets out fees for you, plus a want-list 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 TCG Vault — $6 →Collect sports cards instead? See The Card Vault. Comics? The Comic Vault. Browse all three at The Vault.
FAQ
How do I track different rarities of the same card?
Treat each print as its own row. A base Pikachu, a reverse holo, and an alt art share a name but are different cards to the market — logging them separately (with the rarity/variant field) is the only way your value column stays honest.
Should I track sealed product and singles on the same sheet?
Keep them on separate sheets but total them together for net worth. Sealed product has different economics (it appreciates as a unit, and seal status matters), so it deserves its own log — but you still want one combined portfolio number.
Is it worth tracking a small collection?
Yes — small collections are the easiest time to start, before the backlog and duplicate-buys begin. The habit is what scales; the collection catches up to it.