---
title: "Collection effectiveness index (CEI): formula"
description: "The collection effectiveness index (CEI) explained: the formula, how to calculate it monthly or quarterly, how it differs from DSO, and a worked example."
url: https://emptyspaces.ai/glossary/collection-effectiveness-index
language: en
---

[Home](https://emptyspaces.ai/) [Glossary](https://emptyspaces.ai/glossary) Collection effectiveness index (CEI)

# What is the collection effectiveness index (CEI)? Formula and example

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

Definition

The collection effectiveness index (CEI) is the percentage of collectible receivables a company actually collected in a period: what was collected divided by what was available to collect, excluding ending current receivables (invoices still within terms at period end). A CEI of 100% means everything due was collected. Below 100% indicates some collectible receivables remain outstanding; compare aging balances over time to determine whether overdue debt is growing.

Measures

Collection effectiveness

Unit

Percentage

Desired direction

Target near 100%

Excluded balance

Excludes current AR

## Collection effectiveness index formula

The collection effectiveness index formula compares what you collected with what you could have collected, both built from the same receivables roll-forward.

CEI = (Beginning AR + Credit sales − Ending total AR) ÷ (Beginning AR + Credit sales − Ending current AR) × 100

- **Numerator:** What left receivables in the period, mostly cash collected (credit memos and write-offs also reduce it unless you adjust for them)
- **Denominator:** Everything that could have been collected: all receivables except those still within terms at period end
- **Ending current AR:** Invoices not yet due at period end

For a quarter or a year, many teams divide credit sales by the number of months in both parts of the formula, so the index stays comparable with monthly figures. State which version you use.

## How to calculate CEI: example

**Example:** Sterling Office Interiors calculates CEI for September 2026, which ends Wednesday, September 30. All amounts are illustrative.

| September 2026 | Amount |
| ------------------------------------- | -------------- |
| Beginning AR, September 1 | $400,000 |
| Add: credit sales | 600,000 |
| **Available before collections** | **$1,000,000** |
| Ending total AR, September 30 | 450,000 |
| Ending current AR (not yet due) | 300,000 |
| **Collected (1,000,000 − 450,000)** | **$550,000** |
| **Collectible (1,000,000 − 300,000)** | **$700,000** |
| **CEI (550,000 ÷ 700,000)** | **78.6%** |

Sterling collected $550,000 of the $700,000 it could have collected. The other $150,000 is the past-due balance at September 30 ($450,000 total minus $300,000 current).

CEI has no journal entry. The cash it measures was booked as collected (debit cash, credit accounts receivable) during the month.

## What is a good collection effectiveness index?

A good collection effectiveness index is close to 100% and stable or rising month over month. There's no published standard, so compare with your own trend and break CEI out by customer segment or collector to see where cash is slipping.

## CEI vs DSO

CEI measures how much of the collectible balance you collected; DSO measures how many days sales take to turn into cash. DSO can rise just because sales grew late in the month, while CEI looks only at what was due, so the two together separate collection performance from sales timing.

## What is CEI confused with?

The collection effectiveness index is most often confused with DSO and with the collection rate, a simpler ratio of cash collected to receivables.

| Term | What it is | How it differs from CEI |
| ----------------------------- | ------------------------------------------------------------------------------------------------------------------ | ------------------------------------------- |
| Days sales outstanding (DSO) | Average days to collect receivables: average accounts receivable divided by credit sales, times days in the period | Measures speed, and moves with sales timing |
| Collection rate | Cash collected divided by receivables or billings for a period | Doesn't exclude ending current receivables |
| Average days delinquent (ADD) | Average number of days invoices are paid past their due date, often calculated as DSO minus best possible DSO | Measures how late, not how much |
| Bad debt ratio | Bad debt expense or write-offs as a percentage of credit sales or receivables | Measures losses, not collections |

## CEI at month end

At month end, calculate CEI after cash application and the AR tie-out, alongside your other [month-end close KPIs](https://emptyspaces.ai/resources/blog/month-end-close-kpis).

1. **Apply cash:** Unapplied payments understate collections
2. **Tie out:** Agree the aging to the AR control account so ending AR is right
3. **Split current and past due:** Use the aging's current column for ending current AR
4. **Adjust if needed:** Remove large credit memos or write-offs from the numerator if you want cash only

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 CEI mistakes

The most common CEI mistakes mix periods or count non-cash reductions as collections.

- **Using a quarter's credit sales unadjusted:** Divide by the number of months, or compare only like periods
- **Counting write-offs as collections:** They lower ending AR without any cash
- **Using total AR in the denominator:** Subtract ending current AR, or CEI is overstated. Sterling's denominator would become $550,000 (1,000,000 − 450,000), equal to the numerator, so CEI would show 100% instead of 78.6%
- **Running it before cash application:** Collected cash looks uncollected
- **Reading it alone:** Pair it with DSO and the aging

## Related terms

[ 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) [ Average days delinquent (ADD) Average number of days invoices are paid past their due date, often calculated as DSO minus best possible DSO. ](https://emptyspaces.ai/glossary/average-days-delinquent) [ Accounts receivable turnover ratio How many times a company collects its average accounts receivable in a period: net credit sales divided by average accounts receivable. ](https://emptyspaces.ai/glossary/accounts-receivable-turnover-ratio) [ Accounts receivable aging report Report listing unpaid customer invoices by how long they have been outstanding, such as current, 1 to 30, 31 to 60 days past due. ](https://emptyspaces.ai/glossary/accounts-receivable-aging-report) [ AR KPIs Measures of how well a company bills, collects, and manages receivables, such as DSO, CEI, and bad debt ratio. ](https://emptyspaces.ai/glossary/ar-kpis) [ Collections Process of pursuing payment on overdue customer invoices through reminders, calls, payment plans, and, when needed, escalation or outside agencies. ](https://emptyspaces.ai/glossary/collections)

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

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

Bring collection effectiveness index (cei) 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)
