0 mins to read•
Geotab IFTA/IRP - Compliance and Implementation
0 mins to read•
A comprehensive manual for Resellers and Customers to successfully implement the International Fuel Tax Agreement (IFTA). Learn more about the possible methods for obtaining the required IFTA data, and access detailed instructions for running IFTA reports.
The purpose of this document is to provide resellers and customers a comprehensive manual for successfully using the Geotab platform for International Fuel Tax Agreement (IFTA) reporting. Subject matters for review include everything from the definition of IFTA, the possible methods of obtaining the required IFTA data, and detailed instructions for running IFTA reports.
Learn more about the International Fuel Tax Agreement (IFTA) and its importance. This video walks you through the basics of IFTA and the MyGeotab IFTA report.
What is IFTA? Blog Post: Read an overview of IFTA, the reporting and auditing process, and how telematics can help.
The state/province where vehicles are registered and some travel is accumulated.
Retention of Sovereign Authority:
To determine tax rates, exemptions and exercise other substantive tax authority.
Uniform Definition of Qualified Motor Vehicles:
Motor vehicle used, designed or maintained for the transportation of persons or property and
The goal of the International Fuel Tax Agreement, as set out in the IFTA Articles of Agreement, is to harmonize the administration of taxation of motor fuel usage among member states and provinces. The core documents of IFTA include the Articles of Agreement, the Procedures Manual, and the Audit Manual.
Carriers submit a quarterly tax return to their base jurisdiction for the fuel used and distance traveled in IFTA member jurisdictions for all their qualified vehicles. A report must be filed even if the carrier has not conducted any operations or used taxable fuel for a particular period.
The due dates for filing a tax return and submitting a payment are the last days of April, July, October, and January (or the next business day if any of the due dates fall on a weekend or holiday).
Quarterly Tax Reporting Periods:
IFTA Reporting Periods
Return Due Dates*
1st Quarter — January to March
2nd Quarter — April to June
3rd Quarter — July to September
4th Quarter — October to December
*If the due date falls on a weekend or a holiday, the due date is extended to the following business day.
IRP stands for the International Registration Plan (IRP). While IFTA is an agreement on fuel tax licensing, IRP is an agreement related to vehicle registration for commercial motor vehicle carriers in the U.S., the District of Columbia, and Canadian provinces. Similar to IFTA, carriers register their vehicles with IRP only in their home state or province (base jurisdiction).
IRP registration is required for vehicles that are used or intended to transport people or goods in more than one IRP member jurisdiction and meet the following:
 As of January 2017, changes were made in IFTA regulations to accommodate the use of GPS logs. The new wording is less specific for how systems using GPS data must function. At the same time, language was added requiring consistency.
