PREVRA Restaurant Inventory Template: Control Stock, Reduce Waste, Maintain Traceability
A practical restaurant inventory template for UK kitchens. Covers FIFO rotation, date code checks, stock-level monitoring, and the traceability records your EHO requires.
Why inventory control matters for food safety and profitability
Inventory management sits at the intersection of food safety and financial control. Poor stock rotation leads to out-of-date food reaching customers — a food safety offence under the Food Safety Act 1990. It also leads to unnecessary waste, which in the average UK restaurant accounts for 5-10% of food purchasing costs.
The counter-intuitive truth about FIFO (first-in-first-out): it is not just about expiry dates. Two deliveries of the same product received on different days can have identical date codes but very different remaining shelf lives. This is because the supply chain temperature history — how long each batch sat in an unrefrigerated warehouse bay or on a warm loading dock — directly affects the actual remaining quality and safety. Your inventory system needs to track batch codes and receipt dates, not just use-by dates.
Using this inventory template for daily stock control
Complete a full stock check weekly, with a spot check on high-risk items (fresh meat, dairy, prepared foods) daily. Record product name, supplier, batch code, delivery date, use-by date, and quantity. The batch code is the critical field for traceability — if there is a product recall, you must be able to identify which batches you received and when.
Paper inventory sheets work for small operations, but they do not flag approaching expiry dates or trigger reorder alerts. Digital SFBB inventory management links your stock records to supplier approvals, temperature logs, and menu planning. When the FSA issues a product recall, you can search your inventory by batch code in seconds rather than rifling through weeks of paper records.
Inventory errors that cause food safety failures
Ignoring batch codes. Recording only the use-by date is insufficient for traceability. If two batches of the same product are delivered in one week and one is recalled, you cannot identify which is which without batch codes.
Decanting without labelling. Moving food from original packaging into storage containers without transferring the use-by date and batch code breaks your traceability chain. Every container must be labelled.
Stock counted but not rotated. Taking inventory is pointless if you do not physically move older stock to the front and newer stock to the back. The act of counting must include rotation — otherwise it is just a paperwork exercise.
Prevra · Early access
Prevra is building a digital SFBB app.
The app is not ready yet. See the planned features and contact us about early access.
See planned features