Ever tried chasing three different payment requests while arguing over who has the master bedroom? Splitting household costs in a spreadsheet often turns into a messy chore of broken formulas and forgotten receipts. Setting up a dedicated Notion dashboard fixes this by tying your roommates directly to your household bills.
You only need two interconnected databases. One tracks the people; the other logs the expenses.
With Notion Formulas 2.0, you can calculate each person's exact share automatically without paying for third-party split apps.
Setting up the two databases
To be honest, cramming every bill and tenant into a single massive spreadsheet usually creates more confusion than clarity. A two-database structure separates people from charges. That keeps your monthly archive clean over time.
First, build a database named Roommates where each row represents one person. Next, build a database named Expenses for utility bills, grocery runs, and monthly rent. Link them together using a Relation property inside the Expenses table. Make sure you turn on the two-way relation toggle. That lets both databases share data seamlessly.
Here is the structure for the core properties:
| Database | Property Name | Property Type | Why You Need It |
|---|---|---|---|
| Roommates | Name | Title | Person's name |
| Roommates | Base Rent | Number | Fixed baseline charge |
| Roommates | Room Sq Ft | Number | Private bedroom space |
| Roommates | Net Income | Number | Monthly take-home pay |
| Expenses | Expense Name | Title | Bill description |
| Expenses | Total Cost | Number | The full bill amount |
| Expenses | Date | Date | Due date or charge date |
| Expenses | Category | Select | Rent, Electric, WiFi, or Food |
| Expenses | Roommates | Relation | Links to the responsible people |
Once linked, selecting roommates on an expense pulls their information instantly.
Three ways to split the bill
Different living situations call for different math. The updated Notion formula syntax lets you write these rules directly using dot notation and list functions. You do not need messy rollups anymore.
1. The clean equal split
Use this for shared internet, household paper goods, or identical bedrooms. The formula counts how many people are tagged in the relation and divides the total cost by that count:
prop("Total Cost") / prop("Roommates").length()If an electric bill comes out to $180 and three housemates are tagged, everyone owes $60. Tag four people next month, and the math updates automatically.
2. The square footage split
City apartments often feature one huge master suite and a bedroom the size of a closet. Splitting that evenly builds resentment fast. Instead, calculate rent based on private square footage while splitting common areas evenly.
In the Roommates database, calculate each person's share against the entire apartment's private square feet:
(prop("Room Sq Ft") / prop("Roommates").map(current.prop("Room Sq Ft")).sum()) * prop("Expenses").filter(current.prop("Category") == "Rent").map(current.prop("Total Cost")).sum()That formula looks intimidating, but it is just taking a single person's bedroom footage, dividing it by the sum of all bedrooms, and multiplying by total rent. If someone has a private balcony or a private bathroom, bump their square footage number up by ten percent to reflect that perk instead of building a separate fee.
3. The income-based split
Long-term housemates with wide income gaps often prefer proportional contributions. Each person pays according to their take-home earnings:
prop("Total Cost") * (current.prop("Net Income") / prop("Roommates").map(current.prop("Net Income")).sum())If partner A brings home $6,000 and partner B brings home $4,000, partner A covers 60% of the rent. The total still hits 100%, but nobody gets stretched beyond their means.
Avoiding the Notion free plan trap
Thing is, sharing a Notion page can backfire if you invite housemates the wrong way.
Adding roommates as full workspace members on a free plan triggers a team trial. Once that trial ends, your workspace gets hit with a strict 1,000-block limit that prevents anyone from adding new rows or notes. You do not want that surprise on rent day.
Instead, invite your roommates as Guests to that specific dashboard page. Notion allows up to 10 guests on the free plan without triggering that multi-member block cap.
Give them "Can edit content" access. This allows them to log receipts and mark bills paid. Crucially, it stops them from breaking your formulas.
A monthly routine that actually works
A financial tracker only works if people update it. Set up a simple recurring routine:
- Automate recurring bills using Notion's repeating database templates so rent entries generate on a set schedule.
- Upload utility statements or PDF receipts to a Files and Media property, keeping in mind the free plan caps individual file uploads at 5 MB.
- Add a simple Checkbox property labeled "Reimbursed" for each roommate row so the payer knows who settled up.
- Review past months using filtered database views rather than deleting old rows, giving the whole house a clear record for security deposit returns.
Double-check your percentage math whenever someone moves out or swaps bedrooms. A quick test row ensures your splits still add up to the total rent before anyone sends cash.