Failed upload of IFTA Fuel Purchases CSV file

Whenever a Fleet Admin uploads fuel purchase records for IFTA using an incorrectly formatted CSV file, the import will fail. 

Below is a list of common formatting errors in CSV files. Review this list to ensure your CSV file does not contain any of these mistakes. Once all errors are resolved, the file should upload successfully.

Note: The IFTA tab in the Fleet Dashboard is visible only to U.S.-based fleets and to Canadian or Mexican fleets that operate in the U.S.

Common CSV Formatting Errors

1. CSV Headers Mismatch: Headers do not match the Motive Fuel CSV Template.
2. Incorrect Date/Time Format: The "Purchased at" field is not in ISO 8601 date format.
3. Missing or Incorrect Vehicle ID: Vehicle ID is missing or does not correspond to any vehicle in the company.
4. Missing or Incorrect Driver Information: Driver email/username is missing or does not match any driver in the company.
5. Invalid Jurisdiction: The jurisdiction entry is incorrect.
6. Fuel Volume Entry Errors:
   1. Both or neither Volume (ltr) and Volume (gal) columns are filled. Only one should be filled per entry.
7. Cost Entry Errors:
   1. Both the Cost (USD) and Cost (CAD) columns are filled. Only one should be filled per entry.
8. Odometer Entry Errors:
   1. Both the Odometer (mi) and Odometer (km) columns are filled. Either one should be filled, or both should be left empty.
9. Invalid Values:
   1. Entries for Volume, Currency, or Odometer are less than or equal to 0 or contain non-numeric values.

Make the necessary corrections, and your file should upload successfully.

 

Share this with others