Set up a shared expense spreadsheet in Google Sheets by creating columns for dates, expenses, categories, split types, and per-person amounts. Use example formulas like SUMIF for balances, as shown in thekeycuts.com editorial. Share via the green Share button with roommate emails set to edit permissions for real-time updates, per Tiller editorial.

This approach helps college roommates track rent, utilities, groceries, and reimbursements without apps. Everyone can edit live, making it simple for 2-4 people splitting household costs.

Choose Your Split Method Before Building the Template

Decide on a split method upfront to shape your columns and formulas. Common options for roommates include equal splits, usage-based splits, or reimbursements.

For rent or fixed utilities, an equal split works when everyone contributes the same, such as four roommates dividing monthly rent into equal parts. Usage-based splits fit variable costs like groceries or streaming services, where one person pays upfront and others reimburse based on who used it.

Reimbursements suit personal buys, like one roommate covering groceries for the house; mark it as 100% for the payer and 0% for others, per expensesorted.com blog examples. Tradeoffs matter: equal splits are simplest but may feel unfair if incomes differ; usage-based needs more tracking.

Use this decision tree:

  • Fixed costs like rent? Go equal.
  • Shared but variable, like utilities? Equal or per-room size.
  • One person paid? Reimbursement. Discuss with roommates first, document the rules in the sheet's notes tab, and adjust as needed.

Recommended Columns for a Roommate Expense Tracker

Start with a scalable structure of 8-10 columns, drawn from editorial examples like corriehaffly.wordpress.com. This handles 2-6 roommates; insert or delete columns to scale.

Example columns:

  • A: Date (e.g., 2026-01-15)
  • B: Description (e.g., "February rent")
  • C: Total Cost (e.g., $1,600)
  • D: Category (e.g., Rent, Utilities, Groceries)
  • E: Split Type (e.g., Equal, Reimbursement, Usage)
  • F: Roommate 1 % (e.g., 25 for equal split among four)
  • G: Roommate 2 %
  • H: Roommate 3 %
  • I: Roommate 4 %
  • J: Notes (e.g., "Alex paid, reimburse via Venmo")
  • K: Balance (formula-calculated running total per person, below)

For more roommates, insert columns after I and rename (e.g., Roommate 5 %). Add separate balance columns later, like L: Roommate 1 Balance, M: Roommate 2 Balance. This setup tracks who owes whom, per blog examples.

Add Formulas for Automatic Balances and Splits

Formulas automate calculations. These are approximate examples from editorial sources like thekeycuts.com; test them in your sheet.

In the main table, for per-person share in column L (Roommate 1 share for row 2):
=IFERROR(C2 * F2 / 100, "")
This multiplies total cost by their percentage (e.g., $1,600 * 25% = $400).

For running balance in a summary section (say row 30+), label column B as "Roommate 1", then in C30:
=SUMIF($E$2:$E$25, "Equal", $L$2:$L$25)
Adapt from thekeycuts.com's SUMIF example (=SUMIF($K2:$K25,C$1,$B2:$B25)), where it sums costs matching a name.

For category totals, like utilities for Roommate 1:
=SUMIFS($L$2:$L$25, $D$2:$D$25, "Utilities")
From relayfi.com blog patterns.

Common mistake: Forgetting to use absolute references like $E$2:$E$25 when copying formulas across rows or columns. Copy down to new rows, but test with sample data first. Not copying correctly leads to wrong sums.

Step-by-Step Setup Workflow in Google Sheets

Follow these numbered steps for a working template.

  1. Go to sheets.google.com and click "Blank" for a new spreadsheet. Name it "Roommate Expenses 2026".

  2. In row 1, enter headers: Date (A1), Description (B1), Total Cost (C1), Category (D1), Split Type (E1), then Roommate 1 % (F1), Roommate 2 % (G1), etc.

  3. Add sample data in rows 2-5:

    • Row 2: 2026-01-01, "January rent", 1600, Rent, Equal, 25, 25, 25, 25
    • Row 3: 2026-01-15, "Electricity bill - Sarah paid", 120, Utilities, Reimbursement, 0, 100, 0, 0
    • Row 4: 2026-01-20, "Groceries", 80, Groceries, Equal, 25, 25, 25, 25
    • Row 5: 2026-02-01, "February rent", 1600, Rent, Equal, 25, 25, 25, 25

  4. Enter formulas: In L2 (Roommate 1 share): =IFERROR(C2*F2/100,""), copy to L3:L5 and across to other roommates. In a summary (A30: "Roommate 1 Balance", B30: =SUM(L2:L25)).

  5. Format: Select C:L, Format > Number > Currency (USD). Bold headers, freeze row 1 (View > Freeze > 1 row).

  6. Test: Change a percentage; balances should update. Review weekly, attach receipts via Insert > Image or a shared drive folder link in Notes.

Update cadence: Log expenses weekly, reconcile monthly.

Share the Spreadsheet with Roommates

Sharing enables collaboration.

Click the green Share button upper right. Add each roommate's email, select "Editor" for full access, per Tiller guidance. They can edit live with real-time updates visible to all, as noted in expensesorted.com blog.

For a template version, set to "Anyone with the link" as Viewer; recipients click "Use template". Agree on rules first: one person logs payments, others verify. Assign a monthly reviewer.

Common Mistakes and When to Use an App Instead

Avoid these pitfalls: Formula errors from untested copies; overlooked permissions (Editors only for changes); no backups (File > Version history). Editorial sources like Tiller note up to 100 people can edit simultaneously, though practical for smaller groups; larger may lag.

Spreadsheets suit 2-4 roommates with simple needs like rent and utilities. Common mistakes include outdated sharing steps or unverified formulas - always double-check.

For advanced needs like receipt scanning or auto-reminders, consider apps, but a sheet often suffices with discipline. Back up via File > Download > Excel.

FAQ

How many roommates can edit simultaneously?
Up to 100 with edit access per Tiller editorial, though best for small groups to avoid lag.

Do the formulas work in Excel too?
Yes, SUMIF and SUMIFS are similar; adjust for Excel's interface.

What if someone forgets to update their column?
Set a weekly review meeting; use notifications (Tools > Notification rules) for changes.

How do I handle uneven splits like room size?
Adjust percentages (e.g., 40/30/30); add a Room Size column if needed.

Can I attach receipts to the sheet?
Insert images or link to a shared Google Drive folder in Notes.

Is this legally binding for disputes?
No, it's a recordkeeping tool; for disputes, keep receipts and consider written agreements, but check local rules.