The IFTA Articles of Agreement document provides the full detail for requirements of IFTA.
For a detailed look at these requirements, refer to the current IFTA Procedures Manual.
For a look at the old IFTA requirements enforced before January 2017, refer to the July 2015 IFTA Procedures Manual.
With the ELD mandate in place, many customers are looking for an ELD that can also provide the needed data for automated IFTA reporting. It’s important that they ensure the ELD complies with IFTA requirements. Read Geotab’s blog on IFTA reporting and the ELD mandate for an overview of this subject. Specifically, some good questions to ask about the ELD are:
IFTA and IRP require relatively long retention periods. IFTA requires 4 years from return due date/filing date plus time for waivers/assessments, and IRP requires 3 years plus the current year.
Data retention is the responsibility of the IFTA/IRP registrant. The customer should save their filing documentation external to Geotab in accordance with their other records retention practices.
Note that in the SLA, Geotab may only keep data for 365 days. Thus, it is recommended that the customer should take database backups quarterly — or monthly, depending upon the size of the database.
Using quarterly or monthly database backups will ensure that all the relevant data points can be restored at any point should the original data be purged or removed.
For more information about IFTA/IRP data retention, see the following documents:
Geotab customers have the option to purge their data at a user-specified interval.
The Purge setting can be accessed by navigating to Administration > System… > System Settings and then clicking the Purge tab.
The MyGeotab IFTA report uses a combination of vehicle odometer readings and highly-accurate GPS coordinates to calculate the distance travelled by a vehicle.
MyGeotab enables the users to create IFTA reports based on fuel transactions and the miles driven by each vehicle within individual U.S. states and Canadian provinces (hereafter jurisdictions), as required by IFTA.
For each vehicle, the Geotab IFTA report will show, in chronological order:
See the firmware release notes for more information about GPS logging and precision.
Read our blog on How the Curve Algorithm for GPS Logging Works
Also, watch our video on Geotab's Curved Algorithm for GPS Logging: https://youtu.be/2vxsyJLygws
One of the most critical pieces of information for fleet managers is the vehicle odometer because it represents both a history for the vehicle, as well as milestones for scheduled maintenance.
As your vehicle is driven, your GO device will automatically record the vehicle’s location while intelligently dividing its driving into individual trips. Later on, when you run reports, you will be able to quickly determine where vehicles started and ended their trips and map out the path between them to show which places the vehicles visited.
See the firmware release notes for a list of vehicle support for odometer data.
The December 2016 release of MyGeotab integrated fuel card data into the Advanced IFTA report template. IFTA still requires the original fuel transaction receipts to be available even if the fuel data was imported into the report, for verification.
Fuel usage calculations are based on fuel card data automatically or manually imported into MyGeotab. The five current methods of importing this data are through the Fuel Transaction Import Add-in, Fuel Transaction Provider Add-in, Fuel Tracker App (Android) , Fuel Tracker Add-in and Fuel BI (paid).
Each Fuel Import record is placed, according to the transaction date and time, on a jurisdiction trip. The total amount of fuel transactions during a jurisdiction trip is reported as the fuel purchased.
Purchases of multiple fuel types are listed separately, with one row per fuel type. For example, the report for a dual-fuel vehicle with purchases of both diesel and compressed natural gas (CNG) will contain two rows per jurisdiction trip.
The total amount of fuel purchased during the report period is spread among jurisdiction trips, proportionally to trip distances, and reported as the Fuel Used. For multi-fuel vehicles, the Fuel Used value, as well as the jurisdiction trip distance and the GPS distance, are prorated by fuel type.
IFTA Fuel Economy is calculated as the sum total of fuel purchased over the report period divided by the sum of all jurisdiction trip distances, regardless of fuel type.
Toll road distance
Distances traveled along the New York Thruway and Massachusetts Turnpike are identified in the MyGeotab IFTA report as a field in the hidden Data sheet of the Advanced Fuel Tax Report. You can make use of the data by pulling it into the Report sheet with a formula. You can also add a new column FuelTaxTollRoad to the Data sheet of the Default Fuel Tax Report.
As of the December 2016 release, MyGeotab had a complete revision of the IFTA calculation code, aiming at:
The new IFTA calculation (titled IFTA2017) is based on odometer records, vehicle activity records, and GPS records, whereas the legacy IFTA calculation was based on odometer records, GPS records, and trip records.
IFTA2017 begins its calculation by building a fuel tax set object. The fuel tax set includes:
Learn more about Vehicle odometers through our blog.
High-quality GPS receivers provide better than 2.2 meter horizontal accuracy in 95% of cases, and better than 3 meter accuracy at a 99% confidence level. However, GPS receivers are still subject to issues that may reduce the accuracy of the positional data:
Learn more about GPS data from our GPS In The Spotlight Blog.
The MyGeotab IFTA report uses two distinct data streams to calculate the distances travelled for each jurisdiction trip:
If a vehicle’s odometer increments at a different rate than the GPS distance, customers may notice slight variances between the MyGeotab Trips Report (based solely on GPS distance) and the MyGeotab IFTA report (based on odometer and GPS distance). To help identify these variances, we’ve added FuelTaxGpsDistance to the Data sheet of the IFTA report. By comparing the Distance and GPS Distance values for each jurisdiction trip, users can detect odometer record biases due to variant engine odometer readings.
The IFTA report has undergone extensive changes in how it collects and calculates the data for you. This allows for faster, more consistent data. We have added a system that will do all of the IFTA calculations beforehand and save them to allow the report to pull this information instead of taking a longer time to calculate on-the-fly when requested. More information on these changes can be found in our IFTA 2.0 Guide here.
These reports are intended to help fleet managers report their IFTA and IRP data, better manage their fleet, and use the system to its full capability.
Available by default in MyGeotab.
Telematics device issue detection
Learn more about telematics device issues using this report. You can find the report on the Geotab Marketplace.
IFTA troubleshooting report
Use this report to spot variances between GPS and odometer data, and help review your IFTA data before submission. You can find the report on the Geotab Marketplace. Upload this report to your database as a weekly report.
Odometer jump report
Fleets with heavy-duty trucks should use this report to monitor odometer jumps. You can find the report on the Geotab Marketplace. Upload this report to your database as a monthly report.
For instructions on how to manage your GO devices and how to transfer a GO device between vehicles, see this blog.
For instructions on how to import fuel card data, see this document.
The fuel tax details are continually created and updated, based on stored GPS data, status data, driver changes, and duty status logs, by the crawlers, a group of services deployed on separate virtual machines.
Please see IFTA Guide V2.0 for relevant technical information at the back end.
The Geotab IFTA report and its associated data is in place to assist customers complete their IFTA filing. If customers and/or auditors would like data represented in a different format than is available in the existing reports, the customer or reseller is able to use Geotab’s open API environment to deliver data in any way required.
The MyGeotab SDK allows a user to retrieve the breadcrumb trail data that they can then manipulate as needed in their integration. The API reference page contains detailed information on the methods and objects in the MyGeotab SDK.
The MyGeotab SDK also allows users to set up feeds to receive all the telematics data from their GO devices. The application can be run interactively or in the background as a Windows Service. The results from these feeds can be written to a CSV file, a SQL database, Google BigQuery, or any other storage medium.
The feeds are separated into different streams (called objects in the MyGeotab SDK). For the purposes of IFTA, the two most important objects are:
Examples of using the data feed are included in the following code samples:
The MyGeotab SDK provides a sandbox environment known as the API Runner. It is a tool that can be used to make method calls to a MyGeotab server and see what the results look like. The API Runner has a number of samples built in, including how to get odometer and VIN for vehicles in a group.
The Geotab Marketplace is the ultimate online solutions center for fleet management. From in-vehicle cameras and Bluetooth asset tracking, to apps for managing maintenance and fuel tracking, you can find a wide range of solutions for your business, all integrated with Geotab’s open telematics platform.
Geotab is working to integrate with a number of third-party IFTA compliance providers as we expand. Some of our current partners include Fleet Worthy, DISA Global Solutions, and FuelBI, all of which offer a variety of IFTA/IRP tax reporting services.
Visit the Geotab Marketplace.
The sections below explain the IFTA 2015 P540 Reporting Requirements and the way Geotab addresses each item. IFTA requirements are shown in gray blocks and Geotab comments follow thereafter.
Although this detail has changed as of 2017, the new language is more general. This list may prove to be the preferred standard until more specific language is adopted. This may be particularly true for auditors who have a methodology they are comfortable with based on these requirements.
*P540 REPORTING REQUIREMENTS
The following reports may be prepared by an electronic computer system which accepts data from onboard recording or vehicle tracking devices rather than the recording device itself. The system shall be able to produce the following reports:
.100 Trip Reports
An individual Vehicle Distance Record (IVDR) report for each trip that includes the information required in IFTA Procedures Manual Section P640. (Note: This report may be more than one page).
Trips are available directly in the MyGeotab database. Geotab defines a trip as the distance between two stops, with a stop defined as when the ignition is off or the vehicle is idle for 200 seconds. This condition to specify a MyGeotab trip may be different than the functional understanding of a trip, which might be the travel from a starting point to a final destination, but might exclude some non-relevant stops.
The following two links are examples of trips. Just replace <database> with the name of your MyGeotab database in the links:
IFTA Trips by Jurisdiction (pictured below): https://my.geotab.com/<database>/#iftaMiles
MyGeotab Trips: https://my.geotab.com/<database>/#tripsHistory
The following two links are used for Audit backup of the IFTA-reported mileage as needed.
(Navigate to Map > Trips History)
Log data and collisions report
(Navigate to Activity > Log Data & Collisions)
Raw data for all GPS and odometer values will appear as part of this report.
.200 Summary Reports for Individual Vehicles
Monthly, quarterly, and annual summaries of vehicle trips by vehicle number showing miles or kilometers by jurisdiction.
This is the primary IFTA report which calculates the IFTA mileage. It can be run for any set of vehicles and any date range. As the data is calculated on the fly, it can take some time to run. The SDK does not make available the IFTA calculated distance.
The IFTA Report can be accessed at Activity > IFTA Report (in the Summary sheet, remove all fields except for Vehicle, Jurisdiction and Distance).
.300 Summary Reports for Fleets
Monthly, quarterly, and annual trip summaries by fleet showing the number of miles or kilometers by jurisdictions.
The IFTA Report can be accessed at Activity > IFTA Report (in the Summary sheet, remove all fields except for Jurisdiction and Distance).
*P540 DATA COLLECTION REQUIREMENTS
To obtain the information needed to verify fleet distance and to prepare the "Individual Vehicle Distance Record”, the device must collect the following data on each trip.
.100 Required Trip Data
Date of Trip (starting and ending)
IFTA Report and Trips reports
Trip origin and destination (location code is acceptable)
Routes of travel or latitude/longitude positions used in lieu thereof (may be waived by base jurisdiction). If latitude/longitude positions are used, they must be accompanied by the name of the nearest town, intersection or cross street. If latitude/longitude positions are used, jurisdiction crossing points must be calculated or identified
Raw data is available in the Log Detail report and the trip is most easily seen in the Trip report.
Beginning and ending odometer or hubodometer reading of the trip (may be waived by base jurisdiction)
IFTA Report and Engine Measurements (accessible from Engine & Maintenance > Engine and Device… > Measurements).
Select diagnostic “Raw odometer” for odometer data from the vehicle ECM or “Odometer” for odometer data adjusted by offset and factor.
Total trip distance
Advanced Trip report
Distance by jurisdiction
Power unit number or vehicle identification number
The Advanced Trip report and the IFTA report display the user-entered vehicle unit numbers and the VINs.
Vehicle fleet number
If needed, the vehicles can be placed in groups to separate fleets. The groups can be seen in the Advanced Trip report.
Included in the database name.
.200 Optional Trip Data
(may be included at the discretion of the base jurisdiction)
Driver ID or name;
If drivers are assigned or use identification methods, this detail is available in the Advanced Trip Report (on the Summary tab).
Intermediate trip stops;
Advanced Trip Report
Drivers can specify the authority under which the vehicle was operating for a trip (for household goods carriers). To do so, they can view the column FuelTaxAuthority in the hidden Data sheet of the Advanced IFTA Report.
To identify the authority during a given trip, drivers can use Geotab’s Authority Switcher Add-In with Geotab Drive. Contact Support for help setting up this Add-In.
Geotab constantly strives to improve its products and services. As a result, the IFTA report and related MyGeotab functionality may be updated with new features and improvements. The following table lists all MyGeotab version updates that pertain to the IFTA report:
Account for open-ended trips
Account for IFTA Jurisdiction
Some reports fail for vehicles for certain timeframes
Account for small differences in successive odometer readings
Account for active ferry trips
Account for current open-ended trips
Add FuelTaxGpsDistance column to data sheet in IFTA report
Add Trip Identification By Authority To FuelTax Report
Ability to include or not fuel usage calculation in FuelTax report
Implemented Crawling Data for IFTA reports
The default MyGeotab IFTA reports all include extra information that is pulled into the Data sheet, but is not present in the Report and Summary sheets by default. To make use of this information, create formulas in the Report sheet to pull the data from the Data sheet. The following fields are hidden in the Data sheet:
In addition to the fields already included in the template reports, you can add the following additional columns to see more information:
 “International Fuel Tax Agreement,” Ministry of Finance / Ministère des Finances. [Online]. Available: http://www.fin.gov.on.ca/en/tax/ifta/. [Accessed: January 24th, 2017].
 “IFTA FULL TRACK PRELIMINARY BALLOT PROPOSAL FTPBP #1-2014,” International Fuel Tax Association, Inc. [Online]. Available: https://goo.gl/cDXcnn, 2015 [Accessed: January 25th, 2017].