Key takeaways
- Align billing boundaries and time zones before comparing totals.
- Interval kWh explains usage; it does not by itself reproduce taxes, fees, riders, or adjustments.
- Small differences can come from rounding or data revisions; large persistent gaps deserve investigation.
Smart-meter downloads can make a utility bill more transparent, but the interval total may not equal the printed kWh on the first attempt. The usual causes are mismatched dates, inclusive/exclusive boundaries, time zones, estimated readings, solar netting, multipliers, or revised data. Reconciliation should be methodical.
Start with a bill map
Record the service period, number of days, beginning and ending meter readings where shown, billed kWh, rate schedule, meter number, reading type, and every charge. Distinguish usage-based charges from fixed charges and taxes.
| Bill item | Interval-data equivalent | Common mismatch |
|---|---|---|
| Billed kWh | Sum of interval import energy | Wrong boundary or netting |
| On-peak kWh | Intervals mapped to tariff calendar | Holiday/season/time-zone rule |
| Demand kW | Maximum billing-window demand | Averaging interval differs |
| Fixed charge | None | Cannot be derived from kWh |
| Taxes/riders | Tariff calculation | Different tax base or adjustment |
Choose the exact data window
If a bill covers July 3 through August 2, confirm how the utility defines those boundaries. A timestamp may label the beginning or end of an interval. Fifteen-minute data at “01:00” might represent 00:45–01:00 or 01:00–01:15. Do not assume. The utility’s data dictionary or Green Button documentation should explain it.
Time zone and daylight saving
Exports may use local standard time, local prevailing time, or UTC. Daylight-saving transitions can create a repeated or missing clock hour. This matters most when assigning time-of-use prices. Preserve the source time zone and offset during analysis rather than deleting them from the file.
Import, export, and solar netting
A solar home may have separate import and export channels, net intervals, or a meter that reports register totals differently from the customer portal. Never add import and export without checking sign conventions. Battery charging and discharging can further change the pattern without changing household appliance use.
Reconciliation procedure
- Download the highest-quality interval file for the full bill period plus one day on each side.
- Confirm meter ID, unit, time zone, interval duration, and channel definitions.
- Filter to the billing boundary according to the utility convention.
- Sum raw import kWh before assigning prices.
- Compare with billed kWh and calculate both absolute and percentage difference.
- Only after usage matches, map intervals to tariff periods and calculate charges.
- Add fixed charges, riders, minimums, taxes, credits, and adjustments in the order specified by the tariff.
Example
A bill shows 912 kWh. The first interval sum is 936 kWh, a 24-kWh difference. Inspection finds that the export included the day after the meter-read boundary. Removing those intervals produces 913.1 kWh. The remaining 1.1 kWh, about 0.12%, may reflect rounding or a revised interval. Document it rather than forcing the data to equal the bill by altering arbitrary rows.
When the difference is large
Check for missing intervals, duplicate timestamps, a meter exchange, multiplier, estimated billing, multiple meters, solar channels, account adjustments, or units other than kWh. Compare the current meter identifier with the bill. Contact the utility with the exact service dates, file version, and calculated difference; avoid sending unnecessary personal data.
Use the result to improve calculators
Once interval energy reconciles, calculate baseload, daily profiles, weather-related changes, and time-of-use exposure. Use the matched billed marginal price for savings estimates, while reporting fixed charges separately. Reconcile another month before building a major investment decision on the data.
Frequently asked questions
Why can’t I reproduce the bill from kWh alone?
Tariffs may include time periods, tiers, demand, losses, riders, taxes, minimums, and fixed charges.
What is an estimated meter reading?
The utility may bill from an estimate when validated actual data is unavailable and later adjust it. Check the bill’s reading indicator.
Is a tiny mismatch proof the meter is wrong?
No. Rounding, validation, timing, and export version differences are more common explanations. Persistent material gaps warrant formal review.
Sources and editorial notes
Utility Cost Lab prioritizes primary government agencies, national laboratories, utility documents, and recognized efficiency programs. Sources reviewed August 12, 2026.
- U.S. Department of Energy — Green Button data
- U.S. Energy Information Administration — Electric meters
Calculations are planning estimates. Actual bills depend on equipment, weather, occupancy, utility tariffs, taxes, fixed charges, and local conditions. Follow manufacturer instructions and use qualified professionals for electrical, fuel, plumbing, pool, or HVAC work.
Leave a Reply