EV Fleet · Excel template
Free EV Charging Invoice Reconciliation
A sheet that matches logged charging sessions to what the network and utility actually billed — kWh, rate, idle fees, and the variance on each one.
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 session-level match between your charging log and the network invoice, keyed on session or transaction ID
- Logged kWh against billed kWh, and logged cost against billed cost, with the variance on each
- Separate columns for the charges that are not energy — session fees, idle fees, connection fees, subscription
- A separate view for invoice lines with no session behind them at all
- A disposition column so a disputed line has an outcome rather than being silently absorbed
- A per-network summary, since the fee structures are what actually differ between them
How to use it
- 1
Export the period's sessions from your charging log and the same period's statement from each network, then match on session or transaction ID.
- 2
Compare logged kWh to billed kWh first. A consistent gap in one direction usually means a metering or rounding difference rather than an error; a one-off gap is worth a look.
- 3
Separate the energy charge from everything else. Idle fees, per-session fees and subscription charges distort cost-per-kWh badly if they are left folded into it.
- 4
List the invoice lines you cannot match to a session — those are either sessions your log missed or charges that are not yours.
- 5
Give each variance a disposition: accepted, queried, credited, or written off. A variance with no outcome recorded will reappear next month.
- 6
Roll the result up by network, then feed the reconciled energy cost — not the invoice total — into your cost-per-mile.
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 Invoice Reconciliation
Fee names and structures differ by charging network and by utility tariff, and home-charging reimbursement follows your own policy rather than a network statement. Treat the columns as a shape to adapt, and the figures as illustrative.
| Session / txn ID | Date | Unit / VIN | Network | Logged kWh | Billed kWh | Billed energy | Idle / session fees | Variance | Disposition |
|---|---|---|---|---|---|---|---|---|---|
| TXN-884120 | 2026-03-04 | EV-101 | Depot (utility) | 48.0 | 48.2 | $6.75 | $0.00 | +0.2 kWh | Accepted — meter rounding |
| TXN-901337 | 2026-03-06 | EV-101 | Public DC fast | 46.5 | 46.5 | $18.60 | $4.00 idle | +$4.00 | Queried — vehicle moved at 09:12 |
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.
The invoice is what you were billed, which is not the same as what you used, and not the same as your energy cost. Charging statements mix energy with session fees, idle fees, connection fees and subscriptions, and they occasionally carry sessions that are not yours. Reconciling separates the energy charge from the rest, which is the only figure that belongs in a cost-per-kWh or a cost-per-mile.
Usually metering. The vehicle measures energy arriving at the battery and the charger measures energy delivered at the connector, and the difference between those two is real — charging losses mean the vehicle sees less than the charger sent. Rounding and interval boundaries add a little more. A small consistent gap in the same direction is expected; what is worth investigating is a gap that changes size or flips direction.
Many public networks charge for time a vehicle stays plugged in after charging finishes, to stop a charger being blocked. For a fleet they tend to accumulate quietly, because a driver who parks and goes on break is behaving reasonably from their point of view. Breaking them out as their own column is what turns them from an unexplained invoice gap into a driver-behaviour or a scheduling conversation.
The charging log is the operational record of what happened at the charger — kWh, state of charge, location, duration. This sheet is the financial check on it, matching those sessions to what was billed. Keep both: the log is what tells you a session is missing from an invoice, and the invoice is what tells you a session is missing from the log.
It covers the depot's energy charges the same way as a network's, but demand charges are a different kind of line. They are billed on peak power drawn rather than energy consumed, so they do not attach to any one session and cannot be reconciled session by session. Keep them as a site-level cost and reconcile them against your charging schedule rather than against this sheet.
Home charging has no network statement to reconcile against, so the check is different: you are matching a reimbursement claim to logged sessions and a known rate rather than matching an invoice. Keep those rows tagged by location type so the home-charging reimbursement total stays separable from network spend.
Related guides & tools
Looking for more? Browse all fleet templates or run a fleet calculator.