Workforce Rota, Clock-in Compliance and HR Analytics

The challenge

Rota planning depended on Excel workbooks with manually maintained formulas for expected hours, allocated hours and lost hours. Once a workbook was shared with end users, an altered formula or structure could invalidate the totals and force HR to recalculate the period. The organisation lacked one controlled version of the rota and one dependable audit trail for who changed, submitted or approved it.

Locum management created a second control gap. Non-permanent staff were brought in to cover shifts, but the reason for cover, the permanent employee gap and the locum's actual attendance were tracked manually. It was difficult to enforce the rule that a permanent employee should first complete 184 hours or be on approved leave before requesting locum work, and difficult to justify payment by comparing rota hours with verified clock-in and clock-out time.

What I built

I developed a browser-based rota and workforce-governance platform that synchronizes employee records and HRMIS leave, allocates coded shifts, calculates expected and assigned hours, and moves each monthly rota through submission and approval. Controlled reports replace distributed calculation workbooks with one rules-based source of truth.

The attendance layer connects the approved rota to clock-in/out evidence and highlights late starts, early departures, missed punches, overtime, shift mismatches and planned-versus-worked hours. The locum workflow captures why cover is required, checks permanent-employee hours or leave context, records the approved shift and compares the locum's scheduled hours with actual attendance before payment review.

How the organisation benefits

HR and department managers gain a common operating picture from workforce planning through attendance and payment review. Formula logic is protected in the application, rota versions and approvals are traceable, and exceptions can be analysed by facility, department, job or employee without rebuilding spreadsheets.

For locums, the system creates a defensible chain from the staffing gap and approval reason to the assigned shift, clock evidence and payable hours. This does not remove human authorization; it gives approvers better evidence to challenge unsupported cover, investigate non-attendance and reduce payment based only on scheduled rather than worked time.

Delivery reality

Workforce rules are rarely as simple as subtracting one timestamp from another. Overnight shifts cross calendar dates; leave, days off and public holidays change expected hours; missing punches are not automatically absence; and grace periods must be transparent and consistently applied. I translated these policies into visible calculation rules and retained correction and approval controls for genuine exceptions.

Adoption also required moving managers away from familiar Excel habits without losing the reports they relied on. The delivery approach therefore combined synchronized master data, phased rota approval, familiar matrix-style reports, user training and audit logs so the platform could become the controlled record rather than another parallel tool.

System narrative