To split utilities by percentage, choose what the percentage measures, make all shares total 100%, and apply each share to the current bill. The math is simple. The agreement takes more care.

For example, a 30% share of a $120 electric bill is $36. That percentage could represent income, room size, nights stayed, or an agreed estimate of usage.

A percentage is not automatically fair. It is fair only when the household agrees that the underlying measure makes sense.

Choose what the percentage represents

Start with the reason behind the split. Different methods answer different fairness questions.

Method Share formula Works better when Main limitation
Equal per person 100% divided by the number of people Everyone has similar access and routines It ignores income, space, and unusual usage
Income-based Person's agreed income divided by total agreed income The household wants contributions tied to ability to pay It requires a shared definition of income and some financial privacy
Room-size-based Private room square feet divided by total private room square feet Bedrooms differ significantly in size Room size does not measure appliance use, water use, or heating
Nights stayed Person-nights divided by total person-nights Someone occupies the home part time It tracks occupancy, not necessarily consumption
Usage estimate Agreed usage weight divided by total usage weights The group understands whose routines drive a bill Estimates can become a source of disagreement
Hybrid A stated combination of two methods The household wants to separate shared access from heavier use It takes more explanation and recordkeeping

Equal shares are usually easiest to explain. Per-person shares can also handle a couple or family living with single roommates, but agree whether every person counts separately.

Income shares measure ability to pay, not electricity consumed. Room-size shares measure private space, not shower length or computer use. Turns out, that distinction matters more than the formula.

A hybrid rule can separate different parts of a bill. If a statement clearly separates a fixed service charge from a usage charge, the group could split the fixed part equally and apply another agreed method to the variable part. Do not guess at line items that the bill does not identify.

Put the rule in writing before the first bill

A short roommate agreement prevents many repeat arguments. It does not need legal language.

  1. Name each bill and billing period. List electricity, water, gas, internet, trash, or any other shared charge separately.
  2. Choose the method for each bill. You can use one method for everything, or use different methods for internet and electricity if the group agrees.
  3. Define the inputs. For income, decide whether everyone uses gross income, take-home income, or another consistent figure. For room size, decide which private areas count and measure them the same way.
  4. Decide how changes work. Cover a new roommate, a move-out date, a long-term guest, a part-time occupant, and a major change in work or living routines.
  5. Set the payment process. Name the person who pays the provider, the reimbursement deadline, the rounding rule, and the place where receipts are stored.
  6. Save the approved percentages with the date. Each roommate should be able to see the rule that applies to the bill.

A shared note is enough for a small household. The sheet should show the rule, the bill, the payer, and the status. All of it.

If a lease or utility account assigns payment duties to a named person, an internal roommate agreement may not rewrite that contract. Lease terms and local rules vary, so check the lease before treating the spreadsheet as a substitute for those obligations.

Calculate each person's share

Use two operations for every bill:

share percentage = person's weight / total household weight

amount owed = bill total x share percentage

The weight depends on the method. For an income split, the weight is income. For a room-size split, it is square footage. For a custom split, the agreed percentage can be entered directly.

Suppose three roommates have agreed monthly incomes of $5,000, $3,000, and $2,000. The total is $10,000. Their shares are 50%, 30%, and 20%. On a $120 bill, they owe $60, $36, and $24.

A room-size example looks different. Rooms measuring 100, 150, and 200 square feet total 450 square feet. On a $100 bill, the unrounded shares are 22.222%, 33.333%, and 44.444%. After rounding to cents, the amounts become $22.22, $33.33, and $44.45.

Round dollar amounts after multiplying. Do not round the percentage first if you can avoid it. If the rounded amounts miss the bill total by a cent, assign that cent to a named person and record the adjustment.

Custom shares skip the weighting step. If the group approves 40%, 30%, and 30%, multiply each percentage by the bill. Check the total first.

Income-based math also needs a policy for zero or changing income. A zero in the formula might mean a zero share, or the group might agree on a minimum contribution. The spreadsheet cannot make that choice for you.

