Ask any landlord with five or more rental properties what their portfolio LTV is right now. Most can’t tell you within 60 seconds. They can tell you their rents, their PMs, and roughly what each property cash flows. The debt side of the balance sheet is the part that lives in five or six different servicer portals, each with its own login, each with its own statement format, each pretending it’s the only loan you have.
That’s the operational hole most rental tracking tools never fill. They show you income. They show you expenses. They might even show you NOI. But ask them “what is my total debt, what is my weighted average rate, and how much principal am I paying down across my entire portfolio this year,” and you get a list of properties with monthly payments next to them. That’s not a loans dashboard. That’s a spreadsheet column.
A real rental property loans dashboard is the operational system that consolidates every mortgage, every escrow split, every LTV, and every debt-paydown trajectory into one view. It treats your loans the way a portfolio treats its assets: as a system, not as a list. And on a 10-door portfolio with a mix of conventional loans, DSCR loans, and a recently refinanced BRRR deal, the difference between having that system and not having it is the difference between making refinance decisions on facts and making them on memory.
What a Rental Property Loans Dashboard Should Actually Show
Most “loans” features inside rental tracking tools were built as an afterthought. The product started as an income tracker, then added expenses, then bolted on a loans section because users asked for it. The result is usually a property-by-property list with the loan amount, the rate, and the monthly payment. That’s table-stakes data. It tells you nothing about your portfolio.
A real loans dashboard answers six questions at the portfolio level before you click into any single property:
- What is my total debt across every property?
- What is my weighted average interest rate, and how does it compare to current market rates?
- What is my portfolio LTV, calculated against the latest property values I have on record?
- How much principal will I pay down over the next 12, 24, and 60 months at my current schedule?
- How much am I sending to escrow every month, split between tax escrow and insurance escrow?
- Which properties are inside the refinance-readiness window right now?
If your current setup can’t answer those six questions without a calculator and 20 minutes, your loans tracking is broken. Not because the loans are broken. Because the system around them is.
The Six KPIs That Matter at the Portfolio Level
The DoorVault Loans Dashboard surfaces these six KPIs the moment you open it, recalculated automatically every time a mortgage statement is processed.
Total debt is the sum of every current loan balance across every property, every entity, every state. This is your real liability picture. Not the original loan amounts. The current balances, after every payment Knox has applied this year.
Monthly PITI breakdown splits your total monthly mortgage outflow into principal, interest, tax escrow, and insurance escrow. This is the most underrated portfolio metric in rental investing. Most landlords know their total monthly mortgage payment but can’t tell you the split. That split is exactly what Schedule E needs at year end, and what your cash-flow analysis needs every month.
Weighted average rate weights each loan’s rate by its current balance. A $90,000 loan at 7.5% and a $250,000 loan at 6.2% don’t average to 6.85%. They weight closer to 6.55% because the bigger balance pulls harder. The dashboard does this math live so you know your real portfolio cost of capital.
Portfolio LTV compares your total debt against your total property value (latest ARV or appraisal on record). This is your headline borrowed-against-equity number. It’s also the number every lender will ask you about the next time you walk in to refinance or pull cash out.
5-year debt paydown projection plots the principal you’ll knock off in years 1 through 5 at your current schedule, with no prepayments. This is the slow wealth engine of rental investing, and most landlords have no idea what their actual principal-paydown rate is across the portfolio.
Refinance-ready property count flags every property where the seasoning period is past, the LTV is below the lender’s cash-out cap, and the property is current on payments. This is the operational signal that tells you which deals are ready to recycle capital out of.
Still logging into 5 servicer portals to figure out your debt picture? There’s a better way. → https://doorvault.app
The 31 Fields Inside Every Loan Record
Portfolio-level KPIs are powered by the depth of each individual loan record. Most rental tools track maybe 6 to 8 loan fields per property: loan amount, rate, term, monthly payment, lender, and a note field. That’s enough to make a list. It is not enough to refinance.
The DoorVault loan record tracks 31 fields per loan. The ones that matter for portfolio decisions:
- Loan type (conventional, DSCR, hard money, seller financing, HELOC, commercial)
- Originator and current servicer (these are often different after a loan sale)
- Original balance and current balance
- Rate, rate type (fixed vs ARM), and ARM reset date if applicable
- Term in months, remaining term, and maturity date
- P&I, tax escrow component, insurance escrow component, mortgage insurance component
- Prepayment penalty terms and prepayment penalty expiration
- Balloon date (if any)
- LTV at origination and current LTV
- DSCR at origination (for DSCR loans this matters at refi, the lender wants to see the property still covers)
- Interest-only period (if any) and IO end date
These are the fields a lender’s underwriter actually asks for when you call about a refinance. Most investors have to dig them out of a closing disclosure stored in a Dropbox folder, then call the servicer to confirm the current balance. The whole exchange takes 45 minutes per property. On a 10-door portfolio that’s 7.5 hours of work to put together one refinance package. With the loan record sitting in the dashboard already populated, that work is approximately zero.
How Knox Reads Your Mortgage Statements and Keeps the Dashboard Live
The dashboard isn’t useful if you have to type all 31 fields in for every loan. That’s the trap most landlord software falls into: great data structure, terrible data entry.
This is where Knox Intelligence does the work. Knox Intelligence is AI that proposes, learns, and never touches your data without permission. It powers the loans dashboard the same way it powers the rest of DoorVault: by reading your documents.
Forward your closing disclosure to your Knox inbox when you close on a property. Knox extracts the loan type, the originator, the servicer, the original balance, the rate, the term, the prepayment penalty terms, the balloon date, every escrow component. The loan record builds itself in about 30 seconds.
Every month after that, forward your mortgage statement (or sync your servicer email automatically). Knox reads the statement, extracts the new current balance, the principal applied, the interest paid, the escrow disbursements, and the next-due date. Your loan record updates. The portfolio dashboard recalculates. Total debt drops by the principal paid. Weighted rate adjusts. Debt-paydown projection rolls forward another month.
You have two options for how that update reaches the dashboard. With Trust Knox ON, Knox applies the updates instantly. With Trust Knox OFF, Knox proposes the changes and waits on the Batch Review page until you approve them. The same AI runs both modes. You choose the control surface. Every change Knox makes is logged in the Activity Log with a before-and-after snapshot, and any single field is one click away from a revert.
This is the difference between a static spreadsheet and a live operational system. The dashboard is never stale because the underlying data feeds itself.
Pairing the Loans Dashboard with Equity (the Other Half of the Balance Sheet)
Debt is half of the balance sheet. Equity is the other half. A loans dashboard without an equity tracker is a permanent half-picture.
The Equity Tracker sits next to the Loans Dashboard inside DoorVault. It pulls each property’s latest value (purchase price, last appraisal, or current ARV depending on what you’ve recorded most recently) and subtracts the current loan balance to surface real-time equity per property. It calculates current LTV per property and rolls up to portfolio LTV. It runs refinance scenarios at common LTV caps (70%, 75%, 80%) and tells you how much cash you could pull out of each property today at each scenario, after closing costs.
This pairing matters most when you’re making the sell-or-refinance decision on a specific property. If the loans dashboard tells you the rate is 7.8% and the balance is $89,000, the equity tracker can immediately model what happens if you refinance at today’s DSCR rates against an updated ARV. You see the new payment, the cash out, the new DSCR coverage, and the new principal-paydown trajectory side by side. You make the call with numbers, not vibes.
What This Looks Like Across 10 Doors and Mixed Loan Types
A real-world picture from a 10-door portfolio: 4 Section 8 properties in Birmingham, 4 conventional rentals in Florida, 1 in South Carolina, 1 in Alabama outside of Birmingham. The debt mix is messy on purpose, the way real portfolios are. Two conventional 30-year mortgages from the early-FL purchases. Three DSCR loans across the BRRR Section 8 deals after refinance. One HELOC on the primary that funded an acquisition. One seller-financed note on a property bought at a discount. One recently refinanced conventional that flipped to a DSCR.
Across that mix, the portfolio numbers a typical investor would have to assemble manually from 5 different servicers:
- Total debt: $1.04M across 8 loans
- Weighted average rate: 7.05% (pulled by the higher-rate DSCR loans, offset by the lower-rate original conventionals)
- Portfolio LTV: 64% against the latest ARVs on record
- Monthly PITI: $9,180 portfolio-wide, split into $1,720 principal, $5,840 interest, $1,140 tax escrow, $480 insurance escrow
- 12-month principal paydown projection: roughly $21,400
- Refinance-ready count: 2 properties past seasoning, current LTV below 70%, no prepayment penalty in effect
Pulling those six numbers manually used to take a Saturday morning, 5 servicer logins, and a hand-built spreadsheet. With the dashboard, they’re visible the moment the screen loads, and they’re current to the last mortgage statement Knox processed. The Saturday morning is gone. The decisions are better.
Three Questions to Ask About Your Current Loan-Tracking System
If you’re trying to decide whether your current setup is good enough, answer these three questions out loud.
1. Can you tell me your weighted average interest rate right now without opening a calculator? Most landlords can’t. A loans dashboard exists so you don’t have to.
2. If a lender asked you for your portfolio LTV in this morning’s email, how long would it take to send back a credible number? If the honest answer is “more than 5 minutes,” that’s the gap. Refinance velocity dies in the data-collection step.
3. The last time you refinanced a property, how long did it take to put the lender package together? If it was more than an hour per property, your loan records aren’t structured. They’re scattered. A 31-field loan record built from your closing disclosure on day one means the lender package is one PDF export away on day 180.
If any of those answers landed wrong, the loans side of your portfolio is running on memory. That’s the gap a loans dashboard exists to close.
See your full portfolio debt picture in 60 seconds → https://doorvault.app
