>CRS Reports > Billing > Attrition



Report Overview

The Attrition report lists the monthly attritionThe reduction in the number of memberships. percentages for the selected time frame. You can view a list of several months at once, and also view details for individual months. This report can be generated for one or multiple clubs.

Numbers on this report are rounded throughout.

Report data is available from January 2015 forward.


Report Columns

For each month, the report includes the columns in the table below.

Column Description
Monthly Attrition The negative impact divided by the average number of beginning and ending accounts.
Monthly Attrition Annualized

The monthly attrition multiplied by 12.

Rolling 12 Month Attrition

Uses a history of data in its calculation, including the negative impact and the ending number of accounts. Follow these steps to calculate Rolling 12 Month Attrition:

Follow these steps to calculate Rolling 12 Month Attrition:

  1. Find the sum of the previous 12 months' negative impact.
  2. Find the sum of the last 13 months' ending number of accounts and divide that figure by 13.
  3. Divide the sum in step 1 by the result in step 2.

Note: There must be 13 months of data available for the Rolling 12 Month Attrition figure to be calculated. If there is not enough data available, the calculation will be displayed as .00% until the data becomes available.


When to Use the Attrition Report

Use the Attrition Report to compare a club's attrition rate across months and clubs. Use drill-down reports to view one month of data and compare attrition for recurring and Cash/PIF accounts.

Use these reports in conjunction with the Attrition report to gain further details:

Use the Account Reconciliation report to compares the different explanations for positive and negative impact and to see individual accounts categorized. Use the Attrition report strictly to compare months to one another.


Generating the Report

The parameters page of the report allows you customize the data provided by selecting:

  1. Cycle - When you run the Attrition report, you can choose between viewing all available months or the most recent 13 months of data.
  1. Club(s) - Select one or more clubs to include in the report by moving clubs from the Available Clubs box to the Selected Clubs box.
  2. To add all available clubs to the Selected Clubs box, select the All Clubs check box.
  3. To select specific clubs, click the name of the club you want to move to the Selected Clubs box then click the arrow pointing toward the Selected Clubs box.

  1. Report Format - Select a report format then run or queue the report.
  2. Once you have made your selections, run or queue the report.

The parameters page is displayed below.


Sample Report

When you select multiple clubs, the report will include an aggregate report as well as individual club reports. The aggregate report shows the average attrition rate for all selected clubs. To view attrition for a specific club, navigate to the individual club report. For help navigating to an individual club report, click here.

Below you can view a sample aggregate report.

To see monthly attrition details, click a month. The aggregate report will generate monthly details for all clubs selected.

Please note that negative impact includes transferred accounts, expired accounts, cancelled accounts, and accounts in RFC status.

In some cases, the Net Ending # Accts will not be equal to the Beginning # Accts + Positive Impact - Negative Impact. This occurs when a member renews to a new type. For example, a member may have been categorized as Cash/PIF previously, then renewed to Recurring. In such cases, the member did not exit the club or re-join the club, which would have been classified as positive or negative impact. Instead, that member is simply accounted for under a different category.

In the image below you can see how this scenario would be represented in the report. Recurring accounts are down by three, while Cash/PIF accounts are up by three. No members were lost; however, three members renewed from Recurring to Cash/PIF.