Split a Family Security Deposit in Google Sheets

When a family rents a home together, the landlord usually wants one single deposit check. So who fronts the $2,000? Nine times out of ten it's a parent, or whichever sibling has the credit limit to absorb it. That's an awkward debt sitting there on move-in day, before anyone has unpacked a single box.

Tracking it on scratch paper backfires every time. Months later, nobody remembers who sent what on Venmo. A lightweight Google Sheet fixes this fast. It logs who paid the landlord, splits the move-in cost across everyone, and calculates exact refund payouts when the lease ends.

Pick the Right Split Structure

Thing is, equal splits don't always make sense for family households. Picture a parent renting a three-bedroom flat with two adult college students. Charging everyone an identical 33% might strain the kids, and everyone at the dinner table knows it.

Families usually settle on one of three frameworks:

• Equal split: the deposit gets divided straight down the middle or into equal thirds. It works best when everyone works full-time and occupies similar rooms.
• Income-weighted split: contributions follow take-home pay. A person earning 60% of the household income covers 60% of the security deposit.
• Space-based split: the deposit gets allocated by bedroom square footage or private amenities like an attached bathroom.

Write your choice down before the spreadsheet even opens. Putting the agreed logic in row one avoids sour feelings at move-out.

Recommended Sheet Columns

Build it on a single tab first. One apartment doesn't need multiple tabs or complex scripts.

Set these headers across row 1:

Freeze row 1 so the titles stay put when you scroll: click View, select Freeze, then pick 1 row. Format column C as currency from the toolbar while you're in there.

Enter the Math

Your sheet needs to answer two questions. Who paid what upfront, and who owes whom.

Start with the summary box. Place it below your main table and use SUMIF to total what Marcus physically paid across the entire sheet:

=SUMIF(D2:D20, "Marcus", C2:C20)

The formula checks the Paid By column for Marcus and adds every matching figure from the Total Amount column. Repeat it for Elena and David, changing only the name in quotes.

Marcus's assigned share per line item is a simple multiply. In row 2:

=C2 * E2

Then subtract each person's total owed share from what they actually paid. Say Marcus fronted the full $2,400 deposit but only owes 50% of it ($1,200). His balance calculation shows:

$2,400 - $1,200 = +$1,200

Positive means the group owes him that $1,200. Elena and David will sit at negative balances until their shares land in his bank account.

Splitting the Landlord Refund

Move-out day is where informal agreements collapse. Landlords rarely return the full amount without checking for damage first.

Turns out, refunds are simple to handle if you enter the return as a credit. When the landlord sends back $1,800 after withholding $600 for wall patches, add a new row. Put the return date in column A, "Deposit Refund" in column B, and -1800.00 in column C.

Someone has to absorb that $600 loss. If the landlord itemized deductions because a specific person ruined a bedroom door, that person should cover it. Reviewing roommate move-out checklists during your walk-through helps pinpoint whether deductions stem from communal wear or private room neglect.

Sometimes the withholding is unfair. Check local rules before splitting that loss. In some jurisdictions, such as under New York Attorney General guidance on security deposits, landlords must return deposits within 14 days with an itemized receipt or forfeit their right to keep anything. Knowing the statute stops you from penalizing family members for charges the landlord had no legal basis to make.

Deductions that are genuinely shared, like a general professional cleaning requirement, keep your standard percentage splits on the refund row. The summary formulas will calculate each person's net return automatically.

Sheet Access and Practical Pitfalls

Keep permissions tight. Share the sheet by entering family emails under the blue Share button, but think twice before handing everyone editor rights.

Shared edit access breaks formulas. Someone deletes an equal sign, or types a raw number over a cell holding a SUMIF. A cleaner approach gives family members "Commenter" or "Viewer" access while the primary payer stays the sole editor. If someone sends money via Zelle or cash, they can leave a comment on their row and the sheet owner marks it settled.

Plenty of shared sheets fall apart because grocery runs and electric bills start wandering into the deposit calculator, and once you mix long-term deposits with weekly expenses the balances turn into a confusing headache you'll never fully untangle. Keep this sheet dedicated strictly to the deposit, pet deposits, and final move-out repair fees.

Then there's the percentage trap. If Elena changes her share from 30% to 25% without adjusting someone else's number, your deposit pool will leak money. Add a quick check formula in an empty cell:

=SUM(E2:G2)

Anything other than 1.0 (or 100%) means you fix the row before collecting money.

What to Do Next

Open a new sheet in Google Drive today and drop in the column headers before signing your lease. Have everyone agree on their percentage split in the family group chat, put those numbers into row 2, and log the initial transfer the moment your landlord receives the funds.