Roommate expense spreadsheet: a template for Excel or Sheets
A shared expense spreadsheet in Excel or Google Sheets is a free, flexible way to track what you spend as roommates. Set up well, it shows at a glance how much each person spent and who owes whom.
Below: the structure of the sheet, formulas you can copy, and the limits of the spreadsheet approach.
The columns
Create a sheet called "Expenses" with these columns (row 1 is the header):
| A | B | C | D | E |
|---|---|---|---|---|
| Date | Description | Category | Paid by | Amount ($) |
| 10/02/2026 | Groceries | Groceries | Alex | 90 |
| 10/05/2026 | Electricity | Bills | Sam | 60 |
| 10/07/2026 | Internet | Bills | Jordan | 30 |
Add every purchase as a new row. For equal splits you don't need another column; the formula works out the share.
A summary sheet and formulas
Create a second sheet ("Summary") and list the people in column A (Alex, Sam, Jordan). The formulas:
- Total spending:
=SUM(Expenses!E2:E500) - Equal share per person:
=B1/3(replace 3 with the number of people; put the total in B1) - What one person paid:
=SUMIF(Expenses!D2:D500, A4, Expenses!E2:E500)(A4 holds the person's name) - Net balance:
=B4-$B$2(B4 = what they paid, B2 = share per person). Positive means they are owed; negative means they owe.
In the sample data the total is $180 and each share is $60. Alex is +$30, Sam $0 and Jordan -$30: Jordan pays Alex $30.
Excel in other languages
In some language versions of Excel, function names and separators differ (for example SUM becomes a translated word and arguments are separated with semicolons). If a formula shows an error, check the function name and separator for your version. Google Sheets uses the English names shown above.
Unequal shares
For uneven splits, add a column per person in the Expenses sheet (F: Alex's share, G: Sam's share, H: Jordan's share). Make the shares add up to the bill. The net balance is what they paid minus the sum of their share column:
=SUMIF(Expenses!D2:D500, "Alex", Expenses!E2:E500) - SUM(Expenses!F2:F500)
That lets each expense use a different split.
Keeping the sheet tidy
- Use data validation on the date column so dates are entered in one format.
- Make the Paid-by column a drop-down list; a misspelt name breaks the balance.
- Freeze the header row so it stays visible as rows grow.
- Move old months to a separate sheet and take a backup copy at each month end.
Adding expenses from a phone with a Google Form
Connect a Google Form to the Sheet, and roommates can add expenses from their phones as if filling in a form; the data lands in the sheet automatically. Form fields: date, description, category, paid by (a list) and amount. It is far easier than editing a spreadsheet on a small screen.
The limits of a spreadsheet
- Equal-split assumption: custom shares make the formulas complicated.
- Discipline: if one person forgets to log, the balance is wrong.
- Phones: entering data in a spreadsheet on a phone is awkward.
- No approval step: nothing shows that a payment was made; you need a separate "paid" column.
As expenses grow or everyone wants to add from their phone, an app is easier. Ev Ortağım splits each expense, shows net balances and closes payments with both sides' approval; you can also export the month's summary as Excel (.xlsx) or PDF (Premium).
Frequently asked questions
How do I track roommate expenses in Excel?
Create an Expenses sheet with date, description, category, paid-by and amount. Divide the total by the number of people for each share and compare it with what each person paid to get their balance.
What is the formula for each person's share?
Total the spending with SUM and divide by the number of people: =SUM(E2:E500)/3. Add up one person's payments with SUMIF and subtract the share to get their net balance.
Spreadsheet or app for roommate expenses?
A sheet is enough for a small home with few expenses. With lots of expenses, custom splits and a need for mutual approval, an app is more practical.