What is a stocktake? It's a count of every bottle, keg, can and case you hold on a given day, valued at what you paid for it. In a pub the count is then set against your opening stock, your deliveries and your till sales, and that one sum tells you what your drink really cost, your real GP, and whether anything went missing in between.

That's it. The count is the bit everyone pictures, someone in the cellar with a clipboard, but the count on its own is just a list. The stocktake is what you do with the list.

Most explanations online are written for warehouses and online shops, which is why they talk about SKUs and fulfilment. A pub is different. Half your stock is liquid in part-used bottles and kegs you can't see into, your sales go through a till in measures, and some of it is legitimately lost to line cleaning and head on a pint. So here's what a stocktake means behind a bar.

The one sum a stocktake boils down to

Every stocktake report, however many pages it runs to, is this:

Opening stock + deliveries − closing stock = what the stock you used cost you.

Your opening stock is last time's closing count. Your deliveries come off the invoices. Your closing stock is today's count. Whatever's not there any more was either sold, poured away, given away, or went somewhere it shouldn't have.

Then two comparisons:

  • Against your sales, that cost gives you your real gross profit. Not the GP your price list promises. The one you achieved.
  • Against what the till took, it gives you the variance. Every line you used should have been sold at your selling price. Add that up, compare it with the till, and the gap is the surplus or deficit at the bottom of the report.

A worked example, one month in a small wet-led pub

An illustrative month, all figures ex VAT (my example, not a real pub's accounts)
LineAmount
Opening stock at cost (last month's closing count)£6,000
Plus deliveries at cost (from the invoices)£3,200
Minus closing stock at cost (today's count)£5,800
Cost of the stock used£3,400
Till sales for the month£10,400
Achieved GP: (£10,400 − £3,400) ÷ £10,40067.3%
What the stock used should have taken at your selling prices£10,452
Variance: £10,400 − £10,452−£52, about −0.5%

That −£52 is the number people get nervous about. On that month it's inside what most pub companies treat as normal, which is roughly plus or minus half a per cent of sales. It's still worth looking at which lines it came from, because a flat total can hide a spirits problem behind a draught surplus. My guide to what counts as an acceptable variance goes through why, with five real audit results.

Notice the stocktake needs three things before anyone counts a bottle: last time's closing figure, every invoice for the period, and the till sales by product. If any of those is missing, the count can be perfect and the result still be wrong. A lot of "bad stocktakes" turn out to be a missing invoice or a delivery that landed after the count, not a missing bottle. Delivery timing catches a lot of people.

What a pub stocktake actually counts

The main types of stock behind a bar, and how each is usually counted
StockHow it's countedWhere it goes wrong
Packaged: bottles, cans, sealed spirits, wineCounted as units or casesStock in three places, cases counted twice
Open spirits and wineWeighed on a scale, or estimated in tenths by eyeTenths by eye are nearly always generous
Draught kegsWeighed, or worked out from a calibrated meter or dipWrong keg size set up, so every reading is off
Cask aleDipped with a calibrated dipstickWrong cask size or a stick for a different cask
Food (dry stock)A separate count, often by weightPrep and waste nobody wrote down

Wet and dry stock are usually separate stocktakes, priced separately by stocktakers. Wet stock vs dry stock explains the split, and the kitchen side is in how to do a food stocktake. If part bottles are what slows you down, how to weigh spirits for a stocktake has the grams for the common bottles.

Five things people mean by "a stocktake"

Same word, five different jobs
Kind of countWho does itWhat it's forHow often
Full stocktakeYou, or an independent stocktakerGP and variance for the periodMonthly to quarterly
Spot checkYou or a managerCatching a problem on your top lines earlyWeekly, 15 to 20 minutes
Stock auditA stocktaker working for the pub company or breweryChecking a tenant's stock against deliveries, sometimes leading to a chargebackSet by the agreement
Stock valuationA stocktaker, usually for both sidesPutting a price on the stock when a pub changes handsOn the day of handover
Year-end stock countYou or your accountantThe closing stock figure for your accountsOnce a year, at your year end

The audit is the one that bites, because someone else holds the numbers. Stock audit vs stocktake and what to expect from a pubco stock audit cover it. The valuation is in taking over a pub, and the year-end count in stock valuation for year-end accounts.

What a stocktake costs

An independent stocktaker charges by the visit. Published rates run from about £125 a visit on a monthly contract at InnStock to £190 for a half day and £320 plus VAT for a full day at Roslyns. Food is usually extra. Over a year of monthly wet stocktakes that's roughly £1,500 to £3,840, and my stocktaker cost guide has the full rate cards.

Doing it yourself costs time instead. A full count on a typical pub takes 75 to 90 minutes once your products and prices are set up, and the first ever count takes far longer because you're building the list. How long does a stocktake take breaks those minutes down line by line.

The test I'd use: can you say what you're short of?

Here's the thing a stocktake should give you that a till report never will. At the end of it you should be able to name the line. Not "we're 1% down", but "we're short about six singles of the house vodka and a couple of pints of the guest ale". If your stocktake can't get you to that, it isn't finished. A percentage is something to worry about. A line is something you can do something about: a till button, a line clean that wasn't logged, a measure, a delivery that never came.

That's also why counting more often beats counting harder. A shortage you find in week two is a habit you can fix. The same shortage found three months later is just a bill. How often should you do a stocktake has the rhythm I'd use.

If you want to try one yourself this week, my free stock take template has the sum built in, and how to do a stocktake walks through the count from cellar to fridges.

Common questions

What is a stocktake?

A stocktake is a count of all the stock a business holds on a given day, valued at cost. In a pub it's then set against the opening stock, the deliveries and the till sales for the period, which shows what the stock used cost you, your real gross profit and any variance between what should be there and what is.

What is the stocktake formula?

Opening stock plus deliveries minus closing stock equals the cost of the stock you used. Compare that with your sales and you get your gross profit. Compare what you should have taken for the stock used with what the till actually took and you get the variance, the surplus or deficit on the stocktake report.

What is the difference between a stocktake and a stock audit?

In a pub the two words often mean the same visit. Where they differ, a stocktake is your own count for your own figures, and an audit is a count done for someone else, usually a pub company or brewery checking a tenant's stock against what it delivered. My stock audit vs stocktake guide covers the difference in detail.

How often should a pub do a stocktake?

Most pubs do a full stocktake monthly or every four to six weeks, with a short spot check on the top-selling lines in between. Quarterly is the minimum many stocktakers recommend, but by then a problem has had three months to grow.

How much does a stocktake cost?

Published rates from independent stocktakers run from about £125 a visit on a monthly contract to £320 plus VAT for a full day. Doing it yourself costs your time, usually 75 to 90 minutes for a full count once your product list is set up.

Sources

  • Published stocktaker rates (InnStock from £125 a visit monthly, Roslyns £190 half day and £320 plus VAT full day) and the £1,500 to £3,840 annual range: my pub stocktaker cost guide, which links each firm's published prices.
  • Variance within roughly ±0.5% of sales treated as normal by most pub companies, and the BBPA 95% liquid head-of-beer guidance: my acceptable variance guide, citing BBPA guidance on head of beer via Cask Marque.
  • Full count timings of 75 to 90 minutes and weekly spot checks of 15 to 20 minutes: my stocktake timings guide.
  • The worked month is an illustration with round numbers, not a real pub's figures. The formula is the standard opening-plus-purchases-minus-closing cost of sales calculation; the "name the line" test is my own method.