HACCP template in Excel – plan, daily records and allergen matrix
An environmental health officer wants to see two things: a HACCP plan that fits your kitchen and records that prove it is followed. This workbook holds both. Readings outside your limits turn yellow or red the moment they are typed, and a monthly review is built from the records themselves.
- HACCP plan with CCPs and critical limits
- AM and PM log for up to 8 fridges and freezers
- Cooking 75 °C and hot holding 63 °C with pass or fail
- 14-allergen matrix for 60 dishes

The seven principles in one tab
HACCP PLAN lists each process step with its hazards, control measures, whether it is a critical control point, the critical limit, how it is monitored and what to do when it goes wrong. Review intervals and limits are set in SETTINGS.
Daily records
- FRIDGE & FREEZER: morning and evening readings against each unit's limit
- COOKING & COOLING: cooking, reheating, hot holding and cooling checks
- GOODS IN: temperature by category, use-by date and condition per delivery
- The CLEANING & PEST tab: cleaning schedule with last done and next due, and pest control
There is room for 400 days of records, 800 cooking checks and 600 deliveries.
Questions and answers
Is this the FSAI Safe Catering pack?
Can I write my own HACCP plan with it?
Does using it make us compliant?
A look at the sheets




Technical details
- START
- SETTINGS
- HACCP PLAN
- FRIDGE & FREEZER
- COOKING & COOLING
- GOODS IN
- CLEANING & PEST
- ALLERGENS
- ACTIONS & REVIEW
- DASHBOARD
- File format
- .xlsx
- Tabs
- 10
- Capacity
- 400 days · 800 cooking checks · 600 deliveries · 800 cleaning sign-offs · 60 dishes
- Requires
- Excel 2016+ / Microsoft 365
- Macros
- None
Allergens and the monthly check
ALLERGENS is a dish-by-allergen grid with the 14 allergens, "may contain" entries and menu numbers. ACTIONS & REVIEW builds a monthly verification from the records, with sign-off and a readiness check before an inspection.