Use a Google Sheets tracker with columns for date, description (e.g., "security deposit"), amount, split type, and per-person shares to monitor who paid what and balances owed. This setup helps U.S. roommates record upfront security deposit payments, prorate shares by rent or agreement, and track refunds or deductions at move-out. Enter the total deposit amount once, assign percentages based on your group's rules, and add rows for ongoing expenses like rent or utilities to maintain running balances.
Start with a new sheet named "Roommate Expenses - Security Deposit Tracker." In row 1, add these headers: Date, Description, Payer, Total Amount, Split Type, and columns for each roommate's share percentage (e.g., Person 1 Share %, Person 2 Share %, etc.). Below Total Amount, include Balance Due and Status columns for refunds.
For example, on January 1, 2026, enter: Date = 2026-01-01, Description = "Apt 123 security deposit," Payer = "John," Total Amount = $2000, Split Type = "rent-proportioned." Then fill shares like 50% for Person 1 and 50% for Person 2.
Why Track Security Deposits with an Amount Column
Security deposits often involve one roommate paying upfront while others reimburse over time. Tracking with an amount column ensures everyone sees the total paid to the landlord, individual contributions, and any owed balances. This prevents disputes at move-out when refunds arrive.
In roommate scenarios, deposits cover potential damages beyond normal wear and tear. Uneven upfront payments are common - one person might cover the full amount from savings, expecting splits later. A dedicated tracker ties the deposit to other shared costs like rent, making it easier to settle everything together.
U.S. state laws vary on deposit handling, so check your local tenant resources for specifics. This sheet keeps records clear without replacing legal agreements.
Recommended Columns for Your Security Deposit Tracker
Core columns match shared expense needs, with an amount column for the deposit total:
- Date: When the expense occurred (e.g., 2026-01-01).
- Description: Details like "Apt 123 security deposit" or "Move-out refund."
- Payer: Who paid the landlord or reimbursed (e.g., "John").
- Total Amount: Full deposit or refund figure (e.g., $2000). This is your keyword amount column.
- Split Type: Equal, rent-proportioned, or reimbursement (e.g., "rent-proportioned").
- Person 1 Share %, Person 2 Share %, etc.: Percentages adding to 100% (e.g., 50%, 50%). Adjust columns for your group size - insert or delete as needed.
- Balance Due: Tracks remaining owed after payments.
- Status: Paid, pending, refunded, or deducted.
Rename share columns to roommate names (e.g., "Bob Share %," "Joe Share %"). For larger groups, add more. This setup scales for 2-6 people without complexity.
Setup Steps for Google Sheets Security Deposit Tracker
Follow these steps for a working tracker:
-
Go to Google Sheets and create a new blank sheet. Name it "Roommate Security Deposit Tracker 2026."
-
In row 1, enter the column headers listed above. Bold them for clarity.
-
Add the security deposit as the first row: Date in A2, Description in B2 (e.g., "Security deposit to landlord"), Payer in C2, Total Amount in D2 (e.g., $2000), Split Type in E2 (e.g., "equal").
-
Fill share percentages in F2 onward (e.g., 33% each for three roommates). Manually calculate individual amounts if needed by multiplying Total Amount by each %.
-
Add rows below for other expenses: rent, utilities, groceries. Use "reimbursement" in Split Type for one-off payments - one person at 100%, others at 0%.
-
Update monthly: Review entries, note payments received, and adjust Balance Due. At move-out, add a refund row with negative Total Amount.
Review the sheet before paying rent or at month-end. Print or export to PDF for records.
Sharing and Collaboration Basics
Share via the Share button: Enter roommate emails and set as editors. This allows group access.
Google Sheets supports real-time edits - changes appear live for all editors. For trust issues, set some to view-only. Use comments for notes like "Paid my share via Venmo."
Protect the sheet: Lock header rows (View > Freeze > 1 row) and formulas if added later. Share a view-only link for landlords if documenting payments.
Common Mistakes and U.S. Deposit Tracking Tips
Forgetting to prorate shares by actual agreement leads to imbalance - one roommate overpays long-term. Always document landlord emails or receipts in a shared folder.
Not tracking communications: Save landlord notices on deductions in the Description column or links.
Ignoring state variations: U.S. security deposit rules differ by state - refund timelines and limits vary. This is not legal advice; consult local tenant rights resources or state housing agencies.
Other pitfalls: Mixing deposits with regular expenses without clear Status updates, or failing to note partial refunds. Update promptly after landlord responses.
For damages, note agreed splits in advance via group rules. Keep physical receipts alongside the sheet.
FAQ
How do I prorate security deposit shares unevenly?
Use rent-proportioned splits: If Roommate A pays 60% rent, assign 60% deposit share. Enter percentages in share columns; they must total 100%.
What if one roommate paid the full deposit upfront?
List them as Payer, set their share to 100% initially (or per agreement), others to owed amounts. Mark reimbursements as they pay.
When should we review the tracker for move-out?
Monthly for balances; fully 30 days before lease end. Add refund row immediately upon receipt.
Is a spreadsheet enough, or do we need an app?
For basic tracking, yes - add rules and receipts. Apps suit receipt scanning but aren't required.
How do state laws affect deposit refunds?
States set timelines and max amounts; penalties apply for improper holds. Check your state's attorney general site.
Can we track deposit deductions for damages?
Yes, add a row: Description = "Deduction for wall damage," Total Amount = -$300 (negative), split per responsibility.
Next, agree on split rules in writing, photograph the apartment at move-in, and back up the sheet monthly.