Collection effectiveness index (CEI): formula and example
Key facts
CEI formula for one month: (opening receivables + credit sales − closing total receivables) ÷ (opening receivables + credit sales − closing current receivables) × 100. Current receivables are those that are not past due. The Credit Research Foundation’s reporting formula divides credit sales by the number of months in both parts of the ratio. The example below covers one month.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Worked example: one month
| Input | Amount |
|---|---|
| Receivables at the start of the month | EUR 400,000 |
| Credit sales in the month | EUR 300,000 |
| Total receivables at month end | EUR 360,000 |
| Current (not past due) receivables at month end | EUR 280,000 |
- Reduction in receivables after adding credit sales: 400,000 + 300,000 − 360,000 = EUR 340,000.
- Collectable: 400,000 + 300,000 − 280,000 = EUR 420,000.
- CEI: 340,000 ÷ 420,000 × 100 = about 81%.
The month-end past-due balance is EUR 80,000, or about 19% of the denominator.
How to use CEI
- Track it monthly and look at the trend rather than a single month.
- Read it with DSO. DSO expresses receivables as days of credit sales. CEI compares the reduction in receivables after adding credit sales with the amount available to collect. See how to calculate DSO.
- Reconcile credits and write-offs. A credit note or write-off can reduce receivables without a cash receipt. Reconcile those adjustments before calling the numerator cash collected. If the denominator is zero or negative, report CEI as not applicable for that period.
- Split it by team or region if different people handle different customers, so you can see where follow-up is working.
When CEI drops
A falling CEI usually means overdue balances are building up. Check the oldest items in an aging audit, look for disputes that are blocking payment, and apply your credit control policy to customers who keep missing dates.
For background on CEI and related measures, see the Credit Research Foundation’s national summary, which reports median CEI for participating US companies. If a business customer abroad stays overdue, you can open Debitura case intake.


.webp)