Collection effectiveness index (CEI): formula and example

The collection effectiveness index (CEI) compares the reduction in outstanding receivables after adding credit sales with the balance available to collect. Payment terms, which invoices are due, and non-cash adjustments can affect the result. A CEI of exactly 100% means no net past-due balance remained in the measured pool at period end, provided the denominator was positive. Check cash receipts separately if credits or write-offs reduced receivables.
Upload a case

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.

Worked example: one month

InputAmount
Receivables at the start of the monthEUR 400,000
Credit sales in the monthEUR 300,000
Total receivables at month endEUR 360,000
Current (not past due) receivables at month endEUR 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.

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.