Skip to main content

Reports: Revenue by membership

Membership revenue by type over time, and why the "Average Revenue over time" chart is actually a period total, not a mean.

A
Written by Alex Pogozo

What this report shows

The Revenue by membership report breaks your membership revenue down by membership type and shows how it trends over time. Use it to see which memberships bring in the most money and how that changes month to month (or week to week).

How to open it

Reports → FinancialsRevenue by membership.

What's on the page

Average Revenue over time ($) (chart)

A column chart of membership revenue by period, with a Month / Week toggle:

  • Month shows one column per month.

  • Week shows one column per week (weeks start on Monday). The Week view needs a date range. Until you pick one, Pogozo prompts you to "Select a date range to view by week".

Despite the word "Average" in the title, each column is the total revenue for that period, not an average per transaction — see How the numbers are calculated below.

Revenue by membership (pie chart)

A breakdown showing each membership type's share of the total membership revenue.

Breakdown table

One row per membership type, with these columns:

  • Membership = the membership type.

  • Number of memberships = how many memberships contributed to that row.

  • Revenue (ex tax) = the revenue for that membership, excluding tax.

  • Tax = the tax portion.

  • Discounts = discounts applied.

  • Refunded = amounts refunded.

  • Total = the total (tax-inclusive) revenue for that membership.

Filters and options

See Filters and date ranges for Location, Membership and the date controls.

Control specific to this report:

  • Month / Week This switches the chart between monthly and weekly periods. Weekly mode needs a date range and buckets by weeks that start on Monday.

How the numbers are calculated

"Average Revenue over time" is a period total, not an average

The Average Revenue over time ($) chart shows the total membership revenue for each period (each month, or each week) — not an average per membership or per transaction. The word "average" in the title refers to the chart, not to any averaging of the numbers.

Period revenue = the sum of all membership revenue that falls in that period

Worked example: in March you sold 8 memberships totalling $2,400. The March column shows $2,400 which is the total for the month, not $2,400 ÷ 8 = $300.

Printing and exporting

See Printing and exporting reports for how print and export work and the 1,000-row PDF limit.

Did this answer your question?