Skip to content
Kuberan AI Help

Property P&L

Open Property P&L

Overview

The Property P&L is a standard profit-and-loss report, but filtered to the lines tagged with a single property. Every transaction in Books — invoice line items, bill line items, journal-entry lines, bank-transaction splits — can carry a propertyId, a unitId, and a leaseId. When those tags are set consistently (the rent invoice generator, deposit disposition, mortgage payments and manual bills with the Property picker all do this), the report is fully automatic.

Report layout

Header: Property name, period picker (This month / Last month / This quarter / Year to date / Custom), comparison toggle (Prior period / Prior year).

Body (three sections):

  1. Revenue — rent income, late fees, other income. One row per account, with a drill-down to the underlying transactions.
  2. Expenses — utilities, repairs, property tax, insurance, management fees, mortgage interest, depreciation, deposit writedowns. One row per account.
  3. Net Operating Income (NOI) — revenue minus expenses (excluding depreciation, per NOI convention). Below NOI, depreciation and interest expense display as info rows so the “Net income” bottom line is still available.

Footer: Cap rate approximation — (annualised NOI) / (current book value). Displayed with a note that it’s an approximation because book value ≠ market value.

Scope rules

  • Lines included: any ledger line with propertyId === this.property._id, regardless of source (invoices, bills, JEs, bank txns).
  • Period bounds use the transaction date (not posting date).
  • Unposted (draft) JEs are excluded.
  • Voided invoices and their reversing JEs cancel correctly because both sides carry the propertyId.

Drill-down

Drill-down

Clicking any row opens a detail list of every line contributing to that total: date, source, counterparty, memo, amount. From there you can open the source document (invoice, bill, JE).

Export

Export CSV

Exports the full P&L with the current period applied. Each row carries its account number so it round-trips into a spreadsheet template cleanly.

Export PDF

Exports a formatted PDF for sharing with the client / owner. Header includes property, period, and generation timestamp.

Unit-level P&L (v1.5)

v1 aggregates to the property. Per-unit P&L — useful for multi-unit buildings where each unit has its own tenant and meter splits — is on the post-v1 list. unitId is already stamped on every ledger line, so no re-tagging will be required when the drill-down ships.