One Utility Company, Nine Houses: How to Split Utilities Across a Rental Portfolio

Your electric company bills you nine times a month and your bank records all nine identically. There is no rule, no vendor setting and no amount of tagging that can separate them, because the information simply is not in your bank feed. It is on the bill, and almost nobody reads it.

The problem, exactly

Open your bank statement and look at how a utility payment actually arrives. It will be something like SPI*AMERENIL, or COMCAST CABLE CMCST, or APS AUTOPAY 8012. Now look at the next one, for a different house. It is the same string. Byte for byte.

That is not a flaw in your bank. A descriptor identifies the merchant, and the merchant is the same company no matter which of your meters the power went to. The house is not in there, and it never will be.

Which means every piece of advice built on vendor rules fails here. "Set up a rule so Ameren always goes to Lake Shore" works beautifully until the second Ameren account shows up, and then it silently files one house's power bill against another. That is worse than leaving it unassigned, because nobody goes looking for a charge that already has a property on it.

Any bookkeeping tool that lets you teach it one property per payee will do this to you. A tool that notices the conflict will stop guessing, which is correct but leaves you doing it by hand every month.

What operators actually do, and why each one wears out

Allocate by square footage or by door count. Defensible, and genuinely the right method for a shared expense. But a utility bill is not shared. Each meter belongs to one house, and allocating a known cost by formula turns a precise number into an estimate for no reason.

Keep a spreadsheet of account numbers. This works. It is also the thing you will stop doing in March, and the reason your accountant gets a single "Utilities" figure for the whole portfolio in April.

One bank account per property. The cleanest answer, and worth doing if you are early enough to set it up. Most people are not, and the ones with a dozen doors are usually running one operating account on purpose.

Give up and put it at portfolio level. Common, and it costs you more than people realise. See the Schedule E section below.

The answer is printed on the bill

Every utility bill in the United States almost always tells you which property it is for. Pull up the email your power company sends and you will find something close to this:

Paperless Billing Statement

Account Number: 3509911005
Service Address: 4217 E LAKE-SHORE DR
Amount Due: $175.48
Due Date: 11/09/2026

There it is. Service Address. The one fact your bank will never have, sitting in an email you already receive twelve times a year per meter.

So the method is not "build a better vendor rule". It is: stop trying to get the property out of the bank, and get it out of the bill.

How to do this by hand

You do not need software for this. If you want to do it yourself, do it once per account and never again:

For each utility account, open one bill and write down the account number and the service address.
Match each account number to a property. Keep that list somewhere permanent, not in your head.
Now go back through the year. Sort your utility charges by amount, not by date. Each meter has a stable seasonal range, so a column of charges around $330 and a column around $175 are two different houses, and the account list tells you which is which.
Record the account number in the memo of every charge you assign, so the next person, including future you, can check the work.

Step 3 is the part people get wrong. Utility charges cluster by meter far more reliably than they cluster by date, so amount is the better sorting key when you are reconstructing a year.

Why this matters on the return

Utilities are Schedule E Line 17, and Schedule E is filed per property. A single portfolio-level utilities figure is not just untidy, it has consequences:

Per-property profit is wrong. If your costs sit at portfolio level while your revenue is allocated per door, every property looks more profitable than it is, and the ones with the heaviest utility load look best. That is exactly backwards, and people make buy and sell decisions on it.
A loss on one property can be mislocated. Under the §469 short-stay exception, whether a loss is passive depends on the average stay of that property and on your material participation in it. Costs parked in the wrong place move the loss to the wrong activity.
Mixed portfolios get it worst. If some doors are short-term and some are long-term, the two sets are treated differently and a pooled utilities number blends them.
It is the first thing a reviewer asks about. Not because allocation is suspicious, but because "how did you arrive at this" should have a one-sentence answer, and "the account number on the bill says so" is the best one-sentence answer there is.

How RentReel does it

We added this on 27 October 2026, and it works the way the manual method does, without the list.

Forward a utility bill to [email protected] from the address you sign in with. RentReel reads the account number and the service address off the bill, matches that address against your own property names, and marks the bill for that house. Attach it to the charge and the charge is filed there. Later bills you forward from the same account are recognized the same way.

Two things we were deliberate about, because getting this wrong is expensive:

It refuses rather than guesses. If a service address does not clearly identify one property it does nothing and says so. "E WALNUT ST" cannot choose between 406 and 408, so it will not. A house number alone is never enough either, so a property called "522 Ridge" will not claim a charge at "522 Oak St". Filing one house's power against another is worse than leaving it unfiled.

It shows its work. The receipt says which account number and address it read and that it decided for itself, because a guess you cannot see is a guess you cannot correct.

The same inbox handles the ordinary case too. Forward a receipt and it matches on merchant, amount and date, so a forwarded Verizon bill offers you Verizon charges first, and only Verizon charges when any are in the window. Put the property in the subject if you like, including your own short codes, so "HG Supplies" is enough. One bill covering several houses can say so: "Daisy Lane $648, Hidden Grove $432" splits the charge when you attach it.

What to do this week

Whatever you keep your books in, do this once: open one bill per utility account, write down the account number and the service address, and match each to a property. That list is the asset. Everything else, by hand or automatically, is just applying it.

If you would rather not keep the list, RentReel keeps it for you. Free covers one short-term rental with no card and no time limit, and long-term and mid-term doors do not count toward any tier, because the tax layer that makes RentReel different does not apply to them.

RentReel keeps tax-ready books. It does not prepare, sign or file returns, and nothing here is tax advice. Allocation method and basis questions belong with your CPA.