How to Prorate rent with a billing date of the 1st.

Example: Move in August 20th with a rent due date of September 1th.

  1. $1000.00 / 31 = $32.26 x 12 days = $387.10
  1. Start with the number of days in the month the tenant will move in.
  2. Take the amount of monthly rent and divide by the number of days in the month the tenant will move in to get the amount owed per day. (Tenant moves in on Aug. 20th. There are 31 days in Aug.)
  3. Find the number of billable days in month by subtracting the number of days in the month plus one. For Example, if the move in day is August 5th , subtract 5 from 31 plus 1 is 27 billable days.
  4. Multiply the amount per day by the number of billable days in the month to find your prorated amount.


How to Prorate rent with a billing date OTHER THAN the 1st.

Example: Move in August 20th with a rent due date of September 15th.

  1. $1000 / 31 = $32.2581 per day for August
  2. $1000 / 30 = $33.3333 per day for September
  3. $32.2581 x 12 days = $387.0968 for August
  4. $33.3333 x 14 days = $466.6667 for September
  5. $387.0968 + $466.6667 = $853.76
  1. Start with the rent and divide by the number of days of the first month in question to get the amount per month of month 1. (Example A)
  2. Divide the rent by the number of days in the second month to get the amount per month of month 2. (Example B)
  3. Find the number of billable days in the first month by subtracting the number of days in the month plus one. For Example, if the move in day is August 20th , subtract 20 from 31 plus 1 is 12 billable days.
  4. Find the number of billable days in the second month by subtracting the number of days in the month plus one.
  5. Multiply the amount per day of month 1 times the number of billable days of month 1 to get the prorated amount of month 1. (Example C)
  6. Multiply the amount per day of month 2 times the number of billable days of month 2 to get the prorated amount of month 1. (Example D)
  7. Add the prorated amount of month 1 to the prorated amount of month 2 to get the total prorated amount. (Example E)

Elements to keep in mind when prorating rent:

  • Leap year
  • Day on month billed (Rent due date)
  • If the rent spans months.
  • Number of days in the first month
  • Number of days in the second month
  • Amount per day in the first month
  • Amount per day in the second month
  • Number of billable days in first month
  • Number of billable days in second month
  • Different amount per day depending on month