A property manager earns a percentage of rent collected — not rent due. Fee = collected rent × the management rate, often with a per-unit minimum, summed across a portfolio.
The example
$42,000 collected, 8% fee.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 42000 × 8% | — |
| 3 | Mgmt fee | → $3,360 |
The formula
The formula:
How it works
How it works:
- Use collected rent, not rent due — the fee aligns the manager with actual collections.
- Multiply by the management percentage (commonly 6–10%).
- Apply a per-unit minimum with
MAX(fee, units × min_each)if the contract has one. - Across a portfolio, SUMPRODUCT(collected, rates) handles mixed rates per property.
Fee on collected, not billed, aligns incentives. Charging the manager’s fee against rent actually collected means they only earn when money comes in — so chasing late payers and reducing delinquency directly grows their fee. A fee on rent due would pay the same whether tenants pay or not. The one-word difference (collected vs due) is the whole point of the structure.
Try it: interactive demo
Rent collected and fee %.
Variations
With per-unit minimum
Floor the fee:
Portfolio (mixed rates)
Different % per property:
Owner payout
Net to owner:
Pitfalls & errors
Collected, not due. The fee is on money actually received.
Minimum fee. Apply MAX if the contract sets a per-unit floor.
Percent as decimal. 8% is 0.08 in the multiplication.
Practice workbook
Frequently asked questions
How do I calculate a property management fee in Excel?
Why fee on collected rather than due?
How do I apply a minimum fee?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class