Yes, a shared Google Sheet can handle a roommate rent split. Set up an expense log, a settlement log, and a summary that turns each person's share into a balance.

That separation matters. A rent charge is an expense. Money sent later is a settlement. Recording both in one row can make the household look like it spent more than it did.

Google Sheets lets people work from the same file while the owner controls who may view, comment, or edit it. Its Sheets product page describes those sharing and collaboration features. The file still needs rules; a live spreadsheet won't decide whether rent should be equal, based on room size, or tied to usage.

Set up the shared workbook

Create one file and give it a plain name, such as Roommate Expenses. Four tabs keep the math easier to follow:

Tab What it holds Editing approach
Expenses One row for each rent charge, utility, grocery run, or household cost Roommates enter new rows
Settlements Money sent from one roommate to another Roommates record payments
Summary Amount paid, amount owed, and current balance Protect formulas
Rules The agreed split method, rounding choice, and review routine Keep as a reference

Use actual names in the participant columns. Alex, Bailey, and Casey are easier to audit than Person 1, Person 2, and Person 3.

Turns out, clear labels prevent more arguments than clever formulas do. Write down what counts as a shared expense before the first dispute arrives.

Build the rent split calculator

On the Expenses tab, place these headings in row 1:

Date, Description, Category, Amount, Paid by, Split type, Alex %, Bailey %, Casey %, Jordan %, Split check, and Notes.

Replace the names with your household's names. If there are three roommates, use three share columns instead of leaving an unused fourth column in the calculation.

Enter amounts as numbers, then format the column as currency. Enter 25%, not 25, in a percentage cell.

Here is a sample rent row:

Date Description Amount Paid by Split type Alex % Bailey % Casey % Jordan %
2026-01-01 Rent $2,400.00 Alex Equal 25% 25% 25% 25%

In K2, add a check that confirms the participant shares total 100 percent:

=IF($D2="","",IF(ROUND(SUM($G2:$J2),4)=1,"OK","Check split"))

Copy that formula down the column. OK means the row's percentages add up correctly. Check split flags a missing or excess share before it reaches the balance summary.

For a three-person equal split of $2,000, you can enter 33.33%, 33.33%, and 33.34%. The resulting shares are $666.60, $666.60, and $666.80. Decide in the Rules tab who gets the extra cent when rounding creates one.

A $150 utility split 40%, 30%, and 30% produces shares of $60, $45, and $45. The same percentage columns can handle room-size, nights-stayed, or custom arrangements.

Use Split type for sorting and explanation. Useful entries include Equal, Percentage, Usage, and Custom. If money changes hands later, record that transfer on the Settlements tab rather than entering the original bill again.

You can add dropdowns to Paid by and Split type with Google Sheets data validation. This helps prevent small mismatches such as Alex in one row and Alex with an extra space in another.

Turn the rows into roommate balances

The Summary tab can show whether each person should receive money or pay money. Set up these columns:

Person Total paid Expense share Gross balance Sent in settlements Received in settlements Net balance
Alex
Bailey
Casey
Jordan

Put each person's name in column A. For Alex in row 2, use these formulas:

B2: =SUMIF(Expenses!$E$2:$E$200,$A2,Expenses!$D$2:$D$200)
C2: =SUMPRODUCT(Expenses!$D$2:$D$200,Expenses!$G$2:$G$200)
D2: =B2-C2
E2: =SUMIF(Settlements!$B$2:$B$200,$A2,Settlements!$D$2:$D$200)
F2: =SUMIF(Settlements!$C$2:$C$200,$A2,Settlements!$D$2:$D$200)
G2: =D2+E2-F2

For Bailey, change the share range in C3 from column G to column H. Use column I for Casey and column J for Jordan. You can copy the other formulas down the Summary tab.

A positive net balance means the group still owes that person. A negative balance means that person owes the group. A zero means the recorded expenses and settlements now balance.

The sheet won't care that the grocery receipt is in a jacket pocket or that someone paid back cash on Tuesday. It sees rows, names, and numbers. That is the point, mostly, but the little habits matter.

On Settlements, use this structure:

Date From To Amount Note
2026-02-03 Bailey Alex $25.00 Grocery reimbursement

