Why pay monthly fees just to figure out who bought paper towels? Most apartments simply don't need dedicated software. A basic Google Sheet handles custom split percentages, grocery runs, and deposit tracking without paywalls locking up your data exports. You can run the whole house off two working tabs: one for group spending and one for cash repayments between roommates.
Build the Expense Log
Freeze your top row first so column names stay put as the term drags on. Click View, head to Freeze, and pick 1 row.
| Date | Description | Total Cost | Paid By | Split Type | Roommate A ($) | Roommate B ($) | Roommate C ($) | Check |
|---|---|---|---|---|---|---|---|---|
| 2026-09-01 | Internet | 60.00 | Alex | Equal | 20.00 | 20.00 | 20.00 | OK |
| 2026-09-04 | Groceries | 45.00 | Jordan | Uneven | 15.00 | 30.00 | 0.00 | OK |
| 2026-09-10 | Microwave | 80.00 | Taylor | Reimbursement | 80.00 | 0.00 | 0.00 | OK |
Thing is, communal shopping trips go off the rails fast when personal snacks sneak into the cart. Keep private purchases off this ledger entirely. The Split Type column clarifies who owes what without forcing you to remember the context weeks later. When somebody covers an upfront purchase that one specific person owes back in full, like Taylor buying that microwave, record it as a reimbursement. Assign 100% of the cost to the responsible roommate and zero out the others, which is the clean layout outlined by Expense Sorted.
Why Repayments Need Their Own Tab
Do not mix peer-to-peer transfers with shared expenses.
If Jordan sends Alex $20 through an app to settle last week's food run, that transfer is debt settlement, not fresh household spending. Recording that $20 alongside regular bills artificially inflates what your apartment spent to live that month, and it will distort your balance math right away.
Keep cash settlements on a separate tab called Settlements. Set it up with six columns: Date, Paid By, Paid To, Amount, Method, and Notes. When Jordan pays Alex back, log the transaction there. That records the transfer, leaves the original $60 utility entry on the main tab completely intact, and gives everyone clean documentation if questions surface when the lease ends.
Key Formulas for Balances and Checks
Manual calculations create unnecessary friction. Formulas fix that.
Catch entry mistakes before they trigger an argument by dropping this check formula into cell I2 of your Expenses tab:
=IF($C2="","",IF(ROUND(SUM($F2:$H2),2)=ROUND($C2,2),"OK","Check split"))
Drag it down the column. If Jordan logs $15 and $20 against a $45 grocery bill, the cell flags "Check split" right away.
Create a third tab labeled Balances. Put your roommates' names down column A, then calculate total upfront payments in column B with this:
=SUMIF(Expenses!$D$2:$D$100, A2, Expenses!$C$2:$C$100)
Column C totals each person's consumed share by summing their specific split column from the Expenses tab.
Net balance requires four values. Take what a roommate paid upfront, subtract their total share owed, add payments they sent on the Settlements tab, and subtract payments they received. A positive number means money is owed back to them. A negative number means they owe the apartment.
Ground Rules for Roommate Spending
A spreadsheet cannot enforce good habits on its own. Campus housing teams like George Mason University recommend setting ground rules before small misunderstandings turn into bitter passive-aggressive sticky notes.
- Agree on an expense ceiling. Shared purchases above $30 require a quick confirmation text before anyone taps a card.
- Pick a fixed logging night. Update receipts every Sunday evening so paper piles do not sit around for weeks.
- Square up monthly. Clear net balances on the first of each month when rent comes due.
- Link your receipts. Drop photo receipts into a shared Google Drive folder and paste the URL into the notes column.
- Rotate the spare cent. A $100 bill divided among three people leaves $33.33, $33.33, and $33.34, so take turns paying the odd penny.
Sharing and Access Settings
Spreadsheet accidents usually spike right around finals week when everyone is stressed and rushed. Someone tries to alphabetize their purchases, sorts a single column instead of the entire sheet, and scrambles every row. Or someone accidentally writes over a summary formula.
Lock down your document with basic permissions. Share editing access directly to individual Google accounts instead of generating a link anyone on the web can open. An open link invites anonymous edits and exposes your shared spending to whoever happens to find the URL.
Next, protect your core math. Right-click the Balances tab, click "Protect sheet", and set permissions so only one designated house manager can edit formula cells. Roommates can still add lines on the Expenses and Settlements sheets without touching the balance engine. Under Tools, open Notification rules and select a daily digest email to see whenever an amount gets updated.
When Spreadsheets Fail
To be honest, this setup is not a good fit for every apartment.
Sheets work smoothly for two to four people handling predictable utility bills, bulk household items, and basic Wi-Fi. Once you get past five or six roommates ordering shared takeout, running random mid-week snack errands, and ignoring group texts without automated push reminders, maintaining a sheet feels like an unpaid clerical job. If nobody opens the tab for three weeks, your numbers stop reflecting reality. In larger houses, paying utilities directly to the utility company or using a dedicated group-finance app usually creates far less friction.
Next Steps for Your Apartment
Open Google Sheets and create your file now. Add your three tabs: Expenses, Settlements, and Balances. Share the document with your housemates, set that $30 notification limit, and plug in your latest electric bill to confirm the split check works before real expenses pile up.