{"id":117,"date":"2026-11-22T08:56:00","date_gmt":"2026-11-22T15:56:00","guid":{"rendered":"https:\/\/www.calculationassistant.com\/blog\/?p=117"},"modified":"2026-11-15T01:33:31","modified_gmt":"2026-11-15T08:33:31","slug":"split-utility-bill-by-room-occupancy","status":"publish","type":"post","link":"https:\/\/www.calculationassistant.com\/blog\/split-utility-bill-by-room-occupancy\/","title":{"rendered":"Splitting a Utility Bill When Rooms Sit Empty"},"content":{"rendered":"<p><strong>TL;DR \/ Summary:<\/strong> A flat-share utility bill is not a headcount problem, it is a time problem. Convert each person&#8217;s stay into occupancy-days, split the metered portion by those days, and give fixed charges their own written rule. The result is a number a flatmate can audit instead of a number they have to trust.<\/p>\n<h2>Why an even headcount misses the real usage<\/h2>\n<p>Picture a four-bedroom flat where one room sat empty for the first eleven days and a new tenant arrived on the nineteenth. If you divide the electricity bill by the four names on the lease, the newcomer pays for showers taken before they owned a key, and the person who moved out on the eighth pays for a week of heating they never used.<\/p>\n<p>The error is not cosmetic. In a winter month, two mid-month moves can swing a single share by twenty to forty dollars. Multiply that across gas, water, and broadband and the argument is really about arithmetic nobody wrote down.<\/p>\n<p>An occupancy-day split needs only dates, which are already on the lease.<\/p>\n<h2>Pick the counting unit before you pick the formula<\/h2>\n<p>Take the billing period from the invoice, not from the calendar month. Utility cycles rarely start on the first, and a period that runs from the 4th to the 3rd will quietly distort every calendar-month assumption you make.<\/p>\n<p>Count nights rather than days. A person who arrives at 23:00 on Tuesday has not used Tuesday&#8217;s electricity, and counting both arrival and departure days double-charges every mover. Nights also line up with how water and heating are actually consumed.<\/p>\n<h3>Occupancy-days, not calendar days<\/h3>\n<p>Write the count as a fraction of the period, then convert to a common integer so you can compare people. If the period has thirty nights and someone stayed nine, their weight is nine. Everyone else&#8217;s weight is their own night count. Add the weights into a single total and that total becomes your divisor.<\/p>\n<ul>\n<li><strong>Full-month resident:<\/strong> every night in the period<\/li>\n<li><strong>Mid-month arrival:<\/strong> nights from the move-in date onward<\/li>\n<li><strong>Mid-month departure:<\/strong> nights up to and including the last night<\/li>\n<\/ul>\n<h2>A worked month with two empty rooms<\/h2>\n<p>Say the period has thirty nights. Alex and Sam were there the whole time, so each has a weight of thirty. Casey moved in on the twenty-second, leaving nine nights. Dev moved out on the tenth, leaving ten nights. Total weight is seventy-nine.<\/p>\n<p>The electricity invoice is 151.40. Divide by seventy-nine and the cost per occupancy-night is about 1.9165. Alex owes 57.49, Sam owes 57.49, Casey owes 17.25, and Dev owes 19.17. Add those back and you land within a cent of the invoice.<\/p>\n<p>That last cent matters more than it looks. Four rounded shares rarely sum to the original bill, and a sheet that does not balance invites a second round of messages. Put the remainder on the largest share, or state plainly that the leftover cent goes to the person who paid.<\/p>\n<h2>Fixed charges need a rule of their own<\/h2>\n<p>Broadband, the meter standing charge, bin collection, and a TV licence do not shrink when a room empties. Splitting them by occupancy-night gives a part-month tenant a discount on a service that was running at full cost, which is generous but not obviously fair to the people who carried it.<\/p>\n<p>Two rules survive contact with real flats. Rule one: fixed charges split equally across rooms for the full period. Rule two: fixed charges split equally across people who were resident for at least half the period. Pick one, write it in the pinned message, and stop renegotiating it every month.<\/p>\n<p><strong>When the meter is shared with a shop downstairs.<\/strong> If the landlord&#8217;s meter also feeds a commercial unit, the invoice is not the flat&#8217;s bill yet. Subtract the shop&#8217;s agreed portion first, or get a submeter reading, and only then run the occupancy split on what remains. Splitting a mixed bill by nights produces a confidently wrong number.<\/p>\n<h2>Handling the person who paid the whole bill<\/h2>\n<p>Most flats have one person whose name is on the account. That person is not owed the full bill by each flatmate; they are owed everyone else&#8217;s share. Build the sheet with a column for who paid and a column for what each person owes, then settle only the difference.<\/p>\n<p>If the payer is also a resident, their own share cancels out. Showing that cancellation on the sheet prevents the classic double-charge where the payer collects the full amount from three people and accidentally pockets their own portion twice.<\/p>\n<p>For the division itself, a general calculator such as <a href=\"https:\/\/www.calculationassistant.com\/\">Calculation Assistant<\/a> is enough; the hard part is agreeing the rule, not pressing the buttons.<\/p>\n<h2>When a flatmate disputes the days<\/h2>\n<p>Do not relitigate the whole month. Point at the single line in question and ask for the date that is wrong. If someone says they left two days earlier than recorded, adjust their weight and recompute everyone&#8217;s share rather than deducting a guessed amount from one person.<\/p>\n<p>One awkward case deserves a sentence in advance: a person who was away but left a space heater running. Under an occupancy-day rule their variable share still counts, because the consumption happened in their room. If the flat wants to treat that differently, it needs a separate rule about unattended appliances, not a retroactive edit to the day count.<\/p>\n<blockquote><p>Argue about the rule once, in daylight, not about the total at midnight.<\/p><\/blockquote>\n<h2>Agreeing on the number before the next bill arrives<\/h2>\n<p>A reusable sheet needs seven columns: name, room, first night, last night, occupancy-nights, share of variable charges, share of fixed charges. Add a paid-by column and a settlement column, and the whole thing fits on one screen.<\/p>\n<p>Settle within a week of the invoice. The longer the gap, the more the numbers feel like an accusation instead of a record. Keep the last three sheets in a shared folder; when a new tenant asks how the split works, you can show them a real month rather than explain a theory.<\/p>\n<p>The point of all this is not precision for its own sake. It is that nobody has to win an argument to be treated fairly when a lease starts or ends in the middle of a billing cycle.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TL;DR \/ Summary: A flat-share utility bill is not a headcount problem, it is a time problem. Convert each person&#8217;s [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":45,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[3],"tags":[],"class_list":["post-117","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas-methods"],"_links":{"self":[{"href":"https:\/\/www.calculationassistant.com\/blog\/wp-json\/wp\/v2\/posts\/117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.calculationassistant.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.calculationassistant.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.calculationassistant.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.calculationassistant.com\/blog\/wp-json\/wp\/v2\/comments?post=117"}],"version-history":[{"count":1,"href":"https:\/\/www.calculationassistant.com\/blog\/wp-json\/wp\/v2\/posts\/117\/revisions"}],"predecessor-version":[{"id":118,"href":"https:\/\/www.calculationassistant.com\/blog\/wp-json\/wp\/v2\/posts\/117\/revisions\/118"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.calculationassistant.com\/blog\/wp-json\/wp\/v2\/media\/45"}],"wp:attachment":[{"href":"https:\/\/www.calculationassistant.com\/blog\/wp-json\/wp\/v2\/media?parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.calculationassistant.com\/blog\/wp-json\/wp\/v2\/categories?post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.calculationassistant.com\/blog\/wp-json\/wp\/v2\/tags?post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}