Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceBudgeting & Expense ManagementRoommate Expense Splitter

SpreadsheetBudgeting & Expense ManagementFree

Roommate Expense Splitter

Log shared bills, split each equally, by room size or to one person, and see who owes whom with a settle-up line for everyone.

Shown with sample data

Colour

Roommate Expense Splitter

Log shared bills, split each equally, by room size or to one person, and see who owes whom with a settle-up line for everyone.

Shared spending this month
$3,994
Average per person
$1,331
Room shares total
100%
Should be 100%
Largest amount owed
$1,023
Balance by roommate
  • Alex$1,823.50
  • Sam-$800.30
  • Priya-$1,023.20
Shared spending by category
  • Rent$3,15079%
  • Utilities$317.708%
  • Groceries$258.706%
  • Cleaning$1203%
  • Internet$652%
  • Other$481%
  • Other$34.801%

How to use it

  1. 1On Roommates, type each person’s name and their share of the rent by room size (shares should total 100%).
  2. 2Log each shared expense with the amount and who paid it, using the same names.
  3. 3Choose a split: Equal, By room share, or one roommate only (for something bought for one person).
  4. 4Check Roommates for each person’s balance and the Settle up instruction.
  5. 5Once settled, log the repayments as expenses paid by the person paying back, split to the person receiving it, or start a new month.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Shared houses fall out over money that nobody tracked. Log each shared bill and who paid it, choose whether it is split equally, by room size or belongs to one person, and the sheet works out everyone’s share, what each person has paid, the balance owed or owing and a plain settle-up instruction, so the house can square up monthly in minutes.

Who it’s for

  • Rent, utilities, internet and groceries in shared homes
  • Unequal rooms where the bigger room pays more
  • Settling up at the end of each month or lease

What’s included

  • Expenses sheet: Every shared expense, who paid and how it is split.
  • Roommates sheet: What each person paid, their fair share and how to settle up.
  • By category sheet: Amount and the number of entries for each category.

How to use it

  1. 1On Roommates, type each person’s name and their share of the rent by room size (shares should total 100%).
  2. 2Log each shared expense with the amount and who paid it, using the same names.
  3. 3Choose a split: Equal, By room share, or one roommate only (for something bought for one person).
  4. 4Check Roommates for each person’s balance and the Settle up instruction.
  5. 5Once settled, log the repayments as expenses paid by the person paying back, split to the person receiving it, or start a new month.

Tips

  • Agree the rules on day one: which costs are shared, how rent is split by room size and when you settle up.
  • Split rent by room size but utilities and internet equally; everyone uses those the same.
  • Settle up monthly. Small balances are easy to pay; three months of them start arguments.

Questions

How do you split rent fairly between roommates?

Common methods: equally, by bedroom size (square footage), or by features such as a private bathroom or parking. Set each person’s room share on the Roommates sheet and use By room share for rent.

What if one roommate buys something only for themselves?

Choose that roommate as the split (Roommate 1 only, and so on). They are charged the full amount, and if someone else paid, that person is owed it back.

Can I use this for four roommates?

It is set up for three. For four, add a Roommate 4 share column on Expenses, a fourth row on Roommates, and change the equal split from 3 to 4.

Related searchesroommate expense splittersplit bills with roommatesshared expenses spreadsheetroommate rent split calculatorwho owes whohouse share bills

Details

Format
Spreadsheet
Category
Budgeting & Expense Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBudgeting & Expense ManagementFree

Roommate Expense Splitter

Log shared bills, split each equally, by room size or to one person, and see who owes whom with a settle-up line for everyone.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Budgeting & Expense Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More budgeting & expense management templates

View all
Household Monthly Budget3 sheets

Income received

$4,550

Spent so far

$2,947

Left to spend

$373

Spending by category
$1,450
$518.55
$400
$300
$250
Rent / mortgageGroceriesEmergency fundExtra debt paymentRetirement
SpreadsheetBudgeting & Expense Management

Household Monthly Budget

Plan by category, log spending, and see planned vs actual, what is left and your 50/30/20 split update live.

10 min setupPreview
50/30/20 Budget3 sheets

Total planned

$3,992

Left unallocated

$308

Planned spending by group
63%
  • Needs
  • Savings
  • Wants
SpreadsheetBudgeting & Expense Management

50/30/20 Budget

Split take-home pay into needs, wants and savings, and see how your real spending compares with the rule.

10 min setupPreview
Zero-Based Budget4 sheets

Income this month

$4,980

Left to assign

$0

Spent so far

$3,645

Income by group
63%
  • Essentials
  • Debt
  • Savings
  • Lifestyle
SpreadsheetBudgeting & Expense Management

Zero-Based Budget

Give every dollar a job: assign income until "left to assign" is zero, then track spending against each line.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