Skip to content

1 or 2 credits, some free · 1 credit is about $1

pocketshelf

Roommates Shared Expenses Tracker

Shared expenses tracker for roommates who share rent and household bills: who paid, each share and who owes whom, 3 charts. XLSX with a blank copy.

ForStudents

Dashboard tab: Shared spending $2,197, To settle $2,476, Biggest category Rent, Settled so far $550; doughnut chart of Shared spending by category ($); column chart of Paid vs fair share, by...Balances tab: columns Person, Paid ($), Share ($), Sent ($), Received ($), Balance ($), In words; 7 sample rows.Expenses tab: columns Date, What, Category, Paid by, Amount ($), Split, Jordan share, Riley share, Casey share, Check (auto), Month (auto), Year (auto); 15 sample rows.Settings tab: Currency symbol, Symbol position, Start month, Year and more.

DashboardPreviews of the Dashboard, Balances, Expenses and Settings tabs with sample data, drawn from the file. Fonts and chart styling can differ in Excel, Numbers and Google Sheets.

View full size (opens image)

What's inside

Format
XLSX, CSV
Contents
6 tabs · 3 charts
Version
1.1 · Updated 7 Oct 2026
Licence
Personal What this means
Checked
Checked before it ships
  • roommates-shared-expenses-tracker.xlsxXLSX · 92 KB
  • roommates-shared-expenses-tracker-blank.xlsxXLSX · 90 KB
  • roommates-shared-expenses-tracker.csvCSV · 2 KB
  • LICENSE.txtadded to every download

About this item

A shared expenses tracker for roommates who share rent by room size and split bills evenly. It has 6 tabs: Start Here, Dashboard, Expenses, Settle-Ups, Balances, Settings. Type room weight once; each shared cost you log is split by that ratio, evenly, or charged to one person. The Dashboard with 3 charts shows what you spent together this month, how much needs to change hands to settle up ($2,476 in the sample data) and who pays whom, in one sentence. Log each payback on Settle-Ups and the balances update. Balances lists who paid, each person's share and a plain-words balance such as "Is owed" or "Owes". You get two files: one with sample data so you can see it working, and a blank copy with the same formulas. Nothing is password-locked. Made for Excel (XLSX).

Reviews

No reviews yet.

You might also grab