voupe
George Cox Payroll
Weekly timesheets, holiday and absence requests, and payroll reports for a contractor's site teams
Mark Jennings
Ganger · Week ending Sunday 13 December 2015
| Day | Job | Normal | T&⅓ | T&⅔ | Approved |
|---|---|---|---|---|---|
| Mon | J2381 · Riverside footpath fencing | 8.0 | 1.5 | – | ✓ |
| Tue | J2381 · Riverside footpath fencing | 8.0 | 2.0 | – | ✓ |
| Wed | J2394 · Mill Lane drainage | 8.0 | – | – | ✓ |
| Thu | J2394 · Mill Lane drainage | 8.0 | 1.0 | – | … |
| Fri | J2402 · School car park resurfacing | 7.5 | – | – | … |
| Sat | J2402 · School car park resurfacing | – | – | 5.0 | … |
| Sun | Not working | – | – | – | |
| Total | 39.5 | 4.5 | 5.0 | ||
Comment: Saturday was the weekend resurfacing shift, agreed with Dave.
Holiday request
Sam Walsh
Mon 21 – Thu 24 December · 4 days
This week
46
Submitted
38
Approved
3
Missing
About the project
Payroll is the biggest of the apps I built for George Cox & Sons, and the one most of their staff use every week.
Each week, everyone fills in a timesheet, line by line against the jobs they worked on. Hours are split into normal time, time and a third, and time and two-thirds, and each person’s grade sets their hourly rate. Supervisors then approve the week, or decline a line with a comment, and the person is emailed straight away to fix it.
It also handles:
- Holiday and absence requests, approved by a manager and counted against each person’s yearly entitlement
- Importing everyone’s holiday entitlements at the start of the year
- Reports showing whose timesheets are in, total hours for the week, and a breakdown by supervisor
- Keeping the job list up to date, by pulling new jobs from their Contracts app every 20 minutes
It’s been running since 2014. I’ve kept it up to date since, most recently moving it to Docker.