What's in the file

Six sheets, every figure a formula, every list a dropdown. No macros, nothing hidden.

Inventory

One row per item, with the fields a watch buyer asks about. Dropdowns wherever there is a list; cost, price and the margin as money. Three example rows show how.

Sold

One row per sale. Pick the item by its number and its name and cost come over; type the date, the channel, the sale price, the fees and the shipping, and the net profit and margin are worked out.

Summary

Stock on hand and its value at cost and at price, sales, fees and net profit, then the same by category and by channel. Formulas, so it keeps up as you add rows.

Plus a Field guide, the Lists sheet the dropdowns read from, and a Start here page.

What it looks like

The Inventory sheet, with the example rows. Dropdowns where you see the arrow; the margin works itself out.

Plus 18 more columns on Inventory: location, where and when you bought it, status, where it is listed, notes and the rest of the watch fields. The Field guide sheet lists them all.

When it stops keeping up

The same columns, as software.

A spreadsheet is fine for fifty watches and one person. It stops keeping up when two people edit it, when the same watch is on eBay and Chrono24 at once, or when a consignor asks what they are owed. That is where Sellevry starts: the same columns, with every watch listed from one card and the profit worked out for you. When you get there, send us the sheet and we move it in, free.

Questions

Is it really free?

Yes. You give us your name, your email and what you sell, and the file is yours. We may write to you once, personally, to ask how it is going. There is no automatic mailing and nothing to unsubscribe from.

Does it work in Google Sheets or Numbers?

Yes. It is a plain Excel file with no macros, so Google Sheets, Numbers and LibreOffice open it as it is. Upload it to Google Drive and open it with Google Sheets, or open it in Numbers on a Mac.

Which columns does it have?

The columns every item has: SKU, name, category, brand, condition, quantity, cost, price, margin, location, where you bought it, the date, its status, where it is listed and notes. Then the watch fields: case size, movement, case material, dial, year, serial number and band. The field guide sheet lists them all, with each dropdown's choices.

Can I add my own columns?

Yes. It is your file. Add a column for anything you track, such as service dates or polishing notes. If you later move to Sellevry, we bring your columns over as fields.

What is on the Sold sheet?

One row per sale: pick the watch by its number and its name and cost come over from Inventory; type the date, the channel, the order number, the sale price, the fees and the shipping, and the net profit and the margin are worked out. The Summary sheet adds every sale up by channel.

Do the dropdowns and formulas work in Google Sheets?

Yes. The dropdowns, the formulas and the formats come across when you open the file in Google Sheets. Numbers keeps the formulas and formats and shows the dropdown choices as plain cells. The choices live on the Lists sheet, so you can change them.

What happens when I outgrow it?

Send us the spreadsheet when you subscribe to Sellevry and we move your watches, stock, customers and past sales in, free on every plan. Moving 20,000 items takes about three days.