If your roommates have bedrooms of different sizes, a Google Sheets rent split calculator can turn an agreed room-size rule into a visible monthly amount. Enter the rent, bedroom square footage, and names; the sheet calculates percentage shares and rent due, while a second tab records payments.

Room size is only one fairness choice. The worksheet below also lets you split an agreed portion of rent equally for common space, with the rest following bedroom size. Use a computer for setup and a phone for quick checks.

Choose the rent-splitting rule first

Start with the rule, not the formula. A pure room-size split uses each private bedroom's square footage as a share of the full rent.

An optional shared-cost percentage treats part of rent as common space and divides that part among listed occupants. Pick one approach and write it in the Notes column or a shared household document.

Method How it works Works better when Main tradeoff
Equal split Divide rent evenly among occupants Bedrooms are similar It ignores room differences
Room-size split Divide rent by private bedroom square footage Bedrooms vary and everyone accepts that basis Common areas are not priced separately
Shared space plus room size Split an agreed common portion equally, then divide the rest by room size The group wants to recognize both common and private space Everyone must agree on the common-space percentage
Income-based split Base contributions on an agreed income measure Affordability matters more than room size It requires sharing income details and is a different method

Do not mix total apartment square footage with bedroom square footage in the same denominator. That can make the result look precise while changing the rule halfway through.

Set up the Rent Calc tab

Create a blank Google Sheet and rename the first tab Rent Calc. Add a second tab called Payment Tracker.

  1. Put Total Monthly Rent in cell A1. Enter the full rent in B1.
  2. Put Shared-Cost Percentage in A2. Enter 0% in B2 for a pure room-size split. If your group agrees to share some rent equally for common space, enter that percentage with the percent sign.
  3. Add these headers in row 4: Room, Sq Ft, Person, Room Share %, Rent Due, and Notes.
  4. Use rows 5 through 12 for up to eight rooms. Enter one room, one square-footage figure, and one occupant per row.
  5. Add Total in A13. The formulas below use row 13 as the total row.
  6. Format B1 and E5:E13 as currency. Format B2 and D5:D13 as percentages.

The core layout looks like this:

Cell or range Entry or formula Purpose
B1 Enter the monthly rent Sets the amount to divide
B2 Enter 0% or an agreed percentage Controls the optional equal common-space portion
D5 =IFERROR(B5/$B$13,0) Calculates the room's share of listed square footage
E5 =IF(C5="","",IFERROR($B$1*((1-$B$2)*D5+$B$2/COUNTA($C$5:$C$12)),0)) Calculates the person's rent due
B13 =SUM(B5:B12) Adds the room measurements
D13 =SUM(D5:D12) Checks that room shares total 100%
E13 =SUM(E5:E12) Checks that rent due totals the monthly rent

Copy the formulas in D5 and E5 down through row 12. The dollar signs keep the total rent, shared percentage, and ranges fixed as you copy.

With B2 set to 0%, the rent due formula is simply the total rent multiplied by the room's percentage. With a shared-cost percentage, the equal portion is divided among the nonblank names in C5:C12.

The sheet is plain on purpose. It does the same few things repeatedly, and that makes errors easier to spot.

If you need more than eight rooms, extend the total row and update every range in the formulas. If two people share one bedroom, do not enter the same square footage twice. Calculate that room's charge once, then divide it between the occupants in a separate allocation.

Make the sheet easier to use on a phone

Keep the headers short. Put notes in one column rather than spreading comments across several cells.

On a desktop, freeze the rows through the header row if that helps you keep the labels visible. On a phone, the Google Sheets app or a mobile browser can handle quick edits, but a wide worksheet may still require horizontal scrolling. Build and test formulas on a larger screen first.

Before sharing the file, try a short mobile check:

  1. Enter temporary names and different room sizes.
  2. Confirm D13 displays 100%.
  3. Confirm E13 matches B1.
  4. Change B1 and one room's square footage. The percentages and dollar amounts should change.
  5. Restore the real figures after the test.

Turns out, this five-minute check catches most copied-reference mistakes.

Add a payment tracker

The calculator shows what each person should owe. It does not show whether money changed hands.

In Payment Tracker, add these headers in row 1:

Column Header What to enter
A Month A month label
B Person Use the same name as in Rent Calc
C Amount Due Pulled from the calculator
D Amount Paid Enter the cumulative amount paid
E Date Paid Enter the latest payment date
F Balance Amount due minus amount paid
G Notes or Receipt Add a short reference

In C2, use this formula and copy it down:

=IF(B2="","",IFERROR(VLOOKUP(B2,'Rent Calc'!$C$5:$E$12,3,FALSE),0))

In F2, use:

=IF(B2="","",C2-D2)

