What is the collection effectiveness index (CEI)? Formula and example
Accounts receivable, billing and collections
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.
- 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.
- Apply cash: Unapplied payments understate collections
- Tie out: Agree the aging to the AR control account so ending AR is right
- Split current and past due: Use the aging's current column for ending current AR
- Adjust if needed: Remove large credit memos or write-offs from the numerator if you want cash only
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 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