Description
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.
Review
If you aren’t sure which rental template to get, this video covers all the options:
See more rental property templates here.
Want to try a free rental template?
Download a rental property improvement tracker:
