Skip to content
The title slide and first slides of the Rent and Utilities Split Tracker template

Rent and Utilities Split Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Minimal
Difficulty
Beginner
Updated
November 16, 2026

Every slide (6)

Overview

Four people, one lease, one electric bill and a group chat full of screenshots: shared housing makes small money questions pile up. This tracker keeps the record in one place. The Months tab records every bill and who covered it. The Shares tab gives every roommate a percentage, so a bigger room can pay a bigger part, and compares what each person paid with what they owe. The Paid tab records money sent between roommates.

The Summary tab shows total spending by bill type and, for each roommate, the amount paid beside the fair share. Net balance is the number that ends the argument: a positive figure means the others owe that person, a negative one shows a debt to the group. Sample rows cover three months of rent, power, gas and internet; replace them with your own bills and names.

Useful for

  • Settling up each month without a spreadsheet argument
  • Splitting rent by room size instead of equal parts
  • Keeping a record to hand over when someone moves out

What's included

  • 5 tabs: Summary, Months, Shares, Paid, How to use
  • Summary: a dashboard with 4 summary figures
  • Months: a table
  • Shares: a table with 3 summary figures
  • Paid: 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 Months 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 roommates split rent and utilities fairly?

Many households split utilities equally and rent by room size or income. Set whatever shares the group agrees on in the Shares tab, and the sheet applies them to every bill.

What does a positive net balance mean?

The roommate has paid more than their share, so the others owe them money. A negative number means they still owe the group. Log payments on the Paid tab to bring each balance toward zero.

Can I use unequal shares for different bills?

This sheet applies one share to all bills. If utilities are equal but rent is not, keep two copies of the workbook or enter rent under one name and utilities under another.

  • #bill-tracker
  • #rent-and-utilities-split-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bill tracker templates

See all 13

Also in Personal

All personal templates
Get this template

Preparing your template…