Time Tracking Management template
Timesheets that answer the only question that matters on site: are we inside the budget? Crew with hourly rates, cost codes carrying budget hours and budget cost, and entries that price themselves, separate overtime, and roll up into an actual-versus-budget variance per cost code.
Tables
Crew
Badge, Name, Trade, Hourly rate, Hired, Safety certified, Phone, Email, Timesheet entries, Entries logged, Hours logged, Labour cost, Notes
Cost codes
Cost code, Site, Phase, Budget hours, Budget cost, Start, Finish, Timesheet entries, Actual hours, Actual cost, Budget rate €/h, Duration (days), Notes
Timesheet entries
Entry, Worker, Worker record, Rate, Cost code, Cost code record, Site, Work date, Regular hours, Overtime hours, Work kind, Approval, Total hours, Entry cost and 2 more
Views
- Timesheet log (grid)
- Approval board (kanban)
- Hours calendar (calendar)
- Hours by cost code (chart)
- Waiting for approval (grid)
- Budget vs actual (grid)
- Cost-code programme (timeline)
- Crew workload (workload)
Forms
- Submit a timesheet entry
Automations
- Notify the foreman on a new entry
- Email payroll when an entry is approved
- Daily budget check
- “Timesheet entries” reached “Rejected”
- “Cost codes” reached “External works”
- Daily sweep — still open in “Timesheet entries”
- “Safety certified” was ticked in “Crew”
- Large value in “Regular hours”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.