What are collections KPIs? Definition, formulas, and example
Accounts receivable, billing and collections
Collections KPIs are metrics measuring collections performance, such as DSO, collection effectiveness index, past due percentage, promise-to-pay kept rate, and average days delinquent. They show how well your team turns overdue receivables into cash, by collector, segment, and month.
- Core measures
- CEI and DSO
- Aging measure
- Past-due percentage
- Commitment measure
- Promises kept
- Report breakdown
- Per-collector reporting
What are the main collections KPIs?
The core collections KPIs measure how much you collect, how late it comes in, and how well collectors work their accounts.
| KPI | Formula | What it tells you |
|---|---|---|
| Collection effectiveness index (CEI) | (Beginning AR + credit sales − ending total AR) ÷ (beginning AR + credit sales − ending current AR) × 100 | Share of collectible AR collected |
| Average days delinquent (ADD) | DSO − best possible DSO | Days lost to late payment |
| Percent past due | Past due AR ÷ total AR | How much of the book is overdue |
| Percent over 90 days | AR over 90 days past due ÷ total AR | Exposure most likely to become bad debt |
| Promise-to-pay kept rate | Promises kept on time ÷ promises due | Reliability of commitments collectors get |
| Cash collected per collector | Collections ÷ collectors | Productivity, read with portfolio size |
Collections KPIs example
Example: Ferro Distribution closes October 2026 on Saturday, October 31, with three collectors. The month has 31 days and credit sales of $1,860,000, or $60,000 a day. All amounts are illustrative.
| AR roll-forward, October 2026 | Amount |
|---|---|
| Beginning AR, September 30 | $2,000,000 |
| Add: credit sales | 1,860,000 |
| Less: collections | (1,900,000) |
| Less: write-offs | (20,000) |
| Ending AR, October 31 | $1,940,000 |
| Aging: current $1,400,000 + past due $540,000 | $1,940,000 |
| Difference to general ledger | $0 |
| KPI | Calculation | Result |
|---|---|---|
| CEI | $1,920,000 ÷ $2,460,000 × 100 | 78.0% |
| DSO | $1,940,000 ÷ $1,860,000 × 31 | 32.3 days |
| Best possible DSO | $1,400,000 ÷ $1,860,000 × 31 | 23.3 days |
| ADD | 32.3 − 23.3 | 9.0 days |
| Check: past due in days | $540,000 ÷ $60,000 | 9.0 days |
| Percent past due | $540,000 ÷ $1,940,000 | 27.8% |
| Percent over 90 days | $120,000 ÷ $1,940,000 | 6.2% |
| Promise-to-pay kept rate | 31 ÷ 40 | 77.5% |
| Cash collected per collector | $1,900,000 ÷ 3 | $633,333 |
The CEI numerator, $1,920,000, is collections plus write-offs. A CEI of 78% with 9 days of ADD says collectors are clearing most of the book but letting about a quarter run late.
How do collections KPIs differ from AR KPIs?
Collections KPIs are a subset of AR KPIs: they measure the collections team, while AR KPIs also cover billing accuracy, cash application, disputes, and bad debt.
What are collections KPIs confused with?
Collections KPIs are most often confused with the wider AR set and with single ratios.
| Term | What it is | How it differs from collections KPIs |
|---|---|---|
| AR KPIs | Metrics tracking receivables performance, such as DSO, collection effectiveness index, average days delinquent, past due percentage, and bad debt ratio | The wider set that includes collections KPIs |
| Days sales outstanding (DSO) | Average days to collect receivables: average gross accounts receivable divided by credit sales, times days in the period. Ending AR is a simpler proxy | One speed measure, driven partly by terms |
| Collector productivity | Measures of what each collector achieves, such as cash collected, accounts worked, and promises kept, per period | The per-person slice of collections KPIs |
Collections KPIs at month end
Calculate collections KPIs after receivables are closed, so every ratio uses final numbers.
- Apply cash and credits: Clear unapplied cash and post credit memos
- Book write-offs: Post approved write-offs before calculating CEI
- Tie out: Agree the aging to the general ledger
- Report by collector and segment: Show trends, not one month
For FP&A, a falling promise-to-pay kept rate is an early warning for the collections forecast. Our Close Agent ties the AR subledger to the general ledger at close and prepares the entry, and nothing posts until a named approver signs off.
Common collections KPI mistakes
The most common collections KPI mistakes come from mixing definitions and ranking collectors unfairly.
- Swapping the CEI fraction: Ending total AR goes in the numerator; ending current AR in the denominator
- Ranking collectors on cash alone: Portfolio size and risk differ
- Counting partial promises as kept: Define kept as paid in full by the promised date
- Changing day counts month to month: Use the same days and credit-sales base