What Collection effectiveness index (CEI) means, why it matters, and how finance teams control it in practice.
A measure of how much of the money available to collect in a period was actually collected, expressed as a percentage.
CEI = (opening receivables + credit sales − closing total receivables) ÷ (opening receivables + credit sales − closing current receivables) × 100. A result close to 100 means almost everything collectable was collected.
Unlike DSO, CEI is less affected by changes in sales volume, so it isolates how well the collections team performed.
Calculate it monthly from the same ledger figures as DSO and track the trend. "Current" means not yet overdue under your terms. Because the result can be distorted by one unusually large receipt or write-off, read it with the ageing report and note any one-off items when you report it.
Applies the payments your customers make to the invoices they are paying, including part-payments and one payment for several invoices, and shows what is still owed. Runs in your browser on your own computer: nothing is uploaded.
The Credit Control & Receivables System calculates ageing, DSO, best-possible DSO and CEI from the ledger, shapes a bad debt provision to IFRS 9 / ASC 326 logic and requires independent approval for credit limits and write-offs. Excel, no macros, one-time price.
All glossary terms · All cash & credit guides
Last updated 15 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.