Roommate Expense Tracker with Amount Column: Google Sheets Template Guide

✨ Community Finance

Published: May 6, 2026

Use Google Sheets to build a roommate expense tracker with an amount column for logging shared costs like rent, utilities, and groceries. Start with core columns: Date, Description, Amount (total paid), Category, Split Type, and one column per roommate (e.g., Bob, Joe) for their share or percentage.

This tracks who paid what, assigns splits (equal or uneven), and shows running balances for reimbursements. ExpenseSorted suggests marking reimbursements in Split Type as 100% for one roommate and 0% for others. A 2007 approach from Corrie Haffly adapts columns by roommate name.

For U.S. roommates, this free template handles small groups splitting bills without apps. Log expenses weekly, review monthly, and export for records.

Core Columns for Roommate Expense Tracker

Essential columns keep tracking simple and focused on amounts. ExpenseSorted recommends these for shared roommate costs:

Date: When the expense happened (e.g., 2026-01-15).
Description: What was bought (e.g., February rent).
Amount: Total cost paid (e.g., $1200). This column emphasizes the full expense before splits.
Category: Rent, Utilities, Groceries, Internet (groups similar costs).
Split Type: Equal (for even shares), Uneven (custom percents), or Reimbursement (one person at 100%, others 0%), per ExpenseSorted.

Add columns for each roommate, such as Bob Share, Joe Share. Enter their portion or percentage here. Corrie Haffly's 2007 blog suggests naming columns after roommates like Bob, Joe, John, and using them for owed amounts.

Example row for rent:	Date	Description	Amount	Category	Split Type	Bob %	Joe %	Bob Paid	Joe Paid
2026-01-01	Jan Rent	1200	Rent	Equal	50	50	600	600

For reimbursements, like Bob buying $50 groceries for all: Split Type as Reimbursement, Bob % at 100%, Joe % at 0%, and note Joe owes Bob $25 in a balance summary.

This setup supports equal splits (50/50), room-size splits (larger room pays more), or usage-based (higher utility user pays extra).

Setup Steps in Google Sheets

Follow these steps, attributed from editorial sources, to create the tracker.

Go to sheets.google.com and click Blank spreadsheet.
In row 1, add headers: Date, Description, Amount, Category, Split Type, then roommate columns (e.g., Bob %, Joe %, Bob Balance, Joe Balance).
Format Amount column as currency: Select column > Format > Number > Currency.
Enter a sample row, like the rent example above. For reimbursements, use Split Type "Reimbursement" with 100%/0%, as in ExpenseSorted.
Add a summary section below the log (e.g., starting row 20). ExpenseSorted suggests headers: Category Budget Actual Remaining. Example: Category Budget Actual Remaining

Rent 1200 1200 0
Adjust for your group: Insert or delete roommate columns as needed, then copy formulas down (Corrie Haffly, 2007). Test with 2-3 sample expenses.

Add a summary section below the log (e.g., starting row 20). ExpenseSorted suggests headers: Category	Budget	Actual	Remaining. Example:	Category	Budget	Actual	Remaining
Rent	1200	1200	0

ExpenseSorted notes this works as a free Splitwise alternative for basic tracking.

Sharing and Update Workflow

Share the sheet for group edits via Google Sheets' built-in tools, per ExpenseSorted.

Click Share > Add emails of roommates > Select Editor access. Everyone sees real-time changes, like when someone logs a utility payment.

Practical workflow:

Log expenses right after paying: Take a photo receipt, enter Date/Description/Amount/Category/Split Type, assign shares.
For reimbursements: Payer logs it, notes owed amounts; others confirm and mark paid.
Cadence: Enter weekly (e.g., Sundays), review balances monthly over a call. Export as PDF monthly via File > Download for records.

Common mistake: Forgetting to log payments or reimbursements, which throws off balances. Always add a "Paid" column or note to confirm transfers.

Set ground rules first: Agree on split types (e.g., equal for rent, proportional for groceries) and who updates what.

Basic Calculations and Common Mistakes

Use simple formulas for summaries. RelayFi provides these examples for Google Sheets expense trackers.

For category totals: =QUERY(A2:D100, "SELECT C, SUM(D) GROUP BY C LABEL SUM(D) 'Total'"), where C is Category, D is Amount (RelayFi).

Pitfalls to avoid:

Not updating formulas when adding roommate columns (Corrie Haffly warns of this, even in 2007).
Overlooking reimbursement entries: Always log both expense and payment.
Permission issues: Avoid public links; use email invites only to prevent outsiders editing.
Formula errors: Test on a copy; Sheets autosaves but preview prints first.

These keep math manual enough for trust in small groups.

When This Template Works vs. Upgrade Options

This Google Sheets setup suits 2-4 U.S. roommates with 5-10 expenses monthly, like rent and utilities. It handles logging, splits, and reimbursements with exports for records - often enough without apps.

It shines for custom rules (e.g., income-based splits) and zero cost. Limitations: No receipt scanning, auto-payments, or reminders; manual updates can lag in larger groups.

Consider apps for receipt photos or payment requests if your group grows to 5+ or expenses hit weekly (e.g., travel groups). Stick to spreadsheets when trust is high and rules are simple - pair with a shared folder for receipts.

Next steps: Build the sheet today, log your next bill, and schedule a monthly review. Check IRS guidance for any reimbursement records if needed for taxes.