Geotab IFTA/IRP: Conformidade e implementação
Um manual abrangente para revendedores e clientes implementarem com sucesso o Acordo Internacional de Imposto sobre Combustível (IFTA). Saiba mais sobre os métodos possíveis para obter os dados IFTA necessários e acesse instruções detalhadas para a execução de relatórios IFTA.

Implementation Guide

23 mins to read

Neste documento

Document overview

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.

Understanding the International Fuel Tax Agreement

IFTA basics

  1. IFTA requires carriers to maintain a uniform record-keeping system of motor fuel consumption and the distance travelled in each jurisdiction while operating in member jurisdictions [1].
  2. An agreement between the 48 contiguous United States and Canadian provinces — excluding Alaska, Hawaii, District of Columbia, Northwest Territories, Nunavut & Yukon Territory [1].
  3. Uniform administration of motor fuel taxation law with respect to qualified interjurisdictional motor vehicles [1].

document Image

Watch the IFTA basics video (Video)

document Image

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.

IFTA core principles

Base Jurisdiction:

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

  1. Gross vehicle or registered gross vehicle weight over 26,000 lbs or 11,797 kg.
  2. Three or more axles regardless of weight.
  3. Used in combination when weight of combination exceeds 26,000 lbs or 11,797 kg.

What is a qualified motor vehicle?

  1. A motor vehicle used, designed, or maintained for the transportation of persons or property; and
  2. Gross vehicle weight or registered gross vehicle weight over 26,000 lbs or 11,797 kgs
  3. Three axles regardless of weight
  4. Used in combination when weight of combination exceeds 26,000 lbs or 11,797 kgs
  5. Audit timing and quantity

  6. The base jurisdiction will conduct audits for itself and all member jurisdictions
  7. Jurisdictions must complete audits on an average of 3% of its licensees each year. Of the 3%:
    1. 25% of audits must involve high-distance accounts
    2. 15% of audits must involve low-distance accounts

IFTA reporting process

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.

Overview

  1. Carrier submits an IFTA license application in the base jurisdiction.
  2. Base jurisdiction reviews and processes the license application.
  3. Carrier receives an IFTA license and two decals for each qualified vehicle. A copy of the license must be placed in the vehicle during operation.
  4. At the end of each quarter, the licensed carrier files a quarterly IFTA tax return to the base jurisdiction for fuel used and remit any amounts due.
  5. Review and processing of the IFTA tax return by the base jurisdiction.
  6. A transmittal report is sent by the base jurisdiction to the other jurisdictions in which the vehicle operated.
  7. Base jurisdiction processes all transmittal reports and payments from other states.
  8. Business pays base jurisdiction what is owed; base jurisdiction pays other jurisdictions what they owe and collects from other jurisdictions what is owed to them.

IFTA fuel tax reporting and due dates

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

April 30

2nd Quarter — April to June

July 31

3rd Quarter — July to September

October 31

4th Quarter — October to December

January 31

*If the due date falls on a weekend or a holiday, the due date is extended to the following business day.

What is the difference between IFTA and IRP?

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:

  1. Two axles and a gross vehicle weight (GVW) or registered GVW over 26,000 pounds or 11,793.401 kg
  2. Three or more axles (regardless of weight)
  3. Used in a combination with a combined GVW over 26,000 pounds or 11,79.401 kg (also known as apportioned vehicles).

IFTA updates

Compliance mandate changes

[2] 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.

  1. P600 Electronic requirements were removed entirely
    1. Replaced by P540 which has basic requirements around trips
  2. The goal has been to foster IFTA alignment with IRP

The IFTA Articles of Agreement document provides the full detail for requirements of IFTA.

IFTA compliance and telematics

What does my telematics system need to do?

The Electronic Data Recording Systems Summary document outlines the specific requirements for your telematics solution as set forth by IFTA Inc.

For a detailed look at these requirements, refer to the current 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:

  1. Can my ELD system run detailed trip reports?
    1. The ELD mandate requires 1 GPS log per hour. Detailed and highly-accurate IFTA reporting will require more frequent GPS logging, especially for short haul.
  2. Do the trip reports identify the origin and destination of travel?
  3. Are routes of travel identified in the report?
  4. Will the report calculate total trip distance along with the distance within each jurisdiction?
  5. Does the telematics solution backup your data for the next four years in case of an audit?
  6. Will the ELD system notify you if the device fails?
    1. You must failover to manual records if your telematics solution fails.

Data retention

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:

  1. IFTA Retention (See section *P510 RETENTION AND AVAILABILITY OF RECORDS)
  2. IRP Retention
  3. Geotab Data Retention Policy

MyGeotab IFTA report

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:

  1. The beginning and the end of each jurisdiction trip; that is, the date and time when the vehicle entered and exited a jurisdiction.
  2. The odometer values at the points of entry and exit.
  3. The latitude and longitude of the point of exit.
  4. The amount and type of fuel purchased on each jurisdiction trip.
  5. The jurisdiction trip distance based on odometer data, prorated by fuel type.
  6. The trip distance based on GPS data, prorated by fuel type, for helping detect odometer malfunction.
  7. The amount of fuel used on each jurisdiction trip, by fuel type.
  8. The net taxable fuel for each jurisdiction trip, by fuel type.

