When one housemate uses more, don't force every bill into a 50/50 split. Match the rule to the cost: rent may reflect room value, utilities can use a shared base plus an agreed usage adjustment, and groceries work best when personal extras stay personal.

Start with the bill, not the roommate. Who pays more depends on what you can measure, what everyone benefits from, and which tradeoffs the household accepts in writing.

Set a rule for each expense

Start with categories, not personalities. A roommate who works from home may use more electricity, but that doesn't automatically make them responsible for every increase on the bill.

Expense Practical starting rule Reconsider it when
Rent Split by room value, room size, and amenities One room has a private bath, much more space, or a major drawback
Electricity, gas, and water Equal split or a base-plus-usage method One person has clearly different occupancy, cooling, heating, or laundry use
Internet Equal split Someone does not use the service or the household agrees on another arrangement
Groceries Keep personal items separate and split shared staples One person eats most of a shared item or the household wants a shared food budget
Toilet paper and cleaning supplies Equal shared pool One person uses much more or buys most of the supplies
Deposits and moving costs Follow the lease terms and record each person's contribution One person pays upfront or a refund will not be divided equally

These are starting points, not measurements. Put the rule for every category in a shared document before the first bill arrives.

Choose the split that matches the cost

Equal splits suit fixed costs and low-conflict households. Internet is often easier to divide equally because everyone benefits from having it available.

Usage-based splits work when the difference is meaningful and can be estimated without constant arguments. Extra laundry, unusually heavy air-conditioning use, or a private appliance may justify a higher share.

Room-size splits usually fit rent better than utilities. If one bedroom is 400 square feet and the private bedrooms total 1,000 square feet, that room represents 40% of the private bedroom area. It should not automatically represent 40% of total rent, because everyone also uses the kitchen, living room, and other shared areas.

Income-based contributions solve a different problem. They address ability to pay, not consumption. Use this approach only if everyone agrees to discuss income, and record the agreed percentages instead of storing exact salaries in the household sheet.

Nights-stayed splits can work for short-term housemates or guests. They make less sense for a leaseholder who keeps a room and belongings in the home, even if that person travels often.

Thing is, there is no perfect formula. A rule people can understand and follow usually beats a precise-looking calculation nobody checks.

Write the house rules before move-in

One page is enough. The wording should answer who pays, how the amount is calculated, and what happens when the normal pattern changes.

Include these points:

  1. The expense categories and split method for each one.
  2. The person who posts each bill and the date it should be posted.
  3. The receipt or invoice required for reimbursement.
  4. The difference between personal purchases and shared purchases.
  5. How guests, partial months, move-ins, and move-outs are handled.
  6. The payment method the household accepts and the review date.
  7. What happens when someone disputes a charge or cannot pay on time.

Name the rule precisely. "We will be fair about electricity" invites debate. "Each person pays one-third of the agreed common portion, and the remaining amount follows the usage shares in the Rules tab" gives everyone something concrete to check.

Lease terms still matter. A housemate agreement can explain how roommates reimburse one another, but it does not automatically change a lease or an account holder's obligations.

Build a utility split without pretending it is exact

Utility bills combine household use, personal habits, weather, billing dates, and provider charges. You may know that one person runs the air conditioner more often, but you usually won't know the exact dollars that behavior created.

A hybrid rule can reduce the guesswork. For example, three housemates might agree that $60 of a $180 electric bill represents common household use. Each person pays $20 of that amount. The remaining $120 follows agreed usage shares of 50%, 30%, and 20%, producing total shares of $80, $56, and $44.

That $60 is an agreed household rule, not a magic number. The percentages are estimates unless a reliable measurement supports them. Label estimates clearly so nobody treats them as readings from a meter.

Post the invoice with its billing dates and any credits. Then apply the written base and usage rule, check that the individual amounts add up to the bill, and record the result in the shared sheet. Agree on any proxy, such as work-from-home use or an air-conditioning adjustment, before the bill arrives.

Start with one category for a trial month. Electricity is usually enough to show whether the extra tracking helps.

Keep groceries and consumables from becoming a daily audit

Groceries are not a utility meter. They are a pile of individual choices.

Turns out, a two-lane system handles most households better:

  • Personal items: Each person buys snacks, specialty foods, alcohol, supplements, and other items they mainly consume.
  • Shared staples: The household splits agreed basics such as cooking oil, salt, or cleaning supplies.
  • Group meals: The people eating the meal share its cost, unless the household has chosen a common food budget.

A roommate who eats most of a shared item can buy the next one personally or take a larger agreed share of the next grocery purchase. Don't build a forensic grocery ledger unless the savings justify the effort.

For recurring supplies, pick one routine and keep it visible. One person can buy the supplies and request reimbursement, or everyone can contribute to a shared amount. Change the routine if one person keeps paying upfront or another person consistently uses more.

Build a Google Sheet that shows the math

Your sheet should make the calculation visible, not make the household dependent on one person's memory.

Create four tabs named Rules, Expenses, Balances, and Receipts. The Expenses tab can use columns for Date, Billing Period, Category, Vendor, Total Amount, Payer, Split Method, each person's percentage share, each person's amount owed, Receipt Link, Paid Status, and Notes.

Use one row per charge. Do not use one row per argument.

If the total is in cell E2 and a person's percentage share is in H2, that person's owed amount can use =E2*H2. For a reimbursement, record the payer separately, calculate every participant's share, and subtract the payer's own share when showing the net amount others owe.

Keep formula cells separate from input cells. If everyone needs to add expenses, give the necessary housemates edit access, protect formula ranges where practical, and review sharing permissions before adding sensitive records. Don't store bank passwords, payment credentials, or exact income details in the sheet.

A spreadsheet tracks the agreement. It does not move money. Use a separately agreed payment method, then mark the row paid after the transfer actually happens.

The sheet doesn't need to be clever. It needs to be readable and updated before somebody asks, "Did you pay that?"

Make reimbursements easy to verify

Someone will front a bill. Treat that payment as temporary, not as a silent change to the split.

Post the receipt first, enter the calculation, and send a request that names the expense and amount. For example:

Shared electric bill: your calculated share is $56. The invoice and calculation are in the Expenses tab. Please send it by the household's agreed payment date.

Mark the entry as paid only after the money arrives. If someone disputes the amount, leave it pending, point to the written rule, and correct the row if the receipt or calculation is wrong.

If a housemate cannot pay the full amount, agree on a written repayment plan rather than quietly carrying the balance. To be honest, a clear short message beats "send me money" every time.

Review the system before resentment builds

A monthly review works well for recurring utilities, groceries, and household supplies. Scan for missing receipts, unpaid balances, duplicate entries, and categories that no longer match how the home operates.

When a number looks wrong, check the receipt first, then the billing period, then the split method, and finally the payment record. Fix the individual row before changing the entire system.

Change rules prospectively whenever possible. If the household switches from equal electricity shares to a usage estimate, start on a stated billing date instead of rewriting old charges without agreement.

Keep records for the life of the arrangement. For lease disputes, deposits, or account-holder responsibilities, follow the lease and applicable local rules rather than treating a roommate spreadsheet as legal advice.

Use wording everyone can repeat

A written rule can be short:

Electricity: We split the agreed common portion equally. We split the remaining amount using the percentages recorded in the Rules tab. The bill poster adds the invoice and calculation to the sheet. Everyone reviews the entry before reimbursement.

Adjust the category, percentages, and payment date for your household. The point is clarity.

Test the system on the next electric or grocery bill. Add the receipt, apply the written rule, let everyone check the row, and review the result after one month.