Use a Google Sheets template with columns for expense details, split percentages per person, and sum formulas to calculate individual shares for utilities. For example, mark reimbursements as 100% for one person and 0% for others, as noted in Expensesorted's roommate expense template guide. This setup helps U.S. roommates, couples, or small groups track percentage-based utilities splits by room size, usage, or income without needing apps.

Set up the sheet in minutes: list the date, utility type, total amount, split type, and percentages for each person. Use simple formulas like =total amount times Person1 percentage to compute shares. Share the link for real-time edits so everyone sees updates live. Review monthly after bills arrive, attach receipts via comments or links, and track balances owed.

This approach works for recurring bills like electricity or water, where equal splits do not fit actual usage or contributions.

When to Use a Percentage Split for Utilities

Percentage splits make sense when utilities use varies by household member. For instance, one roommate with a larger room or higher income might cover more than an equal share. Consider usage-based splits, like assigning 60% to a heavy user, 20% each to two others, and 0% to someone who ate none, similar to a Ratehub.ca pizza-splitting example for roommate expenses.

Tradeoffs include fairness versus simplicity. Equal splits (everyone pays 25% for four people) suit low-conflict groups with similar habits. Percentage splits better match reality, such as room size (bigger room pays 40%) or income (higher earner covers 60%). But they require agreement upfront and more tracking effort.

Income-based splits approximate fairness by adjusting shares to earnings ratios. Room-size splits work for rent-tied utilities. Usage-based needs honest estimates, like submeter readings for electricity. Spreadsheets handle these for simple, recurring bills in low-activity groups. For frequent one-off reimbursements or payments, apps add requesting features, though spreadsheets suffice for tracking alone.

Discuss rules first: agree on percentages, review process, and dispute handling. Document in the sheet's first tab for reference.

Google Sheets Template Setup Steps

Start with a new Google Sheet. Name it "Utilities Split Tracker - [Group Name]". Use these editorial-recommended columns in row 1, adapted from shared expense trackers:

  • A: Date (format MM/DD/YYYY)
  • B: Utility Type (e.g., Electricity, Water, Internet)
  • C: Total Amount (currency format, e.g., $150.00)
  • D: Split Type (e.g., Usage, Income, Equal, Reimbursement)
  • E: Person1 Name & %
  • F: Person2 Name & %
  • G: Person3 Name & % (add columns as needed)
  • H: Notes/Receipt Link
  • I: Person1 Share (=C2 * percentage from E2)
  • J: Person2 Share (=C2 * percentage from F2)
  • etc.

For column E, enter as "Alice - 40%" or use separate subcolumns for name and percentage (e.g., E: Alice %, F: 0.4). In I2, enter =C2*E2 (assuming E2 holds 0.4). Percentages should sum to 100% or 1.0; add a check formula in a summary row like =SUM(E2:G2)=1.

Steps:

  1. Enter bill details in rows 2+ after payment.
  2. Set percentages based on your rule (e.g., 60%/20%/20%/0% for usage).
  3. Formulas auto-calculate shares.
  4. For reimbursements, note "Reimbursement" in D and set 100% for payer, 0% others, per Expensesorted guidance.
  5. Add a summary tab: use SUMIF for each person's total owed/paid.

Test with a sample: $200 electric bill, Alice 50% (0.5), Bob 30% (0.3), Charlie 20% (0.2). Shares: $100, $60, $40.

Percentage Split Formula Examples

Basic share: In cell I2, =C2 * $E$2 (lock row for copying down). Copy across for others.

For income ratio approximation from Jakelee.co.uk's bill-splitting post, use =(C2 / number of people) income_percentage. Example: $500 bill, 3 people, Alice's 60% share: =(500 / 3) 0.6 = about $100. Adjust "income_percentage" from agreed ratios (e.g., earnings 6k:3k:1k totals 10k, so 60%:30%:10%).

Usage example: Heavy user (60%), two medium (20% each), guest (0%), as in Ratehub.ca's analogy. Enter in percentage columns; formula multiplies total times each %.

Totals per person: In summary tab A1 "Alice Total", below: =SUMIF(Sheet1!E:E, "Alice", Sheet1!I:I). Track running balance: add Paid column, then Balance = Shares - Paid.

These are editorial examples, not official formulas. Verify sums match 100% each row to avoid errors.

Sharing, Updates, and Common Mistakes

Share via link: Click Share > Get link > Anyone with link can edit. Everyone sees real-time changes, as in Expensesorted's template notes. Set notifications for bill months.

Update cadence: Enter after each bill (monthly for most utilities). Review quarterly: sum balances, request payments via Venmo/Zelle with sheet screenshot.

Common mistakes:

  • Forgetting to share edit access (view-only blocks updates).
  • Formula errors: Use absolute references ($C$2) when copying.
  • Percentages not summing to 100% (add =IF(SUM(E2:G2)=1,"OK","Check %")).
  • No receipts: Link Google Drive photos in Notes.
  • Over-editing: Use comments for disputes.

Spreadsheets work for low-activity groups (2-6 people, 1-5 bills/month). Switch to apps if needing payment requests, scanning, or reminders beyond tracking.

Limitations of Spreadsheet Templates

No official Google Sheets templates exist for utilities percentage calculators as of 2026; guidance draws from editorial blogs like those cited. Features rely on basic functions; advanced automation needs scripts (beyond this guide).

Manual entry required - no auto-import from utility portals. Editorial sources predate 2026, so confirm current sharing rules in Google Sheets help.

Spreadsheets excel at custom percentages but lack app features like push reminders or integrated payments. For tracking and records, they suffice; pair with cash apps for transfers.

FAQ

How do I calculate a utilities share by income percentage?

Approximate with =(total / num_people) income_ratio, like (500 / 3) 0.6 for 60% share, per Jakelee.co.uk editorial. Base ratios on monthly earnings; agree first.

What's the best column setup for percentage splits?

Date, Utility Type, Total, Split Type, per-person %, Notes, then auto-share columns with =Total * %. Add summary tab for balances, adapted from Expensesorted.

How do I handle reimbursements in the template?

Mark Split Type "Reimbursement", set 100% for payer and 0% others. Track until settled.

Can multiple people edit the sheet at once?

Yes, with edit-link sharing; changes appear live, per Expensesorted's roommate template notes.

When should I switch from a spreadsheet to an app?

If needing payment requests, receipt scans, or frequent one-offs beyond monthly tracking.

Are there official Google Sheets templates for this?

No; use custom setups with editorial column/formula examples.

Next, create your sheet, test with last bill, and share the link. Review rules yearly as group changes.