Memberships and prepaid packages are a med spa's most valuable and most misunderstood revenue. Cash comes in up front, but it isn't earned until the service is delivered — so every unredeemed tox package or filler series is a liability you owe clients, and a recurring membership is only as good as its redemption and churn. This dashboard makes the prepaid book visible: how much you owe, how much is being redeemed, what's about to expire, and how healthy the recurring base is.
What this report answers
How much outstanding liability are we carrying — prepaid value collected but not yet delivered? What's our redemption rate, and which package types redeem well versus pile up unused? How much value sits on packages about to expire, where breakage is a real risk? And on the recurring side: how many active memberships, how much MRR, and how many members churned this period?
The metrics that matter
Outstanding liability is the sum of remaining value (purchased minus redeemed) — the truest picture of deferred obligation. Redemption rate, redeemed over purchased, shows whether clients actually use what they buy; low redemption is a retention and satisfaction warning, not a windfall. Breakage at risk isolates remaining value on soon-to-expire packages so the front desk can drive redemption before it lapses. MRR and churn track the recurring engine that PE buyers value most.
Why the data is trapped across the systems
Boulevard, Mangomint, AestheticsPro, and Aesthetic Record sell and track packages, but they rarely roll the book up into a clean deferred-liability and redemption view across package types and membership tiers. Purchased value, redeemed value, expiry windows, and membership status live in different records, so the number an owner most needs at month-end — total liability owed and what's about to break — is the one the native reports don't produce.
How to read it
Start with outstanding liability and redemption rate together: a large liability with a low redemption rate means a lot of promised service hasn't been delivered, which threatens both future capacity and client satisfaction. Work the breakage-at-risk list to drive redemptions before they expire. On membership health, read MRR against churn — growing MRR with rising churn is a leaky bucket, and the by-tier view shows whether the VIP or basic tier is the problem.
The sample on this page uses entirely synthetic membership and package data — no real clients or financial records.
Metrics it tracks
| Metric | What it means |
|---|---|
| Outstanding Liability | Remaining unredeemed value of all prepaid packages and memberships — money already collected but still owed in services. |
| Redemption Rate | Redeemed value ÷ purchased value — how much of what clients prepaid they've actually used. |
| Breakage at Risk | Remaining value on packages close to expiry — liability that may go unredeemed if nothing is done. |
| Active Memberships | Currently active recurring memberships. |
| Monthly Recurring Revenue | Monthly fees across active memberships — the predictable revenue base. |
| Member Churn Count | Memberships that cancelled in the period. |
Used by: Owner and practice manager
Frequently asked questions
What is package liability in a med spa, and why does it matter?
Package liability is the value of prepaid services a client has bought but not yet redeemed — cash you've collected but still owe in treatments. It matters because it's deferred revenue and a future capacity obligation, and because high unredeemed liability signals clients aren't using what they bought, which hurts retention.
What is a good redemption rate for med spa packages?
Redemption rate is redeemed value over purchased value. Higher generally means clients are getting value and returning on cadence; low redemption is a warning sign of disengaged clients and looming breakage, not a profit. This report breaks redemption down by package type so you can see which offers actually get used.
Why do PE buyers and brokers care about MRR and churn?
Recurring membership revenue is predictable and sticky, so it commands a higher valuation multiple than one-off treatments. Buyers underwrite MRR net of churn — growing MRR with low churn is the strongest signal — which is why operators prepping for a sale watch both numbers, and by tier, closely.
Build this report on your own data
Clone this Med spas template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →