To split an electric bill by income share, calculate each person's percentage of combined income, then apply it to the bill. For example, if Person A earns $60,000 and Person B earns $40,000 for a combined $100,000, Person A covers 60% and Person B 40%. On a $200 electric bill, Person A pays $120 and Person B pays $80, per examples from the Online Split Bill calculator.

This approach suits U.S. roommates or couples with uneven incomes who want to divide utilities fairly using a spreadsheet, without relying on apps.

Income-Based Split Formula for Electric Bills

The core formula for an income-based split is: Your contribution percentage equals your income divided by combined income, times 100. This comes from editorial guidance on shared expense splits.

For a household example, add up all incomes to get the total. Divide each person's income by that total to find their share. Apply the percentage to the electric bill amount.

In a Google Sheets setup, use these columns:

Person Income % Share Bill Amount Share Owed
A 60000 =B2/SUM($B$2:$B$3) 200 =D2*E$1
B 40000 =B3/SUM($B$2:$B$3) =D3*E$1

Person A's % Share formula locks the sum range with $ for copying. Share Owed multiplies the row's percentage by the bill total in cell E1. This adapts the formula from Online Split Bill calculator examples for electric bills. Note this is low-confidence editorial guidance; test it for your group's needs.

Update incomes annually, as they reflect budget capacity over time.

Step-by-Step Workflow to Calculate and Track Splits

Set up a shared Google Sheet for recurring electric bills. Here's a concrete process:

  1. Create columns: Date, Bill Total, Person, Income, % Share (=B[row]/SUM($B$2:$B$[last row])), Share Owed (= [Bill Total cell] * [% Share cell]), Paid? (Yes/No dropdown), Receipt Link.

  2. Enter current incomes in the Income column once at the top. Calculate % Shares automatically.

  3. For each new bill, add the date and total in row 2 (or next open row). Shares update via formulas.

  4. Use =SUMIFS(Share Owed column, Paid? column, "No") to total outstanding amounts.

  5. Share the sheet: Set editors for trusted roommates, view-only for others. Protect formula columns to avoid edits.

Common mistake: Forgetting to update incomes yearly or after job changes. Add a note row: "Incomes last updated [date]."

For multiple months, copy rows down. This keeps records lightweight without apps.

Tradeoffs of Budget Share vs Other Split Methods

Income-based splits work when earnings differ significantly, as each person contributes proportional to their budget capacity, per How to Split Costs Fairly with Roommates in Essen (a Germany example; adapt percentages for U.S. groups).

Consider these options:

  • Income-based (budget share): Matches ability to pay. Tradeoff: Requires sharing income details, which some avoid for privacy.

  • Equal split: Divide bill evenly (e.g., $200 / 2 = $100 each). Simple for similar finances. Tradeoff: Burdens lower earners.

  • Usage-based: Track via sub-meters or room size (e.g., Person A in larger room pays more). Fair if one uses AC heavily. Tradeoff: Needs extra effort or hardware.

Use this checklist to pick:

  • Does your group have income variance over 20-30%? Consider income-based.

  • Can you track individual usage (e.g., separate meters)? Consider usage-based.

  • Prefer no math or privacy? Consider equal split.

No method is universally fair; discuss upfront. For electric bills, income-based suits uneven couples or roommates without usage data.

When to Review and Document Your Split Rules

Review splits quarterly, on bill spikes over 20%, or after income changes. Document in the spreadsheet's first tab: "Agreed Rules - Electric: Split by income share (A:60%, B:40%). Excludes personal fans/heaters."

Request payment with a script: "Per our income split (A:60%, B:40%), you owe $80 for March electric - receipt [link]. Due by [date]."

Set boundaries: Agree what counts as shared (e.g., whole-house AC yes, desk lamp no). Keep receipts via photo links or a shared folder.

For records, export the sheet to PDF monthly: File > Download > PDF. This creates a lightweight audit trail for disputes.

If group grows, note permissions: One owner edits incomes; others mark "Paid."

FAQ

How do I handle electric bills if incomes change mid-year?

Recalculate percentages with new incomes. Add a "Revision Date" column and note the change (e.g., "B new job: income to $50k"). Apply forward to future bills.

Is income-based splitting fairer than equal splits for roommates?

It depends on variance. Income-based eases burden on lower earners but needs trust in numbers. Equal is simpler if budgets align.

Can I use this in Google Sheets for multiple bills?

Yes. Stack rows for each bill; formulas auto-scale. Use SUMIFS for balances.

What if one person uses more electricity?

Switch to usage-based: Estimate via room sq ft or kWh meters. Combine with income if needed (e.g., usage % times income %).

Do I need an app, or is a spreadsheet enough?

A spreadsheet handles tracking and calculations for small groups. Apps add reminders but are optional.

Where did the budget share formula come from?

From editorial examples at Online Split Bill calculator, adapted for spreadsheets.

Next, set up your sheet and test with last month's bill. Discuss rules in a group chat for buy-in.