To make a rent split calculator in Notion, you need two related databases: one for Roommates and one for Expenses. By using a Relation property to connect them, you can aggregate costs and apply formulas to divide the total. Notion Formulas 2.0 allows you to calculate shares based on equal splits, income percentages, or square footage. This setup provides a central record for household finances without requiring external apps. You can customize the logic to handle recurring monthly rent or one-off utility bills, helping everyone see exactly what they owe in a shared workspace.

Database setup

The foundation of a Notion rent split calculator is a two-database system. This structure allows you to track individual roommate details separately from the actual bills.

Database A - Roommates

Create a database named Roommates with the following properties:

  • Name (Title): The name of each person.
  • Base Rent (Number): The fixed amount they pay if using a room-size split.
  • Income (Number): Their monthly take-home pay if using an income-based split.
  • Room Sq Ft (Number): The square footage of their private space.

Database B - Expenses

Create a second database named Expenses to track monthly bills:

  • Expense Name (Title): e.g., January Rent or Electric Bill.
  • Amount (Number): The total cost of the bill.
  • Date (Date): When the bill is due or was paid.
  • Category (Select): Rent, Utilities, Groceries, or Internet.

Connecting the databases

To calculate splits, you must link the two databases using a Relation property. In the Expenses database, add a new property and select Relation. Choose the Roommates database.

Once the relation is established, you can select which roommates are responsible for a specific expense. For a standard rent bill, you would typically select all roommates. For a specific grocery run, you might only select two.

Formulas 2.0 makes it easier to pull data across these relations. You can use dot notation to access properties from the related Roommates database directly within your Expense formulas.

Common split formulas

Once your databases are linked, you can add a Formula property to the Expenses database to calculate the split. Here are three common methods using Formulas 2.0 syntax.

1. Equal split

This method divides the total amount by the number of roommates selected in the relation.

  • Formula: prop("Amount") / prop("Roommates").length()

2. Income-based split

This method calculates a person's share based on their percentage of the total household income.

  • Logic: prop("Amount").multiply(current.prop("Income") / prop("Roommates").map(current.prop("Income")).sum())
  • Note: This requires a multi-line formula in the Roommates database to show individual totals.

3. Room-size split

If one roommate has a significantly larger room, you can split the base rent by square footage.

  • Formula: (prop("Room Sq Ft") / prop("Total Sq Ft")).multiply(prop("Total Rent"))

The Notion formula editor allows you to add comments and breaks to these calculations, which helps with troubleshooting if the math seems off.

Managing sharing and permissions

When sharing a rent calculator with roommates, consider Notion's workspace limits and permission levels.

The 1,000-block limit

On the Notion free plan, adding a second Member to a workspace may trigger a Team Trial. Editorial guides from Thomas Frank note that this trial often imposes a 1,000-block limit on the entire workspace. To avoid this, you can add roommates as Guests to the specific page rather than full workspace members.

Permission levels

To protect the integrity of your calculator, use the Can Edit Content permission level. This allows roommates to add new expenses and check off paid bills but prevents them from accidentally deleting or changing the formulas and database properties.

Workflow and recordkeeping

A calculator is only effective if the data is consistent. Establish a household workflow to keep the Notion page updated:

  • Update cadence: Set a specific day each month to log all upcoming bills.
  • Receipt attachments: Use a Files and Media property in the Expenses database to upload photos of utility bills or rent receipts.
  • Payment status: Add a Checkbox property named Paid to track when a roommate has reimbursed the person who paid the primary bill.
  • Recurring dates: Use the dateAdd() function in a formula to calculate the next month's due date once a bill is marked as paid.

By centralizing these records in Notion, you create a transparent history of household spending that can be reviewed if a dispute arises regarding past payments or deposit returns.