How to Report the Cost of Charging Vehicles

How to Report the Cost of Charging Vehicles

This guide outlines how to export charging session data from the Future Energy dashboard and calculate the cost of each session, on a volumetric cost of electricity basis. This is ideal for internal operational tracking, such as allocating EV charging costs across departments.
​

Navigate to the Charging Session page

Home>Activity>Charging Sessions
​
  1. Filter Sessions: Use filters to choose dates. Also, be sure to filter for sessions that have session status as "Finished."

  2. Select Sessions: Once Filtered, select sessions using checkbox on the left.

  3. Export Sessions: Once selected, under Actions on the right side click the Export button at the top right of the session list.

  4. Select the regular option in order for users and user group columns to be exported.

  5. You will receive an email shortly after with a link. After clicking, you may be asked to login again, and then you will be able to download.

  6. Download and open the exported file, which will include session details such as: 

    • Session ID

    • User email and user group

    • Start and End Time

    • Session Duration

    • Energy (Wh)
      Warning
      This must be converted to kWh, divide by 1000

    • Charge Point

    • Revenue

Add Cost Calculation Columns

  1. Open the exported file in a spreadsheet tool.

  2. Hide/delete columns as needed for view.

  3. Create 2 new columns. One for "Cost per kWh", and another for "Calculated Cost"

    1. For the cost rate per kWh (e.g., $0.25 per kWh): To convert from Wh, add three 0s after decimal place. [30000Wh = 30kW], [$0.25 per kWh = $.00025 per Wh]

    2. For the Calculated Cost, input formula: (Energy in Wh X cost per Wh) Ex. (23700 x $.00025= $7.50)

    3. Example for Excel:


Column A
Column B
Column C
Column D
Column E
Column F
Row 1
Session ID
User
User Group
Energy (Wh)Cost per kWh ($0.25)
Calculated Charging Cost 
Row 2
12345
service@dealership.com
Internal Business Use - Service237000.00025
=D2*E2
Row 3
12346
service@dealership.com
Internal Business Use - Inventory34000
0.00025
=D3*E3

6. Copy the formula to all other rows. Save and utilize for accounting purposes.






    • Related Articles

    • Tiered Pricing and User Groups on the Future Energy Network

      What is Tiered Pricing? Future Energy’s CSMS platform supports tiered pricing strategies that allow station owners to offer different rates to specific user groups. Tiered pricing refers to applying different public charging pricing models based on ...

    • Understanding EV Charger Pricing Components

      When setting up public EV charging stations, it's essential to understand and select the right pricing strategy. Future Energy’s platform supports flexible tariff structures to help partners balance revenue goals, infrastructure utilization, and ...

    • How to Adjust Pricing

      Setting up Tariffs: Define tariffs for public EV charging, customizing rates for different user groups. How to Create and Manage Tariffs: - Create Tariff Groups and assign individual tariffs to them - Set specific pricing for user groups (e.g., ...

    • How to Access Revenue and Billing Reports

      View Billing Data: Track your revenue and expenses from public charging sessions. How to Access Reports: - Go to the Billing section in the dashboard - View detailed reports on charging revenue and expenses.

    • FAQ's

      How do I locate charging stations in the app? Open the app and tap the Map tab. Use filters to find stations by: Availability (Online/Offline) Connector type (e.g., CCS, CHAdeMO, J1772) Charging speed (L2 or DC Fast) How do I start a charging session ...