Use this free Google Sheets workflow to track roommate expenses. Start a new sheet and add these core columns: Date, Description, Amount, Payer, Split Type (like "Equal" or "Reimbursement"), Participants, and Notes. Input expenses such as $1,200 rent with equal split or a $50 utility reimbursement.

Apply formulas like =SUMIFS for person totals and =QUERY for category summaries. Share via link with Editor permissions for real-time updates. Review weekly to balance owed amounts. This setup works for U.S. roommates handling rent, utilities, groceries, and IOUs without apps.

Core Columns for Roommate Expense Tracking

Set up your Google Sheets with these essential columns to capture all shared expenses clearly. Place them in row 1, starting from column A.

  • Date: Enter dates in MM/DD/YYYY format, like 01/15/2026. Sort chronologically to track timelines for rent due dates or utility cycles.
  • Description: Detail the expense, such as "February rent" or "Electricity bill - high usage month."
  • Amount: Total cost in dollars, e.g., 1200 for rent or 85.50 for groceries.
  • Payer: Name of the person who paid, like "Alex" or "Jordan." Use consistent spelling.
  • Split Type: Options include "Equal" for even shares, "Reimbursement" where one covers 100% and others owe, "Usage-based" for utilities by shower time, or "Income-based" for uneven splits. This column drives formulas.
  • Participants: List involved roommates, e.g., "Alex, Jordan, Sam" or percentages like "33%, 33%, 34%."
  • Notes: Add details like receipt links or rules, e.g., "Alex fronts utilities; reimburse via Venmo."

For roommate specifics, track rent deposits separately under Description. Utilities suit "Usage-based" splits if one uses more AC. Groceries work with "Equal." A balance column at the end uses formulas to show who owes whom.

Tradeoffs in splits: Equal is simple for rent but ignores unequal rooms. Usage-based needs metering for fairness on chores-tied costs like cleaning supplies. Income-based reduces burden on lower earners but requires salary disclosure. Reimbursement fits one-off buys like moving costs.

Setup Steps to Build Your Tracker

Follow these steps to create the template from a blank Google Sheet.

  1. Go to sheets.google.com and click Blank.
  2. In row 1, enter the core columns: A1=Date, B1=Description, C1=Amount, D1=Payer, E1=Split Type, F1=Participants, G1=Notes, H1=Balance (formula-driven).
  3. Format: Bold row 1, freeze it (View > Freeze > 1 row), right-align Amount as currency ($ format via Format > Number > Currency).
  4. Add sample data: Row 2 - 01/01/2026, "January rent", 1200, "Alex", "Equal", "Alex,Jordan,Sam", "Due 1st". Row 3 - 01/10/2026, "Utilities", 150, "Jordan", "Reimbursement", "Alex (100%)", "Receipt in Drive".
  5. Create a Summary sheet: Right-click sheet tab > Insert sheet. Add headers for totals.
  6. Protect ranges: Right-click columns > Protect range to lock formulas.
  7. Format for mobile: Use conditional formatting (Format > Conditional formatting) to color-code overdue reimbursements red if Date > today and Balance >0.

Update weekly during house meetings. Common mistake: Skipping Date column, which scrambles sorting - always include it.

Key Formulas for Balances and Summaries

Use these copy-paste formulas, adapted from relayfi.com examples for roommates. Adjust ranges like B2:B100 to match your data rows. Place in Summary sheet or column H.

  1. Person Balance: In H2 for Alex's total owed: =SUMIFS(C:C, D:D, "Alex") - SUMIFS( owed range based on splits). For simplicity, add a Paid By Others column and sum.
  2. Category Totals: =QUERY(A2:G100, "SELECT B, SUM(C) GROUP BY B LABEL SUM(C) 'Total'"). Groups by Description (e.g., Utilities total) (relayfi.com).
  3. High Expenses Filter: =FILTER(A2:G100, C2:C100>100). Lists rows over $100, useful for reviewing big rent deposits (relayfi.com).
  4. Payer-Specific Sum: =SUMIFS(C2:C100, D2:D100, "Alex", E2:E100, "Reimbursement"). Totals what Alex paid under Reimbursement (relayfi.com).
  5. Budget Warning: Adapt =AND(C2>=B2*0.8, C2<=B2) for group caps. Set B2=monthly utility cap 200; if actual >=160, highlight yellow (relayfi.com).

For reimbursements, filter by Split Type="Reimbursement" in QUERY: =QUERY(A2:G100, "SELECT * WHERE E='Reimbursement'"). Test formulas on sample data. Mistake: Static ranges - use C:C for dynamic growth.

Sharing and Permissions for Group Access

Share securely for group input.

  1. Click Share (top-right).
  2. Choose link-sharing or add emails.
  3. Set permissions dropdown: Viewer (read-only), Commenter (notes, no edits), Editor (full changes) (GeeksforGeeks).
  4. For 3 roommates, use Editor for trusted group; restrict further sharing (checkbox).
  5. Mobile: Tap three dots > Share & Export (GeeksforGeeks).
  6. Use built-in chat for questions like "Who paid groceries?" (sharedcontacts.com).

Common mistake: Full Editor to casual roommates; start with Commenter, upgrade if reliable. Revoke access on move-out via Manage access.

Common Mistakes and When to Use Sheets vs. Apps

Avoid these pitfalls:

  1. Over-sharing: Giving Editor without restricting re-sharing exposes data. Fix: Use link with "Restricted" and specific emails.
  2. Formula breakage: Inserting rows shifts ranges. Fix: Use dynamic ranges like C2:C1000 or Tables (Insert > Table).
  3. No version history: Disputes arise without checks. Fix: File > Version history > See changes.
  4. Ignoring updates: Stale data leads to double-pays. Fix: Set Google Calendar reminders for reviews.
  5. Uneven splits undocumented: Leads to arguments. Fix: Notes column for rules.

Sheets suffice for 2-4 roommates with 10-20 monthly expenses - free, fully customizable, offline access. For 5+ people, frequent travel, or automated reminders, apps handle notifications better but may add fees or limits. Decision tree: Low volume and trust? Sheets. High turnover or complexity? Consider apps after testing sheets. No method fits all; combine with cash or payment apps for payouts.

FAQ

How do I mark a reimbursement in the template?
Use "Reimbursement" in Split Type, note payer covers 100% in Participants/Notes (expensesorted.com).

What permissions should I set for roommates?
Editor for active trackers, Commenter for viewers (GeeksforGeeks). Restrict further sharing.

Can everyone edit at the same time?
Yes, with Editor access.

How do I summarize totals by person or category?
Use =QUERY for categories or =SUMIFS for payers (relayfi.com).

What's a good review cadence for the sheet?
Weekly house meetings or monthly for bills; set reminders.

When should I switch from Sheets to a paid app?
If group grows beyond 4, needs auto-reminders, or tracks travel often - test sheets first.

Next, duplicate this setup in a new sheet, add your first expense, and share the link. Review after one month to refine splits.