How do you track whether your rental properties are performing the way you expected?

Question

When I bought my properties I calculated the expected rent, mortgage, expenses, projected cash flow. But now that I've owned them for a while I realize I have no clean way to look back and see if reality actually matched those projections. Like I know roughly what comes in and goes out each month, but I don't have a clear picture of my actual cap rate, cash-on-cash return, equity or whether my cash flow is actually what I thought it would be. I end up digging through bank statements and spreadsheets every time I want to answer a basic question. Curious how other investors handle this. Do you use software, spreadsheets, just gut feel? Is tracking this stuff even something you bother with or do you just focus on whether rent covers the mortgage?

Alex S. · Answer

The fastest way to find that missing $250 is to rebuild your pro forma as a line-item variance table and compare projected vs trailing-12 actuals row by row: gross rent, vacancy, taxes, insurance, P&I, management, repairs, capex reserve. Use trailing 12 divided by 12 rather than any single month, since one turnover or an escrow adjustment distorts a monthly snapshot, and check whether your original $400 actually carried reserves (5% vacancy, 8-10% management, 5% repairs, 5% capex on a $1,600 rent is roughly $300/month, which by itself can eat the gap). In practice the culprit is almost always one of three lines: effective rent below what you underwrote, an insurance or tax jump since purchase (reassessment at your purchase price is brutal in some counties), or repairs and capex you modeled at zero. Once you know which line moved, you also know whether it is fixable (bump rent at renewal, reshop insurance, self-manage) or structural, and if it is structural, re-run cash-on-cash with the real numbers against your total cash in so you are judging the hold on today's math instead of the original spreadsheet.

Dan V. · Answer

In an ideal world, you underwrite the property before you buy it, establish your target cap rate, cash-on-cash return and cash flow, then continue tracking the actual results against those projections after closing.

In real life, a lot of investors don't do that. You get busy managing tenants, repairs, rehabs, your regular job, finding the next deal, etc. As long as rent is coming in, the bills and debt service are getting paid, and there's money left in the account, everything seems fine.

As a CPA and investor, I'm actually surprised how many investors only reach out when it's time to update the books for tax purposes or when their books get really messy. They may own several properties but don't regularly look at property-level P&Ls or performance metrics. Cap rate and cash-on-cash get a lot of attention during underwriting, but after closing they stop tracking them.

And to be fair, actual performance will almost never match the original underwriting exactly. Taxes and insurance increase, interest rates change, you have unexpected repairs, vacancies, rent projections might be off, appreciation, improvements, refinances, etc. Some of those you can control and some you can't.

Based on your post, it sounds like you already understand the metrics. What you're missing is probably the accounting system and process to capture the actuals.

That's what I would fix first.

Regardless of whether you have one property or 100, I think having a properly set up accounting system is a must. Track income and expenses by property, properly account for your mortgage principal and interest, capital improvements, fixed assets, owner contributions/distributions, etc., and reconcile everything regularly.

There are two big benefits.

First, when tax season comes around, you're not rebuilding an entire year's activity from bank statements and spreadsheets, mostly relying on your memory.

Second, if one day (like this day) you want to know, "How is this property actually performing?", the data is already there. You can pull the financials and start analyzing instead of spending hours reconstructing the numbers first.

I personally use QuickBooks Online for this. The software itself isn't really the important part, though. The setup and process are. If the books are structured correctly and kept current, you can always take the actual numbers and compare them back to your original underwriting.

Jason Wray · Answer

As a Banker I typically run the numbers in advance for all of my clients on Market price, Current and Proposed Rents, ARV potential, Equtiy position and what month or timeframe to refinance to pull cash out for the next BRRR. Then the investor chooses a rent type LTR, STR, MTR Co-Living and we set it up under a PM or help them set it up and create their own property management company. You should always know your recouperation period on when you recoup the down payment, closing costs, and any renovations to break even prior to profits.

