EV Fleet · Excel template
Free EV Charging Log Template
An EV charging session log that captures kWh delivered, cost, location, and resulting range for every charge: the record that turns electricity spend into a real cost-per-mile for an electric fleet. Use it alongside our fleet calculators to size the costs this template tracks, or browse fleet management software when you are ready to automate the workflow. See all downloads in the template library, and check the fleet glossary for any unfamiliar terms.
Built and reviewed by the FleetOpsClub research team. Preview it free below.
- A row per charging session with date, vehicle, and location (depot/public/home)
- kWh delivered, start and end state-of-charge, and session duration
- Cost and a derived cost-per-kWh and cost-per-mile
- A charger-type field (Level 2 / DC fast) and notes
- Editable CSV. Yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
How to use it
- 1
Log each session with the vehicle, date, location, and charger type.
- 2
Record kWh delivered along with start and end state-of-charge to see how full the battery went.
- 3
Enter the cost; the log derives cost-per-kWh, and with mileage you get a real cost-per-mile.
- 4
Tag the location type so depot, public DC-fast, and home charging can be compared and reimbursed correctly.
- 5
Review periodically to compare charging costs by site and to feed EV-versus-ICE cost analysis.
What's inside
- A row per charging session with date, vehicle, and location (depot/public/home)
- kWh delivered, start and end state-of-charge, and session duration
- Cost and a derived cost-per-kWh and cost-per-mile
- A charger-type field (Level 2 / DC fast) and notes
- A worked example covering depot, public, and home charging
Preview the template
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
Preview
EV Charging Log Template
Charging speed, efficiency (kWh/mi), and cost vary with temperature, charger type, and battery state. Treat the example values as illustrative.
| Date | Unit / VIN | Location Type | Charger | Start SOC | End SOC | kWh | Cost | Cost / kWh |
|---|---|---|---|---|---|---|---|---|
| 2026-03-04 | EV-101 | Depot | Level 2 | 28% | 92% | 48.0 | $6.72 | $0.14 |
| 2026-03-06 | EV-101 | Public | DC fast | 18% | 80% | 46.5 | $18.60 | $0.40 |
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
Without a session log there is no accurate cost-per-mile for an electric vehicle. Capturing kWh, cost, and location turns scattered charging spend into a real operating cost, exposes expensive public DC-fast usage, and supports home-charging reimbursement.
Divide the cost of a charge by the miles it enables, or aggregate kWh and cost over a period and divide by miles driven. Efficiency in kWh per mile varies with temperature, load, and driving style, so use real session data rather than the sticker figure.
Yes. The three cost very differently. Depot is usually cheapest, public DC-fast the most expensive, and home charging often needs driver reimbursement. Tagging location type lets you manage and reimburse each correctly.
It is essential. A real cost-per-mile from your charging log, compared against fuel cost-per-mile, is the honest basis for any EV-versus-ICE total-cost comparison.