Collection Effectiveness Index (CEI)

Collection Effectiveness Index (CEI)

See Also:
CEI vs. DSO
Key Performance Indicators (KPI’s)
How Does a CFO Bring Value to a Company?
5 Stages of Business Grief

Collection Effectiveness Index (CEI)

The Collection Effectiveness Index, also known as CEI, is a calculation of a company’s ability to retrieve their accounts receivable from customers. CEI measures the amount collected during a time period to the amount of receivables in the same time period. In comparison, the collection effectiveness index is slightly more accurate than daily sales outstanding (DSO) because of the time period. A company’s CEI can be calculated for any amount of time, small or large. Conversely, DSO is less accurate with shorter time periods, which is why DSO is calculated every 3 to 6 months.

The Collection Effectiveness Index Formula

Collection Effectiveness Index
The formula consists of the sum of beginning receivables and monthly credit sales, less ending total receivables. Then, divide that by the sum of beginning receivables and monthly credit sales, less ending current receivables. The value is then multiplied by 100 to get a percentage, and if a CEI percentage is close to or equals to 100%, then that means that the collection of accounts receivables from customers was most effective.
(Are you look for more ways to improve your cash flow? Click here for the free complete checklist guide to improve your cash flow!)

CEI and Your Business

The collection effectiveness index is one of the most useful tools a company can use to monitor the business financials. It measures the speed of converting accounts receivables to closed accounts, which then indicates new methods or procedures one can use to retrieve accounts receivables even more. If the CEI percentage decreases, then that’s a key performance indicator that the company needs to put in place in policies or investigate the departments in more detail.

How to Increase a Company’s CEI

Among other ways to reduce accounts receivable, the collection effectiveness index alerts when and how to change the process of retrieving those accounts. By monitoring cash in a company more frequently, financial leaders will notice a pattern and are more inclined to make a change quicker. Changing your policy from checking 3 times a year to 6 or 8 times a year, and the results that come from it, will show a substantial difference in a company.
Collection Effectiveness Index[box]Strategic CFO Lab Member Extra

Access your Flash Report Execution Plan in SCFO Lab.

Click here to access your Execution Plan. Not a Lab Member?
Click here to learn more about SCFO Labs[/box]

Collection Effectiveness Index

ARTICLES YOU MIGHT LIKE

The Struggles of Private Company Accounting

Hiring the right accountant  When I meet a business owner operating at a successful $10 million in revenue, they often mention, “My CPA”… I immediately know that CEO/Entrepreneur is referring to their Tax CPA.  That is because one thing that all Entrepreneurs have in common is that they must file a tax return.  So, from

Read More »

IN CRISIS? GET A STRATEGIC CFO! – CEO Blindspots Podcast

Friend of the firm, Birgit Kamps, recently had Strategic CFO President, Dan Corredor, as a guest on her podcast, CEO Blindspots. CEO BLINDSPOTS HOST: Birgit Kamps. She was speaking five languages by the age of 10, and lived in five countries with her Dutch parents prior to becoming an American citizen. Birgit’s professional experience includes starting

Read More »

SHRM calls ICHRA the 401K for Group Health Benefits

Fed-up with group health insurance? ICHRA is the new way to offer great health benefits and avoid ACA penalties, SHRM calls it the 401K for group health benefits.  In 2020 the Department of Labor, HHS and IRS changed the rules for employer health benefits. They changed the Affordable Care Act mandates and penalties for every

Read More »

JOIN OUR NEXT SERIES

Financial Leadership Workshop

MARCH 28TH-31ST 2022

SHARE THIS ARTICLE

JOIN THE NEXT STRATEGIC CFO™ SERIES

Strategic CFO™ Financial Leadership Workshop
The Art of the CFO®

Days
Hours
Min
Sec

September 12-15th 2022