To split shared expenses between roommates, copy each shared payment from everyone's bank statements into one sheet, add up what each person paid, and compare it with their share. The difference is what each roommate owes or is owed. Settling once a month with one payment per person beats chasing dozens of small transfers.
Which roommate expenses belong on the shared sheet?
Roommate expenses belong on the shared sheet when everyone in the home benefits and everyone agreed to split them: rent, utilities, internet, household supplies and, if you shop together, groceries. Personal spending stays off, even if it was bought on the same trip. Agree on the list before the first month, not after.
A typical shared list:
- Rent, often paid in full by one roommate to the landlord.
- Electricity, gas and water.
- Internet, and a streaming service only if everyone uses it.
- Household supplies, such as cleaning products, toilet paper and bin bags.
- Shared groceries, if the household cooks together.
- Repairs or furniture for common areas, agreed in advance.
Things that usually stay personal: takeaway for one person, toiletries, a phone bill, and anything kept in someone's own room.
Building a roommate expense sheet from statement rows
A roommate expense sheet built from statement rows starts with each person exporting the month's transactions, picking out the shared ones and pasting them into one table with columns for date, description, amount and who paid. Statement rows beat memory because the amounts are exact and the dates are fixed.
Steps for the end of each month:
- Each roommate downloads the month's statement or activity export for the accounts they paid shared bills from.
- Each person copies the shared rows into the household sheet, adding their name in a "Paid by" column.
- Someone checks for doubles, such as a grocery run two people both entered.
- The sheet totals each person's payments with a simple sum per name.
If your bank offers only a PDF, copying rows by hand is where mistakes start. Converting the statement to a spreadsheet first lets you filter and copy the shared lines in a minute. CheapBankConvert will do that for a single payment per statement once it opens, and a statement of two pages or fewer converts free (details on the homepage).
One card sometimes pays every shared bill to earn rewards, with the others paying the cardholder back. That works if the group agrees who keeps the points. If the card carries a fee, the analysis of whether a credit card annual fee is worth it helps the cardholder judge whether the shared spending actually covers it.
Who owes whom at the monthly roommate settle-up?
At the monthly roommate settle-up, each person's balance is what they paid minus their share of the total. A positive balance means they are owed money; a negative balance means they owe. People who owe pay people who are owed, and the balances always add up to zero, which is a quick check on the arithmetic.
A worked example, with example values
Three roommates share equally. These figures are made up for illustration.
| Expense | Paid by | Amount |
|---|---|---|
| Rent | Ana | $2,400.00 |
| Electricity | Ben | $120.00 |
| Internet | Ben | $60.00 |
| Groceries, two shops | Ana | $90.00 |
| Groceries, one shop | Cara | $180.00 |
| Total | $2,850.00 |
Each share is $2,850 divided by three, or $950.
| Roommate | Paid | Share | Balance |
|---|---|---|---|
| Ana | $2,490.00 | $950.00 | +$1,540.00 |
| Ben | $180.00 | $950.00 | -$770.00 |
| Cara | $180.00 | $950.00 | -$770.00 |
So Ben pays Ana $770 and Cara pays Ana $770. Two transfers settle the whole month. The balances, +1,540, -770 and -770, add up to zero, so nothing was missed.
Uneven roommate splits: bigger rooms, guests and time away
Uneven roommate splits make sense when equal shares would be unfair, such as one bedroom being much bigger, a partner who stays most nights, or a roommate away for a month. The fix is a share percentage per person, agreed in writing, instead of dividing by the headcount. Each expense type can have its own percentage.
Common adjustments:
- Rent by room size, for example 40% for the large room with a private bathroom and 30% for each of the others.
- Utilities by people, not rooms, so a partner who stays over counts as an extra share of electricity and water.
- Groceries only for those who eat them, with a separate column for who joined each shop.
- A month away might drop someone's utility and grocery share but not their rent.
Put the percentages in a row at the top of the sheet and let the share column use them. Changing the agreement then means changing one number, not every formula.
When a roommate stops paying their share
When a roommate stops paying their share, start with the sheet: send them the month's table, their balance and the statement rows behind it, and ask for a date. Often the cause is forgetfulness or a short month. A clear record makes the conversation about numbers instead of character.
If several months go unpaid, put the request in writing with the running total. Keep the sheet, the statements that show who paid what, and the messages where the split was agreed. That record is your evidence if you ever need it. The guide to using bank statements for small claims court explains how to present payments like these to a judge.
Clean records help the other side too. A roommate applying for a job that needs a background check may face questions about unpaid debts, and the post on security clearance financial records shows how investigators look at money owed. Settling every month keeps everyone's record simple.