Free Roommate Bill Split Spreadsheet (Excel & Google Sheets): Who Owes Whom, Settled Fairly

Splitting bills with roommates sounds simple until the third month. Someone paid the power bill, someone else covered the Costco run, the lease holder fronted the whole rent, and now nobody is sure who owes whom. A roommate bill split spreadsheet fixes that. Everyone logs what they paid, the sheet works out each share, and you settle up with a few quick payments instead of a long group chat.

This guide shows you how to split shared expenses fairly, what to track, and how to settle up with the fewest payments. You can grab our free roommate bill split spreadsheet for Excel and Google Sheets right below.

Roommate bill split spreadsheet showing who owes whom and the fewest payments to settle up

Free Roommate Bill Split Spreadsheet (Evenstead Free Sample)

XLSX · 72.8 KB · Free

Free sample of the Evenstead roommate bill splitter for Excel and Google Sheets: up to 4 roommates, 60 shared expenses, 4 split methods, balances and a fewest-payments settle-up list.

Enter your email and the file downloads straight away. Up to 3 free downloads a day. Privacy policy

What the free roommate bill split spreadsheet does

The free sample is a working spreadsheet, not a blank table. It handles up to 4 roommates and 60 shared expenses. Type the date, the amount and who paid. Pick how to split it. Each person’s share appears instantly, rounded so the shares always add up to the exact amount.

  • Four split methods: everyone equal, selected people, custom shares (like 2, 1, 1) and exact amounts
  • Move-in and move-out dates: a new roommate never pays for a bill from before they arrived
  • Balances for each person: what they paid, their share and where they stand
  • A settle-up list: the fewest payments that make everyone square, with each person’s Venmo or Zelle handle
  • A payments log: record every payback and watch the balances drop to zero

How to split bills with roommates fairly

There is no single right way. Most houses use a mix, and that is fine as long as everyone agrees up front. Here are the rules that cause the fewest arguments.

1. Split shared utilities evenly between the people living there

Power, gas, water, trash and internet are used by everyone. Split them evenly between the people who lived there during that billing period. If someone moved in on the 15th, use the end date of the bill as the expense date and the spreadsheet will only include people who were living there on that day.

2. Split rent by room, not by head

Even rent splits feel fair until one person has the primary suite with its own bathroom. A common approach is to split about 40% of the rent evenly (kitchen, living room, halls) and the rest by room size, with a premium for a private bathroom or balcony. Parking spots are charged separately. The full Evenstead spreadsheet has a Fair Rent Calculator that does this math and feeds it straight into your rent split.

3. Only split what you share

Groceries are where most disputes start. Shared staples like oil, coffee and toilet paper get split by everyone. Snacks for three people get split by three. Personal items are not shared at all. In the spreadsheet, pick “Selected equal” and put an x under the people who share that purchase.

4. Use custom shares when the split is uneven on purpose

Someone brought two guests to the cookout? Give them a share of 2 and everyone else 1. Someone has the premium streaming tier? Same idea. Custom shares keep it fair without anyone doing math on a napkin.

5. Treat refunds like negative expenses

Returned part of a group purchase? Log the refund as a negative amount and split it the same way as the original. Everyone’s share goes down by the right amount.

How to use the spreadsheet in 4 steps

  1. Settings: add your currency symbol, each roommate’s name, move-in date and payment handle.
  2. Expenses: log each shared cost. Date, description, amount, who paid and the split method.
  3. Settle Up: see each person’s balance. A plus means the house owes them. A minus means they owe the house.
  4. Payments: when someone pays another roommate back, log it. Balances update right away.

Pick one settle-up day a month, such as the 1st. Open Settle Up, send the payments on the list, log them, and you are done until next month.

How “fewest payments” works

Say five roommates all paid for different things. If everyone paid everyone back directly, you could need ten or more transfers. The spreadsheet does something smarter. It adds up each person’s balance, then has the person who owes the most pay the person who is owed the most, and repeats. A house of five never needs more than four payments, and usually fewer. The money still ends up in exactly the right place.

Six ways to split shared expenses in the Evenstead roommate spreadsheet

Free sample vs the full Evenstead roommate bill splitter

The free version is great for a small house that wants to try the system. The full Evenstead Roommate Bill Splitter is built to run a whole shared house all year.

FeatureFree sampleFull version
RoommatesUp to 4Up to 8
Expense rows601,500
Payments between roommates30400
Split methods46, adds Rent calculator and By income
Fewest-payments settle upYesYes
Household Dashboard with chartsNoYes
Recurring bills tracker with due dates and statusNoYes
Fair Rent CalculatorNoYes
Direct who-owes-whom gridNoYes
Monthly Report and Year SummaryNoYes
Roommate Statement for move-out dayNoYes
Step-by-step user guideNoYes

Features that matter most once you have a few months of data

  • Bills tracker: set up rent, power and internet once. Pick the bill on the Expenses tab and the category and split rule fill in. Each bill shows Logged, Due in 3 days or Overdue.
  • Move-out statements: pick a roommate and get their full account with an opening and closing balance. When someone leaves, you know the exact amount to settle.
  • Monthly reports: what the house spent, who paid and each person’s share by category. Easy to screenshot for the group chat.

Evenstead roommate bill splitter spreadsheet dashboard

Tips that keep a shared house calm

  • Log expenses the day they happen. Ten seconds now saves a long conversation later.
  • Let one person pay the landlord and log the rent once. Everyone else pays them back on the Payments tab.
  • Agree on the split rules for rent and groceries before the first month starts.
  • Share the file in Google Sheets so everyone can log their own expenses.
  • Keep people who moved out on the list with their move-out date, so the history stays correct.

FAQ

Does the free spreadsheet work in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets. It also works in Microsoft Excel.

Can I use my own currency?

Yes. Type your currency symbol on the Settings tab and every money label follows it.

What if we have more than 4 roommates?

The free sample handles 4. The full version handles 8 roommates, past and present.

Ready to stop asking “who owes whom?”

Download the free roommate bill split spreadsheet above, or get the full Evenstead Roommate Bill Splitter with the Dashboard, bills tracker, Fair Rent Calculator, monthly reports and move-out statements.

Get the free spreadsheetSee the full version

Scroll to Top