Use a Google Sheets gas bill reimbursement tracker with one row per bill and a separate transaction log. For a home with one pet, enter an agreed pet adjustment as a relative weight, calculate each share against the fixed bill, and record every utility payment and reimbursement. That gives roommates one place to check the math.
The pet percentage is a house rule. Thing is, a pet does not automatically make gas use higher. If nobody can explain the extra use, an equal split may be the fairest choice. If the household agrees that the pet owner should carry more, write down the reason and revisit it after a few bills.
Choose a fair rule before adding formulas
Start with the rule, not the formula. Gas bills can include shared heating, cooking, and fixed charges, so the exact pet-related portion usually isn't measurable from the bill alone.
| Rule | Use it when | Sheet input |
|---|---|---|
| Equal split | Everyone's use is broadly similar | Enter 0% |
| Weighted pet-owner split | The household agrees that the pet owner carries a modest extra share | Enter an agreed percentage, such as 20% |
| Room or nights split | Room sizes or occupancy differ | Use a separate allocation table |
| Fixed exception | The group agrees on a specific dollar adjustment | Record the adjustment separately and make sure all shares still total the bill |
The weighted method treats the percentage as extra share weight. A 20% adjustment means the pet owner has 1.20 share units while each other roommate has 1.00; it does not mean the pet owner pays 20% of the bill.
For a $120 bill with three non-pet roommates, the denominator is 3 + 1 + 0.20 = 4.20. Each non-pet roommate pays $28.57, and the pet owner pays $34.29. The shares total $120 after rounding.
Build the Bills and Transactions tabs
Create three tabs: Bills, Transactions, and Summary. Bills stores the allocation, Transactions records money movement, and Summary shows what each person has paid or still owes.
Start with the Bills tab. Use one row per gas bill.
| Column | Example or formula | Purpose |
|---|---|---|
| A: Bill ID | Jan-2026 |
Matches payment records to the bill |
| B: Bill date | 2026-01-31 |
Identifies the bill period |
| C: Total bill | $120.00 |
Enter the full gas bill |
| D: Pet adjustment % | 20% |
Enter the agreed relative weight |
| E: Non-pet roommate count | 3 |
Count people other than the pet owner |
| F: Each non-pet share | =ROUND(C2/(E2+1+D2),2) |
Calculates the base share |
| G: Pet owner share | =ROUND(C2-(E2*F2),2) |
Assigns the remaining cents to the pet owner |
| H: Receipt link | Optional Drive link | Keeps proof with the bill |
| I: Allocation check | =ROUND(C2-(E2*F2+G2),2) |
Should show $0.00 |
Enter 20%, not 20, in column D. Format C, F, G, and I as currency, D as a percentage, and E as a number. Then fill the formulas down.
The residual formula gives the pet owner the rounding penny, so the row ties exactly to the bill. If the household prefers to assign that penny elsewhere, document the choice and use the same rule each month.
Use the Transactions tab for every movement of money. That includes the original utility payment and later reimbursements.
| Column | Example | Purpose |
|---|---|---|
| A: Date | 2026-02-01 |
Date money moved |
| B: Bill ID | Jan-2026 |
Connects the transaction to a bill |
| C: From | Roommate A |
Person who sent the money |
| D: To | Utility or Pet Owner |
Recipient |
| E: Amount | $120.00 |
Amount transferred |
| F: Type | Utility payment or Reimbursement |
Separates bill payments from roommate payments |
| G: Note | January gas bill |
Optional reference or receipt link |
Use one row for each movement. A partial reimbursement gets its own row.
For the January example, Roommate A might send $120.00 to the utility. The pet owner then sends $34.29 to Roommate A, while the other two roommates each send $28.57. The direction matters.
Add a balance summary
In the Summary tab, put Pet owner in A1 and the pet owner's exact name in C1. Put each participant's name in A5 and the rows below it. Names must match the Transactions tab exactly.
Add these headers in row 4 and copy the formulas down.
| Column | Formula in row 5 | Meaning |
|---|---|---|
| A: Person | Type the person's name | Lists each roommate |
| B: Total charged | =IF(A5=$C$1,SUM(Bills!G:G),SUM(Bills!F:F)) |
Adds that person's bill shares |
| C: Paid to utility | =SUMIFS(Transactions!E:E,Transactions!C:C,A5,Transactions!F:F,"Utility payment") |
Counts direct utility payments |
| D: Reimbursements sent | =SUMIFS(Transactions!E:E,Transactions!C:C,A5,Transactions!F:F,"Reimbursement") |
Counts money the person sent |
| E: Reimbursements received | =SUMIFS(Transactions!E:E,Transactions!D:D,A5,Transactions!F:F,"Reimbursement") |
Counts money the person received |
| F: Net balance | =B5-C5-D5+E5 |
Shows the remaining amount |
A positive balance means the person still owes money. A negative balance means the person should receive money. A zero means the recorded transactions settle that person's share.
If you only want a quick roll-up of reimbursements received, use =QUERY(Transactions!A:G,"select D, sum(E) where F = 'Reimbursement' group by D label sum(E) 'Reimbursements received'",1). That groups payments by recipient, but it doesn't calculate the full net balance.
Run the tracker after each bill
The sheet works best when updates happen close to the bill date.
- Add the new Bill ID, date, total, receipt link, and non-pet roommate count.
- Enter the adjustment agreed for that bill. Use
0%for an equal split. - Fill the share formulas down and confirm the allocation check shows
$0.00. - Add one or more
Utility paymenttransactions for whoever paid the gas company. - Add a
Reimbursementtransaction whenever a roommate pays another roommate. - Review the Summary tab before sending a new request or changing the household agreement.
Don't record a reimbursement request as money sent. The transaction log should show actual payments, or a clearly documented amount the household has agreed to treat as settled.
Share access without exposing the formulas to accidents
Share the file with specific people rather than using a broad link by default. Give Editor access only to roommates who need to add bills or transactions.
- Protect the formula ranges, such as
Bills!F:G,Bills!I:I, and the balance formulas on Summary. UseData > Protect sheets and ranges. - Leave agreed input cells editable, including bill totals, adjustment percentages, roommate counts, receipt links, and transaction rows.
- Give View or Comment access to anyone who only needs to review the record.
- Remember that protection limits editing; it doesn't hide data from someone who can already view the sheet.
If roommates use a separate payment app, treat it as the payment channel. Copy the bill ID, amount, sender, recipient, and date into Transactions so the spreadsheet remains the record.
Avoid the formulas that overcharge the household
A common mistake is to calculate the pet owner's share with =C2*(1+D2)/(E2+1) while calculating each other person's share with =C2/(E2+1). Those amounts add up to more than the bill whenever D2 is above zero.
The adjustment has to be normalized across all share weights. The Bills formulas use E2+1+D2 in the denominator, then use the residual for the pet owner. That keeps the total fixed.
Don't overwrite old adjustment percentages when a new bill arrives. The agreement may change, but the old row should continue to show what roommates agreed to pay at that time.
The Summary shortcut also assumes the same non-pet roommates share every bill. If someone moves in, moves out, stays for only part of a billing period, or has a different room-based arrangement, create an Allocations tab with one row per person per bill. Useful columns are Bill ID, Person, Weight, Share, and Paid to utility. Calculate each share as the bill total multiplied by that person's weight, divided by the total weights for that bill.
To be honest, a spreadsheet cannot prove that a pet caused a specific increase in gas use. It can document a rule that everyone accepted. If the estimate becomes contentious, reset the adjustment to equal sharing or choose a method the group can measure.
When a spreadsheet is enough
Two roommates with occasional bills may only need a shared receipt folder and a written split rule. A spreadsheet becomes more useful when bills repeat, one person fronts the money, payments arrive in pieces, or the group needs a running balance.
Create the three tabs now, enter the next bill as a test, and make the allocation check show $0.00 before sharing the file. Then send the written split rule with the sheet link.