Export IFTA Mileage Data

Export IFTA Mileage Data

Use the IFTA export to gather mileage, truck, jurisdiction, and fuel information for your IFTA review. Load Manager provides the export data; your company is still responsible for reviewing the results and filing the official IFTA return.

Before You Export

The IFTA export depends on equipment, load, mileage, and fuel data already being entered correctly.

  • The truck or equipment must be marked IFTA Include? on the equipment profile.
  • The load must have complete stop addresses so miles can be calculated correctly.
  • The load must be in the delivered-to-completed status range used by your company workflow.
  • The load must fall within the delivery date range you select.
  • Fuel gallons and fuel cost appear only when your workflow records IFTA fuel purchase rows on the load.

Open the IFTA Export

0Demo Equipment list with sample equipment rows redacted

Screen cue: IFTA mileage depends on clean driver, truck, trailer, equipment, and load-mileage data.

  1. Go to the Drivers or Equipment area, depending on your company setup.
  2. Select IFTA from the submenu.
  3. Review the Delivery Date From and Delivery Date To fields.
  4. Set the dates for the quarter or custom period you want to review.
  5. Click Export ALL.

Load Manager downloads a CSV file that can be opened in Excel or another spreadsheet tool.

What the Export Includes

0Demo Export report screen with sample customer data redacted

Screen cue: export screens use filters before downloading a CSV or spreadsheet file.

The CSV export can include columns such as:

  • Truck or equipment name.
  • State or jurisdiction.
  • Toll miles.
  • Non-toll miles.
  • Total miles.
  • Empty miles.
  • Loaded miles.
  • Fuel gallons.
  • Fuel cost.

Why Data May Be Missing

  • No loads export: Confirm the loads are in the expected status range and delivery date range.
  • A truck is missing: Open the equipment profile and confirm IFTA Include? is selected.
  • Miles are missing or incorrect: Review the load stop addresses and mileage calculation.
  • Fuel gallons or fuel cost are blank: Confirm fuel purchase rows are entered using your company's IFTA fuel workflow.
  • The quarter looks wrong: Check the delivery date range before exporting. The screen may default to a prior quarter based on the current date.

Best Practices

  • Review the CSV before using it for filing.
  • Compare the exported truck list against your IFTA equipment list.
  • Correct missing stop addresses or mileage issues before running the final export.
  • Save a copy of each quarterly export for your records.

Related Articles