Start free

Bar Stock Take: Template and Routine for UK Bars

What sets mise apart

By mise · Updated 6 October 2026

Quick answer: a bar stock take counts spirits and wine by the bottle and tenths of open bottles, kegs by weight, and bottled and canned stock by the case. Compare usage with till sales to get your stock result; most bars aim for within ±1–2%.

Behind a bar, a heavy pour, a free drink and a broken bottle all look the same in the till: missing. The stock take is how you see them.

AreaHow to countHow often
SpiritsFull bottles + tenths of openWeekly
WineBottles + open by the glassWeekly
DraughtKegs by weightWeekly
Bottles & cansCases + singlesWeekly
MixersCases + singlesWeekly

How to do a bar stock take

  1. Pick a fixed time — after close or before the first delivery, same day every week.
  2. Collect the paperwork — every delivery note, invoice and credit since the last stock take, plus ullage and wastage records.
  3. Count area by area in shelf order: back bar, fridges, cellar, stores. Full bottles as numbers, open spirits and wine in tenths, kegs by weight (see keg inventory).
  4. Value at cost ex VAT from the latest invoices.
  5. Work out usage: opening stock + deliveries − closing stock, line by line.
  6. Compare with the till: usage at selling price against takings gives the stock result, surplus or deficit. Chase the biggest lines first.

Bar stock take template

One row per line, with the usage worked out for you. Opens in Excel and Google Sheets.

Download the free bar stock take template (CSV — Excel and Google Sheets)

Bar stock take app

A stock take app turns the count into scanning: each bottle comes back named and sized, you tap the tenths, and usage and GP are ready when you close. In the US the same job is called bar inventory.

How mise helps

Scan the barcode with your phone camera or snap a photo of the label; mise's AI finds the product and categorises it with name, brand, category, photo and price. Scan each bottle; open bottles are counted in tenths and kegs by weight. Every count is saved with a date and a name, par levels warn you before you run out, and you see losses and GP for the period without building a spreadsheet.

Try mise at your pub or restaurant

Scan the barcode or snap a photo: mise's AI finds the product and categorises it. Free trial.

Start free
Download on the App StoreGet it on Google Play
Try mise at your pub or restaurant

Scan the barcode or snap a photo: mise's AI finds the product and categorises it. Free trial.

Start free
Download on the App StoreGet it on Google Play
Keep reading GP calculator UK for drinks and food Wet stock management for pubs and bars Keg inventory: how to count and weigh kegs Pub Stock Take: Template, Method and How to Stop Losses All guides

Frequently asked questions

How do I count an open bottle?

In tenths: 0.3 if a third is left.

How often should a bar do a stock take?

Weekly for wet stock.

What is a good stock result?

Within ±1–2% of sales.

Is there a bar stock take app?

Yes. mise lets you scan each bottle with your phone, count open bottles in tenths or with a Bluetooth scale, and get usage, variance and GP when you close the count. Free trial.

Do I need a stocktaker for a bar stock take?

No. Many bars count weekly themselves and keep an independent stocktaker for an occasional audit.

Can I try mise for free?

Yes. You get a free trial, with no card needed.