Can you trust everyone to remember who fronted what for the security deposit three years ago? Probably not. To track a shared security deposit in Notion, set up a simple table database with properties for contributor names, payment dates, amounts paid, refund targets, and status tags. Then add two short formulas for remaining balances and return deadlines. It takes twenty minutes to build.
The setup gives your household a clear paper trail when someone moves out early or when the landlord sends back a single check.
Notion Versus a Basic Spreadsheet
A spreadsheet works fine if two people split an even deposit and leave at the same time. You enter two numbers, sum them up, and close the file.
Thing is, shared apartments rarely stay that simple. If you have four roommates who all paid different amounts at different times, trying to figure out who gets what from an incomplete refund check months later is a headache nobody wants to deal with on moving day. Roommates move out mid-lease. People pay unequal shares based on room square footage or private bathrooms. At move-out, landlords often issue one joint refund check payable to all tenants. Notion handles this better because you can create filtered views, track refund dates, and link photos of move-in condition reports.
Core Database Properties
Open a new page in Notion and type /database to insert an inline database. Notion allows up to 500 database properties per table, but eight to ten fields handle the job without clutter.
| Property Name | Type | Purpose |
|---|---|---|
| Roommate | Select or Person | Identifies who paid the initial cash. |
| Target Share % | Number (Percent) | Records each person's agreed split. |
| Amount Paid | Number (Currency) | The exact dollar amount transferred at move-in. |
| Payment Date | Date | The date the funds cleared. |
| Refund Received | Number (Currency) | Actual money returned to that person. |
| Status | Select | Tags for Pending, Partial, or Settled. |
| Expected Refund Date | Date | The legal deadline for the landlord to return funds. |
| Balance Due | Formula | Calculates what the roommate is still owed. |
| Notes & Receipts | Files & media or Text | Stores transfer screenshots and inspection notes. |
Set the format of your number fields to U.S. Dollars inside the property settings. This keeps the math clean.
Formulas for Balances and Deadlines
Notion's formula editor handles calculations across rows using standard property references. You need two main formulas to automate your tracking.
First, calculate what each person is still owed:
if(prop("Status") == "Settled", 0, prop("Amount Paid") - prop("Refund Received"))This subtracts any partial payouts from the original amount paid. Marking the row as Settled zeros out the balance instantly.
Second, track the landlord's return deadline:
dateDiff(today(), prop("Expected Refund Date"), "days")This shows the number of days left before the deadline. It turns negative once the date passes, warning you that the deposit is overdue.
To be honest, handling unequal room splits is where people make the most mistakes. If someone pays 30% of the rent, assign them a 30% deposit share. When deductions occur, apply that same percentage to the net refund so everyone absorbs damage or fees proportionally.
Sharing and Access for Roommates
You do not need paid workspace seats for your roommates. Notion lets you invite household members as free guests via their email addresses.
Open the Share menu in the top right corner. Grant roommates "Can edit" access if they need to enter payment amounts or upload receipts. Choose "Can view" if you want to prevent accidental edits to formulas. Notion's sharing and permissions ensure guests only see the specific pages you explicitly share with them.
Turns out, adding a "Last edited time" property solves most trust issues. It logs when any roommate edits a number. That timestamp creates an automatic audit trail.
Move-Out Deductions and Records
A Notion database organizes your numbers, but it cannot fix landlord disputes on its own. State rules differ significantly. In New York, for example, landlords generally must return the deposit with an itemized statement within 14 days after move-out. Other states allow 30 or 60 days.
When the refund check arrives, follow this process to close out the books:
- Review the landlord's itemized deduction list against your move-in inspection notes.
- Assign room-specific damage costs directly to the person who lived in that room.
- Divide shared-area deductions across all roommates according to their agreed share percentages.
- Record the final payouts in your Refund Received column and export the view to a PDF.
Keep PDF copies of bank transfers and photos of the cashier's check stored in the database. Clear records keep move-out day civil.