A RUBS template that does the math for you
Download the template, list your units, and drop it back in: each unit's charge, the owner's share and every flag.
| Ratiotally | A blank spreadsheet | |
|---|---|---|
| Method mix | Square feet, occupants, bedrooms and per unit in any blend | Write and check the formulas yourself |
| Vacant and part-month units | Days occupied built in; vacant shares stay with the owner | Extra formulas per unit |
| Rounding | Whole cents, largest remainder: charges plus owner share equal the bill | Charges often miss the bill by a few cents |
| Flags | Missing square feet or occupants, duplicate units, days past the period, optional Texas checks | None |
Honest take: a spreadsheet you already maintain works fine; keep it and drop it into Ratiotally to check the math.
FAQ
Is my data uploaded?
No. Your files are read by JavaScript in your browser tab and never sent to us or anyone else. Unit rows aren't stored, so closing the tab clears them. Settings can be saved in this browser if you ask.
What is RUBS?
RUBS (ratio utility billing system) splits a master-metered utility bill among units by a formula instead of a meter in each unit — usually square footage, occupants, bedrooms or a blend. The lease has to allow it and name the method.
How does Ratiotally split a bill?
It takes off the common-area deduction (the owner's), splits the rest across your method mix, and splits each method's slice by each unit's square feet, occupants, bedrooms or an equal share, scaled by the days the unit was let. Every amount is in whole cents and the leftover cents go to the largest remainders, so nothing is lost or invented.
Who pays for vacant units?
By default the owner: a vacant or part-month unit's square-foot, bedroom and per-unit share for its empty days stays with the owner. Occupant shares always go to the people who lived there. You can switch to spreading the vacant share over occupied units if your lease says so.
Does it follow the Texas rules?
Optionally. Turn on Texas checks to use the ratio occupancy and bedroom scales in 16 TAC §24.281 and get flags if the square-foot share is over 50%, the common-area deduction is under 5%, or the building has fewer than five units. It doesn't register you with the PUC or write your lease disclosures.
What's free?
Importing any number of units, every bill split exactly, the owner's share, every flag, 3 common-area what-ifs and 12 units on screen and in print (with a footer). Pro shows everything and adds the Excel workbook and CSV exports.
Is this legal advice?
No. Ratiotally applies the arithmetic it describes to the figures you provide. Billing tenants for utilities needs a lease that allows it, and states and cities set their own disclosure, method and fee rules. It is not affiliated with any utility or agency.