Household Utility Bill and Meter Reading Log Template
Monthly totals are difficult to compare when billing periods have different lengths or contain rate changes. Logging usage per day separates consumption changes from calendar and price changes.
What to know
- Monthly totals are difficult to compare when billing periods have different lengths or contain rate changes. Logging usage per day separates consumption changes from calendar and price changes.
- Track billing days, usage, readings, rates, fixed fees, and actual-versus-estimated status.
Create one record for every electric meter, natural-gas meter, water meter, sewer account, shared building utility, and solar or export meter.
Record billing dates and usage, not merely the amount due.
Billing intervals can vary in length and cross calendar-month boundaries, making raw monthly totals misleading.
Account identity
Utility:
Service type:
Account holder:
Service address:
Account number:
Meter number:
Rate plan:
Supplier:
Utility contact:
Emergency number:
Regulator:
Online account:
Last reviewed:
Use the final four digits where the complete account identifier is unnecessary.
Bill-entry table
| Field | Entry | |---|---| | Bill date | | | Service start | | | Service end | | | Billing days | | | Previous reading | | | Current reading | | | Multiplier | | | Usage | | | Actual or estimated | | | Variable charge | | | Fixed charge | | | Taxes and fees | | | Credits | | | Amount due | | | Due date | | | Paid date | |
Normalize by billing days
Calculate:
Usage per day = billed usage ÷ billing days.
Example:
- 900 kWh over 30 days equals 30 kWh per day.
- 960 kWh over 35 days equals about 27.4 kWh per day.
The second bill has higher total usage but lower daily usage.
A comparison based only on monthly totals would blame the household for the calendar’s contribution.
Separate usage from price
Calculate an approximate variable usage price:
Variable price per unit = usage-dependent charges ÷ usage.
Do not include fixed customer charges when calculating the marginal rate unless the purpose is total average cost.
Electricity bills can include generation, transmission, distribution, taxes, fees, seasonal rates, time-of-use pricing, and other components.
Electricity fields
Record:
- kWh
- On-peak kWh
- Off-peak kWh
- Demand kW where applicable
- Exported solar kWh
- Net usage
- Fuel adjustment
- Delivery charge
- Generation supplier
- Estimated read
A kilowatt-hour is the energy used by one kilowatt operating for one hour.
Natural-gas fields
Record:
- Therms
- CCF or MCF
- Meter multiplier
- Conversion factor
- Delivery charge
- Commodity charge
- Estimated read
- Heating degree days where supplied
Do not compare a raw cubic-foot meter difference with billed therms without accounting for the utility’s conversion method.
Water and sewer fields
Record:
- Gallons
- Cubic feet
- Thousand-gallon units
- Meter readings
- Water tier
- Sewer basis
- Stormwater charge
- Fixed service fee
- Estimated reading
Take a private meter photograph
On the same date each month:
- Stand in an authorized safe location.
- Photograph the display.
- Include the meter number where safe.
- Record date and time.
- Do not touch seals or enclosures.
- Compare the photograph with the next bill.
Do not open an electrical, gas, or water-meter enclosure.
Track actual versus estimated reads
Estimated bills can create later adjustments.
Record:
- Estimated indicator
- Estimated usage
- Date of actual reading
- Catch-up adjustment
- Utility explanation
A sudden high bill can reflect earlier underestimation rather than one month of actual consumption.
Record household conditions
Useful context includes:
- Number of occupants
- Guests
- Vacation
- Heating or cooling season
- Major appliance change
- Electric vehicle
- Leak
- Pool filling
- Construction
- Rate-plan change
- Solar outage
- Meter replacement
Do not use one month’s change to diagnose equipment without checking these conditions.
Dispute record
Problem:
Date noticed:
Bill:
Meter photograph:
Prior comparison:
Utility contacted:
Representative:
Case number:
Investigation:
Correction promised:
Credit posted:
Regulator contacted:
Preserve the original bill and corrected bill.
Do not rely on a telephone promise that a credit “should appear eventually.”
Minimal spreadsheet header
Utility | Service | Meter | Period Start | Period End | Days | Previous Read | Current Read | Multiplier | Usage | Actual/Estimated | Variable Charge | Fixed Charge | Taxes | Total | Usage/Day | Paid | Dispute
Bottom line
Track billing days, usage, readings, rates, fixed fees, and actual-versus-estimated status.
A bill can rise because the household used more, the rate increased, the billing period grew, a credit ended, or an earlier estimate was corrected. The total alone refuses to identify which culprit arrived.
Sources reviewed
Limits and cautions
- Not hands-on tested
Source notes
See something wrong or out of date? Report a correction.