If IFTA reporting is enabled and recipients are selected for the quarterly IFTA Tax Report, the report will be delivered as an XLS file to the specified email addresses.
The report contains two tabs.
Sheet 1
Total distance travelled: total distance driven by IFTA-enabled vehicles in the fleet over the specified reporting period.
Total Fuel consumed: total taxable fuel summed over each state (Column I in sheet2)
Average fuel consumed: Total fuel consumed/Number of assets
Average fuel consumption factor: Total distance travelled/Total fuel consumed
Sheet 2
Tax rate/state: table from IFTA website (www.iftach.org/taxmatrix/charts/1Q2025.xml), fixed per quarter.
USD to CAD exchange rate: from IFTA website (www.iftach.org/taxmatrix/charts/1Q2025.xml), fixed per quarter.
Total Miles: total mileage driven in the specific state summed across all IFTA-enabled vehicles in the fleet over the specified reporting period
Total taxable Miles: same as total miles (in the future might exclude miles driven on dirt roads)
Total taxable Gallons: calculated from total taxable miles/Ave. fuel consumption factor (sheet 1)
Tax paid Gallons: gallons purchased in the state, which comes from fuel card purchases
Net taxable Gallons: Total taxable Gallons - Total paid Gallons
Tax Due: Net taxable Gallons* Tax Rate
Surcharges (Sheet 2):
Some states require additional fuel taxes that are not paid at the pump.
This results in an additional row for each fuel entry under the state.
Note that the surcharge row does not impact the sub-totals for the state for the mileages and fuel columns, but is included in the sub-totals for the last 6 columns.