RUBS Utility Bill Splitter

Split one master-metered utility bill across units by square feet, occupants and an equal share, with move-ins, move-outs and vacancies prorated by day. The owner carries vacant days and any common-area share. Runs entirely in your browser; nothing is uploaded.

Utility (for statements)

Bill total ($)

Billing period start

Billing period end

Common-area deduction (%)

Admin or service fee per occupied unit ($)

Fee for partial months

% by square feet

% by occupants

% equal per unit

Units (CSV with columns Unit, Sq Ft, Occupants, Move In, Move Out, Vacant; the last three are optional. Move Out is the last day occupied.)

Open a CSV file

Not legal advice. Many states and cities regulate or ban ratio utility billing (RUBS), require it to be disclosed in the lease, set the allocation method, or cap admin and service fees. Some require a specific statement format. Check your local law and your leases before you bill tenants. This tool only does the arithmetic you set up.