How to calculate gym revenue at risk
A simple, transparent formula for estimating how much renewal revenue needs attention — and the assumptions and limits worth knowing before you use it.
The formula
Revenue at risk = the sum of the plan price of every membership that is expiring within the coming week, plus every membership that has already expired.
In other words: take each at-risk membership, look up what that member's plan costs, and add them all together.
A worked example
Say 8 members are expiring this week on a 300 MAD monthly plan, and 4 members have already expired on the same plan.
8 × 300 + 4 × 300 = 3,600 MAD. That's the estimated revenue at risk for that week.
What this number does not mean
It's not a forecast of revenue you will collect — some members will renew, some won't, and the number doesn't predict which.
It's not an accounts-receivable balance or an unpaid-invoice total — it's based purely on membership expiry, not on payment or billing status.
It's not financial advice, and it isn't a substitute for proper bookkeeping if you need that for tax or accounting purposes.
What it's actually useful for
It's a prioritization signal: a way to see, at a glance, how much is genuinely worth following up on this week versus quietly assuming it's fine.
It's most useful as a recurring number you check regularly, not a one-time calculation — the memberships behind it change every day.
Calculating it by hand vs. automatically
You can absolutely do this in a spreadsheet: filter for expiring-this-week and expired memberships, multiply by plan price, and sum. The work is in keeping that filter current every single day.
Software that already tracks expiry dates and plan prices can keep this number current automatically, which is really the only thing that changes versus doing it by hand.
See your revenue at risk calculated automatically
Cuniro keeps this number current as memberships change.