Can three roommates share rent, power bills, and grocery runs in a single Google Sheet without losing their minds? Yes, if your ledger tracks exactly who put up the money and who owes a cut of it. A clean setup needs just three tabs: Expenses, Summary, and Settlements.

Keep every original expense intact. When someone repays you two weeks later, leave that first charge alone. Overwriting old rows makes audit trails impossible to piece back together.

Thing is, spreadsheets handle math, not manners. A formula calculates an exact share, but it cannot confirm that cash landed in your bank account or force your roommates to agree on what feels fair.

Start with one row per shared charge

One charge gets one row. Always. If a quarterly utility invoice spans three calendar months and you prefer viewing each month on its own, split those totals before typing anything into the sheet.

Alex, Jordan, and Sam serve as stand-ins across this guide. Swap them out for your actual housemates.

Column Enter Example
A: Date Date the charge occurred 2026-01-01
B: Description Plain-language description January rent
C: Category Rent, Utilities, Groceries, or another label Rent
D: Paid By Person who paid the bill Alex
E: Amount Full charge in dollars $2,000
F: Split Method Rule used for this row Equal
G: Alex % Alex's agreed share 33.33%
H: Jordan % Jordan's agreed share 33.33%
I: Sam % Sam's agreed share 33.34%
J: Alex Share Formula-calculated amount $666.60
K: Jordan Share Formula-calculated amount $666.60
L: Sam Share Formula-calculated amount $666.80
M: Receipt or Notes Link, context, or exception Electric bill link
N: Check Percentage check OK

The Amount column anchors the entire tab. The percentage and share columns just divide that primary figure.

Four roommates mean four percentage columns and four share columns. Match names letter for letter on every tab, because Google Sheets will never guess that "Jon" means "Jordan" when calculating totals.

Rent rarely sparks friction because the price stays fixed. Groceries, internet gear, cleaning spray, and hasty hardware-store trips are where descriptions get lazy, and lazy receipts cause bitter roommate arguments.

Agree on the split before calculating it

Write your household rules down before logging a single expense. Formulas cannot fix social misunderstandings.

Equal splits work when everyone consumes roughly the same resources. Yet that system frays fast if one person rents an attached master bath, another eats out daily, and a third spends half the week at a partner's flat. Talk through those quirks first.

Income-based splits use an agreed ratio, like 50/30/20, rather than an automatic assumption that high earners must cover extra. Enter that specific ratio in Split Method so everyone remembers the underlying logic.

Room square footage offers a clear baseline for monthly rent, though it makes less sense for power or water bills. Nights-stayed splits accommodate transient roommates, provided you keep a shared calendar. Per-person breakdowns fit group dinners or household purchases where only two of three people participated.

When a purchase belongs entirely to one person, mark the Split Method as Reimbursement. Set their share to 100% and drop everyone else to 0%. This convention matches common tools like this roommate spreadsheet example. It simply assigns liability. It does not prove anybody sent cash.

Every row must total 100%. Three people splitting $2,000 cannot pay clean thirds, so shares of 33.33%, 33.33%, and 33.34% generate rounded costs of $666.60, $666.60, and $666.80. A $150 utility charge split 40%, 30%, and 30% yields $60, $45, and $45.

Build the Google Sheets template

Set up the sheet structure with these steps:

  1. Open Google Sheets and start a new spreadsheet. Name the first tab Expenses, then add tabs named Summary and Settlements.
  2. Add these headers across row 1: Date, Description, Category, Paid By, Amount, Split Method, Alex %, Jordan %, Sam %, Alex Share, Jordan Share, Sam Share, Receipt or Notes, and Check.
  3. Format column A as Date, column E and columns J through L as Currency, and columns G through I as Percentage.
  4. Create data validation dropdowns for Paid By and Split Method. Consistent names protect summary formulas from silent match failures.
  5. Paste these formulas into row 2, then drag them down into future expense rows:
J2: =IF($E2="","",ROUND($E2*$G2,2))
K2: =IF($E2="","",ROUND($E2*$H2,2))
L2: =IF($E2="","",ROUND($E2*$I2,2))
N2: =IF($E2="","",IF(ROUND(SUM($G2:$I2),4)=1,"OK","Check split"))
  1. Select View, then Freeze, then 1 row. Your headers remain pinned as rows accumulate.

Here are two starter entries to confirm your setup:

Date Description Category Paid By Amount Split Method Alex % Jordan % Sam %
2026-01-01 January rent Rent Alex $2,000 Equal 33.33% 33.33% 33.34%
2026-01-10 Electric bill Utilities Jordan $150 Income-based 40% 30% 30%

Turns out formulas bounded at row 100 will break silently without showing errors when your lease runs past month ten. Set your range references deep enough right from the start.

Show who is owed and who owes

Balances come down to basic subtraction:

amount paid - amount assigned

A positive number means the group owes you money. A negative balance means you owe money back to the household.

Build this structure on your Summary tab:

Column Heading
A Person
B Paid
C Assigned Share
D Expense Balance
E Sent
F Received
G Current Balance

List your housemates in cells A2 through A4, then add these formulas:

B2: =SUMIF(Expenses!$D$2:$D$100,$A2,Expenses!$E$2:$E$100)
C2 for Alex: =SUM(Expenses!$J$2:$J$100)
C3 for Jordan: =SUM(Expenses!$K$2:$K$100)
C4 for Sam: =SUM(Expenses!$L$2:$L$100)
D2: =B2-C2

