How to Track Your Sports Card Collection ROI (Without Living in a Spreadsheet)
You bought a collection for $800. You've been listing cards on eBay for three months. You've sold $600 worth so far. Are you profitable?
Most resellers would say "not yet." But that's the wrong question. The real question is: do you actually know?
Once you factor in eBay fees, shipping supplies, grading costs, and the time you spent listing — the answer might surprise you either way. The only way to know is to track it properly.
The Problem With Spreadsheets
I've bought hundreds of collections. For years I tracked them in Google Sheets — a tab per collection, cost at the top, sales logged one by one. In theory, great. In practice, terrible.
The sheet was always two weeks behind. I'd forget a sale, lose a tab, or sell from three collections in one eBay session with no idea which sale came from where. And spreadsheets don't tell you why something is working — they just log numbers.
The 5 Numbers That Actually Matter
1. Acquisition cost — What you paid, all-in. Gas, shipping, any fees.
2. Gross revenue — Total selling price across all sales from that collection.
3. Platform fees — eBay takes ~12-15%. WhatNot takes 8% + processing. These compound fast.
4. Additional costs — Grading fees (PSA, BGS, SGC), shipping supplies, submission shipping. These hit your margin harder than most resellers realize.
5. Sell-through rate — What percentage have you actually sold? This tells you if you're sitting on dead inventory.
Real ROI = Gross Revenue − Acquisition Cost − Platform Fees − Additional Costs
The System That Works
Step 1: Log the Acquisition Immediately
The moment you buy a collection, create a record. What you paid, where you bought it, rough breakdown of what's in it. Don't trust your memory. Log it now.
Step 2: Connect Your eBay Account
At any real volume, manual entry is a losing battle. Connect your eBay store to a dashboard that pulls sales automatically and lets you tag each sale to the right collection.
Step 3: Log Grading Fees as Collection Expenses
You send 15 cards to PSA at $18/card = $270. Six months later you've completely forgotten that $270 when you're calculating what the collection made. Log every grading fee tied to the specific collection it came from. It changes the math dramatically.
Step 4: Track Sell-Through, Not Just Revenue
A collection that's made $1,200 but still has 400 cards left is a very different situation than one that's made $800 with 12 cards left. Sell-through rate tells you whether your pricing is right, whether to list faster, and when to close out a collection to free up cash.
Step 5: Compare Collections Against Each Other
After tracking 5-10 collections, patterns emerge: estate sale collections produce consistent mid-tier margins, "hot" collections bought at peak hype get squeezed, WhatNot liquidation lots turn fast but lower per card. You can't see these patterns in a spreadsheet. You need side-by-side P&L.
The WhatNot Variable
If you stream, you've got an extra layer. Cards from three or five different collections go into one stream. The question you need to answer: Are my WhatNot streams more profitable than just listing on eBay? That's genuinely hard without good tooling — you need revenue per stream, WhatNot fees (8% + 2.9% + $0.30/order for sports/TCG), collection attribution, and a platform comparison.
Most resellers never have this data. They run on vibes. Vibes aren't a business strategy.
What I Use
I built ResellPulse because I was doing over $2M a year in cards and couldn't tell you my actual margin on any given collection. ResellPulse connects directly to your eBay store, pulls sales automatically, lets you tag each sale to a collection, tracks grading fees as collection expenses, and shows real P&L for every collection in real time. It also tracks WhatNot streams separately so you see the platform-by-platform split.
Founding member price is $19/mo. Try it free →
The Bottom Line
Most sports card resellers know their gross revenue. Almost none know their actual margin. Without knowing your margin, every sourcing decision is a guess.
- Log acquisitions immediately
- Sync your eBay sales automatically
- Log grading costs as collection expenses
- Track sell-through, not just revenue
- Compare collections against each other over time
Do this for 90 days and you'll make better sourcing decisions than 95% of resellers out there. Because you'll actually know what's working.
Ty Wilson is a full-time sports card reseller doing $2M+ annually on eBay and WhatNot. He built ResellPulse to solve the tracking and analytics problems he couldn't find a solution for anywhere else.
ResellPulse is the business dashboard for eBay & WhatNot resellers. P&L by collection, stream analytics, daily coaching — $19/mo.
Try It Free →