Home & Utilities

Prorate Utility Bills for a Mid-Month Move

Calculate inclusive person-days for a move-in or move-out and understand what an occupancy-based utility split assumes.

Calculate inclusive person-days for a move-in or move-out and understand what an occupancy-based utility split assumes. Use the guide below to understand the assumptions, work through a real example, and apply the calculator to your own situation.

1

Use person-days rather than a guess at half a month

To prorate shared utilities for a mid-month move, first identify the invoice period and each person's occupancy dates. Count the overlap between those dates, then divide the amount according to each person's share of all occupied person-days. This is an allocation convention. It is not a meter reading and does not prove exactly when electricity, water, or gas was consumed.

The word half can hide several different calculations. Half of a 30-day period is 15 days; half of a 31-day period is 15.5 days. A person who moves in on the 16th of a 31-day month and stays through the 31st is present for 16 inclusive days. Counting calendar dates is clearer than deciding which side of the middle a move belongs on.

Before calculating, ask whether the whole bill should follow occupancy. Some households keep a fixed connection fee shared among the people responsible for maintaining the home and prorate only the variable amount. Others agree to use one simple occupancy rule. Write the choice down so the formula does not make that policy decision for you.

2

Define the billing window precisely

Use the service dates on the invoice. The date the bill was issued or the day payment is due usually answers a different question. A bill issued on May 6 might cover April 3 through May 2. Allocating it by the people living in the home on May 6 would ignore most of the actual service period.

UseCalcVerse counts the billing start and end dates inclusively for occupancy allocation. It clips each person's interval to that window. If the bill covers June 1 through June 30, a roommate present from May 20 through June 10 contributes ten days to this calculation, not twenty-two. Another roommate arriving July 1 contributes zero days to the June window.

Check the provider's own boundary convention when translating an invoice into dates. A reading interval described as from one midnight reading to the next may use an end boundary rather than a full final day. The household needs a consistent interpretation. Do not casually add an extra day to an interval that the provider explicitly states is exclusive at the end. Document any translation used for the calculator's inclusive fields.

3

Work through a simple move-in example

Imagine a $90 shared variable charge for April 1 through April 30. Morgan lives there all 30 days. Riley moves in April 16 and remains through April 30, contributing 15 days. Total person-days are 45. Morgan's weight is 30 divided by 45, and Riley's is 15 divided by 45. Their shares are $60 and $30.

Notice why Riley does not simply pay half of a normal $45 equal share. That shortcut would produce $22.50 for Riley and leave $67.50 for Morgan. Person-day allocation compares the two people's actual weights to each other within the chosen model. It does not assume there are two full shares and then discard the unoccupied portion of one share.

Neither calculation is inherently the only possible agreement. The important distinction is between a daily household occupancy pool and a discount from a standing equal-share arrangement. If the household intends the second rule, use agreed custom amounts rather than labeling it person-day allocation. Clear labels prevent two people from using the same word prorate while expecting different answers.

4

Handle several moves in one period

Consider a $180 bill for September 1 through September 30. Alex is present throughout, giving 30 days. Blair leaves September 10, giving ten days. Casey arrives September 11 and stays through September 30, giving twenty days. The combined weight is 60 person-days. The shares are $90, $30, and $60.

This works neatly because Blair and Casey replace one another without an overlapping day in this example. If both are recorded as present September 10, both receive that date as an occupied day. That may be correct when both had access that day, or it may reflect an entry mistake. Decide what the move dates mean before changing them simply to obtain a preferred result.

A vacancy is not another roommate. If nobody occupies a room for five days, do not add a fictional person to absorb a share. The allocation distributes the full entered bill across the actual positive person-day weights. A household that wants an owner, departing occupant, or other responsible party to bear a vacancy cost needs an explicit separate agreement and a method that represents it accurately.

5

Check leap years and date clipping

The number of days comes from the calendar, including the year. February 1 through February 29 in a leap year contains 29 inclusive days. February 15 through February 29 contains 15. In a non-leap year, February 15 through February 28 contains 14. Using a generic 30-day month loses these differences.

For a $88 bill in a leap-year February, one person present all 29 days and another present the final 15 days create 44 person-days. Their shares are $58 and $30 because each person-day carries $2 of the bill. This example is deliberately simple; most totals produce fractions of a cent and need final rounding.

