Roommate budgets fall apart for boring reasons. Nobody agreed on what counts as shared. Or how each category gets split. Or when anyone actually pays up. Decide those three things before the first bill lands, and the spreadsheet stays what it should be: a record of choices already made.

Start with a short meeting before the next rent or utility payment. Bring the current bills, a rough estimate for variable costs, and any room differences that affect rent. Then choose the split, write it down, log costs as they happen, and settle the net balance once each month. The order matters.

Keep the budget separate from the expense tracker

Budgeting and tracking are two different jobs. A budget sets the amount the household intends to spend. The expense log shows what actually got paid and who's owed money back.

Budget tab. List recurring costs such as rent, internet, electricity, water, and shared supplies. Add a planned amount for variable categories too, including groceries or household goods.

Expense log. Every shared purchase gets its own row. Record the full amount paid, including any shared tax or tip.

Settlement log. Repayments go here, recorded after the month closes. A repayment is a settlement. It isn't a new utility or grocery expense.

Keep personal purchases out of the shared log unless everyone agreed to include them. That one boundary prevents plenty of confusion.

Start with categories people recognize. Rent, utilities, shared groceries, household supplies, and moving costs are usually enough. A category list that's too detailed rarely survives a busy month.

Set the rules before expenses arrive

Write the household rules before anyone fronts a bill. A dedicated sheet tab or shared document is easier to find than an old chat thread nobody can search two months later.

Good rules are boring. That's the point.

  • Say which costs are shared and which stay personal.
  • Pick a split method for rent, utilities, groceries, and anything else that recurs.
  • Name the person who pays each recurring bill, plus the date everyone else reimburses them.
  • Ask for a receipt, screenshot, or clear note on every shared charge.
  • Set an approval threshold for larger shared purchases.
  • Decide ahead of time how rule changes, refunds, cents, and move-outs get handled.

Put the date and every roommate's name on the note. Revisit it when someone moves in, leaves, changes rooms, or takes over a recurring bill.

Pick a fair split for each category

Rent needs its own conversation. Utilities and groceries usually need different rules.

Split method Best fit Tradeoff
Equal shares Rooms, shared spaces, and use are fairly similar Feels wrong when one room has a major advantage
Room-value or room-size split Bedrooms differ in size, privacy, bathroom access, storage, parking, or other features Everyone has to agree on how those differences get valued
Income-based split Roommates voluntarily want rent to take a similar share of an agreed income measure Takes trust, privacy, and a rule for updates
Usage-based or custom split A repeated difference is easy to document, like separate groceries or a dedicated parking space Too many exceptions make the system hard to maintain

Equal shares are often clearest for shared basics. Thing is, fair rent and fair utilities aren't always the same thing.

For an income-based rent split, use an agreed calculation: each person's income divided by the group's agreed total income, multiplied by total rent. Decide together whether that figure is gross pay, take-home pay, or something else. Nobody should be pushed into sharing more financial detail than they want to.

A blended rent split can work when rooms differ. Say three roommates owe $2,400 in total rent, and they decide that $1,200 of it covers access to the common areas, which means each person pays $400 of that portion before the rooms even enter the math.

They value the private-room portion at 50%, 30%, and 20%. The remaining $1,200 turns into $600, $360, and $240. Final shares: $1,000, $760, and $640.

Those numbers are only an example. The method is the useful part. Agree on the shared portion first, then price the room differences in the open.

For groceries, decide whether the household shares staples or most food. A roommate who buys specialty items, meal-preps alone, or eats out often may want those purchases kept separate. For temporary stays, a per-person or nights-stayed rule can be reasonable, as long as everyone can follow it without the sheet turning into a chore.

Build a roommate budget in Google Sheets

A shared spreadsheet handles most roommate households just fine. Use one row per actual charge, not one row per person who owes money.

Columns: Date, Category, Description, Total Cost, Paid By, one percentage column per roommate, and Receipt or Note. For three people, the structure might look like this:

Date | Category | Description | Total Cost | Paid By | Ali % | Bea % | Cam % | Receipt or Note

Enter a percentage on every expense row, even when the split is nearly always equal. It feels repetitive. It also makes exceptions visible instead of buried in memory.

