Fuel Tax Report

To generate the Fuel Tax Report, go to Finance → Reports and click the Fuel Tax Report option under the Operational Reports section. This report generates an IFTA Fuel Tax compliant csv. 

Mileage can either be uploaded using a csv or come from Samsara via the electronic capture of mileage. If using Samsara, it must be enabled and have mileage information available. Only US Jurisdictions/states are supported as well.

Use either a csv or an import file from your 3rd party fuel card vendor with fuel purchase data to generate the report.

In order for fuel information to be generated on the report, trucks must have their IFTA Eligible field set to true. This field can be found in the Profile section of the truck details. If IFTA is not enabled for every truck on the fuel purchases csv, the report will fail to generate and an error email will be sent with information on which truck is invalid. Trucks with unit numbers that do not correspond to any trucks or trucks outside of the broker scope will also cause the report to fail.

Trucks must also have a fuel type set in the Specs section of the truck details under Fuel Tank Configurations. Only trucks with Special Diesel set as their fuel type will generate data on the report.

In the Fuel Tax Report filters, select the IFTA Eligible trucks to generate data for, or leave it blank to generate it for all trucks in the import, provided they meet the requirements listed above. Enter in the time frame which pulls tax data from the IFTA. If the IFTA has not published tax information for the provided time period, the report will not be generated.

Select the Mileage Data Source. If Upload is selected, then the Mileage Data section will be available where the mileage csv can be uploaded. A mileage template is available for download by clicking the Download Template button in the Mileage Data section.

If Samsara is selected, the Mileage Data section will be hidden and mileage data will be used from Samsara instead.

For fuel purchases, upload either a csv using the EKA format, or upload a .dat file from your 3rd party fuel card vendor. To download a csv template for the EKA format, click the Download Template button in the Fuel Purchases section.

Once the file has been uploaded, select the delivery location of the report and click Submit. A window will open where you select the import format.

Select the format that matches the fuel purchases file uploaded and click Submit. The report will be generated and sent to your email and/or mailbox.