Bill split calculator for housemates

Someone moved in or out partway through? Split the bill by the days each person was living there, so nobody overpays.

HousemateDays living thereWeighting (e.g. big room 1.2)

Fair ways to split shared bills

Standing charges are part of the bill whatever you use, so splitting the total by days is fairer than trying to split by kWh. To check whether a bill matches your readings, use the meter reading calculator.

Tips for house shares

Worked example

A £270 quarterly bill covers 90 days. Alex was there for all 90, Sam for 90, and Jo moved in on day 46, so was there for 45 days. That's 225 person-days in total, so each day costs £1.20. Alex and Sam pay £108 each, and Jo pays £54. That's fairer than splitting it three ways at £90 each.

£7UK Bills & Budget Planner

See every bill as one monthly number, and stop direct-debit surprises.

A Google Sheets and Excel planner that turns every bill into a monthly cost, and covers council tax, energy readings, a monthly budget and a savings goal.

Get it for £7 →
Instant download · Google Sheets & Excel · Secure checkout by Payhip
…or get all 9 paid templates for £15 in the UK Bundle (worth £48).
We make and sell this template (Tidy Life Templates).
£15UK Money & Life Templates Bundle (9 templates)

All 9 paid templates (worth £48) for £15: about £1.67 each.

Every paid Tidy Life template in one download: budget, bills, debt, Self-Assessment, Christmas, January reset, Vinted, house move, meal plan and job hunt.

Get it for £15 →
Instant download · Sheets, Excel & Notion · Secure checkout by Payhip
Launch offer: code FIRST10 takes 10% off at checkout (first 10 orders only).
We make and sell this template (Tidy Life Templates).

FAQs

How do you split an energy bill when someone moves out?

Take a meter reading on the day they leave, then split the bill by the number of days each person lived there in the billing period. Standing charges are daily, so splitting by days is fair.

Should the person with the biggest room pay more?

Only if everyone agrees. Some house shares use a small weighting, like 1.2 for a large room. Set it in the weighting column above.

How do you split bills fairly with a partner who earns more?

Some couples split shared bills in proportion to income instead of 50/50. For example, if one of you earns 60% of the household income, they pay 60% of the bills. Agree it together and review it when pay changes.

Related calculators & guides

Energy price cap Jan 2027 · Meter reading → £ · Council tax bands · 50/30/20 budget · Rent affordability · Take-home pay · Moving house checklist · Council tax discount

Handy for this
Affiliate links: we may earn a small commission at no cost to you.