Use a Google Sheets template with columns for roommate names, room sizes in square feet, total rent, and formulas to calculate each person's proportional share. For example, individual share equals total rent times (room size divided by total room sizes). This approach helps U.S. roommates in shared housing with unequal rooms determine fair contributions quickly, following the June Homes workflow.
Set up the sheet in minutes: enter total monthly rent once, input each room's size, and watch shares auto-calculate. Share the sheet for real-time updates among household members. Review monthly to adjust for rent changes or moves. This simple tracker supports small groups tracking rent splits and basic reimbursements without apps.
Why Split Rent by Room Size?
Splitting rent proportional to room size accounts for space differences in shared housing. Measure each bedroom in square feet, then allocate rent based on those proportions. Larger rooms get higher shares; smaller ones pay less, as described in the June Homes blog.
This method suits roommates where one has a master suite and others share smaller spaces. June Homes and Azibo list it alongside equal splits or income-based options. Consider tradeoffs: room size ignores usage or income disparities, so it works best when space is the main fairness factor. Discuss as a group to confirm it fits your household.
Template Columns and Formulas
Build a basic template with these recommended columns for clarity and automation. Start in a new Google Sheet.
| Column A | Column B | Column C | Column D | Column E | Column F |
|---|---|---|---|---|---|
| Roommate Name | Room Size (sq ft) | Proportional % | Your Share | Date Paid | Notes/Reimbursements |
- A1: Roommate Name - List names starting in A2 (e.g., Alex, Jordan).
- B1: Room Size (sq ft) - Enter measurements in B2 downward. Use consistent units like square feet.
- C1: Proportional % - In C2:
=B2 / $B$11(assumes total size in B11; format as percentage). - D1: Your Share - In D2:
=D$1 * C2(total rent in D1; copies down for each row). - B11: Total Room Sizes - Formula:
=SUM(B2:B10)(adjust range for your group size). - D1: Total Rent - Enter monthly total (e.g., $2400).
- E1: Date Paid - Track payments manually.
- F1: Notes/Reimbursements - Log adjustments.
Copy formulas down for each roommate. Input total rent and sizes; shares update automatically. Add a reimbursement row by noting "Reimbursement" in F and adjusting shares manually if needed.
Google Sheets Setup Steps
- Go to sheets.google.com and click "Blank" for a new spreadsheet.
- Enter headers in row 1 as listed above.
- In D1, input your total monthly rent.
- In B11, add
=SUM(B2:B10)for total room sizes (expand range if more rows). - In C2, enter
=B2 / $B$11; drag to fill C3:C10. - In D2, enter
=D$1 * C2; drag to fill D3:D10. - Measure rooms with a tape measure or floor plan app; enter in column B.
- Format D column as currency (Format > Number > Currency).
Test by changing D1; all shares recalculate. Review monthly before rent due. Common mistakes include circular references (e.g., total size formula referencing itself), unprotected formula cells (someone overwrites), or mixing units (sq ft vs square meters). Lock formula columns: select range, Format > Protect sheet.
Sharing and Collaboration for Roommates
Share for group input without version chaos. Click the green "Share" button in the upper-right corner.
- Add roommate emails; set to "Editor" for live updates.
- For a reusable template, generate a shareable link set to "Viewer" - others can copy and use it.
- Small households collaborate smoothly this way.
Common mistake: granting Editor access without discussing changes first, leading to accidental overwrites. Start with Viewer, then upgrade. Use comments (right-click cell > Comment) for questions without altering data.
Tracking and Recordkeeping Basics
Extend the template for ongoing use. Add a "Date Paid" column to mark payments (e.g., "2026-01-05"). Sum paid amounts in a footer: =SUM(E2:E10).
Log changes: if rent rises or someone moves, update D1 or row data and note in F. Export records monthly: File > Download > PDF for landlord proof or disputes.
For small groups, this spreadsheet handles tracking and basic records well. Mark reimbursements separately, like one person fronting a deposit. Pair with receipt photos in a shared folder. When group grows or payments complicate, consider payment apps for transfers, but keep records here.
FAQ
How do I measure room sizes accurately?
Use a tape measure for length and width, multiply for square footage. Include closets if used regularly; exclude shared bathrooms or hallways. Apps like MagicPlan help scan rooms.
What if someone moves out - how to update the template?
Delete or gray out their row, re-measure if needed, update sizes, and recalculate. Adjust total rent if it changes; discuss new split immediately.
Can we combine room size with equal split for common areas?
Yes - calculate bedroom shares for most rent, then add equal shares for living room/kitchen portion. Example: 70% by room size, 30% equal. Test in extra columns.
What formulas handle rounding errors in shares?
Use =ROUND(D2, 0) in shares for whole dollars; adjust final row manually to balance total. Or =D$1 * B2 / $B$11 and accept cents for precision.
How often should we review the rent split?
Monthly, before rent due, or after changes like lease renewal or moves. Set a shared calendar reminder.
Is this legally binding for roommates?
No - it's a tracking tool. For enforceability, write a roommate agreement signed by all, noting the split method. Check state landlord-tenant rules for your area.
Next, create your sheet and test with current numbers. Discuss the split in a house meeting, measure rooms together, and agree on update rules.