Tired of chasing roommates for bill money? A shared spreadsheet handles it without a monthly subscription, and nobody has to download another commercial app just to see what they owe. The ledger lives in one place where everybody can look. Nobody wonders who paid rent.
Core Columns for a Shared Ledger
Put your headers across row 1. Clear labels now save you from messy entries later.
| Column | Header | Purpose | Example Entry |
|---|---|---|---|
| A | Date | When the transaction happened | 02/01/2026 |
| B | Category | High-level grouping for filtering | Utilities |
| C | Description | Specific vendor or purchase details | Electric bill - winter rate |
| D | Total Cost | Total dollar amount paid | $140.00 |
| E | Paid By | Name of the roommate who fronted cash | Alex |
| F | Split Method | How the expense divides | Equal |
| G | Alex Share | What Alex owes for this row | $70.00 |
| H | Jordan Share | What Jordan owes for this row | $70.00 |
| I | Notes | Venmo links, invoice notes, or receipts | Paid via auto-pay |
Thing is, tracking each person's share in its own column makes the balance math far simpler than stuffing names and percentages into one text cell. One column per person. Your formulas stay clean.
Setting Up the Sheet Step by Step
The whole build takes about five minutes.
- Open a blank workbook at Google Sheets and give it an obvious name, something like Household Expenses.
- Type the headers into row 1, select the row, then click View > Freeze > 1 row so the labels stay pinned while entries pile up.
- Highlight your cost and share columns and hit Format > Number > Currency. The dollar values line up neatly after that.
- Click row 1 and choose Data > Create a filter. Now you can sort expenses by category or by who paid.
- Add a second tab called Summary. That's where the rolling debt calculations live, kept away from the daily log.
Splitting Rent, Utilities, and Groceries
Rent rarely divides evenly without an argument. One bedroom has the en-suite bath, another has extra square footage, a third catches better light, and everybody notices. Most households handle it by pricing rooms off square footage or fixing percentages before anyone moves in, maybe 55% for the master bedroom and 45% for the smaller space. Agree on those numbers early.
Utilities are easier. Split them down the middle.
Groceries need a boundary everyone understands. Shared essentials like cooking oil, spices, and paper towels go on the sheet and divide equally across the household. Personal snacks stay off it. That single rule prevents most grocery fights.
Reimbursements take careful logging, or you'll double-count a debt. Say Jordan buys a $60 desk fan that Alex requested for a private bedroom. Jordan fronts the cash, so Alex's share column gets the full $60 while Jordan's share is $0. Jordan paid sixty dollars. Alex owes sixty dollars. Then, when Alex eventually sends that money back, log a separate repayment row where Alex pays sixty and, a little repetitively, Jordan's share is also sixty, which feels silly to type out but it balances the books back to zero without breaking your math. That clears the debt completely.
Formulas for Balances and Summaries
Turns out, you don't need complex scripts to calculate household balances. Two standard formulas do the work.
To find how much cash Alex paid out of pocket, point a SUMIF at your payer column:
=SUMIF(E2:E, "Alex", D2:D)
To see what Alex actually consumed across all purchases, sum the dedicated share column:
=SUM(G2:G)
Net standing is the first number minus the second:
=SUMIF(E2:E, "Alex", D2:D) - SUM(G2:G)
A positive balance means the household owes Alex money. A negative number means Alex owes the household.
For an automated spending overview by category, drop a QUERY function onto the Summary tab:
=QUERY(A1:D, "SELECT B, SUM(D) WHERE B IS NOT NULL GROUP BY B LABEL SUM(D) 'Total Paid'", 1)
That single formula totals your utility, grocery, and household costs instantly. Every new row updates it.
Sharing and Permissions
Lock down permissions before someone accidentally deletes a formula or mangles a range. You can review the GeeksforGeeks guide on Google Sheets permissions to see how desktop and mobile permission settings work.
When you grant access:
- Share the file directly with each roommate's Google account instead of generating an open public link anyone can access.
- Set roommates as Editors so they can log expenses from their phones.
- Open the Share settings gear icon and uncheck the option letting editors change permissions and share.
- Lock formula columns and the Summary tab by opening Data > Protect sheets and ranges.
Common Pitfalls and When to Upgrade
To be honest, shared spreadsheets almost never fail over technical bugs. They fail socially. Nobody enters the receipt, the balances drift, and weeks later the memories are gone and receipts are lost, so someone inevitably feels shortchanged during month-end settlement. Fix that with a simple update rhythm agreed in advance. Log purchases within 48 hours. Settle debts once a month.
For two to four roommates with typical monthly bills, a spreadsheet does the job well. It costs nothing, and your financial data stays private.
The math changes at five or six roommates. Manual data entry gets exhausting, especially if people travel together often, split dinners unevenly every week, or need automated payment reminders to actually pay their share on time. If logging causes friction, switching to a dedicated group expense app might be worth the trade-off.
Next Steps
Open a new Google Sheet today and type in your column headers. Enter last month's utility bills so you can watch the formulas work. Bookmark the link on your phone. Then run the numbers together at your next house meeting.