How to track watch inventory as a dealer
Once you hold more than a handful of watches, memory stops being a system. A stock list that captures what you paid, when it arrived, and where it is turns a pile of watches into a business you can actually steer.
When you own two or three watches, you know each one by heart: what you paid, where it is, what you need to get for it. That knowledge doesn't scale. By the time a dozen pieces are moving through your hands, the details blur, and the watch you forgot about is the one quietly costing you money. A written stock list fixes that, and it costs nothing but the discipline to keep it up.
What every watch in stock needs
Think of each watch as a row, and each row as everything you'd want to know if a buyer called about it right now. At a minimum:
- A unique reference for the piece — your own stock number, plus the brand, model, and reference number so there's no confusion between two similar watches.
- What you have in it. The purchase price and every cost you've added since: service, polishing, authentication, shipping in. This is your cost basis, and it's what your pricing works back from.
- The date it arrived. The clock on your money starts here.
- Condition and completeness. Box, papers, extra links, the state of the bracelet and crystal, any service history.
- Where it physically is. Your safe, with a watchmaker, out on approval, or listed and awaiting a buyer.
- Its status. In prep, listed, on hold, sold, returned.
The IRS expects your purchase records to identify who you paid, the amount, the date, and a description of what you bought, so capturing those on the way in also covers what you'll need at tax time.[1]
Why the list earns its keep
A stock list isn't paperwork for its own sake. It answers questions you'll actually face:
- Which watches have sat too long? Sort by arrival date and the slow movers rise to the top, so you can reprice or move them before they eat more of your margin.
- How much cash is on the shelf? Sum the cost column and you know exactly how much of your working capital is tied up, and in what.
- What did this deal really make? With cost basis recorded, your profit on a sale is a subtraction, not a guess.
- Where is everything? A watch out with a watchmaker or a buyer is easy to lose track of. A location field means nothing goes missing between the safe and the sale.
Keep it current, or it lies to you
An inventory list is only as good as its last update. The failure mode isn't starting one — it's letting it drift, until the list says a watch is in the safe that actually sold last week. Two habits prevent that:
- Update on the event, not later. A watch changes status the moment it arrives, ships, sells, or comes back. Record it then, while the detail is in front of you, not from memory at the end of the month.
- Reconcile against reality. Every so often, physically count what's in the safe against what the list says should be there. A mismatch is either a data-entry slip or a real problem, and you want to find out which while it's small.
Let the records do more than one job
The details you capture for inventory are the same ones your listings, invoices, and bookkeeping need. A reference number, condition notes, and cost basis entered once should flow into the ad you post and the record you keep, instead of being re-typed each time with a fresh chance to introduce an error. Choosing a system — even a simple one — that keeps a single source of truth for each watch is what turns tracking from a chore into an advantage.
The numbers to track covers what those records tell you once you have a few months of them.
Common questions
Do I need software to track inventory, or is a spreadsheet enough?
A spreadsheet is enough to start, and it's how most dealers begin. What matters is that every watch has a row and every row is kept current. You move to dedicated software when the manual updating starts costing you more time than it saves, or when you want the same records to drive listings, invoices, and reports without re-entering them.
What's the single most useful field to track?
The date a watch came into stock. It's the one field you can't reconstruct later, and it's what tells you how long your money has been sitting in each piece. Everything about repricing and cash flow starts from that date.
Should consignment watches go in the same list?
Yes, but flag them clearly. You don't own them, so they don't tie up your cash the way bought stock does, but you're still responsible for them and you still need to know where each one is and whose it is.
Keep going
More on running the business
Records, paperwork and the unglamorous parts that keep a shop out of trouble.
Sources
General information, not legal, tax, or financial advice. Confirm anything that matters with a qualified professional.