We have a new customer with a few hundred vehicles. But they have 4 delivery vehicles whose miles need to be internally billed to each of their various job sites for accounting purposes. It takes one of their employees about 4 hours each month to get this data out of the current stop detail report we provide.
They asked us if we would build them a custom GPS tracking report to help.
Here’s a depiction of how they assign mileage to job sites:

Delivery workflow & mileage calculation
All mileage from the warehouse or another job site needs to be allocated to the NEXT job site reached, to include miles spent going to non-job sites (such as McDonald’s, above).
The mileage spent heading BACK to the warehouse needs to be assigned to the most recent job site serviced.
Rather than go through a stop/detail report, line by line, for hundreds or thousands of trips for a month, we created this consolidated GPS tracking report, called the “Delivery Vehicle Mileage” report:

New Custom Delivery Mileage GPS Tracking Report
Here is the output with client specific information blurred out:

Easy totals for mileage to job sites
Note the red arrows illustrate mileage TO the job site, and a couple blue arrows show mileage FROM the job site deadheading back to the yard.
Any group of vehicles as well as starting/reset landmarks such as a warehouse and job site landmarks may be chosen and it can be run for 31 days at a time (and we can always increase that restriction if the number of vehicles/landmarks are reasonable and you need quarterly reports instead).
And the best part: Instead of it taking this customer 4 hours a month to tabulate through a mind-numbing stop detail report, they can now run it in about 2 seconds with this report we built for them (and any customers who may require it in the future):

2 seconds to do 4 hours work
As always, we appreciate customer requests, and accommodate them better than any other GPS Tracking provider out there. Keep them coming — when we help our customers, we help the product as well!
Rob.
Tags: billed jobs, custom gps tracking report, custom reports, customer requests, delivery mileage report, delivery vehicle mileage, Fleet Tracking, gps fleet tracking, gps mileage report, GPS Tracking, gps tracking provider, gps tracking report, gps vehicle tracking, mileage report, stop detail report, stop report, tracking mileage, tracking truck mileage, tracking vehicle mileage, vehicle mileage report, vehicle stop report, Vehicle Tracking