Good Columns
Shop all

Free tools / Prorated Rent Calculator

Prorated Rent Calculator

Enter the monthly rent and a move-in or move-out date to get the daily rate, the days charged and the prorated amount. Pick the method your lease uses and the working is shown below the result.

The rent and the date

The day itself is charged in both cases.

Use the method your lease or local rules state.

Example figures are filled in. Replace them with yours.

Prorated rent

Days charged

Daily rate

The numbers
Full monthly rent
Month
Daily rate
Days charged
Prorated rent

The working

    Schedule E Rent Ledger
    US$9.99 launch price. Rent and expenses by property, in Schedule E order.

    Buy on Gumroad, US$9.99

    How it works

    Actual days in the month

    Daily rate = monthly rent / days in that month. A tenant moving in on the 17th of a 31-day month is charged 31 - 17 + 1 = 15 days.

    365-day year

    Daily rate = monthly rent x 12 / 365, so every month uses the same daily rate. Days charged are the actual calendar days.

    30-day month

    Daily rate = monthly rent / 30, and every month counts as 30 days (banker's month). A date on the 31st counts as the 30th.

    Move-in and move-out

    Move-in: days charged run from the move-in day to the end of the month, counting both. Move-out: days run from the 1st to the move-out day. The prorated amount is the daily rate times days charged, rounded to the cent.

    Log every rent payment in one place

    The Rent Payment Tracker is free and flags late, short and overdue rent for up to 10 units. The Schedule E Rent Ledger records rent and expenses by property through the year.

    Questions

    How do you calculate prorated rent?

    Divide the monthly rent by the number of days in the month to get a daily rate, then multiply by the days the tenant has the unit. For US$1,500 rent and a move-in on 17 October, the daily rate is 1,500 / 31 and 15 days are charged, which comes to US$725.81.

    Do you charge for the move-in day?

    This calculator counts the move-in day and the move-out day as charged days. If your lease treats the day differently, adjust the date by one day.

    Which proration method should I use?

    Use the one your lease or local rules state. Actual days in the month is the most common. A 365-day year gives the same daily rate all year, and a 30-day month is used where leases or accounting practice treat every month as 30 days.

    Why do the methods give different amounts?

    Because the daily rate differs. Dividing by 31 gives a lower daily rate than dividing by 30, and rent x 12 / 365 sits in between for most months. The difference is usually a few dollars.

    Embed this calculator

    Copy this code into your own page or blog post. It is free to use, and the credit link below the calculator stays in.

    Preview of the credit line: Calculator by Good Columns

    One email when a new file is out

    The free Rent Payment Tracker is ready to download now. Leave your email and we send one message when a new file or free tool is out, and nothing else unless you ask.

    The small print

    This calculator does arithmetic on the figures you enter. It is not tax, legal, accounting, investment or financial advice, and it is not endorsed by the IRS or any government body. Proration rules depend on your lease and local law. You are responsible for the figures you enter.

    Good Columns, Melbourne, Australia. hello@goodcolumns.com

    Nothing you type is sent anywhere. The calculation runs in your browser, and the page sets no cookies and stores nothing.