You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Reports - CM/MZ > Renewal Rate
Renewal Rate
print icon

Renewal Rate is the percentage of members that renew their membership over a given time period.

CALCULATION: # of Renewals ÷ Eligible Members = Renewal Rate

Example:

# Renewals = 273

# Eligible Members = 326

Calculation: # of Renewals ÷ Eligible Members.

273 ÷ 326 = .83 

Member has a 83% Renewal Rate.

Your # of Renewals can be found using the Receipts by Member Report:

  1. Click Billing in the left-hand navigation panel.
  2. Click the Reports tab.
    Billing Reports Tab.JPG
  3. In the Sales section, click Payment/Receipts by Member.
    Pay Receipt by Member.JPG
  4. Select Dues in the Fee Item Type drop-down.
  5. In the Payment Date Between and And fields, filter for payments made in the desired date range (example 1-1-2017 – 12-31-2017)
  6. Enable Member Join Date Before and enter the first date in your desired date range (1-1-2017).
  7. Click View Report.
  8. Click the excel link to export the report, to easily count the # of Renewals. Members that paid Member Dues during the specified date range and that were members previous to the Member Join Date Before date are considered a Renewal.

 

Eligible Members can be found by using the Sales by Member report:

  1. Click Billing in the left-hand navigation panel.
  2. Click the Reports tab.
    Reports Sales by Member.jpg
  3. In the Sales section, click Sales by Member.
    Sales by Member Summary.JPG
  4. Set the Sale Date From and To for the desired date range (example 1-1-2017 – 12-31-2017)
  5. Set the Member Join Date from your earliest Member Join Date (example: 1-1-1990). NOTE: You can use the Custom Member report to find your earliest join date.
  6. Set the Through date to the day just prior to the specified date range (12-31-2016).
  7. Set the Item Type to Member Fees/Dues.
  8. Click Refresh Report.
  9. Download the report results to Excel, to count the members that were invoiced this will be the Eligible Members.

 

Feedback
0 out of 0 found this helpful

scroll to top icon