Skip to content
Roommate Shared Expenses cover: a sample sheet with shared spending, each person owes and items logged and a bar chart, beside the Dashboard and Expenses tabs

Roommate Shared Expenses

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Bold
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This sheet is for roommates who share rent, bills and groceries. The Expenses tab shows every shared cost along with its date, item, type, the person who paid and the amount. Each row also shows an even share of the cost. The Dashboard shows the total shared spending, what each person owes and a balance for every roommate.

Four roommates are assumed. If your household is a different size, change the 4 in the Each share column and in the Dashboard formulas, and make sure every name appears in the paid by list. A positive balance means that person paid more than their share and should be paid back; a negative one means they owe money. Settle up when the month closes.

Useful for

  • Splitting rent, bills and groceries four ways
  • Seeing who should be paid back before a trip
  • Keeping a clear record for a shared house

What's included

  • 3 tabs: Dashboard, Expenses, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Expenses: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Expenses tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I split one bill differently?

The template splits every item evenly. For a cost only some roommates share, log the part each person owes as its own row, paid by the person who covered it, and note the reason in the Item column.

What does a negative balance mean?

A negative balance means that roommate has paid less than their share and owes the others that amount. A positive balance means they are owed money. The balances add up to zero, so the totals always reconcile.

Can we add a fifth roommate?

Yes, but the formulas use four. Change each division by four to five in the Each share column and in the Dashboard formulas, then include the fifth person in the paid by list and in the breakdown.

  • #expense-tracker
  • #shared-expenses-roommates
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More expense tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…