Free roommate expenses spreadsheet template (Excel and Google Sheets)

Rent is the easy part of sharing a place, because it is the same every month. The hard part is everything around it: utilities, groceries and household purchases paid by different people at different times, until nobody is sure who is ahead.

This post gives you a free roommate expenses spreadsheet for Excel and Google Sheets, explains what each tab does, and walks through a full month of sample numbers. No signup is needed, and it handles rent split by room size, which most free splitting templates do not.

The short answer

Download the roommate expenses template, type everyone's name and rent share on the Setup tab once, then log each bill on the Expenses tab as it lands: date, what it was, who paid and how much. Pick a split for each row: Equal for utilities and groceries, Rent shares for the rent, or Custom for anything uneven. The Balances tab shows who is up and who is down for the month and for all time, and the Settle up tab turns that into the fewest payments that clear everything. Once someone pays back, you log the repayment as its own row and the balance resets. The template holds up to six roommates and 300 expenses, and a month picker on the Setup tab switches every summary to the month you choose.

Download the template

Download the roommate expenses template (Excel, .xlsx). It is free, with no email and no macros. Prefer Google Sheets? Make your own copy in Google Sheets and it lands in your Drive with every formula, dropdown and check already working. Then share your copy with your roommates so everyone sees the same numbers.

What is inside: the six tabs

Step 1: set the rent shares once

Rent is the one bill most households do not split equally, because rooms are not equal. A bigger room, a private bathroom or a parking spot is worth more, and the fair answer is usually a percentage per person. If you have not agreed on one yet, how to split rent and bills with roommates walks through the options.

Type each roommate's share on the Setup tab. In the sample, Maya has the big room and pays 40 percent of the $2,400 rent, $960, while Jordan and Sam pay 30 percent each, $720. For three equal rooms, type =1/3 in each cell. The check beside the shares stays green only when they add up to 100 percent.

Step 2: log every bill as it lands

Each bill gets a row on the Expenses tab. The Split column decides who pays what:

• Equal splits the amount evenly across everyone on the Setup tab. Use it for electricity, gas, water, internet, shared streaming and household groceries. A blank Split counts as Equal.
• Rent shares splits the amount by the percentages on the Setup tab. Use it for the rent itself, and for anything else your household agrees should follow room size.
• Custom splits by the numbers you type in the white Custom columns on that row. Type exact amounts and you get exactly those amounts. Type 2, 1 and 1 and the first person pays half. Type 0 to leave someone out.

The shaded columns to the right show each person's share and a row check that flags any row that does not add up. You never have to edit a formula; inputs and results live in separate columns.

Step 3: settle up once a month

At the end of the month, open Settle up. It lists the payments that clear every balance in as few transfers as possible, usually one or two for three roommates. Once the money moves, log each transfer on the Expenses tab with the category Repayment, Paid by set to the person who sent it, Split set to Custom, and a 1 in the column of the person who received it.

Repayments clear the all-time balance without counting as spending, so the monthly totals stay honest. That is what lets the same sheet run for a whole lease without starting over each month.

A worked month: three roommates in October

The template ships with two months of sample data. Here is October for Maya, Jordan and Sam, with rent split 40/30/30 and everything else split equally, except Jordan's birthday dinner, which Maya and Sam covered between them:

The household spent $2,931 in October. Maya fronted the rent, so she is owed money; Jordan and Sam are each down. Settle up gives two payments: Jordan pays Maya $684 and Sam pays Maya $609. That is it for the month.

Using it in Google Sheets

The quickest route is the Google Sheets copy: one click puts your own editable copy in your Drive, with the sample data in place so you can see how it works. If you already downloaded the Excel file, File, Import, Upload works too, because the template only uses formulas that both apps support, so the splits, the checks, the month picker and the Settle up tab all behave the same. Sheets is the better home if all your roommates should be able to see and edit it from a link.

When a spreadsheet stops being the right tool

A spreadsheet works as long as one person keeps it up. The usual failure is not the formulas; it is that bills get paid on phones, in the moment, and the sheet only gets updated on Sundays, if then.

HippoSplit is the chat version of this template. Your household gets a group chat, and expenses live in the conversation. Type "internet 75 split equally" when the bill comes in, or post a photo of the bill straight into the chat, the same way you would send a picture to your roommates, and HippoSplit reads it and logs the expense. Rent can be set up once as a recurring monthly expense, split by shares or percentages like the Setup tab here, and when it is time to pay up, HippoSplit works out the fewest payments. Try it free.

Frequently asked questions

Is the roommate expenses template really free?

Yes. No email, no signup and no macros. It is a plain Excel file you can keep, edit and share.

Does it work in Google Sheets?

Yes. Make a copy of the Google Sheets version in one click, or import the Excel file with File, Import, Upload. The template sticks to formulas that Excel and Google Sheets both support, so nothing breaks either way.

How many roommates does it handle?

Up to six. Type a new name on the Setup tab and give them a rent share; their columns on the Expenses tab, the Paid by dropdown and the balances pick them up automatically.

How do I split rent by room size?

Set each person's rent share as a percentage on the Setup tab, then choose Rent shares in the Split column for the rent row. The template applies the percentages every month.

What if a roommate moves out mid-month?

Use a Custom split on that month's bills, typing each person's share or the number of days they lived there as weights. Then update the rent shares on the Setup tab for the next month. Roommate bill splitting for recurring rent, utilities and subscriptions covers the move-out math in detail.

Should utilities be split equally or by usage?

Equally, for most households. Measuring usage per person is rarely possible and causes more arguments than it saves money. The exception is an obvious outlier, like one roommate running a space heater all winter, which is a conversation to have before the bill, not after.

I only need to split one bill, not track a household

Then the bill split calculator is quicker, and for a one-off group like a trip, the general expense-splitting spreadsheet template is a better fit.

The bottom line

Roommates do not need a complicated system, just one place where every bill goes on the day it is paid, rent that follows the rooms, and a settle-up that happens on a schedule. This template does those three things.

Download the roommate expenses template or make a copy in Google Sheets, set the rent shares before the first rent day, and settle once a month. If the sheet starts to feel like a chore, the same setup runs in a HippoSplit group where the bills arrive as messages.