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

Cleveland, Ohio
Managing Your Property
6dFollow

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

Jayden Thompson
Investor · Calgary, AB · Member since 2021 · 14 posts · 5 votes

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?

0Reply
600 views

Most Popular Reply

Kyle MccawBusiness Member
Property Manager · Keller, TX · Member since 2011 · 1k+ posts · 1k+ votes
6d

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

McCaw Property Management4.4905 Reviews
WebsiteView Page
1Reply
See this reply in the discussion

23 Replies

Jump to latestLatest
  • Vaibhav PuranikPro Member
    Member since 2025 · 69 posts · 36 votes
    6d

    I have a great scanner (Fujitsu IX1600) on my desk. Every time I have a receipt or a document, I simply scan it. Then, I have written a Document Uploader skill in ChatGPT. The skill knows which property is which LLC and where are the relevant folders. I also maintain the list of property, their LLCs and the folders in a spreadsheet. Everytime I scan something, I simply ask my ChatGPT, I just scanned something, go pickup those files and upload them to appropriate folder in my Google Drive. It parses the receipts, 99% of the time detects the correct property and then files it in the correct folder. And if i am outside, I take photos of the receipts and I can do the same thing from my phone as well as I have a ChatGPT app and it's able to do the same thing. And then ChatGPT's new ASTRA model also does my bookkeeping. It can actually take all the receipts, add them as expense line item and most of the time, it classifies them correctly. That part is in Google Spreadsheet. Hope this is helpful.

    [email protected]
    0Reply
    • Jayden Thompson
      OP
      Investor · Calgary, AB · Member since 2021 · 14 posts · 5 votes
      6d

      Hey Vaibhav!

      That’s a solid setup. Having it identify the property and file the receipt automatically sounds like a huge time saver, especially across multiple LLCs.

      Are you also using that spreadsheet to track mortgage paydown, equity and returns for each property, or mainly for bookkeeping? We’re building EquityRise around that portfolio side, so it’s helpful hearing how other investors have solved the document side.

      0Reply
  • Kyle MccawBusiness Member
    Property Manager · Keller, TX · Member since 2011 · 1k+ posts · 1k+ votes
    6d

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

    McCaw Property Management4.4905 Reviews
    WebsiteView Page
    1Reply
    • Brett Nachbor
      Kansas City · Member since 2024 · 16 posts · 1 vote
      6d

      good point about the data. Most investors aren't lacking data, or simply not collecting enough data points; at least not from conversations I've had with scaling operators. Its connecting it all in order to have a fuller picture of the portfolio to make better informed financial and strategic decisions rather than play whack-a-mole from property to property depending on what problem just blew up. I created assetmanagerai.net to do just that. I first saw this years ago when I was on the lender side.

      0Reply
  • Richard (Ryszard) Cieplechowicz
    Member since 2026 · 63 posts · 19 votes
    6d

    I'd keep a dated follow-up log alongside the books. QuickBooks tells you what posted, but a payment promise or missing invoice needs a next action and a date. The hard part is finding that note when somebody calls back.

    0Reply
  • Jim Johnson
    Real Estate Agent · Memphis · Member since 2026 · 561 posts · 327 votes
    6d

    The hardest part isn’t usually tracking one number, it’s getting the full history of a property in one place. An invoice might be in email, the work order is in the management system, the payment is in accounting, and the lease or insurance document is somewhere else entirely. Then six months later you’re trying to answer a simple question and have to piece it together from four different places. If you’re building something, solving that without creating another system people have to manually keep updated would be a big one.

    0Reply
  • Ming Yi
    Investor · San Francisco · Member since 2026 · 25 posts · 11 votes
    6d

    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.

    0Reply
  • David Yellin
    Member since 2018 · 1 post · 0 votes
    6d

    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

    0Reply
  • Divin KanyamaBusiness Member
    Accountant · Seattle, WA · Member since 2025 · 330 posts · 120 votes
    6d

    @Jayden Thompson With 27 units in two countries, spreadsheets alone can become difficult to maintain. I’d use property-management or accounting software for income and expenses, paired with one cloud folder and a dedicated email address for each property’s receipts, leases, insurance, and tax bills. For equity tracking, record each loan balance and estimated property value quarterly so you can separate appreciation from principal paydown. Your U.S. and Canadian records should also stay clearly separated for year-end reporting, with guidance from cross-border tax professionals. The biggest gap most tools seem to have is bringing cash flow, debt paydown, equity, and document storage into one reliable dashboard without double entry. That sounds like a valuable problem for your new tool to solve.

    [email protected]
    WEMBO CPA532 Reviews
    WebsiteView Page
    0Reply
    • Jayden Thompson
      OP
      Investor · Calgary, AB · Member since 2021 · 14 posts · 5 votes
      6d

      Hey thanks man.

      That’s exactly what I am trying to build. I would really love for a few investors to take a look at it. I don’t really know anyone in the space.

      The website is www.equityrise.app

      If you could maybe check it out and send me some feedback via DM? I’d really appreciate it !

      0Reply
  • Jayden Thompson
    OP
    Investor · Calgary, AB · Member since 2021 · 14 posts · 5 votes
    6d

    Hey thanks for your reply ! Have you thought about just combining everything ? That’s kinda what I’m building is all about. All properties, all countries and all documents in a single place.

    I’d like for some feedback. The link to my website is www.equityrise.app

    0Reply
  • Aaron ZimmermanBusiness Member
    Accountant · Chicago, IL · Member since 2018 · 2k+ posts · 1k+ votes
    6d
    I keep everything in spreadsheets but I only have two properties and am a cpa!
    [email protected]
    Brick House CPAs53 Reviews
    WebsiteView Page
    0Reply
  • Diana KhanPro Member
    Attorney · 10451 Mill Run Cir #755 Owings Mills, MD 21117 · Member since 2024 · 432 posts · 166 votes
    6d
    Quote from @Jayden Thompson:

    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?

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

    [email protected]240-266-0291
    0Reply
    • Jayden Thompson
      OP
      Investor · Calgary, AB · Member since 2021 · 14 posts · 5 votes
      5d

      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.

      0Reply
  • Simon W.Business Member
    Real Estate Consultant · Lehigh Valley PA & New York City · Member since 2013 · 1k+ posts · 665 votes
    5d

    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.

    Accounting Properties LLC
    View Page
    CFO LLC
    View Page
    0Reply
  • Jack KrusinskiBusiness Member
    Realtor · Cleveland/Akron OH · Member since 2019 · 146 posts · 93 votes
    5d

    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.

    [email protected]216-789-6736
    0Reply
  • Adam BartomeoBusiness Member
    Real Estate Broker · Cape Coral, FL · Member since 2015 · 2k+ posts · 1k+ votes
    5d

    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.

    [email protected]239-339-3969
    Bartomeo Property Management4.7150 Reviews
    WebsiteView Page
    0Reply
  • Ashish AcharyaBusiness Member
    CPA, CFP®, PFS · FL · Member since 2017 · 5k+ posts · 3k+ votes
    5d

    Jayden, I think you’re asking the right question because once a portfolio gets beyond a few properties, cash flow alone doesn’t tell the whole story.

    I’d want to track property-level performance separately from the overall portfolio: current value, debt balance, equity growth, cash flow, reserves, major repairs, upcoming renewals, and any changes that affect the long-term return.

    The documentation side is usually where things start becoming painful. Having a consistent system for invoices, insurance, leases, tax documents, and receipts makes year-end much easier and also gives you a clearer picture of which properties are actually performing.I’d also be careful about relying only on spreadsheets as the portfolio grows. They can work early on, but once you have properties across different locations, currencies, and tax environments, keeping everything organized becomes much harder.

    From the tax side, having clean property-level records is extremely valuable. Depreciation schedules, repairs versus improvements, financing records, and operating expenses all become much easier to manage when the information is organized throughout the year rather than rebuilt at tax time.

    Feel free to DM me, I’d be happy to share our Real Estate Portfolio Management Tool and a few resources that may help you organize the portfolio side.

    [email protected]941-914-7779
    INVESTOR FRIENDLY CPA®5241 Reviews
    WebsiteView Page
    TaxMD® | AI-Powered Tax Planning
    WebsiteView Page
    0Reply
  • Fulton Abraham Sanchez
    CPA| New Clients Welcome| 50 States · Member since 2016 · 435 posts · 93 votes
    4d

    @Jayden Thompson

    The real pain point sounds like year-round organization. If receipts, leases, insurance, and tax records are captured consistently, year-end becomes much easier.

    From a CPA perspective, combining financial reporting and document management in one portfolio view would solve a major problem for investors like you.

    0Reply
  • Eduardo Cavasotti
    Investor · Charleston, SC · Member since 2018 · 198 posts · 84 votes
    4d

    27 doors across two countries is where the receipt problem stops being an inbox problem and becomes a filing problem. What fixed it for me: every invoice, insurance bill, and tax notice gets tied to one property, not my inbox or a shared drive. I also stopped tracking debt paydown by hand, split principal from interest on the loan schedule every month, so year end pulls two clean numbers instead of a scavenger hunt. Two year ends make that worse, not better, so tag everything by year and by country from day one.

    0Reply
  • Israel Oluwaseun
    Virtual Assistant · Member since 2026 · 14 posts · 2 votes
    4d

    With 27 units across two countries, I can definitely see why keeping receipts and year-end records organized becomes difficult. I’d separate the tracking into property-level income/expenses, capital improvements, financing/debt, and tax-year documentation. Having everything categorized throughout the year can make year-end tax preparation much easier and reduce the scramble for missing receipts.

    I’d also keep the U.S. and Canadian records clearly separated from the beginning since the tax reporting requirements can differ.

    0Reply
  • Ryan ThomsonBusiness Member
    Real Estate Agent · Colorado Springs, CO · Member since 2018 · 1k+ posts · 1k+ votes
    1d

    Cash flow is the starter metric. The three I track alongside it tell a more complete story.

    Principal paydown. On a $380K loan at 2.75%, I'm capturing about $12K in principal year one. That's equity I built without appreciation doing anything. On my older properties with sub-3% rates, the loan paydown is steady and predictable. I factor it into total return, not just monthly cash.

    Equity position (cost basis vs. current value). I pull comps every six months and update a simple spreadsheet. Not obsessing over it, just knowing where I stand. When the number moves enough to refinance into a cash-out or sell, I want to see it coming.

    Effective yield on equity. This one changes behavior. A property cash flowing $400/month on $150K in equity is a 3.2% return on that equity. At some point it makes sense to 1031 into something with a better yield. Tracking it keeps me honest about whether I'm holding because the asset is good or because I'm attached to it.

    The one I'd add that most people skip: cost to carry if vacant. Know your break-even occupancy before you're in a vacancy, not after.

    On the financing side, if you're holding any properties with sub-4% assumed loans, that low rate is a major component of your total return. A $400K loan at 2.75% versus replacing it at 7% is nearly $1,200/month difference. That's as real as cash flow.

    Track what changes your decisions. Everything else is noise.

    The Assumable Guy544 Reviews
    WebsiteView Page
    0Reply
Join the conversationCreate a free account to reply, vote on answers and follow this thread.
Log InJoin for Free