The Hygiene Management System

The problem

Everything ran on paper. Cleaning records, checks, sign-offs – all of it lived in ring binders and folders. Paper has one bad habit: it goes missing quietly. A sheet gets wet, a page slips out, a binder walks off to another room, and nobody notices until an auditor asks for the one record that isn't there.

The setting is a BRCGS-certified Scottish food manufacturer – two sites, a team of 57. When an audit lands you need the proof fast and complete. Searching through paper for a record that may or may not still exist is not a good place to stand.

What I built

I replaced the paper with one system. A few plain rules held the whole thing together.

• One folder, every tool. Every part of the system reads and writes to the same place. There is one source of truth, not a copy on each machine that slowly drifts out of step.
• The log is the truth, the screen is just a view of it. Nothing gets overwritten. Every action is added to an append-only log on each PC – a new line, never an edit. Want to know the exact state last Tuesday at 2pm? Replay the log up to that point. Records can't change behind your back, because the system never changes them. It only adds.
• Paperwork that builds itself. Sign-off sheets print from the same data, then a QR stamp sorts each sheet the moment it is scanned back in. An hour of filing became a scan.
• One report across both sites. A shift report pulls from both sites into a single view, and a dashboard of around thirty widgets shows where each team stands right now.
• A holiday board. Time-off requests, cover and approvals sit in one place, so the schedule never has a hole nobody spotted.

What changed

The paper problem is gone. When a live data-loss incident hit, nothing was lost – the append-only logs meant every record could be rebuilt line by line. The system runs across both sites for a team of 57, and helps keep both sites ready for their BRC and M&S audits.