Free template · Excel & Google Sheets

Free roommate expense tracker template

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 free template (.xlsx) Rent split calculator →

No sign-up, no email. Works in Excel, Google Sheets, Numbers and LibreOffice.

What’s inside

Expenses sheet: Every shared cost, from rent and Wi‑Fi to groceries, with who paid it.
Balances sheet: Each person’s share (equal, or by room size like 40/30/30), what they paid, and what they owe or are owed.

Preview, with sample data

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

Where a spreadsheet falls short

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.

In Traxpend, everyone adds expenses from their own phone, budgets warn you at 80%, recurring bills log themselves, and settle-up shows the fewest payments with a UPI QR or a PayPal or Venmo link. Free for up to five people. Traxpend for flatmates.

Questions

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%.