Skip to main content
What can we help you with?
< All Topics
Print

Mileage, fuel and route efficiency

Posted
Updated
ByThe Wax Stak Team

By the end of this article you will know where the miles on this report come from, why a fuel figure can be missing or partial, and how to find the route that burned the most.

Reports › Operations › Mileage & Fuel is a Business feature. Every figure is built from the routes your technicians ran: the distance planned when a route was optimized, and the distance actually driven where a technician recorded odometer readings.

Read the report

  1. Under Filters, set From, To and Group by. The report opens on the current month; a range can be up to a year long.
  2. The summary cards show Actual miles, Planned miles, Gallons and Estimated fuel cost, each with the number of routes behind it. A note under the cost says whether it is based on odometer readings or on planned distance, and which fuel price it used.
  3. Mileage trend charts miles per day, week or month.
  4. By Fleet Vehicle and By Technician break the same figures down: Routes, Planned mi, Actual mi, Efficiency, Gallons, Est. fuel cost and, once you have set a per-mile rate, Reimbursable. A vehicle row also shows its MPG and fuel type.
  5. By route lists every route in the period with its Date, Technician, Vehicle, planned and actual miles and its efficiency score, worst first. Click a row and Route map draws it.
  6. Export mileage log downloads the period as a CSV — one line per route with its date, technician, vehicle and plate, purpose, start and end locations, planned and actual miles and the fuel and reimbursement figures — the record a mileage deduction needs.

What the numbers mean

  • Efficiency is planned miles divided by actual miles, as a percentage: 100% means the route was driven exactly as optimized, less means it took more road than planned. Only a route with both a planned and a recorded distance can be scored; the tooltip says how many of a row’s routes contributed. A route with no score says why — Not optimized, Not driven yet or No planned distance.
  • Fuel cost is an estimate, not a record of purchases: distance divided by the vehicle’s MPG, priced per gallon. The price comes from the regional average, from the price you set, or from a platform default, and the note under the cards names which. Fuel type decides the price line — gasoline and diesel are priced separately.
  • A fuel figure can be missing. A route with no vehicle assigned, a removed vehicle, a vehicle with no MPG on file, an electric vehicle or no recorded distance cannot be priced. A row that mixes priced and unpriced routes is marked Partial, and the notice under the cards totals the miles left out.

Good to know

  • Set the fuel price and per-mile rate under Settings › Company › Service Area, in the Mileage & fuel card. The rate is what the tax report’s mileage deduction and the Reimbursable column are worked out from; the fuel price feeds the cost estimate.
  • Vehicles and MPG come from Catalog › Vehicles, the Fleet Vehicles page. A route without a fleet vehicle shows No vehicle assigned.
  • Business only. On Starter or Pro the page shows Unlock Business reporting with Upgrade to Business. Any role that can view reports can open it.

Related

Table of Contents