Replacing five spreadsheets with one ops dashboard at North Harbor Logistics
5 spreadsheets → 1 dashboard. Late-job visibility went from end-of-day to real-time.
Outcome figures illustrative — pending client sign-off
Daily admin time
−~3 hours / day
Late-job detection
Real-time vs end-of-day
New-hire ramp time
Weeks → days
The problem
Five overlapping spreadsheets ran the daily dispatch — drivers, jobs, capacity, customer comms, and invoicing. Late jobs only surfaced at end-of-day reconciliation. New ops staff took weeks to ramp.
Our approach
We built a single dispatch dashboard with role-based views for ops, drivers, and customers. Drivers update job status from a phone view; ops sees the board in real time; customers get auto-tracking links.
Stack
- Next.js
- PostgreSQL
- Tailwind
- Auth.js
- WhatsApp Cloud API
“We stopped reconciling spreadsheets. The board is the source of truth — drivers update it, customers see it, finance bills off it.”