EV Fleet · Excel template
Free EV Battery Health Log
A per-vehicle record of state-of-health readings over time — capacity retention, charge cycles, and fast-charge exposure — the data that turns a range complaint into an actual answer.
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 state-of-health reading logged per vehicle at a regular interval, not just when a driver complains
- Cumulative charge-cycle and fast-charge-cycle counts, since both affect degradation differently
- A capacity-retention percentage calculated against the vehicle's original rated capacity
- An ambient-condition note, since heat and cold both distort a single reading
- A trend view across readings, so a real decline is separated from one unusual day
How to use it
- 1
Record the state-of-health reading at a fixed interval — monthly is common — rather than only when someone raises a concern, so you have a baseline before there's a problem.
- 2
Log cumulative charge cycles and, separately, fast-charge cycles; heavy DC fast-charging use degrades a battery faster than the same energy delivered on Level 2.
- 3
Take readings under similar conditions where possible, or note the ambient temperature — a cold-weather reading looks worse than the battery's real health.
- 4
Calculate retention against the vehicle's original rated capacity, not last year's reading, so drift doesn't compound unnoticed across the log.
- 5
Plot the trend across several readings before acting on any single one — one low reading on a cold morning is not the same finding as a steady six-month decline.
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 Battery Health Log
State-of-health reporting varies by manufacturer and telematics platform, and some vehicles expose it more readily than others. Confirm how your fleet's vehicles report SOH before relying on this log as the only source.
| Date | Unit | SOH % | Total Cycles | Fast-Charge Cycles | Ambient Temp | Notes |
|---|---|---|---|---|---|---|
| 2026-01-15 | EV-101 | 97% | 142 | 18 | 42°F | Baseline reading |
| 2026-04-15 | EV-101 | 95% | 203 | 31 | 68°F | Normal seasonal range |
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.
Some gradual capacity loss over the life of any EV battery is expected and is not itself a fault — the manufacturer's warranty terms usually define the retention level considered acceptable over a given mileage or time period. What this log is for is catching a decline steeper than that normal curve early, while it's still a warranty conversation rather than a replacement bill.
Frequent DC fast-charging generally accelerates degradation compared to the same energy delivered via slower Level 2 charging, though the effect varies by battery chemistry and thermal management design. Tracking fast-charge cycles separately from total cycles is what lets you connect a faster-than-expected decline to a usage pattern you can actually change — routing more charging to depot Level 2 overnight, for instance.
Battery chemistry is temperature-sensitive, and a cold reading understates usable capacity while a hot one can distort it the other way — neither is the battery's true baseline health. Noting ambient temperature at each reading is what lets you tell a seasonal dip from a real decline, rather than chasing a warranty claim on a January reading that recovers by April.
Check it against the manufacturer's warranty terms for retention at the vehicle's current mileage and age — a confirmed decline below the warranted level is a claim, not just a data point. Keep the full trend log as the evidence; a single low reading is easy to dispute, a documented six-month decline against a stated baseline is not.
Related guides & tools
Looking for more? Browse all fleet templates or run a fleet calculator.