What do you track beyond cash flow in your rental portfolio?

Question

I own 27 rental units across the U.S. and Canada. Cash flow gets most of the attention, but I also want to know how much debt I’ve paid down and how my equity has changed. I am horrible at keeping track of receipts and I have two year ends. One in Canada one in the US. Which sucks because year end is always a mess I never have everything I need my inbox is a mess. Cant find anything.....

Then there’s the admin side: keeping invoices, insurance, tax bills and leases organized so year end doesn’t turn into a scavenger hunt.

I’m building a portfolio management tool with my buddy currently I cant find anything that meets all my needs on the market.... So I’m interested in how other property owners handle this.

Do you keep everything in spreadsheets, use software, or have your property manager handle it? What’s the one thing your current setup makes harder than it should be?

Kyle Mccaw · Answer

@Vaibhav Puranik Cash flow is important, but I’d also track lease expirations, delinquency, maintenance spend by property, vacancy days, turnover cost, insurance renewals, tax bills, debt paydown, and estimated equity.

The bigger opportunity now is putting all of that into one database instead of having it scattered across email, spreadsheets, and folders. If the data is structured correctly, AI can summarize the portfolio for you, flag problems, answer questions like “which properties had the highest maintenance spend this year?” and even generate dashboards automatically.

That’s where I think this is headed — less time hunting for information and more time actually making decisions from it.

The hard part isn’t collecting more data. It’s making sure everything is connected to the right property and kept clean enough that your reporting is trustworthy.

Diana Khan · Answer

@Jayden Thompson, with 27 properties across two countries, I can see why keeping everything organized has become such a headache. Beyond cash flow, I would keep a clear record of who owns each property, which LLC owns it, the current loan and insurance information, and the important documents tied to each property. Having that all connected makes it much easier when something changes or you need to find an old document.

I’ve had investors come to me when they needed to clean up their property records after buying more properties or changing how they were structured. Sometimes the deed, LLC records, operating agreement, insurance, and estate plan are not all keeping up with the portfolio. Those are the things I like to review with clients because small gaps can become much harder to fix later.

I really like this topic, @Jayden Thompson, because keeping the legal and ownership side organized is a big part of the real estate work I do. Your idea of bringing the property, documents, and ownership information into one place makes a lot of sense. Happy to stay connected and follow what you’re building.

Jayden Thompson · Answer

Hey Diana!

In the app I’ve actually implemented that. You can designate each property to which company owns it, you can put in a partnership split as well if you only own 50% of the deal. You can input company filing reminders and deadlines so you get email notifications. Each property then has cloud storage where you can upload any documents relevant including: repairs, capex, renovations, water bills, cleaning invoices, power bill, natural gas bill.

For each property there is a section to input your current mortgage Balance with your interest rate and amortization schedule (traditional financing, OR SELLER FINANCING), also insurance and tax information for the year.

Then mortgage/escrow, taxes, insurance are all automatically deducted for the year so the landlord only has to enter repairs and other bills.

Having an attorney check it out would mean a ton to me. I’d love to book a call and walk you through it!!! Maybe you have clients who could benefit from it as well.

Simon W. · Answer

Cash flow is the easy headline. For client portfolios we also want debt paydown, equity change, and whether the bank still matches the books after owner draws and reserves. Receipts matter too — a pretty cash number with no paper trail is just a guess at tax time.

With doors in two countries and two year-ends, I'd keep one property-level ledger that rolls into each entity, then a thin portfolio view on top. Don't let the PM statement be the only source of truth. Their owner report is ops. Your books are what you own.

Spreadsheets work until the handoff breaks. When Canada and the U.S. close on different calendars, the pain is usually mismatched cutoffs, not missing software. Pick a close checklist and stick to it.

Adam Bartomeo · Answer

We keep track of a LOT of information for our owners and some are very similar to you. When they came to us it was a bit of a mess. We cannot track everything for them especially if we aren't managing their other assets. We do not track their taxes, insurance, mortgage payments but we do handle almost everything else. For my personal investments I just need a spread sheet to track vacancy and some other KPI's.

Jack Krusinski · Answer

Hi Jayden. I use a simple spreadsheet that is shared with my CPA and quickbooks. It could be better but it gets the job done.

Maurizio Pisciotta · Answer

I’ve run into the same issue of having portfolio information spread across different places. For the portfolio/equity side, I use Navikoo.

It lets you keep your properties together and track things like property values, equity, financing, cash flow and overall portfolio performance, which is much easier than maintaining separate spreadsheets.

It doesn’t currently track exactly how much interests you’ve paid down over time, and it’s not designed for uploading receipts, invoices or tax documents.

For that side, I’d still use QuickBooks.

I actually think these are two different problems: understanding how your portfolio is performing versus keeping the accounting documentation organized.

Trying to make one tool do everything can sometimes make both sides worse.

Ming Yi · Answer

Beyond cash flow I track three things per property: true net including capex reserves, debt paydown and equity change once a year, and maintenance cost per unit per year so I can spot the house that eats money. The receipt problem was my biggest pain too. What fixed it was a weekly ritual: every Sunday I photograph receipts into a per-property bucket with the expense category tagged at the moment, not at tax time. Doing it weekly takes ten minutes and beats a January scavenger hunt. I built a small app called Portiq for my own rentals to handle exactly this, per-property accounting with receipt photos attached to each expense and one-tap reports my CPA actually accepts. If you are curious, click my avatar and check my profile, I put more info there.

David Yellin · Answer

Coming at it from the accounting side (I'm a real estate accountant with over 12 years of experience and a former NYC commercial real estate Controller), a few suggestions:

Debt paydown and equity: Most tools track cash flow well but treat the mortgage payment as one expense. Split each payment into principal and interest using the loan's amortization schedule and track them separately in your books. Principal reduces the loan balance (a liability), and interest is an expense. The mortgage is probably your largest liability, so your equity is roughly estimated value minus that balance; other assets and liabilities are usually small by comparison. Again, I'm coming at this with an accounting mindset, but a basic P&L and balance sheet alongside your cash flow will tell the full picture.

Two year-ends: Keep US and Canadian properties in separate books, each in its own currency, closed monthly. That way year-end is a cutoff, not a rebuild. For a consolidated view, translate the balance sheet at the year-end exchange rate and the P&L at the average rate for the year.

Receipts and admin: Best advice I can give is to capture and record in the moment, or every few days at most. Set a cadence, daily or weekly, and stick to it. Send every receipt to one inbox or app, and keep one folder per property with the same subfolders (leases, insurance, tax bills, invoices, loan docs). The numbers and the documents live in separate places. You can see an expense in the books but not the invoice behind it, or you have the invoice but aren't sure it was ever recorded. A tool that links the two would save a lot of headaches at year-end.

Happy to connect further and discuss how my accounting expertise could help bridge the gap with what you're building

What do you track beyond cash flow in your rental portfolio?

What do you track beyond cash flow in your rental portfolio?

Most Popular Reply

18 Replies