Moving Watch Inventory Off a Spreadsheet

Moving watch inventory off a spreadsheetA spreadsheet holds watch inventory perfectly well until roughly fifty pieces, or the first time two people edit it at once. What breaks first is not the list — it is everything hanging off the list: cost that is spread across six columns, photographs that live on a phone, and consignment stock that belongs to somebody else. Export to CSV, decide what a row actually means, and move it somewhere that can hold a watch and its history together.Cost stops being one numberPurchase price is the easy part. A watch also absorbs service, polishing, a new crystal, courier both ways, insurance, merchant fees and GST. On a spreadsheet those become columns people forget to fill in, so the margin at the bottom is the margin on the purchase price, not on the watch.Two people, two versionsThe moment a second person needs the file, you are reconciling copies. The one on the laptop has the sale; the one in the drive has the new stock. Neither is wrong and neither is complete.Photographs live somewhere elseA spreadsheet cell cannot hold twelve photographs of a bracelet. They end up in a phone roll or a folder named after a reference number, and they are gone by the time somebody asks about condition at sale.Consignment is not stockStock you own and stock you hold for someone else behave differently: reserve price, commission, payout, return. A spreadsheet will let you mix them in one tab, and the first time you report on value you will count money that was never yours.Nothing tells you anythingA list is passive. It will not tell you a watch has been sitting for 180 days, that a client has been waiting since March for a Submariner, or that this brand has lost you money three times running.History is overwrittenChanging a price in a cell destroys the old one. You lose what you paid, what you asked, what you dropped to, and when — which is exactly the record you need to price the next one.

Reference number — the key everything else hangs off, and what makes bulk import worth doing

Brand, model and year

Serial number, kept separate from the reference

Condition, graded consistently rather than described in prose

Box, papers, links, and whether it is a full set

What you paid, and the date you paid it

Every cost since: service, polish, parts, freight, fees

Asking price, and the floor you will not go under

Where it physically is

Whether you own it or hold it on consignment, and on what terms

Export what you have, as it isDo not tidy the spreadsheet first. Export it to CSV untouched, so you keep a copy of the thing you are migrating from. Tidying before you have a second copy is how people lose a year of records.Decide what one row meansMost spreadsheets drift into holding two kinds of thing — owned stock and consigned stock, or stock and sold items — in one tab. Split them before import. It is far cheaper than separating them afterwards.Fix reference numbers, ignore the restReference numbers are the one field worth cleaning by hand, because a correct reference fills in brand, model and specification automatically. Everything else can be corrected later, in place.Import, then reconcile against the safeImport the file, then walk the safe with the list on a phone. The discrepancies you find are not import errors; they are what the spreadsheet had been quietly wrong about.Add the costs you have been carrying in your headFor each piece, add the service and polishing you have already paid for. This is the step that changes the numbers, and it is the reason the migration is worth doing at all.When a spreadsheet stops being enough, what to capture instead, and how to move without losing the history you already have.The short answerWhat actually breaksNot the list. The things that hang off the list.What to capture per watchWhatever you move to, these are the fields that stop you guessing later.How to move, in orderFive steps. The order matters more than the speed.Running a workshop rather than a shop?Repair jobs have the same problem in a different shape: the tag goes missing and the service history goes with it.Import your spreadsheet and see the real numbersBulk CSV import, reference auto-fill from over 10,000 models, and true cost on every piece. $99 per month AUD, 14-day free trial, no credit card required.