Export IFTA Mileage Data

Export IFTA Mileage Data

[Audience: Carrier or Trucking Company TMS - Admin Users, Accounting Users, and Operations Users]

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

  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

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

    • Related Articles

    • How to Export Load Data to Excel

      Load Manager can export your data to Microsoft Excel. Use this feature to analyze sales performance, review load history, or prepare data for external reporting. How to Access Go to the Reports tab in the main menu. Click Export in the submenu. ...

    • Is Your Load Manager Data Safe and Secure?

      Is Your Load Manager Data Safe and Secure? [Audience: All TMS Types] Load Manager is designed to protect your company data while keeping your team connected to the loads, customers, carriers, drivers, documents, and accounting information they need ...

    • QuickBooks Integration for TMS

      What is QuickBooks Integration with your TMS? QuickBooks integration for Load Manager TMS is designed to streamline financial and accounting work for transportation and logistics businesses. Load Manager TMS helps manage freight operations, including ...

    • Load Manager Integration QuickBooks Online

      Load Manager integrates with QuickBooks Desktop and QuickBooks Online. This Article will cover: How to Link QuickBooks with Load Manager How to Export Bills and Invoices to QuickBooks How to Undo the history of an Export to QuickBooks from Load ...

    • Understanding the All Loads Screen

      Understanding the All Loads Screen [Audience: All TMS Types] The All Loads screen gives you a company-wide view of loads in Load Manager. Use it when you need to find a load, review team activity, check load status, or open a load record that may not ...