How to Split Utilities by Percentage: Fair Rules for Roommates

✨ Community Finance

Published: May 7, 2026

Split utilities by percentage using formulas like (person's income divided by total household income) times the bill amount for income-based splits, or (person's room square footage divided by total square footage) times the bill amount for space-based splits. Start with a group agreement on the method to set clear expectations.

This approach helps U.S. roommates or housemates manage recurring bills like electricity, water, or internet. Document the chosen percentages in a shared note or spreadsheet. Update shares monthly when bills arrive, and review the rules every few months to maintain fairness.

Decide on a Percentage Split Method for Utilities

Household members often split utilities evenly, but percentages can better reflect differences in income, space, or usage. Consider income-based splits when earnings vary widely, as they aim for equity by tying shares to financial capacity. For instance, Subset's proportional splitting guide describes dividing bills by each person's income relative to the total.

Room-size splits work for objective fairness based on occupied space, especially in homes with unequal bedrooms. Custom percentages, set by group agreement, allow flexibility for factors like remote work or family size, per MemoGo's split bill guide.

Tradeoffs matter. Income splits promote equity but require sharing sensitive financial details, which not everyone may want. Room-size splits are straightforward and measurable but overlook actual usage, like one person running air conditioning more. Equal splits (100% divided by headcount) are simplest yet may feel unfair if incomes or spaces differ. Discuss as a group: "What factor feels fairest: income, room size, custom shares, or equal?" Agree in writing before the first bill.

Calculate Percentages with Simple Formulas

Once the method is set, calculate shares step by step. For income-based splits, list each person's monthly income, sum the total, then find each share as (person's income divided by total income) times 100 for the percentage. Apply to the bill: percentage times bill amount.

Example: Two roommates with incomes of $6,667 and $3,333 (total $10,000) on a $100 bill. First person's share: ($6,667 / $10,000) = 0.6667 or 66.7%, times $100 = $66.70. Second: 33.3% or $33.30.

For room size, measure each person's space in square feet, sum the total, then (person's square footage / total) times the bill. Example: Rooms of 100, 150, and 200 square feet (total 450) on $100 bill. Shares: $22.22, $33.33, $44.44.

Custom percentages skip measurements: Assign shares like 40%, 30%, 30% based on agreement, then multiply each by the bill. Double-check math on paper first, then automate in a spreadsheet. These steps assume honest inputs; verify totals match 100% or the full bill.

Set Up a Spreadsheet to Track and Automate Splits

Google Sheets offers a free, shareable way to automate percentage utilities splits. Create columns: Date, Utility Type, Total Bill Amount, Person Name, Income (or Room Sq Ft), Total Income (or Total Sq Ft), Percentage, Share Amount, Paid By Whom, Reimbursed? (Yes/No).

In the Percentage column (e.g., column G), enter =E2/$B$10 for income-based (E2 is person's income, B10 is locked total). For Share Amount: =G2 * C2 (percentage times bill). Use $ for absolute references to totals.

Example rows:

Date	Utility	Total Bill	Person A Income	Total Income	%	Share	Paid By	Reimbursed
1/15/26	Electric	$120	5000	12000	=D2/$E$2	=F2*C2	Person A	Yes/No

Share via link with view-only for most, edit access for a trusted updater. Per ExpenseSorted's roommate template, mark the initial payer at 100% and others at 0% until reimbursed.

Update monthly: Enter bill on pay day, calculate shares, note payments. Common mistakes include forgetting to lock totals (causing errors when copying formulas) or not archiving old months in a new tab. Set notifications for changes.

Establish Rules and Review for Ongoing Fairness

Clear rules prevent disputes. Hold a kickoff meeting with this script: "Let's agree on our split method: income, room size, custom percentages, or equal? What if someone moves out or income changes?" Write the decision, including how to measure rooms or incomes, and sign digitally.

Store bills: Scan receipts or PDFs in a shared folder, noting the total and date. Track payments in the spreadsheet; request reimbursements promptly, like "Per our sheet, your $25 share for January water is due by the 10th."

Review every 3-6 months, or after events like job changes or new roommates. Script: "Has anything changed with incomes, space, or usage? Adjust percentages if needed." Include opt-out clauses, such as 30 days' notice to switch methods.

For recordkeeping, export the sheet quarterly as PDF. This lightweight documentation supports discussions without complexity. If tensions rise, revisit the original agreement to refocus on facts.

FAQ

How do I handle uneven utilities usage if no sub-meters exist?

Estimate via custom percentages from group input, or stick to income/room size. Without meters, usage-based splits rely on trust; consider equal as a neutral fallback.

What if someone refuses to share income for percentage splits?

Switch to room size or custom percentages that don't require financial details. Agree upfront on alternatives to avoid stalemates.

Can I use these percentages for rent too, or just utilities?

These work for any recurring bill if agreed, but rent often follows separate rules like per room. Keep utilities distinct unless the group votes to align.