A wine cellar inventory you can keep up

Give each kind of information its own place

• Wine: producer, full label, year, region, size and closure.
• Quantity: acquired, remaining and reserved bottles.
• Purchase: date, supplier, wine cost and extras in AUD.
• History: document references, condition observations and unknowns.
• Storage: location and movement notes.
• Plans: producer guidance, intended use and next review.
• Experience: opening date, impressions and buy-again preference.

Wine Ark includes origin, transport, storage and ownership in provenance (Wine Ark’s provenance framework). Your sheet organises the evidence you have; it doesn't verify a history merely because someone has entered it.

Use a separate row for a separate purchase lot

Suppose you buy 6 bottles from one supplier and later find 2 more of the same year elsewhere. Give them different lot IDs and rows. That preserves the different purchase dates, documents and storage accounts.

This is an example of record keeping, not a suggested order size. Split a lot further if individual bottles have important differences. Choose enough detail to preserve what matters without making every update an administrative event.

Keep the evidence easy to find

Store invoices, condition photographs and storage statements in a private folder, then put filenames or references in the sheet. Keep “seller reports” distinct from “document on file”. Those phrases establish different levels of support.

Check access permissions if the spreadsheet or folder is shared. Don't include payment-card information or identity documents. An initial sourcing enquiry doesn't need your complete inventory or the exact location of valuable bottles.

Update the record when the wine moves

On arrival, compare the label, vintage, format and count with the order. Add the lot, documents and location before putting the bottles away. If anything differs, record it and raise it through the seller's agreed process.

When you open a bottle, reduce the remaining count and add a short note. Keep reserved bottles visible so an anniversary purchase doesn't appear freely available for the next dinner. The total should describe reality, not your best recollection.

Use review dates rather than automatic deadlines

Record the producer's guidance with its reference and the date you consulted it. Keep your own next-review date separately so a suggested window doesn't become an automatic instruction to open or discard a bottle.

If you follow a wine over time, preserve each opening note in a dated log rather than overwriting the last one. This template doesn't provide valuations, insurance cover or investment advice. An estimated future value isn't an observed sale price.

Send the useful part of the list

Before an enquiry, extract the wines you'd like again, the missing vintages and the styles you want to explore. Add target quantities, priorities and budget. A focused request is more useful than asking the team to interpret the whole collection.

Back up the file and review it periodically. If a column doesn't help you decide, simplify the system. The best inventory is the one you can trust because you actually keep it current.

Choose a version you can keep current

Use the six-column sheet if you're starting: wine, vintage, format, remaining quantity, purchase-lot reference and location code. Add detail when it helps a real decision, rather than making every update a clerical project.

The filled example is entirely fictional. It keeps two purchases of the same wine in separate lots because their histories differ, and distinguishes bottles received from bottles remaining.

Download the six-column inventory (CSV) ↓

Download the fictional filled inventory (CSV) ↓

Use the drinking-window review log for decisions about timing and the moving log for handovers. Keep precise valuable-bottle locations private when sharing records.