Fleet management log
A log to keep a small fleet in order. The Fleet sheet lists each vehicle with its driver, odometer, last service and service interval, insurance end date and inspection date. It works out when the next service is due and the kilometres left, shows a status (OK, Due soon, Service overdue or Papers expired) and adds up each vehicle's fuel cost from the Fuel sheet, where every fill-up is logged with its cost per liter. Download it as Excel, OpenDocument, PDF or CSV.
Fleet
Fleet management log
One row for each vehicle. Service, insurance and inspection dates are checked against the status date. Log fuel on the Fuel sheet.
Company Baltic Courier Services
Status date (empty for today) 2027-06-01
Date used for the status 2027-06-01
| Vehicle ID | Registration plate | Make and model | Driver | Odometer (km) | Odometer at last service | Service every (km) |
|---|---|---|---|---|---|---|
| V-01 | KB 4821 TR | Ford Transit Custom | Jonas | 84,250 | 80,100 | 15,000 |
| V-02 | KB 7710 LM | Renault Kangoo | Elena | 61,900 | 47,500 | 15,000 |
| V-03 | KB 1156 AP | Mercedes Sprinter | Dmitri | 132,400 | 118,000 | 20,000 |
| V-04 | KB 9034 ZW | Toyota Hilux | Amina | 28,700 | 20,000 | 15,000 |
| Vehicles | 4 | |||||
| Need attention | 1 | |||||
| Due soon | 1 | |||||
| Total distance on the odometers (km) | 307,250 | |||||
| Total fuel cost | 387.40 |
Fuel
Fuel log
Use the same Vehicle ID as on the Fleet sheet.
| Date | Vehicle ID | Liters | Cost | Odometer (km) | Cost per liter |
|---|---|---|---|---|---|
| 2027-05-03 | V-01 | 58.4 | 96.40 | 83,610 | 1.651 |
| 2027-05-07 | V-02 | 41.2 | 68.00 | 61,240 | 1.650 |
| 2027-05-12 | V-03 | 79.9 | 131.80 | 131,980 | 1.650 |
| 2027-05-19 | V-01 | 55.1 | 91.20 | 84,250 | 1.655 |
