Food Safety Records Bundle, HACCP CCP Monitoring, Temperature Log, Sanitation Schedule, Allergen Matrix Excel

Four daily food safety records for one site in one download: HACCP CCP monitoring, temperatures, cleaning and allergens – with a shared setup file: enter your site, people and calendar once and paste them into each tool.

✔ 4 Excel tools: HACCP CCP log, temperature log, master sanitation schedule, allergen matrix
✔ Missing checks, out-of-limit results, missed cleaning and open actions shown in red
✔ Shared setup file: enter site, days, people, areas and lines once, then paste into each tool
✔ Instant download: 4 × BLANK + EXAMPLE · Start Here PDF · Quick Start guides + printable forms
✔ Built by a food production manager · one-time purchase, no subscription, no macros

▶ Requires Microsoft Excel 2016 or newer on a Windows or Mac computer. Not for Google Sheets, Apple Numbers, Excel Online or mobile apps.

Save 29% compared with buying the four tools separately. They are exactly the same files as the four single listings in our shop.

━━━━━━━━━━━━━━━━━━━━
WHAT'S IN THE BUNDLE
━━━━━━━━━━━━━━━━━━━━
1) HACCP CCP MONITORING LOG
• Up to 30 CCPs with critical and operational limits – number or Pass/Fail
• Every check shows IN LIMIT, NEAR LIMIT or OUT OF LIMIT
• Deviations with corrective action, product decision and closed date
• 14-day missing-check matrix, weekly verification, printable daily record and CCP sheet

2) TEMPERATURE MONITORING LOG
• Fridges, freezers, cold rooms and hot holding – up to 40 units
• 1–6 readings per day, TOO LOW / TOO HIGH, action + re-check + product assessment
• 14-day missing-reading matrix, printable month sheet per unit, °C or °F

3) MASTER SANITATION SCHEDULE & CLEANING LOG
• Up to 300 cleaning tasks with due dates from daily to annual
• MISSED / DUE / OK per task, cleaning log with on time / late
• Visual, ATP or swab verification: fail → re-clean → re-check → closed
• Weekly list, monthly checklist per area to print and sign, workload per role

4) ALLERGEN MATRIX
• 20 allergens (EU / UK 14 pre-filled, editable), raw materials, products and recipes
• Product allergens calculated from recipes – contains, may contain, shared line, incomplete data
• Label check, line matrix and allergen changeover check with clean record

━━━━━━━━━━━━━━━━━━━━
SHARED SETUP – ENTER ONCE, PASTE INTO EACH TOOL
━━━━━━━━━━━━━━━━━━━━
The four tools need some of the same information. The bundle includes a setup workbook – a centralized initial setup, not a live link:
• MASTER_DATA: site name, records start date, open days, closed dates, up to 30 people, 25 cleaning areas and 20 production lines – typed once, checked for duplicates and empty rows
• COPY_GUIDE: 18 short copy-and-paste steps (Paste Values) with the exact cell in each tool, Ready status and "what you should see in the tool" (number of entries, first … last) – about 10–15 minutes including a final check
• "Done" on COPY_GUIDE is your own checklist – the setup file cannot see or check the other workbooks

The tools are NOT linked or synchronised. A change on MASTER_DATA (new person, new closed day, new line) reaches a tool only when you paste that block again – the Start Here guide has a table for each kind of change. Separate files on purpose: QA, hygiene and production can each keep their file, and files can be moved, renamed or e-mailed without broken links.

━━━━━━━━━━━━━━━━━━━━
HOW IT WORKS
━━━━━━━━━━━━━━━━━━━━
1. Unzip on a computer and open 00_START_HERE (3-page PDF)
2. Fill in MASTER_DATA in the setup file and paste the lists into the four BLANK files
3. Finish each tool's own setup: CCPs and limits, temperature units, cleaning tasks, allergens and recipes
4. Log every day – each DASHBOARD shows what is missing, out of limit, overdue or still open

━━━━━━━━━━━━━━━━━━━━
WHO IT'S FOR
━━━━━━━━━━━━━━━━━━━━
Small and medium food manufacturers, bakeries, central kitchens and catering, meat, dairy and ready-meal producers – QA and food safety managers, technologists and production managers who keep HACCP, BRCGS, IFS or SQF records in Excel.

━━━━━━━━━━━━━━━━━━━━
CAPACITY – PLEASE CHECK BEFORE BUYING
━━━━━━━━━━━━━━━━━━━━
• HACCP CCP log: 30 CCPs · 20 people · 30 closed dates · 5,000 check rows
• Temperature log: 40 units · 1–6 readings per unit and day · 20 people · 30 closed dates · 8,000 reading rows
• Sanitation schedule: 300 tasks · 30 people · 25 areas · 60 closed dates (30 come from the setup file) · 5,000 log rows
• Allergen matrix: 20 allergens · 300 raw materials · 150 products · 2,000 recipe lines · 20 production lines
• Setup file: 30 people · 30 closed dates · 25 cleaning areas · 20 production lines

━━━━━━━━━━━━━━━━━━━━
LIMITS – PLEASE READ
━━━━━━━━━━━━━━━━━━━━
• The tools record and check your monitoring. Hazards, CCPs, limits and actions come from your own HACCP study – this is not a HACCP plan and not a certification.
• No sensors, no automatic data logging, no e-mail reminders, no audit trail.
• The four files are not linked: shared lists are copied once and copied again when they change.
• One site per set of files. Setup time: about 15 minutes for the shared lists, then from 30 minutes per tool.

━━━━━━━━━━━━━━━━━━━━
FAQ
━━━━━━━━━━━━━━━━━━━━
Is this the same as buying the four listings?
Yes – the same files, plus the setup workbook and the Start Here guide, at a lower price.

Are the files linked or synchronised?
No. You paste the shared lists at the start and again when a list changes. Nothing breaks when you move or e-mail a file.

Can I edit the lists and limits?
Yes. Yellow cells are yours. Formulas are protected without a password to prevent accidental damage.

Do dates work in my language?
Yes. Dates are real Excel dates and show in your Excel format.

━━━━━━━━━━━━━━━━━━━━
DIGITAL DOWNLOAD
━━━━━━━━━━━━━━━━━━━━
You receive one ZIP file (about 10 MB). Nothing physical is shipped. Download it on a computer, unzip it and open the files in Microsoft Excel.

Related tools from SmartFactoryTools: CAPA Tracker, Customer Complaint Tracker, Calibration Tracker, Training Matrix.

━━━━━━━━━━━━━━━━━━━━
LICENSE
━━━━━━━━━━━━━━━━━━━━
For use within your own company or organization (any number of employees). Reselling, sharing or uploading the files elsewhere is not permitted. © SmartFactoryTools