On prevailing-wage projects, someone has to check every subcontractor's weekly certified payroll report by hand. We built a skill that reviews each report against the project's wage scale automatically and keeps one dashboard showing who is compliant, what needs attention, and who owns the fix.
The problem
Every prevailing-wage project collects weekly certified payroll reports from every subcontractor. Reviewing them means confirming each report is signed, that every worker's classification actually exists on the project's wage scale, and that everyone was paid at or above the scale minimum, including 1.5x for overtime. Across dozens of subs, every week, on a multi-year project, that is slow, repetitive, and easy to get wrong, and the mistakes carry real compliance risk.
What we built
A skill pointed at a project's certified payroll folder. On every run it:
- validates each new report against the wage scale, the signed compliance statement, each worker's classification, and pay at or above the scale minimum with overtime at 1.5x or better, reading scanned reports by OCR where needed;
- keeps a permanent, week-by-week record as the source of truth and rebuilds one Excel dashboard from it, a summary, the open to-do list, and a tab per sub, so nothing is dropped and no two indicators can disagree;
- never guesses. An unrecognized classification, an unsigned report, a missing week, or a sub it cannot identify becomes an assigned to-do or a question, not a silent judgment call. Even a file it cannot read is flagged, not skipped;
- learns from the team. When the compliance lead resolves a classification, that decision is remembered and applied automatically on every run after.
The skill validates and flags; the team resolves the exceptions, and their decisions make it sharper over time.
The result
Weekly certified payroll review shifts from a manual slog across dozens of subs to a dashboard that stays current on its own, backed by a full record of every report and every run. Compliance is visible at a glance, exceptions are assigned rather than missed, and the reports that come back clean no longer need a manual read at all.
