Do you really need another monthly app subscription just to divide the power bill? Probably not. A basic Google Sheet handles shared utilities cleanly if you set up the columns properly from the start. You log each invoice as it arrives, tag the roommate who paid it, and let formulas calculate the net debt between everyone under your roof. Nobody has to guess who covered the Wi-Fi. The math stays visible in real time.
Recommended Columns for a Shared Bill Ledger
Most tracking sheets fail because people try to combine the raw bill log with the settlement ledger in a single messy row. Thing is, separating the bill details from the participant breakdown keeps your math intact when someone pays early or covers an extra fee.
| Column Header | What Goes In It | Example Entry |
|---|---|---|
| Bill Name | Service and billing period | Electric (July) |
| Total Billed | Statement balance due | $165.00 |
| Due Date | Utility company deadline | 07/18/2026 |
| Payer | Person who paid the provider | Jordan |
| Split Rule | Equal, custom, or reimbursement | Equal |
| Jordan Share | Jordan's portion of the bill | $55.00 |
| Taylor Share | Taylor's portion of the bill | $55.00 |
| Morgan Share | Morgan's portion of the bill | $55.00 |
| Settled? | Status flag for house bookkeeping | Yes |
Add a dedicated column for every roommate. If you have four roommates, you will have four share columns. It feels wide at first, but horizontal layouts make row-by-row auditing painless.
Core Formulas for Who Owes What
Automating the math requires only three primary steps.
- Calculate individual shares automatically.
If row 6 is an equal split among three people, put this formula in Jordan's share column (cell F6):
=IF($E6="Equal", $B6/3, 0)
Replace the 3 with your actual household headcount. When a bill is not split equally, type the custom amount directly into that cell.
- Build a summary block above your log.
Do not put balance totals at the very bottom of an expanding table. Put them in rows 1 through 4 at the top of your sheet, or on a second tab named Summary. To find out what Jordan paid upfront across all months, use SUMIF:
=SUMIF($D$6:$D$100, "Jordan", $B$6:$B$100)
That formula checks column D for Jordan's name and sums the billed amounts he paid.
- Calculate each person's net position.
Take what Jordan paid to the utilities and subtract what he personally owes across all rows:
=SUMIF($D$6:$D$100, "Jordan", $B$6:$B$100) - SUM($F$6:$F$100)
A positive number means the house owes Jordan money. A negative number means Jordan owes the house. The balance updates automatically every time you log a bill.
Handling Reimbursements and Direct Paybacks
Turns out, the messiest part of roommate math is not the utility company invoice. It is the random peer-to-peer transfers people make on Tuesday night to square up. If Taylor sends Jordan $55 for July electricity, how do you record that without messing up the total utility expense history?
Log the repayment on its own line. In the Bill Name column, enter "Reimbursement: Taylor to Jordan". Enter $55 in Total Billed. Set the Payer column to Taylor. Under the split rule, mark it as Reimbursement. In the share columns, give Jordan a share of $55, and set Taylor and Morgan to $0. Jordan's share counts as an expense against his ledger balance, reducing what the house owes him, while Taylor gets credit for paying $55 upfront. The overall house expense total stays slightly distorted if you sum the whole column blindly, so use SUMIFS in Google Sheets to exclude rows marked "Reimbursement" when generating your annual expense reports.
Locking Down Cells to Prevent Broken Sheets
Shared spreadsheets break when someone accidentally types a number over a cell that holds an active formula. It happens constantly during late-night balance checks on a phone.
You can prevent this by using native sheet protections. Highlight your summary formula cells and your calculated share columns. Go to Data, then click Protect sheets and ranges. In the sidebar that appears, select Set permissions and restrict edit rights to yourself. You can review the exact setup steps in this guide to protect sheets and ranges. Your roommates can still enter new rows, select drop-down values, and type invoice numbers, but your math engine stays locked.
Deciding Between a Sheet and a Dedicated App
To be honest, spreadsheets are not ideal for every household situation. A shared sheet is usually the better choice when:
- Your household has three to five dependable people who manage recurring monthly services like power, water, trash, and fiber internet.
- You want full ownership of your payment history without dealing with banner ads, paywalled transaction exports, or surprise subscription tiers.
- The house prefers settling balances once a month in a single batch instead of pinging each other three times a week for nine-dollar items.
If you live in a rotating cooperative with eight people moving in and out, or if you need automated push notifications to remind someone to pay, an app makes more sense. Otherwise, keeping your records in Google Drive avoids friction and keeps personal banking details off third-party platforms.
Getting Started
Set up your sheet before your next utility cycle cuts. Enter the upcoming billing dates, assign one person as the primary contact for the utility providers, and schedule a five-minute check-in on the first of every month to clear net balances.