22 Questions in This Hub
- What is portfolio reporting and why does it matter?
- What KPIs should I track at portfolio level?
- How do per-property and portfolio views fit together?
- How do I build a consolidated view across multiple LLCs?
- What is capital velocity and how do I calculate it?
- How do I track equity across the portfolio?
- How do I aggregate cash-on-cash return across the portfolio?
- Why does return on equity matter more than cap rate at portfolio level?
- How do I report to capital partners vs. for myself?
- How often should I review portfolio reports?
- How do I build a portfolio P&L?
- How does NOI roll up across the portfolio?
- How do I track vacancy across the portfolio?
- How do I track loans and debt service across the portfolio?
- How do I track capital expenditures separately from operating expenses?
- How do I identify refi candidates from the portfolio view?
- How do I identify properties that should be sold?
- What changes in portfolio reporting as I scale from 5 to 50 doors?
- How do I track properties across multiple states?
- What red flags should I watch for in portfolio P&L?
- How do I know when the portfolio can absorb another acquisition?
- How much of portfolio reporting can be automated?
1. What is portfolio reporting and why does it matter? #
Portfolio reporting is the consolidated view of every property, entity, loan, and bank account in your real estate business as one operating unit. It answers questions you cannot answer from per-property records alone: total monthly cash flow across all rentals, weighted average cap rate, total equity deployed, total deployable equity, which properties are profitable on a cash basis versus only after depreciation, and where capital is sitting idle.
It matters because rental investing is a portfolio activity. A single property that loses money in a given year is not necessarily a problem if the rest of the portfolio more than offsets it. Without a portfolio view you cannot make capital allocation decisions: whether to refinance property A to fund acquisition B, whether to sell the underperformer, whether to pay down debt or buy more. Most landlords with 3+ properties operate without a true portfolio view and are surprised when they finally build one.
2. What KPIs should I track at portfolio level? #
Six core metrics handle 90% of decisions. Total monthly cash flow across all properties (the actual cash you put in your pocket after debt service and operating expenses). Weighted-average cap rate across the portfolio (NOI / market value, weighted by property value). Total equity deployed (current market value minus loan balances). Capital velocity (how fast your invested dollars recycle into new deals). Debt-to-equity ratio across the portfolio. Per-property health score that flags vacancy, delinquency, deferred capex, and underperformance.
Two derived metrics matter once you have these: cash-on-cash return on the actual cash you have invested (not what the underwriting model said three years ago) and return on equity on current equity (which tells you whether you should refinance to redeploy that equity). Avoid vanity metrics like total door count or total assets under management; they look impressive on a spreadsheet but do not tell you whether the business is healthy.
3. How do per-property and portfolio views fit together? #
Per-property views are the operational layer: rent collection, vacancy, repair tickets, lease renewals, individual P&L. You manage daily operations from the per-property view. Portfolio views are the strategic layer: capital allocation, financing decisions, dispositions, acquisitions. You manage the business itself from the portfolio view.
The two views need to come from the same underlying data. If your per-property bookkeeping lives in spreadsheets and your portfolio dashboard is a separate Sunday-night manual rollup, the two diverge by month two and you end up making decisions on stale or inconsistent numbers. The cleanest pattern is software that maintains per-property books as the source of truth and computes portfolio views by aggregation, so the two cannot drift apart. Per-LLC views sit between them as a third layer for tax filing and entity-level financing.
4. How do I build a consolidated view across multiple LLCs? #
Three layers of aggregation. The bottom layer is per-property: each property has its own income, expenses, debt service, and net cash flow. The middle layer is per-entity: properties owned by LLC A roll up to LLC A's P&L, balance sheet, and cash position. LLC A's books are what files with the IRS (Form 1065 for MMLLC, or feeds the owner's personal Schedule E for SMLLC). The top layer is portfolio: all entities consolidate into a single view of the entire investing business.
Consolidation requires consistent categorization across entities (the same chart of accounts), elimination of intercompany transactions (a loan from holding company to operating LLC nets to zero at portfolio level), and a clean way to view either gross (each entity's full activity) or net (after eliminations). Spreadsheets handle two entities, struggle with four, and break above five. Dedicated multi-entity rental software handles the rollup automatically.
5. What is capital velocity and how do I calculate it? #
Capital velocity is how fast your invested dollars recycle through deals. The formula in its simplest form: capital recycled in the period divided by average capital deployed during the period. A BRRR investor who pulls $50,000 of equity out of a refinanced property in month 9 and redeploys it into a new acquisition in month 10 has high capital velocity. A buy-and-hold investor whose $200,000 of equity sits in a property for 15 years has low capital velocity.
Why it matters: a portfolio with high capital velocity grows much faster than one with low velocity, even at the same total return per dollar. $100,000 that recycles every 18 months funds 6 to 8 deals over a decade; the same $100,000 sitting in one property funds one. Capital velocity is the metric that explains why some investors scale to 20+ doors while others plateau at 4. The DoorVault capital velocity calculator runs the math on your portfolio in 5 minutes.
6. How do I track equity across the portfolio? #
Equity per property = current market value minus current loan balance. Portfolio equity is the sum across properties, plus or minus any cash held at the entity level. Market value is updated periodically (annual broker price opinion, AVM estimates, or county assessment as a floor). Loan balance is the current outstanding principal from your most recent mortgage statement.
The useful split is deployed equity (the original cash you put in plus retained appreciation and principal paydown) versus extractable equity (equity above the lender's max LTV, typically 75% to 80% on cash-out refis for investment property). Extractable equity is the real fuel for the next acquisition. A portfolio with $800,000 of equity but only $200,000 extractable is much less liquid than the headline number suggests. Track both separately so you do not overestimate redeployable capital.
7. How do I aggregate cash-on-cash return across the portfolio? #
Aggregate cash-on-cash return at the portfolio level = total annual cash flow across all properties divided by total cash invested across all properties. The numerator is the actual net cash flow (rent minus operating expenses minus debt service minus capex), summed across the portfolio. The denominator is the cash you put in (down payments plus closing costs plus rehab) summed across the portfolio, less any equity you have already pulled back out via cash-out refinances.
The trap is using original cash invested even after a cash-out refi has returned that capital. If you put in $40,000 and pulled $40,000 back out, your remaining cash invested is essentially zero and the cash-on-cash on remaining capital is infinite (or undefined). For a meaningful portfolio number, track cash invested net of returns of capital. The result tells you the real return on the dollars currently working, which is what you compare against alternative uses of that same capital.
8. Why does return on equity matter more than cap rate at portfolio level? #
Cap rate measures the property's yield on its current value. Return on equity (ROE) measures your yield on the equity actually trapped in the property. The two diverge over time. A property bought 8 years ago at $150,000 with $30,000 down, now worth $280,000 with $90,000 of equity, may show a 7% cap rate at $280,000 valuation but only a 4% ROE on the $90,000 of equity sitting there.
When ROE drops below what you can earn on extracted equity in a new deal, refinancing to redeploy is usually the right move (assuming the property continues to cover the new debt service). Cap rate keeps looking healthy because it is denominated in market value, but the real opportunity cost is on your equity. Most long-time holders have at least one property where ROE has decayed below the threshold for refinancing, and a portfolio view is what surfaces those candidates. Reviewing ROE per property annually is one of the highest-leverage portfolio activities.
9. How do I report to capital partners vs. for myself? #
Owner views (for yourself) include everything: full P&L per property and per entity, capex tracking, capital velocity, deployable equity, the works. Investor views (for outside capital partners) are typically narrower and focused on what the investor cares about: their pro-rata share of cash distributions, their account balance (capital contributed minus distributions plus retained earnings share), the performance of the specific deal they invested in, and tax documents (K-1).
Mixing the two is a common mistake. Showing a passive investor your full operational details (vendor invoices, tenant turnover spreadsheets, your other unrelated properties) adds noise and creates fiduciary expectations you may not want. Build a separate investor-facing report per investor or per syndication that shows exactly what they need: distributions to date, current account balance, current property performance, and projected exit. The owner view stays internal.
10. How often should I review portfolio reports? #
Three cadences work for most operators. Monthly: cash flow summary, vacancy by property, delinquency, capex spend versus budget, any flagged items from PM statements or bank reconciliations. This is a 30-minute review that catches problems early. Quarterly: full portfolio P&L, capital velocity, equity update, ROE per property, refi candidates. This is the strategic check-in, 60 to 90 minutes.
Annually: full year-end close, tax-prep package, multi-year trend analysis, dispositions consideration, refinance and acquisition pipeline planning. This is the half-day review that drives next year's strategy. Below this cadence (semi-annual or annual reviews only) you lose the ability to catch problems early; above it (weekly portfolio reviews) you spend more time reporting than operating. Match the cadence to portfolio size and complexity, but never skip the quarterly entirely.
11. How do I build a portfolio P&L? #
Aggregate the per-property P&L across all properties, then add a portfolio-level layer for entity-level expenses that do not belong to any single property (legal, accounting, software subscriptions, owner distributions, intercompany items). The per-property layer should follow Schedule E line categories so it ties to your tax return; the portfolio layer adds the operational items that are real expenses but live above the property level.
Two presentations are useful. Tax-aligned: gross rent at top, then Schedule E expense categories, then depreciation, then net taxable income. This matches what your CPA filed and what the IRS sees. Cash-aligned: gross rent at top, then cash operating expenses, then debt service (which is not on Schedule E), then capex (which is also not on Schedule E in the year incurred), then net cash flow to owner. The cash view is what tells you actual portfolio cash flow; the tax view is what files. Build both, and reconcile them once a year so you understand where they diverge.
12. How does NOI roll up across the portfolio? #
NOI per property = gross rental income minus operating expenses (everything except debt service, depreciation, and capex). Portfolio NOI is the sum across properties. Portfolio cap rate uses portfolio NOI divided by portfolio market value. The aggregation is mechanically simple but two definitional issues trip people up.
First, what counts as an operating expense versus capex versus debt service. Be consistent across properties; if you exclude HVAC replacements from operating expenses on property A and include them on property B, the per-property NOIs are not comparable. Second, vacancy treatment: some operators report NOI on actual collected rent (which already reflects vacancy), others report on potential rent and subtract vacancy explicitly. Pick one method and apply it everywhere. The cash flow and NOI hub goes deeper on the formula and common pitfalls.
13. How do I track vacancy across the portfolio? #
Two vacancy metrics are useful at portfolio level. Physical vacancy: vacant units divided by total units, expressed as a percentage. Economic vacancy: rent lost (vacancy plus delinquency plus concessions) divided by gross potential rent, also as a percentage. Economic vacancy is the more honest number because it reflects all the ways rent fails to materialize, not just unoccupied units.
At portfolio level, weight by units (not by property) so a 4-unit building with one vacancy contributes more to vacancy than a single-family with no vacancy. Track rolling 3-month and trailing 12-month averages to see trends; a single bad month is noise, three bad months is a pattern. Compare your vacancy to local market benchmarks; running 8% in a 4% market means something is wrong with your screening, pricing, or property condition that you can fix before it becomes a real cash-flow problem.
14. How do I track loans and debt service across the portfolio? #
Maintain a loan ledger with one row per loan: lender, loan amount original, current balance, interest rate, monthly P&I, escrow components (taxes and insurance), maturity date, prepayment penalty terms, and the property the loan is secured against. Recompute the current balance from the most recent mortgage statement at least quarterly; amortization tables drift from actual balances when extra principal payments are made.
At portfolio level, three numbers matter: total monthly debt service (across all loans, including escrow), weighted-average interest rate (rate-weighted by current balance), and maturity timeline (how much debt comes due in the next 1, 3, 5, and 10 years). The maturity timeline is the early-warning system for refinance risk. A portfolio with $1M of debt all maturing in 2027 has a very different risk profile than one with the same $1M staggered evenly over 10 years.
15. How do I track capital expenditures separately from operating expenses? #
Capex (capital improvements) capitalize and depreciate; operating expenses deduct in the current year. The portfolio P&L should separate them clearly so you can see cash going out the door even when it does not affect taxable income. A property may show $20,000 of taxable income while spending $35,000 on a new roof, leaving you cash-negative even though Schedule E looks fine.
Maintain a per-property capex log: date, vendor, amount, what was replaced, what is the expected useful life. The log feeds the depreciation schedule (each capex item starts its own MACRS schedule) and informs your reserves planning (knowing your roof has 10 years of life remaining tells you when to start setting cash aside). At portfolio level, total capex per year tells you what the real-world reserve requirement is, which usually exceeds the textbook 5% to 10% of rent allowance and explains why properties with strong NOI on paper still drain cash.
16. How do I identify refi candidates from the portfolio view? #
Run an annual filter. For each property, compute current ROE (annual cash flow divided by current equity). Sort the portfolio from lowest ROE to highest. Properties at the bottom of the list are refi candidates because the equity sitting there earns the lowest return. Then layer on extractable equity (current value at 75% LTV, minus current loan balance) to see how much capital each candidate would actually free.
The decision is not automatic: refinancing increases debt service, which reduces cash flow on that property. The math works when the freed capital can earn more in the next deal than the cost of the additional debt service on the refi. A property with $80,000 of extractable equity and a 4% ROE is a strong candidate if you can deploy $80,000 into a new acquisition at 12% cash-on-cash. If the next deal is 6%, the math is closer and the friction (closing costs, appraisal, time) may not justify it.
17. How do I identify properties that should be sold? #
Three signals together: persistent negative or marginal cash flow despite a fair rent, significant deferred capex relative to property value, and ROE that has decayed well below portfolio average even after considering refinance options. Any one signal alone is not a sell decision. All three together usually is.
Fourth optional signal: the property is in a market where you have no information edge and managing remotely costs disproportionate time. A property that drains 30% of your management attention while contributing 5% of portfolio cash flow is a sell candidate even if the math otherwise looks acceptable. Calculate the after-tax exit (capital gain plus depreciation recapture, possibly deferred via 1031), then compare to holding for another year. The portfolio gets stronger faster when you concentrate capital in your best properties; pruning is part of compounding.
18. What changes in portfolio reporting as I scale from 5 to 50 doors? #
At 5 doors most operators run the portfolio from a spreadsheet plus their head. At 15 doors the spreadsheet starts to lag, transactions get miscategorized, and PM statements pile up unreconciled. At 30+ doors the operator either professionalizes the reporting stack (dedicated software, virtual bookkeeper, monthly close routine) or starts losing money to operational drag (missed deductions, overlooked vacancies, late refis on rate-locked loans).
The transitions are usually painful. The first hire is typically a virtual bookkeeper for $300 to $800 per month who handles transaction categorization and monthly reconciliation. The second is moving off spreadsheets onto purpose-built software (DoorVault, REI Hub, or QuickBooks plus serious customization). The third is potentially a part-time portfolio analyst or asset manager who runs the quarterly review and surfaces refi or sell candidates. Most plateaus at 5 doors are not capital-driven; they are reporting-driven.
19. How do I track properties across multiple states? #
Properties in different states usually live in different LLCs (one per state, sometimes multiple per state) and have different state tax filings, different state-level expenses, sometimes different management arrangements, and different local market dynamics. The portfolio reporting layer should be state-agnostic for the operating numbers (cash flow, NOI, ROE) so you can compare apples to apples, but state-aware for tax filings and any state-specific compliance items.
Two reports help. The state breakdown: properties by state, NOI by state, cap rate by state, vacancy by state. This tells you which markets are pulling weight. The state tax calendar: each state's annual report deadline, franchise tax due date, state income tax filing deadline. Missing a state filing because you forgot you had an LLC there carries penalties. Most multi-state operators benefit from one CPA firm that handles all states (rather than a different CPA per state) so the consolidated picture stays coherent.
20. What red flags should I watch for in portfolio P&L? #
Six recurring red flags. First, growing accounts receivable from a property manager (rents collected but not disbursed). Second, repair line items consistently above 12% to 15% of rent on stabilized properties (suggests deferred capex misclassified as repairs). Third, vacancy creeping above market on a property that previously rented quickly (suggests the property is becoming undesirable). Fourth, declining net cash flow per property year over year despite stable or rising rents (suggests operating cost creep).
Fifth, debt service approaching gross rent (DSCR below 1.10 on a stabilized property is a warning). Sixth, capex that never seems to end (multiple major capex projects per year suggests the property is in worse condition than acquisition assumed). Build a per-property dashboard that flags these automatically rather than relying on memory; portfolios get into trouble quietly, and the red flag almost always shows in the books months before it shows in cash.
21. How do I know when the portfolio can absorb another acquisition? #
Three readiness checks. First, current portfolio cash flow comfortably covers personal living expenses plus a meaningful reserve buffer; you are not depending on the new acquisition to be cash-positive immediately for personal cash flow. Second, you have identified deployable capital (extractable equity from refis, savings, or partner capital) sufficient to fund the down payment, closing, rehab, and a 6-month operating reserve on the new property. Third, the existing portfolio is operationally stable: PM relationships are working, vacancy is low, and you are current on all reconciliation and reporting.
Adding doors when any of these three are weak compounds problems rather than capital. A portfolio with two properties already running into reconciliation issues will not magically reconcile better with three. Fix the operations layer before adding more doors. The portfolio review is what tells you whether you are actually ready or just feeling acquisitive.
22. How much of portfolio reporting can be automated? #
More than most operators realize. Bank feeds pull transactions automatically. Document AI reads PM statements, closing disclosures, mortgage statements, insurance declarations, and 1098s and posts the data without manual entry. Reconciliation engines compare bank activity to PM statements and flag mismatches. Dashboards compute cash flow, ROE, capital velocity, and vacancy in real time from underlying transaction data.
What still requires human judgment: categorizing ambiguous transactions (was that $4,200 a repair or a capital improvement), interpreting unusual items (a one-time legal fee, a tenant settlement), making capital allocation decisions (refi or sell), and reviewing the AI's work to catch the rare miscategorization. The right model is AI handles the data plumbing so you focus on the strategic decisions. DoorVault's Knox AI runs this loop continuously; the operator reviews and approves, then makes the calls. Manual spreadsheet maintenance is increasingly indefensible above 3 properties.