Every dealer starts with a spreadsheet. One tab, one row per watch, brand and model and asking price. It costs nothing and it works, right up until the day it doesn't: a watch shows sold on eBay but still sits active on Chrono24, or a want-list buyer never hears about the exact reference that just came in because nobody remembered to check the list.
That gap isn't a sign you're doing it wrong. It's what happens when one spreadsheet has to do a job that actually needs several systems talking to each other. Here's the template dealers actually use, free to download, and the specific places where it stops being enough.
What a Good Inventory Spreadsheet Actually Needs
Most dealer spreadsheets fail before they even get complicated, because they track the wrong things, or too many things. The columns that matter are narrower than people expect: brand, model, reference number, condition, year, purchase price, asking price, purchase date, box, papers, and notes.
Reference number does more work than model name ever will. "Submariner" describes a family. "126610LN" identifies the exact watch, and it's what a buyer actually searches for. Purchase price matters just as much as asking price: without a cost basis recorded at intake, you can't calculate margin later, only revenue, and revenue tells you what came in, not what you kept.
The free template below has these columns pre-filled with three realistic rows, a Rolex Submariner 126610LN, an Omega Speedmaster Moonwatch, and a Tudor Black Bay 58, so the expected format for dates, yes/no flags, and prices is obvious before you delete the examples and add your own inventory. Download it here.
Where the Spreadsheet Actually Breaks
A spreadsheet tracks what you own. It has no way to act on what happens next, and that's the real gap.
Sell a watch on eBay and the Chrono24 listing doesn't know. Someone has to remember to pull it, and remembering is exactly the step that fails at 11pm on a Tuesday. We've written before about what that single missed step costs: a seller defect, a search penalty, a buyer who doesn't come back.
A spreadsheet also has no view into the market. Your asking price column reflects what you decided months ago, not what the same reference is asking for on eBay right now. And a spreadsheet can't match new inventory against a want list. If a collector told you six months ago they wanted a specific Daytona reference, nothing taps them on the shoulder when it finally comes in. The match only happens if you remember, on the right day, that the list exists at all.
The Numbers a Spreadsheet Can Hold, But Can't Compute
A disciplined dealer can add a column for days listed, or manually subtract cost basis from asking price to estimate margin. Both are worth tracking. Neither updates itself.
The moment you stop maintaining a manual column, it goes stale, and a stale number is worse than no number, because it still looks trustworthy. Capital tied up is the clearest example: it only means something as a running total across your whole safe, recalculated the moment anything sells or ages further. That kind of upkeep is exactly what a spreadsheet depends on a person to remember, every day, forever.
Why Dealers Stick With It Longer Than They Should
Spreadsheets survive past their usefulness for a simple reason: switching feels like a project, and a project competes with sourcing and selling for the same hours. The honest math rarely gets run. An hour a week reconciling three tabs against three marketplaces adds up to fifty-two hours a year, which is more time than the switch itself would ever cost.
Putting the Same File to Work
That's exactly why the template above uses the same header row as Vericog's own CSV importer. The file that tracks three watches in a spreadsheet today is the same file that loads your whole inventory into Vericog the day you're ready. You don't retype anything or map columns by hand.
From there, an eBay sale queues the Chrono24 feed for removal automatically, asking prices sit next to live market data instead of a number you typed in March, and new inventory checks itself against every want list the moment it's added. If you'd rather see the upload happen than read about it, a demo covers exactly that, using your own inventory instead of the example rows.
The Takeaway
A spreadsheet is a genuinely fine way to start. Its limit is that a static file can't act on anything: it can't pull a listing, check a price, or remember a want list. Getting past that takes a connected system, not a better spreadsheet.
See the full Vericog vs. spreadsheets comparison if you want the longer version of this argument.
Want the exact file dealers use? Download the free inventory template. The same columns import straight into Vericog when you're ready to stop reconciling by hand.