Restaurants · cafés · delis · catering

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
Add to basket
HACCP Records System – Dashboard

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?
No. It is an independent workbook that follows the same HACCP logic and records, but it calculates and flags readings for you.
Can I write my own HACCP plan with it?
Yes. The plan is yours to fill in; example steps help you start, and you change them to match your kitchen.
Does using it make us compliant?
It helps you run and prove your food safety system. Compliance depends on the system being right for your business and followed every day.

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.

Have the records ready when the inspector calls

Add the HACCP workbook to your basket and continue to payment.

Add to basket