The Collection Effectiveness Index (CEI) estimates how effectively a company collected receivables that were available for collection during a period. Unlike days sales outstanding, which relates receivables to sales, CEI compares the reduction in total receivables with a denominator that excludes ending current receivables that are not yet due under the selected definition.
Key Takeaways
- CEI is usually expressed as a percentage and is most often calculated monthly or over another short operating period.
- The formula uses beginning receivables, credit sales, ending total receivables, and ending current receivables.
- A result near 100% suggests that most eligible balances were collected, but no universal target applies across businesses.
- Write-offs, credits, returns, acquisitions, foreign exchange, factoring, and classification choices must be reconciled.
- CEI complements DSO and aging schedules; it does not measure profitability, cash adequacy, or credit loss by itself.
A common form is:
$$
\text{CEI} = \frac{\text{Beginning receivables}+\text{Credit sales}-\text{Ending total receivables}}{\text{Beginning receivables}+\text{Credit sales}-\text{Ending current receivables}}\times100
$$
In this formula:
- Beginning receivables are total receivables at the start of the period.
- Credit sales are sales added to receivables during the period.
- Ending total receivables include current and past-due balances at period end.
- Ending current receivables are balances not yet overdue under the chosen aging policy.
CEI is an operational metric rather than a standardized GAAP or IFRS measure. Organizations may define current balances, eligible accounts, deductions, and adjustments differently. Record the policy before comparing results.
Worked Example
Assume a company has the following monthly data:
- beginning total receivables: $1.0 million
- credit sales during the month: $5.0 million
- ending total receivables: $1.2 million
- ending current receivables: $0.8 million
The numerator is:
$$
\$1.0\text{m}+\$5.0\text{m}-\$1.2\text{m}=\$4.8\text{m}
$$
The denominator is:
$$
\$1.0\text{m}+\$5.0\text{m}-\$0.8\text{m}=\$5.2\text{m}
$$
CEI is:
$$
\frac{\$4.8\text{m}}{\$5.2\text{m}}\times100=92.3\%
$$
Under this policy and simplified data, the company collected or otherwise reduced about 92.3% of the amount treated as eligible for collection. Before treating the difference as collection failure, reconcile write-offs, returns, credit memos, disputes, currency effects, acquisitions, and receivables transfers.
CEI vs. DSO
| Measure | Main question | Strength | Limitation |
|---|
| CEI | How much of the amount eligible for collection was collected or reduced? | Focuses on collection execution and current-versus-overdue classification | Requires detailed and consistently classified receivables data |
| DSO | How many days of credit sales are represented by receivables? | Easy to trend and connects with the cash conversion cycle | Can be distorted by growth, seasonality, and sales mix |
| Receivables turnover | How many times do average receivables cycle during the period? | Intuitive efficiency ratio | Hides invoice-level aging and overdue concentration |
| Aging schedule | Which balances are current or overdue? | Shows age distribution and customer-level risk | Does not summarize sales velocity in one ratio |
DSO can rise because sales slowed even if collections remain effective. CEI can deteriorate when overdue balances persist even if strong current sales keep DSO stable. Using the measures together provides a better diagnosis.
What Can Change CEI?
CEI can improve when invoices are accurate and timely, disputes are resolved, cash is applied promptly, collection activity is prioritized, or customer payment behavior strengthens. It can deteriorate when billing errors, deductions, delayed approvals, customer distress, weak follow-up, or concentration problems increase overdue balances.
Operational events can also change the arithmetic without reflecting ordinary collection skill:
- writing off old balances reduces ending receivables;
- selling or factoring receivables removes balances;
- acquisitions add receivables that were not generated by period sales;
- foreign-exchange movements alter translated balances;
- credit notes and returns reduce receivables without cash collection; and
- changing the definition of current receivables changes the denominator.
How to Calculate CEI Reliably
- Define the period, receivables population, aging policy, and current bucket.
- Reconcile beginning balances, credit sales, cash receipts, credits, write-offs, and ending balances.
- Exclude or separately disclose acquired, sold, pledged, or factored receivables.
- Apply consistent treatment to disputes, unapplied cash, and customer deductions.
- Calculate by customer segment, region, or business unit when the aggregate hides concentration.
- Trend CEI with DSO, overdue balances, bad-debt expense, and cash collections.
- Investigate out-of-range or abrupt results rather than assuming the formula is self-explanatory.
Interpreting Results
A higher CEI generally indicates stronger collection against the defined eligible pool. A lower result can indicate growing overdue balances or weaker collection, but the cause may also be measurement, timing, or portfolio mix.
Results above 100% or below 0% can occur when adjustments, recoveries, reclassifications, acquisitions, write-offs, credits, or mismatched data affect the formula. Such values should trigger reconciliation rather than be accepted as ordinary performance.
Common Mistakes and Limitations
- Calling CEI standardized: formula policies and aging definitions can vary.
- Treating receivables reduction as cash collection: credits, write-offs, returns, and transfers also reduce balances.
- Ignoring the current-balance definition: invoice date, due date, grace period, and dispute status can change classification.
- Comparing different periods blindly: sales cycles and seasonality can change the eligible pool.
- Using unreconciled systems: billing, ledger, aging, and cash-application data may not agree automatically.
- Optimizing one metric: aggressive collection can damage customer relationships or profitable sales.
- Ignoring concentration: a strong aggregate CEI can coexist with a severe exposure to one customer.
- Replacing aging review: CEI does not show which invoices or customers create the risk.
Source Records to Check
CEI usually requires internal operational data beyond public financial statements. Relevant evidence includes the accounts-receivable ledger, aging report, invoice and due-date data, credit memos, write-offs, disputes, cash receipts, and subsequent collections. For public-company context, the SEC investor bulletin on reading a Form 10-K explains where receivables, accounting policies, concentrations, risks, and management discussion may appear.
FAQs
What is a good Collection Effectiveness Index?
There is no universal target. A higher result generally indicates more effective collection under the selected policy, but compare consistent periods, customer segments, contractual terms, and aging quality rather than relying on one threshold.
Can CEI replace DSO?
No. CEI focuses on collection against balances eligible for collection, while DSO relates receivables to credit sales. They reveal different effects and are stronger when used with an aging schedule.
This page is educational and does not provide accounting, credit, collection, legal, investment, or valuation advice.