Stock take template: free printable sheet and Excel download
By mise · Updated 7 October 2026
Download the Excel template (.xlsx) CSV Print the blank sheet
Free, no sign-up. Google Sheets: File → Import → Upload the .xlsx.
Quick answer: a stock take template needs opening stock, deliveries, closing stock and usage (opening + deliveries − closing) for every line, valued at cost. Take stock at the same time each week or month, before deliveries, and compare usage with what the till says you sold to find your real gross profit.
In the UK the weekly or monthly stock take is what turns the till report into a real gross profit figure. This template has the columns a pub, restaurant or café needs, with the usage formulas already in.
What is in the template
One row per line, grouped by area: cellar, back bar, kitchen, fridges, dry store. Usage, usage value and closing stock value are formulas — fill in opening stock, deliveries, closing stock and cost price ex VAT. The Excel file has totals at the bottom, prints landscape on one page width, and a second tab explains how to use it. The CSV opens anywhere. Prefer paper? Print the blank sheet further down this page.
How the template works
| Column | Meaning |
|---|---|
| Opening stock | The closing figure from the previous stock take. |
| Deliveries | Everything received in the period, from the delivery notes and invoices. |
| Closing stock | What you physically count today, including part bottles and open kegs. |
| Usage | Opening + deliveries − closing: what left the shelf. |
| Usage value | Usage × cost price. Add it up to get your cost of sales. |
Running the stock take
- Pick a fixed time — Sunday after close or Monday before deliveries — and keep it.
- Get deliveries in the system first. A delivery note left in a drawer shows up as a "loss".
- Count by area, in shelf order. Two people: one counts, one writes (or scans).
- Measure part bottles. Tenths by eye, or better, weigh them. Kegs can be weighed too.
- Compare usage with sales. If the till says 80 pints of lager and the keg usage says 96, you have 16 pints of wastage, spillage or free pours to explain.
From stock take to GP
Cost of sales for the period is opening stock + purchases − closing stock. Gross profit (GP) percentage is (net sales ex VAT − cost of sales) ÷ net sales ex VAT. Set a target per category (draught, spirits, wine, food), and compare each stock take with the last one. Work out the GP each serve should make with the GP calculator, and line-by-line drink losses with a wet stock reconciliation.
Printable stock take sheet
Print it (or save as PDF) and take it round the cellar, bar, kitchen and stores. Usage = opening + deliveries − closing.
| Area | Item | Unit | Opening | Deliveries | Closing | Usage | Cost ex VAT | Value |
|---|---|---|---|---|---|---|---|---|
Faster than a clipboard
An external stocktaker usually charges per visit. Doing it yourself with a phone is quicker than the clipboard: with mise you scan each bottle or pack, the mise AI finds the product and brings it back already named and categorised, and you only enter the quantity. Deliveries go in from a photo of the invoice, and usage and GP are worked out for you.
Point the camera and the product comes up complete: name, brand, category, size and photo — the mise AI finds it from the barcode or a photo. Free trial, no card.
Start freeFrequently asked questions
How often should a pub do a stock take?
Wet stock is usually checked weekly or every two weeks, with a full stock take monthly. Kitchens with high-value lines like meat and fish benefit from a weekly count.
Is there a free printable stock take sheet?
Yes. This page has a blank sheet you can print or save as PDF, an Excel template with the formulas in, and a CSV. No sign-up.
How do I work out GP from a stock take?
Cost of sales = opening stock + purchases − closing stock. GP% = (net sales ex VAT − cost of sales) ÷ net sales ex VAT × 100.
What is the difference between a stock take and stock control?
The stock take is the count itself. Stock control is the whole system around it: ordering to par, recording deliveries and waste, and comparing usage with sales.
Can I do a stock take on my phone?
Yes. With a scanning app you count by reading barcodes and typing quantities, and the report comes out in Excel without retyping.
