Easily track the rental income and expenses for up to 25 properties. This excel template is set up so that each property will have it’s own page/tab, as well as 1 standard expenses page and 1 main summary page that will bring everything together.
See a sample demonstration of how the upgrade version (remaining balance option), works in video below. The basic version is similar, except it does not have the late fee and remaining balance due columns.
INDIVIDUAL PROPERTY PAGES – Within each property page, there are 3 main sections –
1st Section – A monthly summary of income and expenses as well as a summary for total expenses by category. The totals in these summaries will automatically calculate after you enter the details in the next 2 sections.
2nd Section/Green section – This is where you can enter the rental income and any fees.
3rd Section/ Orange section – Here you can enter any expenses related to that property, the date, amount and select from up to 14 categories in a drop down list.
*You will be able to add up to 8 of your own expense categories to the expense category drop down list (directions included).
THE STANDARD EXPENSES PAGE – This extra page was set up to save you time on entering expenses that are the same amount every month. You will simply enter the monthly rate once and it will populate for all 12 months. Works great for association fees or other types of bills that are the same every month.
THE OVERALL SUMMARY – This page will summarize the totals for annual rent and expenses per category for all 25 properties. There are also hyperlinks set up so that while you’re on the summary page, you can click the links for each property to go to that property’s detail page.
This template will work 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.
Also available in different versions for 5, 10 or 15 properties here.
You will receive via email. Template is designed in MS Excel, and will include directions in PDF. An Open Office version is available upon request.
*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 can’t decide which rental template to get, this video goes over all the options: