What Is Required
Under UK statutory standards—including the Companies Act 2006 (sections 386–388), HMRC electronic record-keeping frameworks (such as Making Tax Digital), and statutory payroll requirements—records must remain reliable, accurate, and verifiable. The fundamental principle requires that an entry must not be altered or overwritten in such a way that its original content is obscured or lost.
This standard applies not only to core general ledgers but also to all upstream feeder systems, including operational time tracking, attendance logs, and project billing software used to substantiate payroll, National Minimum Wage (NMW) compliance, Working Time Regulations (WTR 1998) limits, and client invoicing.
Traceability Rather Than a Prohibition of Amendments
Statutory compliance does not prohibit genuine corrections or retroactive adjustments. Instead, it mandates complete transparency: every alteration must preserve the original historical entry while capturing an immutable audit log containing:
- The exact date and timestamp of the amendment.
- The unique identity of the user who made the change.
- The previous and newly updated values.
- The operational or legal reason for the correction.
A dedicated digital time tracking platform that maintains an immutable, append-only audit trail—recording edits as distinct event logs while keeping the initial entry intact—fully satisfies statutory requirements under HMRC, Employment Tribunal, and regulatory scrutiny.
Why Spreadsheets Regularly Fail Compliance
Standard spreadsheets (such as Microsoft Excel or Google Sheets) allow historical cells to be overwritten retroactively without producing an automatic, tamper-evident audit log.
While businesses sometimes attempt to achieve compliance using strict folder permissions, file versioning, or manual change logs, these arrangements are operationally fragile and rarely withstand rigorous scrutiny during HMRC wage investigations, National Minimum Wage audits, or employment dispute tribunals. Where working hours, holiday pay calculations, or overtime records are contested, unlogged spreadsheets are routinely challenged or dismissed as insufficient proof of compliance.
Technical and Operational Implementation
To guarantee full compliance and tamper resistance, an organisation's time tracking and HR systems must incorporate:
- Individual User Authentication: Distinct credentials and role-based permissions for every individual recording, approving, or amending data.
- Append-Only Audit Trail: Automated, tamper-proof logging of all record creations, edits, and deletions that cannot be manipulated by administrative users.
- Database-Level Integrity: Security controls and encryption preventing direct, unlogged modifications to the underlying database tables.
- Period Locks & Timesheet Approval Workflows: A formal period-close process after which historical timesheets are locked against ordinary edits and can only be amended via documented, auditable adjustment entries.
- Updated on