Why Cellar Records Drift So Easily

Ask most pub operators how much stock is actually in the cellar and you will get a thoughtful pause followed by a rough figure. That is not a criticism of the people doing the job. It is the natural result of managing a wet stock cellar with a delivery note shoved in a folder, a chalk board by the hatch, and a spreadsheet that gets updated on a quiet Tuesday afternoon if there is time. Every handover, every busy Friday, every "just grab a keg from the back" moment erodes the accuracy a little further.

The trouble is that small inaccuracies hide big problems. A two per cent drift across a wet stock cellar can mask a leaking cooler, a case of spirits walking out of the back door, or a mis-tapped keg being poured and dumped. Because nothing throws up a red flag, nobody investigates. Barcode scanning does not fix poor cellarmanship, but it does close the gap between what you think is on site and what is genuinely there.

Scanning Deliveries at the Cellar Door

The highest-value scan happens in the first ten minutes of a delivery. Rather than ticking off a delivery note by eye while the driver waits impatiently, you scan every keg, case and box as it comes off the wagon. A basic Bluetooth scanner paired to a phone or tablet costs somewhere between £40 and £150, and most stock or EPOS apps will accept a scan straight into a goods-in screen.

The real benefit is timing. When a scanned line does not match the delivery note, the driver is still standing in your yard. That is the moment to raise a credit note, not three weeks later when the paperwork has been filed and the brewery's telesales team has no idea what you are talking about.

• Short deliveries are caught on the spot rather than discovered at stocktake.
• Wrong products — a keg of the wrong ale, a case of the wrong mixer — get refused before they are on your books.
• Double counting disappears, because a scanned keg cannot be counted twice in a single delivery.
• Price file errors surface early, so your cost of goods stays honest.

Transfers: The Kegs Nobody Remembers Moving

Internal transfers are where most accuracy quietly dies. A keg goes from the main cellar to the function room bar. A bottle of premium gin moves to the kitchen for a private dinner. A cask is loaned to a sister site for a beer festival and comes back a fortnight later, or possibly does not.

Without a record, those movements look identical to loss. Scanning a product code at the point of transfer creates a simple movement entry: out of one location, into another. It takes seconds, and it means your cellar stock figure stays tied to a physical location rather than floating somewhere in the building.

For multi-site operators, transfer scanning between venues turns a vague conversation about "who borrowed what" into a clean audit trail. That alone tends to sharpen behaviour, because everyone knows the movement is recorded.

Choosing Kit That Survives a Working Cellar

Cellars are damp, cold and often have terrible Wi-Fi. A scanner that works beautifully in an office will fail in a cellar within a month, so choose deliberately.

• IP rating matters. Look for at least IP54, ideally higher, because condensation and the occasional hose-down are part of cellar life.
• Offline mode is essential. The device should store scans locally and sync when it finds a signal, so a blackspot never stops the delivery check.
• Gloves and cold hands. A trigger-style scanner is far easier to use in a cellar than tapping a phone screen with numb fingers.
• Battery life should comfortably cover a double delivery day without a mid-afternoon charge.
• Screen legibility in dim light, plus a loud confirmation beep, save a lot of squinting and shouting.

Do not overlook labelling. Barcodes on kegs fade, get scraped and end up under a pallet. Keep a small laminator and a roll of durable labels behind the bar, and replace damaged codes during quiet shifts rather than mid-delivery.

Turning Scans Into Numbers Worth Reading

Scanned data becomes genuinely powerful when it meets your dips and ullages. If you know exactly what was delivered, exactly what was transferred and exactly what was sold through the till, the remaining variance is a much tighter figure than anything you could calculate from memory.

That tighter variance is what makes line cleaning yields, cellar temperature problems and training gaps visible. A single fridge running warm shows up as a persistent shortfall on draught lager. A new starter over-pouring shows up as a yield dip on one shift pattern. Neither is obvious from a monthly stocktake sheet, but both stand out in a weekly variance report built on scanned movements.

Even a simple weekly routine — goods-in scanned, transfers recorded, dip reading taken — gives you a picture that is accurate enough to act on. Perfection is not the goal. Direction of travel is.

Rolling It Out Without a Mutiny

The fastest way to kill a scanning project is to change everything at once on a busy Friday. Start with deliveries only, and run it for a fortnight. Once the team sees a missing keg caught while the driver is still there, they will start scanning transfers without being asked.

Nominate one person per site as the scanning champion, keep the old paper process as a fallback for the first month, and resist the urge to send daily reports to the whole team. Share the weekly variance figure, praise the shifts where it is tight, and use the data to solve problems rather than assign blame. Do that, and accurate cellar records stop being an admin chore and start being one of the more useful tools behind the bar.