Close
Accounts Receivable

5 Accounts Receivable KPIs You Should Be Trackingโ€”And Why

Celonis
by Celonis
January 07, 2021
7 min read

2020 was a difficult year for Accounts Receivable (A/R). Global economic and operational uncertainty forced millions of businesses to refocus on the importance of cash to ensure their survival. And practically speaking, that means pushing A/R and collections teams to collect more cash from a customer base thatโ€™s less likely to pay on time than ever.

Thatโ€™s a tough task by anyoneโ€™s standards. But the upside is that this increased focus on cash has put A/R in the spotlight once more, and driven more organizations to think critically about how they measure and enable effective and productive collections.

If 2020 was the year of disruption, 2021 will be the year of recalibration. As companies focus on recovery and building their organizations back to full strength, their A/R teams and processes need to be able to execute at maximum capacity.

To help, weโ€™ve brought together five KPIs you should be measuring to get a comprehensive picture of A/R performance โ€” and get a clearer idea of where and how your teamโ€™s performance can be improved.

KPI #1: Average Days Delinquent (ADD)

Average Days Delinquent (ADD) provides a decent snapshot of your overall collections performance โ€” making it a valuable metric for those looking to gain a quick, reliable view of how their team is executing at a glance.

This is largely thanks to how simple the KPI is to calculate, and how reliable and accessible the data inputs for it are. All ADD is concerned with is the due date of a receivable (usually captured reliably in contracts and invoices), and the paid date of that receivable (reliably captured at the point of payment).

At the most basic level, ADD offers a valuable, high-level view of collections performance, while asking very little of you or your team. Thereโ€™s no data deep-dive to do, very little scope for bias or inaccuracy to creep in, and the calculation behind it is very straightforward.

Recent research by Celonis found that the highest performing organizations were able to achieve an ADD of just 8 days. But across all organizations, the average figure was 29.9 days. If your figures are above that number, youโ€™ve likely got some collections performance issues on your hands. If you want to understand where those issues may be coming from, youโ€™ll need to look at some other, more advanced metrics.

KPI #2: Days Sales Outstanding (DSO)

DSO is the most commonly tracked KPI for Accounts Receivable โ€” and for good reason. By determining the average number of days it takes to collect payments, you can monitor cash flow at an individual customer and organizational level.

By helping to identify problem payers and the customers frequently pushing your ratio up, DSO starts to highlight some basic next steps and priorities for improving collections execution. It helps you understand at a very basic level where issues may be originating from on the customer side. Fluctuations in DSO can even help you understand how different market forces influence payment times, so you can adapt your A/R strategy accordingly.

Lower average DSO is obviously better when it comes to maximizing cash flow, but very low DSO is typically only possible for those in certain industries, such as retail. Payment terms and collection effectiveness are the twin levers here.

KPI #3: Percentage of Current A/R

The big problem with DSO is that it doesnโ€™t consider receivables before theyโ€™re due. Itโ€™s only concerned with receivables that have already become a problem. So it canโ€™t do anything to help your collections team work proactively. Thatโ€™s where percentage of current A/R comes in.

Percentage of Current A/R helps you better understand the relative distribution of current and overdue receivables. Instead of just looking at the payments that are late, it helps teams to be more proactive about high-value receivables that are about to come due.

Percentage of Current A/R is helping to drive a real transformation in A/R departments. Itโ€™s supporting a shift in mindset and showing teams that to execute at maximum capacity and deliver the best results, they need to shift their focus away from just the oldest receivables, and instead focus on the trifecta of age, value, and risk That way, teams can recover more cash, faster, and waste less time on delinquent payments that are never going to come in.

KPI #4: Collections Effectiveness Index (CEI)

Understanding the execution gaps in your collection processes โ€” and how to eliminate them โ€” is vital when maintaining tight control over your cash. But it can be difficult to see exactly where your teams are working ineffectively. And metrics like DSO, which only provide an overall sense of your cash flow health, donโ€™t provide a complete, reliable picture.

Your Collections Effectiveness Index (CEI) however, looks specifically at the effectiveness of your collections department at securing overdue payments within a specific time period. By calculating the percentage of collected payments against available receivables, you can see clearly whether or not you might have a problem. Technology like Process Mining or EMS can then more specifically identify where the execution gaps might be.

Ideally, this number should be above 80%, with the best A/R departments out there reaching 83% CEI. If it drops, thatโ€™s a clear indication that something is getting in the way of your execution capacity โ€” whether thatโ€™s your customerโ€™s health, how youโ€™re targeting specific accounts, or team efficiency.

As your organization and A/R department evolves, tracking this metric frequently and over shorter time periods provides you with up-to-date insight into gaps in your processes, as they occur.

KPI #5: Operational Cost Per Collection

For many organizations, COVID recovery efforts will naturally focus on strategic short-term goals and improvements โ€” the kinds of changes that keep them stable and operational. But during times of change, itโ€™s also important to consider how decisions today could support long-term efficiency gains.

Tracking Operational Cost Per Collection is hugely valuable for supporting long-term improvement and optimization of collections. Itโ€™s one of very few metrics that looks beyond receivables alone, and considers how your teamโ€™s execution capacity โ€” and the processes surrounding them โ€” could be maximized to deliver more collections at a lower cost.

Tracking this KPI wonโ€™t help you find quick fixes. Nor is it likely to help you understand how your performance stacks up against competitors. And frankly, building a reliable view of your cost per collection based on accurate data thatโ€™s free from bias is a difficult task (although one which the right technology can simplify significantly).

But, when tracked accurately, it can support significant changes and optimizations across the A/R department. Take a change like process automation for example. Accurate cost per collection data can help you understand where automation can be applied to help you maximize the execution capacity of your team and deliver the best results.

More and more A/R teams are realizing that thereโ€™s only so much they can do to drive collections using the methods and metrics they have in place today. Becoming more proactive has a big role to play in changing that, but so too does looking inward for opportunities to improve efficiency by maximizing your departmentโ€™s capacity to execute.

Cost per collection is a hugely valuable tool for teams interested in delivering those internal optimizations and improvements.

Set yourself up for the future of A/R

2020 wasnโ€™t easy on anyone, but things are at least looking better for 2021. A/R teams have felt and weathered the disruption โ€” now itโ€™s time to define what they want their lasting โ€˜new normalโ€™ to look like.

The metrics outlined above can all play an important role in A/Rโ€™s transformation and advancement. By providing unique views of performance, and the sources of A/R challenges, they can contribute to an A/R department thatโ€™s both highly aware of its current performance, and clear on what needs to be done to maximize their execution capacity, improve operations and bring more cash into the business.

To find out how Celonis can help you optimize these KPIs and maximize execution capacity in Accounts Receivable, take a look at our Execution App for Collections Management.

Celonis
Celonis
Author

Celonis believes that every company can unlock its full execution capacity. Powered by its market-leading process mining core, the Celonis Execution Management System provides a set of instruments and applications, the Celonis Studio as well as platform capabilities for business executives and users. The Celonis EMS offerings help companies manage every facet of execution management from analytics to strategy and planning, management, actions and automation.

Subscribe to our newsletter

Insights to inbox - Monthly newsletter

Thank you for your subscription

New Subscription
Please enter an email

By submitting this form, you confirm that you agree to the storing and processing of your personal data by Celonis as described in our Privacy Policy

Celonis World Tour 2021: October 5-14

Master Data-Driven Business Execution. 8 virtual events worldwide.

Dear visitor, you're using an outdated browser. Parts of this website will not work correctly. For a better experience, update or change your browser.