An attendance sheet that stands up to an inspection

The day the labour inspectorate, an auditor or internal control asks to justify an employee’s pay, HR has to produce evidence. A hand-filled spreadsheet is not evidence: anyone could have written it. An attendance sheet that holds up rests on four principles.

1. Every line traces back to a clock-in

No figure is typed by hand. Every cell of the calendar opens down to the exact timestamp and the terminal that recorded it. The document does not summarise an opinion about attendance: it restores machine facts.

2. Corrections stay visible

An employee forgot to clock in, a terminal was down: the correction is legitimate. But it does not replace the original clock-in — it is added alongside, with its author, date and reason. The inspector sees what happened and what was decided.

3. The same month gives the same document

Regenerated later, the sheet for a closed month is identical to the one that was handed over. Each document carries a reference and a fingerprint hash that make it possible to check it has not been altered.

4. Data comes out in open formats

PDF for the file, CSV or Excel for the inspection: the auditor works with their own tools, on the raw clock-ins if they wish.

Why it also helps internally

An indisputable sheet defuses most disputes before they begin. The employee who contests a deduction sees the same thing as HR. The discussion is about the reason, never about the facts. It is the same principle that makes payroll calculation traceable to the minute.

And because the audit log records every approval, the chain of responsibility is clear, from clock-in to payslip. The protection mechanisms are detailed in HR data security.