Split a Security Deposit by Income in Google Sheets

Why should three people pulling very different paychecks hand over the same chunk of move-in cash? They shouldn't have to. Splitting a security deposit by budget share ties each roommate's contribution to what actually lands in their account each month, which keeps upfront moving costs from wrecking a lower earner's balance. The math takes about five minutes in Google Sheets. Take your monthly income, divide it by the group's total, multiply that fraction by the deposit. Done.

Why Split Deposits by Income Instead of Headcount

Equal splits look tidy. They work fine when paychecks are similar.

When earnings diverge, though, the flat cut stings. Demanding $1,000 from someone who clears $2,500 a month is a very different ask than taking $1,000 from someone making $6,000, even though the number on paper is identical.

Here's the part people forget: a deposit isn't an ongoing expense. It's escrowed with the landlord until the lease ends. Whoever puts in 40 percent owns 40 percent of the eventual refund. Rental management platforms like Azibo and Doorloop treat income-based sharing as a real alternative to flat headcounts, and the reasoning holds up. A lower-earning roommate draining their entire checking account just to get keys is a bad way to start a household, and honestly, it makes the first conversations tense. Agreeing on the split up front protects everyone, as Uniplaces City Explorer notes in its rental guidance.

Setting Up the Spreadsheet Step by Step

1. Open a blank sheet and call it Roommate Deposit Splitter.
2. Add your row 1 headers: A1 Roommate Name, B1 Monthly Net Income, C1 Split %, D1 Total Deposit, E1 Individual Share, and F1 Notes.
3. Type the total deposit into cell D2, say 2000.
4. Fill column A with roommate names and column B with monthly net earnings, starting in row 2.
5. In cell C2, get the proportional share with =B2 / SUM($B$2:$B$4).
6. Drag that formula down column C. The dollar signs pin the denominator range so it stays fixed, per Jake Lee's bill split guide.
7. In cell E2, calculate the dollar share with =ROUND($D$2 * C2, 2), then drag it down.
8. Build a totals row. Cell C5 takes =SUM(C2:C4) to verify the percentages hit 100%. Cell E5 takes =SUM(E2:E4) to confirm the shares add up to the exact deposit sitting in D2.

A Three-Roommate Calculation Example

Three roommates, a $2,000 deposit, and monthly take-home pay driving the split:

Under a flat three-way split, everyone owes $666.67. That's over 22 percent of Alice's monthly income. For Charlie it's barely 13 percent. The income-weighted model moves $166.67 from Alice to Charlie and leaves Bob's portion off by a single penny, which is about as clean as money math gets. The final numbers balance the landlord's required deposit exactly.

Formatting Cells and Locking Formulas

Spreadsheet typos are quiet. They don't announce themselves. They just corrupt the totals.

Format column C as a percentage before anyone types into it. If you type 25 into an unformatted cell and press the percent button, Google Sheets multiplies by 100 and reads it as 2,500%. Let the formula output the raw decimal, then apply the percentage formatting.

Lock your references with dollar signs. Highlighting a reference and pressing F4 inserts them fast. Skip the lock on $B$2:$B$4 and copying down shifts the range to B3:B5, wrecking your total income denominator.

Rounding matters too. Bob's share works out to $666.666 recurring, and unrounded decimals can drop a rogue cent somewhere in the ledger. Wrapping calculations in =ROUND(..., 2) produces clean financial cents and keeps shared ledgers reliable, as recommended in the expensesorted.com family budget guide.

Handling Permissions and Move-Out Refunds

The math is half the job. Move-out day needs ground rules, because landlords rarely write separate refund checks to individual roommates. Turns out most property managers hand one consolidated check to whoever signed first on the lease, or send a single electronic transfer. Your primary tenant cashes it, then redistributes based on the tracker.

Set the sheet to view-only for general reference and grant edit access only when someone updates verified numbers. Write the refund rules into the notes column before anyone pays their share:

• Full refund payout: if the landlord returns everything, each person receives their exact recorded dollar share.
• Bedroom-specific damage: a stained carpet or damaged closet door comes out of that tenant's share alone.
• Shared living space cleaning: legitimate deductions for common rooms get carved out proportionally, using the original split percentages.
• Payout deadline: whoever holds the landlord check distributes funds within five business days of the deposit clearing.

What Happens When Incomes Change Mid-Lease

Household income doesn't sit still for twelve straight months. People switch jobs, earn promotions, pick up side gigs.

Don't touch the deposit when monthly pay changes mid-lease. Utility or grocery splits can flex as income shifts. Thing is, the deposit is static collateral sitting untouched in escrow, and adjusting shares halfway through means passing cash between roommates for money nobody can withdraw until move-out. Keep the initial percentages locked until the lease terminates. The only time to adjust is a roommate replacement, where the incoming tenant buys out the departing person's recorded equity share.

Move-In Documentation and State Rules

A spreadsheet protects nobody if the physical documentation is missing.

Deposit rules and return deadlines vary a lot by state. Some mandate returns within 14 days, others allow 30 or 60. Check your state's tenant handbook so you know what the landlord can legally deduct before you're arguing about it later.

Three records to keep from day one. First, move-in walkthrough photos: detailed shots and video of baseboards, walls, appliances, and flooring, taken before any furniture goes in. Second, proof of payment: bank transfer receipts, check images, or digital confirmations stored in a shared Google Drive folder alongside the sheet, matching practices from expensesorted.com. Third, a signed agreement memo where everyone confirms the total deposit, individual dollar contributions, and move-out refund percentages.

Then it's just execution. Open Google Sheets, enter your household income numbers, and agree on the split before a single dollar goes to your landlord. Getting the math on paper early kills the awkward money friction before it starts.