Rental Investment Tracker/Spreadsheet

[Kyle Thompson]

Greetings everyone! 

My brother and I are rapidly advancing towards our first rental unit. After that goes well (which I know it will thanks to all the insight gained from you all) we intend to grow our portfolio to 50+ doors of single family and multi family units. 

My question is how do you all keep track of your rental units and any information about them and how they're performing? Specifically when you have more than 1 unit. Is there a type of software I can download and/or possibly an excel spreadsheet. I'm looking to be proactive and get a system in place to track each unit's performance.

Any information would be GREATLY appreciated. Thanks in advance!

[John Underwood]

@Kyle Thompson

I created an Excel spreadsheet. I have a separate tab for each property. I customize it for my needs.

I have tenant info, rent amount, dates rent is paid, late fees, garbage pickup day, ac filter size, when the lease expires etc.

I have formulas that keep running tab of income and expense. I have one tab that grabs pertinent info from each property tab to show data I am interested in on this one summary tab.

Excel is very powerful and it makes it easy to do my taxes at the end of the year.