How are you actually tracking your portfolio performance across all your properties?

Question

I've got a handful of rentals and I'm starting to look at my next few acquisitions. The thing that's been bugging me lately is I don't have a clean way to see how my whole portfolio is actually performing in one place.

Like — I can run numbers on a new deal fine, but when I'm trying to figure out if I should sell one property to fund another, or refi vs hold, or just understand which of my properties is actually my best performer after all expenses... I'm bouncing between spreadsheets, my bank account, and my own memory.

For those of you with 5-15+ doors — how are you actually making portfolio-level decisions? Is anyone using something that pulls it all together, or is everyone just running their own spreadsheets and gut feel?

Not talking about property management software for tenants/maintenance — more the investment strategy side. What should I hold, sell, buy next, and why.

Jake Baker · Answer

@Finnegan McDonnell

I use QuickBooks Online (QBO) for my flipping business, rental portfolio, and bookkeeping clients. You can separate properties by class to have an individual P&L per property. QuickBooks is great central software for your business if you know how to set it up correctly. It is not initially set up for real estate, so many in the forums will advise against it. If you have accounting knowledge or have good bookkeeping, or if they can set it up right for you, you can be tracking your portfolio in somewhat real time.

Drew Sygit · Answer

You should have accounting software where you are entering income/expenses to do P&Ls for each property.

Can be something only accounting-focused like Quickbooks, or DIY property management software with built-in accounting like RentRedi, Hemline or Doorloop.

Eduardo Cavasotti · Answer

QBO by class is a good accounting answer, but it is not the decision answer.

For hold, sell, or refi I want each property showing trailing NOI, current debt, equity, DSCR, and the cash I could redeploy if I sold.

The trap is ranking properties by rent or cash flow alone when the lazy door is actually tying up the most capital.

G. Brian Davis · Answer

I think this is a challenge a lot of investors run into as they grow.

A spreadsheet can work when you have a few properties, but eventually, the bigger question becomes portfolio allocation rather than property-level analysis. Which assets are producing the best risk-adjusted returns? Which has trapped equity? Which no longer fit your goals?

As a co-founder of a co-investing club, I've noticed that some of the most successful investors spend as much time evaluating their existing portfolio as they do evaluating new opportunities. I've seen everything from sophisticated dashboards to simple spreadsheets, but the common theme seems to be having a consistent process for comparing opportunities across the entire portfolio rather than evaluating each property in isolation.

Garrett Crosby · Answer

Eduardo's breakdown is solid. The metric I'd add emphasis to at your stage: Return on Equity (ROE). It's the number most investors ignore because they're focused on cash flow — but ROE is what tells you whether your capital is working as hard as it could be.

When you're at 5-15 doors, spreadsheets can still work if you're disciplined about updating them. The problem is exactly what you described — they go stale. What I'd recommend: pick one software (QBO is fine, REIHUB is easier for landlords specifically) and commit to entering transactions monthly. The ROE question — when to sell, refi, or hold — still requires you to build that layer in a spreadsheet, but at least the underlying data is clean and current.

Ryan Flanagan · Answer

To me, the art of maximizing return on equity (ROE) while maintaining somewhat healthy cash flows to keep you safe is how the game is played. You can have ROE that is poor because of poor management/performance or because there has been massive appreciation and there's the option to refinance and re-deploy capital elsewhere.

Taking every penny possible out of equity to have 20 doors that cash flow $5 a month (but maximizing ROE) doesn't make sense to me, personally. But neither does having a fully paid off $1M property (and minimizing ROE). It's really more of an art than a science, and every investor has their own philosophy.

In any case, feel free to DM me and I'd be happy to show you exactly how I would measure both property and portfolio-level performance for your investments. We're all doing this for the returns. Figuring out what return metrics are important to you is key.

Happy investing.

Basit Siddiqi · Answer

If you have everything set up within an accounting software(REIHUB, Quickbooks, etc) you can run different reports such as an income statement by property by year.

You can examine it for the following
1) How profitable / unprofitable a property has been over several years.
2) Expenses by year(Are they going up and by how much and is there anything that you can do to reduce it)

Best of luck!

Eduardo Cavasotti · Answer

@Finnegan McDonnell this is the question I wish I had asked earlier. I have 10 doors in Birmingham, all Section 8, all with third party property managers. For the first 4 or 5 properties I could keep track of performance in my head. After that it became impossible without real systems.

To answer your actual question about portfolio level decisions, here are the metrics I track per property and how I use them:

Net Operating Income (NOI) per property. This is gross rent minus all operating expenses (management fees, repairs, insurance, taxes, vacancy). NOI tells you how each property performs operationally before debt service. If one property has a significantly lower NOI margin than the others, that tells you something is off, either expenses are too high or rents need adjusting.

Cash on cash return. This is your annual pre tax cash flow divided by the total cash you have invested in the deal. For BRRR deals where you refinance out most of your capital, cash on cash can look incredible on paper. But it is still the single best metric for comparing properties against each other and against alternative investments.

Equity position. This matters for exactly the decision you described: sell one to fund another, refi versus hold. You need to know current estimated value minus loan balance for each property. If you have $60K in equity sitting in a property returning 8% cash on cash, but you could 1031 into a deal returning 15%, that is a portfolio level decision you can only make if you can see the numbers side by side.

The problem with spreadsheets (and I say this having built several elaborate ones) is that they go stale. You update them when you remember, which means the numbers you are looking at are often 2 or 3 months behind reality. Your PM raised a fee, insurance renewed at a higher rate, you had an unexpected repair. By the time you update everything, you are making decisions on old data.

QuickBooks and Xero can handle the accounting side, but they don't give you portfolio level visibility. They will tell you income and expenses per property, but they won't show you cash on cash, equity position, or help you compare properties side by side for hold versus sell decisions. You end up exporting to a spreadsheet anyway for the analysis layer.

What I found is that the real gap is between the accounting (which tracks what happened) and the portfolio intelligence (which tells you what to do about it). Most landlords are stuck building that intelligence layer manually in spreadsheets that break every time they add a property or change an assumption. The investors I know who scale past 10 doors all eventually build or find systems that give them real time visibility across the entire portfolio without manual data entry every month.

Markus Shobe · Answer

You need accounting software such as Quickbooks or Xero to track your properties inflows and outflows. Both of these software's will let you run reports by doors to see how each one is doing. Once you get to that many doors using spreadsheets is not the best way.

How are you actually tracking your portfolio performance across all your properties?

How are you actually tracking your portfolio performance across all your properties?

Most Popular Reply

12 Replies