# Free roommate expense tracker template

> Free roommate and flatmate expense tracker for Google Sheets and Excel: log shared costs, split them equally or by room size, and see who owes whom.

Canonical: https://www.traxpend.com/templates/roommate-expense-tracker
Last updated: 2026-10-16

A shared expense tracker for flatmates, roommates, PGs and hostels. Everyone’s shared costs in one sheet, split equally or by room size, with a balance for each person.

Download: https://www.traxpend.com/templates/traxpend-roommate-expense-tracker.xlsx

## What is inside

### Expenses

Every shared cost, from rent and Wi‑Fi to groceries, with who paid it.

### Balances

Each person’s share (equal, or by room size like 40/30/30), what they paid, and what they owe or are owed.

## Preview

| Person | Share | Paid | Fair share | Balance |
| --- | --- | --- | --- | --- |
| Aarav | 40% | 33,100 | 17,583.60 | +15,516.40 |
| Kabir | 30% | 5,179 | 13,187.70 | −8,008.70 |
| Ishaan | 30% | 5,680 | 13,187.70 | −7,507.70 |

## Limits

- Someone has to remember to add every expense, and it is fiddly on a phone.
- The sheet shows balances but not the fewest payments to settle them.
- There are no reminders before rent or the electricity bill is due.

## FAQ

### How do I split expenses by room size?

Set each person’s share on the Balances sheet, for example 40% for the biggest room and 30% for the two smaller ones. Our free rent split calculator can suggest shares from room sizes.

### Does it work in Google Sheets?

Download the file, open Google Sheets, choose File → Import → Upload, pick the file and select “Create new spreadsheet”. The formulas carry over.

### What does a negative balance mean?

A negative balance means that person has paid less than their share and owes money. People with a minus pay the people with a plus.

### Can I add more roommates?

Yes. Add a row on the Balances sheet, copy the formulas down, and make sure the shares still add up to 100%.

## Related

- [Rent split calculator](https://www.traxpend.com/tools/rent-split)
- [Traxpend for flatmates](https://www.traxpend.com/for/flatmates)
- [All templates](https://www.traxpend.com/templates)