Skip to content

What are collections KPIs? Definition, formulas, and example

Accounts receivable, billing and collections

Definition

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.

KPIFormulaWhat it tells you
Collection effectiveness index (CEI)(Beginning AR + credit sales − ending total AR) ÷ (beginning AR + credit sales − ending current AR) × 100Share of collectible AR collected
Average days delinquent (ADD)DSO − best possible DSODays lost to late payment
Percent past duePast due AR ÷ total ARHow much of the book is overdue
Percent over 90 daysAR over 90 days past due ÷ total ARExposure most likely to become bad debt
Promise-to-pay kept ratePromises kept on time ÷ promises dueReliability of commitments collectors get
Cash collected per collectorCollections ÷ collectorsProductivity, 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 2026Amount
Beginning AR, September 30$2,000,000
Add: credit sales1,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
KPICalculationResult
CEI$1,920,000 ÷ $2,460,000 × 10078.0%
DSO$1,940,000 ÷ $1,860,000 × 3132.3 days
Best possible DSO$1,400,000 ÷ $1,860,000 × 3123.3 days
ADD32.3 − 23.39.0 days
Check: past due in days$540,000 ÷ $60,0009.0 days
Percent past due$540,000 ÷ $1,940,00027.8%
Percent over 90 days$120,000 ÷ $1,940,0006.2%
Promise-to-pay kept rate31 ÷ 4077.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.

TermWhat it isHow it differs from collections KPIs
AR KPIsMetrics tracking receivables performance, such as DSO, collection effectiveness index, average days delinquent, past due percentage, and bad debt ratioThe 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 proxyOne speed measure, driven partly by terms
Collector productivityMeasures of what each collector achieves, such as cash collected, accounts worked, and promises kept, per periodThe per-person slice of collections KPIs

Collections KPIs at month end

Calculate collections KPIs after receivables are closed, so every ratio uses final numbers.

  1. Apply cash and credits: Clear unapplied cash and post credit memos
  2. Book write-offs: Post approved write-offs before calculating CEI
  3. Tie out: Agree the aging to the general ledger
  4. 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