Bar Stock Take: Template and Routine for UK Bars
What sets mise apart
- Scan once, the product is classified. Read any barcode with the camera or a Bluetooth scanner, or snap a photo of the label: mise brings back the name, brand, group, size and photo, already sorted. No item setup.
- A product base that is already built. Your items are usually in it before you start. You can also upload your own list and mise fills in the rest.
- Alerts before you run out. Set a minimum for each product. Anything below it turns red and goes into a shopping list with how much is missing.
- Control stock from your phone. Count by location, with your team, and compare one count against another to see where the loss is.
- Bluetooth scale. Connect a scale to weigh open bottles, meat and bulk items; the weight goes into the product by itself.
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.
| Area | How to count | How often |
|---|---|---|
| Spirits | Full bottles + tenths of open | Weekly |
| Wine | Bottles + open by the glass | Weekly |
| Draught | Kegs by weight | Weekly |
| Bottles & cans | Cases + singles | Weekly |
| Mixers | Cases + singles | Weekly |
How to do a bar stock take
- Pick a fixed time — after close or before the first delivery, same day every week.
- Collect the paperwork — every delivery note, invoice and credit since the last stock take, plus ullage and wastage records.
- 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).
- Value at cost ex VAT from the latest invoices.
- Work out usage: opening stock + deliveries − closing stock, line by line.
- 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.
Scan the barcode or snap a photo: mise's AI finds the product and categorises it. Free trial.
Start freeScan the barcode or snap a photo: mise's AI finds the product and categorises it. Free trial.
Start freeFrequently 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.
