Cask management systems and inventory tracking

Why whisky stock is different

Most drinks inventory moves fast. Beer is brewed and sold within weeks. Whisky is distilled, filled into oak casks and left for years. Scotch must mature for at least three years in oak in Scotland. Many whiskies sit far longer. During that time the stock is not idle. It loses volume through the wood every year, changes strength and gains value as it matures.

That makes a whisky warehouse a ledger of thousands of individual assets, each with its own history. A cask management system is the software, or sometimes the spreadsheet, that records them. Our guide to how whisky is made gives the production background.

The record behind each cask

Each cask is a single row with a unique ID painted, stamped or tagged on its head. A sound record holds:

• Cask type, size and wood (American or European oak), previous fill and how many times it has been filled.
• Fill date, fill volume, fill strength and litres of pure alcohol (LPA).
• The spirit batch that went in, linking back to distillation records.
• Location: warehouse, bay, row and tier.
• Every regauge, sample and movement, with dates.
• Ownership, if casks are sold to third parties.

LPA is the key unit. It is volume multiplied by alcohol strength, corrected to 20 °C. It lets you compare stock regardless of how much it has been diluted.

Barcodes, RFID and the people with clipboards

Larger warehouses tag casks with barcodes or RFID labels so staff can scan as they move them. Smaller ones still rely on painted IDs and paper sheets entered later. The technology matters less than discipline. A scan that never happens is the same as a sheet that never gets typed up.

The common failure is location drift. A cask is moved to make room, the move is not recorded and two years later nobody can find it. Every stock check that turns up a cask in the wrong bay is a sign the move process needs fixing, not just the record.

Why the stock shrinks

Spirit evaporates through the oak. The usual figure quoted for Scotland is about 2% of volume a year. In Indian heat it is well above that. So a forecast that assumes the volume filled is the volume bottled will always be too high.

Good systems store a loss rate per cask type, size and position, measured from regauges. They project each cask's expected yield at its planned bottling date. Our guide to measuring cask losses explains how those rates are measured. If your dashboard shows a single flat loss percentage for all stock, ask where it came from.

What finance and planning should ask

• Age profile. How much LPA will be available at each age over the next five to ten years? This drives which products can launch when.
• Cask mix. How much is in ex-bourbon, sherry or other casks? Blends depend on it.
• Loss variance. Which warehouses or positions lose more than expected?
• Reconciliation. Does the system match the excise authority's bonded stock record? Rules vary by state and change, so the compliance team should hold the current notification.

For analysts building models, see cask inventory data models for how to structure the tables.

Where the numbers come from on the floor

Every figure in the system started with someone weighing a cask, drawing a sample with a valinch and reading a hydrometer or density meter. A strength reading taken without temperature correction, or a weight taken on an uncalibrated scale, flows straight into your forecast. When a number looks odd, the fastest fix is usually a conversation with the warehouse team, not a new formula.

Teams that understand the physical process, why a cask on a high rack loses more than one on the floor, ask better questions of the data and build forecasts the business can trust.

Valuation and the age curve

Whisky stock usually sits on the balance sheet at cost, but its sale value depends on age and cask. A cask that will make a 12 year old single malt is worth more in eight years than it is today, even after losses. Planning teams therefore look at stock as an age curve: litres of pure alcohol available at each future age, year by year.

Gaps in that curve are slow to fix. If too little spirit was filled five years ago, no amount of money today can produce five year old whisky next year. This is why distillery fill plans are set years ahead and why a cask system that cannot project yield by age is a planning risk, not just an IT issue. A wrong loss assumption compounds across every year of the curve.

Start with a reconciliation

If you are new to a whisky business, ask for one month's cask movement report next to a physical count of one warehouse bay. Walk the bay with the warehouse manager and check ten cask IDs against their recorded positions. The gaps you find will tell you more about the quality of the data than any dashboard.

Common questions

What is a cask management system?

Software or a structured register that records every whisky cask: its type, fill details, location, regauges and movements, so the distillery can track stock that matures for years.

Why does whisky inventory shrink?

Spirit evaporates through the oak during maturation. The loss is well above Scotland's commonly quoted 2% a year in hot climates like India.

What is LPA in a cask system?

Litres of pure alcohol: volume times alcohol strength corrected to 20 °C. It is the standard unit for comparing and valuing spirit stock.