Skip to content

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

Accounts receivable, billing and collections

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 2026Amount
Beginning AR, September 1$400,000
Add: credit sales600,000
Available before collections$1,000,000
Ending total AR, September 30450,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.

TermWhat it isHow it differs from CEI
Days sales outstanding (DSO)Average days to collect receivables: average accounts receivable divided by credit sales, times days in the periodMeasures speed, and moves with sales timing
Collection rateCash collected divided by receivables or billings for a periodDoesn'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 DSOMeasures how late, not how much
Bad debt ratioBad debt expense or write-offs as a percentage of credit sales or receivablesMeasures 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.

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