Collection effectiveness index
/What is the Collection Effectiveness Index?
The collection effectiveness index (CEI) is a measure of the ability of the collections staff to collect funds from customers. It operates at a somewhat higher level of precision than the days sales outstanding (DSO) measurement, and so is finding increasing popularity among collection managers.
The collection effectiveness index compares the amount that was collected in a given time period to the amount of receivables that were available for collection in that time period. A result near 100% indicates that a collection department has been very effective in collecting from customers.
Formula for the Collection Effectiveness Index
The formula for the CEI is to combine the beginning receivables for the measurement period with the credit sales for that period, less the amount of ending receivables, and then divide this number by the sum of the beginning receivables for the measurement period and the credit sales for that period, less the amount of ending current receivables. Then, multiply the result by 100 to arrive at a CEI percentage. Thus, the formula is stated as:
((Beginning receivables + Monthly credit sales - Ending total receivables) ÷ (Beginning receivables
+ Monthly credit sales - Ending current receivables)) x 100
Related AccountingTools Courses
Disadvantages of the Collection Effectiveness Index
There is one disadvantage to using the collection effectiveness index. First, a collections manager can drive a high CEI number by focusing on the collection of the largest receivables. This means that a favorable CEI can be generated, even if there are a number of smaller receivables that are very overdue. This could result in a collections manager being measured as highly effective without ever making collection calls to the smallest accounts.
Collection Effectiveness Index vs. Days Sales Outstanding
Days sales outstanding (DSO) is the average number of days that receivables remain outstanding before they are collected. The DSO calculation tends to be less accurate than the CEI measurement for very short periods of time, since it includes receivables from prior periods that do not directly relate to the credit sales figure in that calculation. Conversely, the CEI figure can be calculated for a period of any duration, such as a single month.