Utility Bill Prorate Calculator
Calculate the prorated share of a utility bill for a partial billing period.
Prorated amount
$60
What is prorating a utility bill?
A prorated utility bill is the portion of a full billing period’s charges that corresponds to the days a tenant, subscriber, or service was active. When someone moves in or out partway through a billing cycle, charging the full period’s bill is inequitable; proration allocates only the proportional cost.
The standard method is a simple day fraction: the full bill multiplied by occupied days divided by total days in the period. This assumes daily cost is uniform across the period, which is a reasonable approximation for most residential utility bills.
Proration is distinct from splitting. Splitting divides a bill among multiple people who all shared the space for the full period; proration adjusts for a person who was present for only part of the period. The two can be combined: prorate first to find the partial-period amount, then split that amount if the space was shared.
How to prorate a utility bill
Formula
prorated amount = total bill x (occupied days / total days in period)
How the formula works
Daily rate = total bill / total days in period. Prorated amount = total bill x (occupied days / total days). Period percent = (occupied days / total days) x 100.
The day-fraction method produces the same result either way: direct fraction or daily rate times days. Both paths are shown in the example.
Counting occupied days
The key question is whether to count both endpoints. Inclusive counting counts the move-in day and the last day of occupancy; exclusive counting omits one end. The most common residential convention is inclusive: a tenant who moves in on the 1st and vacates on the 15th of a 30-day month occupied 15 days. Some lease agreements specify exclusive counting (14 days in this case). Use whichever method your lease or utility agreement specifies. Enter that number in the occupied days field.
Total days in the period
Use the actual calendar days the utility covers, not a nominal month. A utility bill running from January 15 to February 14 covers 30 days (counting January 15 through February 13, or 14 to 14 depending on convention). The exact day count is usually printed on the bill. For a calendar month, use 28 for February (29 in a leap year), 30 for April/June/September/November, and 31 for the remaining months.
Combining with a split
To prorate and then split: prorate the full bill to find the occupying tenant’s portion, then apply the Bill Split Calculator to that portion if the space was shared during the occupied period.
Rounding
Results are shown to four decimal places for the daily rate (useful when billing for many days) and two decimal places for the final prorated amount.
Example
- 1Daily rate$120 / 30 = $4.00 per day
- 2Percent of period15 / 30 = 50.0%
- 3Prorated amount$120 x (15 / 30) = $60.00
FAQ
Should I count the move-in and move-out day?
It depends on the convention in your lease or utility agreement. One common approach is inclusive counting: if a tenant occupies a unit from the 1st through the 15th of a 30-day month, they used 15 days. Another approach excludes the last day (14 days). Agree on the counting method with the other party before calculating; this calculator uses whatever number you enter for occupied days.
How many days are in the billing period?
Use the actual calendar days in the billing period as shown on the bill. Billing periods are not always exactly one month: some utilities bill every 28 days, some use calendar months (28 to 31 days), and some span partial months. The exact day count is usually printed on the bill.
What is the difference between prorating and splitting?
Prorating adjusts for time: if someone occupied a space for part of the billing period, they pay only for the days they were there. Splitting divides a single bill among multiple people who shared a space for the full period. Use the Bill Split Calculator for the splitting case.
Is a prorated amount legally enforceable?
Proration methods can be specified in lease agreements, utility contracts, or local law. This calculator uses the simple day-fraction method: total bill times (occupied days / period days). Confirm that this method is consistent with your agreement or local rules before issuing or paying a prorated bill.
Sources
1. Tenant Rights: Security Deposits and Proration
U.S. Department of Housing and Urban Development (HUD)
HUD provides tenant rights guidance including proration conventions; referenced for context on how partial-period charges are handled in residential tenancy.
https://www.hud.gov/topics/rental_assistance/tenantrights2. Massachusetts Tenant Rights and Responsibilities
Massachusetts Attorney General's Office
Discusses utility billing responsibilities and proration practices in shared housing.
https://www.mass.gov/info-details/tenant-rights-and-utilities