Collections Effectiveness Index (CEI) Calculator

By /

CEI Collections Effectiveness Index Calculator

Measure how efficiently you convert receivables into cash. Higher is better, with 100% representing perfect effectiveness for the period.

£
Opening A/R balance for the period.
£
Total credit invoices during the period.
£
Closing A/R at the end of the period.
£
A/R still within current terms at period end.
CEI: —
—
Show worked example
CEI = ((BR + CS − ER) / (BR + CS − ECR)) × 100
Example values: BR = 100,000; CS = 500,000; ER = 80,000; ECR = 20,000.
CEI = ((100,000 + 500,000 − 80,000) / (100,000 + 500,000 − 20,000)) × 100 = 89.66%

Tip: CEI complements DSO. CEI reacts quickly to in-period collection discipline even if DSO stays flat.

Free download included
Enjoyed this article?
Get more like it — free, every week
Join 10,000+ credit professionals who get the weekly Credit Brief — one insight, one tactic, one tool. Plus get the free Credit & Collections Glossary instantly on sign-up.
No spam. Unsubscribe any time.

Must Read

Scroll to Top
Free download included

Wait — before you go

Get the free Credit & Collections Glossary (120+ terms) plus the weekly Credit Brief — one insight, one tactic, one tool every week. Trusted by 10,000+ credit professionals.

Check your inbox — your free glossary is on its way!
Your subscription could not be saved. Please try again.
No spam. Unsubscribe any time.