Transport / operations · Calgary, AB
Prairie Fleet Logistics
Forty drivers and three dispatchers moved off a shared spreadsheet onto a real portal with logins, live job status and exportable records.
- Package
- Web App
- Timeline
- 6 weeks, start to launch
- Industry
- Transport / operations
The challenge
Dispatch ran on one spreadsheet that everybody edited at once. Job status was whatever the last person typed, proof-of-delivery photos lived in personal phone galleries, and month-end invoicing took four days of reconciliation.
Before and after
Before
- One shared spreadsheet, frequent overwrite conflicts
- Status updates by text message, often missed
- Delivery photos scattered across personal phones
- 4 days of month-end reconciliation
- No history of who changed what
After
- Role-based logins for drivers, dispatch and admin
- One-tap status from the cab, live on the dispatch board
- Proof-of-delivery photos attached to the job record
- Month-end export in under an hour
- Full audit trail on every field change
What we built
- Modelled jobs, drivers and clients properly, with row-level access so drivers see only their own work.
- Built a mobile-first driver view: today's runs, one-tap status, photo upload on delivery.
- Gave dispatch a live board with filters, assignment and a full audit trail per job.
- Added CSV and PDF exports shaped to match the accountant's existing invoicing process.
Results
-94%
Month-end admin
4 days down to ~3 hours
0
Lost delivery proofs
Down from ~11 per month
+18%
Jobs per dispatcher
Same headcount, more volume
2 min
Driver onboarding
Invite, set password, done
“The spreadsheet was costing us more than the build did. Dispatch can finally see the whole day at once.”
More case studies
Healthcare / clinic
Northshore Dental Studio
A two-chair clinic replaced a slow template site with a fast, bookable, bilingual-ready presence — and stopped losing evening enquiries to voicemail.
Retail / e-commerce
Harbour Roast Coffee
A wholesale roaster added a direct-to-customer store with subscriptions, real shipping rates and receipts that stopped landing in spam.