A Google Sheet can handle a family gas bill without a special app. Put the bill total, each person's agreed share, payments, and running balance in one record.

Start with the household rule, not the formula. If the rule is vague, a perfect spreadsheet only makes the disagreement easier to see.

This setup fits a multigenerational home, a parent and adult child, or siblings sharing a house. It also leaves a clear trail when someone asks, "What do I owe?"

Choose the split rule before opening the sheet

The right gas bill split depends on what your family is trying to make fair.

Method How it works Works better when Main friction
Equal Divide the total among the people, adults, or household units you name. Everyone has a similar arrangement. It can ignore differences in space, heating, or income.
Usage-based Use room size, nights stayed, or a written usage weight as a proxy. Residents use the home very differently. The estimate can become a new source of disagreement.
Income-based Divide each person's agreed income by total agreed income, then apply that percentage to the bill. Earnings differ substantially. Everyone must agree on the income definition and update timing.
Hybrid Split one part equally and another part by usage or income. The bill has fixed and variable lines. It requires more entries and a clearer written rule.

An equal split is easiest to audit. A usage split may feel closer to actual heating patterns, but room size and nights stayed are still estimates. Income-based sharing can reduce pressure on a lower earner, although it asks the family to discuss private numbers.

For a $200 bill shared equally by four agreed participants, each share is $50. With incomes of $1,334 and $1,766, total income is $3,100; the shares are about 43.03% and 56.97%. Applied to $200, that produces $86.06 and $113.94.

Thing is, the spreadsheet cannot decide who belongs in the denominator. Decide whether the rule covers adults, all residents, households, or another group.

Write the agreement in one sentence. For example: "We split recurring gas bills equally among two adults and review the rule every three months."

Set up two Google Sheets tabs

Create two tabs first: Members and Bills. Add a Rules tab if you want the agreement beside the calculations.

Tab Suggested fields Purpose
Members Name, agreed income, usage weight, equal share, income share, usage share Stores the inputs used to calculate percentages.
Bills Date, total due, split method, shares, amounts owed, amounts paid, net balances, notes Keeps one row for each billing period.
Rules Split definition, income definition, review date, payment instructions Records decisions that should not live only in someone's memory.
  1. On Members, enter each person's name. Add income only if the family has agreed to use an income-based method.
  2. Decide whether income means gross income, take-home income, or another agreed figure. Write that choice on Rules.
  3. On Bills, enter the date and total due from the statement. Do not estimate the amount.
  4. Format share columns as percentages. Format owed, paid, and net columns as currency.
  5. Add a dropdown for Equal, Usage, Income, and Hybrid if that helps people enter the same labels.
  6. Give edit access only to people who update the file. Avoid public edit links. A view-only copy or PDF can preserve a record after a review.
  7. Set a reminder for each billing period. Someone should own the entry, even if everyone can inspect it.

If income feels too private for a shared workbook, agree on the percentages separately and enter only those percentages in Bills. The rule still needs to be documented.

Add the gas bill split formulas

On the Members tab, use a layout like this:

Column Field
A Name
B Agreed income used for the split
C Usage weight
D Equal share
E Income share
F Usage share

Assume names run from row 2 through row 7. In Members!D2, enter =IF(A2="",0,1/COUNTA($A$2:$A$7)). In Members!E2, enter =IFERROR(B2/SUM($B$2:$B$7),0). In Members!F2, enter =IFERROR(C2/SUM($C$2:$C$7),0).

Copy each formula down to the last named member. Link the selected share column to the matching share column on Bills, or copy the percentages into the bill row when the family chooses a method.

For a two-person Bills tab, use this structure:

Column Example header Meaning
A Bill date Date shown on the statement
B Total due Amount being split
C Split method Equal, Usage, Income, or Hybrid
D Member 1 share Member 1 percentage
E Member 2 share Member 2 percentage
F Member 1 owed Calculated share of the bill
G Member 2 owed Calculated share of the bill
H Member 1 paid Amount paid toward this bill
I Member 2 paid Amount paid toward this bill
J Member 1 net Owed minus paid
K Member 2 net Owed minus paid
L Notes Payment, statement, or adjustment details

