Fleet management system
Challenge
A transport company with 10+ trucks and drivers tracked everything in Excel: trips, vehicle expenses, payroll — all scattered across separate spreadsheets. No consolidated P&L per driver, trip statuses had to be confirmed by phone, and the dispatch queue existed only in the manager's head.
What was built
A fleet management system built on Laravel 12 + Livewire v4 — 11 modules replacing scattered Excel spreadsheets with a single platform.
Drivers
full driver profile: contacts, documents, assigned vehicle. Show page with tabs: trips, expenses, payroll — the complete P&L per driver in one place.
Counterparties
client and partner database with accounts receivable tracking: outstanding balance, unpaid trips, contact details.
Trucks & Trailers
fleet CRUD with driver assignment, status tracking (active/maintenance/idle) and full trip history per vehicle.
Routes
route reference book with distances. Used when creating trips to automatically calculate mileage and fuel costs.
Trip Queue
trip queue with a state machine: scheduled → pending → in_progress → delivered → closed. When an active trip closes, the next one in queue automatically becomes in_progress without manual intervention.
Expenses
categorised expenses by vehicle and driver: fuel, repairs, fines, depreciation. Categories managed from the admin panel without touching the code.
Salaries
payroll calculation: % of trip revenue + fixed payments. Payout log with date and comment.
Monthly P&L Reports
monthly report per driver: trip revenue, expenses (fuel, repairs), salary, net profit. Month-over-month comparison.
GPS Tracking
Leaflet map with real-time positions of the entire fleet via Freetrack API. View the current location of any vehicle without calling the driver.
Telegram Notifications
automatic manager alerts on trip status change: closed, delivered, issue. Configurable per event type.
Settings
dynamic management of expense categories, rates and payroll calculation parameters. Everything through the UI without code or manual DB edits.
Result
Excel replaced with a fully-featured system. Management sees a consolidated P&L per driver in real time without calls or manual spreadsheets. The trip queue and GPS tracking eliminate the need for manual status monitoring and vehicle location checks.
Tech stack
Have a similar challenge?
Discuss a projectNext case
System development
TMS platform for a freight company →