How to use this
calculator?

This CEI calculator determines a finance team’s CEI, a measurement that shows how much was collected from a pool of all available accounts receivables which indicates the effectiveness of a team’s collections process.

  • Beginning receivables: A businesses open receivables at the start of the month.
  • Ending total receivables: The total of open receivables including current and overdue receivables at the end of the month.
  • Ending current receivables: The number of open receivables that are not overdue.
  • Monthly credit sales: The sales made by extending credit in that month.

COLLECTIONS
EFFECTIVENESS INDEX
CALCULATOR

Beginning receivables

$

Ending total receivables

$

Ending current receivables

$

Monthly credit sales

$

What is CEI?

CEI is the calculation of a company’s ability to collect payment from customers. The benefit of CEI is that it’s an effective measure at shorter intervals (weekly/monthly), while DSO is more accurate with a volume of data feeding it. DSO is more useful at quarterly, semi-annual, or annual intervals, with CEI used in the interim.

What is a “good” CEI?

Since CEI is the percent of invoices paid in a given period, 100% is the perfect score. Averaged across all industries, data from Credit Research Foundation show a CEI median near 85%, but much lower (55-65%) in transportation and fabricated metal. Food products, petroleum, coal, chemicals, and electrical products have demonstrably higher CEIs, tipping the scales at 97% or more.

How to improve your CEI?

Evaluate and align your accounts receivable team, tools and protocols with the company’s AR goals to improve your collections process.

Understanding CEI allows businesses to identify potential inefficiencies in their current process, this can be improved by looking at:

  • Credit Policy – Look at how your company determines creditworthiness, terms and conditions for making sales and agreements.
  • Invoicing – Define a clear process for sending and following up on invoices, look to automate your tasks to improve efficiency.
  • Data management – Mitigate the chance of human error with technology automatically inputting data and recording tasks.
  • Payment communications - Flexible payment options mean your customers have control over how, when and where they pay. Resulting in more prompt and on time payments.

Download our Ultimate AR Collections Benchmarks Report to learn more tips on how to improve your Collections Effectiveness Index and every other key metric you’ll need to become a revenue hero. You can also book a consultation with one of our AR experts to discover the power of Smart AR and you could reduce your DSO by 34% on average.

Want to learn how AR AUTOMATION CAN IMPROVe your CEI?