What it means
Credit control teams have long relied on days sales outstanding, which converts the receivables balance into an average number of days. That measure is useful but blunt, because it moves whenever sales volumes change even if collection performance is identical.
The collection effectiveness index answers a narrower question: of the cash that was available to be collected during the period, what share came in? Anything still sitting in receivables that was not yet due is excluded, so the index isolates the performance of the collections process itself.
A score in the low 90s is generally considered strong, while anything below the mid 70s usually points to a real problem with invoicing accuracy, credit terms or follow up. The trend matters more than the level, because a business with long standard terms will always look different from one that sells on 14 days.
The index is also more resistant to seasonality than days sales outstanding. A quiet trading month shrinks sales and can flatter the days measure while the index stays honest, which is why many finance teams report both side by side.
Behind the number, effective collection is mostly an operational discipline rather than a financial one. Accurate invoices sent on the day of delivery, a clear escalation path, and someone whose actual job is chasing tend to move the index further than any change to the reporting.
In practice
Real-world examples.
Example
A commercial printer's days sales outstanding jumps from 44 to 52 days and management fears a collections breakdown. The collection effectiveness index is steady at 93%, and the real cause turns out to be a large late quarter order that simply had not fallen due yet.
Example
A staffing agency ties part of its credit control team's bonus to the collection effectiveness index rather than to cash collected. The change stops the team from chasing only the easiest invoices and pushes the index from 81% to 91% over two quarters.
Example
A building materials merchant tracks the index by branch and finds one site sitting at 68% while the group averages 92%. The branch had been issuing delivery notes without matching invoices, so a fifth of its work was never billed on time.
Think of it
“Collection effectiveness shows how good you are at collecting money owed-your collection success rate.
Formula
Calculation
Collection effectiveness index = (opening receivables + credit sales - closing total receivables) / (opening receivables + credit sales - closing current receivables) x 100
A commercial cleaning company starts the quarter with $800,000 of receivables and makes $3,200,000 of credit sales. It ends the quarter with $960,000 of receivables in total, of which $800,000 is not yet due and $160,000 is overdue.
Numerator = $800,000 + $3,200,000 - $960,000 = $3,040,000, which is the cash actually collected. Denominator = $800,000 + $3,200,000 - $800,000 = $3,200,000, which is everything that could have been collected.
Collection effectiveness index = $3,040,000 / $3,200,000 x 100 = 95%. The company brought in 95% of the money that was genuinely available to collect, leaving $160,000 overdue at the quarter end.Case study
Seen in the real world.
This illustrative story features an entirely fictional business. Thorn Valley Instruments, an invented maker of laboratory equipment, had a credit control function that reported one number each month: total cash collected. In a growing year that number rose steadily, and nobody looked further.
A new financial controller calculated the collection effectiveness index for the previous eight quarters and found it had slid from 94% to 76% while collections grew, because sales had grown faster still. Overdue receivables had quietly tripled to $2,100,000 and included several accounts more than 180 days old.
The fictional company introduced a weekly overdue review, tightened credit limits for two large accounts and started issuing invoices on despatch rather than at month end. The index recovered to 91% within three quarters, and the business released roughly $1,300,000 of cash without selling anything extra.
Watch out
Common mistakes.
- Using days sales outstanding alone and reading every movement in it as a change in collection performance rather than a change in sales mix or timing.
- Including receivables that are not yet due in the overdue figure, which drags the index down and hides where the real problem sits.
- Chasing the easiest invoices to hit a cash target while genuinely difficult accounts age quietly in the background.
Questions
People also ask.
What counts as a good collection effectiveness index?
Most businesses treat 90% and above as strong, though the sensible benchmark is the company's own trend and its industry's payment culture.
Does the index work for a business with very few customers?
It does, but with a handful of large accounts one late payment swings the result, so the underlying account by account detail matters more than the percentage.
Can the index be calculated monthly?
Yes, and monthly is common, though quarterly figures are steadier for businesses with lumpy invoicing patterns.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%