# Roommate expense tracker template for a spreadsheet or paper

Canonical URL: https://www.evenoutapp.com/templates/roommate-expense-tracker-template
Updated: 2026-10-06

A roommate expense tracker is a ledger with one row per purchase: date, item, who paid, amount, split rule and each person's share. A person's net balance is what they paid minus their total share. Positive means they are owed money, negative means they owe it. Settle by matching the biggest debt to the biggest credit until everyone reaches zero.

Key points:
- Log one row per purchase: date, item, who paid, amount, split rule and each person's share. The shares in a row must add up to its amount.
- Net balance is total paid minus total share. Positive means owed money, and every net in the house adds up to 0.
- Matching the biggest debt to the biggest credit settles four people in 3 payments. Settling row by row in the example would take 23.
- Log each payment as a row too (paid by the sender, shared by the receiver) so every net returns to $0.00.

## How to use this template

Keep one row per purchase and one sheet per month. The layout works on paper, in Excel and in Google Sheets.

1. **Log the purchase the day it happens.** The person who paid adds the row: date, what it was, who paid, the amount and the split rule, such as "Equal, all 4" or "Equal, not Cal".
2. **Fill in each person's share.** Add one share column per roommate to the right of the split rule. For $60.00 split four ways, type 15.00 in each column. Leave out anyone who is not in the split. The shares in a row must add up to the amount.
3. **Total each person.** With names in column C and amounts in column D, Ana's total paid is `=SUMIF(C2:C200,"Ana",D2:D200)`. Her total share is the sum of her share column.
4. **Work out the net balance.** Net is total paid minus total share. Positive means the person is owed money. Negative means they owe it.

When an amount does not divide evenly, one person pays a cent less so the shares still add up. Split $50.00 three ways as $16.67, $16.67 and $16.66, and rotate who pays the short one.

## The template

The ledger, one row per purchase:

| Date | What | Paid by | Amount | Split rule |
|---|---|---|---|---|
|  |  |  |  |  |
|  |  |  |  |  |
|  |  |  |  |  |
|  |  |  |  |  |
|  |  |  |  |  |
|  |  |  |  |  |

The balances, filled in at month end:

| Roommate | Total paid | Total share | Net (paid minus share) | Pays or receives |
|---|---|---|---|---|
|  |  |  |  |  |
|  |  |  |  |  |
|  |  |  |  |  |
|  |  |  |  |  |

## A worked example with eight rows

Say Ana, Ben, Cal and Dee log these in October. Cal was away for the pizza night, so that row is split three ways.

| Date | What (paid by) | Amount | Split rule | Share each |
|---|---|---|---|---|
| Oct 2 | Internet (Ana) | $60.00 | Equal, all 4 | $15.00 |
| Oct 4 | Groceries (Ben) | $84.00 | Equal, all 4 | $21.00 |
| Oct 6 | Cleaning supplies (Cal) | $28.00 | Equal, all 4 | $7.00 |
| Oct 9 | Electric (Ana) | $96.00 | Equal, all 4 | $24.00 |
| Oct 12 | Pizza night (Dee) | $45.00 | Equal, not Cal | $15.00 |
| Oct 15 | Groceries (Cal) | $60.00 | Equal, all 4 | $15.00 |
| Oct 20 | Water (Ben) | $48.00 | Equal, all 4 | $12.00 |
| Oct 27 | Trash bags and filters (Dee) | $20.00 | Equal, all 4 | $5.00 |

The total is $441.00. Seven rows are split four ways, which puts $99.00 on each person, and the pizza adds $15.00 for everyone except Cal.

| Roommate | Total paid | Total share | Net |
|---|---|---|---|
| Ana | $156.00 | $114.00 | Owed $42.00 |
| Ben | $132.00 | $114.00 | Owed $18.00 |
| Cal | $88.00 | $99.00 | Owes $11.00 |
| Dee | $65.00 | $114.00 | Owes $49.00 |

The people who are owed money total $60.00 ($42.00 plus $18.00), and the people who owe total $60.00 ($11.00 plus $49.00). If the two totals differ, a row has an error.

Settling each row on its own would take 23 payments. To net them, take the person who owes the most and the person who is owed the most, and have the first pay the second the smaller of the two amounts. Cross off whoever reaches zero and repeat. That never needs more payments than the number of people with a balance, minus one.

1. Dee pays Ana $42.00. Ana is done and Dee still owes $7.00.
2. Cal pays Ben $11.00.
3. Dee pays Ben $7.00. Everyone is at zero.

## The month-end close

Do these on a fixed day, such as the 1st.

1. Check that every row's shares add up to its amount.
2. Total paid, total share and net for each person. The nets must add up to 0.
3. Work out the payments and send them however you normally pay.
4. Log each payment as a row: paid by the sender, amount as sent, the whole amount in the receiver's share column. Dee's $42.00 to Ana is paid by Dee, $42.00, all in Ana's column. When every payment is logged, every net reads $0.00.
5. If someone has not paid, start next month's sheet with that debt as a row: paid by the person owed, shared entirely by the person who owes.

## What to agree on

- **Who adds rows, and by when.** Agree that the payer logs a purchase within two days. A row added three weeks later is hard to check.
- **What belongs in the ledger.** Shared items only. [What roommates should split](https://www.evenoutapp.com/guides/what-expenses-should-roommates-split) lists the usual ones, and [how to split groceries](https://www.evenoutapp.com/guides/how-to-split-groceries-with-roommates) goes through groceries in detail.
- **How long a row can be questioned.** Pick a window, such as seven days, after which a row stands.
- **A note column.** Anyone with edit access can change a row, so write a note when you do.

## When a spreadsheet stops being the easy option

A sheet records what you type and nothing more. Someone has to add every row, check every share and chase whoever owes. The ledger records what was spent. What you plan to spend each month belongs in a [roommate budget](https://www.evenoutapp.com/templates/roommate-budget-template).

An app can take over the netting. EvenOut's "Simplify debts" is a group setting, on by default, that cuts the number of payments needed without changing what anyone owes. Splits are cent-accurate, so the spare cent is shared out instead of lost, and rent and bills can repeat weekly, monthly or yearly on their own. "Settle up" records the payment, and the money still moves however you already pay. [The best apps to split bills with roommates](https://www.evenoutapp.com/alternatives/best-apps-to-split-bills-with-roommates) compares the options.

## Frequently asked questions

### How do you track rent in a roommate expense tracker?

If everyone pays the landlord directly, leave rent out of the ledger. If one roommate collects the money and pays the landlord, log one row paid by that roommate and put each person's room share in the share columns. Rooms of different sizes mean different shares in the same row.

### What if the net balances do not add up to zero?

A row is wrong. First check that each row's shares add up to its amount. Then check that every amount was typed once. Last, check that each payer's name is spelled the same everywhere, because SUMIF treats two spellings as two different people and skips one of them.

### How do you log a partial payment?

Add a payment row the day the money moves. Say Dee sends Ana only $30.00 of the $42.00 payment in the worked example: paid by Dee, amount $30.00, the whole $30.00 in Ana's share column. Dee's net moves from owes $49.00 to owes $19.00, and Ana's from owed $42.00 to owed $12.00.

### How often should roommates settle up?

Once a month on a fixed day is a simple rule to keep. Settle sooner when one person is fronting something large, such as a deposit or a furniture purchase, so that nobody carries a big balance for weeks.

## Sources

- [Microsoft: SUMIF function](https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b)
- [Google Docs Editors Help: SUMIF](https://support.google.com/docs/answer/3093583?hl=en)