How to Split Rent by Room Size in Google Sheets

How do you split a $2,400 apartment when one bedroom is double the size of another? Splitting rent strictly down the middle causes quiet resentment fast. A proportional calculation based on bedroom square footage solves this cleanly. Each person pays for their private square feet while sharing common areas. You do not need paid rent-splitting software to do the math. A simple Google Sheet updates totals instantly whenever rent changes or someone swaps rooms.

Thing is, square footage alone does not solve every roommate dispute, but it gives everyone a mathematical starting point that feels fair.

Pure Square Footage vs. The Common Area Hybrid

Before typing formulas, decide which math your household actually agrees on. There are two standard ways to run the numbers.

In a pure room-size split, the entire monthly rent is divided by bedroom square footage. If you have a 200-square-foot room out of 500 total bedroom square feet, you pay exactly 40% of the rent. That works well in tight city apartments where bedrooms take up nearly the entire floor plan.

Turns out, pure square footage can punish the person in the bigger room if your apartment has a giant shared living room and balcony. Why should someone pay 60% of the total rent when 400 square feet of the apartment is shared equally by everyone?

That is why many households prefer a hybrid split. You divide half the rent equally for common space. Then, you divide the remaining half based on bedroom sizes.

Spreadsheet Layout and Cells

Keep your overall lease inputs separate from the individual bedroom rows. Putting the total rent in a dedicated cell at the top prevents broken formulas whenever the landlord adjusts the lease rate.

Set up your sheet with this layout:

Step-by-Step Setup

1. Open Google Sheets and click Blank to create a new spreadsheet.
2. In cell A1, type "Total Monthly Rent". In cell B1, enter your total rent amount (for example, 2400) and format B1 as currency.
3. Add the column headers across row 3 from A3 to F3 as shown in the table above.
4. Measure each bedroom with a tape measure or floor plan app. Enter roommate names into A4 through A6 and room sizes into B4 through B6.
5. In cell B7, type =SUM(B4:B6) to total the private square footage.
6. In cell C4, enter =B4/$B$7 and format the cell as a percentage.
7. In cell D4, enter =$B$1*C4 and format the cell as currency.
8. Highlight cells C4 and D4, then drag the blue fill handle down through row 6.
9. In cell D7, enter =SUM(D4:D6) to verify that all individual shares sum back up to the exact lease rent in B1.

If your household prefers the 50/50 hybrid method, change the formula in cell D4 to =($B$1 * 0.5 / COUNTA($A$4:$A$6)) + ($B$1 * 0.5 * C4). Then drag that formula down through D6. That formula splits half the rent equally among all listed roommates and splits the remaining half by square footage. The math balances either way.

Lock Formula Cells Before Sharing

Few things wreck a shared spreadsheet faster than an accidental backspace. Someone opens the sheet on a phone, taps cell D4 to check what they owe, and accidentally overwrites the formula with plain text.

To prevent this, use Google Sheets range protection before sending invite links:

• Select your formula columns (C4:D7) and your total rent cell (B1).
• Click Data in the top menu, then select Protect sheets and ranges.
• Click Add a sheet or range in the right panel.
• Set permissions to "Only you" so roommates can view the calculations without overwriting formulas.

Give roommates Editor access only if they need to check off payment dates in column E. Otherwise, give them Viewer access. Under standard Google Drive sharing permissions, viewers can inspect numbers and make a private copy without editing your master sheet.

Accounting for Bathrooms, Parking, and Closets

To be honest, square footage rarely tells the entire story. A 130-square-foot room with an attached private bath is worth more than a 140-square-foot room that shares a single hallway bath with two people.

Most households handle amenities with simple adjustments:

• Private ensuite bathroom: Add a 10% to 20% premium to that room's share, deducted proportionally from the rooms that share a bath.
• Assigned parking space: Subtract the value of the parking spot from the total rent first, bill it directly to the driver, then run the room-size formula on the remaining balance.
• Balconies and large walk-in closets: Add dedicated private outdoor space or storage directly into that bedroom's square footage measurement.
• Couples sharing a room: Add a 10% to 25% premium on top of the room's share because an additional occupant increases utility usage and common space wear.

Why Your Sheet Needs a Written Agreement

A spreadsheet is a calculation tool, not a legal shield. When you sign a standard residential lease, tenants are almost always jointly and severally liable. That means your landlord does not care who pays what percentage. If a roommate shorts their share, the landlord can legally demand the missing money from anyone on the lease.

As noted by Virginia Tech Student Legal Services, a standard lease defines the relationship between the tenants and the landlord, but does not define the financial relationship between the roommates themselves.

Draft a one-page roommate agreement that documents the agreed numbers. List each person's exact monthly dollar amount, the agreed due date, and who submits the final lump-sum payment to the property management portal. Have everyone sign it before moving in.

Grab a tape measure this weekend. Measure length and width together, plug the numbers into your sheet, and let everyone review the exact breakdown before signing a lease.