One roommate wants to pay less rent. Fair enough, sometimes. A smaller room, lighter use of the shared space, or a tighter budget can each point somewhere different, and the reason you settle on changes the number you land on.

So agree on the why before anyone opens a tracker. Then write the deal down and keep two records apart: the rent split, which says who is responsible for what, and the reimbursement log, which says who fronted the money and whether the transfer actually happened. That one separation prevents a lot of confusion.

Choose the reason for the lower share

There's no single formula for cheaper rent. Pick the method that matches what's actually changing.

Situation Starting method Put in writing
Different bedroom sizes Split private space by room size and shared space equally Each person's rent percentage or dollar amount
Different room features Agree on adjustments for features such as a private bathroom, balcony, noise, or limited windows The adjustment and the final share
Lower income Use a voluntary income-based ratio or an explicit subsidy Whether the ratio applies to rent, utilities, or both
Part-time occupancy Consider nights stayed for variable bills Which expenses change and when
Similar rooms and usage Use an equal per-person split The same share for fixed expenses

For room size, one practical approach is to divide the common-space portion equally, then divide the private-space portion by measured room area. Features complicate things. A private bathroom or a noisy spot changes the conversation, but there's no universal price list anywhere, so the adjustment is whatever you agree on and write down.

Income-based sharing needs consent. A ratio like 50/30/20 is an agreement between people, not a rule that the higher earner must cover more. The tracker works best when it records a decision the roommates already accept.

Write the agreement before the first bill

You don't need anything fancy to start. A shared document works. So does an email, or a note at the top of the spreadsheet.

Put these in writing:

  • Total monthly rent and each person's rent share
  • How utilities, groceries, internet, and other variable costs are divided
  • Who pays the landlord or vendor first
  • How soon reimbursements should be sent and how they'll be marked paid
  • What happens after a room swap, move-out, missed payment, deposit refund, or new roommate
  • When the arrangement will be reviewed

To be honest, a clear two-line explanation beats a complicated formula nobody understands. Here's the shape of one: "Monthly rent is $2,400. Alex pays 40% or $960 for the larger room, while Jordan and Taylor each pay 30% or $720. Utilities use a separate agreed split."

If the group only needs the final ratio, keep salary figures out of the shared sheet. Record the percentage or dollar amount instead.

Build separate expense and settlement records

Set up two tabs. Expenses records responsibility: the original charge and who owes what. Settlements records the money sent afterward.

Here's a three-person example:

Date Description Type Amount Paid by Alex % Jordan % Taylor % Total % Alex share Jordan share Taylor share Note
2026-05-01 May rent Rent $2,400 Alex 40% 30% 30% 100% $960 $720 $720 Larger room for Alex
2026-05-10 Electric bill Utility $150 Jordan 40% 30% 30% 100% $60 $45 $45 Example usage split

Enter amounts as numbers formatted as currency. Format the share columns as percentages. In this layout, use these formulas in row 2:

  • I2 =SUM(F2:H2)
  • J2 =D2*F2
  • K2 =D2*G2
  • L2 =D2*H2

That Total % cell should display as 100%. If the total comes out lower or higher, fix the row before you use it.

Equal thirds are where rounding bites. You can use 33.33%, 33.33%, and 33.34%, then assign the extra cent deliberately so the shares add back to the bill total, because even a mathematically correct split can land a cent off once currency rounding gets involved.

The settlement tab answers a different question: who sent money to whom. Give it its own columns:

Date From To Amount Related expense Status Note
YYYY-MM-DD Jordan Alex $720 May rent Pending Jordan's rent share
YYYY-MM-DD Taylor Alex $720 May rent Paid Receipt reference

Walk through the rent row and it makes sense. Alex paid the landlord $2,400, but Alex's assigned share is $960, so Jordan and Taylor each owe Alex $720. Keep the original rent row even after those transfers are completed.

For another layout that separates expense records from settlement records, see Spark's shared expense spreadsheet setup.

Calculate balances without erasing the original math

List each roommate once on a Balances tab. For Alex, total paid comes from =SUMIF(Expenses!$E:$E,A2,Expenses!$D:$D). Alex's assigned share is =SUM(Expenses!$J:$J), because Alex's share lives in column J. The raw balance is total paid minus assigned share.

Jordan uses the K column. Taylor uses the L column. Then account for completed settlements with a formula such as:

=D2-SUMIFS(Settlements!$D:$D,Settlements!$C:$C,A2,Settlements!$F:$F,"Paid")+SUMIFS(Settlements!$D:$D,Settlements!$B:$B,A2,Settlements!$F:$F,"Paid")

Quick map of that formula: D2 is the raw balance, column B in Settlements is the sender, column C is the recipient, column D is the amount, and column F is the status. A positive final result means the group still owes that roommate. A negative result means that roommate still owes the group. Pending transfers stay out of the final number.

Run the tracker on each rent cycle

Each rent cycle runs the same loop:

  1. Agree on the split before move-in or before changing rooms. Check the lease before changing occupancy, subletting, or the person responsible for paying the landlord.
  2. Add the rent or bill row after someone pays. Include a receipt reference or a link to a shared receipt folder.
  3. Compare the payer with each person's assigned share. Create a settlement row for the amount another roommate owes.
  4. Mark a settlement as paid only after the money arrives. A payment app may move the money, but the spreadsheet remains the record of why it was sent.
  5. Review the sheet at each rent cycle. If the agreement changes, start a new split from a stated date and leave old rows unchanged.

A monthly review fits monthly rent. A disputed charge shouldn't wait that long. Don't overwrite an old percentage just to make the current balance look cleaner.

Avoid the common tracker mistakes

Problem Better practice
One percentage is used for every bill Separate fixed rent from usage-based expenses
A 100%/0% reimbursement row has no explanation Define what the convention means, or use clear From and To settlement columns
The original expense is deleted after reimbursement Keep the charge and the transfer as separate records
Rounding creates a mismatch Assign the extra cent and make the rule visible
Roommates edit formula cells by accident Use protected ranges where available and keep a backup copy
Income details are visible to everyone Record only the agreed percentage or dollar amount

One template habit deserves a warning. Some one-sheet designs log reimbursements as 100% and 0% rows, and that works only if the sheet explains whether 100% identifies the payer, recipient, credit, or another status. Without that legend, the row can look like the original cost split and reverse the meaning.

Know what the spreadsheet cannot decide

Thing is, a spreadsheet can calculate an agreement. It can't decide whether the agreement is fair or voluntary.

Name the arrangement for what it is. If the lower share is a subsidy from the other roommates, call it a subsidy. If it reflects a smaller room, use the room-based method instead of hiding the discount inside a reimbursement line.

The roommate agreement doesn't rewrite a landlord's lease or local housing rules, either. Check the lease before changing room assignments, adding a roommate, subletting, or changing who pays the landlord.

Start with the first rent row. Enter the agreed percentages, confirm the total reaches 100%, record who paid, and add the first settlement line. If the split feels wrong before anyone pays, renegotiate it before the sheet turns an unclear deal into a recurring dispute.