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
Importing Date Fields
Jul 24 There are times when you import a date field and it just does not work out as expected. Here are ways to address the problem before or after the import.  ...
Tech Tip: Understanding Join and Visual Connector
Jun 19 Using IDEA’s Join and Visual Connector features can help you search for matches and correlations between different data sets, but they are often confused with...
Tech Tip: Transforming Your Data
May 15 We are inundated with data on a daily basis. Here are a few time-saving tips for transforming your raw or jumbled data into useful information.   Adding...

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