Collection effectiveness index (CEI)
The collection effectiveness index (CEI) measures the share of receivables available for collection during a period that a business collected during that period. Its calculation compares beginning receivables and credit sales with ending receivables, separating current balances from total balances.
Example
For illustration, a business starts with 500,000 in receivables, makes 300,000 in credit sales, and ends with 450,000 in total receivables, of which 250,000 are current. CEI = (500,000 + 300,000 - 450,000) / (500,000 + 300,000 - 250,000) × 100 = (350,000 / 550,000) × 100, or about 64%.
Calculating CEI for a period
For an illustrative month, take 1,200,000 in beginning receivables and 400,000 in credit sales. Ending total receivables are 1,100,000, and ending current receivables are 700,000.
The numerator is 1,200,000 + 400,000 - 1,100,000 = 500,000. The denominator is 1,200,000 + 400,000 - 700,000 = 900,000, so CEI is (500,000 / 900,000) × 100, or about 55.6%.
Reading CEI beside DSO and receivables aging
DSO can move with sales volume and payment terms, so it does not isolate collection effort as directly as CEI. An aging report adds the age distribution of outstanding balances, which the single CEI figure does not show.
For illustration, if the denominator is 10 million and ending total receivables exceed ending current receivables by 100,000, CEI is 99%. That high percentage can coexist with 100,000 in older receivables.
Questions we get asked
Does CEI include cash sales?
The CEI formula uses credit sales, not cash sales. Use credit sales for the period being measured.
Does CEI show whether a specific customer paid?
No. CEI uses receivables totals, so it does not identify an individual customer’s payment. Account-level records can show that detail.
What is a good CEI?
The formula does not set a universal target. A CEI near 100% means almost everything available to collect in that period was collected, but the percentage should be read alongside the balances it measures.
Decisimo’s monthly CEI calculator calculates the index from receivables and shows days sales outstanding and months below target.