How do you fairly split a deposit when one bedroom dwarfs another? Measure the private rooms. Agree on an amenity factor for perks like private baths or balconies. Then multiply each room's area by its factor, divide by the total effective area, and apply that percentage to the cash owed. A shared Google Sheet keeps every calculation visible. It also logs reimbursements when one person cuts the cashier's check to the landlord.
Room size is a practical tool, not a legal mandate. Equal shares make sense when rooms are virtually identical. Proportional splits work far better when square footage diverges. Before transferring cash, agree on three things: who pays the landlord upfront, when IOUs must clear, and how any refund gets returned at move-out.
Choose a split rule before measuring
Pick your formula before pulling out the tape measure. If you debate the fairness rule after seeing the numbers, people tend to lobby for whatever saves them fifty bucks.
| Method | Works well when | Main tradeoff |
|---|---|---|
| Equal per roommate | Rooms and amenities are similar | It ignores differences in private space |
| Room-size proportional | Bedrooms vary noticeably | It requires measurements and agreed factors |
| Usage-based | One person has exclusive parking, storage, or another feature | Usage needs a clear definition |
| Income-based | The group prioritizes ability to pay | Income does not measure room value |
| Nights stayed | Occupancy genuinely varies | Lease responsibility may still be shared |
| Reimbursement after proof | One roommate pays the landlord upfront | It tracks repayment, not the fairness rule itself |
Some groups mix models. They split common living areas evenly down to the penny, then allocate bedrooms strictly by square footage. Whatever you choose, write it down in plain text before touching any spreadsheet formulas.
Measure the space consistently
Grab a tape measure and calculate length times width for each private bedroom. Log the raw square footage immediately. Keep the measurements separate from any debate over perks, light, or closet depth.
Closets and bathrooms can muddy the math quickly. Unless a closet is unusually massive, leave it out of the raw area. A private bath is usually better handled as an adjustment multiplier, which prevents counting the same physical luxury twice.
Shared living space needs a clear team decision. You can exclude it completely, split it equally among everyone, or draft a separate side agreement. Drop that decision directly into the sheet's Notes column.
Build the Google Sheets calculator
Build a fresh sheet from scratch instead of wrestling with someone else's cluttered template. Two tabs are all you need: Rooms and Summary. Keep your raw inputs separated from automated math so nothing gets overwritten accidentally.
On the Summary tab, set up these cells:
| Cell | Label | Entry or formula |
|---|---|---|
| B2 | Total deposit | Enter the deposit, such as 3000 |
| B3 | Total effective area | =SUM(Rooms!E2:E) |
| B4 | Target contributions | =SUM(Rooms!G2:G) |
| B5 | Total paid to landlord | =SUM(Rooms!H2:H) |
| B6 | Balance check | =SUM(Rooms!I2:I) |
Format B2 and your totals as currency. Once the full deposit reaches the landlord, cell B6 should sit at exactly $0.00.
Row 1 of your Rooms tab needs these headers:
| Column | Header | What to enter |
|---|---|---|
| A | Person | Roommate's name |
| B | Room name | Bedroom or other private space |
| C | Square footage | Measured private area |
| D | Adjustment factor | 1.00 for an unadjusted room |
| E | Effective area | =C2*D2 |
| F | Share % | =IFERROR(E2/Summary!$B$3,0) |
| G | Target contribution | =F2*Summary!$B$2 |
| H | Paid to landlord | Amount this person sent directly to the landlord |
| I | Balance before reimbursement | =G2-H2 |
| J | Notes | Measurement rule, factor reason, or approval |
Drag the formulas in columns E, F, G, and I down through every occupied room row. Format column F as a percentage, and set columns G through I to standard currency.
The balances are easy to interpret. A positive balance means that person still owes cash. A negative balance means they overpaid upfront and need reimbursement from the household.
If B4 does not match your total deposit in B2, check your copied formulas. Never mix landlord payments with internal roommate repayments in column H.
See how the room-size formula works
Turns out, a modest adjustment factor can swing the math much more than twenty extra square feet of carpet. Take a $3,000 deposit split across three bedrooms as a real-world test:
| Person | Room | Raw area | Factor | Effective area | Share | Collection amount |
|---|---|---|---|---|---|---|
| Roommate A | Master bedroom | 190 | 1.18 | 224.2 | 44.08% | $1,322.45 |
| Roommate B | Bedroom 2 | 150 | 1.00 | 150.0 | 29.49% | $884.78 |
| Roommate C | Bedroom 3 | 120 | 1.12 | 134.4 | 26.43% | $792.77* |
| Total | 460 | 508.6 | 100.00% | $3,000.00 |
Those numbers illustrate how multipliers shift totals. The 1.18 and 1.12 values might account for a private en-suite bathroom or a private balcony, but they are not fixed industry standards. Under raw unrounded math, Roommate C lands at roughly $792.76. The table bumps that figure by one single penny so the collected sum matches $3,000.00 on the nose.
Leave full-precision decimal calculations inside the sheet cells. Settle any lingering odd cent in your reimbursement ledger rather than messing with the underlying square footage.
Agree on amenity adjustments
An adjustment factor works as a straightforward multiplier. A factor of 1.00 preserves the exact measured space. A factor of 1.18 scales a 190-square-foot room up to 224.2 effective square feet.
Stick to consistent ground rules for every private perk:
| Feature or situation | Practical worksheet choice |
|---|---|
| Standard room | Use 1.00 |
| Private bathroom | Use an agreed factor, or include the area, but do not quietly do both |
| Balcony or private entrance | Use an agreed factor if the group considers it valuable |
| Feature already counted in the area | Do not add a second adjustment without agreement |
| Disputed feature | Leave the factor at 1.00 until everyone decides |
The precise multiplier matters much less than the group agreeing on it beforehand. Add an explicit note like 1.18 agreed for private bathroom directly beside the entry. Get everyone to sign off on that note before sending any transfers.
Track upfront payments and IOUs separately
Target obligations and actual cash routing are two entirely different animals. Mixing them together creates headaches.
Suppose Roommate A pays the entire $3,000 deposit via wire to the landlord. Enter $3,000 in Roommate A's row under Paid to landlord, and put zero for everyone else. The target contributions in column G stay locked to agreed room percentages. Roommate A will show a large negative balance, while the other roommates show positive balances matching their debt.
To track repayments cleanly, add a third tab named Reimbursements. Give it columns for Date, From, To, Amount, Payment method, and Status. When roommates reimburse the primary payer, log the payment there. Do not alter the original Paid to landlord column.
If your group tracks split styles, tag the initial payment as Landlord payer and follow-ups as Reimbursement. This keeps the agreed room shares intact and prevents confusion.
Share the sheet without losing the record
Give everyone Editor permissions while measuring rooms and discussing amenity factors. Once the group settles on the final figures, lock your formula ranges and keep only payment fields open for edits. A helpful Google Sheets sharing guide details how to set up protected ranges and edit access.
Use in-cell notes or threaded comments to record every mutual agreement. Log who approved each measurement, which factors were assigned, who pays the landlord, and the target repayment date.
Google Sheets tracks every single change automatically. Head to File > Version history to tag or restore an agreed snapshot; this version history overview walks through the exact clicks. Download a backup PDF or spreadsheet copy once finalized, and file it right alongside your lease agreement.
Review these details before anyone pays
Thing is, people love to tweak multipliers right when payment requests start arriving. Pick the numbers, document the logic, and leave the sheet alone.
Run down this quick checklist first:
- Every room was measured with the exact same method.
- Shared spaces are either excluded or covered by a written rule.
- Each amenity factor has an accepted reason attached.
- Column G target contributions total the full deposit amount.
- The upfront payer and the payback deadlines are defined.
- Cell B6 reads $0.00 once the landlord payment is entered.
- Any one-cent rounding difference is assigned and recorded.
Know what the spreadsheet cannot decide
A spreadsheet manages the social contract between roommates, nothing more. It does not override your lease, dictate state deposit caps, or govern deductions. Landlord rules depend on state statutes and your specific rental contract.
Take California tenancy law as a clear example. Under the California Courts' security deposit guide, landlords generally have 21 days after move-out to return the deposit with an itemized deduction statement. That 21-day timeline does not apply nationwide.
When you move out, run your original internal percentages against the actual refunded check. Keep landlord deductions separate from routine room splits. Decide ahead of time whether damage deductions attach to the responsible roommate or get absorbed by the household. This represents practical roommate guidance, not formal legal advice.
Common questions
Is a square-footage split required?
No. Equal splits work great if rooms are comparable. Square footage only helps when room layouts are noticeably mismatched and people want fair compensation.
What if a couple shares one bedroom?
Decide whether you split costs by bedroom or by individual occupant. You can dedicate one row to the master bedroom and let the couple handle their split privately, or list them on separate rows with split percentages.
What if one roommate pays the whole deposit?
Keep their target share unchanged in column G and put the total amount in column H. The balance column will immediately display how much cash the other roommates owe them.
How should a returned deposit be divided?
Apply your original percentage shares to the final check returned by the landlord. Account for itemized damage fees first, deduct costs from whoever caused the damage, and then distribute the remaining funds.
Measure the rooms together, record agreed factors in the sheet, and confirm the Summary tab balances out before anyone transfers a dime.