Cask inventory in spreadsheets vs. a dedicated system: the honest comparison

Every distillery's cask inventory starts in a spreadsheet, and that is fine. Excel is flexible, free-ish, and everyone can use it. This post is the comparison we'd want to read if we were on the other side of it: what spreadsheets genuinely do well, the specific signs you've outgrown them, and what actually changes with a dedicated system. (Yes, we sell one. The checklist works even if you buy someone else's.)

What spreadsheets genuinely do well

Credit where due. For a young distillery — a few hundred casks, one warehouse, one person keeping the records — a disciplined spreadsheet is:

• Infinitely flexible. New column, new tab, no vendor conversation.
• Transparent. Every formula inspectable, nothing hidden.
• Free of onboarding. No migration, no training, no subscription.
• Honest about its author. The person who built it understands it completely.

If your casks number in the hundreds, nothing is sold mid-maturation, vattings are rare, and the same person fills, records and files the W1 — a good spreadsheet plus discipline may truly be enough for now. The problems begin when any of those conditions stops being true.

The eight signs you've outgrown it

1. Month end takes days. The arithmetic on the W1 takes a minute; collecting and reconciling the eight numbers behind it takes days. If closing the month means cross-checking the cask ledger against the vatting sheets against the orders file, the spreadsheet has become a job.
2. There are two "master" files. The warehouse copy and the office copy, or Casks_2026_FINAL.xlsx and Casks_2026_FINAL_v2.xlsx. The moment two versions exist, one of them is wrong — you just don't know which.
3. One formula, one person.The VLOOKUP cathedral has a single architect. When they're on holiday, nothing is certain; when they leave, nothing is recoverable.
4. History gets overwritten. A regauge replaces the old figure in the cell. The OLA-to-RLA story — the thing HMRC, auditors and buyers actually ask for — no longer exists.
5. Sold casks keep getting picked. Reservations live in a column someone forgets to filter on, and a cask sold to a brokeris scheduled into next month's vatting.
6. Vattings don't balance. Inputs leave one tab, outputs appear in another, and the two kinds of loss — storage and operational — are whatever makes the total work.
7. Nobody can answer "who changed this?"A figure moved between September's return and October's opening stock. The spreadsheet has no idea who, when or why — and HMRC's first question at a visit is exactly that.
8. Traceability means archaeology."Which casks are in batch 24?" is an afternoon with filters rather than a click. Fine until a recall, an audit or an age-statement query makes it urgent.

Count honestly. One or two: tighten the discipline. Three or more: the spreadsheet is costing more than software would.

What a dedicated system actually changes

Not magic — structure. The differences that matter in practice:

One event, entered once. A regauge, a transfer, a vatting, a sale is recorded as a single event on the cask, and the stock ledger, the W1, the valuation and the trace all derive from it. The reconciliation disappears because there is nothing to reconcile — there was only ever one record.

History is append-only.Nothing is overwritten. Every cask carries its fills, regauges, movements and owners as a timeline, and every correction is itself a recorded event with an author. That is what "audit trail" means when HMRC uses the words.

The rules live in the system, not in memory. Sold and reserved casks are invisible to vatting planning. Losses split themselves into storage and operational. The month-end cut-off applies itself the same way every period. Discipline stops depending on the most careful person being in the room.

Returns build themselves. The W1 and W5are generated from the period's recorded events, with every line traceable to cask level. Month end becomes review-and-file, not reconstruct-and-hope.

Everyone sees the same truth. Warehouse, office, accountant, and (where you choose) brokers or owners — one live record, with permissions, instead of emailed copies aging at different rates.

The honest counterarguments

"Software costs money." It does. So does the alternative: count the loaded hours of month-end reconciliation, error-chasing and audit preparation across a year, and price the spreadsheet honestly. For most distilleries past a few hundred active casks, the spreadsheet is the more expensive option — it just bills in salary.

"Migration is painful." The cleanup is real: the migration isthe audit of your spreadsheet you've been deferring, and it finds the ghosts (casks that exist on paper only, or in wood only). That's an argument for doing it before HMRC or a buyer does it for you.

"We lose flexibility." Partly true. You lose the freedom to add a column nobody validates — which is also the freedom that created FINAL_v2.xlsx. A good system keeps the useful flexibility (your fields, your processes) and removes the dangerous kind (silent edits to history).

"We're not big enough yet."Maybe. But cask records are unusual: today's lazy record is permanent, because the cask matures for a decade and its paperwork matures with it. The cheapest time to get the record right is at the fill.

If you're evaluating systems

Whether or not you talk to us, interrogate any system on the eight failure points above: does it keep OLA and RLA with full history, enforce reservations, split losses correctly, build the W1 to cask level, and answer "who changed this" instantly? Our checklist for choosing distillery software goes through the full evaluation, vendor by vendor questions included.

And if you want to see the comparison on your own data rather than in the abstract: bring your spreadsheet to a demoand we'll load a sample of it live. The ghosts show up in the first half hour. They always do.