How it works
- Total actual expenses for the year, by category.
- Remove exclusions set by each lease, such as capital items that aren't allowed.
- Apply gross-ups where the lease allows them.
- Apply caps and base years by tenant.
- Calculate each tenant's share, then subtract its estimated payments.
- Issue statements with support, and set next year's estimates.
Each lease can differ, so a single property can have many different calculations.
Example: pro rata share
| Item | Calculation | Result |
|---|---|---|
| Tenant's share | 20,000 SF ÷ 100,000 SF | 20% |
| Recoverable expenses | $600,000 | |
| Tenant's portion | $600,000 × 20% | $120,000 |
| Estimates already paid | $9,500 × 12 | $114,000 |
| Balance due from tenant | $120,000 − $114,000 | $6,000 |
If $50,000 of those expenses were a capital item the lease doesn't allow, the recoverable total falls to $550,000, the tenant's portion to $110,000, and instead of owing $6,000, the tenant is due a $4,000 credit.
Example: gross-up
Some costs, such as janitorial, rise with occupancy. Gross-ups adjust them so that tenants in a partly empty building pay what they'd pay in a full one, where the lease allows it.
| Item | Calculation | Result |
|---|---|---|
| Actual variable expenses at 80% occupancy | $400,000 | |
| Grossed up to 95% | $400,000 × 95% ÷ 80% | $475,000 |
| 10,000 SF tenant's share of 100,000 SF | $475,000 × 10% | $47,500 |
| Without a gross-up | $400,000 × 10% | $40,000 |
Gross-ups generally belong on variable expenses. Prophia, a lease data vendor, points to gross-ups applied to fixed costs like taxes and insurance as a common error.1
The errors to check
| Error | What happens | How to catch it |
|---|---|---|
| Management fee base or rate | Prophia calls this the most common source of overcharges1 | Test each lease's fee language |
| Capex billed as operating expense | Roof, HVAC or parking lot work billed without amortization rights1 | Review large invoices against the lease |
| Wrong cap method | Cumulative vs non-cumulative, compounding vs simple1 | Abstract cap terms per tenant |
| Wrong denominator | Occupied vs leasable area used inconsistently | Tie out each tenant's share to the lease |
| Stale lease data | Amendments not entered in the system | Abstract again, and audit against the source |
How large is the problem? Prophia cites an estimate from PredictAP of $15 billion a year in losses to US owners, and a Tango Analytics finding of material errors in roughly 40% of reconciliations.1 These are vendor figures, from companies that sell solutions to this problem, so treat them as directional. They do fit one sensible point: most errors stem from lease data, not math.1
Why it matters beyond the check
- Tenant relationships: a surprise bill right before a renewal doesn't help. See rollover risk.
- Value: each dollar of recovered expense is a dollar of NOI, and it's capitalized at sale.
- Diligence: buyers test recoveries, and a messy history raises questions.
- Time limits: some leases limit how long you have to bill, so check your deadlines, and don't assume late billing can be recovered.
What to do this year
- Pick your largest property and test its top five tenants against the leases.
- Compare last year's recovery ratio with the same period before.
- Review all items over a set dollar amount for capital treatment.
- Have your lease abstracts checked before you start on next year's reconciliation.
