What happens to the shared gas bill when a roommate moves out two weeks before the cycle closes?
The fairest solution is prorating the bill by active days. Utility companies bill for natural gas in arrears. That means your statement for January heating usually arrives midway through February, long after a departing roommate has returned their keys and settled into a new place.
That delay creates tension. The person who left does not want to pay for furnace heat they never felt. The roommates staying behind do not want to subsidize someone else's hot water. Setting up a clear proration method settles the account before anyone feels shortchanged.
Why Natural Gas Bills Need Special Proration
Thing is, gas bills do not work like flat internet subscriptions. A standard utility invoice combines fixed connection charges with variable fuel rates.
Reviewing the natural gas bill line items shows that your utility charges a flat monthly fee just to keep the meter connected. On top of that base fee, you pay for actual fuel consumed, measured in hundred cubic feet (CCF) or therms. In winter, central furnaces burn substantial amounts of gas. In summer, usage drops mostly to water heaters and cooking ranges.
Splitting the bill fairly means deciding how to treat the base fee versus the fuel itself.
| Bill component | What it covers | Fair split method |
|---|---|---|
| Customer charge | Fixed monthly pipeline connection fee | Prorate through official lease end date |
| Gas delivery and supply | Billed therms of heating and hot water | Prorate by days physically present in home |
| Taxes and municipal fees | Local energy surcharges | Split proportionally across each person's total |
The Person-Days Method
Most households divide utility statements equally, but an equal split fails when move-out dates do not align with billing periods. The person-days method solves this. It weights each person's financial share by the exact number of days they occupied the home during that specific invoice window.
Here is the five-step formula:
- Identify the billing start and end dates on the utility statement.
- Count how many days each roommate lived in the apartment during that window.
- Sum everyone's days together to find the total household person-days.
- Divide the total bill by total person-days to calculate the daily person rate.
- Multiply that daily rate by each individual's day count.
Here is an example with round numbers.
Imagine a monthly gas bill of $140 covering a 30-day cycle. Alex and Jordan stayed the full 30 days. Taylor moved out on day 10.
Alex logged 30 person-days, Jordan logged 30, and Taylor logged 10. That creates 70 total person-days for the household. Dividing $140 by 70 gives an exact rate of $2.00 per person per day. Taylor owes $20.00 for their 10 days. Alex and Jordan each owe $60.00 for their 30 days.
The math balances to the penny. Nobody pays for days they were not there.
Building a Spreadsheet Tracker
Spreadsheets make date-based splits automatic. Setting this up in Google Sheets or Excel takes five minutes, although people often overcomplicate their tabs by trying to calculate burner hours instead of just logging dates.
Keep your sheet focused. You only need five columns: Billing Cycle Start, Billing Cycle End, Statement Total, Days Present, and Share Due.
If you handle trailing expenses across several months, use the SUMIFS function to isolate costs between specific move dates. The formula syntax works like this:
=SUMIFS(sum_range, criteria_range1, ">="&start_date, criteria_range2, "<="&end_date)
According to Microsoft Excel support, SUMIFS lets you filter numbers across multiple conditional ranges without manual sorting. It keeps the ledger clean.
Physical Departure vs. Legal Lease Obligations
Turns out, physical move-out dates and lease agreements do not always align. A roommate might vacate their bedroom on the 12th to start a new job, even though their name remains on the lease through the 31st.
Who pays for the remaining nineteen days of gas?
Standard house agreements split the difference. The departing tenant stays responsible for their fraction of the fixed customer charge until their lease actually expires. They signed a contract for the space. However, remaining roommates cover the variable heating therms after the physical move-out date. They are the ones running the heat and taking hot showers.
Setting this boundary early prevents bitter arguments when the final bill lands.
Move-Out Day Utility Checklist
Do not wait for the gas bill to arrive before taking basic documentation steps. Complete these four items on move-out day:
- [ ] Read the meter: Snap a clear phone photo of the physical gas meter dials or digital display on departure day.
- [ ] Adjust the registers: Close the heating vents in the empty room so furnace heat does not circulate into unoccupied space.
- [ ] Verify contact details: Confirm an active phone number, personal email, and preferred reimbursement app.
- [ ] Establish deposit rules: Agree in writing whether utility balances will come out of the security deposit or via a direct transfer request.
A quick photo of the meter proves the baseline reading if a massive heating spike happens after someone leaves.
How to Request the Final Reimbursement
To be honest, tracking down a former roommate three weeks after they left is awkward. People move on with their lives. They forget about the old apartment.
The best approach is complete transparency. Send a short note with the original utility bill attached alongside your math:
"Hey Taylor, the final gas bill for our last cycle just arrived. Total was $140 across 30 days. Based on our 70 person-days formula, your 10 days come out to $20.00. I attached the utility statement and the spreadsheet math. Let me know if that looks right to you!"
Attach the utility invoice. Show the breakdown clearly. When former roommates can inspect the raw statement and the exact formula, reimbursements usually get settled without debate.