Why professional watch dealers outgrow spreadsheets
Spreadsheets get you to fifty watches. After that they start costing you money, and you won't see it until it's already gone.

Contentstap to expand
Short answer: a spreadsheet works for the first few dozen watches. As stock grows, it hides what each watch has really cost and how long it has sat, it cannot keep the tax scheme of a purchase in step with the invoice, it does not take a sold watch off your other channels, and client history ends up in chats. A system built around one record per watch fixes those four things; moving costs a week or two of work.
Many watch dealers start the same way: a shoebox of receipts, a WhatsApp group of other dealers, and one spreadsheet that grows a little wider every year. For the first thirty watches it is fine. Somewhere past fifty, something breaks.
The costs that do not show up in the sheet
Capital you cannot see. You know what you bought. You do not see what is sitting. A watch that has been in the safe for 180 days ties up capital every day, and no row tells you that unless someone writes and maintains the formula. See aged watch inventory and holding cost.
Costs that live elsewhere. The service bill is in a folder, the courier invoice in an email, the commission in a chat. The margin column in the sheet is the sale price minus the purchase price, and it is wrong. See profit per watch.
Tax handling that multiplies. Margin scheme, standard rate, intra-EU supply, reverse charge, export. The treatment is decided per watch at purchase. A sheet can record it; it cannot keep it in step with your Ankaufsrechnung and your sales invoice.
Channels that do not know. A Chrono24 listing that is still live after the watch sold on WhatsApp is a cancelled order waiting to happen. See overselling.
Client memory. "Who bought the Daytona last spring?" becomes a scroll through chat logs and old invoices. The relationship is in your head, not in your system.
What a system built for watches changes
The difference is not buttons. It is the model. Every watch is one record with its status, its tax scheme, its costs, its documents and its buyer. Invoices are written from that record instead of being retyped, and listings are built from it.
When that record is the source of truth:
- Margin includes every cost, and days in stock are visible per piece.
- The tax scheme is chosen once, at purchase, and the sales invoice follows it.
- Recording a sale updates the channels that are fed from your stock.
- Client history is a by-product of the invoices you write anyway.
The honest trade-off
Moving off spreadsheets is work. There is a learning curve and data to clean. The first week can feel slower than the sheet you know by heart. Plan the move: clean the columns that carry identity and money, import, and check counts and totals against the sheet. Our guide on moving watch stock out of Excel goes through it step by step.
How ChronoDesk helps
- One record per watch: reference with autocomplete from the ChronoDesk watch database, serial (kept private), year, condition, scope of delivery, buying price, date and source, tax scheme, location, photos and documents. Add watches from a spreadsheet, a PDF or photos of the piece and its papers, and confirm every field.
- Costs on the watch, each with a type and an optional receipt, plus days in stock and capital tied up per watch.
- Invoices from the record: the sales invoice follows the tax scheme chosen at purchase, as a PDF with embedded ZUGFeRD XML, numbers in sequence.
- Channels from one stock: record a sale in ChronoDesk and the Shopify product comes down, marketplace listings are delisted and the Chrono24 feed only carries watches still in stock. Sales made on those platforms are recorded in ChronoDesk.
- Customers with purchase history, total spent and wishes, and you are told when stock matches a wish.
FAQ
At what size should a dealer move off spreadsheets?
There is no fixed number. Many dealers feel it somewhere past fifty watches, or as soon as more than one person works on the stock or more than one channel is live.
Can I keep my spreadsheet next to the new system?
As a read-only archive, yes. Updating both leads to two different numbers within weeks.
What does a spreadsheet miss most often?
Costs after the purchase, days in stock, and the tax scheme of each watch. Those three decide the real margin.
ChronoDesk is free for 60 days. See the plans.