Room Size Rent Split Calculator: Mobile-Friendly Google Sheets Template

✨ Community Finance

Published: May 3, 2026

Use this free Google Sheets template guide to calculate rent splits by room size. Enter room square footage, auto-compute percentage shares, multiply by total rent for individual amounts, track payments, and share mobile-friendly links with roommates.

This setup works for U.S. roommates in shared housing with unequal rooms. It creates fair, trackable splits without apps. Google Sheets is responsive on phones via the Sheets app, supporting real-time edits for small groups. Steps draw from editorial workflows at ExpenseSorted and Tiller.

Why Split Rent by Room Size

Splitting rent by room size accounts for unequal space in shared housing. A June Homes blog post notes this method bases contributions on room square footage if rooms differ in size.

This contrasts with even splits, where all roommates pay the same amount, or income-based splits, which adjust shares by earnings, as noted in the same June Homes post. Room-size splits promote fairness for larger spaces but require group agreement upfront. Tradeoffs include simplicity for even splits versus perceived equity in room-size or income methods. Discuss as a group to align on one approach, as no method fits every situation.

Google Sheets Template Setup Steps

Start with a new Google Sheet for mobile-friendly rent splitting. Steps draw from ExpenseSorted and Tiller workflows.

Go to sheets.google.com and click Blank to create a new sheet. Name it "Room Rent Split Calculator."
Add two tabs: Rename Sheet1 to "Rent Calc" for calculations. Add a second tab named "Payment Tracker" via the + icon at the bottom.
In Rent Calc, set up the structure in row 1 for headers. Format columns wide enough for mobile viewing: select columns A-F, right-click, and choose Resize columns to fit content.
Enter total rent in a fixed cell, like B1 labeled "Total Monthly Rent." Use currency formatting: select the cell, Format > Number > Currency.
Calculate total square footage with a SUM formula at the bottom.
For mobile access, install the Google Sheets app on iOS or Android. Sheets auto-adjusts for phone screens, showing full rows without horizontal scrolling when zoomed.

Test on your phone: share a view-only link first to confirm readability.

Recommended Columns and Formulas

Build the Rent Calc tab with these editorial-derived columns, based on ExpenseSorted workflows. Formulas are approximate and adjustable.

Column	Header Example	Sample Formula (Row 2 Example)	Notes
A	Room	(Enter text like "Bedroom 1")	Descriptive name.
B	Sq Ft	(Enter number like 120)	Measure rooms accurately.
C	Person	(Enter name like "Alex")	Assign occupants.
D	% Share	=B2/$B$10	Assumes total sq ft in B10; use absolute reference $ for copying.
E	Monthly Rent Share	=$B$1*D2	Multiplies total rent (B1) by % share.
F	Notes	(Enter text)	For features like parking spot.

In B10 (or last row +1), label "Total Sq Ft" and use =SUM(B2:B9) for up to 8 rooms.
% Share auto-updates when sq ft changes.
Format D and E as Percentage and Currency.

In Payment Tracker tab:

Column	Header Example	Sample Formula	Notes
A	Month	(e.g., Jan 2026)	List months.
B	Person	(Copy from Rent Calc)	Dropdown via Data > Data validation.
C	Amount Due	=VLOOKUP(B2,'Rent Calc'!C:E,3,FALSE)	Pulls rent share.
D	Paid	(Y/N dropdown)	Mark yes/no.
E	Balance	=C2-IF(D2="Y",C2,0)	Simple reimbursement check.
F	Total Balance	=SUMIF(B:B,"Alex",E:E)	Per person at bottom.

Common mistake: Forgetting absolute references ($B$1) causes errors when copying formulas. Test by changing total rent - shares should recalculate.

For reimbursements like deposits, mark one person 100% and others 0% in a split column, per ExpenseSorted guidance.

Sharing and Collaboration for Roommates

Share securely for roommate access. Tiller's 2020 guide notes up to 100 people can have view, edit, or comment permissions simultaneously.

Steps:

Click Share (top right).
Add emails or generate a link.
Set Viewer (read-only), Commenter, or Editor.
For templates, choose "Anyone with the link" as Viewer; recipients see a "Use template" button to copy.

Real-time collaboration lets editors see live changes, as noted in ExpenseSorted editorial. On mobile, shared links open in the Sheets app for edits.

Limit editors to roommates only - over-sharing risks accidental deletes. Use Comments for discussions without altering data.

Tracking Payments and Common Mistakes

Use the Payment Tracker monthly: log due amounts, mark Paid as Y/N, review balances. Set a calendar reminder for the 1st of each month.

Workflow:

One roommate enters payments after bank transfers or cash.
Sum balances per person: =SUMIF for quick owes/owed.
Export to PDF via File > Download for records.

Common mistakes:

Over-sharing permissions: Stick to "Editor" for trusted roommates only.
Untracked reimbursements: Always note dates and proof in Notes.
Mobile formula errors: Edit on desktop first, verify on phone.
No version history: Google auto-saves, but check File > Version history monthly.

Sheets suffice for small groups (2-5 roommates) with simple rent. For larger groups or non-rent expenses like utilities, consider apps for reminders, but a spreadsheet with rules often works.