The End-of-Year Wine Inventory Count, Without the Dread

Every winery has a version of the same December scene: clipboards, cold fingers, someone shouting case counts across the warehouse, and a spreadsheet that refuses to match reality by exactly 37 bottles. The annual count is unavoidable, for accounting, for tax, and for your own sanity. Here is how to run it so it is accurate, and how to make it dramatically shorter next year.

Before the count: preparation is most of it

• Freeze movements. Pick a count window and stop shipments and transfers during it. Counting a moving target is how phantom discrepancies are born.
• Clean up first. Consolidate half pallets, return strays to their zones, label anything unlabeled. An organized warehouse counts twice as fast.
• Close the paperwork. Enter every pending delivery, shipment, and bottling before counting. Most 'losses' are just paperwork that never happened.
• Decide units in advance. Count cases or bottles, not a mix. Partial cases get counted in bottles and flagged. Write the rule down; unit confusion is the classic count killer.

During: a method that produces trustworthy numbers

• Count in zones, in pairs. One counts, one records. Walk a fixed route through each location so nothing is skipped or double-counted.
• Count blind. Counters should not see the expected numbers. Blind counts find errors; counting toward a target confirms it.
• Do not forget the invisible stock. Bulk wine in tanks and barrels, unlabeled bottles, wine at bonded warehouses and distributors on consignment, samples in the office. Finished cases are the easy part.
• Recount only the gaps. Where the count disagrees with records, recount that SKU before hunting for explanations. Half of all discrepancies are counting errors, not missing wine.

After: reconcile and actually learn something

Adjust records to physical reality, then interrogate the pattern of the gaps. Consistent small losses on one SKU point to breakage or over-pouring at tastings; a missing pallet points to a shipment that was never logged; bulk wine short by more than evaporation explains suggests topping that went unrecorded. The count is not just an audit, it is the yearly diagnosis of which process leaks.

How the count shrinks to an afternoon

The count takes days when the records are reconstructed once a year. It takes an afternoon when the records are maintained continuously: every movement logged as it happens means the year-end exercise becomes verification, not archaeology. Producers running Oenova scan pallet QR codes zone by zone and compare against live records on the spot; discrepancies surface immediately, with the movement history right there to explain them. The free plan covers 5 SKUs and 2 locations, which is exactly enough to make this December the last painful one.