A positive balance means money is still outstanding. A negative balance means the recorded payment is higher than the amount due.

Use one row per person per month. If someone pays in several transfers, enter the cumulative amount in D or create a separate Payment Log tab with one row per transfer. A log is clearer than packing several dates into one Notes cell.

You can add simple totals below the tracker:

  • Total due: =SUM(C2:C50)
  • Total paid: =SUM(D2:D50)
  • Total outstanding: =SUM(F2:F50)

The lookup uses the first matching name. Keep the Person values unique, especially if one person has more than one room or charge.

Set a recurring reminder for the payment date your household agrees to. Keep the rule in writing.

Keep deposits and other reimbursements separate

Rent, deposits, utilities, and household purchases don't always follow the same allocation rule. Giving them separate rows prevents a one-time reimbursement from distorting the rent calculation.

Item Record Suggested treatment
Shared security deposit Who paid, date, and each person's agreed share Track the advance separately from the amount each person owes
Utilities Billing period, total, and allocation rule Use equal, usage-based, or another agreed method
One-person purchase Item, amount, and responsible person Assign that item to the responsible person rather than changing rent
Furniture or repair Buyer, date, group share, and reimbursement status Keep the receipt and reimbursement record together

For a cost that belongs only to one person, a separate split row can assign that person 100% and everyone else 0%. That setting describes the agreed allocation for the item; it does not decide what a lease or local rule requires.

Share the file without exposing more than necessary

Use named access when the sheet contains roommate names, payment history, or notes. Link sharing is better suited to a blank template or information you are comfortable making accessible to anyone with the link.

Google Sheets generally offers these permission choices:

Access Useful for Limitation
Viewer People who only need to read the calculation They cannot enter payments
Commenter Questions and suggestions Comments do not update the tracker
Editor Roommates who enter payments or change inputs Editors can overwrite formulas or share the file

Open the Share controls, add the intended people, and choose the narrowest access that supports the workflow. Give Editor access only to people who need it.

Protect formula cells or columns when the option is available, while leaving input cells editable. Formula columns D and E, plus the total row, are good candidates. Test the file with a non-owner account before relying on it.

Name a version before changing the rent for a new billing period. A label such as Rent Calc - May final makes the record easier to review later.

Avoid historical payment errors

A live lookup is convenient, but it can change old amounts due when you edit the current rent or room assignments. Before starting a new month, use one of these approaches:

  1. Duplicate the calculator tab for the new month and point that month's tracker rows to the duplicate.
  2. Copy finalized Amount Due values in the tracker and paste them as values.
  3. Save a named version, then keep a separate monthly record.

The second option is the simplest for a small household. The first preserves the formulas.

Common mistakes and fixes

Mistake Fix
Entering 25 instead of 25% in B2 Type the percent sign or format the cell as a percentage
Forgetting the dollar signs in formulas Use absolute references such as $B$1 and $B$13
Room shares do not total 100% Check for missing or duplicated square-footage entries
Names differ between tabs Copy the exact Person value into the tracker
A new month's rent changes old balances Freeze old Amount Due values or use a monthly calculator tab
A formula was overwritten Restore it from version history and protect formula cells
The phone view feels crowded Shorten headers, keep notes brief, and use the desktop for setup

To be honest, the spreadsheet cannot decide whether an ensuite, balcony, parking spot, noise, or larger common area deserves a premium. Put those features in Notes, discuss them, and record any agreed adjustment in a visible column or separate rule.

Questions roommates usually have

Does this use the whole apartment's square footage?

No. The basic formula uses the private room measurements listed in column B. If your group wants common areas shared equally, use the optional percentage in B2 rather than adding living-room space to the bedroom total.

What if two people share a bedroom?

Do not duplicate the room's square footage. Calculate the room's total charge once, then split that charge between the occupants in a separate allocation. Write down how you handled the shared room.

What happens when the rent changes?

Update B1 for the new period, but preserve the old amounts first. Otherwise, the Payment Tracker lookup can recalculate historical rows using the new rent.

Can this handle a mid-month move-in?

Yes, but move-in proration is a separate rule. Record the agreed dates and prorated amount manually in the tracker, and check the lease and local requirements before treating the result as final.

Is this spreadsheet legally binding?

No. It is a record of the group's calculation and payment history. Keep the lease, written roommate agreement, receipts, and transfer confirmations; landlord-tenant rules vary by location.

Can I maintain it entirely on a phone?

You can make small edits in the Google Sheets app or browser. Formula setup, range changes, and permission checks are usually easier on a desktop, especially when the sheet has several columns.

Create the two tabs, enter a few dummy rooms, and verify that the total row works before adding real payments. Then write the chosen split rule beside the sheet so every roommate can see what the numbers mean.