How To Create A GPS-Based IFTA Report 

Related Questions 

  • Incorrect IFTA Mileages When Odometer Values Do Not Update
  • Mileage is showing 0 or negative values (no odometer data)
  • Time for IFTA reports but odometer readings are not reliable
  • Why is the mileage listed in the IFTA report lower than the mileage indicated on the trips history report? Where did those miles go?

Symptoms

  • Enter/Exit Values do not change
  • Odometer measurements do not change
  • Mileage on IFTA is 0 for portions

Applies To

  • MyGeotab
  • IFTA
  • Report

Cause

When engine based odometer doesn't update, the IFTA report cannot calculate mileages correctly.

Resolution

  1. Download the "Advanced Fuel Tax Report" for the time frame needed 
  2. Open the report and un-hide the 'Data' Tab
  3. In the Data tab, scroll to the last entry
  4. Select the last "FuelTaxEnterOdometer" cell (Column M) and change the value to a formula taking the same row corresponding "FuelTaxExitOdometer"(Column O) minus the same row corresponding "FuelTaxGpsDistance"(Column Q)
  5. Copy the formula to the entire "FuelTaxEnterOdometer" column by selecting the cell > Click and hold the bottom right corner of the cell > Dragging up to the top of the column with data.
  6. Select the second from the bottom "FuelTaxExitOdometer"(Column O) and change the value to a formula equal to the last"FuelTaxEnterOdometer" cell (Column M) value
  7. Copy the formula to the Preceding "FuelTaxExitOdometer" column cells,by selecting the cell > Click and hold the bottom right corner of the cell > Dragging up to the top of the column with data.
  8. Navigate to the report sheet > "Distance" column(Column H)
  9. Change the formula for the first "Distance" value to a formula equal to the corresponding "FuelTaxGpsDistance" from the Data Tab.
  10. Copy the formula to the entire "Distance" column.
  11. Save the newly edited report. 

Additional Notes

  • The resolution in this article only acts as a one-time fix. For more information about how the Geotab Fuel Tax solution works see the Geotab IFTA/IRP Compliance Manual GUIDE V1.0.
  • This procedure assumes the last known exit odometer of each vehicle is correct and up-to-date. If not, please update them accordingly in column O of the Data sheet of the IFTA report. 
  • See attachments for a GPS based IFTA report template.