CEI
Collections Effectiveness Index (CEI) measures the percentage of overdue accounts receivable a company actually collects within a given period. It is the standard quality metric for collections operations, complementing DSO with a measure of how effectively the team is working its overdue book.
Days Sales Outstanding tells you how long it takes customers to pay, but it's noisy: it moves with sales volume, payment term changes, and customer mix in ways that have nothing to do with collections team performance. Collections Effectiveness Index strips out those distortions. CEI asks a single sharp question: of the overdue AR available to collect in a given period, how much did the team actually collect? It is the cleanest available measure of collections operational performance and the standard pairing with DSO in AR dashboards.
The standard formula is:
CEI = ((Beginning AR + Credit Sales - Ending Total AR) / (Beginning AR + Credit Sales - Ending Current AR)) x 100
The numerator is total cash collected in the period. The denominator is what should have been collected (total receivables minus what was current and therefore not yet collectible). The ratio expresses collections as a percentage of the collectible base, scaled from 0 to 100.
A worked example: a company starts the month with 10 million euros AR, issues 12 million euros in new credit sales, ends with 11 million euros total AR of which 7 million euros is current. CEI = ((10 + 12 - 11) / (10 + 12 - 7)) x 100 = (11 / 15) x 100 = 73.3 percent. The team collected 73 percent of what was collectible during the period.
CEI benchmarks vary by industry maturity and collections team size, but the following ranges are widely accepted:
The absolute number matters less than the trend. A CEI of 78 percent improving to 85 percent over a quarter is a strong signal of operational improvement, even if it still trails best-in-class.
DSO and CEI both measure receivables performance but answer different questions. DSO measures the duration of the collection cycle; CEI measures the success rate of collections work. Together they give a complete picture:
Reporting both metrics monthly to leadership is the standard discipline for any enterprise AR organisation.
Mistake 1: Using CEI in isolation. CEI without DSO context can hide structural problems. A team can score 90 percent CEI while DSO climbs because new sales overwhelm the team's capacity.
Mistake 2: Manipulating the denominator. Some teams strip out genuinely uncollectible receivables (bankruptcy filings, fraud cases) from the denominator to inflate CEI. This is appropriate for write-offs but should be transparent and consistent across periods.
Mistake 3: Confusing CEI with collection rate. CEI is period-specific (what was collected of what was collectible this month). Collection rate is the lifetime recovery rate (what percentage of all sales eventually convert to cash). Both matter but they measure different things.
Mistake 4: Setting CEI targets without operational backing. A target of 90 percent CEI requires the staffing, tools, and process to work 100 percent of overdue invoices within the period. Setting the target without enabling the work creates frustration without results.
The structural lever for CEI improvement is collections coverage. Manual teams work the top 30 to 40 percent of overdue invoices by dollar value, leaving smaller invoices to age. Autonomous collections agents change the economics by working 100 percent of overdue invoices within 24 hours of going past due:
Mid-market collections teams typically see a 10 to 15 percentage point CEI lift within 90 days of agentic AR deployment, with the gain coming primarily from the long tail of smaller overdue invoices that manual capacity could not reach.
DSO measures the average days between sale and payment, which is influenced by sales volume, payment terms, and customer mix. CEI measures the percentage of overdue AR actually collected in a period, isolating collections team performance. Together they provide a complete view: DSO for cycle duration, CEI for collection success rate.
Best-in-class collections teams operate at 85 to 95 percent CEI. Industry average is 75 to 85 percent. Below 75 percent typically signals a structural problem like under-staffed collections, large dispute backlogs, or process fragmentation across AR, collections, and disputes teams.
Monthly is the standard cadence for collections team performance. Some enterprises track weekly for early warning. Trend analysis matters more than any single month, since CEI can spike or dip due to timing of quarter-end pushes or one-time large collections.
Technically yes if a team collects more in the period than the denominator allows, for example by recovering previously written-off bad debt or processing reversals. CEI over 100 percent is a flag to investigate one-time effects, not a sustainable metric.
Standard CEI calculation treats all overdue receivables equally. To make CEI more meaningful for teams that handle heavy dispute volume, some companies report a separate 'CEI excluding disputes' or break out dispute resolution rate as a complementary metric.
The main lever is collections coverage. Manual teams work 30 to 40 percent of overdue invoices, focused on the largest balances. Autonomous collections agents work 100 percent of overdue invoices within 24 hours of going past due. The long tail of smaller invoices, previously left to age, starts converting to cash. Combined with faster dispute resolution and dynamic dunning, mid-market teams see 10 to 15 percentage point CEI lifts within 90 days.
