Roommate Expense Tracker: Splitting Bills Fairly

Three roommates I know keep a Google Sheet called APARTMENT $$$. It has tabs for rent, utilities, and groceries, a color-coded balance column, and a formula that tells each person exactly what they owe. Last edited: March 14. It’s August now. One of them is fairly sure she’s down about $400, nobody has settled since spring, and nobody wants to be the person who brings it up over dinner.

That’s the usual ending for a roommate expense tracker, and the reason isn’t laziness. The person who pays does the extra work of logging it, the person who owes gets no deadline, and the gap between those two facts grows quietly for months until it’s too big to fix with one transfer.

---

Roommates aren’t couples, and the math knows it

Most advice about shared expenses assumes a couple — two people who’ll eventually merge accounts and stop counting. Roommates never merge. Every shared cost stays a debt between two specific people until money actually moves.

That changes the shape of the problem in three ways.

The pairs multiply. Two roommates have one debt relationship. Three have three. Four have six. Five have ten. Every grocery run someone covers creates another small IOU in a web that nobody is tracking in their head.

People leave. Someone’s lease ends in month seven, and their balance has to close out that week or it never gets paid. There’s no shared future to settle it in.

Asking is awkward. Telling your partner they owe you $60 is a conversation. Telling the person who shares your bathroom, and who you might also consider a friend, feels like a confrontation. So the $60 sits there, and then it’s $240, and then it’s a resentment instead of a number.

A tracker doesn’t make the awkwardness disappear. It makes the number impersonal, which is most of the way there.

---

Tracking payments with a roommate spreadsheet

A shared sheet works fine as a roommate expense tracker if you build it around one idea: you’re not settling transactions, you’re settling balances. Nobody sends $18 for their share of the paper towels. You log it, and once a month the sheet tells you who sends what to whom.

Start with five columns and resist adding more:

Date	Item	Amount	Paid by	Split between
Aug 3	Rent	1800	Maya	All
Aug 5	Electric	140	Sam	All
Aug 9	Groceries	210	Devon	All

Log everything that leaves one person’s account on behalf of the household — rent, utilities, internet, groceries, the plunger you bought at 11 p.m. Living costs run well past rent, and it’s the small forgettable stuff that turns into resentment six months later.

At the end of the month you need two numbers per person: what they paid, and what their fair share was. In Google Sheets that’s =SUMIF(D:D, "Maya", C:C) for the first and =SUM(C:C)/3 for the second. The balance is the difference.

Here’s a real month for a three-person apartment. Rent $1,800, electric $140, internet $70, groceries $610, household supplies $240 — $2,860 total, so each person’s share is $953.33.

• Maya paid rent and internet: $1,870, balance +$916.67
• Devon paid the groceries: $610, balance −$343.33
• Sam paid electric and supplies: $380, balance −$573.33

Two transfers close the month. Devon sends Maya $343.33, Sam sends Maya $573.33. Not fifteen Venmo requests, not a running mental tally of who bought the last case of seltzer.

When something isn’t split evenly — one roommate skips the streaming bundle, or two of you share a parking spot — add a per-line share column instead of dividing the whole sheet by three. =C2/2 for the two-person costs, =C2/3 for the rest, then sum each person’s shares with SUMIF against a name column. It’s more setup, but it’s the difference between a sheet people trust and a sheet people argue with.

---

Where the spreadsheet cracks

Spreadsheets are genuinely good at this math. They’re bad at the other four fifths of the job.

Entry happens away from a laptop. You’re in the checkout line at 7 p.m. Logging $63.40 means opening Sheets on your phone, waiting for it to load, scrolling to the first empty row, and typing into cells sized for a desktop. Most people do it twice and then start “remembering to do it later.”

One person ends up maintaining it. This is the failure mode of every shared spreadsheet: one roommate becomes the accountant, the others become auditors who check the totals once and complain about the categories. The accountant burns out around month four.

Receipts hide the mixed purchases. A $180 Target run goes in as one line called “household.” But $52 of it was one person’s shampoo, protein powder, and phone charger. Split three ways, that roommate just got $35 of personal spending covered by everyone else. Nobody’s cheating — the format simply can’t see it.

Move-outs don’t prorate themselves. Someone leaves on the 18th. Now you need partial rent, partial utilities, and a closing balance, all mid-month. Every spreadsheet I’ve seen handle this ends up with a tab called “SAM FINAL v3.”

---

Unequal rooms, unequal rent

Splitting rent by headcount is the default and it’s wrong more often than people admit. The person in the 110-square-foot room with no closet is subsidizing the person with the master and the private bath.

Square footage gives you a defensible number. Take an 1,100 sq ft apartment at $2,700:

• Bedrooms: 180, 140, and 110 sq ft (430 total)
• Common space: 670 sq ft, divided three ways is 223 sq ft each

Add each person’s bedroom to their share of the common space, divide by 1,100, and multiply by the rent. That gives $990, $892, and $818. A $172 monthly spread — over a year, $2,064 between the biggest and smallest room.

Then adjust by hand for what square footage misses. A private bathroom is worth something. So is a window, or a door that isn’t the path to the kitchen. Argue about it once, write the numbers into the sheet, and don’t revisit it until the lease renews.

---

Pick the settle-up date before you pick the tool

The single habit that separates apartments that stay square from apartments that blow up is a fixed settlement date. Rent day works well — you’re already thinking about money and already opening your bank app.

Monthly is the right interval. Weekly is too much administration for amounts this size, and quarterly lets balances grow past what someone can send in one transfer. A roommate who owes $340 pays it. A roommate who owes $1,100 negotiates.

---

Sharing the tracker with Receiptix

Receiptix has a feature called Projects, which is the app version of the shared sheet. You create one project for the apartment, invite your roommates, and everyone logs expenses from their own phone into the same list. Each expense records who paid, so the balance math you’d otherwise write with SUMIF is already done when you open it.

Receipt scanning matters more for roommates than it does for solo tracking. That $180 Target run is one opaque line in a spreadsheet — photograph it and you get the items separately, which means the $52 of one person’s stuff can be pulled out of the shared total instead of quietly costing everyone else $17.

Projects also break down spending by member, which is the number that ends the paper-towel argument. Not who feels like they buy more, but what each person actually paid across three months.

Manual entry, categories, and spending charts are free. Projects, receipt scanning, and data export come with the premium plan.

---

Whatever you use — a sheet, an app, a whiteboard on the fridge — pick the settle-up date before you pick the columns. The apartment sheet that fails isn’t the one with bad formulas. It’s the one where the balance column was correct for five straight months and nobody ever sent the money.