>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 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:

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


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:


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.

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.