A roommate whose recorded move-out precedes move-in has invalid dates, not negative occupancy. Correct the record. A roommate entirely outside the invoice window gets zero weight even if their personal interval is valid. If everyone has zero overlapping days, there is no positive allocation base. Check the billing dates and participant list instead of forcing a result by adding a random day.

6

Recognize the limits of time as a proxy

An occupied day is a convenient weight, but use can vary sharply across days. Heating during a cold week may cost more than heating during a mild week. A meter read halfway through the period could show that the first half consumed more energy. Without such evidence, the person-day method treats those days alike.

Common appliances also continue operating while individual people are away. A refrigerator, router, or shared security device may remain on. Occupancy weights do not separately estimate those loads. A person who is absent may still have agreed to support a shared service. These questions belong in the allocation agreement rather than being hidden inside a date adjustment.

If reliable readings permit a better split, divide the service period into documented subperiods or separate fixed and variable components. For each subperiod, use the participants and amounts that belong to it, then sum each person's results. Do not claim extra precision merely because a calculation has many decimal places. Precision in the answer cannot replace missing evidence about the underlying use.

7

Enter and verify the calculator result

In UseCalcVerse, select the occupancy or by-days option and enter the invoice start and end. Add each person with their actual move-in and final occupied dates. Check that a blank optional end date has the intended meaning in the current form. Before sharing, make sure every displayed interval matches the household's agreed records.

Run the calculation and compare the weights to a manual count for one full-period occupant and one partial-period occupant. This quick check can reveal a wrong month, reversed date, or mistaken year. Sum the displayed payments and compare them with the original included charge. Whole-cent distribution should leave no unallocated residue.

Save both the result and the dates used. If a departure date changes later, create a revised version with a note stating why. Keep the earlier reimbursement record instead of erasing it. A person who already paid might then owe a difference or receive a credit. The revised allocation and the payment adjustment are related, but they are not the same number.

8

Plan the handover before anyone leaves

A departing roommate can record final readings, photograph the relevant meter identification, and confirm the address for a later invoice copy. The account holder can note which future bill will close the outstanding service period. These practical steps reduce uncertainty when an invoice arrives after someone has moved away.

Avoid treating a refundable estimate as a final measured charge. If the household collects an estimated amount before the last bill arrives, label it as a provisional payment. Reconcile it when the invoice is available. For example, a provisional $40 payment against a final $33.75 share creates a $6.25 refund or credit, depending on what everyone agrees.

The cleanest closeout contains the final bill, agreed date convention, per-person weights, exact shares, payments already received, and remaining adjustments. It should explain the move without requiring people to remember a discussion from weeks earlier. Person-days make the arithmetic repeatable; the supporting records make the result understandable.

9

Check the overlap with a small calendar

Draw the invoice interval on a calendar and mark each person’s first and final included dates. Count a full-period person first, then a partial-period person. This gives you a simple reference against which to check the computer result. It also makes overlapping move dates visible without needing to inspect a formula.

Suppose the invoice is July 5 through August 3. July 5 through July 31 contributes 27 days, and August 1 through August 3 contributes three, for 30 inclusive days. Someone arriving July 20 contributes twelve July days plus three August days, or 15. With two people weighted 30 and 15, a $120 selected bill allocates $80 and $40.

If your calendar count differs from the provider’s displayed day count, stop and check the boundary convention. The document may use a reading endpoint rather than a full final service day. Do not resolve the mismatch by quietly changing a person’s dates. Record the interpretation so the next person can reproduce it.

Put your own numbers to work.

Compare your real inputs using the split utility bills calculator.

Open Calculator

Frequently Asked Questions

Is this personalized financial advice?

No. This is general educational information. Verify important decisions using actual invoices, agreements, or a qualified professional.

Where do the example numbers come from?

They are illustrative assumptions chosen to explain the arithmetic. They are not claims about typical prices, rates, or earnings.

Updated October 31, 2026. These guides were prepared with AI assistance. Examples use illustrative inputs and documented calculator formulas. Independent professional review is not claimed. Check important decisions against original bills, employment terms and qualified advice where needed.

Make Smarter Decisions Today

Explore all our free calculators and take control of your finances,
home and daily life.

Browse All Tools