Written by: JJ Tan, Founder, Jelly
Key Takeaways
- A clear stocktake checklist protects gross profit by catching waste, theft, portion drift and delivery errors before they cut revenue.
- UK hospitality wastes 18–20% of purchased food, and sites without variance control often see food cost variance of 3–5 percentage points.
- The four-stage framework of Prepare, Count, Investigate and Act gives you a repeatable, FSA-aligned routine that cuts admin and improves margin visibility.
- Weekly counts of high-cost items plus a monthly wall-to-wall stocktake give you both day-to-day control and accurate financial reporting.
- Switching from spreadsheets to Jelly automates invoice scanning, live dish costing and price alerts. Book a Jelly demo to cut stocktake time from hours to minutes and lift GP by 2–3 points.
How Stocktakes Protect Restaurant Gross Profit
A stocktake is a physical count of all food, beverage and consumable stock on site at a fixed point in time, compared with what the system expects. The gap between the two is called variance. Variance is expressed as a percentage of theoretical usage and signals waste, theft, portion drift or receiving errors.
Three supporting terms matter throughout this guide:
- Par level: the minimum quantity of an ingredient that must be on hand before an order is placed, calculated as (average daily usage × supplier lead time in days) + safety stock.
- FIFO: First In, First Out, where new deliveries go behind existing stock so older product is used first. For perishables, FEFO (First Expired, First Out) applies and can support compliance with food safety and traceability obligations.
- Theoretical usage: what the system expects was consumed, calculated from POS sales data multiplied by recipe specifications.
Well-run multi-site restaurant groups often keep food cost variance under 3% of theoretical.
Four-Stage Stocktake Framework for UK Restaurants
- Prepare. Close or pause stock movement so no items enter or leave during the count, because movement mid-count corrupts the data. Print or open your count sheet organised by storage zone, then assign one counter per zone to ensure full coverage without duplication. Confirm the count time matches previous weeks, as inconsistent timing produces data that cannot be trusted for accurate variance analysis.
- Count. Work shelf to sheet, not sheet to shelf, so the count follows the physical layout. Record item, unit of measure and physical quantity for each line. Note use-by dates on all A and B items to support rotation. Do not adjust figures during the count, and record only what is physically present.
- Investigate. Compare physical counts against theoretical stock for each item. Flag any line where variance exceeds your agreed threshold. Follow the investigation sequence in the variance section below before drawing conclusions or changing system data.
- Act. Adjust orders to correct par levels and prevent overstocking or stockouts. Raise supplier credit claims for short deliveries, update recipes where portion drift is confirmed, and document corrective actions with a named owner and follow-up date.
Weekly Stocktake Checklist for High-Cost Items
A weekly stocktake in a UK restaurant can take under an hour when the operation is organised and the scope is focused. Concentrate on the highest-cost items, such as proteins, premium produce, premium spirits and specialty ingredients, because they drive most of your food cost. Use the table below as your printable shelf-to-sheet count sheet.
| Category / Item | Unit | Physical Count | Theoretical Stock | Variance | Investigation Notes |
|---|---|---|---|---|---|
| Dry Store | |||||
| Pasta (dried) | kg | ||||
| Rice | kg | ||||
| Tinned tomatoes | 400g tin | ||||
| Fridge | |||||
| Chicken breast | kg | ||||
| Salmon fillet | kg | ||||
| Cheddar | kg | ||||
| Double cream | litre | ||||
| Freezer | |||||
| Beef mince | kg | ||||
| Chips (frozen) | kg | ||||
| Bar | |||||
| House red wine | 750ml bottle | ||||
| Draught lager (keg) | 9-gal keg | ||||
| House spirits (open) | 70cl bottle | ||||
| Chemicals & Cleaning | |||||
| Sanitiser spray | litre | ||||
| Washing-up liquid | litre | ||||
Weekly stocktakes can support HACCP compliance by highlighting items approaching use-by dates so you maintain food safety standards. Non-food items such as cleaning chemicals must be stored separately from food.
Monthly Stocktake Routine for Full Inventory
A full wall-to-wall monthly stocktake takes several hours, depending on the size of the operation. The monthly count covers every SKU, not just the top 20, and produces the food cost percentage used in management accounts.
The stock control formula for UK restaurants is:
Opening Stock + Deliveries − Closing Stock = Usage Cost
Usage Cost ÷ Revenue × 100 = Actual Food Cost %
UK restaurants should track their food cost percentage closely and review trends over time.
The monthly count sheet should include a manager sign-off section confirming:
- Count date, time and location
- Names of all counters
- Total opening stock value (£)
- Total purchases in period (£)
- Total closing stock value (£)
- Calculated usage cost (£) and food cost %
- Variance vs. theoretical (%)
- Manager signature and date
- Any items flagged for investigation
Businesses must keep traceability records for suppliers and deliveries, and these records must be available for inspections.
Delivery Checks That Feed Reliable Stocktakes
Every delivery functions as a stocktake event. Accepting stock without checking it introduces errors that corrupt your variance data and create food safety risk. On delivery, food businesses must check that chilled and frozen food is at the correct temperature, packaging is undamaged and the items match what was ordered. If food has not been handled safely or is poor quality it must not be used and the supplier must be contacted immediately.
For each delivery, check and record the following:
- Temperature: chilled foods should arrive at or below recommended temperatures. Use a calibrated probe thermometer and log the reading.
- Packaging: reject any delivery showing tears, dents, broken seals, wet spots or lost vacuum.
- Use-by and best-before dates: reject items expiring too soon to be used safely within the restaurant’s menu rotation.
- Quantity vs. delivery note: count every item against the purchase order before signing.
- Batch and lot numbers: record for traceability.
- Acceptance or rejection decision: goods-in records should document the key details for accepted and rejected items.
Rejected items must be isolated immediately and the supplier notified in writing. Do not count rejected stock into usable inventory.
Once deliveries are checked and stock is counted, the next step is to measure the gap between what you physically hold and what the system expects. That gap is variance, and calculating it accurately turns raw count data into margin insight you can act on.
How to Calculate and Act on Stock Variance
Variance is calculated at the item level and then aggregated by category. The formulas are:
| Step | Formula | Example (chicken breast) | Result |
|---|---|---|---|
| Actual usage | Opening stock + Purchases − Closing stock | 20 kg + 50 kg − 24 kg | 46 kg |
| Theoretical usage | Recipe qty × Portions sold (from POS) | 0.2 kg × 200 covers | 40 kg |
| Variance (units) | Actual usage − Theoretical usage | 46 kg − 40 kg | 6 kg over |
| Variance (%) | (Variance ÷ Theoretical usage) × 100 | (6 ÷ 40) × 100 | 15% |
A large variance on a high-value item can signal a process problem and should be investigated.
When a variance is confirmed, follow this investigation sequence in order:
- Recount. Ask a different person to blind-recount the item before changing any system data.
- Check receiving records. Verify the goods-received note against the purchase order. A supplier recording 10 kg when they actually delivered 8.5 kg explains the entire discrepancy without any further investigation.
- Review waste logs. Confirm all spoilage, staff meals and prep waste were recorded at the time.
- Check recipe adherence. Weigh portions against spec, as portion inconsistency can be a major contributor to food cost variance.
- Consider theft. Take this step only after the above checks are clean and variance persists across multiple periods.
Using Counts for Supplier Credits and Price Alerts
Stocktake data has commercial value beyond food cost reporting. When a delivery variance is confirmed, whether quantity short or temperature breach, the goods-received note becomes the evidence for a supplier credit claim. Raise the claim within 24 hours of delivery with the batch number, temperature log and signed delivery note attached.
Price monitoring runs in parallel with these checks. When ingredient costs change between invoices, the impact on dish GP is immediate and measurable. The operational workflow is:
- Scan or photograph every invoice on receipt.
- Compare line-item prices against the previous invoice for the same SKU.
- Flag any increase above your threshold, for example more than 3% on a protein.
- Contact the supplier with the specific invoice evidence and request a credit or revised pricing.
- Update recipe costs and review menu pricing if the increase is sustained.
Jelly’s Price Alert feature automates steps 2 and 3, flagging every price movement the moment an invoice is scanned so chefs negotiate from evidence rather than instinct.
See Jelly’s Price Alert and live dish costing in action on a short demo.
Manual vs Automated Stocktakes: Time and Margin Impact
Manual stocktakes using spreadsheets are the default for many independent UK operators, but the time cost is significant and margin insight arrives late. The table below quantifies the operational cost of manual processes and shows how automation compresses admin time from hours to minutes while delivering real-time margin visibility.
| Metric | Manual (spreadsheet) | Automated (Jelly) |
|---|---|---|
| Weekly admin time | 10–20 hours | Under 1 hour |
| Monthly stocktake duration | A full manual stock take in a medium-sized restaurant, bar, or hotel involves a team of two to four people working for two to four hours | 5–20 minutes (Sushi Revolution) |
| Dish cost update frequency | Monthly (manual re-entry) | Real-time on invoice scan |
| GP margin visibility | Delayed (month-end report) | Daily Flash Report |
| Average GP improvement | Baseline | Improvement |
| Food cost reduction | Baseline | Reduction |
Sushi Revolution’s head chef Tom reduced the monthly stocktake from 2–3 hours to 5–20 minutes after implementing Jelly, delivering the GP improvement outlined earlier. Amber restaurant saves £3,000–£4,000 per month through faster credit claims, better buying decisions and tighter menu controls enabled by automated invoice scanning and real-time costing.
The process itself stays familiar. Counts still happen, deliveries are still checked and variances are still investigated. The difference is that data flows automatically from invoice to dish cost to GP report, which removes the spreadsheet layer entirely.
Frequently Asked Questions
How long should a weekly stocktake take?
A focused weekly stocktake covering the 20 highest-cost SKUs takes 45–90 minutes for a well-organised operation with two people counting. Larger sites with more storage zones or higher SKU counts may take up to two hours. The key variables are whether the count sheet matches the physical shelf layout, whether counters are assigned to specific zones and whether the count happens at a consistent time when stock is not moving, typically after last service or before morning deliveries. Operations using purpose-built inventory tools rather than spreadsheets consistently complete counts in half the time.
What is an acceptable inventory variance for a UK restaurant?
Acceptable variance depends on the item category. For overall food, 1–3% is the target, and anything consistently above 3% warrants investigation. High-cost proteins should sit under 2%. Bar and spirits variance of 3–5% is typical, while draught beer line loss of 3–5% is considered well-managed. A healthy kitchen should maintain total inventory variance under 2% of theoretical usage. Variance above 5% on any single high-value item in a single week clearly signals a specific process problem, such as portion drift, a receiving error or unlogged waste, and should be investigated before the next count cycle.
How does a stocktake support FSA compliance?
UK food businesses are legally required to implement food safety management procedures based on HACCP principles, maintain traceability records for all suppliers and deliveries and keep those records available for inspection at any time. A weekly stocktake directly supports these obligations by creating a documented record of stock on hand, use-by dates checked, delivery temperatures logged and any corrective actions taken. The FSA’s Safer Food Better Business framework expects businesses to show they are actively monitoring and controlling food safety hazards, and a consistent stocktake routine with signed records provides that evidence. Environmental Health Officers check stock rotation, labelling and temperature records during unannounced inspections, so the stocktake record also serves as your audit trail.
Should food and beverage stocktakes be done separately?
Food and beverage counts should always be performed separately. Alcohol carries higher margins, requires stricter daily tracking and is subject to different regulatory scrutiny under licensing and VAT rules. UK pub operators must keep stock records to meet VAT and licensing requirements. High-volume operations often perform daily cellar counts for draught lines and open spirits, while food dry goods follow a weekly schedule. Combining the two into a single undifferentiated count makes it harder to identify category-specific variance and slows down the investigation process.
What is the difference between a weekly and monthly stocktake?
A weekly stocktake is a focused cycle count of the highest-cost and highest-risk items, typically 20–40 SKUs, designed to catch variance within 7–10 days before losses compound. It takes 45–90 minutes and produces an actionable food cost figure for the current week. A monthly stocktake is a full wall-to-wall count of every SKU across all storage zones, taking 3–5 hours, and produces the closing stock valuation used in management accounts. Monthly counts also identify dead stock, slow-moving items and any SKU drift where products have been renamed or substituted by suppliers. Both routines are necessary, as the weekly count provides operational control and the monthly count provides financial accuracy.
Download Your Free Restaurant Stocktake Checklist Template
The checklist tables and variance formulas in this guide are available as a free Google Sheets template, pre-formatted with the shelf-to-sheet categories, variance calculation columns and manager sign-off section described above. It is ready to use immediately and can be printed or completed on a tablet during the count.
For operators ready to move beyond the spreadsheet, Jelly automates the entire flow. Invoices are scanned on receipt, ingredient costs update in real time, dish GP margins refresh automatically and price alerts flag supplier increases the same day they happen. Onboarding takes under a week and the first price alerts are live within 24 hours of connecting your first supplier invoice.