Use Notion database filter views to create custom perspectives on roommate rent splits. Set up properties like "Roommate" (multi-select), "Amount Due" (number), "Status" (select: Due, Paid, Overdue), and "Due Date" (date). Then apply filters for views such as "My Unpaid Rent" or "Alex's Share."

This approach helps U.S. roommates track rent, utilities, and splits in one shared database. Filter by roommate or status to focus on what's due, without needing payment apps. Public templates from Notioneers and Notion Things provide starting points you can duplicate and adapt.

Set Up a Notion Database for Roommate Rent Splits

Start with a new database in Notion for roommate expenses. Choose table layout for easy entry and filtering.

Add these properties, based on Notion's database options:

  • Name: Default title for each entry, like "January Rent" or "Utilities Bill."
  • Expense Type: Select property with options such as Rent, Utilities, Groceries, Deposit.
  • Roommate: Multi-select for who shares the expense (e.g., Alex, Jordan, Sam).
  • Amount: Number property for total cost.
  • Amount Due: Number for each roommate's share. Enter manually or note split method (equal, room size).
  • Paid By: Select for who covered it initially (e.g., Alex Paid, Group Venmo).
  • Status: Select with Due, Paid, Overdue.
  • Due Date: Date property.
  • Paid Date: Date for when reimbursed.
  • Notes: Text for receipts or proof.

To add a property, open the database, click the + next to existing columns, and select the type. Use multi-select for Roommate to tag multiple people on shared items.

For expansion, add a Relation property linking to a separate database for household rules or chores. This connects rent to related tasks without overcomplicating the main table. Notion supports up to 500 properties per database, but keep under 20 for roommate use to avoid clutter.

Enter sample data: Add a row for rent with Total $2,400, split equally among 3 roommates ($800 each), Status Due, Due Date end of month.

Create Filter Views for Rent Split Tracking

Filter views let you slice the database for roommate-specific needs. Views show with a • symbol in the left sidebar.

Create a new view: Click + New View at database top, name it (e.g., "Unpaid Rent"), choose layout like table or timeline.

Apply filters via Filter menu:

  • Simple filter: Status is "Due."
  • Advanced: Status is "Due" AND Roommate contains "Alex."

Combine with Sort (Due Date ascending) and Group by Roommate. For visuals, switch to timeline layout grouped by month to see rent due over time.

Practical examples:

  • My Unpaid Rent: Filter Status "Due" OR "Overdue," Roommate contains your name, sort by Due Date.
  • Alex's Share: Roommate contains "Alex," group by Expense Type.
  • Overdue Items: Status "Overdue," sort by Amount Due descending.
  • Monthly Overview: Filter Due Date in "This month," group by Roommate.

Edit filters by clicking the filter icon in the view. Use AND/OR logic for precision, like (Status "Due" AND Paid By "Not Me"). These persist per view, so roommates see tailored data without changing the full database.

For more on filters, sorts, and groups, see Notion's guide to views, filters, and sorts.

Duplicate and Adapt Shared Expense Templates

Public templates speed setup. The Notioneers Split Expenses template tracks shared costs for roommates or trips. Duplicate via the button, then add rent properties like Due Date and Status.

Notion Things offers a Roommate Hub template with sections for rent, utilities, expenses, and chores. It includes grocery lists and calendars - adapt by adding filter views for unpaid rent.

Steps to use:

  1. Open template link, click Duplicate in top-right.
  2. Rename to "Our Rent Tracker."
  3. Add properties as above if missing.
  4. Create views: One filtered by unpaid Status, grouped by Roommate.
  5. Test with sample rent entries.

These beat static Excel lists since linked views update across filters. Customize for your split (e.g., filter for uneven shares by room size).

Sharing Your Rent Split Database

Share the full database for collaboration. Click Share button, invite roommates by email, set to Can Edit for updates.

Editors can add entries, change Status, or tweak filters in views. For comment-only, select Can Comment - good for reviews without accidental changes.

For details on properties like relations, see Notion's database properties guide.

Common Mistakes and When to Use Alternatives

Avoid these pitfalls:

  • Overloading properties: Stick to essentials; Notion caps at 500 but usability drops after 20.
  • Unlinked databases: Use Relations for chores or rules instead of separate pages.
  • Ignoring timestamps: Add Created Time and Last Edited for audit trails on changes.
  • Over-relying on filters: Update Status promptly; stale data confuses splits.
  • No backups: Export to CSV monthly via ... menu.

If filters feel complex for one-off splits, use Google Sheets with simple tabs per roommate. Sheets handles basic sorts without learning curves. Notion suits ongoing tracking with visuals; spreadsheets work for static records.

Stick to documentation for shared expenses - pair with receipt photos in Notes for proof.

FAQ

How do I filter a Notion view to show only my roommate's unpaid rent?
Create a view, add filter: Status is "Due" AND Roommate contains their name. Sort by Due Date.

What properties work best for tracking uneven rent splits by room size?
Use Amount Due (number), Roommate (multi-select), Notes for split basis (e.g., "Larger room: 40%"). Filter by Roommate.

How often should we review the rent split database?
Monthly, before bills due. Mark Status Paid after reimbursements.

Are there free Notion templates specifically for roommate rent?
Yes, duplicate free ones like Notioneers Split Expenses or Notion Things Roommate Hub, then add rent filters.

Does Notion support formulas for auto-calculating shares?
Formula properties exist for math, but set up manually for splits like total / roommates. See Notion help for basics.

Next, duplicate a template, add your properties, and test filters with real data. Review as a group before first use.