To make a security deposit tracker in Notion, create a new database page, add properties for roommate names, payment amounts, dates, and refund status, then use formulas to calculate balances and days until refund. This setup helps U.S. roommates or shared housing groups monitor who paid what toward a deposit, track expected refunds, and document splits for moves or disputes.

For example, with a $2,000 deposit split among four roommates, enter each person's contribution, add a refund date estimate, and let formulas show remaining balances. Test with sample entries before sharing. The process takes under 30 minutes and uses Notion's database properties and formulas.

When to Use a Notion Tracker for Security Deposits

Notion works well for security deposit tracking when your group needs linked views, like filtering by roommate or status, or relations to a full expenses database. Roommates in shared U.S. rentals often track deposits separately from monthly rent due to refund timing at move-out.

Use Notion if your group has uneven splits, such as by room size or income, and wants visual boards or calendars. For equal splits on one-time deposits, a Google Sheets sum formula often suffices without Notion's structure.

Decision tree for tool choice:

  • One deposit, equal split, no ongoing updates? Use Google Sheets with columns for names and amounts; sum at bottom.
  • Multiple contributions, refund tracking, group edits? Build in Notion.
  • Full household expenses with chores or utilities? Consider relations to another database.

Spreadsheets handle basic sums faster for simple cases, while Notion adds flexibility for views like "Unrefunded" lists.

Core Database Properties for Your Tracker

Start with these properties, drawn from Notion's database options. Each database supports up to 500 properties, per the Notion Help Center.

Recommended setup:

  • Person: Select property for roommate names. Type names and press enter to add options.
  • Amount Paid: Number for contributions (e.g., 500).
  • Payment Date: Date for when paid.
  • Refunded: Checkbox or Select (Yes/No/Partial) for status.
  • Refund Amount: Number for received refund.
  • Expected Refund Date: Date for lease end estimate.
  • Balance: Formula (detailed below).
  • Created time and Last edited time: Auto-added timestamps for records.
  • Notes: Text for receipts or landlord comments.

For groups, add a Multi-select for payment methods (Cash, Venmo, Check). Limit to essentials to stay under the 500-property cap.

Setup Steps to Build the Tracker

  1. In Notion, create a new page and type /database to insert an inline or full-page database (table view).

  2. Add properties: Click the + in the table header. Choose types like Select for Person, Number for Amount Paid, Date for Payment Date. Notion's formula editor handles calculations.

  3. Enter sample data: For a $2,000 deposit with four roommates - Alex ($600), Jordan ($500), Taylor ($450), Casey ($450). Set Expected Refund Date to lease end.

  4. Create views: Click + New View. Add a Board grouped by Refunded (Kanban for To Refund/Done), a Calendar by Expected Refund Date, or a List filtered by Person.

  5. Test formulas (next section) and share (below).

This mirrors simple budget systems with connected properties, as seen in editorial examples like budget trackers on Medium.

Formulas for Balances and Tracking

Edit formulas in Notion's formula editor. Use official date units: years, quarters, months, weeks, days, hours, minutes.

Balance formula (remaining owed):

if(prop("Refunded"), 0, prop("Amount Paid") - prop("Refund Amount"))

Shows amount still due if not fully refunded.

Days until refund due:

dateDiff(today(), prop("Expected Refund Date"), "days")

Positive for future dates; negative if overdue.

Total group balance (in a summary rollup or separate formula page):

sum(prop("Amount Paid")) - sum(prop("Refund Amount"))

Add to database or a linked summary.

For uneven splits, add Share % (Number, e.g., 0.25) and adjust balance:

(prop("Amount Paid") * prop("Share %")) - prop("Refund Amount")

Roommate example: Total deposit $2,000. Alex's balance formula shows $100 if $500 paid but $400 refunded.

Copy-paste into the editor; preview before saving.

Sharing, Permissions, and Update Cadence

Share via the top-right Share button. Invite roommates by email; set to "Can edit" for updates or "Can comment" for reviews. Conditional colors on properties require Can edit access or higher.

For roommate groups, use guest access without full accounts. Weekly checks: Sort by Last edited time to spot stale entries.

Export views to PDF for landlord records or moves. Update cadence: Monthly for active leases, weekly near move-out.

Common Mistakes and Limitations

Databases cap at 500 properties; avoid bloat by sticking to 8-10 core ones. No official Notion template exists for security deposits, so build custom.

Common pitfalls:

  • Forgetting timestamps: Rely on Created time and Last edited time for audit trails.
  • Overcomplicating: If no relations needed (e.g., to utilities database), Google Sheets sums work without Notion's learning curve.
  • Rare edits: Formulas don't auto-recalculate offline; reopen page.
  • Records only: Track for group reference, not as legal proof. U.S. landlord-tenant rules vary by state; keep receipts separate and consult local laws for disputes.

Switch to Sheets for one-off deposits without views. For complex budgets, editorial workflows like Medium's transactions database inspire relations, but test simply first.

FAQ

Can I link this to a transactions database for full expenses?
Yes, use Relation properties to connect deposits to a monthly bills database for rollups like total household spend.

What formula shows days until the deposit refund is due?
dateDiff(today(), prop("Expected Refund Date"), "days") - positive for time left, negative if past due.

How many properties can I add before hitting limits?
Up to 500 per database, per Notion's help center.

Is Notion sharing secure for roommate groups?
Guest sharing uses permissions like Can edit; suitable for small trusted groups. Export PDFs for static records.

When should I use Google Sheets instead?
For basic equal splits or one-time tracking without custom views or relations.

How do I handle uneven deposit splits (e.g., by room size)?
Add Share % property; modify balance formula to prop("Amount Paid") * prop("Share %") - prop("Refund Amount").

Next, add 2-3 sample entries, share a test view with your group, and pair with a folder of receipt photos for complete records.