Fleet Management System – Google Sheets Apps Script

A fleet and transport management dashboard built on Google Sheets. It tracks the three things a transport operator actually loses money on: where the vehicles are committed, what each driver is owed, and whether a job made a profit after costs. Everything sits in one Google Sheet-backed app instead of a booking diary, a payment notebook and a spreadsheet of fuel bills.

What it does

Vehicles and drivers are kept as records; services and bookings are raised against them, with a driver assigned to each job. Payments are tracked on both sides — what the customer paid, in cash or by card, and what the driver is owed — and the revenue and profit calculator turns that into a number for the period rather than a guess. Provider performance reports and a top performers dashboard show which providers and drivers are actually carrying the operation. Maintenance logs, route management and cost tracking keep the running side of the fleet in the same place, and partner access means an outside provider can be let in without handing over the whole admin panel.

Highlights

• Fleet dashboard with vehicle and driver tracking
• Service and booking management with driver assignment
• Driver payment tracking, plus cash and card payment records
• Revenue and profit calculator
• Provider performance reports and a top performers dashboard
• Maintenance logs, route management and cost tracking
• Multi-vehicle management and full service history
• Admin and partner access control

Who it is for

Taxi and rental companies, logistics operators, school and staff transport providers, and anyone running a handful of vehicles who has outgrown a spreadsheet but does not want per-vehicle monthly fleet software.