Collections teams are often judged on a single number: how much cash came in. But cash depends on how much was billed, so a good month and a good process are not the same thing. The Collection Effectiveness Index, or CEI, answers a sharper question: of everything we could have collected, how much did we actually collect? Here are the answers to the questions people ask most.
What is the Collection Effectiveness Index?
CEI is a percentage that measures how well a team collects the receivables that were collectable during a period, usually a month. A score of 100% means everything that could have been collected was collected. Lower scores mean money was left behind.
What is the CEI formula?
CEI = (beginning receivables + credit sales − ending total receivables) ÷ (beginning receivables + credit sales − ending current receivables) × 100
- Beginning receivables. Total amount owed to you at the start of the period.
- Credit sales. Invoices raised on credit during the period.
- Ending total receivables. Everything still owed at the end, current and overdue.
- Ending current receivables. The part of that balance that is not yet due. It is excluded from the denominator because nobody could reasonably have collected it yet.
Can you show a worked example?
Suppose that in September you start with 500,000 in receivables and raise 800,000 in credit sales. At month end you are owed 560,000 in total, of which 440,000 is still within terms and 120,000 is overdue.
- Numerator: 500,000 + 800,000 − 560,000 = 740,000
- Denominator: 500,000 + 800,000 − 440,000 = 860,000
- CEI: 740,000 ÷ 860,000 × 100 = 86.0%
The team collected 86% of what was collectable. The remaining 14% is the overdue balance that carried over. Only the overdue 120,000 is the real follow-up work.
How is CEI different from DSO?
Days sales outstanding (DSO) tells you how long, on average, it takes to get paid. Using the same figures, DSO is 560,000 ÷ 800,000 × 30, about 21 days. It is a speed measure, and it moves with sales volume, seasonality and payment terms. A big invoice raised on the last day of the month can push DSO up even if your team did nothing wrong.
CEI measures effort and results against what was actually due. Because it ignores current receivables, it is fairer to collectors and less distorted by timing. The two work best together: DSO shows the cash cycle, CEI shows how well the team is working it.
How do you interpret the result?
- 100%: the ideal. Every collectable amount was collected.
- 80% and above: a common target and generally healthy.
- Below 80%: overdue balances are building up. Look at specific customers and invoice ages.
Targets vary by industry and payment terms, so track your own trend over several months rather than chasing a single number.
What moves CEI up or down?
Things that raise it
- Clear invoices that are accurate and sent on time.
- Reminders before and right after the due date.
- Quick resolution of disputes.
- Credit checks and sensible terms for new customers.
Things that lower it
- Invoice errors that trigger disputes.
- Large customers who habitually pay late.
- Unapplied payments that leave paid invoices open.
- Collecting only when someone remembers.
What mistakes should you avoid?
- Using different periods. Beginning and ending figures must cover the same period.
- Including cash sales. Only credit sales belong in the formula.
- Misclassifying current and overdue. Aging errors change the denominator and the score.
- Ignoring write-offs and credit notes. Decide how you treat them and stay consistent.
- Judging one month alone. A single large payment can swing the figure, so watch the trend.
What does a monthly CEI routine look like?
- Close the month and confirm that payments are applied.
- Pull beginning, ending total and ending current receivables from your aging report.
- Calculate CEI, and DSO next to it.
- List the five largest overdue accounts and agree an action for each.
- Record the result and compare it with the previous three months.
A spreadsheet is enough to start. If you would rather not rebuild it every month, FulcrumGrid Collection tracks invoices, ageing and follow-ups in one place, so the inputs for CEI are always current. Whichever tool you use, the habit matters more than the software.
Frequently asked questions
What is a good Collection Effectiveness Index?
Most teams aim for 80% or higher, and 100% is the ideal. The right target depends on your industry and payment terms, so compare against your own past results.
Can CEI be above 100%?
Not normally. If it is, check for data problems such as payments applied to the wrong period, credit notes, or mismatched receivable balances.
Should I use CEI or DSO?
Use both. DSO shows how long payment takes, while CEI shows how effectively your team collects what is due.
How often should I calculate CEI?
Monthly is the usual rhythm. Weekly can help during a collection push, but short periods make the figure swing more.
FulcrumGrid Collection
Keep collections on track every month
FulcrumGrid Collection helps you follow up on overdue invoices and see ageing at a glance, so your CEI inputs are always up to date.