Agree on two layers: a default split for necessities and a separate rule for optional upgrades. Equal shares work when rooms and usage are comparable. An optional upgrade needs a separate yes, and that yes should be visible in your records.
Before move-in, or at your next house meeting, decide what counts as a basic, who can opt into extras, and when balances get settled. Rutgers' roommate and cotenant guidance recommends writing down responsibilities, household purchases, and the rent division. The University of Colorado's off-campus roommate tips also encourages shared ground rules.
Written rules beat memory.
Set the baseline before discussing upgrades
Start with the costs your college house expects to share. Rent, agreed utilities, internet, trash, and cleaning supplies often belong in this category. Groceries need more care because roommates may eat differently or buy personal items.
Turns out, the simplest default is equal shares when bedrooms, common areas, and typical use are broadly similar. If rooms differ substantially in size or features, agree on fixed rent amounts before anyone signs or moves in. Room-size adjustments make more sense for rent than for every household bill.
Assigning each utility to a different roommate can spread out the administrative work. Everyone still needs to know the bill's due date, the reimbursement rule, and where the receipt goes.
An income-based split is another option, but it should be voluntary. It may reflect ability to pay, while also requiring more personal financial information and more discussion. Don't assume the roommate with the larger paycheck automatically owes more.
Choose a split method for each expense
One formula rarely fits every bill. Use the least complicated method that reflects a real difference.
| Expense | Sensible starting point | Change it when | What to record |
|---|---|---|---|
| Rent | Equal shares if rooms are similar | Bedrooms or private features differ | Each person's agreed monthly amount |
| Utilities | Equal shares | Usage differs materially and the group agrees | Bill, date, and participants |
| Household supplies | Equal among people who use them | Someone does not use the item | Buyer and participating roommates |
| Groceries | Separate by default, with shared staples by agreement | The house wants a shared grocery plan | Receipt lines and participants |
| Optional upgrade | Buyer pays unless others opt in | The group adopts it as a new basic | Basic cost, added cost, and opt-ins |
Keep the rule specific. "We split groceries" creates arguments. "We split shared breakfast items, but personal snacks stay separate" gives everyone something usable.
Make the nicer option opt-in
Make an upgrade opt-in, not opt-out. A roommate who stays silent has not agreed to pay.
- Describe the exact upgrade. Name the item or service, its total price, and how often it recurs.
- Separate the basic cost from the extra cost. For a faster internet plan, record the basic plan and the additional premium. For a separate premium product, the full price may be optional.
- Ask for a clear yes or no. A group message can work, but save the decision in the sheet or roommate agreement.
- Have the buyer pay upfront. At checkout, the buyer has fronted 100% of the cost.
- Record final shares after people opt in. The buyer gets a share, other opt-ins get their shares, and everyone else is recorded at 0%.
- Set a review point for recurring upgrades. Decide how someone leaves the arrangement and what happens if nobody wants to continue.
If a hypothetical premium coffee purchase costs $20, Alex can buy it, Jordan can opt in, and Casey can decline. Alex and Jordan each carry a $10 share, while Casey carries $0. Alex paid the full $20 initially, so Jordan reimburses Alex $10.
If nobody opts in, the person who proposed the upgrade can cover it alone or drop the idea. That choice should be made before the purchase, not after the bill arrives.
Separate a shared basic from a premium choice
A nicer version of a shared service can be partly shared and partly personal. If everyone agrees to a basic internet plan, split that basic cost among the household. Only the roommates who choose the faster plan should split the added amount.
If the group does not want the premium service at all, the requester can pay the full cost or use the basic option. Don't quietly turn a personal preference into a house bill.
Groceries work the same way. Put agreed household staples on shared rows, then mark personal or premium items separately. One receipt can still work if the sheet records the participants for each line.
Thing is, the receipt matters less than the rule. A clear rule can handle one receipt, several buyers, or a recurring delivery.
Build a sheet that shows each balance
A shared Google Sheet is enough for a small roommate group if everyone updates it. Keep one Expenses tab and one Balances tab. The tracker records obligations; it does not process payments.
Use columns that make the decision visible:
| Column | What to enter |
|---|---|
| Date | Purchase or bill date |
| Description | Internet, cleaning supplies, premium coffee, or another clear label |
| Category | Basic, personal, shared grocery, or opt-in upgrade |
| Total | Full amount paid |
| Paid By | Roommate who fronted the money |
| Person share | One column for each roommate's final share |
| Receipt link | Photo or file stored in the group's shared folder |
| Status | Open, paid, or under review |
| Notes | Opt-in decision, due date, or unusual split |
Enter the final agreed share, not just the amount the buyer paid. For an opt-in purchase, people who declined should show zero in their share column.
Suppose the Expenses tab uses column D for Total, column E for Paid By, and column F for Alex's share. Alex's balance can use:
=SUMIF(Expenses!E2:E100,"Alex",Expenses!D2:D100)-SUM(Expenses!F2:F100)
A positive result means the group owes Alex. A negative result means Alex owes the group. Copy the same approach for each roommate, changing the name and share column.
Let everyone edit expense rows, but protect headers and formula cells if the spreadsheet supports it. Link receipt photos rather than leaving the amount unexplained. Avoid putting bank account details or other sensitive information in the sheet.
Review and reimburse on a schedule
Choose a cadence before balances grow. Biweekly reviews suit houses with frequent grocery and supply purchases. Monthly reviews can work when spending is light and predictable.
To be honest, a short review is easier than reconstructing a month of receipts later.
- Add each expense promptly and attach the receipt.
- Confirm the participants on every opt-in row.
- Check the balance for each roommate.
- Send a request with the exact amount and expense description.
- Mark the reimbursement complete only after it arrives.
- Decide whether to carry a small balance forward or settle it now.
A clear message sounds like this:
The sheet shows I paid $20 for premium coffee. You opted in, so your share is $10. Please mark it paid after you send it.
Use whatever payment method the group accepts. Record the payment date in the sheet so the tracking record and the payment history do not drift apart.
If someone disputes a charge, review the receipt and the agreed rule together. If an expense has no receipt and nobody can verify the amount, the group can decide whether to estimate it, waive it, or record a different amount.
Put the rule in writing
A roommate agreement does not need to be formal or long. It needs to answer the questions that cause friction later.
You might write:
Basic rent and agreed utilities follow the amounts listed in the sheet. Optional upgrades are personal unless a roommate opts in before purchase. The buyer records the receipt, final shares, and reimbursement status. Recurring upgrades are reviewed before the next billing period.
Add the due date, the person responsible for each provider account, and the process for changing an opt-in. Include what happens if someone moves out or a new roommate arrives. Read the lease and utility contracts separately; an internal reimbursement agreement may not change duties set by those documents or by local law.
For a lease dispute, use a local tenant resource rather than assuming the spreadsheet decides who is legally responsible.
Start with the next receipt
List your current expenses and label each one basic, personal, or opt-in. Then create the tracker before the next purchase, add one real expense, and ask everyone to confirm the split.
If the row needs a long explanation, the house rule needs more work. Fix that rule while the decision is still fresh.