You can use Quickbooks, Excel, create a spreadsheet or use other software but alwasy track your Gross, Net, and have the numbers ready for your Schedule E or CPA at the end of the year. Having an investment that only "debt services" itsel (pays the mortgage) is okay but its a long term 20-25 year investment. Thats is why buying and running the numbers are the most crucial steps to ensure cash flow above PITI and ARV potential.

Simon W. · Answer

I keep the original underwriting assumptions as a baseline and compare actuals on the same lines: rent versus underwritten rent, vacancy and concessions, taxes, insurance, utilities, repairs versus the reserve assumption, property management and admin fees, debt service, cash flow after debt, and capex outside the operating picture.

Monthly is for cash and surprises. Quarterly is for whether the deal thesis is still true. Annually is for hold, refi, or sell.

If you're digging through bank statements to rebuild this every time, the missing piece is usually property-coded books plus a one-page variance report — not another spreadsheet tab. Also separate performance from accounting truth. A property can look fine on cash-on-cash while the balance sheet is a disaster because capex and owner activity got dumped into expenses.

Fulton Abraham Sanchez · Answer

@Sahil Faran , hi. Absolutely worth tracking. Rent covering the mortgage tells you very little about how the investment is actually performing.

From the CPA side, I’d track each property separately and compare actual cash flow, cap rate, cash-on-cash return, expenses, and equity against the original projections. A simple monthly reporting system can eliminate the bank-statement digging and show you which properties are truly performing and which only look like they are.

Ashish Acharya · Answer

Sahil, I’d definitely track it. Once you own more than one property, “rent covers the mortgage” is not enough to tell you whether the investment is actually performing well.

I’d keep a simple monthly or quarterly scorecard for each property with the same numbers every time: gross rent collected, vacancy, repairs, CapEx, taxes, insurance, management, debt service, actual cash flow, and reserves. Then compare those numbers against what you originally projected when you bought the property.

The most useful part is usually the variance. If you projected $400/month in cash flow but the property is averaging $150, you want to know why. Maybe repairs are higher than expected, insurance increased, vacancy is worse, or the rent assumption was simply too optimistic.

I’d also track return on equity as the property appreciates and the loan pays down. A property may still be producing positive cash flow but become a weak use of capital if you have a large amount of equity tied up for a relatively small return.

From the tax side, good property-level tracking helps too. Repairs, capital improvements, depreciation, cost segregation, and suspended losses all become much easier to manage when each property has clean records rather than everything being reconstructed at tax time.

You don’t need anything overly complicated. A system you update consistently is much more useful than a perfect dashboard you stop using after three months.

Feel free to DM me, I’d be happy to send over a portfolio-management tool that might help.

Drew Sygit · Answer

I have a template I've used for years that I run for each purchase offer and save them.

So, I can pull them up to track projected vs actual:)

Sahil Faran · Answer

@Jason Wray yeah that's what I thought. I just don't want to manually do all of that on a spreadsheet for every property I own. I'm building something to automate it. That way as my portfolio grows I don't have to actively manage the numbers, I can get my answers right away. I'm sure it'll be time efficient as well

Aaron Zimmerman · Answer

You can't use gut feel. That will not fly. Accounting is pretty objective. I use a spreadsheet for my properties as I only have two. I usually recommend qbo or stessa once you're past a few properties.

feel free to pm me if you'd like my spreadsheet!

Mark Updegraff · Answer

I absolutely think it’s worth tracking.

Your original underwriting should become the baseline you compare the property against, not a spreadsheet you close after buying it.

I’d periodically compare actual collections, vacancy, taxes, insurance, maintenance, management, CapEx and debt service against what you originally assumed. Then recalculate the things you actually care about — cash flow, DSCR, cash-on-cash return and equity.

The variances are often more useful than the return itself.

If insurance is 30% over budget or maintenance is consistently double what you modeled, that tells you something about the property and improves how you underwrite the next one.

“Rent covers the mortgage” is a pretty low bar for determining whether an investment is performing.

How do you track whether your rental properties are performing the way you expected?

How do you track whether your rental properties are performing the way you expected?

Most Popular Reply

12 Replies