With the total cost in column D and Ali's percentage in column F, her assigned share in J2 can be calculated with:

=IFERROR($D2*F2,"")

Format the percentage columns as percentages and make sure each row totals 100%. Copy the formula across each roommate's assigned-share column, changing the percentage reference as needed.

Your summary needs two numbers per roommate: what they paid and what they were assigned. If Ali appears in the Paid By column and her assigned shares sit in column J, a simple summary could use:

K2: =SUMIF($E$2:$E$200,"Ali",$D$2:$D$200)
L2: =SUM($J$2:$J$200)
M2: =K2-L2

Before settlements get recorded, a positive balance means the household owes Ali. A negative balance means Ali owes the group. Use absolute references, such as $E$2:$E$200, so the range doesn't shift when you copy it.

Give Editor access only to roommates who need to add or correct entries. Google describes Viewer, Commenter, and Editor access in its collaboration help. Keep sensitive information out of the sheet: no full bank account numbers, no passwords, no other private account details.

Use a monthly routine people will keep

Keep the routine short. If it drags, it fades.

  1. At the start of the month, fill in fixed bills. Add rent and recurring household costs with their expected amounts and payment dates.

  2. Log new shared charges promptly. Whoever pays should add the entry the same day when possible, or send the receipt and amount to the roommate handling the log.

  3. Check the sheet once a week. Look for missing receipts, unusual grocery spending, duplicate entries, or a bill that has no payer assigned.

  4. Review balances before a bill payer gets stuck waiting. If one roommate fronted the internet or utility bill, the group should see the amount before the provider's due date.

  5. Close the month with a net settlement. Calculate each roommate's final balance, record who paid whom, and mark that month closed.

Turns out, nobody wants to repay eleven small transactions one by one. Net the balances first. A $12 cleaning-supply entry matters less than whether everyone can trace it later.

Repayments go on the Settlement tab with the date, payer, recipient, amount, and the month being closed. Never log that payment as another household expense, or the monthly total gets counted twice.

Handle exceptions without improvising

Real households don't stay perfectly still.

Guests and long stays. Decide whether frequent guests affect groceries, utilities, or shared supplies. For an extended stay, check the lease and any building rules before treating that person like an informal roommate. Local requirements vary.

Refunds and bill credits. Apply a credit with the same split as the original expense, unless the group agrees on another approach before settling.

Missing receipts. Mark the expense as pending instead of guessing. Add the final amount once the receipt or bill arrives.

Someone moves out. Close the expense log through their last day, settle shared bills, and preserve the record. For security deposits, lease changes, or property damage questions, the lease and applicable local rules are the controlling documents. A roommate spreadsheet only records the household's arrangement.

Copy this roommate money agreement

To be honest, most conflicts don't start with a big bill. They start when two people remember a vague conversation differently.

Use this as a starting note, then edit it together:

Month: [month and year]
Rent split: [equal, room-value, income-based, or another agreed method]
Utilities split: [method]
Shared groceries and supplies: [what is included and excluded]
Bill payers: [name and bill for each recurring charge]
Logging rule: The payer adds the charge and receipt by [agreed time].
Settlement date: Net balances are paid by [agreed date].
Approval rule: Shared purchases above [agreed amount] need group approval first.
Changes: Any new rule gets written in the group chat or Budget Rules tab before payment where possible.

Place the final version where every roommate can see it. Review it whenever the household changes, even if the change seems small.

Questions roommates often ask

Should rent and utilities use the same split?

Not necessarily. Rent reflects room value and access to the home. Utilities usually reflect shared household use, so an equal split may make more sense unless there's a clear, ongoing difference everyone agrees to recognize.

What if one roommate wants an income-based rent split?

Treat it as voluntary. Room value and affordability are separate concerns, and roommates may prefer a room-based split, an income-based split, or a blended approach. The important part is consent and a written calculation.

Do we need a bill-splitting app?

No. A shared spreadsheet, receipt folder, and regular settlement date work well for plenty of households. An app may suit a group with frequent expenses, but it can't settle a decision nobody made about what's fair.

Open a blank sheet, list next month's fixed bills, and ask each roommate to approve one written split rule before anyone pays the next shared charge.