Managing Multiple Properties

Managing Multiple Properties

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.

Tips / tricks / online tools & platforms / anything else are welcome :)

Thanks!

-Dylan

0Reply
39 views

Most Popular Reply

Investor · Athens, GA · Member since 2015 · 205 posts · 66 votes
9y

@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.  

This is how I track my work orders.

See this reply in the discussion

8 Replies

Jump to latestLatest
  • Flipper/Rehabber · Rochester, NY · Member since 2014 · 1k+ posts · 1k+ votes
    9y

    @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.

  • Peter TverdovBusiness Member
    Developer · New Brunswick, NJ · Member since 2015 · 1k+ posts · 2k+ votes
    9y

    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.

  • Investor · Philadelphia, PA · Member since 2016 · 2k+ posts · 1k+ votes
    9y
    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.
  • Investor · Athens, GA · Member since 2015 · 205 posts · 66 votes
    9y

    @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.  

    This is how I track my work orders.

  • Flipper/Rehabber · Rochester, NY · Member since 2014 · 1k+ posts · 1k+ votes
    9y

    @Brad E. Just took a very quick look.  That is an awesome tip.  Thanks!

  • New York City, NY · Member since 2017 · 5 posts · 0 votes
    9y

    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. 

  • San Ramon, CA · Member since 2017 · 78 posts · 97 votes
    9y

    @Mike McCarthy where you able to get the Classes setup with Online version, and if not how did you go about defining each of your properties/units?


    Cheers,
    ART

  • New to Real Estate · Oshkosh, WI · Member since 2019 · 19 posts · 5 votes
    5y

    @Peter T.

    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.

Join the conversationCreate a free account to reply, vote on answers and follow this thread.