From 5 Spreadsheets to One Platform
A 1,200-employee hospital replaced disconnected Excel sheets with a unified workforce system — cutting monthly payroll close from 4 days to 6 hours.
See the Platform in Action
Running 1,200 People on 5 Excel Files
The hospital's HR team tracked attendance, shifts, and leave across five separate spreadsheets — one per department, none connected. Every month, the finance team spent four days manually piecing them together before payroll could run.
Errors in that process led to compliance notices. Managers had no live visibility into their team's attendance. And every shift swap happened over WhatsApp, then got manually entered hours later.
They needed one system — not another tool to manage alongside everything else.
What Was Actually Going Wrong
Every team had workarounds. The workarounds had workarounds. Here's what we found when we mapped the real workflow.
5 Attendance Sheets, 0 Connection
Each department kept its own register. No one had a full picture until month-end, when someone had to manually merge them all.
4-Day Payroll Close
Three finance staff spent the first four days of every month just reconciling attendance data before payroll could even begin.
Repeated Compliance Notices
Labour compliance reports were built from the same manually-merged data — so errors in the source meant errors in the filing.
Zero Live Visibility
Department heads had no way to see who was present today. Absenteeism was noticed monthly, not daily — too late to act.
Built to Fit Their Workflow, Not Ours
We spent the first two weeks listening — not building. Only after mapping every process did we write a line of code.
Discovery
Interviewed HR, finance, and department heads. Mapped every data flow — from a shift-swap request to a payroll export. Found six points where manual effort was the only option.
Architecture
Designed one unified data model — attendance, leave, shifts, and payroll rules in a single source of truth. All departments write to the same system, in real time.
Build & Test
Built in phases: attendance first, then leave, then payroll, then compliance. Each phase was tested with real users before the next began.
Launch
Onboarded all 1,200 employee records with zero data loss. Ran live training sessions. The team processed their first payroll on the new system — in 6 hours.
Swipe through the key screens we built
What Changed After Launch
Measured 6 months post-launch.