Use a shared Google Sheets template with columns for roommate names, agreed percentage shares based on room size or value, contributions paid, and refund shares to calculate security deposit splits fairly. This helps U.S. roommates track move-in payments, refunds, and balances without relying on apps. Agree on percentages before signing the lease to ensure fairness. Document the unit's condition with photos at move-in. Enter data row-by-row: total deposit, each person's share paid with receipt notes, and calculated refund portions on return. Share the sheet via edit link for group updates, restricting changes to approved contributors. This keeps records clear for small groups handling one-time deposits.
Why Track Security Deposits by Percentage in a Spreadsheet
Percentage-based tracking suits roommates with unequal rooms or contributions. It allows splits by room size, where larger spaces carry higher shares, or by other agreed factors. Tracking each person's contribution and refund share in a shared spreadsheet handles returns fairly and avoids disputes. Agreeing on the deposit division before moving in prevents conflicts.
Spreadsheets work well for small, informal groups like roommates or shared housing setups. They provide a central record without subscription fees or app logins. Tradeoffs exist: equal splits simplify math but ignore room differences, while percentage methods promote fairness at the cost of upfront discussion. Room size or income can serve as bases for rent splits, which extend to deposits. For low-recurrence needs like move-in deposits, a spreadsheet often suffices over payment apps.
Decide Your Percentage Split Method
Start by discussing split methods as a group. Measure room square footage for a size-based percentage. Assign shares by bedroom value, such as factoring in private bathrooms or location. Consider income differences if one roommate earns less.
Use this decision tree:
- If rooms vary in size, measure each and calculate percentages from total square footage.
- If sizes are similar, default to equal splits unless income or usage differs.
- Assign by combined factors like room plus shared amenities.
Document the chosen method in writing, signed by all, before paying the deposit. Revisit only with group approval. This prevents mid-lease arguments. Percentages should sum to 100% across roommates.
Set Up Your Security Deposit Split Calculator Template
Create a new Google Sheet named "Security Deposit Tracker - [Address] - 2026". Use one tab for the main tracker.
Recommended columns (enter headers in row 1):
- Roommate Name
- Room Size/Value (e.g., sq ft or descriptive note)
- Agreed % Share (e.g., 35%)
- Total Deposit Amount (same for all rows)
- Contribution Paid (yes/no, amount, date, receipt note)
- Refund Expected (= % share times total refund; update on return)
- Balance Owed/Received (contribution minus refund share)
Steps:
- List roommates in column A, starting row 2.
- Enter room details in B, percentages in C (ensure they sum to 100% via a totals row).
- In column D, input the full deposit once; reference it across rows.
- Column E: Mark payments with dates (e.g., "Yes, $1,200 on 1/15/26, Zelle receipt saved").
- On refund day, enter total returned in a summary cell, then calculate shares in F.
- Track balances in G for any deductions.
Add a summary section at top: total deposit, total contributed, total refunded, discrepancies. Use basic sum functions for totals. No advanced scripting needed. Update on move-in and refund day.
Document and Share to Prevent Disputes
Prevention starts with proof. Take dated photos of the unit's condition at move-in, including walls, floors, appliances. Create a shared photo folder (Google Drive or similar) and checklist: note existing damage, cleanliness, fixtures.
Save all payment receipts: bank statements, transfer confirmations, lease copy showing deposit. Store links in the sheet's contribution column.
Sharing notes: Generate a Google Sheets link with "Editor" access for contributors only. Avoid "Anyone with link" to prevent unapproved edits. Set update cadence: review monthly or on key events like lease renewal. Require group email approval for percentage changes.
On refund, landlord emails total (minus deductions). Update sheet together via video call, calculate shares, and note reimbursements paid (e.g., Venmo with memo). Export as PDF for records.
Common Mistakes and When to Use a Spreadsheet vs App
Skipping move-in photos or receipts risks disputes over damage claims. Changing percentages without group sign-off leads to resentment. Forgetting to sum shares to 100% creates math errors.
Spreadsheets suit small groups (2-6 people) with infrequent updates, like one deposit per move. They keep everything free and customizable. For larger groups or ongoing expenses, consider apps with receipt scanning as examples, but separate tracking from payment. A sheet plus folder of receipts often handles deposits fully. If scaling to monthly bills, evaluate lightweight trackers, but start simple.
FAQ
How do I calculate each roommate's share of the security deposit refund?
Multiply their agreed percentage by the total refund amount, then subtract from their original contribution. Update in the sheet's refund column.
What columns does a basic security deposit tracker need?
Roommate Name, Room Size/Value, Agreed % Share, Total Deposit, Contribution Paid, Refund Share, Balance.
Should we split by room size or equally?
Consider room size for fairness if unequal; equal works for similar spaces. Agree upfront.
How do we handle changes to percentage shares mid-lease?
Require written group approval and document in the sheet to avoid disputes.
Why document the apartment condition before moving in?
Photos and checklists prove starting condition, helping contest unfair deductions.
Is a shared spreadsheet enough for security deposit records?
Yes, for small groups - add receipts and photos for complete proof.
Next, create your sheet today, agree on percentages, and photo the unit on move-in day. Review records before refund time.