Prorated Utility Split Calculator

How prorating a utility bill works

Prorating means charging a share of a bill that matches the share of the billing period you were there. The formula has three parts: the bill total, the number of days in the billing cycle, and the number of days you occupied the place. Divide the bill by the cycle days to get a daily rate, then multiply by your days.

On a $180 electric bill for a 30 day cycle the daily rate is $6.00. Live there 12 days and your share is $72.00, which is 40% of the bill. The person who had the place for the other 18 days carries $108.00. The two shares add back to $180, which is the check that the split is right.

That is the whole method, and it works on electric, gas, water, sewer, trash and internet. It does not work on a deposit, a connection fee or a late fee, because those are not charges for consumption over time. Keep those separate and bill them in full to whoever caused them.

Two details trip people up. The first is the denominator: it is the length of the billing cycle printed on the statement, which is usually 28 to 31 days but can be 33 or 35 if the meter was read late. The second is occupancy: the day you move in counts, and the day you move out usually does not, so a move-in on the 19th of a 30 day cycle that started on the 1st gives you 12 days, not 13.

Worked example: moving in on the 19th

The bill covers the 1st through the 30th and totals $180. You get the keys on the 19th, so you are responsible for the 19th through the 30th, which is 12 days. The daily rate is $6.00, your share is $72.00, and the previous occupant owes $108.00. If the landlord also bills a $12 account setup fee, that goes on your side in full, and your total becomes $84.00.

Now change one input. The same $180 bill in a 31 day cycle with the same 12 days gives $69.68, because the daily rate drops to $5.81. That $2.32 difference is the reason to use the cycle length from the statement instead of assuming 30 days. In February a 28 day cycle pushes the daily rate to $6.43 and the 12 day share to $77.14.

Move-out works the same way in reverse. Leave on the 10th of a 30 day cycle that started on the 1st and you owe 9 days, or $54.00 on a $180 bill. The day you hand back the keys is normally the landlord's day, not yours, but a written agreement can set it either way.

Round to the cent at the end, not in the middle. Carrying $6.00 exactly is fine, but a $187.43 bill over 30 days gives $6.2477 a day, and rounding that to $6.25 before multiplying by 12 days produces $75.00 instead of the correct $74.97. Small, but it is the kind of three cent gap that makes a roommate distrust the whole spreadsheet.

The billing cycle is the base, not the calendar month

Utility meters are read on a route, so a bill rarely covers the 1st to the 30th. A cycle can run from the 8th to the 7th, from the 14th to the 13th, or from the 22nd to the 21st. When you prorate against the calendar month instead of the cycle, you are dividing a bill by days it does not cover, and the error grows with the size of the bill.

Take a $300 electric bill for a cycle that runs June 8 to July 7, which is 30 days. If you divide by 30 you get $10.00 a day, which happens to be right. If the same bill covered June 8 to July 9, a 32 day cycle, dividing by 30 overstates the daily rate by 6.7% and overcharges a 12 day occupant by $24.00. The statement always prints the read dates and the number of days, usually in a line that says "billing period" or "days in cycle".

Season matters too. A summer electric bill in Phoenix can be three times a winter bill, so prorating a July cycle with a January daily rate is worse than useless. Always prorate the actual bill for the actual cycle.

Every figure in that table is a share of the same $180 bill. The widest gap, between a 28 day February and a 31 day month at 20 days of occupancy, is $12.44. That is real money on a single bill, and it repeats on every utility in the house.

Which utilities prorate, and which do not

Consumption charges prorate because they measure use over time. Flat charges do not, because they buy access rather than volume. The distinction matters more than the formula, since a $45 trash bill and a $45 account fee look the same on a statement.

Internet is the one people argue about. A $70 plan billed monthly is $2.33 a day, so 12 days is $28.00. Providers that bill a month in advance will often credit the unused days instead of prorating the first bill, which amounts to the same thing at the end of the lease.

The national average residential electricity price has been running near 17 cents a kWh in the most recent EIA monthly electricity report, which is why a 482 kWh month lands near $82 before fixed charges.

Water is the one that hides a trap. Many cities bill water every two months, and the sewer charge is based on winter water use rather than the current bill. Prorating a two month water bill by the days in one month halves the bill and doubles the argument. Read the period on the statement before dividing anything. For scale, the EPA WaterSense figures put an average US family above 300 gallons a day indoors, so a two month bill is a large number and a small mistake in the denominator is expensive.

