Bar inventory in the UK: how to run a stocktake that tells the truth

By Jack Hawkins · Updated 19 October 2026

Bar inventory is a repeatable count and reconciliation of what is available, received, used and left. A focused single-site count can be planned around a manageable working session, but actual time depends on layout, SKU count, measurement and staff experience. Measure elapsed time and staff-hours separately so a fast two-person count is not mistaken for half the labour cost.

Why do it at all, given the trade's running joke about counting bottles on a Sunday morning? Because stock is the biggest controllable number in a wet-led venue after labour, and because the count is the only witness that survives cross-examination. Your POS says what was rung. Your invoices say what you bought. Only the count says what's left. Subtract one from the other two and you get variance, which is where the argument always ends up.

What to count, and how often

Choose the count rhythm around value, turnover and perishability. A practical starting schedule to adapt is:

• Weekly: spirits by the bottle, wine by the bottle (at least the value end), kegs by the full/empty/connected state, and whatever premium product you actually sell three sheets to the wind on. Same weekday, same hour, before deliveries. Monday 10:00 beats "sometime Sunday".
• Fortnightly or monthly: mixers, syrups, beer cans and bottles, produce if you're juice-heavy. Lower value per line, slower drift.
• Per delivery, always: the delivery book, every case, signed against invoice. A signed delivery still needs a physical quantity check; distinguish what was ordered, invoiced and actually received.

For planning, try a focused list of high-value and fast-moving products, time a trial count and retain a periodic complete count. Ninety minutes with two people is three staff-hours; it is not a universal guarantee for an 80–120-SKU venue. Improve shelf order, measurement and receipt completeness before deciding whether the software or the counting scope needs to change.

The method that keeps the number honest

1. One direction, one system. Count shelf top-to-bottom, left-to-right, and never recount a bottle you've already logged unless you strike it out and start the line again. Double-counting is the number-one sheet-killer.
2. Count units the product deserves. Full bottles: whole numbers plus marks for partials. Partials: scale or pour-spout marks, not "halfish". A 70cl bottle with two fingers left is not 0.25 of anything anyone can verify later. Choose scales with suitable capacity and resolution, then validate the bottle tare and liquid conversion method before relying on the result.
3. Kegs are a separate species. Full, in-use (using a manufacturer-approved method such as calibrated weighing or dispense reconciliation; do not open or dip a pressurised keg), emptied. Record the count cutoff and disposal consistently; a state label alone cannot establish the quantity difference.
4. Price at invoice cost, ex-VAT, the same way every week. When trade prices move, use the weighted cost you actually paid across the period, and document the valuation policy; do not interchange last-in pricing with weighted-average cost for financial stock valuation. Changing the pricing rule between weeks invents variance out of paperwork.
5. Two people, one reads, one writes, swap roles. It provides a second check on transcription and it makes the whole thing feel like operations instead of suspicion, which matters more than anyone admits.

The sheet (or the app, or the spreadsheet)

Whatever tool, a working stock sheet needs exactly these columns: product, unit, size, count, cost per unit, total cost, last week's count, purchased this period, and the derived "used this period". That last column is the whole point; everything else is bookkeeping in service of it.

A controlled spreadsheet or browser workspace can be appropriate for a single site, and free: our inventory workspace is an editable browser workspace with quantity, costing and reconciliation controls. Dedicated stock apps may earn their subscription when multi-site coordination or a verified POS integration removes repeated work to compute theoretical usage automatically; compare the manual work left behind before deciding whether a subscription pays.

The reconciliation itself is one line per product: opening + purchases − closing = actual usage. Compare to theoretical usage from the POS and specs. The gap is variance, priced at what you paid. Ten minutes with a pivot table, once the counts are trustworthy.

The habits that make the number move

Count consistency beats count frequency. Same day, same hour, same route, same two people where possible. A sloppy monthly count produces a number nobody acts on; a tight weekly count of the top 20 products by value produces the £200-a-week conversation that actually changes behaviour.

Prioritise valuable or fast-moving lines, but set a separate check for perishables such as opened vermouth, juice and dairy. Slower stock still needs regular rotation, expiry checks and periodic complete counts. An annual-only blind spot can hide spoilage, availability problems and cash tied up on the shelf.

Log waste the moment it happens, clipboard on the ice well, everyone includes the dropped tray and the killed bottle. A waste log with three lines a week turns a five-point mystery into a two-point known cost.

And when the number looks bad, resist the first instinct. Walk the list of boring causes first, measures, unring sales, waste, spec drift, missing invoices. The count is a thermometer, not an accusation. It's wrong roughly as often as any other measurement, which is why method, not vibes, is the subject of this entire guide.

Make a partial-bottle measurement repeatable

For weighing, record the empty bottle tare and use a product-specific density or a calibrated full-to-empty weight range. Bottle glass weights can differ even within a brand; water density is not an exact conversion for every spirit, liqueur or syrup. Store the method with the SKU so the next counter repeats it. Keep original measurements and any correction note. A quarter of a 70cl bottle is 175ml, equivalent to seven 25ml measures, so quarter-bottle rounding alone cannot demonstrate a small variance target on a fast-moving line. Choose count resolution according to the decision you need the stocktake to support.

FAQ

How do I do bar inventory as a UK bar? Count everything on a fixed weekly schedule, partial bottles by scale or marks, kegs by an appropriate measured remaining quantity, with state recorded as context, priced at invoice cost ex-VAT. Opening + purchases − closing gives actual usage; compare against POS-based theoretical usage per product; price the gap.

How often should a bar count stock? Weekly for spirits, premium lines and kegs; monthly for low-value categories; deliveries reconciled every single time. Consistent weekly counts outperform enthusiastic irregular ones every time.

What's a good bar inventory spreadsheet? Product, size, count, unit cost, total, last week, purchases, used-this-period. That's the whole instrument. Anything more is integration; anything less can't reconcile. Ours is free and linked above.

Does inventory software beat spreadsheets? Software can help when it demonstrates a better counting, purchasing or integration workflow. There is no universal SKU threshold; compare the actual process, effort and control before purchasing. The discipline is the product; the software is packaging.

Method and assumptions

Practice guidance reflects standard UK licensed-trade stock control conventions rather than a regulated standard; SKU-count and time thresholds are working defaults to test against your own venue. Variance method follows our methodology page. Planning thresholds should be tested against the venue rather than treated as measured national results.

Last reviewed 19 October 2026.