RUBS billing, short for Ratio Utility Billing System, is how many US landlords pass a building's utility costs on to tenants when the units don't have their own meters. You take the master bill, deduct what your rules require, for example common areas, and split the rest by a formula: number of occupants, square footage, or a mix. The math is easy. The work is the paperwork: the right bill for each utility and period, a formula that matches lease and local rules, and records you can show when a tenant asks how their share was calculated. AI can prepare most of it: sort bills into a binder per utility, flag gaps, run the formula, draft replies to records requests. One limit stays, and I put it the same way in my overview for property managers: whether an item can be passed on is not its call.
This is not legal advice. Rules on allocated utility billing differ by state and sometimes by city; the Texas rules below are an example, not a template for your state. There's a section for landlords in Germany further down. The overview of what AI can take over in property management is in AI for Property Management. Bank reconciliation and year-end statements are covered in Property Management Bookkeeping with AI.
RUBS billing in five steps
Spreadsheet, software or billing company: the steps are the same, only the roles change.
- Start with the lease. Does it allow allocated utility charges, for which utilities, and by which method? How an AI pulls such clauses word for word with a page reference is in AI Contract Review: What Works.
- Collect the master bills. One folder per utility, with every bill for the billing period.
- Close the gaps. Anything missing gets requested before you calculate. A line without a bill is never estimated. How to track down and request missing bills: Missing Receipts: Find, Request, Document.
- Deduct and allocate. Take out what your rules require, then apply the formula to each unit.
- Check, send, keep the binder. A second person reads it against the bills, then it goes out. The binder stays ready for the tenant who asks.
What the rules can look like: Texas as an example
Texas regulates allocated billing for water and wastewater in Title 16 of its Administrative Code, and it spells out the steps.
Deductions first. Before allocating the master meter bill, the owner deducts dwelling unit base charges or the customer service charge, if applicable, and common area usage. If common areas share the master meter and there is an installed landscape irrigation system, the rule requires deducting at least 25% of the bill; with no irrigation system, at least 5% (16 TAC § 24.281(e)(1)).
Then the formula. For an apartment house, the remaining amount is multiplied by one of several factors, among them: the actual number of occupants in the unit divided by all occupants; a ratio occupancy formula that must assign at least 1 for one occupant, 1.6 for two, 2.2 for three and 0.4 for each additional occupant; the average number of occupants per bedroom; or a combination of square footage and occupancy "in which no more than 50% is based on square footage" (16 TAC § 24.281(e)(2)).
Records tenants can inspect. Under 16 TAC § 24.277(e), the owner makes records available for inspection, including the utility's bills, the formula, occupancy factors and percentages, total occupants, square footage used and the total billed to all tenants each month. The owner may require a written request. Records kept at the on-site manager's office must be available there within three days; otherwise copies go to the on-site manager within 15 days, or, with no on-site manager, to the tenant's unit within 30 days (§ 24.277(g)).
That's Texas, for water and sewer; other states and cities set their own rules. ButterflyMX's RUBS guide advises rereading your leases and checking local law before you switch.
The utility binder: one folder per utility
Two columns make a binder better than a folder of bills. The period on the bill: a utility billing from the 15th to the 14th doesn't line up with your tenant's month by itself. And open questions: if a bill mixes in something that may not belong, that becomes a question for a person, not a guess. The template:
Utility binder, RUBS billing
Property: [address]
Billing period: [MM/DD/YYYY to MM/DD/YYYY]
Updated: [date], kept by [name]
No. | Utility | Period on bill | Bill on file | Amount [USD] | Allocation method per lease | Open question for a person
1 | Water | [MM/DD to MM/DD] | yes | [amount] | [e.g. ratio occupancy] | none
2 | Sewer | [MM/DD to MM/DD] | yes | [amount] | [same as water] | none
3 | Common area deduction| [period] | n/a | [amount or %] | [per local rule] | is irrigation metered separately?
4 | Trash | [month] | no | open | [e.g. per unit] | request invoice from hauler
5 | Gas, central boiler | [MM/DD to MM/DD] | yes | [amount] | [e.g. square footage] | bill spans two periods: how to split?
6 | [other per lease] | | | | |
Status per line: bill missing / bill on file, question open / done
Rule: a line without a bill stays open. Nothing is estimated or forced to match.
Also on file: occupants per unit, square footage per unit, the formula used.
File naming: one PDF per line, e.g. "01_Water_YYYY-MM.pdf"
Tenants will later ask by these line numbers. Scan paper bills right away; which apps read them cleanly is in Receipt Scanning Apps for German Businesses, and filing a stranger can follow is in Digital Receipt Filing in Germany: GoBD Rules.
Here an AI is strong: it reads a stack of bills, assigns each to a line, checks the period and writes the gap list. Tell it that a line stays open when in doubt, and ask for the source of every figure, as described in Summarize Texts and PDFs with AI.
Answering a tenant's records request
I know property management from the other side of the desk. My advice to anyone whose rent runs through a property management company: always cross-check everything. People who cross-check ask for records, so a request is a normal step, and a good binder answers it quickly.
Before sending, check that the file numbers match the tenant's line items, every file is readable, and nothing in the documents belongs to someone else. The reply:
Subject: Your request to review utility billing records, [period]
Hello [name],
thank you for your request of [date]. You're welcome to review the records
behind your utility charges for [unit] for [period].
[Option A, in person]
The records are ready at [office address]. Available times:
[date, time] or [date, time]. Please let me know which works for you.
[Option B, electronic]
The records are here for you: [portal or link]. They are sorted by
utility, and the numbers match the line items on your bill.
The file includes the utility bills, the formula and the figures used
for your share (occupants or square footage, as applicable).
If you only want to check specific charges, let me know which ones
and I'll put exactly those together.
Best regards,
[name]
[landlord or management company, phone]
The template answers the request, not a dispute; objections you answer yourself.
Spreadsheet, software or a billing company
The binder is the same on every route; what changes is who calculates. A spreadsheet works for a small building with a simple formula. ButterflyMX describes the other two: RUBS billing software that generates invoices, and billing service providers that analyze the property and set up the formulas. A provider calculates with what you hand over, so a complete binder is the best handoff, and you check the result against it. Ask providers for a written quote. Software for the whole management side is compared in Software for Property Managers Compared.
If you rent out property in Germany
In Germany the same job is the Nebenkostenabrechnung, the annual service charge statement. Section 2 of the Operating Costs Ordinance (BetrKV) lists the cost categories in 17 numbers, from property tax to "other operating costs"; the lease sets which apply and by which key. The binder works the same way, one line per category.
Two rules shape the workflow. Under Section 556(3) of the Civil Code (BGB), the statement must reach the tenant within twelve months of the end of the accounting period. Under Section 556(4), the landlord has to let the tenant inspect the underlying receipts on request and may provide them electronically.
The routes are the same three: a spreadsheet, software, or a property manager or billing service. Two examples with prices from the providers' pricing pages (as of November 2026, not from a test, not a ranking): WISO Vermieter 365 by Buhl costs 34.99 euros a year on subscription, VAT included, for up to 5 units; objego charges 0.95 euros per unit per month for its "Nebenkosten" tool, VAT included, with a 12-month minimum term. For a rented condominium, the owners' association statement comes first; see HOA Statement: How to Read and Review It.
Who does what: Peter, Frieda and you
Two roles in my business fit this workflow. The table shows how you use them.
Peter has been running in my business since August 19, 2026. He works in my bookkeeping interface in the browser: he screens new receipts, assigns each the correct receipt type, matches the credit card statement line by line and reports what doesn't add up. He follows a written process description; whatever isn't in it, he doesn't do, and he doesn't book entries. His page lists "Document missing receipts" as something this also works for. For utility billing, you describe once the utilities, where bills arrive and when a line is done; he learns it by reading along, you test it on real cases, you approve. Then he keeps the binder and reports what's missing.
Frieda sorts my inbox into four piles plus a fifth for cases that need my judgment, and prepares reply drafts. She has never sent anything on her own. You define which replies she may prepare; for a records request she fills name, unit and period into your template and leave the draft. Per her instructions, she doesn't touch legal disputes, not even to sort them.
How you put this into practice in your business is something we can look at together.
Limits: legal judgment and tenant data
The AI assigns, recalculates and drafts. Whether a charge is allowed, which formula applies and whether a deadline is met is for a person who knows the rules. AI models sometimes invent citations; how to spot that is in AI Hallucinations: Why AI Makes Things Up.
Leases and occupant counts are personal data and belong only in tools with a data processing agreement. My three questions before any input are in AI and Privacy: What the AI Gets to See.
Frequently asked questions
What is RUBS billing?
A Ratio Utility Billing System splits a building's utility bill among tenants by a formula instead of individual meters.
Is RUBS billing allowed everywhere?
That depends on your state, sometimes your city, and your lease. Texas, for example, regulates allocated water and wastewater billing in 16 TAC Chapter 24. Check your own rules before you switch.
Do I have to show tenants the bills behind their charges?
In Texas, for allocated water and wastewater billing, yes (16 TAC § 24.277); elsewhere, check your local rules. In Germany, Section 556(4) BGB gives tenants that right.
Can AI do RUBS billing?
It can prepare it: sort bills, report gaps, run the formula, draft the statement and replies. Whether a charge is allowed and the bill is right, a person decides.
What to do next
Take your last billing period and build the binder for one property using the template. Every open line is your to-do list for the coming weeks. Once every line says "done", the calculation is the smaller part. If the rent itself is overdue, see Late Rent Notice Template and Reminder Steps. More industries are on AI by Industry.
