Watch inventory spreadsheet: fields and template

The fields a watch inventory sheet actually needs

A good inventory sheet answers three questions on sight: what is this watch, what did it cost and what's it worth, and where does it stand right now. Cram in too many columns and nobody keeps it current; leave out the essentials and it can't tell you your margin. The set below is the practical middle — enough to run a real dealing operation, structured so it maps cleanly to software the day you outgrow the sheet.

Organize your columns into three groups.

Identity — what the watch is

• Brand — e.g. Rolex, Omega, Patek Philippe.
• Model / reference — the model name and, critically, the exact reference number. The reference is what pins value, so never leave it vague.
• Serial number — unique to the piece; essential for provenance and for not confusing two similar watches.
• Condition — a short, consistent grade or note (unpolished, light wear, needs service).
• Box and papers — full set, watch only, or partial. This materially affects price, so track it explicitly rather than in a comment.

Financials — what it cost and what it's worth

• Purchase date — when it entered stock; lets you measure days-in-stock later.
• Cost (landed) — what you paid, ideally including service, shipping, and refurbishment.
• Asking price — your current list price, which you'll revise as the market moves.
• Sale price — filled in when it sells, so margin is a simple subtraction.

Ownership and status — where it stands

• Ownership type — owned, consigned, or on memo. This is the column dealers most often skip and most regret skipping, because it changes who gets paid when the watch sells.
• Status — in stock, on memo, reserved, sold, or returned.

When the sheet has done its job

These columns will carry you a long way, and there's no shame in running a lean operation on a well-kept sheet. The limits show up not in the data but in what a spreadsheet can't do with it: it won't push your asking price to a storefront, won't generate an invoice from a row, and won't total your sold pieces by brand without manual work. Those are the moments dealers move to watch inventory management software, and the reasons are laid out in tracking watch inventory without spreadsheets and how watch dealers manage inventory.

The reason this field list is worth getting right now is that the same structure transfers directly into connected watch dealer software — brand, reference, serial, condition, cost, ownership type, and status are exactly the fields it expects. So a tidy spreadsheet isn't wasted work; it's a clean on-ramp. WatchFlow's free Starter plan holds up to seven watches with no card, which is a low-risk way to see those columns become a live record that feeds your invoices and reporting instead of sitting inert in a tab.