Use Google Sheets to create a roommate expense tracker with a category column by setting up columns for date, description, category, amount, payer, split type, and balances. Share via email invites for real-time edits. This helps U.S. roommates track shared costs like rent, utilities, and groceries without needing paid apps.

Google Sheets offers a free, customizable way for small groups to log expenses, categorize them, and calculate who owes what. Add a category column to group items like "Rent" or "Groceries" for easy filtering and reviews. Everyone with edit access can update simultaneously, seeing changes live.

Recommended Columns for a Roommate Expense Tracker with Categories

Start with these essential columns to organize shared expenses effectively. The category column lets you sort and filter, such as viewing all utilities or grocery totals.

  • Date: When the expense happened (e.g., 2026-01-15).
  • Description: What was bought (e.g., "February rent" or "Electricity bill").
  • Category: Group similar costs (e.g., Rent, Utilities, Groceries, Internet, Cleaning Supplies). Use consistent labels like "Rent" for monthly payments or "Groceries" for shared food runs.
  • Total Amount: Full cost (e.g., $1200).
  • Paid By: Roommate name or initials (e.g., "Alex").
  • Split Type: How to divide (e.g., "Equal" for even shares, "Reimbursement" for one person covering all).
  • Balances: One column per roommate showing their running total (e.g., positive if they paid more, negative if they owe).

The category column simplifies reviews: filter to see total rent paid over months or spot overspending in groceries.

Link to Expense Sorted blog for a roommate-focused example.

Setup Steps for Your Tracker

Follow these steps to build and use the tracker.

  1. Create a new Google Sheet at sheets.google.com. Name it "Roommate Expenses 2026".

  2. In row 1, add and rename columns: A: Date, B: Description, C: Category, D: Total Amount, E: Paid By, F: Split Type, G+: Balances (one per roommate, e.g., G: Alex Balance, H: Jordan Balance).

  3. Enter sample expenses. Example row 2: 2026-01-15, "Electricity bill", Utilities, 150, Alex, Equal. For equal split with two roommates, manually adjust balances: subtract half from Alex (-75) and add half to Jordan (+75).

  4. For reimbursements, use "Reimbursement" in split type. Example: One roommate pays $50 groceries; mark them 100%, others 0%. Update balances accordingly (payer gets +50, others -25 each for equal split).

  5. Apply filters: Select row 1, go to Data > Create a filter. Click category dropdown to view one type, like all Rent entries.

Review weekly: Set a recurring calendar reminder to add expenses and check balances. Common mistakes include inconsistent categories (e.g., "Electric" vs. "Utilities") - standardize a list in a separate sheet tab. Another: Forgetting to update all balance columns per row, leading to errors. Copy any simple running total formulas down the sheet if using them, but test first.

Sharing and Collaboration Rules

Sharing enables group input without emailing files back and forth.

Click the Share button (top right). Add roommate email addresses, select "Editor" for each to allow edits. They get an invite link; once accepted, changes appear live for all.

Everyone with edit access updates simultaneously and sees updates in real time. Use "Commenter" for guests who should not edit.

Common mistake: Accidentally setting "Viewer" access, which blocks edits. Double-check permissions in the Share menu. Notify roommates via group chat when sharing.

For security, only share with trusted emails.

Link to Tiller sharing guide.

When a Spreadsheet Tracker Works and Limits to Consider

A Google Sheets tracker suits small U.S. roommate groups (like 2-4 people) with straightforward splits: equal shares for rent/utilities or reimbursements for groceries.

Workflow example: Snap receipt photos, paste links in the description column. During weekly meetings, add expenses, calculate owed amounts from balances, and settle via cash, Venmo, or Zelle. Document payments in a "Settled" column.

It works when:

  • Expenses are few (under 20/month).
  • Group agrees on rules upfront (e.g., equal split unless specified).
  • No need for receipt scanning or automated reminders.

Tradeoffs: Free and flexible, but manual entry risks mistakes. Apps add scanning or notifications but may charge fees - consider if group size grows or disputes arise.

Limits: Relies on trust; no built-in payment enforcement. For privacy or exports, check Google's terms directly. Sometimes a sheet plus a folder of receipt photos suffices over apps.

Link to SharedContacts sharing blog.

FAQ

How do I organize expenses by category in the tracker?
Use the category column with consistent labels (Rent, Utilities). Apply filters via Data > Create a filter to view or sum one category.

What split types work for uneven roommate contributions?
Try "Equal" for even shares, "Proportional" (based on income/room size - note percentages per row), or "Reimbursement" (one pays, others repay shares). Track in balances.

How often should we review and update the shared sheet?
Weekly for small groups; add expenses right away, review balances Sundays. Set calendar reminders.

Can all roommates edit at the same time?
Yes, editors see live changes simultaneously with edit access.

What if someone forgets to add a receipt?
Paste a photo link or note "Receipt pending" in description. Review at meetings to catch misses.

When should we switch from Sheets to a paid app?
If group exceeds 4-5 people, needs auto-scans, or frequent disputes - but start simple.

Next, create your sheet today, share with roommates, and agree on update rules. Test with last month's expenses to refine.