The Google Sheet is a rite of passage for card sellers. You start selling, you set up a tracker, you feel organized. For a while, it works.
Then it doesn't. The sheet gets slow. You start skipping entries. The formulas break when eBay's fee structure changes. You realize your P&L tab and your inventory tab have different card counts and you're not sure which is right. You want to check comps on a card while you're at a show but the mobile experience is terrible. You finally just stop updating it.
At that point, you don't have a tracking system anymore — you have a partial record that's less accurate than nothing, because it gives you false confidence in wrong numbers.
This is the point where most serious sellers look for a dedicated sports card inventory tracker. Here's what to look for, what spreadsheets get wrong, and what a real inventory system looks like for a growing card business.
What Spreadsheets Get Right
Let's be fair: spreadsheets are genuinely good tools for early-stage card tracking. If you're flipping 10–20 cards a month and want to know your basic cost vs. revenue, a simple Google Sheet does the job. It's free, flexible, you can customize the columns exactly how you want, and you already know how to use it.
The problems emerge at scale. Once you're managing 200+ cards across multiple platforms, platforms selling simultaneously, cards in grading, and inventory that changes daily, spreadsheets hit a wall on several dimensions.
Where Spreadsheets Break Down
What Every Card Should Track in Your Inventory
When you log a card to your inventory, you should capture:
- Card details: Player, year, set, variation/parallel, card number if applicable, condition (raw or graded)
- Cost: What you paid (purchase price + shipping to you if relevant)
- Acquisition date and source: When you bought it and where (card show, eBay, group break, etc.)
- Storage location: Box number, binder, case — important once you have hundreds of cards
- Listing status: In inventory, listed on eBay, listed on WhatNot, at grader, sold, etc.
- List price (if listed): What you're asking
- Market value: Latest eBay comp — ideally updated regularly
When a card sells, the record should update to capture:
- Sale price and platform
- Platform fee (calculated automatically based on platform and price)
- Shipping cost (actual, not buyer-paid)
- Sale date
- Net profit and ROI (auto-calculated)
The Inventory Snapshot: Know What You Own Right Now
A good inventory tracker gives you instant answers to questions you're constantly asking:
- How many cards do I currently have in inventory?
- What's my total cost basis (capital tied up)?
- What's the estimated current market value of my inventory?
- Which cards have been sitting the longest without selling?
- What's listed on eBay right now vs. unlisted?
- How many cards are currently at graders, and what's the estimated value when they return?
With a spreadsheet, answering any of these questions requires manual counting and filtering. With a proper tracker, it's your dashboard — always current, always accurate.
One of the most underrated metrics for card sellers is total cost basis — what you have invested in unsold inventory right now. This number tells you how much capital is working vs. sitting idle. Cards that sit too long may be priced wrong, or they may just be in the wrong market. Knowing your average days-to-sell by card type helps you make better buying decisions.
Inventory Across Multiple Platforms
Most card sellers sell on more than one platform. You might have cards listed on eBay, some live on WhatNot, some at a recent card show, and some saved for a future group break. A good inventory tracker handles all of these in one place — so you never accidentally sell a card you already shipped, and you always know where every card is.
The key is a status system. Every card should have a current status that's always up to date:
- In inventory (unlisted, available)
- Listed (active on a platform, with platform noted)
- At grader (with grader and tier noted)
- Sold (with sale date, price, and platform)
- Returned / Relisted (came back from grader, relisted)
How Inventory Tracking Connects to P&L
Inventory tracking and P&L aren't separate systems — they're the same data at different stages. When a card enters your inventory (with cost), that's the cost side of your P&L. When it sells (with platform fee and shipping), that's the revenue side. The gap is your profit.
Keeping these as separate spreadsheets means your data gets out of sync. You update the inventory sheet but forget to update the P&L sheet. You manually calculate fees but use last year's eBay rates. You realize in December that your "P&L" doesn't include 40 cards you sold in October that you forgot to log.
A single connected system eliminates these discrepancies. Log the card once, mark it sold once, and everything flows through automatically — inventory, P&L, and historical record.
One system for your whole card business
HobbyMetrics connects inventory tracking, eBay comps, grading submissions, and P&L in one app. Log a card once — everything else updates automatically. Free to start.
Start Free →Making the Switch From Spreadsheets
If you've been on spreadsheets and are ready to switch, the migration is simpler than it sounds. You don't need to enter years of historical data — just start with your current active inventory. Import what you have in stock today with cost and acquisition date, and let the new system handle everything going forward. Your historical data stays in the spreadsheet as an archive.
The time investment to migrate is usually 2–3 hours for a couple hundred cards. After that, the time you save every week on manual entry, formula-fixing, and data reconciliation adds up fast.
The Bottom Line
Spreadsheets are a starting point, not a destination. Once you're past the early stages of selling, the right tool is one that's built specifically for card sellers — with eBay comps built in, fees calculated automatically, inventory and P&L connected, and a mobile interface you can actually use at a show.
The goal is to spend less time on bookkeeping and more time on buying great cards, building your inventory, and actually growing your business. A proper inventory tracker is how you get there.