---
title: "Collections KPIs: definition, formulas and example"
description: "Collections KPIs explained: formulas for CEI, ADD, percent past due, promise-to-pay kept rate and collector productivity, with one example that ties out."
url: https://emptyspaces.ai/glossary/collections-kpis
language: en
---

[Home](https://emptyspaces.ai/) [Glossary](https://emptyspaces.ai/glossary) Collections KPIs

# What are collections KPIs? Definition, formulas, and example

Updated November 19, 2026[Accounts receivable, billing and collections](https://emptyspaces.ai/glossary#browse)

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.

| 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.

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](https://emptyspaces.ai/product/close) 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

## Related terms

[ AR KPIs Metrics tracking receivables performance, such as DSO, collection effectiveness index, average days delinquent, past due percentage, and bad debt ratio. ](https://emptyspaces.ai/glossary/ar-kpis) [ Collection effectiveness index (CEI) Percentage measuring how much collectible receivables were actually collected in a period, with 100 percent meaning everything collectible was collected. ](https://emptyspaces.ai/glossary/collection-effectiveness-index) [ Average days delinquent (ADD) Average number of days customers pay late, calculated as days sales outstanding minus best possible DSO. ](https://emptyspaces.ai/glossary/average-days-delinquent) [ Promise to pay Customer's commitment to pay a stated amount by a stated date, logged by collectors and tracked until it's kept or broken. ](https://emptyspaces.ai/glossary/promise-to-pay) [ Collector productivity Measures of what each collector achieves, such as cash collected, accounts worked, and promises kept, per period. ](https://emptyspaces.ai/glossary/collector-productivity) [ 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. ](https://emptyspaces.ai/glossary/days-sales-outstanding)

Full guides: [Month-end close KPIs](https://emptyspaces.ai/resources/blog/month-end-close-kpis), [FP&A](https://emptyspaces.ai/resources/blog/fpa), and [General ledger vs subledger: AP and AR reconciliation](https://emptyspaces.ai/resources/blog/ap-ar-reconciliation).

More terms: [Finance and accounting glossary](https://emptyspaces.ai/glossary)

Bring collections kpis into a clearer close.

Our Close Agent prepares the AR subledger tie-out and proposed entries. Your team reviews and approves before posting.

[Book a working session](https://emptyspaces.ai/contact-us)

No implementation commitment.

[All 721 glossary terms](https://emptyspaces.ai/glossary)
