A payroll allocation platform, built to replace Excel.
Context
The client’s staff allocated payroll across programmes in Excel workbooks. I built the timesheet and payroll allocation app that replaced them, which staff now use to close each month.
What I did
- Built it: Flask, PostgreSQL and React.
- Checked it against the client’s workbooks; found and fixed 17 defects.
- Fixed controls that reported “compliant” on empty months.
- Guarded closed months against later imports.
- Five fixes shipped as five pull requests in one day.
More
- Shipped staff requests: split allocations, Excel paste, multi-month uploads.
- Unblocked a month-close traced across six layers of the app.
- Wrote client updates in French; handed over once the client ran it alone.
Outcome
Coverage totals matched to the cent, 219 of 222; the only material gap was the client’s own workbook error. 2025 payroll: 87% of employees to the cent. Eight people paid but missing from the roster, flagged.