Build a spreadsheet that keeps the rule visible

A useful tracker separates household assumptions from monthly transactions.

On a People tab, use columns for Name, Weight, Percentage, Effective date, and Notes. Put the total weight in a clearly labeled cell. On a Bills tab, use Bill ID, Date, Utility, Total bill, Person, Percentage, Amount owed, Paid by, Payment date, Status, and Receipt note.

For a simple income example, place each person's income in B2:B4 and the total in B5. Enter =SUM(B2:B4) in B5, then enter =IFERROR(B2/$B$5,0) in C2 and copy it down. The dollar signs keep the total reference fixed when the formula moves.

On the bills tab, if the total bill is in D2 and the approved percentage is in F2, enter =ROUND(D2*F2,2) in G2. Format the percentage cells as percentages, so a stored value of 0.5 displays as 50%.

Google's Sheets formula help covers functions such as SUM and formula editing.

Keep one row for each person's share of each bill. That means the same bill total may appear on several rows. Do not add those repeated totals together when checking household spending; sum the amount-owed column instead.

Add a check cell such as =SUM(C2:C4) on the People tab. It should equal 100%. A second check can compare the total owed for one bill with the bill itself.

Use the approved percentage on old bills rather than letting a later change rewrite history. If a person's income changes in May, record a new effective date and preserve the earlier percentage for April.

Give edit access to the person who maintains formulas and view access to others when your spreadsheet tool supports those settings. If income is sensitive, calculate the percentages privately and record only the approved percentages in the shared file.

Track the payer separately from the amount owed

The person who pays the provider may not owe the entire bill. Record both facts.

Suppose roommate A pays the full $180 electric bill. The agreed shares are 50%, 30%, and 20%. A's own share is $90, while roommate B owes $54 and roommate C owes $36. The sheet should show one provider payment by A and three household obligations.

Keep payment status separate from the formula. Useful labels include owed, requested, and received. Do not mark a reimbursement complete just because someone sent a request.

A clear reminder sounds like this: "The electric bill is $180. Your share is $54. Please mark it received in the sheet after payment."

Thing is, a correct formula will not settle a disagreement about the rule. When someone challenges a charge, show the bill, the approved percentage, the input used, and the calculation. That keeps a math question separate from a fairness question.

Record refunds and credits against the bill that produced them. Do not quietly change next month's percentages to compensate.

Review the split when the household changes

Fixed percentages can handle changing bill amounts without a new negotiation every month. Enter the new total, apply the approved shares, and check the rounded amounts.

Reopen the agreement if:

  • Someone moves in or out.
  • A person begins staying at the home regularly or stops doing so.
  • The agreed income measure changes.
  • A bedroom, private bathroom, or occupancy arrangement changes.
  • The household adds or removes a shared bill.
  • One person's usage becomes materially different from the assumption behind the rule.

Review the arrangement every few months. Review it sooner after a major household change.

Keep dated copies of the People tab and the bills. A simple export or duplicate sheet makes it easier to explain why an earlier bill used a different percentage.

Frequently asked questions

What if someone does not want to share income?

Use room size, equal shares, nights stayed, or custom percentages instead. Another option is for each person to calculate privately and share only the resulting percentage, if everyone trusts that process.

What if utility usage is uneven but there are no sub-meters?

Use an agreed estimate and label it as an estimate. If the group cannot agree on a reliable usage adjustment, an equal or per-person split may be easier to defend than a precise-looking guess.

What if the bill changes every month?

Keep the percentages and recalculate the dollar amounts from the new total. A $200 bill and a $260 bill can use the same shares.

Can the same percentages be used for rent?

The arithmetic works, but rent and utilities are separate decisions. Rent may reflect private space, shared areas, parking, or lease terms, so do not transfer a utility rule without a new agreement.

Before the next bill arrives, write down the chosen method, enter one real bill in the sheet, and ask each roommate to confirm the percentage before anyone pays.