Drag B2 and D2 downward. Each roommate's assigned cell must point to their dedicated share column in Expenses. Whenever you rename someone, update both their row label and their share formula.

Summary tabs can also host helpful overview widgets. This query rolls up spending by category:

=QUERY(Expenses!A1:N100,"select C, sum(E) where C is not null group by C label sum(E) 'Total'",1)

To spotlight large purchases, drop this filter formula into an open cell:

=IFNA(FILTER(Expenses!A2:N100,Expenses!E2:E100>100),"No charges over $100")

Adjust that $100 cutoff to whatever matches your household budget. Use these summaries to spot anomalies, not as substitutes for line-item records.

Record repayments in a separate tab

A shared bill and an actual cash payback are two distinct events. Keep them separated.

Imagine Jordan buys $50 of groceries for Sam alone. On Expenses, list Jordan under Paid By, enter $50 as Amount, set Split Method to Reimbursement, and assign Sam 100% while setting Jordan and Alex to 0%. That single entry increases Jordan's net balance by $50 and lowers Sam's by $50.

Once Sam transfers that $50 back, log a new entry on Settlements:

Column Enter
A: Date Date the payment was made
B: From Person who sent the money
C: To Person who received it
D: Amount Payment amount
E: Note Reference or short description

If Sam settles with Jordan, enter Sam in From and Jordan in To. Don't mark debts paid until funds actually clear. Add a payment confirmation code or receipt link whenever roommates want hard verification.

Link these settlements back into the Summary tab with these formulas:

E2: =SUMIF(Settlements!$B$2:$B$100,$A2,Settlements!$D$2:$D$100)
F2: =SUMIF(Settlements!$C$2:$C$100,$A2,Settlements!$D$2:$D$100)
G2: =D2+E2-F2

Current Balance factors in both shared charges and direct paybacks. As soon as Sam sends that $50 payment to Jordan, both balances level back out to zero.

External payment apps handle the transaction itself. Your spreadsheet retains the permanent record.

Share the file without breaking formulas

Google Sheets provides three permission tiers: Viewer, Commenter, and Editor. Viewers only read, Commenters post remarks, and Editors rewrite sheet contents. Review this sharing permissions overview for exact settings.

Give Editor rights only to roommates entering expenses. Protect columns J through L and N against accidental edits while leaving input cells open. Configure range protection under the Data menu, then verify permissions using an alternate test account.

Share by email address rather than an open public link, especially if receipts contain home addresses or bank notes. In sharing settings, uncheck the box that allows editors to add new users or alter permissions so one tenant maintains administrative control. Turn to version history whenever someone inadvertently wipes out a cell.

Edits sync in real time across active accounts. Even so, establish one firm house rule: enter every new transaction on a fresh row, and never delete an existing row to show a settled balance.

Review the ledger on a regular cadence

Schedules keep sheets alive. Pick a rhythm and stick to it:

Timing Review
After each bill Enter the charge, check the percentages, and attach the receipt link
Weekly Look for missing bills, blank payer names, and rows marked Check split
Month end Compare the Summary balance with the group chat or payment records
Before moving out Save a copy of the final ledger and review deposits, final utilities, and unsettled rows

To be honest, ten minutes on a Sunday beats spending a weekend combing through seven months of crumpled supermarket slips and text threads. Anchor your reviews to when bills actually hit your inbox.

Fix the mistakes that cause most disputes

Shared files derail in predictable ways:

Mistake Better practice
Typing 33.33 instead of 33.33% Enter a percentage or its decimal equivalent, such as 0.3333
Letting percentages total 99% or 101% Use the Check column and adjust the final share for rounding
Changing an old amount after repayment Leave the charge intact and add a Settlements row
Overwriting a formula Protect J:L and N, then copy formulas from the row above
Using one split rule for every bill Choose the rule by expense and document exceptions
Leaving receipts in private messages Add a restricted shared link in Receipt or Notes
Mixing household and personal costs Record only shared charges and mark exclusions clearly

Uneven splits do not create conflict. Hidden adjustments do.

Know when the spreadsheet is enough

A spreadsheet works best for small groups with steady routines, consistent monthly bills, and people who do not mind logging transactions. It lets you customize math freely, keeps formulas visible to everyone, and leaves historical receipts intact.

If you spend more time chasing delinquent roommates than managing money, swap to a dedicated split-expense app with push notifications and receipt scanning. Tracking, requesting, paying, exporting, and recordkeeping represent distinct jobs, so figure out which step is failing before abandoning your sheet.

Practical edge cases

A roommate misses one bill

Enter the expense under its original charge date and actual payer. Add a quick note in column M explaining the late entry. Backdating keeps monthly figures accurate without rewriting history.

Someone moves out mid-month

Log partial-month expenses on a separate line with custom percentages. Never adjust past rows that the household already settled.

More than three roommates join

Insert an extra percentage column and matching share column in Expenses. Expand the percentage check formula to include the new column, then add the new roommate to the Summary tab with their matching share reference.

Your group wants a simpler setup

Small two-person rentals can skip the Settlements tab entirely by adding a Settled? checkbox to Expenses. That indicates whether a charge cleared, though it will not track partial paybacks as cleanly as a From-and-To log.

Set up your three tabs now, log this month's rent, and confirm everyone agrees on split percentages before sending out Editor invitations.