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.
Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- 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
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.
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 |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
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.
Related guides & tools
- Fleet preventive maintenance: the complete guide
- EV fleet maintenance checklist template
- Fleet maintenance cost calculator
- Fleet maintenance category
Looking for more? Browse all fleet templates or run a fleet calculator.