Collections Effectiveness Calculator

Measure portfolio collection discipline. This calculator computes % on-time, days sales outstanding (DSO), and aged receivables ratio.

Total rent billed (month)

Collected by due date

Collected within 30 days of due

Outstanding past 60 days

On-time collection %

94.00%

Collected within 30 days %

3.50%

Past-60-day outstanding %

1.00%

Total collected (on-time + 30)

97.50%

How the math works

Collections effectiveness is a leading indicator of portfolio health. Pre-delinquency is cheap to fix (phone call); past-60 is expensive (legal).

Benchmark monthly and trend. If on-time drops 2 points over a quarter, investigate — usually tenant-mix shift or management team issue.

How to Use

Enter total billed rent (month).
Enter collected by due date.
Enter collected within 30 days of due.
Enter still outstanding past 60 days.
Read collection effectiveness ratios.

Frequently Asked Questions

What's benchmark?

Class-A multifamily: 97-99% on-time collection. Class-B: 92-97%. Class-C/workforce: 85-92%. Subsidized: 80-90%. Below these = collections team underperforming or wrong tenant mix.

What is DSO?

Days Sales Outstanding = average days from rent billing to collection. Multifamily target: <3 days. Retail/office with NNN reconciliation: 10-30 days is normal.

How to improve?

Auto-pay adoption (easiest big win), online portal, stricter late-fee enforcement, early-intervention courtesy calls. Top operators run 1%+ improvement per quarter on Class-B.

What documentation matters here?

Written leases, move-in/move-out inspections with photographs, ledger entries showing every payment and charge, served notices with proof of service, and contemporaneous emails or texts. Courts weigh written evidence heavily; informal understandings rarely stand. Institutional operators run a monthly file audit to catch gaps before they matter. Good paper trails recover most of what's owed.