What financial and owner reports are available?

Use portfolio reports to compare performance, then move into a property, owner, unit or tenant when the question requires more detail.

Rent Roll

Portfolio or propertyExcel, PDF, CSV

Get a complete, up-to-date view of every unit, tenant, lease, rent amount, deposit, arrears balance and upcoming rent review across your portfolio.

What it shows

  • Property and unit
  • Occupied or vacant status
  • Current tenant and lease status
  • Lease dates and days to expiry
  • Monthly contracted rent and currency
  • Required security deposit
  • Tenant rent arrears
  • Next scheduled rent review

Available filters

Property, occupancy status and free-text search.

Important definition: This is an as-of-date snapshot based on current leases, units and tenant arrears. It is not a historical month-by-month rent roll.

Expenses & Payables

Portfolio, property or managementExcel, PDF, CSV

Track property costs and management overhead in one place, with supplier aging, approval status, payment progress and outstanding obligations broken down by category, property and currency.

What it shows

  • Expense, due and payment dates
  • Property or management-overhead scope
  • Vendor, description and category
  • Approval and payment status
  • Total, paid and outstanding amount
  • Days overdue and aging bucket
  • Currency-separated summaries

Available filters

Expense, creation, due or paid date; date range; property; status; category; vendor; payment position; currency; and search.

Important definition: Amounts in different currencies remain separate instead of being combined into a misleading total.

Profit & Loss Statement

Portfolio, property, unit or tenantOn-screen statement; detail in Excel, PDF, CSV

Understand operating performance with an accrual-based profit and loss statement that separates property expenses from management overhead and lets you inspect every supporting invoice and expense.

What it shows

  • Operating income by category
  • Property and unit operating expenses
  • Net operating income
  • Management overhead
  • Net operating result
  • Monthly or annual period columns
  • Supporting transaction detail

Available filters

Starting and ending month, monthly or annual grouping, currency, property, unit, tenant, category and search.

Important definition: Income comes from finalised invoices rather than cash received. Draft and security-deposit invoices are excluded. The screen shows the formatted statement; downloads contain its filtered transaction detail.

Monthly Property Collection & Remittance Statement

One property and payment monthExcel, PDF, CSV

Turn each month’s property collections into a clear, owner-ready statement showing every tenant payment, applicable deduction and final amount due to the owner.

What it shows

  • Tenant payment lines
  • Gross collections
  • Agency commission and management fees
  • Maintenance, utility and custom deductions
  • Net remittance
  • Charge-type, payment-method and tenant breakdowns

Available filters

Landlord, property, payment month and charge type.

Important definition: Foreign-currency payments use saved exchange-rate information for the target KES statement. CSV contains payment rows, not the presentation-focused cover or deduction footer.

Owner Monthly Remittance Statement

One owner and payment monthExcel, PDF, CSV

Produce one consolidated monthly owner statement across every managed property, bringing collections, posted expenses, management fees and net remittance together.

What it shows

  • Gross collections across owner properties
  • Payment and property counts
  • Per-property gross totals
  • Posted expenses and management fees
  • Manual deductions
  • Total deductions and net remittance

Available filters

Owner, payment month, charge type and optional per-property breakdown.

Important definition: This is an agency-only report. Automatic expense and management-fee deductions are currently included only when recorded in KES.

Collections Performance Report

Portfolio or propertyExcel, PDF, CSV

Compare expected rent, actual collections, outstanding balances and collection rates across every property, with a six-month trend for faster portfolio decisions.

What it shows

  • Rent expected to date
  • Rent collected to date
  • Outstanding rent
  • Collection rate
  • Six-month collection trend
  • Property-by-property comparison

Available filters

Property, collection-rate band, outstanding or settled position, and search.

Important definition: The calculation includes rent histories, period overrides, proration and settled periods. The portfolio Collections report is currently KES-only.

Arrears Aging Report

Portfolio or propertyExcel, PDF, CSV

See exactly how much rent is overdue, how old each balance is and which tenants need attention first—down to the property, unit and unpaid month.

What it shows

  • Current or not-yet-due balance
  • 1–30, 31–60 and 61–90 days
  • More than 90 days
  • Unallocated balance
  • Oldest due date and balance age
  • Number of unpaid months

Available filters

Property, aging bucket and search.

Important definition: Currencies are treated as separate tenant accounts and are not added together.

Security Deposit Position Report

Portfolio or propertyExcel, PDF, CSV

Reconcile every tenant deposit from collection to refund, with visibility into amounts required, held, deducted, under-collected or awaiting review.

What it shows

  • Tenant and tenancy status
  • Deposit treatment and position
  • Required and collected deposit
  • Refunded and deducted amount
  • Amount still held
  • Currency

Available filters

Property, deposit position and search.

Important definition: The report distinguishes properly held, under-collected, settled and review-required deposits.

Utility Collections Report

Portfolio or propertyExcel, PDF, CSV

Bring water, electricity and service-charge collections together, including payment history and consumption calculated from recorded meter readings.

What it shows

  • Billing period and payment date
  • Utility type
  • Property, unit and tenant
  • Collected amount and currency
  • Consumption and meter unit
  • Meter-reading validity

Available filters

Property, utility type and search.

Important definition: Usage is calculated only when valid opening and closing readings exist. Collection-only records remain visible rather than being discarded.

Product information reviewed 2026-09-10. Report access and advanced downloads depend on role, subscription and enabled modules. Reviewed by the Pangoni editorial team.