Case study · Construction

Site hours, task progress and payroll in one app for a construction company

This construction company pays site workers twice a month and tracks progress task by task. Hours, progress and payroll were spread across separate spreadsheets. We built a Spanish-language Retool app on Supabase that records each worker’s hours against project tasks, suggests progress from hours against budget, and prepares payroll by pay period.

The challenge

What wasn’t working

Hours had to be logged against the right task, several levels deep: project, category, subcategory, activity, then task. Picking from one long list invited mistakes.

Progress reports needed a sensible starting figure, and earlier reports had to stay on record rather than be overwritten.

Payroll needed hours grouped by pay period and worker, with the right bank account for each payment.

The solution

What we built

Hours by task

An editable table of each worker’s hours, with cascading dropdowns from project down to task, saved in one batch with a MERGE upsert.

Suggested progress

Progress is suggested as hours worked against budgeted hours, capped at 100%, and the site team can adjust it.

Full progress history

Each new report is stored as a new record and the old one is marked as superseded, so nothing is lost.

Dependency warnings

A task status screen warns when someone starts a task whose predecessor isn’t finished.

Payroll by pay period

Hours per worker per pay period and day of the week, with the payment account assigned.

Safety nets

Delete confirmations, a warning when leaving a page with unsaved changes, and one-click generation of foreman hours for a pay period.

How it works

From timesheet to payroll

  1. 1

    Log hours

    Hours are entered against the right task for each worker and day.

  2. 2

    Report progress

    The app suggests progress from hours used and the site team confirms it.

  3. 3

    Check dependencies

    Task statuses are updated, with a warning if a predecessor is still open.

  4. 4

    Close the period

    Foreman hours are generated and payroll is grouped by worker and bank account.

Screens

Inside the build

The result

What changed

  • Site hours and progress in one place instead of separate spreadsheets
  • Progress reports start from hours against budget, so they’re more consistent
  • A complete history of every progress report
  • Payroll prepared straight from the logged hours

Have a project like this?

Tell us what you need to build. In 30 minutes we’ll map what to build first and follow up with a fixed-scope estimate.

Official Retool Agency Partner5.0 on Clutch, 9 reviewsBuilding software since 2015Reply within one business day