Use a Google Sheet when roommates need a transparent rent calculation and a record of the agreed inputs. Put monthly rent in B2, list each person once, select one method for that rent period, and let the sheet calculate percentages and dollar shares.

Equal, income-based, and room-size splits fit the same layout. Keep the method consistent. If you're comparing options, duplicate the tab instead of mixing rows.

Choose one rent split method

Equal. Divide rent evenly among occupied roommate rows. It's easy to review, but it doesn't account for a larger bedroom or a different ability to pay.

Income-Based. Enter the same type of income for everyone, such as monthly gross income or monthly take-home income. The sheet applies each person's share of the group total to rent. Agree on the income basis first.

Room-Size. Enter each private room's square footage. A larger private area produces a larger share. For shared space, either leave it outside this calculation and split shared costs separately, or allocate an agreed portion to each person's value in column D.

An en-suite bathroom or balcony may justify an adjustment, but write the rule in Notes. Make the judgment visible.

One rent pool should use one method. The dropdown records that choice; it shouldn't turn one month's rent into several different calculations.

Set up the Google Sheets rent split template

Create a new Google Sheet and add these headers in row 1:

Column Header What to enter
A Date The rent period or first day of the month
B Total Rent Enter the full monthly rent in B2 only
C Roommate Name One roommate per occupied row
D Room Sq Ft or Income Room size for Room-Size, or the agreed income basis for Income-Based
E Split Method Equal, Income-Based, or Room-Size
F Share % Formula-calculated percentage
G Individual Share Formula-calculated dollar amount
H Notes Method details, measurements, exceptions, or changes

Use B2 as the only rent input. Leave B3:B10 empty, while each occupied row still points to B2.

On an income-based month, don't mix gross income and take-home income. On a room-size month, don't mix private square feet with an unexplained adjustment.

Add the dropdown and format the sheet

  1. Create the headers above and reserve rows 2 through 10 for roommates.
  2. Enter the monthly rent in B2. Add names in C2:C10 and the relevant input in D2:D10.
  3. Select E2:E10. Open Data > Data validation, choose Dropdown or List of items, and add Equal, Income-Based, and Room-Size.
  4. Choose the method in E2, then use the same option in E3:E10 for occupied rows. Leave unused rows blank.
  5. Format B and G as currency, F as a percentage, D as a plain number, and A as a date.

For a room-size split, D contains square feet. For an income-based split, D contains the agreed income measure. Equal splits can leave D blank.

Add formulas for the share and dollar amount

The formulas below use E2 as the method control. That absolute reference is intentional.

Paste this into F2:

=IF(C2="","",IF($E$2="Equal",1/COUNTA($C$2:$C$10),IF(OR($E$2="Income-Based",$E$2="Room-Size"),IF(D2="","",IFERROR(D2/SUM($D$2:$D$10),0)),"")))

This formula counts non-empty names for an equal split. For income-based and room-size methods, it divides the row's D value by the total of column D. A missing D value stays blank, making incomplete inputs easier to spot.

Paste this into G2:

=IF(OR(C2="",F2=""),"",F2*$B$2)

The formula multiplies the share percentage by total rent. Drag F2 and G2 through row 10.

In C11, type Total. Then add these checks:

=SUM(F2:F10)

in F11, and:

=SUM(G2:G10)

in G11.

F11 should show 100%. G11 should match B2. Stop there if either check fails. Look for a missing name, a missing D value, or a method that wasn't copied consistently.

Need more than nine roommate rows? Extend every range in the formulas and total row. Keep the ending row consistent.

See how the calculations work

Suppose monthly rent is $3,000 and three private rooms measure 180, 150, and 120 square feet. The total private area is 450 square feet.

Roommate D input Split method Share Individual share
Priya 180 Room-Size 40.00% $1,200.00
Ankit 150 Room-Size 33.33% $1,000.00
Meera 120 Room-Size 26.67% $800.00
Total 450 100.00% $3,000.00

The displayed percentages are rounded for readability. The dollar total is the useful check.

For an income-based example, two incomes of $4,500 and $9,000 produce a group total of $13,500. The shares are 33.33% and 66.67%, so $3,000 of rent becomes $1,000 and $2,000. Turns out, Equal needs no D value; the names in column C are enough.

If currency rounding leaves a small difference, record the agreed adjustment in Notes instead of changing the formula.

Keep deposits and one-time charges separate

Rent is not every shared charge.

Create a second tab called One-Off Charges with columns for Date, Charge, Amount, Paid By, Person Owing, Status, and Notes. Use it for deposits, move-in purchases, agreed fees, utility balances, or reimbursements.

A one-person charge shouldn't turn the recurring rent row into a 100% split. Record who paid, who owes, and the receipt or explanation instead. Keep the rent formulas focused on recurring rent.

Share the sheet without losing control

A shared calculator needs a clear editing boundary. Protect the math, not the inputs.

  • Leave roommate names, D values, the method column, and Notes editable.
  • Use Data > Protect sheets and ranges for B2 and the formula cells in F2:G11.
  • Give Editor access to people who need to change inputs. Use Viewer or Commenter access for others.
  • Use Comments for questions and name a version after the group confirms a rent period.
  • Remove old roommates' access after move-out and keep a copy of important periods.

Thing is, protection prevents accidental edits; it doesn't settle a rent disagreement or replace access controls for sensitive income information.

Use a simple monthly review

Review point Action
Before editing Confirm the total rent, current occupants, and selected method
Input check Update names, D values, dates, and Notes
Formula check Confirm F11 is 100% and G11 matches B2
Group review Let roommates review the result before payment requests
Recordkeeping Duplicate the tab, name a version, or download a copy for the period

For a new month, duplicate the prior tab before changing the numbers. People forget the Notes. They do. A dated copy keeps the old method and inputs visible.

After everyone reviews the calculation, send amounts through whatever payment method the group already uses. The sheet tracks the calculation; it doesn't move money or confirm a transfer.

Know when a spreadsheet is enough

This template fits a household that mainly needs calculations, notes, and a shared record. It's useful when roommates want control over the formulas and don't need another tool for every expense.

A separate app or process may help when the group also needs receipt capture, payment requests, multiple bill categories, or automated reminders. Compare tools by tracking, requesting, paying, exporting, and recordkeeping. Those are different jobs.

To be honest, a spreadsheet plus a folder for receipts may be enough for a small household.

Know what the sheet cannot decide

The formulas show an agreed allocation. They don't decide whether the allocation is fair, change lease obligations, or enforce payment.

For U.S. roommates, check the lease and applicable local rules before changing rent responsibilities or adding charges. This sheet is a record, not a lease amendment or legal agreement.

Start with the names, put rent in B2, select one method, and have everyone review F11 and G11 before the first payment request.