Moving out rarely breaks roommate friendships, but dividing an unexpected security deposit deduction almost always does. Who covers the carpet stain in bedroom two? A basic spreadsheet stops these fights before move-out day. You do not need expensive software. A clean Google Sheets setup tracks who paid upfront, who reimbursed whom, and exactly how much cash each person gets back from the landlord.
What Your Deposit Sheet Needs to Track
| Column | Header Name | Purpose | Example |
|---|---|---|---|
| A | Roommate | Tenant name | Jordan |
| B | Deposit Share | Agreed portion of full deposit | $1,000 |
| C | Paid Upfront | Cash sent directly to landlord | $2,000 |
| D | Reimbursement Balance | Net owed between roommates | +$1,000 |
| E | Individual Deductions | Damage charged to this specific person | $150 |
| F | Final Payout | Net refund owed after landlord return | $750 |
Thing is, landlords rarely split return checks. Most property managers issue one joint check or a single electronic deposit to the primary applicant. Your sheet must separate what was sent to management from what roommates settled privately.
Formulas for Roommate Balances and Returns
When the landlord sends back less money than you deposited, you have to split that deduction into shared costs and personal damage, and while it sounds annoying to calculate by hand when everyone is packing boxes and arguing over who left the blender, the formula is straightforward.
Communal costs belong to everyone. Cleaning the oven or patching nail holes in the living room falls under shared expenses. Personal damage belongs only to the person responsible.
Enter your group total deposit in cell B7 and the actual refund received in cell B9. To calculate each person's final payout in column F, use this formula in cell F2:
=B2 - E2 - (($B$7 - $B$9 - SUM($E$2:$E$5)) / COUNTA($A$2:$A$5))
Cell B2 represents the roommate's base deposit share. Cell E2 holds their individual damage charges. The remaining term calculates their equal portion of general landlord deductions. Drag the formula down column F for each roommate.
Handling Uneven Rent and Room Sizes
Splitting a deposit 50/50 makes sense when bedrooms are identical. When one roommate pays $1,400 for a master suite with a private bath and another pays $1,000 for a smaller room, equal splits create friction. Two common approaches work best:
- Rent-proportional split: Each tenant pays a deposit percentage that mirrors their monthly rent percentage. A roommate paying 60 percent of the monthly rent covers 60 percent of the total deposit.
- Equal split with private room add-ons: Everyone splits the base deposit for common areas equally, then adds a fixed flat buffer for private rooms.
Notice that reclaiming deposit funds later requires clear initial proof. Keep a copy of your initial lease payment receipts saved in the same folder as the sheet.
Step-by-Step Setup in Google Sheets
- Open a blank spreadsheet and create two tabs: "Deposit Tracker" and "Receipts and Logs".
- Set up row 1 on the first tab with headers for Roommate, Agreed Share, Paid Upfront, Reimbursement Balance, Individual Deductions, and Final Payout.
- Enter your group's total deposit target and verify that individual shares match the lease.
- Record every reimbursement transaction immediately. If Jordan paid the full $3,000 deposit on June 1, log the cash Sam and Alex sent back to Jordan in your tracker.
- Add a summary row at the bottom using
=SUM(B2:B5)to confirm your numbers balance to zero.
Locking Down Permissions and Formulas
Accidental edits wreck spreadsheet formulas fast. When four people have full edit access from their phones, someone will inevitably overwrite a calculation with plain text.
Google Sheets allows you to protect specific sheets and ranges so roommates can only edit designated input fields:
- Highlight columns with formulas, right-click, and select "Protect range".
- Set permissions to "Only you" so roommates cannot alter balance or payout formulas.
- Leave input columns like "Paid Upfront" and notes open for everyone to update.
Move-Out Deductions and Dispute Rules
Turns out, most deposit disagreements do not happen between tenants and landlords. They happen between roommates after the check arrives.
A landlord might charge $400 for carpet replacement. If one roommate had a puppy, that deduction should not come out of the general pot. Request an itemized deduction receipt from your landlord before distributing any money. Landlord-tenant laws in most states require landlords to provide written lists of repair costs within 14 to 30 days of move-out. Check your state deadlines for returning security deposits if management stalls on sending the itemized statement. Attach that breakdown directly to your tracker.
What to Do Next
To be honest, the best time to set up this sheet is the day you sign your lease, not the week you pack moving trucks.
Set up your tracking sheet before sending the initial deposit to management. Agree on bedroom shares, share the link with your housemates, and save date-stamped move-in photos in an attached folder. You will thank yourself when move-out day comes around.