Sommelier Wine Cellar Inventory Log

This template covers the core inventory checks a sommelier or cellar manager needs during a periodic cellar count. It is designed to verify bin location, bottle quantity, vintage, label condition, and storage environment such as temperature and humidity. It also helps confirm whether each SKU is above, at, or below par so replenishment decisions are clear.

Most cellars use it on a recurring cadence such as weekly, biweekly, or monthly depending on bottle turnover and storage risk. High-value or fast-moving programs usually need tighter recurrence, while low-volume cellars may only need a monthly count with spot checks in between. The right cadence is the one that catches misbins, shrinkage, and storage issues before they affect service.

A sommelier, cellar manager, beverage director, or another designated DRI should own the task. In larger operations, one person can count while another verifies entries for high-value bottles or critical discrepancies. The key is to assign a clear owner so the log produces one accountable record instead of multiple partial counts.

Yes, this template fits any operation that stores wine in bins, racks, or a dedicated cellar and needs repeatable inventory control. It is especially useful where service depends on accurate vintage availability and where premium bottles require tighter handling. You can adapt the same structure for restaurants, hotels, private clubs, tasting rooms, and wine retail back rooms.

The most common issues are misfiled bottles, outdated counts, missing vintages, and unnoticed climate drift. It also surfaces par-level gaps that can lead to stockouts during service. Another frequent problem is recording a count without checking the physical condition of the bottle, which leaves damaged labels, seepage, or cork issues undiscovered.

Add fields for bin location, producer, region, vintage, format, and par level if those are part of your workflow. You can also include condition notes, transfer history, and a verification step for high-value allocations or reserve bottles. If your cellar uses multiple storage zones, separate them into sections so the count follows the actual floor plan.

Yes, it works well alongside purchasing, POS, and beverage management systems because the output is a clear list of discrepancies and reorder needs. Use the log to flag items that need replenishment, correction, or investigation, then route those actions to the buyer or beverage lead. That keeps the inventory count tied to action instead of becoming a static spreadsheet.

An ad-hoc count often misses the same details every time because there is no fixed checklist item sequence or verification step. This template standardizes the count so each bottle is checked the same way, which improves consistency and makes discrepancies easier to compare across periods. It also creates a repeatable record for audits, handoffs, and trend review.