GPS data precision

  1. Logged GPS coordinates are validated by an internal algorithm
  2. If invalid, checked against engine-based road speed
  3. Each bit of latitude and longitude has a precision of 0.0000256 of a degree (approximately 2.5–3 metres)
  • document Image

  • See the firmware release notes for more information about GPS logging and precision.

  • document Image

  • 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

  • Odometer data

    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.

    Fuel data

    Fuel card data is integrated 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.

    document Image

    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.

    Report calculation

    As of the December 2016 release, MyGeotab had a complete revision of the IFTA calculation code, aiming at:

  • Increased performance. With prior versions of the application, it could take 24+ hours to complete a quarterly report for a large fleet. Many report executions would crash in the process. Even when they did not, the users halted them and reported them as failed.
  • Fixing discrepancies in state entry and exit odometer readings.
  • Detecting passive (ferry, tow) trips so that they are not counted for fuel tax.
  • Adding fuel usage data from fuel transactions.
  • The new IFTA calculation 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.

    The IFTA calculation starts by creating a fuel tax set object. The fuel tax set includes:

  • A minimal sequence of active intervals covering the report period.
  • All GO device Code 5 (Generic Odometer) diagnostic records both inside and in-between the active intervals, with an extra odometer record both before and after the active periods. In absence of Code 5 records, Code 248 (Odometer Adjustment) records are considered.
  • All the GPS records inside the active periods.
  • Odometer discrepancies

  • Odometer discrepancies may begin to appear if tires are non-standard, worn or underinflated.
  • It is common for odometers to be off by ±5%. Odometer errors are typically proportional to speedometer errors.
  • Speedometers can have built-in tolerances up to ±10%, with many manufacturers deliberately calibrating speedometers to read high to account for eventual discrepancies and protect liability for speeding issues.
  • Sources of error due to tire diameter variations include: wear, temperature, pressure, vehicle load, and nominal tire size.
  • document Image Learn more about Vehicle odometers through our blog.

    GPS discrepancies

    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:

    1. Signal arrival time measurements: Delays caused by physical obstructions like mountains, buildings, trees, and more.
    2. Atmospheric effects: Examples include ionospheric delays, heavy storm cover, and solar storms.
    3. Ephemeris: The orbital model within a satellite could be incorrect or out of date, although this is becoming less of an error.
    4. Artificial interference: The best example includes GPS jamming devices or spoofs.

    Learn more about GPS data from our GPS In The Spotlight Blog.

    Odometer vs. GPS discrepancies

    The MyGeotab IFTA report uses two distinct data streams to calculate the distances travelled for each jurisdiction trip:

    1. Distance, based primarily on odometer records.
    2. GPS Distance, based solely on GPS records.

    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.

    Under-the-hood changes

    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.

    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.

    MyGeotab Fuel Tax Program

    Ongoing reviews with MyGeotab reporting

    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.

    Daily Review

    document Image

    Watchdog report

    Available by default in MyGeotab.

    Weekly Review


    Fuel Tax Distance Records Report

    Custom report to aid 2024 IFTA/IRP Audit Compliance. This report captures and maintains essential data as per the fuel tax distance records requirements including timestamps, GPS positions, odometer readings, and vehicle identification. You can find the report on the Geotab Marketplace.


    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.

    Monthly Review

    odometer-jump-report-marketplace-solution-icon.png

    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.

    Default fuel tax report

    1. Basic IFTA report which displays distances traveled per jurisdiction

    Advanced fuel tax report

    1. Advanced IFTA report which displays distances traveled with fuel transaction data

    Setting up your MyGeotab IFTA program

    Refer to this Quick Guide for setting up your IFTA program.

    For instructions on how to import fuel card data, see this article.

    MyGeotab IFTA reporting integration

    SDK calls to retrieve IFTA data

    The Geotab IFTA report and its associated data is in place to assist customers complete their IFTA filing. The built-in IFTA reports are based on the FuelTaxDetail object. Refer to this .NET code sample to view how to pull FuelTaxDetail objects: GetFuelTaxDetails

    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.

    Code samples are available in Javascript and .NET to help developers get started. Some noteworthy examples are:

    1. displayOdometer.html (Javascript)
      1. Shows how to display a vehicle's odometer readings over time.
    2. ExtractMileage (.NET)
      1. An example that extracts vehicle mileage into a CSV or XML file. A good starting point for any data extraction tool. The required parameters for this example are: server, database, username, password, output file name.
    3. GetLogs (.NET)
      1. A GUI example that obtains the logs for a given vehicle between a range of dates. Required parameters: server, database, username, password.

    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:

    1. LogRecord
      1. Records of log entries containing data for a device's position and speed at a specific date and time.
    2. StatusData
      1. Records that represent information from the engine system of the specific device. For IFTA purposes, the odometer records are of particular interest. See the displayOdometer.html Javascript example to better understand how to retrieve odometer records.

    Examples of using the data feed are included in the following code samples:

    1. dataFeed.html (Javascript)
      1. How to use the GetFeed method and retrieve a continuous stream of GPS, Engine Status, and Fault data. This is the recommended method for getting a copy of this data.
    2. DataFeed (.NET)
      1. An example of retrieving GPS, Status, and Fault data as a feed and exporting the feed to a CSV file. Required parameters for this example are: server, database, username, password, last known GPS data/status data/fault data/trip/exception id, save folder, continuous.

    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.

    Geotab Marketplace & IFTA

    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.



    How to handle an audit

    IFTA reporting requirements

    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:

    1. IFTA Trips by Jurisdiction (pictured below): https://my.geotab.com/<database>/#iftaMiles
    2. MyGeotab Trips: https://my.geotab.com/<database>/#tripsHistory ifta by vehicle.png

    The following two links are used for Audit backup of the IFTA-reported mileage as needed.

    Trips report

    (Navigate to Map > Trips History)

    trips report.png

    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.

    Log Details report.png

    .200 Summary Reports for Individual Vehicles

    Monthly, quarterly, and annual summaries of vehicle trips by vehicle number showing miles or kilometers by jurisdiction.

    IFTA report

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

    ifta summary by vehicle.png

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

    ifta summary by fleet.png

    *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

    Geotab Solution

    .005

    Date of Trip (starting and ending)

    IFTA Report and Trips reports

    .010

    Trip origin and destination (location code is acceptable)

    Trips report

    .015

    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.

    .020

    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.

    .025

    Total trip distance

    Advanced Trip report

    .030

    Distance by jurisdiction

    IFTA report

    .035

    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.

    .040

    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.

    .045

    Registrant's name

    Included in the database name.

    .200 Optional Trip Data

    (may be included at the discretion of the base jurisdiction)

    Geotab Solution

    .005

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

    .010

    Intermediate trip stops;

    Advanced Trip Report

    IFTA reporting by authority

    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.

    Here are two example templates: Default IFTA Report with Authority and Advanced IFTA Report with Authority.

    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.

    document Image

    Appendix

    Changelog of MyGeotab updates

    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:

    Improvement

    Release Version

    Other Versions

    IFTA2017

    1. Complete revision of the IFTA calculation code
    2. Relies more heavily on engine odometer readings rather than GPS distance
    3. Increased performance (reports now take less time to compile)
    4. Fixes discrepancies in state entry and exit odometer readings
    5. Detects passive (ferry, tow) trips so they are not counted for fuel tax
    6. Added fuel usage data

    5.7.1612.276

    Account for open-ended trips

    1. Resolves issue where the FuelTax report starts with 0 odometer for certain time intervals
    2. Resolves issue where the FuelTax report does not include any trip in progress

    5.7.1702.241

    5.7.1701.320+

    Account for IFTA Jurisdiction

    1. Summary sheet in the FuelTax report now only shows states participating in the IFTA

    5.7.1702.241

    5.7.1701.316+

    Some reports fail for vehicles for certain timeframes

    1. Resolves issues where some active intervals were being accounted in the IFTA calculation
    2. Resolves regression where vehicles with no activity records and no odometer records cause the report to crash

    5.7.1703.220

    5.7.1701.344+

    5.7.1702.264+

    Account for small differences in successive odometer readings

    1. Resolves issue where negative values are reported

    5.7.1703.220

    5.7.1702.287+

    Account for active ferry trips

    1. Resolves issue where report fails for ferry trips with ignition ON
    2. Resolves issue where report fails for trips outside of North America (ie, states and provinces participating in IFTA)

    5.7.1703.220

    5.7.1702.279+

    Account for current open-ended trips

    1. Resolves issue where current active interval cause wrong odometer calculation

    5.7.1704.273

    Add FuelTaxGpsDistance column to data sheet in IFTA report

    1. Improves usability and troubleshooting

    5.7.1704.273

    Add Trip Identification By Authority To FuelTax Report

    1. Allows users to identify whether they are operating as lessor or lessee

    5.7.1704.273

    5.7.1702.329+

    5.7.1703.244+

    Ability to include or not fuel usage calculation in FuelTax report

    1. Unless the fuel usage-related column is present in the report, fuel usage data will not be calculated

    5.7.1704.273

    5.7.1703.270+

    Implemented Crawling Data for IFTA reports

    1. Faster IFTA report Generation
    2. Fuel tax details are continually created and updated, based on stored GPS data, status data, and duty status logs, by the fuel tax crawler, a dedicated database service

    5.7.1707.302

    Custom IFTA reporting fields

    Hidden fields

    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:

    1. FuelTaxCountry
    2. FuelTaxVin
    3. FuelTaxLicensePlate
    4. FuelTaxLatitude
    5. FuelTaxLongitude

    Insertable fields

    In addition to the fields already included in the template reports, you can add the following additional columns to see more information:

    1. DeviceSerialNumber
    2. DeviceLicensePlate
    3. DeviceLicenseState
    4. DeviceActiveFrom

    References

    [1] “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].

    [2] “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].

    scroll-up