Stock Control Spreadsheet: UK Template and Formulas
By mise · Updated September 29, 2026
Quick answer: a stock control spreadsheet lists each line with unit, cost (ex VAT), par, stock count, value (=count×cost) and reorder quantity. Pubs add sales and GP% per line to spot wet-stock losses.
Every stock controller starts with a spreadsheet. It works until the count takes a whole morning.
| Column | Formula / note |
|---|---|
| Line, supplier, unit | Text |
| Cost ex VAT | Latest invoice |
| Par | Target stock |
| Stock count | At the stock take |
| Stock value | =Count × Cost |
| Reorder | =MAX(0, Par − Count) |
| GP% | =(Net price − Cost) ÷ Net price |
Try mise in your business
Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. 7-day free trial, then US$33 a month (£26 in the UK).
Start free
Keep reading
Restaurant stock take template: free sheet and how to use it
Restaurant stock control: a practical guide
Restaurant gross profit and GP %: formula and calculator
Pub Stock Take: Template, Method and How to Stop Losses
All guides
Frequently asked questions
Should costs include VAT?
No: use cost ex VAT for stock value and GP.
How often should I stock take?
Weekly for wet stock, monthly for food.
Can I export from mise to my spreadsheet?
Yes, to Excel.
How much does mise cost?
A 7-day free trial, then US$33 a month per location (£26 in the UK).