How to calculate cost of sales: take your opening stock, add everything you bought in the period, and take off your closing stock. Opening stock + purchases − closing stock = cost of sales. In a pub, do every figure at cost price and ex VAT if you're VAT registered, and the answer is what the drink and food you actually used cost you.
That one sum is the bottom half of your GP. Get it wrong and your GP is wrong, whatever the till says. Most of what ranks for this phrase is written for accountancy students. Here's how it works behind a bar, with the bits that trip pubs up: deliveries on the wrong side of the count, staff drinks, Christmas stock, and the till taking VAT that your invoices don't show.
A worked example: one four-week period
| Line | Figure | Where it comes from |
|---|---|---|
| Opening stock | £4,800 | Last period's closing stocktake, at cost |
| + Purchases | £7,350 | Every delivery invoice dated in the period, less credit notes |
| − Closing stock | £5,050 | Tonight's stocktake, at cost |
| = Cost of sales | £7,100 | What you used |
| Sales | £20,400 | Till takings ex VAT (£24,480 inc VAT ÷ 1.2) |
| Gross profit | £13,300 | Sales − cost of sales |
| GP% | 65.2% | £13,300 ÷ £20,400 |
Notice closing stock went up by £250. Look only at what you bought and you'd say cost of sales was £7,350 and GP 64.0%. You'd be blaming yourself for 1.2 points that are sitting in the cellar.
The five things that make the sum lie
1. Deliveries on the wrong side of the count
If a delivery comes in on count day, decide once whether it's in or out, and stick to it. A £600 delivery counted in the cellar but left out of purchases flatters this period's GP by nearly 3 points, then takes it back next period. This is called cut-off, and it's the single biggest reason a pub's GP swings from one month to the next for no reason anyone can find. I've gone through the others in why GP changes week to week.
2. VAT on one side and not the other
If you're VAT registered, everything goes in ex VAT: stock, invoices and sales. The trap is the till. Takings come in VAT-inclusive, and dividing by 1.2 is the step people miss when they work GP out on a napkin. If you're not VAT registered, VAT is a real cost to you, so use invoice prices including VAT. More on that in ex VAT vs inc VAT stock value.
3. Credits that never made it in
Ullage credits, short deliveries and returned empties all reduce purchases. If the credit note lands next month, so does the correction. Chase them and put them in the period they belong to. My guides on short deliveries and ullage claims cover what you're owed.
4. Drink that left the bar without going through the till
Staff drinks, your own drinks, comps, wastage and transfers to the kitchen are all in cost of sales, because they left the stock, but there's no sale against them. That's fine as long as you know the number. A good stocktake shows cost of sales and then the "allowances" separately, so you can see 65.2% actual against, say, 67.0% if every pint had been sold. The gap is your loss, and a gap you can name is a gap you can fix. See comps and freebies and bar to kitchen transfers.
The tax angle on your own drinks: HMRC's self-employment notes say if you take goods or stock out of the business you put the cost in box 60 on cash basis, or the normal sale price if you use traditional accounting. Ask your accountant which you're on before you guess.
5. Opening stock that isn't last period's closing stock
It has to be the same figure, to the penny. If someone revalued the stocktake at new prices, or a different stocktaker used different bottle weights, the two ends don't join and the period in between takes the hit. HMRC's accepted basis for valuing stock is the lower of cost and net realisable value. For pub drink that's what you paid.
Why a small counting error moves GP so much
On £20,400 of sales, every £100 of error in the closing stock moves GP by about half a point. Miss a keg of lager off the count, call it £165, and GP drops by 0.8 of a point. Count a case of wine twice and it goes up by the same. That's why a cost of sales figure is only as good as the count, and why one month's GP on its own proves very little. Two or three in a row do.
The idea nobody does: cost of sales by category
Do the same sum for each category: draught, packaged, spirits, wine, softs, food. Opening + purchases − closing for each one, then set it against the till sales for the same category. You need nothing new for this. The invoices already say what each line is, and a decent stocktake groups the count the same way.
What it tells you is where the money is, which the overall figure never does. A pub at 64% overall might be 70% on spirits and 52% on draught. That's not a pub with a problem, it's a pub with one problem, and now you know which cellar door to open. Then compare each category with GP benchmarks and check your GP per drink on the biggest sellers.
Cash basis and Christmas
GOV.UK now calls cash basis the standard way for sole traders and partnerships to record income and expenses (limited companies can't use it), and HMRC's notes say you only adjust for opening and closing stock if you use traditional accounting. That's a tax return figure. It isn't your GP.
This matters right now. Most of us buy heavy at the end of November and into December. On a purchases-only view, November looks awful and January looks brilliant, and neither is true. Do the full sum with a stocktake either side and you see what Christmas actually made. If you want one rule: count before the Christmas delivery and after New Year, so the big stock build doesn't bleed across two periods.
Doing it without the spreadsheet
You can do all of the above on paper or in my free stocktake template, and plenty of pubs do. StockTap's COGS report does the sum from your counts and the invoices you've scanned, and its GP analysis puts it next to the till, which saves the evening. Either way, the sum is the same.
Common questions
How do you calculate cost of sales?
Opening stock plus purchases minus closing stock. For a pub, value the stock at cost, use invoice prices less any credits, and keep everything ex VAT if you're VAT registered.
Is cost of sales the same as purchases?
No. Purchases are what you bought; cost of sales is what you used. They only match if your stock level didn't change. If closing stock is higher than opening, cost of sales is lower than purchases.
Do staff drinks count in cost of sales?
Yes. Anything that leaves the stock is in cost of sales, sold or not. Record staff drinks, comps and wastage so you can show the gap between actual GP and what GP would have been if everything had been sold.
Should cost of sales include VAT?
Not if you're VAT registered: stock, purchases and sales all go in ex VAT. If you're not registered, the VAT you pay on invoices is a cost to you, so include it.
What is a good cost of sales percentage for a pub?
Cost of sales as a percentage of net sales is 100 minus your GP%. A wet-led pub at 65% GP has cost of sales at 35% of sales. Food usually runs higher. Compare category by category rather than one overall figure.
Sources
- Cost of goods bought for resale, stock adjustments only under traditional accounting, goods taken for own use at cost on cash basis or normal sale price on traditional accounting (box 60): HMRC, Self-employment (full) notes, SA103F Notes 2026 (PDF), boxes 10, 17 and 60.
- Stock valued at the lower of cost and net realisable value: HMRC Business Income Manual, BIM33115.
- Cash basis as the standard way for sole traders and partnerships, not available to limited companies: GOV.UK, Cash basis.
- The four-week example, the £600 cut-off example, the £165 keg and the half-a-point-per-£100 rule are my own illustrative arithmetic, not figures from any real pub.