Specialist · PA · Member since 2026 · 13 posts · 0 votes
I'm trying to see how other investors keep track of a mixed portfolio. Some of mine are rehabs with budgets and draws, some are long-term rentals with tenants and leases, and some are land I'm holding or developing. Most software I've looked at handles only one of those well.
What do you use for each type, and does any of it talk to the others? A spreadsheet is a fine answer. I'd like to hear what actually works.
You're right, I haven't seen anything that handles all three really well either.
What seems to work best is to stop hunting for the one perfect tool. Keep using whatever works for each type, and then put one simple master sheet on top of it all.
Just one row per property with the type, where it's at, money in, money out, and the next important date, whether that's a draw, a lease renewal, a permit or a closing. The details live in the tool that's built for them, and the sheet gives you the whole picture at a glance.
Getting everything to talk is usually easier than people expect, too. Most rental and accounting tools can export to a spreadsheet or connect to one, so a few key numbers can update on their own instead of you retyping them every month.
Out of curiosity, which side takes up most of your time right now, the rehab draws or the rentals?
Eric, sorting this out before the portfolio gets bigger will save you a lot of cleanup later. One angle nobody's raised is to set up each tracker in the shape the next lender will ask to see it. On the rehabs, keep your budget on the same line items as the scope of work the lender approved, so every draw request lines up item for item and moving savings into contingency is easy to show. On the rentals, keep a current rent roll with the signed leases attached, since most DSCR lenders size a refi off the rent. On the land, log taxes, insurance and other carrying costs as they come in, so you always know what holding it really costs. The tracker runs the deal, the paper trail gets you the next loan.
Lee's master sheet is a good start. The thing I'd add is to make all three share the same few fields so one view works across them: property, type, stage, money in, money out, and the next date that matters (a draw, a lease renewal, a tax bill). Once every deal has those, it matters a lot less whether the rehab lives in one tool and the rentals in another. You can still see everything in one place.
When several people are updating it, or you're typing the same numbers in twice, that's usually the point to move it all into one system built around how you actually run things. Before that, a well-kept sheet does the job.
how many doors are in each bucket, and which type is actually causing the pain? the answer changes the setup a lot. rehabs need budget vs. actual by line item plus a draw log. rentals need a rent roll, monthly NOI per property, and repairs spent vs. what you reserved. land is basically carrying costs and a tax date. most people end up with a spreadsheet for rehabs, a rental tool for leases and rent. if rentals are the bulk of it, start there, since that's where the numbers drift fastest.
Eric, one thing I'd add to the master sheet idea: give every deal the same return column, so the three types can be compared against each other, not just listed side by side.
The trap with a mixed portfolio is that each type gets judged by its own yardstick. Flips get judged on profit, rentals on monthly cash flow, land on what you think it'll sell for. That makes it hard to tell where your next dollar should go.
What works for me is two numbers per row:
1. Cash in today: down payment, rehab money, closing costs and carrying costs paid so far, minus any cash you've pulled back out (a refi or a partial sale).
2. Annualized return on that cash: for a flip, expected profit divided by cash in, divided by the months held, times 12. For a rental, the last 12 months of cash flow divided by cash in. For land, minus the yearly carrying cost divided by cash in, until it sells.
Example numbers: a flip that makes $30,000 on $100,000 of cash over 8 months is 30% / 8 x 12 = 45% a year. A rental with $60,000 in and $4,800 a year of cash flow is 8%. A lot with $40,000 in and $2,400 a year in taxes and insurance is minus 6% until something happens with it.
None of that says sell the land or stop buying rentals, since appreciation, principal paydown and tax benefits aren't in those numbers. But it shows what each bucket costs you in cash while you wait, which is the question a mixed portfolio usually needs answered.
From my experience working with real estate investors, I’ve found that a well-structured CRM like Follow Up Boss or GoHighLevel can make managing different types of real estate leads much easier.
The key is setting up separate pipelines, custom fields, tags, and Smart Lists for each investment category, whether it's fix-and-flip properties, long-term rentals, or vacant land.
I personally prefer keeping everything organized under one CRM rather than managing different lead databases across multiple platforms.
Eric, one reason to keep the three buckets clearly separated, even under one master sheet, is that your CPA will likely treat them differently at tax time. Flip profit, rental income and land held for investment usually end up in different places on the return, and holding costs on raw land have their own rules, so ask your CPA early whether to expense or capitalize them. What makes that easy is a separate bank account per bucket (or per entity), plus a property ID on every transaction, so the master sheet can be built from the bank data instead of retyped. If a dollar ever moves between buckets, record it as a transfer, not as an expense, or the returns on each bucket get muddy fast.
The master sheet is fine for a snapshot. But I'd run one set of books per entity, not per strategy. That's what saves you later. Flips need job costing, line by line, draws as liabilities until the work's done. Rentals just need a tag per property so the P&L pulls clean. Land, don't forget it, just log taxes and carrying costs as they hit. My company keeps the detail in the accounting system and the sheet simple. One row per property, money in, money out, next date that matters. The sheet tells you where you are. The books answer the lender and the CPA.
