Property Portfolio Reporting

Portfolio numbers people can rely on: one property list, agreed KPI definitions, a consolidated rent roll, arrears, occupancy, debt and valuation schedules, and a quarterly pack for partners or lenders that goes out on time.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Property Portfolio Reporting, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help your team organise its work. It is not legal advice, and following it does not make anyone your organisation's lawyer. Rules differ between countries and change often, so check decisions that matter, and anything your organisation signs, with a qualified lawyer or the official authority in the country concerned.

What it installs.

1

Pillar

1

Area

50

Projects

200

Starter tasks

🏢 Real Estate Investing & Development

Property Portfolio Reporting

Reporting across a property portfolio: rent rolls, arrears, occupancy, debt maturities, valuations and a quarterly pack for partners or lenders.

  1. Master property list for the portfolio
  2. Reporting audience and requirements map
  3. Portfolio KPI definitions sheet
  4. Consolidated rent roll template
  5. Source data inventory and owners
  6. Annual reporting calendar
  7. Common chart of accounts across properties
  8. Report folder structure and version rules
  9. Choosing portfolio reporting software or a spreadsheet
  10. Baseline portfolio snapshot
  11. Monthly rent roll to bank reconciliation
  12. Weekly arrears and aged debt review
  13. Monthly occupancy and vacancy report
  14. Property manager report intake check
  15. Debt maturity and rate reset ladder
  16. Quarterly covenant compliance tracker
  17. Quarterly partner and lender reporting pack
  18. Monthly portfolio close
  19. Valuation register and schedule
  20. Lease event calendar for reporting
  21. Budget versus actual variance commentary
  22. Reporting data issue log
  23. Physical and economic occupancy explained
  24. NOI to cash flow bridge
  25. WAULT and lease expiry profile reporting
  26. Reading loan reporting and covenant clauses
  27. Pulling reporting figures from a valuation report
  28. Spreadsheet controls for portfolio reports
  29. Charts that show portfolio performance clearly
  30. Automating bank and rent roll imports
  31. One-page portfolio dashboard
  32. Shortening the quarterly reporting cycle
  33. Standard reporting requirements for property managers
  34. Materiality thresholds and restatement rule
  35. Four-eyes review and sign-off
  36. Year-end portfolio report and accountant handover
  37. Lender annual review submission
  38. First quarterly pack for a new partner
  39. Reporting through a covenant near-miss
  40. Reporting handover when changing property manager
  41. Annual valuation round coordination
  42. Reporting for a small owner-run portfolio
  43. First 90 days as a portfolio reporting analyst
  44. Multi-currency portfolio reporting
  45. Reporting a mixed residential and commercial portfolio
  46. Entity and look-through reporting across SPVs
  47. Total, income and capital return measurement
  48. Sustainability and energy data in the portfolio pack
  49. Aligning reports with an industry reporting guideline
  50. Buyer or refinance data pack from reporting records

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Master property list for the portfolio

Every later report depends on one agreed list of what the portfolio actually owns, and many owners discover that the bank, the accountant and the property manager each count it differently. A master list with one row per property, its owning entity, unit count, lettable area, purchase date and lender becomes the spine that every rent roll and schedule hangs from.

First tasks

  • Start a sheet with one row per property and columns for code, entity and address
  • Fill in units, lettable area and acquisition date from completion documents
  • Add the lender, property manager and insurer against each property
  • Compare the list with the accountant's fixed asset register and resolve gaps

Reporting audience and requirements map

Partners, lenders, the accountant and the tax authority all want portfolio information, but each wants a different cut, on a different date, under different rules. Mapping who receives what, how often and under which agreement stops you building one oversized report that pleases nobody and missing the one deliverable a loan agreement actually requires.

First tasks

  • List every person or institution that receives numbers about the portfolio
  • Pull the reporting clauses from each loan and partnership agreement
  • Record content, frequency and deadline for each recipient in one table
  • Mark which outputs can share the same underlying data

Portfolio KPI definitions sheet

Occupancy can mean units let, area let or rent collected, and arrears can include or exclude deposits and disputed charges, so two honest people can report different numbers from the same building. Writing one definition per KPI, with its formula and exclusions, makes the numbers comparable across properties and across quarters.

First tasks

  • List every KPI that currently appears in any portfolio report
  • Write a formula and exclusions for each in plain language
  • Copy lender covenant definitions verbatim beside your own
  • Send the sheet to the property manager and ask for questions

Make it yours.

Install Property Portfolio Reporting, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.