Skip to content
The AR AgentThe accounts receivable agent
Log in

Collection effectiveness index: what it measures and how to calculate it

By The AR Agent team · · 6 min read

The collection effectiveness index (CEI) is the percentage of the money a business could collect in a period that it actually collected in that period. It uses beginning receivables, credit sales and ending receivables. Published versions of the formula differ on the denominator, so write down which one you use and keep it the same from period to period.

What the collection effectiveness index measures

CEI answers one question: of the money that was owed to you, or became owed to you in the period, how much did you collect?

Beginning receivables are what customers owed you at the start of the period. Credit sales are the invoices you issued on credit during the period. Ending receivables are what customers still owe at the end. Put together, the amount collected is the beginning receivables plus the credit sales, minus the ending receivables.

Both sources we checked use that same amount collected. The difference is what it is divided by.

The formula, and why there are two versions

The amount collected is the same in both versions:

Amount collected = beginning receivables + credit sales - ending total receivables

The denominator is where they part.

  • Version A (Allianz Trade): CEI = amount collected divided by (beginning receivables + credit sales), multiplied by 100.
  • Version B (Versapay): CEI = amount collected divided by (beginning receivables + credit sales - ending current receivables), multiplied by 100.

Version B takes out the part of the receivables that is still current, so the result measures collection against the money that was due to come in. Version A does not. The two sources also define "current" receivables differently. Allianz Trade describes them as amounts due immediately or soon. Versapay defines its ending current figure as the payments received on credit sales in the period. A reader who uses both pages will get different numbers, and the difference comes from the formula and from the definitions.

Worked example with invented figures

Say a service business starts the month owed $100,000. It issues $60,000 of credit sales during the month. At month end it is still owed $40,000, of which $30,000 is not yet due.

  • Amount collected: $100,000 plus $60,000, minus $40,000, gives $120,000.
  • Version B denominator: $100,000 plus $60,000, minus $30,000, gives $130,000. CEI is $120,000 divided by $130,000, multiplied by 100, which is 92.3%.
  • Version A denominator: $100,000 plus $60,000, gives $160,000. CEI is $120,000 divided by $160,000, multiplied by 100, which is 75.0%.

The business collected the same money in both cases. A finance lead who moved from one page to the other would see a drop of about 17 points and think collections had got worse. Nothing about the collections changed, only the formula.

How to use it

  1. Choose one formula and write it down. Put it in the notes of the report, so the next person knows which version the number comes from.
  2. Use the same period each time. A monthly figure is only comparable with other monthly figures.
  3. Watch the trend, not one value. A single month can move for reasons that have nothing to do with chasing, such as one large invoice that was paid early or late.
  4. Read it next to the ageing report. CEI gives the percentage. The accounts receivable aging report shows which invoices make up the balance.
  5. Do not copy a target from a vendor article. The sources we opened give the formula but no target that applies to a small business, and the figure depends on the formula you use.

CEI is related to days sales outstanding, which also uses receivables and sales. DSO is a number of days. CEI is a percentage. They answer related questions, and they are not interchangeable.

Our view

Most finance leads we talk to already have an ageing report and a figure for cash collected. What they often lack is a reason to act on either. A fractional CFO we spoke to put it this way: the dashboards show what is late, but give the person chasing nothing to do about it.

So we think a CEI figure is worth tracking only if a fall leads to a question about the invoices behind it. Which invoices did not pay in the period? Is one missing a purchase order, sitting in a dispute, or waiting on a promise that was missed? A percentage on its own does not answer any of those. The invoices do, and the record of what happened to each one is where the CEI figure should lead.

Frequently asked questions

Is the collection effectiveness index the same as DSO?

No. Both use receivables and sales, but DSO expresses how many days of sales are tied up in unpaid invoices, and CEI expresses the share of collectable money that was collected in the period. Use the DSO guide for the days figure, and this page for the percentage.

What is a good CEI?

This page does not give a target. The sources we opened describe the formula, not a benchmark a small business can rely on. Use your own history instead: the same formula, the same period length, and the trend over the last several months.

Which formula should I use?

Either one, as long as you write it down and keep it. The sources disagree, so neither version is the standard. If you report to an owner, a lender or an accountant who uses one of them, use theirs so the numbers match.

Where do I get the figures?

Take the beginning and ending receivables from your receivables or ageing report at the start and end of the period. Take credit sales from the sales for the period. If you use the Versapay version, you also need the part of ending receivables that is still current, which is the amount not yet due at the end of the period.

How The AR Agent handles this

The AR Agent follows up overdue invoices by email and works from the invoices in QuickBooks or Xero. It reads customer replies and turns "I'll pay Friday" into a tracked payment promise, with a next step if the promise is missed. It identifies blockers such as a missing PO, an invoice query or the wrong contact, and it pauses chasing when a customer disputes an invoice and brings it to the right person. It keeps a complete history of every email, promise, blocker and action against the customer and the invoice. That history is the detail behind any figure for what was collected in a period.

Talk to us: our AI agent chases your invoices until you are paid.

Sources

Let us chase your overdue invoices

Connect QuickBooks or Xero and your finance inbox. We’ll help you set it up. No card or contract.

Accounting software

No card required.