How do you actually manage utility bills across multiple units?

Question

Hey everyone,

I manage 8 residential units across a few properties and I'm embarrassed to admit my utility bill process is basically "open bill, glance at total, pay it." I know that's not good.

Last month I finally sat down and actually read through a few bills line by line. Found that one of my units had been on an estimated read for 4 consecutive months — the utility never sent anyone out.

Another had a charge for a service I cancelled 6 months ago still showing up. Together that was around $280 in overcharges I probably would have just paid without noticing.

Now I'm trying to build an actual system but I don't know where to start. A few things I'm wondering:

1. Do you actually read every line item, or just check the total against last month?

2. How do you keep track of which bills are "normal" vs. suspiciously high?

3. Any red flags you always look for? (Estimated reads, rate changes, etc.)

4. Is there a spreadsheet or system people use to track utility costs per unit over time?

I'm not looking for software recommendations necessarily — more curious what your manual process looks like, or if you've just accepted that some overcharges slip through.

For context: my units are all residential, mix of electric and gas, across two different utility providers. Would love to hear from anyone managing more than 5 units especially.

Thanks

Patricia Steiner · Answer

My clients and I do not provide for utilities for our tenants. The assessments are based on their usage and therefore the control and management of that expense is all on them. It's amazing what happens when you stop paying that expense and it becomes their responsibility; the usage drops dramatically. Even in multi-family properties we acquire that are not on separate systems - and the city will not do so - we have purchased tracking systems installed on each unit and have the assessments billed to the tenants by the third party vendor. Even with all of this in place, I contact the electric and water providers as part of the inspection process to make sure that the accounts are paid-in-full and payments received in a timely manner. It's a 'great warning sign' of financial hardship that I'm not letting come my way.

Hope this helps...

Lindsey Allard · Answer

@Patricia Steiner This is very helpful! What tracking systems do you use? I was looking at installing systems to track this but I'm not sure where to start!

Daniel Clas · Answer

The ones who stay sane all end up doing something boring:

-one folder per property, every bill PDF dropped in the day it shows up

-one spreadsheet, a row per bill , property, utility, month, amount, and whether it's master or tenant metered

Then 20 min on the 1st checking that sheet against the bank feed so nothing slips. It falls apart the first time a bill spikes or a tenant argues a charge. Then you're digging through email at 11pm.

What's pushing you to tighten it up , just tracking cost, or are you billing tenants back?

Divin Kanyama · Answer

@Jeff Wei, you’re definitely not alone — with multiple units, it’s easy to fall into just checking the total and paying. But your example is exactly why having even a basic process matters.

I’d suggest a simple spreadsheet for each unit with: provider, billing period, usage, total cost, meter read type, fees/adjustments, and notes. Each month, compare usage and cost to the prior month and, if available, the same month last year.

The main red flags I’d check for are:

- Estimated reads, especially repeated ones

- Big usage spikes without an obvious reason

- New or recurring service fees

- Charges for cancelled services

- Rate changes or account adjustments

- Usage in vacant units

- Unusually long or short billing periods

I wouldn’t audit every bill in depth, but I would do a quick exception review each month. For eight units, that should be manageable and will catch most of the obvious billing issues before they become expensive.

Andrew Caranto · Answer

The $280 you found is probably the tip of it. Estimated reads compound for months and cancelled services ghost-bill constantly. Tracking usage units instead of dollar amounts is the move. Consumption spikes tell you there's a problem before the bill confirms it.

Ever considered bringing a thermal cam around your building a few times a month and checking for exceptionally hot units? Fairly simple check that could indicate someone activating crypto mining machines or AI servers on your electric bill.

James Jones · Answer

Great catch. Most landlords don’t realize how much money slips through the cracks until they audit their bills like you just did.

Here’s a simple, effective system that works well once you’re managing multiple units:

1. Don’t read every line item monthly, use a tiered review approach.

Monthly: Compare the total bill to the last 3–6 months for that same unit. If it’s within a normal range, approve it quickly.

Quarterly or Semi-Annually: Do a deeper line-by-line review to catch issues like estimated reads, rate changes, or lingering service fees.

2. Track “normal” ranges per unit.

Use a basic spreadsheet with these columns:

Property / Unit

Utility Type (Electric, Gas, Water, etc.)

Billing Period

Usage (kWh, therms, gallons)

Total Bill

Cost per Unit of Usage (e.g., $/kWh)

Notes (estimated read, vacancy, weather spike, etc.)

After a few months, you’ll clearly see each unit’s normal cost range. Anything 15–25% above the norm gets flagged for review.

3. Red flags to always watch for:

Estimated reads for multiple consecutive months

Charges for canceled services or duplicate service fees

Unusual spikes in usage without a clear reason (vacancy, extreme weather, tenant change)

Rate or tariff changes from the utility

Meter or service address mismatches

4. Build a simple monthly workflow:

Download all bills on the same day each month.

Log totals and usage into your spreadsheet.

Highlight any bill outside the normal range.

Investigate only the flagged ones.

This keeps your review time low while still catching costly errors, like the $280 you just saved.

You don’t need complex software to stay on top of this. A consistent process and a clean tracking sheet will prevent most overcharges and give you clear visibility into utility performance per unit over time.

Richard F. · Answer

If the utility bill does not include a simple bar chart showing past 12 months usage, then you need to just set up a spreadsheet and plug in the total number of units used in each billing period. KWH (kilowatt hours) for electric, gallons of water, cubic feet for natural gas, etc. and just track them over time. From the spreadsheet you should be able to easily generate a graph if that is your preference to review.

Depending on the taxes and other fees the utility charges, I would likely just total those, divide by unit's used, and add it to show the total cost of units used each month.

Over time you will see the seasonal patterns, and any single month jump could indicate an issue depending on what util. Water in particular you want to watch closely for signs of dramatic change which can indicate a leak within the system. Could be as simple as a running toilet, or as costly as a leak underground...or under a slab.

Electrical usage that is exceptionally high could indicate a freezer stuck in the "defrost" cycle, or an electric water heater either running excessively due to leaking hot water faucet, or due to electrical failure of the heating elements. Or a pot farm in the bedroom with lots of grow lights.

How do you actually manage utility bills across multiple units?

7 Replies