How to Forecast Membership Revenue, Redemptions, and Capacity
Short answer: To forecast a membership, estimate monthly new members, cancellations and average fee to project active members and revenue. Then estimate redemption to project the treatments and provider hours members will use. Compare that capacity with your calendar, and update the forecast monthly with actual data.
Key takeaways
- Forecast active members from new joins and cancellations.
- Revenue = active members × fee.
- Project redemptions and the capacity they require.
- Update with actual data every month.
Why forecast more than revenue?
A growing membership can quietly fill the calendar with included treatments, leaving less room for full-price appointments. Forecasting redemptions and capacity alongside revenue shows whether growth is sustainable.
It also highlights when you'll need more provider hours.
What does the forecast include?
- Starting members, new joins and cancellations per month
- Active members and monthly revenue
- Expected redemption per member
- Treatments and provider hours required
- Available capacity and remaining room for other bookings
How does the membership forecast worksheet help?
The forecast worksheet includes monthly inputs, a hypothetical example and controls for keeping it accurate.
Resource 059 is organized into these sections:
- Monthly inputs
- Hypothetical example
- Controls
For the calculation, use tab “059 Membership forecast” in the Aesthetic Intelligence Calculation Workbook. Blue cells are editable inputs.
Download Resource 059: Membership forecast worksheet →
Frequently asked questions
How far ahead should we forecast?
Twelve months, updated monthly.
What if redemption exceeds capacity?
Limit new memberships, adjust benefits or add capacity before quality suffers.
Should prepaid revenue be recognized immediately?
Ask your accountant. Revenue treatment depends on how benefits are delivered.
What should you do next?
Download the free membership forecast worksheet and complete it with your team this week.
Bring your numbers, team and growth plan together.
The Revenue Room by Aesthetic Intelligence combines clinic management tools, customisable dashboards, branded resources and AI-assisted planning in one membership. Stress-test pricing, packages, memberships and promotions using interactive financial tools and clear business reporting.
Monthly expert strategy consulting and a personalised strategy plan help you turn that insight into practical action. $129/month per clinic. One membership. Complete access.
Launching November 2026. Join the free waitlist, no payment today.
Download the resource → · Join the Revenue Room waitlist →
Related reading
- How to Introduce a Clinic Membership Without Confusing Patients (Resource 058)
- What to Include in a Clear Treatment Quote (Resource 060)
- How to Create Consistent Patient Service Across Different Providers (Resource 069)
About Aesthetic Intelligence. Aesthetic Intelligence helps aesthetic clinic owners and managers in Canada and the United States find missed revenue and turn it into practical action through strategy, operations systems, front-desk workflows and training. Founded by Chantel Allen, a former clinic COO with more than seven years of operations, AI and business-systems experience in Canadian medical aesthetics and longevity clinics.
Examples in this article are hypothetical. This is general operational guidance, not legal, financial, tax or medical advice. Clinical decisions belong with qualified clinicians, and advertising, privacy and consent requirements vary by province and state.