Glossary · Accounts receivable

Collection effectiveness index: definition and how it works in accounts payable

The share of receivables available for collection in a period that was actually collected, closer to 100% being better.

Definition

The share of receivables available for collection in a period that was actually collected, closer to 100% being better.

Also called: CEI

CEI = (opening AR + credit sales − closing AR) / (opening AR + credit sales − closing current AR) × 100

Example. Opening receivables of $600,000, credit sales of $900,000, closing receivables of $650,000 of which $420,000 is not yet due: CEI = ($600,000 + $900,000 − $650,000) / ($600,000 + $900,000 − $420,000) × 100 = 78.7%.

Key points

  • Unlike DSO it is not distorted much by a jump in sales near period end.
  • It should be measured monthly and compared over the same months each year.
  • Unapplied cash should be applied before measuring, or collections are understated.

Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.