HACCP Excel - Free Template

1. Open Instructions and review the workbook layout, including the pale-yellow cells intended for manual entry.
2. In CCP Hazard Analysis, enter the facility and plan date, then list each process step from receiving through shipping.
3. Select Biological, Chemical, or Physical for each hazard and mark CCP? as Yes or No using the dropdown lists.
4. Enter the operator-supplied minimum and maximum limits, monitoring procedure, frequency, corrective action, responsible person, and verification method.
5. In Monitoring Log, enter the date, time, CCP step, and measured temperature for each scheduled check. Complete the corrective-action, verifier, and notes fields when appropriate.
6. Review the calculated limits and Pass or Fail status after each entry; do not overwrite formula cells in columns E through G.
7. Open Dashboard for the current summary, then review the step-level results and charts with the food-safety team.

A restaurant kitchen manager, commissary supervisor, caterer, food truck operator, or small processing facility can use this workbook to keep the food-safety team working from the same process record. A receiving clerk can document a delivery check, while a production employee can record cooking, cooling, hot-holding, or cold-holding measurements.

For Receiving And Production Teams

The CCP Hazard Analysis tab gives each process step one row with a hazard type, description, limit range, monitoring procedure, frequency, corrective action, responsible person, and verification method. Image 1 shows the 12-column layout, including the sample Receiving row with a 32°F minimum and 41°F maximum entered as facility-plan values.

For Weekly Review

The Monitoring Log is designed for repeated checks in its prepared entry area. Image 2 shows entries such as 38°F for Receiving, 172°F for Cooking, and 45°F for Cooling; these are populated workbook samples, not universal operating limits. The Dashboard then groups results across five named CCP steps, so a supervisor can see where follow-up is needed.

This workbook is a documentation and calculation aid, not an FDA certification or a determination that your plan meets every applicable requirement. Enter the limits and check frequencies approved for your operation; the sample values illustrate the layout and should be replaced when they do not apply.

Operator-Supplied Plan Inputs

In CCP Hazard Analysis, the minimum and maximum temperature fields are manual inputs. The Monitoring Log retrieves those values with VLOOKUP from the selected CCP Step. For example, if Receiving has a 32°F minimum and 41°F maximum, a recorded 38°F is evaluated against that range.

Calculated Monitoring Status

The Status column returns Pass when the measured temperature is greater than or equal to the minimum and less than or equal to the maximum; otherwise it returns Fail. Image 3 shows the Dashboard's key metrics, including total CCPs, total checks, passed checks, failed checks, and overall compliance rate. Review your facility's applicable food-safety requirements separately and retain supporting records according to your operating policy.

The most expensive failures are often simple: the employee records a measurement but leaves the CCP Step blank, types a step name that is not in the dropdown, or replaces a formula with a hard-coded number. In this workbook, the limit lookup depends on the selected step matching a process step in CCP Hazard Analysis.

Wrong Limits Create Wrong Statuses

If a facility changes a limit but updates only the Monitoring Log, later entries can pull the old value from the analysis tab. The safer position is to maintain the approved limit in one place—CCP Hazard Analysis—and let the formulas retrieve it. A 38°F reading may show Pass under one range and Fail under another, so the plan input must be reviewed before relying on the result.

Incomplete Corrective Actions

A Fail result without a completed Corrective Action Taken field leaves the record difficult to interpret. Image 2 shows a sample Hot Holding entry with a corrective action describing reheating to 165°F and verification; use that field to document what your team actually did, rather than leaving a vague note such as “fixed.”

Assign one person to enter each check immediately after it is taken and one reviewer to inspect the Dashboard at a fixed weekly meeting. The Instructions tab specifically points users toward updating the Monitoring Log at every scheduled check and reviewing the Dashboard weekly.

A Practical Entry Routine

• Record Date, Time, CCP Step, and Measured Temp (F) before moving to the next task.
• Read the returned limits and Status instead of manually calculating Pass or Fail.
• Complete Corrective Action Taken, Verified By, and Notes whenever a result needs explanation.
• Review the Dashboard's five CCP-step rows and two charts during the weekly food-safety review.

Protect The Calculations

Use the dropdown for CCP Step rather than typing variations such as “cold storage” when the prepared list expects Cold Holding. Keep formula cells intact, save a dated copy according to your record policy, and test the workbook with a known measurement such as 38°F against the applicable entered range before putting it into routine use.