GoFleet
            Knowledge Base Go Fleet support Geotab MyGeotab Reports

            How to Generate IFTA report based on GPS data?


            Ticket:N/A
            Client:N/A
            Agent: Anjali


            If a Geotab unit is removed from the database without making it historical, system will no longer be able to generate the historical IFTA report based on raw odometer values.
            In cases like this,it can created based on GPS data.



            Here are the steps to creating a GPS based IFTA report.


            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 J)
            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.


            Please feel free to contact support if you have further questions regarding this.

            Updated: 15 Aug 2019 05:40 AM
            Helpful?  
            Help us to make this article better
            0 0