On this page we want to introduce you to the Geotab ELD system and how we have integrated it into My Fuel Tax GPS.
Geotab provides a full fleet management system which includes a State Mileage Reporting feature. The mileage reports can easily be imported into My Fuel Tax GPS.
Key benefits include:
- One step import of Miles in State. No need to enter miles manually.
How to use our Geotab ELD interface
The Import for Geotab is done using the Data Wizard button.
When you click it, the data wizard comes up:
The Data Wizard Dialog consists of the following:
The “Select a Fleet” Dropdown box – This will show the company name once the UserProfile has been initially set up. If there are more than one company to run IFTA reports for, and multiple UserProfiles have been set up, the dropdown box will list multiple companies.
The Reporting Period – You have to choose a quarter to import data for.
The “Units Reporting for IFTA/IRP taxes” Data Grid – When you import trip data from Geotab, My Fuel Tax will only collect data for the units both listed in this box and that also match the units in Geotab’s State Mileage Report. The “Done” column on the left gets an X mark if you want to exclude that unit from data collection. Clicking “Done” in the upper left hand corner toggles between selecting all or deselecting all units.
The Units Not Found Data Grid – When you import data from Geotab, My fuel Tax will list any unit found in Geotab that is not found in the selected fleet. If you want to add one or more of these vehicles you can simply drag a vehicle not found and drop it in the Reporting Grid discussed above. The vehicle should be dragged to the button labeled “Add New Vehicle”.
Manual Data Entry – This button will open the manual Trip Entry dialog where you can enter fuel gallons purchased by vehicle and by state. Once we receive .txt or .csv formatted fuel reports from fuel card companies we will adapt My Fuel Tax to import fuel gallons and eliminate this manual entry also.
You click on the “Import Miles in State Data” button, and you find your Multi State Mileage Report for the quarter you specified in the “Choose a Quarter” box.
You click “Open” when you selected the file you need, and the import is executed. When it’s done you get this message box:
After you click “OK”, please note the there is an “X” mark next to the units in the list on the left. this means that import for this unit was already done.
Now we click on “Manual Data Entry” to check the results:
- As mentioned above, you still have to enter or import your fuel for all trucks before you can run the IFTA Report.
That’s all there is to it. You can close this dialog, close the wizard, and click on IFTA Report to run the IFTA report, save it, and then Print it to the Form for your jurisdiction.
Pricing for My Fuel Tax GPS starts as low as $100 set up fee and $100 per year thereafter. Feel free to contact us for additional pricing information. 603-206-9977 or send us an E-mail at [email protected]. Click Here if you want to read more about Geotab.