RUBS utility billing: spreadsheet, billing service or software?

There are four realistic ways to run RUBS utility billing for a small multifamily portfolio: a spreadsheet you keep yourself, a full-service billing company, per-unit billing software, and a tool that reads the bills you already pay and returns charges to import. The right one depends on what you pay today, whether you want tenants billed directly by a vendor, and how many bills you open each month. Try one split in the calculator above, then use the comparison below.

What are the ways to run RUBS utility billing?

• A spreadsheet. You open each bill, note the amount and period, and split it across units in a sheet. It costs nothing but time, and its weak spot is keeping occupant counts, lease dates and proration right every month.
• A full-service biller. A company takes over the bills and the tenant billing. Some of these charge the property manager nothing and recover their cost through fees paid by residents; others quote by sales call. In the evidence behind this guide, one 1,800-apartment portfolio was quoted $12 per outsourced utility bill and called it steep next to other invoice processing.
• Per-unit billing software. Software priced by the unit. Utility Ranger, for example, listed $2 per unit per month on its Cadet plan when we checked on 2026-09-21, which is $200 a month at 100 doors and rises with every unit.
• A bill-reading tool. You upload the bills and the rent roll, and it returns tenant charges and exceptions. Utility Billback is this: a flat monthly price for up to 1,000 units and 600 bills a month, with the CSV as the output.

How do the four compare?

Read the last column carefully: it is the one the others cannot be compared on without asking. Ask any vendor what happens to the bills that never moved into a tenant's name.

Which should you pick?

Start from what you actually pay now. If the work takes you about an hour a month, a spreadsheet may be fine, and no tool will save much. Some managers report exactly that. If a billing company costs you nothing because residents pay a fee, the question is whether you accept that fee on your tenants and the loss of control over who bills them.

The case for a bill-reading tool is the manager who has neither: no vendor, a stack of PDFs and a spreadsheet that falls behind. That is the buyer Utility Billback is built for, and it is not for everyone. If you want a company to bill tenants and collect from them, it does not do that: it collects nothing and emails nobody outside your account.

What does a spreadsheet RUBS miss?

Three things, most often.

1. Proration. A split by occupants that ignores the days each lease covers overcharges whoever is in the unit when the bill arrives.
2. Rounding. Shares computed to the cent and rounded one by one drift from the bill by a few cents, which an auditor or a tenant will find. Whole-cent splitting with leftover cents handed to the largest remainders keeps the total exact. See the RUBS calculator for the arithmetic.
3. Bills that never moved to the tenant. The sheet only holds the bills you thought to put in it. The bill sitting in your company's name for a unit whose lease puts the utility on the tenant is not in the sheet at all. The utility billback guide explains how to find them.

What does Utility Billback do, and not do?

It reads PDF utility bills (provider, service address, account name, service period and amount), with a review screen beside each PDF before anything is used. It matches each bill to a property and unit by service address, splits shared water, sewer, gas and trash by occupants, square feet or equal share, to the cent and prorated for move-ins and move-outs, lists every bill still in your company's name where the lease says the tenant pays, and downloads a tenant charge CSV plus a statement PDF per charged unit.

It does not connect to AppFolio or Buildium, post to your ledger, pay utility bills, collect from tenants, handle submeter data, or know your state's billback rules. Scanned bills it cannot read go to manual entry. It is not legal advice: check local law and your leases before billing tenants.

How do you test before you commit?

Run one real bill. The calculator on this page splits it across your own rent roll with no sign-up and reads the file in memory without keeping it. Then look at the sample month, which runs four bills on a fixed 12-unit building and shows the exceptions list. If the numbers agree with what you would have worked out by hand, the arithmetic is the same arithmetic a spreadsheet does, and the question is only whether you want to stop doing it by hand. The ratio utility billing system guide covers what to verify in any tool's split.

Frequently asked questions

Are RUBS billing companies free for the property manager?

Some are, because they charge residents a fee, and some quote by sales call. Ask for the fee schedule that your tenants would see before you decide.

Is per-unit software cheaper than a flat price?

It depends on your door count. At $2 per unit per month, 100 doors cost $200 and 500 doors cost $1,000, so a flat price changes the comparison as you grow. Check the plan's current price, which may have changed since 2026-09-21.

Does any tool make RUBS charges legal?

No tool does. Whether you may use RUBS, what you may charge and what you must disclose varies by state, city and lease, so check local law and your leases.