Watch Dealer Inventory Management: A Practical Guide
How watch dealers manage inventory: what to record for every watch, tracking cost, margin and stock age, spreadsheets vs software, and reports to review.
By Dejan Zoric
Updated 4 min read
The short answer
Good watch inventory management means recording every watch the day it arrives (reference, serial, set, condition, cost, source and photos), tracking its status, where it's listed and how long it's been in stock, and reviewing margin and stock age regularly so slow pieces get repriced or moved. A spreadsheet works for a handful of watches; dedicated software saves time and mistakes as you grow.
Key takeaways
- Record every watch on arrival: serial, set, condition, cost, source, photos.
- Track status and where each watch is listed, so nothing is sold twice.
- Stock age is the number that quietly costs dealers the most.
- Know your margin on every piece, and who can see your cost prices.
- Spreadsheets work at first; software pays off as you grow.
On this page
Inventory is where a watch dealer's money lives. Every watch in stock is cash waiting to come back, and every watch you can't find, can't price or forgot you had is costing you. Good inventory management isn't glamorous, but it's what separates dealers who grow from dealers who are always surprised by their bank balance.
Record every watch the day it arrives
Create a record for each watch on the day it arrives, before it's photographed or listed:
- Identification: brand, model, reference, dial, year, serial.
- Set: box, papers or card (with date), tags, booklets, links.
- Condition: grade and specifics (see watch condition grading).
- Originality: any aftermarket or service parts.
- Source: who you bought it from and how (dealer, private, trade-in, auction), with their details.
- Cost: purchase price plus costs added later: shipping in, service, parts, polish.
- Photos on arrival, including the serial, for your own records.
- Date acquired.
That record protects you in disputes, with tax, with insurance, and if a watch is ever questioned as stolen.
Track status and where each watch is listed
As soon as you sell on more than one channel, it's easy to lose track. For each watch, know:
- Status: in transit, in for service, draft, listed, on hold, sold, traded, shipped.
- Where it's listed: your website, social, marketplaces, dealer networks.
- Asking price on each channel.
When a watch sells, take it down everywhere immediately. Selling the same watch twice is an embarrassing, reputation-damaging mistake.
Watch the age of your stock
Stock age, how long each watch has sat in inventory, is the number that quietly costs dealers the most. Money in a watch that isn't selling can't fund the next deal, and the market can move against you.
- Sort your inventory by days in stock, oldest first.
- Set review points (for example, 30, 60 and 90 days).
- At each point, act: reprice, offer it to dealers, put it in a trade, or auction it.
For why turnover matters so much, see watch dealer margins.
Know your margin on every piece
Your inventory should show, for every watch, the all-in cost and the margin at the current asking price. That tells you how much room you have to negotiate, and which watches you can afford to move quickly.
If you have staff, decide who can see cost prices. Many owners keep them private to themselves and senior staff.
Spreadsheets vs software
A spreadsheet works when you have a handful of watches: one row per watch, columns for the fields above, and a separate sheet for sold stock. It's free and flexible.
It starts to break down when:
- photos, listings and the spreadsheet are in different places;
- several people update stock;
- you're listing on several channels;
- you need to export records for an accountant.
That's when dedicated software saves time and prevents mistakes.
A starter spreadsheet layout
If you're starting with a spreadsheet, set it up properly from day one so it's easy to move later:
| Column | Example entry |
|---|---|
| Stock ID | Your own number, written on the watch's bag or tag |
| Brand / model / reference / dial | One column each, so you can sort and filter |
| Year and set | Card month and year; box, papers, links |
| Condition and originality | Grade, polishing, any aftermarket parts |
| Serial | Kept private; never in a shared tab |
| Source and date in | Who, how and when |
| All-in cost | Purchase price plus shipping, service and parts |
| Status and location | Safe, with a watchmaker, out on approval, listed, sold |
| Asking price and channels | Where it's listed, at what price |
| Sale date, price and buyer | Filled in when it sells |
| Days in stock | A formula from the date in |
Keep sold watches in a separate tab rather than deleting rows. Your sold history is your own price data, and your accountant will want it.
Physical checks and watches out of your hands
Records only help if they match what's in the safe. Once a month, count every watch against your list, and investigate any difference straight away.
Watches out of your hands need the most care:
- With a watchmaker: note the date sent, the work requested and the expected return.
- Out on approval with a client or another dealer: record who has it, since when, the agreed price and the return date, ideally signed by both sides.
- In transit: keep the tracking number and insurance details with the record until delivery is confirmed.
A watch that's "somewhere" is a watch you can't sell, insure properly or account for.
The reports to review
Weekly or monthly, look at:
- Total stock value at cost, and how much of it is older than 60 or 90 days.
- Sales and gross profit for the period.
- Average days to sell, overall and by brand or price band.
- Best and worst performers: which references sell fastest and which sit.
Those numbers tell you what to buy more of and what to stop buying.
Inventory habits that save money
- Record every watch on arrival, no exceptions.
- Take a watch down everywhere the moment it sells.
- Review stock age every week.
- Keep a file per watch (purchase, photos, sale, payment, shipping).
- Reconcile your inventory with your books monthly.
The bottom line
Good watch inventory management means a complete record for every watch, clear status and listing tracking, a close eye on stock age and margin, and regular reviews. Start with a spreadsheet if you're small; move to software as you grow. Either way, the habits matter more than the tool.
Manage your stock on Soda
Soda gives verified dealers an inventory manager with private cost and margin, one-tap publishing, invoices from every deal and live auctions to move slow stock. No commissions on your trades. See all features, then apply for access or book a demo.
Questions dealers ask
What should a watch dealer track for each watch?
At minimum: reference, brand, model, year, serial, set, condition, links, any aftermarket parts, cost and costs added (shipping, service), where it came from, date acquired, photos, status, where it's listed, asking price, and the sale details once sold.
Is a spreadsheet good enough for watch inventory?
For a few watches, yes. As stock grows, spreadsheets get harder to keep in sync with listings, photos and sales, and mistakes like selling a watch twice become more likely. That's when dedicated software pays off.
How long should a watch stay in inventory?
There's no fixed rule, but every watch should have a review date. Many dealers look again at anything that hasn't had serious interest in a few weeks, and act on anything older than a couple of months: reprice, offer it to dealers, trade or auction it.
Who should see cost prices in a watch business?
Usually only the owner and trusted managers. Salespeople may not need cost prices, and keeping them private protects your negotiating position.