Property Operations

Multifamily Rent Collection KPIs: Delinquency, Bad Debt, Benchmarks

Swara - Property Management Technology Consultant September 18, 2026

Multifamily rent collection KPIs are the six measures that tell an operator whether rent is being collected on time, how much is at risk, and how much has been lost: on-time collection rate, month-end collection rate, delinquency rate, bad debt percentage, days sales outstanding and the ageing profile of what is owed. Each has a formula, a denominator that has to be chosen and held constant, and a benchmark range that depends on the asset class. Most operators track one or two of them, usually the ones their software prints by default, and are surprised at year end by the third.

This post is measurement only: what to calculate, from what, how often, what the numbers should look like by asset class, how to read a trend, and how to lay the six out on one dashboard. The workflow that acts on them, the notices, escalation and arrears follow-up, is in our existing guide to building a rent delinquency workflow, and the mechanics of taking payment are in online rent collection for property managers.

The six KPIs and their formulas

The worked figures use a 250-unit conventional property with gross potential rent of $400,000 a month and $385,000 billed after vacancy in the month measured.

KPI	Formula	Worked example	Denominator to fix	Frequency
On-time collection rate	Rent received by the due date (or the end of the grace period) ÷ rent billed for the month	$339,000 ÷ $385,000 = 88.1% by day 5	Billed rent for the month, not GPR; state whether the cut-off is the due date or the grace date	Monthly, on the cut-off day
Month-end collection rate	Rent received by the last day of the month ÷ rent billed for the month	$377,300 ÷ $385,000 = 98.0%	Same billed figure as above, so the two rates are comparable	Monthly
Delinquency rate	Balances 30 or more days past due ÷ rent billed for the month (dollar basis), and units with a 30+ day balance ÷ occupied units (unit basis)	$28,000 ÷ $385,000 = 7.3% by dollars; 12 ÷ 250 = 4.8% by units	Choose 30+ days as the threshold and report both bases; the dollar rate shows the money, the unit rate shows the spread	Monthly, as at month end
Bad debt percentage	Balances written off as uncollectible (net of recoveries) ÷ gross potential rent for the period	$62,000 written off in the year ÷ $4,800,000 GPR = 1.3%	GPR for the year, so that vacancy does not flatter the ratio; net of recoveries from collection agencies	Monthly accrual, reported quarterly and annually
Days sales outstanding (DSO)	Total resident receivables ÷ rent billed for the month × 30	$41,000 ÷ $385,000 × 30 = 3.2 days	Total open receivables including current-month balances; use 30 for a monthly figure	Monthly
Ageing profile	Open balances grouped as current, 1–30, 31–60, 61–90, 90+ days, each as a share of total open balances and of billed rent	e.g. 60% current, 22% at 1–30, 10% at 31–60, 5% at 61–90, 3% at 90+	Age from the due date, not the invoice date	Monthly, with month-on-month movement between buckets

Three definitions decide whether the numbers are comparable across properties and months.

The denominator for the rate KPIs is rent billed for the month, after vacancy and concessions, not gross potential rent. A property at 92% occupancy that measures against GPR shows a collection rate that can never exceed 92% and tells the operator nothing about collections. Bad debt is the exception: it is measured against GPR because the question there is how much of the property's revenue potential was lost, and because that is how lenders and buyers underwrite it.
Delinquency is measured at 30 or more days past due. Balances inside the grace period are not delinquent; balances between the grace date and day 30 are late, and the on-time and month-end rates capture them. A property that reports "delinquency" as everything unpaid on the 6th of the month will show a number three times the size of one that reports at 30 days, and the two cannot be benchmarked against each other.
Bad debt is net of recoveries and is accrued monthly, not booked when the collection agency gives up. An operator that writes off in December shows a clean eleven months and a bad December; one that accrues an allowance monthly against ageing balances shows the real trend and can act on it in March.

Benchmarks by asset class

The on-time rent benchmark, the delinquency rate multifamily operators should expect and the bad debt percentage multifamily lenders underwrite to are all less public than benchmarks for occupancy or rent growth, because most of the data sits inside operators and the public reporting comes from REITs and industry trackers rather than a single standard survey. The ranges below draw on what has been published and on what operators report; treat them as planning ranges, and replace them with your own trailing-twelve-month figures as soon as you have them.

Asset class	On-time (by grace date)	Month-end collection	Delinquency 30+ (dollar)	Bad debt (% of GPR)	Notes
Class A conventional, institutional	90–95%	98–99.5%	1–3%	0.5–1.0%	Public REITs reported pre-pandemic bad debt of roughly 0.5% to 0.7% of revenue; the largest reported returning toward that range through 2024 and 2025 after peaking above 2% in 2021–2023
Class B conventional	85–92%	96–98.5%	3–6%	1.0–2.0%	The widest spread by market; regulated eviction timelines are the main driver of the difference between the top and bottom of the range
Class C / workforce	75–88%	93–97%	6–12%	2.0–4.0%	Cash and money-order payers; on-time rate improves markedly with payment plans and low-cost electronic options
Student housing (by the bed)	85–92% at instalment dates	97–99% by semester end	3–6% at bed level	0.5–1.5%	Guarantors keep bad debt low; delinquency spikes at aid-disbursement gaps in September and January
Affordable / subsidised	Tenant portion 80–90%	95–98%	5–10% of tenant portion	1.5–3.0% of tenant portion	Subsidy portion collects at ~100%; measure the tenant portion separately
Manufactured housing (lot rent)	85–92%	96–98%	3–6%	1.0–2.0%	See the manufactured housing delinquency guide for why the playbook differs

