The Membership Status report gives you a live snapshot of every membership by lifecycle stage — active, frozen, cancelled, expired, suspended, or about to expire — organised into seven tabs, with a Summary dashboard you can click through to the detail.
It answers: how many memberships are in each state right now, which memberships are about to expire, and — for any state — who the members are, when each membership was activated, and when it expires.
For example, on the Summary tab, clicking the "Frozen recurrences" card jumps straight to the Frozen tab, where every frozen membership is listed with the client, plan, location, activation date and expiry date.
NOTE: This report looks different from its sibling membership reports — it's organised as tabs rather than the standard filter bar, and it has no Print button, column manager, or date-range filter.
How to find it
Step 1: Navigate to the Analytics Feature
Log in to your Pabau account, and in the left sidebar menu, go to Analytics, then click on the "Reports" button.
Step 2: Access the reports banner
On the "Try our new suite of reports" banner, click Try it now.
Once you're in the new reports view, go to the Memberships section, scroll to the "Members & status" group, and click on Memberships — Status (marked with a "New" badge) to open the report. The opened page is titled Membership Status.
The seven tabs
The report is split into a Summary tab followed by six list tabs: About to expire, Active, Frozen, Cancelled, Expired, and Suspended. The selected tab (along with your location filter and expiry window) is kept in the page URL, so you can bookmark a view or share a link that opens straight on, say, the Cancelled tab.
The Summary tab
Eight stat cards give you the headline counts. Click a card to jump to the matching list tab.
| Card | What it counts | Jumps to |
|---|---|---|
| Active non-recurring | Active memberships that don't renew automatically. | Active tab |
| Active recurrences | Active recurring memberships. | Active tab |
| Cancelled recurrences | Recurring memberships that have been cancelled. | Cancelled tab |
| Frozen recurrences | Recurring memberships currently frozen (on hold). | Frozen tab |
| Expired recurrences | Recurring memberships that have expired. | Expired tab |
| Upgraded/downgraded recurrences | Recurring memberships that were moved to a different plan. | — (count only, no detail tab) |
| Suspended recurring | Recurring memberships currently suspended. | Suspended tab |
| About to expire (next 30d) | Memberships due to expire within the next 30 days. | About to expire tab |
NOTE: The "Upgraded/downgraded recurrences" card is a count only — it has no matching detail tab, so it's the one card that isn't clickable.
The list tabs
Each list tab shows a table of the memberships in that state. Every table uses the same nine columns:
| Column | What it shows | Sortable |
|---|---|---|
| Member ID | The membership record's ID (e.g. #2041). | Yes |
| Client name | The member's name. Click it to open their client card. | No |
| The client's email address. | No | |
| Membership | The membership plan name (e.g. Glow Membership). | No |
| Location | The location the membership belongs to. | No |
| Status | A colour-coded pill with the membership's current status. | No |
| Type | Recurring or Non-recurring. | Yes |
| Activated | The date the membership was activated. | Yes |
| Expires | The date the membership expires. | Yes |
Click a sortable column's header to sort the tab by it, and click again to flip the direction.
Filters on the list tabs
- Location – A searchable dropdown that defaults to All locations and narrows the current tab to one location.
- Expiring within N days – On the About to expire tab only: a numeric input (default 30) controlling how far ahead the tab looks for expiring memberships.
NOTE: Each list tab loads up to 200 memberships, and the Location filter narrows within those loaded rows. On a very large member base, export the tab or check the count label to make sure you're seeing the full picture.
Toolbar actions
| Control | What it does |
|---|---|
| Export CSV | Downloads the current tab as a CSV file (e.g. membership-status-active-2026-08-04.csv). The file contains ten columns — the nine on screen plus Client ID. The button is disabled while the tab has no rows. |
| Run | Re-runs the current tab's data. |
| Count label | Shows how many memberships are listed on the tab (e.g. "34 memberships"). |
If nothing matches, the About to expire tab reads "No memberships will expire in the chosen window."; the other tabs suggest trying a different tab or clearing the location filter.
NOTE: This report lives in the Memberships category of the new reports view, which is visible to users holding the "Can access sales company reports" permission (alongside "Can access reports page"). There is no separate per-report permission.
Related guides
- Memberships - Members Report — the roster of every member and add-on member.
- Memberships - Payments Report — every membership installment and its collection status.
- New Memberships Report — every membership sold within a date range.
With this understanding, you can confidently use the Membership Status report to keep a live pulse on your member base — from the headline counts on the Summary tab down to exactly which memberships are frozen, cancelled, or about to expire.
Was this guide helpful? Let us know by voting below - your feedback helps us write clearer articles.
For more guides, browse the related articles below or use the search bar at the top of the page. You can also watch our video learning series, the Pabau Academy, or visit the Support page for additional help.