A settlement is not a new grocery expense. It records money moving from Bailey to Alex, so the Summary formula adds the amount to Bailey's position and subtracts it from Alex's remaining balance.

If you prefer the word Reimbursement, put it in the note or add a settlement type column. Do not mix a reimbursement into the expense total unless your formulas are designed to treat it separately.

Pick a split rule everyone can explain

Equal splitting is easy. It is not always fair.

Method Useful when Detail to agree on
Equal per person Everyone uses the home and shared services similarly Whether a vacant room or short absence changes the share
Room size Bedrooms differ substantially The percentage assigned to each room
Usage based Utilities or supplies vary by use What evidence or estimate determines usage
Nights stayed A temporary roommate or guest uses the home Which nights count
Per-person participation Groceries, meals, or events include only some people Who receives 0% for that row
Income based Everyone explicitly agrees to contribute by an income ratio The ratio, such as 50/30/20, and how it will be reviewed

Income should not automatically determine a roommate's share. Use an income-based split only when everyone agrees to it.

A useful Rules tab entry might say: Base rent is split 25% each. Electric is split 40/30/30. Grocery rows include only the people who joined the purchase. Settlements go on their own tab.

Write the boring version down. A rule that sounds obvious in the kitchen often isn't obvious six weeks later, especially when one person thinks "utilities" means electricity only and another includes internet.

A spreadsheet also does not replace a lease or local landlord-tenant rules. If a lease controls who owes a charge, follow that document and treat the workbook as a record of the roommates' calculations.

Share the sheet without losing control

Google Sheets offers Viewer, Commenter, and Editor roles. Choose the least powerful role that still lets each person do their part.

  1. Click Share and add each roommate's email address.
  2. Give Editor access only to people who need to add or correct rows.
  3. Use Commenter for someone who needs to flag an issue without changing cells.
  4. Use Viewer for someone who only needs to review the ledger.
  5. Keep general access restricted instead of using a public link for household financial records.
  6. Review the sharing settings for whether editors can change permissions or share the file. Turn that option off if you want the owner to manage access.
  7. Use Data > Protect sheets and ranges for the Summary tab, headers, and formula cells. Leave the intended input area open.

Protected ranges help prevent accidental overwrites. They do not make a file private from someone who already has access.

Ask roommates to add new expenses on separate rows. Two people changing the same cell at once can still create confusion, even in a shared file.

Keep an audit trail

Mistakes happen. A version history gives you a way to inspect an earlier state instead of guessing who changed a formula.

In Google Sheets, the usual path is File > Version history > See version history. Select the version in the side panel, then use the three-dot menu to restore it when necessary. SpreadsheetPoint's version history walkthrough shows that menu path and explains why naming important versions helps later.

Name useful milestones, such as Before March settlement or January expenses reviewed. Dates and times alone become hard to recognize after several months.

A simple review routine can look like this:

Timing Check
After adding an expense Confirm the payer, amount, participants, and Split check result
Once each week or on an agreed day Ask whether any bills, grocery runs, or reimbursements are missing
After a payment Add the From, To, amount, and date on Settlements
At month end Review every nonzero balance and save a copy if the record matters

To be honest, the exact day matters less than having a day. A reminder in a shared calendar can keep the sheet from becoming a last-minute argument.

Common problems and practical fixes

Problem What to do
A row says Check split Correct the percentages before relying on the Summary
A bill appears twice Compare the date, description, amount, and receipt before deleting anything
A repayment changes spending totals Move it to Settlements and leave the original expense intact
Someone overwrites a formula Protect the formula range and use version history to inspect the change
A roommate cannot edit Reopen Share and confirm the email has the intended role
A public link exposes private records Change general access to restricted and invite specific people
Two people edit one row Give each new expense its own row and discuss corrections in a note

This template works best for a small group that can agree on a rule and review entries regularly. It becomes less comfortable when expenses arrive constantly, several people need receipt images, or the group expects payment requests to connect directly to the ledger.

If that happens, compare alternatives by function: expense tracking, payment requests, actual payment, exports, and recordkeeping are separate needs. A different tool may help with one of them, but it still won't choose a fair split for your household.

Create the four tabs, enter last month's rent and one utility, and test the Summary with a sample settlement. Have every roommate confirm the split rule and the balance before you invite ongoing edits.