Two external reference points anchor the table. The NMHC Rent Payment Tracker, which reported monthly collections across millions of professionally managed apartment units from 2020 to 2023, consistently showed month-end collection rates in the low-to-mid 90s as a share of households, with the top of the market above that. And the large public apartment REITs, whose bad debt is disclosed on earnings calls, described pre-pandemic bad debt of 50 to 70 basis points of revenue, a peak above 2% during and after the eviction moratoria, and a return toward roughly 1% to 1.7% by 2024, which is the trajectory most institutional portfolios have followed since.

The benchmark that matters most is not the industry's; it is the property's own trailing twelve months, by month, so that seasonality (January and September are worse in most markets; tax-refund season is better) is separated from a real change.

Reading the trend

A single month's figure is noise. The six KPIs are read as trends and against each other, and four patterns cover most of what a portfolio will show.

On-time rate falling while month-end rate holds. Residents are paying later inside the month but still paying. The usual causes are a change in pay cycles, a rise in the share of residents on payment plans, or a late-fee policy that has stopped being enforced. It is a cash-timing problem, not a credit problem, and it is fixed at the due date, not at day 30.
Month-end rate falling and the 31–60 day bucket growing. Balances are rolling forward, which is the first visible stage of bad debt six months out. This is the pattern to act on hardest, because a balance that reaches 60 days without a payment plan is unlikely to be collected in full. The delinquency workflow's escalation steps are designed for this stage.
Delinquency rate flat but bad debt rising. The same residents are delinquent every month and are being written off in turn, while new delinquencies replace them. This is a screening or a resident-quality problem, not a collections problem, and it shows up first as a rising eviction filing count per 100 units. Check the screening criteria and the guarantor policy before spending more on collections.
DSO rising while the delinquency rate is flat. Receivables are growing in the current and 1–30 buckets rather than in the delinquent buckets: billing is late, charges are posting after the due date, or utility and ancillary charges are being billed on a different cycle from rent. Fix the billing calendar.

Read every KPI by property and by unit type as well as by portfolio, because a portfolio delinquency rate of 4% can hide one property at 11%, and a property rate of 4% can hide one floor plan whose residents were screened under a different policy.

Dashboard layout

A collections KPI dashboard is one page per portfolio, with the same layout per property, and it is looked at on three days of the month: the day after the grace date, the 15th, and the first business day after month end.

The top row carries the six KPIs for the current month against the prior month, the same month last year and the target, with a colour on each. The second row is the ageing profile as a stacked bar by property, with the month-on-month movement between buckets shown, because the movement is the signal and the level is the context. The third row is the trailing twelve months of on-time, month-end and delinquency rates as lines, with the seasonality visible. The fourth row is the action list: residents by balance and age, with the last contact, the workflow stage, the payment plan status and the guarantor where there is one, sortable by balance and by days.

Beneath those, the numbers that explain the KPIs: eviction filings and completions per 100 units, payment plans open and their performance, late fees assessed and collected, write-offs and recoveries by month, and the share of rent paid electronically. The last one is the leading indicator: a property where 90% of rent arrives by card, ACH or portal has an on-time rate that a property at 60% electronic will not reach with any amount of chasing.

In RIOO on NetSuite, all six KPIs run from the resident ledger with the definitions above fixed in the report, so the on-time rate on the dashboard is the same number in every property and every month. Balances age from the due date, delinquency is reported at 30+ days on both the dollar and unit basis, and bad debt accrues monthly against ageing rather than being booked at write-off. The dashboard sits beside the delinquency workflow, so the action list and the KPI it drives are on the same page, and the portfolio view rolls up by property, region and unit type. Our post on NetSuite real estate dashboards shows the wider set of KPIs this sits within, and the property management KPI cheat sheet lists the 25 an operator should have in one place. Collections is also the second function most operators centralise, and the metrics here are what the central AR team is measured on; see multifamily centralization models.

Frequently asked questions

Q1. What is a good rent collection rate for multifamily?
By month end, 98% or better of billed rent on a Class A property, 96% to 98.5% on Class B, and 93% to 97% on Class C or workforce housing. On-time collection by the grace date runs 10 to 15 points lower than month-end in each class. Measure against rent billed for the month, not gross potential rent.

Q2. How is delinquency rate calculated in multifamily?
Balances 30 or more days past due divided by rent billed for the month gives the dollar-basis rate; units with a 30+ day balance divided by occupied units gives the unit-basis rate. Report both, age balances from the due date, and do not count balances inside the grace period as delinquent.

Q3. What is a normal bad debt percentage for apartments?
Roughly 0.5% to 1% of gross potential rent on institutional Class A assets, 1% to 2% on Class B and 2% to 4% on Class C, net of recoveries. Public REITs reported pre-pandemic bad debt of 50 to 70 basis points, a peak above 2% during the eviction moratoria, and a return toward 1% to 1.7% by 2024.

Q4. Should collection KPIs use gross potential rent or billed rent as the denominator?
Billed rent (after vacancy and concessions) for the on-time, month-end and delinquency rates, so the KPI measures collections rather than occupancy. Gross potential rent for bad debt, because that ratio measures lost revenue potential and is how lenders and buyers underwrite it.

Q5. How often should rent collection KPIs be reviewed?
Three times a month: the day after the grace date for the on-time rate and the action list, mid-month for payment-plan and escalation progress, and the first business day after month end for the month-end rate, the delinquency rate and the ageing movement. Bad debt is reviewed monthly on an accrual basis and reported quarterly.