In F2, enter =ROUND($B2*D2,2). In G2, enter =ROUND($B2*E2,2). In J2, enter =ROUND(F2-H2,2), and in K2, enter =ROUND(G2-I2,2).

Positive net means that person still owes money. Negative net means that person has paid more than their share and should receive money back.

Put a check in a spare cell with =IF(ROUND(SUM(D2:E2),4)=1,"OK","Check shares"). For four members, expand the range to include every share column.

Rounding can leave a one-cent difference. For two members, the second owed cell can use =ROUND($B2-F2,2) after the first amount is rounded. For larger groups, subtract the preceding rounded amounts from the total for the final member.

Turns out, changing old rows makes later questions harder. Update the Members tab for a new job or an agreed change, but leave past bill rows showing the percentages used at that time.

Decide how to handle each bill line

Some gas statements show a fixed customer or service charge alongside a usage charge. If yours does, the family can split those lines differently.

Statement line Possible treatment
Fixed customer or service charge Divide equally, by adult, or by household unit, according to the written rule.
Usage charge Apply the equal, usage-based, income-based, or hybrid method the family selected.
Correction or adjustment Enter it separately and explain the decision in Notes.

A simple household can split the total amount due in one row. A household seeking more precision can enter each line separately and apply the agreed rule to each row.

Do not split the same charge twice. The rows should add back to the statement total.

A spreadsheet agreement does not change the utility account's terms. The person responsible for that account should keep the statement and payment confirmation.

Record reimbursements after someone pays

Usually, one person pays the utility company and the others reimburse that person. Your sheet should show both the amount each person owes and what each person has actually paid.

  1. Keep a photo or PDF of the statement with the household records.
  2. Add the bill date, total, method, and percentages to the next empty row.
  3. Confirm that the share check says OK.
  4. Enter each payment in the correct person's Paid column. Record the actual amount if someone pays in installments.
  5. Add the payment date and method to Notes, or use an optional Payments tab for a longer transaction history.
  6. Review the net columns before sending a reminder or settling the balance.

A payment request can stay simple: "Hi family, your share is $45 of the $180 gas bill under our equal split. Please send it through our agreed method, and I'll mark it paid when it arrives."

If Member 1 pays the full $200 bill, enter $200 in Member 1's paid column and $0 for everyone else. Member 1 will show a negative net of $100, while Member 2 shows a positive $100 on a two-person equal split.

A Paid? checkbox is convenient, but it cannot show partial payments. Keep the amount paid as the source of truth.

One small mess is worth accepting: if someone pays cash, record it when they tell you, then keep a receipt or short note somewhere outside the formula. Sheets are good at arithmetic. They do not remember conversations.

Check the sheet before sharing it

To be honest, most household spreadsheet fights begin with stale inputs, not complicated math.

  • [ ] Do the share percentages total 100%?
  • [ ] Do the owed amounts add up to the bill total?
  • [ ] Did each payment go in the correct person's column?
  • [ ] Did a new income, resident, or usage agreement change the next bill?
  • [ ] Is the file shared only with the people who need access?
  • [ ] Is the statement saved for later questions?

Enter bills during each billing period. Review balances monthly, then discuss the rule quarterly or whenever the household arrangement changes.

If manual entry becomes a chore, add a dedicated Payments tab with one row per payment. Another tracking tool may help with reminders, but keep the same written rule and payment records.

FAQ

How do I split a gas bill four ways?

Give each person one share column, one owed column, one paid column, and one net column. For an equal split, each share is 25%. For another method, calculate each percentage separately and make sure all four shares total 100%.

What if one family member pays the utility bill upfront?

Enter the full payment in that person's paid column, not just their personal share. The net columns will show that person's credit and the other residents' outstanding amounts.

Can we split the bill by bedroom?

You can use room size or another written weight as a proxy, but it is not a room-level meter reading. Explain the weights in the Rules tab and review them if the household changes.

Should we change old gas bill rows after an income change?

No. Keep historical rows intact. Apply the new agreed shares to the next bill and note the change date in Rules.

Does a spreadsheet prove that someone paid?

No. It records what the household enters. Keep a receipt, transfer confirmation, or cash note for payments that might later be questioned.

Create the Members tab, write the split rule in one sentence, and enter the next statement as the first Bills row. Check the share total before sending any payment request.