Track Rent and Late Fees, Landlord Expenses Spreadsheet, Rental Property Record Keeping Template


Personalize with Name or Company Name


Track your rental income, late fees, and expenses

Easily track your rental income, late fees and balances due, along with all your rental property expenses, in 1 excel template that will keep you organized.

This excel template is set up to make it easy for you to track your rental income, late fees, and all rental property related expenses.    Simply enter the monthly rent that is due, and when rent isn’t paid or is not paid in full, the remaining balance column will automatically calculate the balance due.  You can also add in the late fee charges that get added into the balance due column.

Individual Property Page

The template starts with a 5 property version, and goes up to an 80 property version upgrade. Each property has it’s own page, along with a summary page that will show the annual totals per property.Works with both long term and short term rentals. All cells that contain formulas are protected so that you don’t accidentally write over them. Once you enter your details in the specified places, the cells with formulas will automatically sum up your data. All pages are set to print, however you can also change the print settings.

Main Summary Page

The main summary page will show the annual totals for each property for the annual rental income, and expenses per category. You won’t actually enter anything in the summary page. Underneath each property name, you can click on the link and it will take you to that properties detail page (or you can click on the tabs at the bottom of the worksheet).

The basic versions without the updates for remaining balance are available here for 5, 10,15, 25 or 30 properties.

You will receive via email, an Excel spreadsheet Template, along with directions in PDF.

*You do not have permission to distribute or re-sell the template, so please don’t do it.
*All templates come personalized with your name or company name.



If you aren’t sure which rental template to get, this video covers all the options:

Want to try a free rental template?

Download a rental property improvement tracker: 

Additional information

Number of Properties

5 property version, 10 property version, 15 property version, 25 property version, 30 property version, 40 property version, 50 property version, 80 property version, 110 property version

Customer Reviews

Based on 4 reviews
Kathy Cuevas
Great time saver

I have been using my own spreadsheet for years to track my rental and business expenses. It was good, but this one is GREAT. It will also be MUCH easier for my CPA when it comes to doing my taxes next year. It's not that hard to learn, and when I had an issue with a formula, the response was the same day! Thanks for the great template and customer service. I highly recommend this spreadsheet template.

Richard Torres
Best investment!!

I would highly recommend the rental property template!!

Very easy to use

just one suggestion if you could add the feature of total profit from all the rental that would be wonderful.

Simcha Goldberg
Super helpful!

I love this spreadsheet. It really helped me organize all my accounting needs