Start free

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

ColumnMeaning
Opening stockThe closing figure from the previous stock take.
DeliveriesEverything received in the period, from the delivery notes and invoices.
Closing stockWhat you physically count today, including part bottles and open kegs.
UsageOpening + deliveries − closing: what left the shelf.
Usage valueUsage × cost price. Add it up to get your cost of sales.

Running the stock take

  1. Pick a fixed time — Sunday after close or Monday before deliveries — and keep it.
  2. Get deliveries in the system first. A delivery note left in a drawer shows up as a "loss".
  3. Count by area, in shelf order. Two people: one counts, one writes (or scans).
  4. Measure part bottles. Tenths by eye, or better, weigh them. Kegs can be weighed too.
  5. 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.

AreaItemUnitOpeningDeliveriesClosingUsageCost ex VATValue
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         

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.

Count your stock by scanning barcodes

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 free
Download on the App StoreGet it on Google Play
Keep reading GP calculator UK for drinks and food Wet stock reconciliation: how to do it in a pub Stock take app: do the stocktake yourself by scanning How to do a stock take, step by step All guides

Frequently 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.