A utility bill-back spreadsheet that does the math
One row per unit with square feet, occupants, bedrooms and days occupied; Ratiotally splits each bill and flags what's missing.
How the split works
Enter each master bill and the share of it that is for common areas (the owner's). The rest is split across your method mix — for example 50% by square feet and 50% by occupants — and each method's slice is split by each unit's square feet, occupant count, bedroom count or an equal share. A unit let for only part of the billing period counts for its days. Every amount is in whole cents and the leftover cents go to the largest remainders, so unit charges plus the owner's share equal the bill exactly.
Keep one row per unit: unit, tenant, square feet, occupants, bedrooms and days occupied. Missing square feet or occupant counts, duplicate units and days longer than the billing period are flagged. Pro exports a charge line per unit and bill to post in your rent software.
Your figures stay on your computer
Ratiotally reads your file with JavaScript in this browser tab. Nothing is uploaded, and the rows are gone when you close the tab.
How it works
- List the units — unit, square feet, occupants, bedrooms and days occupied — in the template, or try the sample.
- Enter the master bills, the common-area deduction and your lease's method mix.
- Print the split with every unit's charge, or export the charge lines to post in your rent software.
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.