The 21st Minute

Blog Image

Identifying Churn in AR

IDEA Tech Tip

Customer churn (also known as customer attrition, turnover, or defection) is when a customer decides to stop engagement with your company.

IDEA can help easily identify “churn” in accounts receivable by following these steps:

Perform a File Compare between the current and prior year databases. A File Compare will take the detail AR from both years, summarize, and join the databases. A difference column calculating the current and prior year balances will be created automatically. To determine potential AR churn, index the field containing the number of records (NRECS_2017) for the current year in ascending order. If that customer has a balance from the previous year, then it tells us that although they have a balance in both years, the decrease in activity (NRECS_2017 vs. NRECS_2016)) suggests that customer engagement has dropped off.

AR Churn Analysis

Tech Tip

Posted By


Related Posts
Give Python a Go
Mar 29 Python is considered the official programming language for non-programmers. It gives you increased flexibility and expansive access to your data. For those usin...
5 Avenues for Importing Data into IDEA
Nov 21 One of the greatest benefits to CaseWare IDEA is the sheer amount of data it can read and make universally consumable – both in file types and in data...
Infusing Python into Your Analysis with IDEA
Oct 06 The tech community often refers to Python as the official programming language for non-programmers. It’s free and easy to learn (even if you don’t know wher...

This website has been designed for modern browsers. Please update. Update my browser now