A cellar you can read.

A wine cellar inventory turns a collection of bottles into a cellar you drink well. Without one, the failures are quiet: the wine opened five years past its best, the case bought twice, the bottle found at the back of the rack long after its moment passed.

The inventory needs to be accurate rather than elaborate, which means simple enough to update every time a bottle arrives or leaves. The usual mistake is the opposite: a beautiful spreadsheet started with enthusiasm and abandoned by the third case.

Why a wine cellar inventory earns its keep

• Timing. The point of keeping wine is to open it at the right moment. An inventory with a drinking window against every wine tells you what is ready tonight and what should wait.
• No duplicates, no orphans. Checking the list before you buy stops you ordering a case you already own. It also stops the single bottle at the back of the rack from drifting past its best.
• Insurance and estate. A current list of what you own, where it is and what you paid is among the first things an insurer or your family will ask for. It sits at the heart of the paper trail that documents a collection.
• Better buying. The list shows the gaps before you shop: nothing ready for the next three years, no whites for summer, no half bottles for a quiet weeknight.

What to record for each wine

Keep one line per wine, vintage and format, with a quantity, rather than one line per bottle. Then fill in these fields:

• Producer and wine. Written the same way every time, producer first, so that sorting and searching work.
• Vintage. Or NV for a non-vintage wine.
• Format. Half bottle, bottle or magnum. Formats age at different speeds, so a magnum and a bottle of the same wine deserve separate lines.
• Quantity. The number of bottles you hold now, not the number you bought.
• Location. Rack and bin at home. In professional storage, the account and case reference.
• Source. The merchant, the auction lot number or the person who gave it to you.
• Purchase date and price paid. For insurance and your own records, not for speculation.
• Drinking window. The first and last year you expect to enjoy it, adjusted as you taste.
• Notes. Anything future you will want: an occasion, a tasting note, a reason you bought it.

That list covers everything worth recording. If it feels like too much, start with the essentials: for a first cellar, the short list of columns in your first twelve bottles is enough. Add the rest as the cellar grows. More than the number of fields, what matters is that every wine has a location and a window.

When the last bottle of a wine is gone, do not delete the line. Set the quantity to zero and keep it. It holds what you paid, what you thought and whether you would buy it again, which is exactly what you want to know when the next vintage is offered.

Choosing a tool

A spreadsheet is enough for most cellars. It sorts by drinking window in a second, filters by location and costs nothing. Cellar apps help with scanning labels and reminders, but check that you can export your data in a plain format before you commit years of records to one. Paper works too, a bound notebook with a page per wine, provided you actually keep it.

Whatever you use, keep a copy somewhere other than the device you update it on. The inventory is a record of real value and it deserves the same care as the invoices behind it.

Knowing where every bottle is

A list without locations sends you rummaging through the rack with a torch. Draw the rack as a grid, number the bins from left to right and top to bottom and label each bin on the rack itself.

The plan shows a small rack mapped this way, with each bottle marked by its drinking window: ready now, ready in one to five years or later. Grouping bottles by window in this way puts the ones you should open next within easy reach and lets the long-term wines rest undisturbed. It also shows the shape of the cellar at a glance. A rack where every bottle carries the same mark is telling you something.

Move bottles as little as you can. When you do move one, update its location the same day.

The routine that keeps it alive

Three habits are enough.

1. Update at every movement. Record each purchase when it arrives and each bottle when it is opened, given away or broken. An inventory that is out by three bottles is one you stop trusting.
2. Look at what is ready every quarter. Sort by drinking window and note what has entered its window since the last review and what is nearing the end of it.
3. Keep a drink-next list. Six to twelve bottles that are ready and should be opened before anything else. When you need a bottle for dinner, choose from this list first.

An inventory you update every time a bottle moves beats a perfect one you update once a year.

The drink-next list does more work than it seems. It keeps good bottles moving, it stops you reaching for the same favourite every time and it makes the quarterly review a matter of topping the list up.

A well-kept inventory also doubles as your own wine list. Before a dinner, filter for what is ready, then choose by the food and the guests rather than by whatever is nearest the front of the rack.

If your wine is in professional storage

The facility's statement is your second record and the two should agree. Each time a statement arrives, match it line by line against your inventory: wine, vintage, format and quantity. Errors do happen. A case logged under the wrong vintage or a withdrawal never recorded is easy to put right in the same month and much harder years later.

It is also the moment to confirm that every case is held under your own name. Keep the facility's case or lot references in your own inventory. When you withdraw bottles, record where they went, whether to your home, a restaurant or a friend's table.

Tasting notes that help future you

Most tasting notes are written for the moment. The useful ones are written for the next bottle. Three lines are enough:

• The date and where the wine sits in its window: still young, opening up, at its best or tiring.
• Whether you would buy it again.
• When to open the next bottle and what it would suit at the table.

Then update the drinking window in the inventory to match. If you are short of time, skip the adjectives: the decision is the part future you will use.

Where to start

Start with what you have: count it, list it, map it. Do the first count with the rack in front of you rather than from memory or old invoices, because bottles you thought you had drunk and bottles you forgot you owned both turn up. Then keep it alive: log every bottle in and out and look at what is ready each quarter. When the list shows too many wines ready at once or nothing ready for years, the cellar needs rebalancing; planning a cellar that stays in balance explains how. If you are starting from scratch, a first-cellar session ends with a written plan you can turn straight into your first inventory.