Real estate portfolio reporting software Kenya property companies use should convert daily leases, invoices, receipts, expenses, maintenance and occupancy events into decisions. A useful report does not merely display attractive charts. It defines each metric, reconciles to source records, separates owners and properties correctly, explains exceptions and reaches the right audience on schedule.
Professional managers often lose time assembling reports rather than analysing them. Each branch submits a different spreadsheet. Occupancy is calculated using inconsistent denominators. One report uses billed rent while another uses cash collected. Owner packs do not agree with finance control totals. Senior leaders spend the meeting debating which number is correct.
PMS.co.ke can be evaluated as the professional portfolio layer, while RentalDesk remains focused on daily rental operations. Buyers should verify the current reporting and integration capabilities in a live demonstration. This guide is an operational framework, not accounting, valuation, tax, investment or legal advice.
Why portfolio reporting fails even when data exists
Data can be abundant and still unreliable. Duplicate units distort occupancy. Old tenants remain marked active. Receipts are imported but not allocated. Property expenses lack owner or cost-centre tags. Lease dates are held in PDF files but not structured records. The dashboard then calculates precise figures from incomplete inputs.
The second failure is definition drift. “Collection rate” could mean cash collected this month divided by this month’s billing, cash allocated to the billing period, or all receipts divided by total outstanding. “Occupancy” can be measured by unit count, floor area or economic rent. None of those choices is automatically wrong, but mixing them makes comparisons meaningless.
The third failure is weak ownership. Finance produces cash and receivable figures, leasing produces occupancy, facilities produces work-order metrics, and property managers write commentary. Without a governed close, the pack becomes a collage rather than one portfolio story.
Establish a reporting hierarchy
The platform should reflect how the organisation manages assets:
Group or legal entity → owner or fund → portfolio → property → building or block → unit or space → tenancy.
Not every company needs every level, but the hierarchy should preserve owner and property separation. A single property can have several cost centres. One owner can hold several properties. An agency can manage assets for many unrelated clients. Reports should aggregate up without losing the ability to investigate down.
The existing property management for multiple owners guide describes the operational records beneath this reporting model.
Create a metric dictionary before a dashboard
| Metric | Definition questions | Source controls |
|---|---|---|
| Occupancy | By units, area or economic rent? At what date? | Unit status, area and lease-effective dates |
| Collection rate | Which billing and receipt period? Are credits excluded? | Approved invoices, allocations and reversals |
| Aged receivables | Age from invoice or due date? How are disputes shown? | Tenant ledger and documented classifications |
| Net operating income | Which revenue and operating costs are included? | Approved chart, property ledger and period close |
| Maintenance cost per unit | Completed, invoiced or paid cost? Which units? | Work orders, invoices and property allocation |
| Lease-expiry exposure | By area, rent or tenant count? Which options count? | Reviewed lease register and critical dates |
| Owner payout | Statement entitlement or actual transfer? | Client ledger, approval and payment reference |
| Budget variance | Actual, committed or forecast against which version? | Approved budget, expenses and commitments |
Publish the dictionary internally. Each metric should have an owner, calculation, cut-off, filters, exclusions and refresh frequency. A future change needs version control so trend lines are not reinterpreted silently.
Comparability also requires context. A residential block, shopping centre and office building may not share the same occupancy economics or maintenance profile. Keep the group definition stable, then allow authorised users to segment by asset type, geography, owner and lifecycle stage. Do not hide a weak property inside a favourable total. A portfolio result should show both the consolidated outcome and the concentration or dispersion that management needs to understand.
Core financial reporting
Portfolio financial reports commonly include billed rent, collections, aged receivables, property expenses, management fees, owner balances, payouts, deposits and operating performance. The exact statements depend on accounting policy and management agreements. The system should preserve the link between each summary and its detailed ledger.
Rent collected should reconcile to allocated receipts, not simply the bank total. Property expenses should carry supplier evidence and approval. Management fees should follow current agreements. Owner payouts should remain distinct from statement balances. The new client money accounting guide is designed as the supporting control pillar once published.
Rent roll and aged receivables
The rent roll should show active spaces, tenants, billing, receipts, balances and lease dates as of a defined cut-off. Aged receivables should split balances into agreed ageing bands and classify disputes, payment plans, unapplied cash and legal follow-up separately where policy requires.
Senior management needs trend and concentration: total arrears, percentage of billing, movement from prior month, top balances, days outstanding and recovery actions. An owner needs only their portfolio. A property manager needs the accounts assigned to them. Permissions and commentary should reflect those audiences.
See the established rent roll and aged receivables guide for the month-end source controls that make these reports credible.
Occupancy, vacancy and leasing performance
Occupancy reporting should identify physical and economic measures. A space can be occupied but under a rent-free period. A unit can be reserved but not handed over. A tenant can remain in occupation while renewal documents are pending. The report should use defined statuses rather than forcing every case into occupied or vacant.
Useful indicators include occupied units or area, economic occupancy, vacancy days, upcoming move-outs, enquiry-to-lease conversion, average void period and income lost to vacancy. Portfolio views should allow comparison without concealing property type and market context.
Lease-expiry and income-at-risk reporting
Commercial portfolios need expiry and break profiles by month, quarter and year. Reports can show affected area, current annualised rent, tenant concentration, review events and task status. This helps management prioritise renewals and forecast downtime.
The planned commercial lease management pillar should supply the governed lease data. The live commercial lease escalation article already explains specialist rent-review control.
Maintenance, facilities and asset reporting
A property dashboard should not measure only ticket count. Include response time, resolution time, overdue work, repeated faults, cost by asset or category, preventive-maintenance completion, contractor performance and tenant satisfaction where data quality permits.
Open tickets and unpaid supplier invoices are different measures. A job marked completed without evidence can distort response reporting. Set status definitions and required completion fields. High repair cost per unit may reflect an ageing asset, delayed preventive maintenance, poor procurement or incorrect allocation; commentary should identify the cause.
Service-charge budget and reconciliation reporting
For shared-cost properties, portfolio reports can show approved budget, actual and committed cost, forecast, variance, contribution billing, collections, evidence exceptions and reconciliation status. Senior management should see which properties risk a material year-end adjustment.
The new service charge reconciliation guide is intended to own that specialist intent once live. Reporting should aggregate its controlled calculations, not recreate them in a second spreadsheet.
Build different packs for different audiences
Owner pack
Opening balance, collections, arrears, approved expenses, management fee, payout, closing balance, occupancy, material maintenance and concise commentary for the owner’s properties.
Property-management operations pack
Tenant follow-ups, vacant units, lease tasks, open work orders, inspections, unresolved payment exceptions and approaching deadlines assigned to operational teams.
Executive portfolio pack
Portfolio trends, concentration risk, net operating performance, collection movement, occupancy, lease-expiry profile, maintenance exposure, budget variance and decisions required.
Board or investment-committee pack
Stable definitions, material variances, forecast scenarios, strategic risks, compliance status and management actions. Board reports should not drown decision-makers in unit-level detail, but every total should remain traceable.
One database can support these audiences without giving everyone the same report or access rights.
Use commentary and exception ownership
Numbers rarely explain themselves. A report should allow authorised managers to add period commentary, root cause, action, responsible person and due date. Commentary should be retained with the reporting period so next month’s team can see whether promised action occurred.
Focus on exceptions rather than narrating every stable metric. Examples include collection rate below threshold, large balance moved to an older ageing band, lease event overdue, maintenance cost above budget, owner statement not approved or payout details recently changed.
Scheduled reporting and close controls
Automated distribution is valuable only after the close is approved. Define a reporting calendar with data cut-off, reconciliation completion, management review, commentary deadline, owner-pack approval and release date. A draft pack should carry a visible status.
If a report changes after release, preserve the original version, reason, approver and corrected version. Silent replacement weakens trust. Period locks and governed adjustments help trend reports remain stable.
Data quality controls behind the dashboard
- Duplicate owner, property, unit and tenant detection
- Mandatory property and owner dimensions on financial transactions
- Lease dates checked for impossible or overlapping periods
- Unmatched bank and M-Pesa transactions aged in an exception queue
- Unit status changes tied to evidence and effective dates
- Supplier expenses requiring invoice and approval fields
- Metric totals reconciled to agreed finance control reports
- Missing-data dashboards with named owners and deadlines
Report a data-quality score or exception count alongside performance. A director should know when a seemingly good result is based on incomplete records.
Access, privacy and secure distribution
Owner A must not see Owner B’s data. A regional manager may need several properties but not company-wide payout information. A contractor needs assigned work orders, not tenant financial history. Build roles around job requirements and review them regularly.
Email attachments can remain accessible long after an employee leaves. Consider permissioned portals, expiry controls and secure exports for sensitive packs. Kenya’s Office of the Data Protection Commissioner has highlighted property management in its sector compliance activity. Organisations should obtain professional advice on their obligations, retention and data-subject processes.
Business intelligence integrations
Some organisations need Power BI or another analytics platform for group reporting. Ask whether PMS provides documented APIs, scheduled exports or database views; how authentication and access scopes work; and whether historical changes are preserved. A one-off spreadsheet download is not an enterprise integration.
The source system should remain responsible for transaction integrity. Business intelligence can model and visualise data, but it should not become the only place where staff correct owner or tenant records. Define lineage from PMS fields to executive metrics.
Implementation roadmap
- Identify report audiences and the decisions each pack must support.
- Approve the portfolio hierarchy and master-data ownership.
- Create the metric dictionary, calculation and cut-off rules.
- Map each metric to authoritative source transactions.
- Reconcile opening balances, leases, occupancy and property structures.
- Build operational, owner and executive prototypes.
- Run parallel reports and investigate every material difference.
- Configure roles, commentary, approvals and release schedules.
- Train users on interpretation as well as button clicks.
- Review adoption, data quality and decisions after the first three closes.
Start with a small, representative portfolio. Include properties with arrears, vacancies, maintenance and multiple owners so the pilot tests reality rather than a perfect data set.
Questions to ask PMS.co.ke
- Can reports aggregate by entity, owner, portfolio, property and unit?
- Can each KPI show its definition and source-detail drill-down?
- How are billed rent, cash collection and allocated receipts distinguished?
- Can owner packs be generated separately without cross-client data?
- Does the platform support scheduled draft, approval and release statuses?
- Can users add action-oriented commentary and track follow-up?
- How are prior reports versioned after a correction?
- Which APIs, exports and business-intelligence integrations are live?
- What permissions protect financial, tenant and payout information?
- What reporting configuration and data migration are included?
Use the PMS feature overview to prepare questions, then request a demonstration using anonymised source transactions and your current owner pack. Compare total cost through PMS pricing, implementation, integration and ongoing support.
Frequently asked questions about real estate portfolio reporting software Kenya
What is real estate portfolio reporting software?
It combines authorised property, lease, tenant, financial and maintenance data into reports for owners, managers and executives. Reliable systems retain definitions, source links, permissions and approval status.
Is a dashboard the same as portfolio reporting?
No. A dashboard displays selected metrics. Portfolio reporting also requires governance, period cut-offs, reconciliations, commentary, versioning, audience-specific packs and traceability.
Which KPIs should a property company track?
Common measures include occupancy, collections, aged receivables, operating performance, lease expiry, maintenance, budget variance and owner payout status. Use only metrics with agreed definitions and reliable data.
Can PMS create reports for multiple owners?
Buyers should verify the current capability. The essential requirement is strict owner-level separation combined with authorised portfolio aggregation and traceable transactions.
Can reports be exported to Excel or Power BI?
Ask PMS.co.ke which exports, APIs or connectors are currently supported, their security controls and whether scheduled refresh and historical data are available.
How often should reports be produced?
Operational reports may refresh daily, while reconciled owner and executive packs often follow a monthly close. Critical lease, cash or maintenance alerts may require immediate notification.
How do we prevent owners from seeing each other’s information?
Use owner-scoped permissions, tested report filters, secure portals, export controls and regular access reviews. Test for cross-owner leakage before release.
Should this new article replace the existing owner-reporting article?
No. The existing article targets owner statements. This new canonical targets enterprise portfolio and board reporting across assets, owners and functions, so the intents can support each other through internal links.
