Subcontractor Reputation and Job Tracker

What it is

An internal Next.js and Supabase tool for Westerfield Paint to track subcontractors, the jobs they work, amounts paid and an average rating. Admin and sales reps have separate logins; reps see only their assigned jobs and work through a four-stage checklist from pre-estimate call to final walkthrough and payment.

The problem

Tracking which subcontractors do good work, and what they have been paid, needs one shared record.

How it works

1. Supabase Auth for rep accounts, with a separate env-password admin login
2. Role-filtered views: reps see assigned jobs, admin sees jobs grouped by rep and can reassign
3. Contractor stats (total jobs, total paid, average rating) recomputed when jobs change
4. Rep job-claiming and a four-stage checklist per job

Stack

Disciplines

For your business

Lightweight internal tools that give a service business one shared record of subcontractors, jobs and payments.