Splitting a prorated bill across roommates

Prorate first, then split. Take the bill, divide by the cycle days, multiply by the days the household occupied the unit, then divide by the number of people on the lease. A $240 electric bill over 30 days, with the household in place for 15 days and four people sharing, gives $120.00 for the household and $30.00 per person.

That order matters when one person arrives late. If three roommates lived there for the whole cycle and a fourth arrives on day 16, the newcomer does not get a quarter of the whole bill. The right move is to take one person's full share, then prorate that share. A $240 bill split four ways is $60.00 each; the newcomer owes $60.00 times 15 over 30, which is $30.00, and the other three each pick up $10.00 of the difference.

Run the whole house at once rather than one utility at a time, and round each person to the cent, then put the leftover cents on the person who set up the account. On a $575 month across five utilities the per person total is $71.88, and four people at $71.88 leaves a two cent gap that has to land somewhere.

Income matters less than people expect. A couple sharing a two bedroom usually splits 50/50, while a three bedroom with rooms of different sizes might go 40/30/30. Whatever the split, apply the same ratio to the prorated total, not to the raw bill.

Why separate meters should never be merged

If the unit has its own meter, the utility bills you directly for what you used, and there is nothing to prorate. The mistake is to add a metered bill into a shared house pot and divide it by people, because the person who runs a space heater in a converted garage ends up subsidized by everyone else.

The same logic applies inside a shared house with sub-metered rooms. A $95 bill for one room's electric and a $180 bill for the common meter are two different pools. Prorate each against its own cycle, split the common pool by the agreed ratio, and leave the sub-metered pool with the person on that meter. Mixing them means the low user pays for the high user, and the argument repeats every month.

There is a practical reason too. Utilities can only put an account in one name, so the person on the account carries the credit risk. That person should collect the prorated shares before the due date, not after. A simple rule, money due three days before the utility due date, avoids the late fee entirely.

Where a landlord bills a single meter for several units and divides it by square footage, the split is not a proration at all. It is an allocation, and in many states the lease has to say so and show the method. Ask for the calculation in writing if the numbers move month to month.

Fixed charges, deposits and fees that do not prorate

A fixed monthly charge buys the connection, not the kilowatt hours. A $12 customer charge on an electric bill applies whether you used 10 kWh or 1,000, so a 12 day occupant who pays 40% of it is getting a discount the utility never gave. Bill the fixed charge in full to the account holder, or split it evenly among the people who were there when it was incurred.

Deposits are not charges at all. A $150 deposit is your money held against nonpayment, and it comes back with interest in some states. It should never appear in a prorated split, and it should never be counted as part of a move-in cost that gets divided.

Late fees and reconnect fees belong to the person who caused them. A $35 reconnect fee after a shutoff notice is not a household expense, and prorating it across four roommates teaches everyone that missing the due date is free.

One more: taxes and riders. Some states apply a percentage tax to the whole bill, and a few add a fixed rider per meter. If you prorate the usage line and then add tax on the prorated amount, you get the same answer as prorating the taxed total, to the cent, as long as the tax rate is flat. When a fixed rider sits on the bill, pull it out before you divide. The Energy Department's Energy Saver program lists which charges on a bill are for usage and which are flat, which is the split you need before any proration.

What to write down when someone moves in or out

Put five numbers in the message: the bill total, the cycle start and end dates, the days in the cycle, the days the person was there, and the resulting share. That is enough for anyone to check the math in ten seconds, and it ends the conversation before it starts.

Add a photo of the meter on move-in day if the unit has its own meter. A reading of 41,208 kWh on the 19th and 41,690 on the 30th is 482 kWh, and at $0.17 a kWh that is $81.94, which is a better number than any proration. Prorating by days assumes even use, and a household that runs the dryer on weekends does not use power evenly.

For a lease, write the method rather than the number: "utility charges for the partial month are prorated by the number of days occupied over the number of days in the billing cycle, with fixed charges billed in full." That sentence survives a rate change, and it is the sentence a small claims judge will understand.

Keep the arithmetic simple enough to redo by hand. A $180 bill, 30 day cycle, 12 days, $72.00. If the numbers need a spreadsheet with six tabs, the method is too complicated for a house of four people.

This is a planning estimate, not legal or financial advice. Lease terms and state landlord rules control how a partial month is billed, so check the agreement before you rely on a prorated figure.