Investor · Seattle, WA · Member since 2017 · 15 posts · 9 votes
Question for all you experts with multiple real estate properties!!!
I'm in the process of buying my third property, and am starting to think about how I can create a holistic financial picture of my entire portfolio (rather than manage each property individually). Does anyone have any tips on how you've done this successfully in the past? I'm talking about things like cash inflows/outflows, tenant & lease terms, home values, etc.
If this helps, it basically stems from the question I've been mulling over lately, 'if one of my property becomes vacant, how will it impact my other two properties, and how much of the cash flow from the other two properties can I use to offset the costs of the third?' So really focused on financial management across my portfolio here.
@Larry Turowski Check out Airtable.com for tracking. It's an online database software that's reminiscent of Excel but you can store attachments and create relationships between data. Really easy to work with.
@Dylan Hoffman I use Quickbooks for the financials. There is a learning curve, for sure but some sort of financial software is a must. I've heard of investors using Excel with 100 properties! That seems chaotic to me but I haven't tried.
For lease details I use excel. I have all the pertinent information in there.
What I really need to work on is some sort of ticketing system for repairs and small jobs related to the properties.
I don't know that you need to have one thing that does all this for you. The best software tends to do only one or a few things, but does them well. The greater the feature set, the less it becomes suited for any one of the features.
I have a spreadsheet like that for my portfolio. It has the LTV of each property (along with the total LTV of the portfolio). In addition it breaks down what the PITI is per property. What the maintenance expenses are per property. (I self manage). Also lists the mechanicals on each property and the year they were installed. Finally, I have the rents on each property and how much rent would need to drop before I would only be able to cover the mortgage. It's a nice risk management tool to have.
I just started with Quickbooks online and I must say that I LOVE it.
It wasn't as much of a learning curve as I expected, and within a few hours I had a full P&L.
Be sure to do a bit of research first on how to set multiple properties. There are a few tricks that definitely help.
@Larry Turowski Check out Airtable.com for tracking. It's an online database software that's reminiscent of Excel but you can store attachments and create relationships between data. Really easy to work with.
Rentigo is one of the newer online tools/apps that supports an unlimited number of properties (free). Worth a look if you want a "snapshot" view to help you track rent cycles and vacancies across multiple properties. While not cash flow related its also useful for streamlining tenant communications around maintenance issues, rent collection, etc.
Hey Peter , would you be ok with sharing a screenshot of your excel sheet please (without numbers ),
Or the Excel file that you use to do this ? I got my first offer accepted for an owner occupied home (will rent it out in two years and buy another property). I am also sending another offer for a rental property on Monday, and I’m working on figuring out a system that works best. Thank you.