How to Track Your Watch Collection
Use a spreadsheet if you want total control of the fields and don't mind typing every spec by hand; use a dedicated app if you want references, case dimensions, and photos filled in from a catalog, plus a wear log you'll actually maintain. Either way, record five things per watch: the exact reference number, purchase date and price paid, service history, box-and-papers status, and how often you wear it. Cost-per-wear is the most useful number the log produces.
Spreadsheet vs app — the real tradeoffs
A spreadsheet's strengths are permanence and control: your data lives in a file you own, every column is one you chose, and it will still open in twenty years. Its weakness is that every field is manual. Reference numbers get typed with transposed digits, case dimensions get copied from forum posts instead of the manufacturer, and the "last worn" column stops being updated the second the novelty wears off — which defeats the main reason to keep a log at all.
A dedicated tracker inverts the tradeoff. On lug2lug, adding a watch to your collection pulls the reference, case dimensions, movement, and imagery from the spec catalog, so the record is correct at creation instead of correct-if-you-typed-carefully. Wear logging is the bigger difference in practice: marking today's watch takes one tap in the iOS app, and a log you update in one tap is a log that stays updated.
The honest summary: a spreadsheet is better at bespoke fields (provenance chains, insurance appraisals, multiple examples of the same reference), an app is better at everything that benefits from a catalog behind it — specs, photos, wear history, and comparisons against watches you don't own yet.
What to record for every watch
The exact reference number, not the model name. "Speedmaster" describes a dozen distinct references with different movements and different collector value; 310.30.42.50.01.001 describes one watch. Service centers, insurers, and future buyers all key off the reference.
Purchase date and the price you actually paid — not MSRP. When you eventually sell or insure the watch, the delta between paid price and market price is the number that matters, and memory is unreliable after a few years. If you care where a watch trades today, our value-retention guide covers how to read secondary-market numbers.
Service history with dates and what was done. A mechanical watch with a documented service at a known workshop is worth meaningfully more than the same watch with "serviced at some point, I think." Record the date, the workshop, and whether parts were replaced.
Box and papers status, strap inventory with lug widths, and condition notes (polished or unpolished matters to buyers). Finally: wear. Which watch you actually put on, day by day, is the one field nothing else in the log can reconstruct later.
Cost-per-wear is the number that changes behavior
Cost-per-wear is the price you paid, minus what the watch would realistically sell for today, divided by the number of times you've worn it. A $1,000 watch that would resell for $600 and has been worn 200 times has cost you $2 a wear. The same watch worn ten times has cost you $40 a wear — more per wear than a watch four times its price that you reach for daily.
The metric only works if the wear log is real, which is why logging friction matters so much. Tracked over a year, it answers the two questions every collector argues with themselves about: which watch to sell (the one with the stubbornly high cost-per-wear that you keep skipping), and whether the expensive watch you're eyeing is defensible (it is, if you'll genuinely wear it — a daily watch amortizes almost anything).
Your wear history and per-watch stats live in My Watches once you've logged a few days.
When a spreadsheet is still the right call
Vintage-heavy collections are the clearest case: a 1960s watch with a replaced dial, a period-correct-but-not-original bracelet, and a three-owner provenance chain needs free-form fields no structured tracker offers. The same goes for collectors holding multiple examples of one reference, or anyone whose log doubles as an insurance schedule with appraisal documents attached.
The pragmatic setup many collectors land on is both: a spreadsheet as the archival record (purchase documents, serials, service invoices) and an app for the living data — wear, current market context, and the catalog around it. The two jobs are different enough that forcing one tool to do both usually means doing both badly.
Common questions
What is the best way to track a watch collection?
For most collectors: a dedicated tracker for specs, photos, and wear logging (the data that benefits from a catalog behind it), and optionally a spreadsheet for archival records like purchase documents and service invoices. The deciding factor is wear logging — it only produces useful numbers if updating it takes seconds.
What should a watch collection spreadsheet include?
At minimum: exact reference number, purchase date, price paid, current estimated value, service dates and workshop, box/papers status, strap inventory with lug widths, and condition notes. Add a wear count column if you'll maintain it honestly — it's the field that makes the rest actionable.
How do you calculate cost per wear on a watch?
Price paid, minus realistic resale value today, divided by times worn. A $1,000 watch worth $600 used and worn 200 times cost $2 per wear. It's a better decision metric than purchase price because it accounts for both depreciation and whether you actually wear the watch.
Should I record my watch serial numbers?
Yes — privately. Serial numbers are what police reports and insurance claims key off if a watch is stolen, and they help authenticate the watch at resale. Keep them out of public collection posts and photos: a serial visible online can be cloned onto counterfeit paperwork.
See also
Every claim in this guide traces back to the spec catalog — case dimensions, movements, and list prices you can check yourself. A free account adds a collection tracker and wear log on top of the same data.