ERP Consultant Network Blog


5 Accounts Receivable Management Key Performance Indicators: Part II

Written by Jeanne Lee on Fri, Dec 19, 2014

Accounts Receivable Management: 5 Ways to Increase Cash Flow

Accounts receivable management 3When it comes to increasing cash flow, are you finding that your numbers are not quite where you would like them to be? The first step is to learn about accounts receivable performance indicators, how they interact with each other, and what those interactions mean for your bottom line. There are a number of different things you can do and small changes you can make to improve your metrics and overall accounts receivable performance, such as:

  • Developing, refreshing, or re-evaluating your credit policy.
  • Standardizing your credit collections communications with templates.
  • Making sure you have the right number of employees focused on the task.

Previously, in part 1 of this blog series 5 Accounts Receivable Management Key Performance Indicators (KPIs) we covered 1. Days Sales Outstanding (DSO) and 2. Average Days Delinquent (ADD). In this article, we will cover the remaining 3 key performance indicators (KPIs) that can help CEOs, CFOs, controllers and credit managers increase cash flow by making accounts receivable efforts much more strategic than just making collection calls.

Accounts Receivable Management Key Performance Indicators (KPIs)

In part 1 of this blog series we covered the following topics:

1. Days Sales Outstanding (DSO)
2. Average Days Delinquent (ADD)

In this article we will cover:

3.    Collection Effectiveness Index (CEI)
4.    CEI vs DSO
5.    Accounts Receivable Turnover Ratio (ART)

Now let's cover the last 3 remaining accounts receivable management KPIs:

3. Collection Effectiveness Index (CEI)

Put most simply, the CEI compares how much money was owed to the company and how much of that money was actually collected in the given time period, usually one year. The resulting percentage allows the company to gauge how strong their current collections policies and procedures are and whether or not changes need to be made.

CEI= (Beginning receivables + Monthly credit sales – Ending total receivables) / (Beginning receivables + Monthly credit sales – Ending current receivables) x 100

The closer the resulting percent is to 100% the stronger your collections processes and policies are. A low or dropping percentage means it is time to re-evaluate your policies on selling on credit and the processes your collectors are following. If you find it is time to reevaluate your policies and procedures, download this guide to developing policy and procedure manuals that will get your CEI percentages to where they need to be.

4. CEI vs DSO

On the surface DSO and CEI sound very similar, but there is a very important difference to note. DSO provides insight into collections during one point in time, usually periods of less than a year. DSO also is a measurement of time, how long it takes for you to collect on an invoice once it is sent.

CEI measures the effectiveness of your collections performance over a longer period of time, generally a year although the formula can be manipulated for smaller segments of time. Additionally CEI differs from DSO because it is not a measurement of time, it measure the overall quality of your collections processes.

Generally DSO and CEI should move in opposite directions, which makes sense if you think about what each represents. There a few exceptions to this rule so don’t panic if yours are not behaving as such.

5. Accounts Receivable Turnover Ratio (ART)

The ART measures how many times your company turns accounts receivable into cash during a period; usually over one year.

ART= Net credit sales/average accounts receivable

A higher ratio means you are turning A/R into cash more frequently; if, for example, your ration is 2, you collect average A/R twice a year, every 6 months. The more frequently you are collecting, the higher your cash flow and liquidity.

Download the white paper below to learn some quick, simple, yet very effective ways to improve your accounts receivable management and get the above metrics where you need them to be.
e2b teknologies is a Microsoft Managed Partner providing cloud-based business software applications and business services to progressive businesses worldwide including ERP/CRM consulting and development, accounts receivable management software, SCM software, B2B e-commerce software, and other business software applications

Follow us on twitter @e2bteknologies

Another version of this blog was previously posted on July 30, 2014 on the Anytime Collect Blog site: Critical Metrics for Measuring Accounts Receivable Performance

Blog Updates

Get blog updates by email. Fill in your email and click subscribe.

Subscribe Here!



SAGE 100cloud BLOG





Related posts

Related Blog
Contact Us