Reporting specification and open dataset
Make the monthly report a board decision tool.
Lead with what changed, what is late, what requires direction, and what evidence supports the recommended next action.
Quick answer
Start with decisions and exceptions, then show the operating evidence.
A useful report lets a director understand the current position, trend, cause, consequence, accountable owner, and decision deadline without searching across emails or unexplained attachments.
Use consistent definitions and source systems from month to month. Restate prior figures visibly when the basis changes, label estimates, and link to detailed schedules instead of crowding the core report with raw transactions.
40 report linesDefined with sources and warning signs
14 sectionsFrom decisions through data quality
1 page firstExecutive decisions and exceptions
Reporting cycle
Move from close to decision in six steps.
- CloseComplete reconciliations, interfaces, accruals, work-order updates, contract logs, and project status inputs on a defined timetable.
- ValidateCheck completeness, cut-off, changed definitions, duplicate entries, unsupported status claims, and exceptions to source quality.
- ExplainIdentify the driver, impact, trend, uncertainty, and likely next condition behind each material variance or exception.
- DecidePlace required approvals and directions first, with the deadline, alternatives, recommendation, and consequence of waiting.
- AssignRecord the owner, due date, next proof point, and escalation rule for every accepted follow-up.
- LearnCompare forecast with outcome and revise thresholds, definitions, controls, or operating assumptions where evidence warrants it.
Filterable report specification
Choose the lines that explain performance and support action.
Use the library as a design reference. The final report should reflect the property’s contracts, asset profile, service model, budgets, systems, risk profile, projects, and board responsibilities.
40 report lines shown
| Section and measure | Definition and source | Owner and reporting rule | Decision and warning sign |
|---|---|---|---|
| Executive summaryTop five decisions required | Ranked list of approvals or directions needed before the next cycleSource: Open decision register; project and contract calendars | Property managerLead the report with decision deadline and consequence | What must the board decide now?Warning: Material issue described without a decision request |
| Executive summaryMaterial changes since prior report | New facts assumptions risks or commitments that affect approved plansSource: Change logs; meeting actions; incident reports | Property managerState what changed why and the downstream effect | Which approved plan needs adjustment?Warning: Change appears only inside a detailed section |
| Executive summaryOverdue commitments | Board management and vendor actions past their agreed dateSource: Action register | Property managerShow owner original date revised date and recovery plan | Which delay requires escalation?Warning: Date repeatedly moves without cause or control |
| FinanceOperating budget variance | Actual revenue and expense compared with phased budgetSource: General ledger; adopted budget | ControllerExplain material month and year-to-date variance | Is corrective action or forecast change required?Warning: Large variance lacks driver and owner |
| FinanceCash position and 13-week outlook | Available unrestricted cash and forecast receipts and paymentsSource: Bank statements; cash forecast | ControllerSeparate restricted funds and show low point | Can approved commitments be funded when due?Warning: Forecast minimum approaches operating threshold |
| FinanceBank reconciliation status | Age and completion status of every account reconciliationSource: Bank reconciliations | ControllerReport unreconciled items by age and value | What blocks a complete close?Warning: Prior month remains unreconciled |
| FinanceAssessment receivables aging | Outstanding owner balances by aging band and process stageSource: Accounts receivable ledger | ControllerShow trend recoveries disputes and material concentrations | Does policy or legal follow-up need direction?Warning: Older balances or disputes increase |
| FinanceAccounts payable aging | Approved and disputed obligations by due-date bandSource: Accounts payable ledger | ControllerSeparate held disputed and scheduled payments | Which obligation may incur cost or service risk?Warning: Past-due critical vendor invoice |
| FinanceReserve activity | Contributions expenditures transfers and restricted balancesSource: Reserve ledger; bank records | ControllerReconcile to approved plan and project coding | Does any use require approval or correction?Warning: Unexplained transfer or miscoded project spend |
| FinanceForecast at completion | Updated annual result using current run rate and known changesSource: General ledger; commitments; forecast model | ControllerShow base case and material assumptions | What action protects the year-end position?Warning: Forecast changes without an assumption log |
| OperationsOpen work orders | Count and age by priority asset and responsible partySource: Work-order system | Chief engineerShow oldest critical and repeat items | Where is capacity or vendor support failing?Warning: Emergency or high-priority item exceeds standard |
| OperationsPreventive maintenance completion | Due tasks completed within the approved windowSource: Maintenance system; service logs | Chief engineerReport numerator denominator and verified exceptions | Which missed task creates the greatest risk?Warning: Completion rate hides deferred critical assets |
| OperationsRepeat failure rate | Assets or locations with repeated corrective workSource: Work-order history | Chief engineerGroup repeat incidents by root cause | Should repair strategy or capital plan change?Warning: Same failure returns after claimed completion |
| OperationsInspection deficiencies | Open findings by severity owner and due dateSource: Inspection reports; corrective log | Property managerShow evidence needed for closure | Which finding needs professional or board action?Warning: High-severity item lacks interim control |
| OperationsUtility use exception | Material change from weather-normalized or operational baselineSource: Utility bills; meters; occupancy data | Property managerExplain cause confidence and corrective action | Is there a leak failure or billing error?Warning: Spike continues for two cycles |
| VendorsService-level exceptions | Missed contractual standards and required remediesSource: Contracts; service logs; inspections | Property managerTie every exception to clause evidence and response | Does the board need to enforce or reconsider the contract?Warning: Exception repeats without written correction |
| VendorsContract calendar | Renewal termination escalation and pricing windowsSource: Contract register | Property managerShow next 180 days and preparation lead time | Which decision window is narrowing?Warning: Notice date within 45 days without direction |
| VendorsInsurance and license status | Current required evidence for active providersSource: Vendor files; official verification | Property managerReport expired missing or exception-approved items | Can work continue under current controls?Warning: Critical vendor evidence has expired |
| VendorsInvoice exception log | Charges outside scope rate approval or evidence standardSource: Invoices; contracts; purchase orders | ControllerShow value disposition and recurrence | Is a control or contract clarification needed?Warning: Same exception appears across billing cycles |
| StaffingCoverage and vacancies | Filled roles vacancies leave overtime and critical coverageSource: Schedules; payroll; staffing plan | Property managerConnect gaps to service and cost effects | What support or hiring decision is required?Warning: Critical shift depends on recurring overtime |
| StaffingTraining and certification status | Required and planned learning by roleSource: Training records; certification files | Property managerShow expiring and overdue items | Which gap limits safe or authorized work?Warning: Required credential expires before renewal |
| ResidentsOpen resident commitments | Published or direct commitments not yet completedSource: Request system; communication log | Property managerReport age owner and next promised update | Which commitment needs escalation or correction?Warning: Resident receives no update by promised date |
| ResidentsService request themes | Recurring request categories locations and root causesSource: Request and work-order systems | Property managerDistinguish volume from repeat unresolved issues | What operational change would reduce recurrence?Warning: Volume rises while closure appears stable |
| ResidentsMaterial communication calendar | Planned notices for work decisions interruptions and eventsSource: Communication plan; project calendar | Property managerShow audience channel owner approval and send date | What must be approved before release?Warning: Operational change lacks advance message |
| RiskTop property risks | Highest residual risks and movement since prior reportSource: Risk register | Property managerShow control status trend and next review | Which risk needs treatment or acceptance?Warning: Risk score falls without new evidence |
| RiskIncident and near-miss summary | Events with impact response learning and open actionsSource: Incident log | Property managerProtect sensitive details while preserving decision facts | What control should change?Warning: Near misses recur without analysis |
| RiskEmergency readiness exceptions | Gaps in contacts supplies vendors authority systems or exercisesSource: Emergency plan; test logs | Property managerReport only actionable exceptions and resolution dates | What readiness gap requires resources?Warning: Critical contact or backup channel untested |
| InsuranceClaims status | Open notices claims estimates reserves requests and next milestonesSource: Claims log; carrier correspondence | Risk leadState owner deadline evidence and coverage uncertainty | What decision preserves the claim position?Warning: Carrier request or limitation date approaching |
| InsuranceRenewal readiness | Progress against the renewal evidence and market timelineSource: Renewal plan; broker requests | Risk leadBegin 120 to 150 days ahead where practical | Which missing item weakens market readiness?Warning: Submission deadline approaches with incomplete data |
| ProjectsProject portfolio status | Budget schedule scope risk and decision status for active projectsSource: Project controls | Owner representativeUse approved baselines and forecast at completion | Which variance requires board direction?Warning: Green status conflicts with late milestone or cost growth |
| ProjectsChange-order status | Submitted pending approved and rejected changesSource: Change log; contracts | Owner representativeShow cause value schedule effect and authority | Which change must be decided before work proceeds?Warning: Work proceeds on unsigned change |
| ProjectsPayment and retainage status | Applications reviewed paid held or disputedSource: Pay applications; certifications | ControllerTie payment to verified progress and required releases | Is any payment blocked or premature?Warning: Requested progress exceeds observed completion |
| ComplianceRecurring obligations | Upcoming filing notice inspection and policy datesSource: Compliance calendar | Property managerShow verified source owner and lead time | Which obligation enters its action window?Warning: Date lacks current source or accountable owner |
| RecordsRecords requests and production | Requests received response stage exceptions and completionSource: Request log; delivery evidence | Records custodianReport timeliness and issues without exposing sensitive content | What resource or advice is required?Warning: Deadline is close or responsive set is uncertain |
| RecordsDocument control exceptions | Missing duplicate obsolete or inaccessible authoritative recordsSource: Records inventory; access logs | Records custodianShow affected decision and recovery owner | Which gap prevents a defensible decision?Warning: Only copy depends on one person or device |
| TechnologyAccess review exceptions | Dormant excessive shared or unassigned system accessSource: Identity and access records | Technology leadReport material exceptions and removal confirmation | Which access should be revoked or changed?Warning: Departed user or vendor still has access |
| TechnologyBackup and recovery evidence | Successful protected backup and tested restore for critical recordsSource: Backup logs; restore test | Technology leadReport last successful test and unresolved failure | Can the association recover its critical records?Warning: Backup exists but restore is untested |
| ManagementNext-month priorities | Limited set of outcomes with owners dates and proofSource: Operating plan; board calendar | Property managerEnd with measurable deliverables | Are priorities realistic and decision-aligned?Warning: List contains activities without outcomes |
| ManagementBoard action requests | Consolidated approvals directions and information neededSource: Entire report | Property managerRepeat each request with deadline and attachment reference | Can each request be acted on without searching?Warning: Request is buried or lacks supporting evidence |
| QualityReport data confidence | Known limitations late feeds estimates and changed definitionsSource: Source systems; close checklist | Property managerLabel estimates and restatements visibly | What uncertainty could change the decision?Warning: Metric presented as precise despite incomplete source |
Board-readable reporting
Make the exception understandable in one view.
PositionShow the current measure, period, baseline, trend, threshold, and confidence in the source data.
MeaningExplain the cause, operational or financial effect, and what could worsen if no action is taken.
ActionState the recommendation, authority required, owner, date, cost or tradeoff, and next proof point.
The reporting specification supports oversight. Accounting treatment, legal duties, technical conclusions, insurance matters, and property-specific decisions require appropriate current records and qualified advice.
Quality controls
Keep definitions stable and uncertainty visible.
A metric can improve because operations improved, or because its definition, denominator, timing, or source changed. Maintain a data dictionary and a change log so directors can distinguish performance from measurement drift.
Show missing inputs, estimates, restatements, and disputed facts beside the affected item. A confident-looking dashboard built on incomplete evidence creates worse decisions than a transparent exception.
Pre-issue review
- Do totals reconcile to their authoritative sources?
- Are period and cut-off consistent?
- Are material variances explained?
- Are estimates and changed definitions labeled?
- Do status colors match their thresholds?
- Can each requested decision be acted on now?
Open download
Define the management report before automating it.
The CSV sets out report lines, definitions, sources, owners, reporting rules, decision questions, and warning signs. Add property thresholds, calculation formulas, delivery dates, system links, reviewers, and board-approved exceptions.
Available format
CSV40 rows · spreadsheet-readyVersion September 21, 2026 · UTF-8 · reporting frameworkFrequently asked questions
Monthly reporting questions.
What should a monthly property management report include?
Lead with decisions, material changes, overdue commitments, and exceptions, then support them with consistent finance, operations, vendor, staffing, resident, risk, insurance, project, compliance, records, and technology reporting.
How long should the report be?
Keep the core report as short as possible while preserving the evidence needed for decisions. Use linked schedules and authoritative source records for transaction-level detail.
How should status colors be used?
Define every status against objective thresholds and show the measure and trend. A color should never replace the cause, owner, due date, or decision required.
Who owns the report?
The property manager normally coordinates the report, but each source and explanation needs a named data or operating owner. The board should approve the information needed for oversight and the cadence for resolving exceptions.