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.