Fill-Ups

Fill-Up Validation

Fill-Ups Graph

Importing Fuel Card Data into Your Database

Using the Import Fuel Transactions Add-In

Using the API directly

EV Charging

How to Pull up the Fuel Usage Report

Fuel and EV Energy Usage

The Fuel and EV Energy Usage report (formerly Fuel Usage report) supports conventional and Electric Vehicles (EVs), allowing fleets to compare both fuel and electric energy economy in one easy-to-read report. 

The Fuel and EV Energy Usage Report provides a summary of fuel and/or electric energy economy, travel distance, and monthly fuel and/or energy usage of selected vehicles. You can access the report by navigating to Sustainability > Fuel and EV Energy Usage. 

The report groups fill-ups by asset, time period, or fuel/electric energy economy. Selecting an item from the list displays the fill-up or fill-ups associated with that item. For example, a report organized by asset will display all fill-ups associated with that asset in the selected date range. 

Selecting Fill-ups from the top menu displays all fill-ups from the chosen date range, while selecting EV Charging shows all charging sessions. From either page, selecting Fuel and EV Energy Usage from the top menu returns the user to the original report.

The report displays fuel usage and fuel economy for conventional vehicles, as well as electric energy used and electric energy economy for electric vehicles. It also displays % Electric Energy of Total, which can be used to evaluate whether a PHEV is running predominantly on gas.

Note: To include EV Charging, the former clearance name View fill-ups and fuel transactions is now View fill-ups, EV charging, and fuel transactions. 

For more information about the Fuel and EV Energy Usage Report, refer to the EV Reporting and Monitoring User Guide.

Fill-Ups

A fill-up event occurs every time fuel is added to the asset. The Fill-Ups Report displays all fill-up events for a selected time period. To view this report, navigate to Sustainability > Fuel and EV Energy Usage and select the Fill-Ups button from the top menu. Select your date range and asset(s) from the Options tab and select Apply changes to view your results.

When sorted by asset or driver, the heading of every asset displays the average fuel economy, the total fuel added for the fill-up event, and the total cost of all fill-ups for the selected time period.

Click the graph button to view the fill-ups graph for the selected time period. Click the location button in each row to view the trip. 

Selecting a row from the fill-ups report will show the details of that particular fill-up event. A matching fuel transaction will also be shown if available.

Fill-Up Validation

Data from the telematics device is used to validate imported fuel transactions. A fill-up row that does not meet the validation criteria displays a yellow warning icon. Hovering the cursor over the icon will display the reason why the system flagged the fill-up.

The Fill-Up details page for a flagged fill-up event will show rows highlighted in yellow when the fuel transaction cannot be validated against telematics data.

Fill-Ups Graph

The Fill-Ups Graph page can be used to validate a fill-up that has been flagged as suspicious. The graph can be accessed by selecting the graph icon at the far left of the Fill-ups page.

The image above illustrates a fuel transaction event where the fuel level of the car (red line) does not increase together with the blue line. Generally, such an instance indicates suspicious activity associated with that particular fill-up.

The blue line is influenced by three factors: the fuel transaction import, the fuel tank level as reported by the vehicle, and the total fuel used as reported by the vehicle. Each dot on the blue line indicates a vehicle stop.

The red line is influenced only by the fuel tank level as reported by the vehicle. The accuracy of the red line will depend on the vehicle and manufacturer.

The two lines should follow a similar pattern under regular driving and refueling. However, because the blue line changes with imported transaction information, it is possible that the blue line may rise when the red line does not, indicating a scenario like the following:

• • There was an instance of card sharing — a driver forgot his fuel card and another driver let him use theirs.
  • The fuel card is associated with the wrong vehicle.
  • A driver has used the fuel card to fill a personal vehicle or a Jerry can.

To understand how fuel reporting works including features and limitations, refer to Fuel Usage and Fill-Ups FAQs.

Importing Fuel Card Data into Your Database

Fuel card importing is vendor agnostic. Most fuel card providers will supply fuel transaction data in .csv or .xls file formats. Each row of the transaction file represents a separate fuel card transaction, with the columns indicating values like cost, volume, location, vehicle, etc. Fuel transactions can be imported using either of the methods below:

Using the Import Fuel Transactions Add-In

An Add-In has been developed to assist in importing fuel card data from .csv/.xls files. Two formats are supported: the WEX master file and a generic format.

1. 1. Integrate the Fuel Transaction Import Add-In into your database.
   2. Navigate to Engine & Maintenance > Fuel Transaction Import from the main menu.
   3. Select the Browse button and choose a .csv/.xls file of the appropriate format. Be sure to convert .xlsx file to .xls files before importing. 
   4. Select the Open File button.
   5. The Add-In will begin parsing the file. When completed, the first ten records will be previewed and the Import button will be enabled.
   6. Some files may contain information for multiple fuel card accounts. In these cases you can select the account whose data you wish to import from the dropdown menu. Only the data rows with the selected account name will be imported into the database.
   7. Select the Import button to import the selected data. The Add-In will notify you when the process has completed or if an error has occurred.

Using the API directly

The SDK documentation contains examples of adding, removing, setting, and searching for fuel transactions, along with information about the object structure. Potential use cases for using the API might be:

1. 1. Developing a small application that monitors an FTP site for new files. Once new files appear, it processes and adds them to a database.
   2. Fuel card system integration with the API.

EV Charging

A charge event occurs every time an electric vehicle is charged. Similar to the Fill-Ups Report, the EV Charging Report displays all charge events, charge sessions, and multiple charge events that occur during a single stop, for a selected time period.

When sorted by vehicle or driver, the heading of every vehicle displays the amount of electric energy added.

Note: For information on EV charging and firmware compatibility, refer to the EV Reporting and Monitoring User Guide.