Building a bottle-by-bottle inventory system

A serious bottle inventory is not a shopping list. It is a working record of what you own, what it cost, where it came from, what it is worth, and whether it can be proved in a claim, sale, or probate file. If a bottle cannot be identified from the record alone, the system is weak. The job is to capture enough detail that an insurer, auction specialist or executor can understand the asset without opening the cabinet.

Start with the bottle, not the collection

Every line in the inventory should describe one physical bottle, not a parcel or a case. That means one row per bottle, with a unique internal ID that never changes. Use a simple code such as GML-000127 for Glenmorangie bottle 127, then link every photo, invoice and valuation note to that ID. If you later move the bottle from a safe in London to a bank vault in Edinburgh, the identity stays intact.

The core fields should be fixed and boring: distillery, bottling name, bottler, expression, vintage, age statement, ABV, cask type, cask number, bottle number or outturn, bottle size, fill level, condition, purchase date, purchase price, seller or source, current location, and last valuation date. For single casks, note the outturn precisely. A release of 180 bottles is materially different from 1,200. That affects scarcity, resale depth and insurance logic.

• Unique ID
• Distillery and bottling name
• Vintage, age statement and ABV
• Cask number and bottle number/outturn
• Purchase date, source and price
• Location and last valuation date

Record value in a way that can be defended

Collectors often confuse purchase price with value. They are not the same thing. Your inventory should hold the original purchase price, but also the current market comp, the comp date, and the source of that comp. If the bottle is a Macallan 1926 or a Springbank single cask, a stale valuation is almost useless. For auction-based markets, the nearest credible comparables are usually recent realised prices from Sotheby’s, Christie’s or Bonhams, not an optimistic dealer ask.

Be disciplined about how you define a comp. Use the same bottling, same size, same condition band and, if possible, the same market region. A 70cl bottle sold in London is not always directly comparable with a 75cl US import. If there is no strong comp, say so. A blank field is better than a fantasy number. In a serious collection, accuracy matters more than false precision.

• Original purchase price
• Current market comp
• Comp source
• Comp date
• Currency used

Photographs are part of the record

Photos are not decorative. They are evidence. Every bottle should have at least four images: front label, back label, fill level at eye height, and capsule or closure. For high-value bottles, add close-ups of serial numbers, tax strips, import labels, wax cracks, ullage and any box or tube. If the bottle has a flaw, photograph it before it moves. Insurance claims are easier when the inventory already shows the condition.

Name image files with the unique ID and a date stamp, then store them in two places. A cloud backup is not a luxury; it is basic risk control. If you own fragile or expensive bottles, consider one photo showing the bottle beside a ruler or known reference to document height and shape. That is especially useful when the label is faded or the bottle is a less common historic format.

• Front label
• Back label
• Fill level
• Capsule or closure
• Box, tube or case
• Close-up of any damage

Spreadsheet first, but know its limits

For many collectors, a spreadsheet is the right place to start. It is cheap, flexible and easy to export when you need to share a catalogue with an insurer or executor. But a spreadsheet becomes fragile as soon as the collection grows, the movement history matters, or multiple people need access. One broken formula or duplicated row can create serious confusion.

A purpose-built tracker is worth paying for when the collection is large, high-value or actively traded. The advantage is not glamour. It is structure: controlled fields, image storage, audit trails, barcode or QR support, and user permissions. That matters if you buy across London, Hong Kong and online auction platforms. It also matters if you want to track bottles by cabinet, safe, storage unit or temperature-controlled cellar rather than by memory.

• Use a spreadsheet for small, stable collections
• Use a dedicated system when multiple users, movement logs or image libraries matter
• Export regularly so you are not trapped in one platform

Condition, location and movement are not optional

Condition notes should be plain and factual. Do not write “good” unless you define it. Record damaged capsule, nicked label, stained tissue, seepage, low fill, signs of recorking, or missing box. For older whisky, fill level can materially affect value. A bottle described as low shoulder is not the same as one sitting at high neck. If the bottle has provenance, note it separately from condition.

Location should be precise enough to find the bottle in an emergency. Cabinet number, shelf, vault, or safe deposit box is better than “home”. If the bottle is moved, record the date and destination. That is essential for theft recovery, but also for probate and insurance continuity. A collection with no location history is difficult to verify and slow to settle.

• Condition language must be factual
• Record ullage or fill level where relevant
• Log every movement with date and destination

Why unique IDs matter for insurance and probate

Insurance claims need proof of existence, ownership and value. Probate needs the same, plus clarity about what exactly is in the estate. Unique IDs solve a real problem: they separate identical bottles. If you own three bottles of the same Glenfarclas vintage, one with a box and two without, they are not interchangeable. A unique ID tied to photographs, invoices and comp data makes that distinction defensible.

For executors, a clean inventory reduces delay and dispute. It also protects against under-insurance, which is common when collectors rely on memory or on a single annual valuation. The practical standard is simple: if a bottle is valuable enough to worry about, it is valuable enough to document properly. A serious inventory should let another person reconcile the entire collection without guessing.