Membership Revenue Calculator

Forecast what a membership base actually brings in: enter your member count, the fee per billing period and whether you bill monthly, quarterly or yearly, and this calculator returns monthly recurring revenue (MRR), the recurring revenue over your forecast window, joining-fee income kept on its own line, the combined total, and the annual run rate. It is built for gyms, studios, clubs, associations and subscription products that bill on different cycles and need the figures separated instead of blended into one number.

Quick Answer

How to use the membership revenue calculator

Enter the member count, the fee, and the billing cycle, set the forecast window, and click Calculate. You get five figures at once, each on its own line.

1. Number of members: the active base you are forecasting from. The pre-filled example uses 200.
2. Fee per billing period: what one member pays per charge, in the same rhythm as the frequency you pick. Quarterly billing at $135 means $135 every three months, not per month.
3. Billing frequency: monthly, quarterly or yearly. This is the input most rival tools leave out entirely.
4. Months to forecast: the planning window. Six months on quarterly billing is exactly two billing periods.
5. Joining fee and new members (optional): the one-time fee and how many people will pay it in the window. Blank or zero is fine; both fields default to 0.

Two reading rules keep the output honest. First, the badge under the total states what share of the window total is recurring: in the worked example, 93.1% repeats and the rest is one-time joining money, which matters when a lender or investor asks what next quarter looks like without a sign-up drive. Second, Copy and Share send the full breakdown (inputs, MRR, recurring, joining, total, run rate), so a pasted forecast still shows where every figure came from.

The membership revenue formulas

Five formulas produce the five outputs. Billing periods come first, because every recurring figure depends on how many times the fee lands inside the window.

The normalization is the same one billing platforms use. Stripe’s guidance on calculating MRR in Billing makes the point with an annual plan: a £1,200 yearly subscription counts as £100 toward MRR, because MRR is the monthly-normalized value of active subscriptions rather than the cash that happened to arrive this month. Keep that distinction and the run rate behaves: it annualizes the current base instead of extrapolating a good month’s collections. The U.S. Small Business Administration puts revenue forecasts in the same frame in its business plan guidance, where financial projections are built from stated revenue streams, memberships fees listed among them, instead of from a single hoped-for total.

Worked example: a 200-member studio on quarterly billing

The worked example is the pre-filled one, so you can reproduce every figure with one click. A studio bills quarterly, which is where monthly-only calculators start giving wrong answers.

MRR falls out of the same inputs: (200 × $135) ÷ 3 = $9,000.00 per month, and $9,000 × 12 gives the $108,000.00 run rate. Notice what the frequency did: a monthly-only tool fed “$135 fee, 6 months” would report $162,000 of recurring revenue, triple the real figure, because it assumes the quarterly charge lands every month. Four more runs, all verified against the calculator:

The last two rows deserve a second look. The 5-month row is prorated, covered in the next section, and the free-tier row shows why the joining line exists: a $0 fee is valid input, and the $500 of onboarding fees is the whole forecast.

Billing frequency and the forecast window

If the forecast window does not divide evenly by the billing cycle, the calculator prorates: it charges fractional periods instead of rounding to whole bills. A 5-month window on quarterly billing counts 1.67 periods and returns $45,000.00 of recurring revenue for the studio, which is the monthly-normalized value ($9,000 × 5), not the cash that two quarterly collection dates would actually bring in ($54,000).

Neither answer is wrong; they answer different questions. Prorated figures are the right basis for comparing periods, setting budgets and reporting MRR-based metrics, because they spread each payment across the months it buys. Cash planning is the opposite job: if rent is due monthly and dues land quarterly, you need the collection calendar, and the cleanest way to get it from this tool is to forecast in whole billing periods (3, 6 or 9 months on quarterly billing) so every period counted is a period collected. The normalization table below is the conversion the calculator applies per member:

Annual payers deserve one extra note. Their cash arrives once, but revenue recognition spreads it: record $100 a month of the $1,200 as earned, and the run rate stays smooth instead of spiking every January. That spread is also why the members in this forecast are really member months in disguise: 200 members held for 6 months is 1,200 units of exposure, the same counting the member months calculator formalizes for health plans and subscription books alike.

Multiple tiers, churn and discounts: what this forecast does not model

The forecast holds one member count at one fee, flat across the window. Tiers, churn and discounts are handled by adjusting the inputs, and this section shows the adjustments that stay honest.

Multiple tiers. Run each tier separately and add the totals, or blend the fee first. A club with 120 members at $50 a month and 80 at $90 has a weighted average fee of (120 × $50 + 80 × $90) ÷ 200 = $66, so one run at 200 members and $66 reproduces the tiered MRR exactly: $13,200. Blending works for MRR and recurring totals; run tiers separately when the tiers bill on different cycles or carry different joining fees. Knowing the revenue is only half the picture, though: the subscription box profit calculator covers the cost side for subscription offers, and capacity puts a ceiling on member growth that a gym occupancy check can size before you forecast past it.

Churn and growth. The tool has no churn input, deliberately: a single churn percentage hides whether losses land early or late in the window, and the revenue difference is real. The workable method is to forecast in shorter windows with stepped counts: this quarter at the current 200 members, next quarter at 194 if you expect a net 3% decline, and so on. If you do not know your decline rate yet, measure it with the churn rate calculator before building the stepped forecast. Discounts are simpler: enter the fee members actually pay after the discount, not the list price, and run the joining-fee fields at the waived amount (often $0 during promotions) so the promotion case and the list case stay comparable.

What competing calculators miss

Most membership revenue tools run one multiplication: members times monthly fee times months. Anything billed on a different rhythm breaks them before the first number appears.

The closest rival tools assume monthly billing outright, so a quarterly studio has to convert its fee by hand and a yearly club has to invent a monthly equivalent, with the error risk pushed onto the user. The fuller forecasters sit at the other extreme: the spreadsheet-style MRR projectors model growth and churn month by month, but they start from an MRR figure you must already have, inside a billing product’s funnel, and none of them accepts a member count and a fee. Tier-based MRR calculators handle SaaS pricing pages well and stop there: no forecast window total, no joining fees, nothing for a gym or association. This calculator takes the middle ground on purpose: members and fee in, frequency normalized properly, joining fees separated, and five labeled outputs (MRR, recurring, joining, total, run rate) that a spreadsheet has to be built to reproduce.

Frequently asked questions

Add This Calculator to Your Website

References