Export IFTA Mileage Data

Before You Use This Article

• Access needed: Carrier/trucking setup in Load Manager, including driver, equipment, driver settlement, or driver/mobile dispatch access.
• Use this article when: you are a carrier, owner-operator, or trucking company using company drivers, equipment, driver settlement, or driver/mobile dispatch. Full company path: Carriers, Owner-Operators, and Trucking Companies.
• Use a different article when: you dispatch for carrier customers; use Dispatch Report Overview for Dispatch Services. If you broker freight to outside carriers, use Rate Confirmation Layout and Features.

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 start: Applies to carrier, owner-operator, and trucking company accounts.

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

• Why Are My Load Miles Not Calculating Automatically?
• Add Equipment Types for Carriers and Loads
• Export Load Data to Excel or CSV
• Reports Overview: Available Report Tabs