Roommate Expense Tracker Spreadsheet

Choose your format

Get the roommate expense tracker

Excel and Google Sheets include setup, expense and repayment records, an automatic summary and a completed example. Choose the format you prefer. The CSV is a simple ledger without formulas or settlement suggestions.

You Owe Me does not receive the expenses you enter. Excel data stays in your file unless you upload or share it. Google Sheets data is stored in your Google account and is accessible to people you choose to share your copy with.

Inside the workbook

What the workbook keeps separate

A trustworthy roommate record separates what happened from what happened later. Expenses show what was paid and how it was shared. Repayments show money sent between roommates. The summary combines both without erasing either history.

On a phone, swipe sideways to see all columns.

Five-minute setup

Set up the spreadsheet in five minutes

Start on the Setup sheet, then enter each activity only in the input columns. Leave formula cells and summary cells unchanged.

1. Add the household and period

   Enter an optional household name, the month or date range you are reviewing, one currency, and two to six unique roommate names.

2. Enter an opening position only when one exists

   Use the closing positions from the last verified period. A positive opening position means that roommate should receive money; a negative position means they owe money. All opening positions must add up to zero.

3. Record each expense once

   Add the date, expense, category, amount, and the roommate who paid. Do not add a second row just because the cost is being repaid later.

4. Confirm who shared the cost

   For an equal split, include only the roommates who shared that expense. For a custom split, enter the agreed amount assigned to each included roommate and check that the shares equal the full expense.

5. Add repayments and review the summary

   Record each transfer on the Repayments sheet, then review the Summary sheet together before anyone sends the final settlement.

Tip: if a cost is disputed, leave it outside the accepted balance until the roommates clarify whether it belongs and how it should be shared.

Worked example

Three roommates, three expenses, one partial repayment

Maya, Alex, and Sam split three shared costs equally. Maya paid the rent, Alex paid the internet bill, and Sam paid for groceries. Alex then sent Maya $200 before the final settle-up.

On a phone, swipe sideways to see all columns.

The shared expenses total $1,980, so each roommate’s assigned share is $660.

On a phone, swipe sideways to see all columns.

The $200 transfer does not erase or rewrite the rent. It is recorded separately, reducing Alex’s open amount and Maya’s amount still to receive.

Starting the next month

If Alex pays Maya $400 and Sam pays Maya $540, everyone starts the next period at zero.

If those suggested transfers have not happened, carry the checked closing positions into the new period once: Maya should receive $940, Alex owes $400, and Sam owes $540. Do not enter those amounts again as new expenses.

Continuing that unpaid-balance example, if Alex pays a new $90 shared bill, split equally, Maya should receive $910, Alex owes $340, and Sam owes $570.

Common situations

Record each roommate cost once

Use one row for each event. Do not change an old expense when a repayment arrives or a balance moves into the next month. Add a new repayment or opening-position row instead.

On a phone, swipe sideways to see all columns.

Need help agreeing the rule before entering costs? Read how to split rent, utilities, and groceries with roommates.

Before anyone settles

Review the month before anyone pays

A correct formula is not enough if the inputs are unclear. Review the record together while the expenses are still easy to recognize.

After someone pays, use the repayment receipt generator to confirm what was paid and whether anything remains.

A shared summary is an invitation to check the record—not a demand, collection notice, or proof that a disputed amount is owed.

Choose the maintenance level

When the spreadsheet is enough—and when it is not

The best method is the lightest one people can keep accurate. More software is not automatically better; a manual file becomes the wrong tool only when maintaining it creates gaps, duplicated balances, or missed updates.

Use the spreadsheet when one person is comfortable maintaining it and the household reviews it regularly. Use You Owe Me only when repeated costs, partial repayments, reminders, or shareable history make manual spreadsheet upkeep unreliable.

Questions and boundaries

Roommate spreadsheet questions