Portfolio reports that build themselves.
The reports your asset management meeting runs on, built once from every system and manager and kept current, so the month starts with review instead of rebuilding.
The portfolio report pack
Each report is a table you can open in Excel or Power BI, ask about, or share with your team.
Budget vs actual, property by property
Every property's operating statement on one chart of accounts, against budget and the trailing twelve months, so variance starts with the answer.
Property operating statement
Property · Period · Account group · Actual · Budget · Variance · Variance % · Trailing 12 · Prior year · NOI
From the GL in Yardi, MRI or your accounting system, the property budgets, and third-party manager packages.
Rent roll and lease expirations
Every lease in the portfolio in one rent roll, with the expirations and rent at risk over the next twelve months.
Portfolio rent roll
Property · Unit or suite · Tenant · Square feet · Lease start · Lease end · Monthly base rent · Market rent · Status · Expires within 12 months
From leases in your property management systems, with market rents from the data you subscribe to.
Occupancy, leasing and delinquency
Physical and economic occupancy, leasing velocity, renewals and delinquency by property every week, not just at month end.
Occupancy and delinquency trend
Property · Week · Physical occupancy · Economic occupancy · Leased % · Move-ins · Move-outs · Renewals · Delinquency
From Yardi, Entrata, ResMan, AppFolio or Rent Manager.
Fund roll-up
Property results rolled up to each fund and investor vehicle, for quarterly investor updates.
Fund performance
Fund · Quarter · Properties · NOI · Budget NOI · Occupancy · Underwritten NOI · Distributions
From property financials in your property management systems and fund data in Juniper Square.
Delinquency and receivables
What every tenant owes, how old it is and how it is trending, property by property.
Aged receivables
Property · Tenant · Current · 31 to 60 days · 61 to 90 days · Over 90 days · Total owed · Last payment
From charges and receipts in Yardi, MRI, Entrata, ResMan or AppFolio.
Manager package tracker
Which third-party managers have submitted each month's package, and which accounts did not map.
Close package status
Property · Manager · Period · Submitted · Unmapped accounts · Out-of-balance amount · Reviewed
From manager workbooks and property GLs, checked against your chart of accounts.
Questions the reports answer
- Which properties are more than 5% behind budgeted NOI year to date?
- What is the weighted average lease term across the office portfolio?
- How much rent expires in each of the next eight quarters?
- Which properties have the highest delinquency this month?
- How does each fund compare to underwriting on NOI and occupancy?
Report questions
Can we change how NOI or occupancy is defined?
Yes. The tables use your definitions, and we update them when your definitions change.
Do the reports cover multifamily and commercial?
Yes. Unit-based and square-foot-based properties report side by side, each with the measures that fit it.
Bring last month's portfolio report
We will show you the same report built from your own systems.