How to Compare Utility Bills Month to Month (4 Simple Steps)
TL;DR: Track your electric, gas, and water bills month to month by normalizing for weather and occupancy, calculating cost per square foot or per unit, and flagging spikes above 20%. Most landlords who compare systematically save 10-15% per year by catching hidden leaks, failing HVAC equipment, and tenant misuse before they compound.
_Last reviewed: July 2026 · 5 min read_
A $200 electric bill in July looks normal until you compare it to last July's $160—same occupancy, same thermostat setting, but your AC compressor is silently dying. Comparing utility bills month to month turns raw numbers into actionable insight, catching problems while they're still fixable and inexpensive.
Okoniq Property Hub logs utility bills by property and unit, plots them on a timeline, and flags percentage spikes automatically—so you spend five minutes reviewing instead of an hour with spreadsheets.
What baseline should you use to compare month to month?
Use the same month last year as your primary baseline, then layer in a rolling 12-month average to smooth out one-time anomalies. Comparing March 2024 to March 2023 accounts for seasonal heating and cooling demand; comparing March 2024 to your trailing-12-month average tells you whether the spike is part of a trend or a one-off weather event.
Calculate cost per square foot for multi-unit properties or normalize by degree days if you heat with gas or oil. The National Oceanic and Atmospheric Administration publishes heating degree days (HDD) and cooling degree days (CDD) for every ZIP code—divide your gas bill by the month's HDD count to see cost per degree day. If that number climbs 15% year over year, your furnace efficiency is declining or insulation has failed, even if the raw dollar amount stayed flat because winter was milder.
For water bills, divide total gallons by occupancy days. A duplex with one vacant unit should use roughly half the water; if it doesn't, you have a toilet flapper leaking 200 gallons per day or an outdoor spigot left open. Leaks under 1 GPM rarely make noise but add $40-60 per month in many jurisdictions.
Track the date each bill covers, not the date you paid it—billing cycles shift by a few days, and a 35-day cycle in February will show higher usage than a 28-day cycle even if daily consumption stayed flat. Closing a seasonal home for winter will drop your baseline to near zero; flag that month in your comparison so you don't treat the next occupied month as a false spike.
How do you spot a spike that warrants immediate action?
A 20% increase over the same month last year or over your rolling average is the threshold most property managers use to trigger an inspection. Smaller variances—5-10%—usually reflect weather or a few extra days in the billing cycle; anything above 20% points to equipment failure, occupancy change, or a leak.
Electric spikes in summer mean the AC is short-cycling, the compressor is failing, or someone added a space heater or window unit. Gas spikes in winter point to a failing furnace heat exchanger, a pilot light that won't stay lit and keeps re-igniting, or a water heater running constantly because the thermostat failed. Water spikes with no occupancy change almost always mean a running toilet, a leaking supply line under a sink, or an outdoor hose bib left cracked open.
Compare usage in kilowatt-hours (kWh), therms, or gallons—not just the dollar total—because rate hikes can mask efficiency gains or hide usage creep. If your kWh consumption dropped 8% but your bill went up 5%, you're doing fine; the utility raised rates. If kWh went up 18% and the bill went up 25%, you have both a usage problem and a rate problem, and the usage problem is the one you control.
Log every bill in a single place with the meter reading, billing-cycle dates, and any notes about occupancy or weather. A basement dehumidifier left running 24/7 after a tenant moved out will add $30-50/month in electric; you won't catch it unless you track kWh per day and notice it stayed high despite vacancy.
What seasonal patterns should you expect in a typical year?
Electric bills peak in July and August in most of the US due to air conditioning, then drop 30-50% in spring and fall when neither heating nor cooling runs. Gas bills peak in January and February, drop to a pilot-light minimum in summer, then climb again in October. Water usage stays fairly flat unless you irrigate a lawn or garden—then expect a 40-60% summer spike.
A property with electric baseboard heat will show reversed seasonality: electric peaks in winter instead of summer, and gas stays minimal year-round. Heat pumps in moderate climates (zones 4-5) show smaller winter spikes than gas furnaces because they move heat instead of generating it, but they'll spike hard if outdoor temps drop below 25°F and the backup resistance strips kick in.
Occupancy turnover resets the baseline. A new tenant who works from home will use 20-30% more electric and 15-20% more water than a tenant who commutes five days a week. If you see a step-change increase the month a lease starts, that's behavioral, not equipment failure—but log it so you don't later mistake normal usage for a spike.
Weather-adjust by multiplying your bill by the ratio of this year's degree days to last year's. If March 2024 had 850 HDD and March 2023 had 750 HDD, multiply last year's gas bill by 1.13 (850 ÷ 750) to get an apples-to-apples comparison. If this year's bill exceeds that adjusted baseline by 20%, your heating system efficiency has dropped.
Quarterly meter reads—common in some rural water districts—smooth out monthly noise but delay problem detection. If you get one bill covering January through March, you won't know whether the spike happened in week two or week eleven, and a running toilet could waste 1,800 gallons before you notice.
How do you track multiple properties or units on one dashboard?
Normalize every bill to cost per square foot per month, then compare properties against each other. A 1,200 sq ft duplex unit using $0.18/sq ft/month in electric is typical; $0.28/sq ft signals a problem even if the raw dollar amount looks small. For multi-family, track common-area usage separately—lobby lights, hallway heat, laundry room circuits—so you can isolate tenant-caused spikes from building-system issues.
Use property management software or a spreadsheet with one row per bill and columns for property, unit, billing start/end dates, kWh or therms, total cost, cost per sq ft, and percent change vs. last year. Sort by percent change descending once a month; anything above +20% gets a site visit. Okoniq logs bills automatically, calculates the year-over-year delta, and highlights outliers in red on the property timeline.
If you manage properties in multiple climate zones, compare each property only to its own history—never to a property 500 miles away. A Phoenix fourplex will use triple the summer electric of a Portland fourplex; the meaningful comparison is Phoenix July 2024 vs. Phoenix July 2023.
Tag bills with notes: "new tenant moved in 3/15," "AC compressor replaced 6/10," "outdoor spigot left open, repaired 8/3." Six months later, when you see a step-change in the trend, those notes explain whether it's expected or anomalous. A boiler maintenance visit in October should correlate with a 5-10% efficiency gain in November's gas bill; if it doesn't, the tune-up didn't work or wasn't done.
FAQ
How long should I keep old utility bills for comparison?
Keep at least 24 months of bills—two full years lets you compare this January to last January and the January before that, revealing multi-year trends like gradual insulation decay or an aging HVAC system losing 3-5% efficiency per year. The IRS wants supporting records for rental expenses for three years after you file, so keep bills digitally for at least 36 months; many landlords archive them indefinitely because they document property operating history for resale or refinance appraisals.
What if my tenant pays utilities directly and I never see the bills?
Ask the tenant to forward a copy each month or request a third-party authorization from the utility so you receive duplicate statements. Most utilities allow landlords to add a "courtesy copy" recipient without transferring billing responsibility; you'll see usage data but the tenant stays liable for payment. If usage spikes indicate a maintenance issue—like a leaking water heater or failing AC compressor—you're responsible for repairs even if the tenant pays the bill, so monitoring usage protects your asset.
Should I compare gas and electric bills separately or combine them into total energy cost?
Compare them separately because they fail differently—an electric spike points to HVAC, appliances, or lighting; a gas spike points to heating or water heating. Combining them into one "energy cost" number obscures which system is failing. Track total energy cost as a portfolio metric for budgeting, but troubleshoot each utility independently.
How do I know if a spike is weather-related or equipment-related?
Divide this month's usage by degree days (HDD for heating, CDD for cooling) and compare that ratio to the same month last year. If the usage-per-degree-day stayed flat, the spike is weather; if it jumped 15-20%, your equipment is losing efficiency. Most utility websites publish local degree-day data, or pull it from NOAA's National Centers for Environmental Information for your ZIP code.
Can I automate bill comparison without manually entering data every month?
Many utilities offer CSV download of 12-24 months of billing history; import that into a spreadsheet or property management tool once, then add new bills as PDFs arrive. Some property software (including Okoniq) reads utility PDFs via OCR and auto-populates usage, cost, and dates; you review and approve rather than typing. Set a monthly calendar reminder so bill review becomes a 10-minute task instead of a quarterly scramble.
This is educational information, not financial or tax advice. Consult a CPA about deductibility of utility expenses and energy-efficiency improvements as rental property operating costs or capital expenditures.
Keep reading
Get seasonal maintenance tips by email
Gutter-cleaning, filter-changing, before-it's-a-$3,000-problem guides. No schedule, no spam — unsubscribe anytime.
Prefer to dive in? Get started free →