Rent Split Calculator: Simple Google Sheets Template Guide

✨ Community Finance

Published: May 6, 2026

Use a free Google Sheets template to calculate rent splits among roommates. Start with columns for tenant names, monthly incomes, total rent, share percentages, and individual amounts. For an even split, divide total rent by the number of tenants, as noted in Azibo's rent splitting guide. For income-based splits, adjust shares proportionally to earnings, also from Azibo.

This setup lets U.S. roommates track fair contributions in real time without apps. Add formulas for automatic calculations, share via links with granular permissions, and review monthly. It works for stable groups handling rent, deposits, or utilities.

Choose Your Rent Split Method

Roommates often split rent evenly or based on income. An even split divides the total rent by the number of tenants. For example, $3,000 rent for four roommates means $750 each.

Income-based splits aim for fairness when earnings differ. Each person's share reflects their proportion of group income, per Azibo's approach. If total income is $10,000 and one roommate earns $4,000, their share is 40% of rent.

Tradeoffs matter. Even splits are simple but ignore income gaps. Income-based feels fairer yet requires sharing salary details and regular updates. Use this decision tree:

Stable equal incomes? Even split.
Varied incomes or extra rooms? Income-based.
One covers upfront, others reimburse? Mark as 100% for payer, 0% others, as in ExpenseSorted's roommate template.

Discuss rules upfront, like updating incomes yearly or handling mid-month changes.

Set Up the Google Sheets Rent Split Template

Create a new Google Sheet named "Roommate Rent Split 2026".

Add these recommended columns starting in row 1:

Column	Header	Purpose
A	Tenant Name	List each roommate.
B	Monthly Income	Enter pre-tax earnings for proportional splits.
C	Total Rent	Same value for all rows (e.g., $3,000).
D	Share %	Formula calculates proportion.
E	Individual Amount	Formula for owed rent.
F	Paid?	Yes/No dropdown for tracking.
G	Notes	Deposits, late fees, or adjustments.

In row 2, enter names and incomes. Copy row 2 down for all tenants. Put total rent in C2 and reference it across rows.

Add a summary section below the table (e.g., row 20):

Total Rent: =C2
Total Income: =SUM(B2:B10)
Unpaid Balances: Use formula below.

This tracks core rent data. Expand for utilities by duplicating columns.

Add Formulas for Automatic Calculations

Formulas make the template dynamic. Adjust cell references to match your sheet.

For even split in E2: =C$2 / COUNTA(A2:A10). This divides total rent by tenant count (assuming 9 rows). Copy down.

For income-based in D2: =B2 / SUM($B$2:$B$10). This gives share percentage. In E2: =D2 * C$2. Copy both down. From Azibo's proportional method.

Track unpaid totals in a summary cell (e.g., E20): =SUMIFS(E2:E10, F2:F10, "No"). This sums individual amounts where Paid? is "No", adapted from RelayFi's SUMIFS example.

For tenant summaries (e.g., in G22): =QUERY(A2:F10, "SELECT A, SUM(E) WHERE F <> 'Yes' GROUP BY A LABEL SUM(E) 'Unpaid'"). Groups unpaid by name.

Filter large balances (e.g., H2): =FILTER(A2:F10, E2:E10 > 500). Shows rows over $500, from RelayFi.

Common mistakes: Mismatched ranges (use $ for fixed cells), blank incomes causing errors (=IFERROR(formula,0)), or not copying formulas down. Test with sample data.

Share and Collaborate on the Template

Share via Google Sheets' link options for real-time edits. Everyone with edit access sees changes live, per ExpenseSorted.

Set granular permissions from Google Workspace: Choose Viewer (read-only), Commenter, or Editor. Restrict downloading or further sharing for control, as detailed on Google Workspace Sheets page.

Steps:

Click Share > Add emails or copy link.
Set role (Editor for updates).
Notify via email.

Log offline and sync later, also from ExpenseSorted. Review monthly: One person updates rent/incomes, group confirms payments.

Common Mistakes and When to Use an App Instead

Avoid these pitfalls:

Forgetting income updates, skewing shares.
Over-sharing permissions, allowing unwanted edits.
Formula breaks from deleted rows; protect ranges via Data > Protect sheets.
No backups; download monthly as PDF/Excel.

Spreadsheets suffice for small, stable groups (2-6 people) with trusted access and simple needs like rent plus utilities. They cost nothing and customize easily.

Consider apps for larger groups, receipt scanning, or automated payments. Examples include tools for split bills, but check their features separately. Stick to sheets if your group prefers free, no-account workflows.