MyGeotab : How to create a GPS-based IFTA Report?

1. Download the Standard or Advanced Fuel Tax Report for the time frame needed and the desired vehicles
2. Open the report and un-hide the Data sheet
3. In the Data sheet, scroll to the last row of the affected vehicle
4. In that row, updateFuelTaxExitOdometer(Column O) to the correct value
5. ChangeFuelTaxEnterOdometer(column M)to a formula taking the corresponding FuelTaxExitOdometer (Column O) minus the corresponding FuelTaxGpsDistance (Column Q)

• Example of formula:

6. Copy the formula to the rest of the vehicle's FuelTaxEnterOdometer (column M)by selecting the cell:

• Click and hold the bottom right corner of the cell
• Dragup to the first row of the affected vehicle's data (if the report contains multiple vehicles, we only want to apply the formula to the affected vehicle).

7. Click on the second to last cell of FuelTaxExitOdometer (column O) of the affected vehicle, change the value to a formula equal to the last FuelTaxEnterOdometer (Column M) value of the affected vehicle.

Example:8. Copy the formula to the preceding cells of the vehicle's FuelTaxExitOdometer (column O),

• Select the cell and click and hold the bottom right corner of the cell
• Dragup to the first row of the affected vehicle's data (if the report contains multiple vehicles, we only want to apply the formula to the affected vehicle).

9. Navigate to the Report sheet
10. Find the first row of the affected vehicle and change the formula of Distance (Column J) cell to equal to the corresponding FuelTaxGpsDistance (Column Q) from the Data sheet.

Example:10. Copy the formula to the rest of the vehicle's Distance column.

• Select the cell and click and hold the bottom right corner of the cell
• Dragdown to the last row of the affected vehicle's data (if the report contains multiple vehicles, we only want to apply the formula to the affected vehicle).

11. Save the newly edited report.