Yes, but set it up around individual balances rather than one household total. You can build a practical Notion rent tracker without buying a template: create one row per roommate per billing month, then connect payment entries to those rows.
For $2,400 monthly rent split four ways, each equal-share row calculates to $600. Uneven shares work too, but the percentages must total 100% before anyone pays.
Notion fits best when rent records need to sit alongside lease notes, utility rules, or receipt links. To be honest, Google Sheets or Excel may be quicker for a short, numbers-only list. Notion's database help covers the current database creation flow.
Start with the row that needs a balance
A single row for the whole household looks tidy. It does not show who still owes money.
Use one row for each roommate and billing month instead. For four roommates, May produces four rent-share rows. This design makes partial payments, late balances, and uneven shares much easier to track.
A Select property is usually simpler for roommate names. A Person property is better for people who are actually part of the Notion workspace, so don't invite collaborators just to label a row.
Build the rent-share database
Create a full-page table database and add the properties below. Rename the first title column to Name, then use a label such as Alex - May 2026.
| Property | Type | What to enter |
|---|---|---|
| Name | Title | Roommate and billing month |
| Roommate | Select | Alex, Jordan, Taylor, or Casey |
| Billing month | Date | Use the first day of the month |
| Household rent | Number | For example, 2400 |
| Roommate count | Number | For example, 4 |
| Share percentage | Number formatted as Percent | Leave blank for equal splits; use 30% for an uneven split |
| Amount due | Formula | Use one of the share formulas below |
| Paid | Number or Rollup | Start at 0, or sum related payment records |
| Balance | Formula | Amount due minus Paid |
| Due date | Date | The actual date rent is due |
| Status | Formula | Pending, Paid, or Overdue |
Enter the same household rent and roommate count on each row for that billing month. Historical rows should keep their original values, even if the rent or household changes later.
Choose an equal or uneven rent formula
For an equal split, set the Amount due formula to:
prop("Household rent") / prop("Roommate count")With $2,400 and four roommates, the result is $600.
For an uneven split, format Share percentage as a percentage and use:
prop("Household rent") * prop("Share percentage")A 30% share of $2,400 is $720. A sample 30%, 25%, 25%, and 20% arrangement adds up to the full rent.
Check the percentage total yourself. Notion can calculate the amount, but it can't decide whether the household's rule is fair. Write down the reason for the split first, whether that is income, room size, parking, or nights stayed.
If the results include fractions of a cent, agree on who absorbs the extra cent. Silent rounding creates small discrepancies that become annoying later.
For the Balance property, use:
prop("Amount due") - prop("Paid")A positive balance means money remains due. A zero or negative balance means the row is fully covered or overpaid.
The Notion formula guide lists supported functions and date units. Formula names and property names must match your database exactly.
Keep payment history instead of overwriting a total
A single Paid number works for a very small household. It loses the story when someone pays in two parts, pays late, or disputes an amount.
Create a second database called Payments when you need a cleaner record.
| Payment property | Type | Example |
|---|---|---|
| Payment | Title | Jordan - May first payment |
| Rent share | Relation | Jordan - May 2026 |
| Amount | Number | 300 |
| Paid on | Date | The transfer date |
| Payer | Select | Jordan |
| Note | Text | Partial payment |
| Receipt reference | URL or Text | Link or confirmation note, if appropriate |
In the rent-share database, relate each row to its payment records. Change Paid from a plain Number to a Rollup that sums the related Amount values. Leave the Balance formula unchanged.
Record two payments as two payment rows. A $300 payment followed by another $300 payment should produce a $600 rollup, not a replacement value.
A Notion entry records what your group entered. It does not move money or verify a transfer. Compare it with the payment app's confirmation, bank record, or receipt, and don't store account passwords or full account numbers in the database.
Set due dates that do not drift
Use a real Due date property for each rent row. A fixed date preserves the history better than a formula tied to today's date.
To calculate a following date from the current row, use:
dateAdd(prop("Due date"), 1, "months")The commonly used formula dateAdd(now(), 1, "months") is relative to the moment the page is viewed. It can help with a moving reminder, but it does not automatically mean the first day of next month.
Month-end dates need a quick check. Adding one month to a 31st can land on a different day in a shorter month, so test rows around February and the end of the year.
For a readable date label, use:
formatDate(prop("Due date"), "MMMM D, Y")That displays a date such as January 1, 2026. The actual Date property should remain the source for sorting and status checks.
You can calculate the status with:
if(empty(prop("Due date")), "Set due date", if(prop("Balance") > 0, if(now() > prop("Due date"), "Overdue", "Pending"), "Paid"))This status updates as time passes. That is useful for a current dashboard, but it means an old row can change from Pending to Overdue later. Add a manual review note if you need to preserve what the group saw at the time.
Share the page without giving away the structure
Open Share and invite only the people who need access. Notion's sharing and permissions guidance describes the available access levels, which can depend on the workspace setup.
| Access level | Sensible use |
|---|---|
| Can view | Roommates who only need to check totals |
| Can edit content | Roommates who should update rows but not change the database structure, if this option appears |
| Can edit | A trusted person who maintains formulas, properties, and views |
Full editing access can allow someone to change formulas, add properties, or alter views. Start with the smallest permission that supports the workflow.
Thing is, a filtered view is not the same as a private ledger. Don't assume that hiding rows from a view prevents access to the underlying database. Test the page with one invited account before sharing payment details widely.
You can test the tracker on the plan you already have; you do not need to purchase a template. Shared-member, guest, file, and workspace limits can change, so check Notion's current plan information before adding lots of collaborators or household documents. Avoid relying on old advice that quotes one permanent block limit.
Run a short monthly review
A consistent routine matters more than a clever formula.
- Create the new roommate-month rows by copying the prior month's structure.
- Change the billing month, rent amount, due date, and any agreed percentages.
- Clear old payment relations and confirm that the new
Paidvalue starts at zero. - Add each payment as it happens, including partial payments.
- Review rows with a positive balance before the due date.
- Save or export a copy if your household needs records outside Notion.
Create a table view for all rows, a calendar view for due dates, and a status view for unpaid balances. Keep the views simple enough that a roommate can understand them without a formula lesson.
Keep the lease, landlord notices, utility bills, receipts, and payment confirmations available separately. A Notion tracker is a shared record, not a payment service or a replacement for lease obligations. State and local rules can differ if a rent dispute develops.
Fix the mistakes that cause roommate disputes
| Common mistake | Better fix |
|---|---|
| One row contains every roommate | Use one row per roommate per billing month |
| A multi-select list calculates the headcount but not each balance | Add separate roommate rows |
The Paid number gets overwritten each month |
Use a Payments database and a rollup |
now() becomes the historical due date |
Store each due date in a Date property |
| Uneven percentages do not add to 100% | Check the total before recording payments |
| Everyone receives full edit access | Use view or edit-content access when available |
| A filtered view is treated as private | Test actual access with an invited account |
| Payment notes contain sensitive account details | Record only the amount, date, payer, and safe receipt reference |
Questions roommates usually ask
Can I use one row for the whole household?
You can use one household row for a summary, but it is a poor choice for individual balances. Separate roommate-month rows are easier to reconcile.
How do I split rent unevenly in Notion?
Add a percentage for each roommate and multiply it by household rent. Confirm that all percentages total 100%, then keep the reason for the arrangement in a note or separate household rules page.
Is Notion free enough for this tracker?
You can build and test the database without buying a template. Whether a free workspace fits your shared setup depends on current collaborator and workspace limits, so check Notion's current terms before inviting the entire household.
Can Notion confirm that rent was paid?
No. It can record the payment details your group enters and sum related records. Verify transfers against the external payment confirmation or other receipt.
Before sharing the page, create a test month with four rows, set rent to $2,400, and enter a $300 payment on one row. Confirm that row shows a $300 balance while an unpaid $600 row remains Pending. Clear the test entry, add your written split rule, and invite the first roommate.