Step-by-Step Guide — Follow each step exactly as written. All values are provided — do not improvise.

TC-RPT-002: Membership Reports (Detailed)

Module: Reporting - Membership

Primary Test User: admin@rcme.membervu.com / Admin123! (Admin)

URLs for this test:
Frontend: https://stg-rcme.membervu.com/login

Step 1: Login and Navigate to Reports

Step	Action (EXACT clicks/typing)	Expected Result (EXACT text/behavior)	Test Value
1	Open your browser and go to: `https://stg-rcme.membervu.com/login` Enter email: `admin@rcme.membervu.com` Enter password: `Admin123!` Click "Sign In".	Login succeeds. Dashboard loads.	Email: `admin@rcme.membervu.com` Password: `Admin123!`
2	If tour appears, click "Skip". Navigate to Admin > Reports.	Reports page loads.	-

Purpose: Verify the count of active members broken down by membership type.

Step	Action (EXACT clicks/typing)	Expected Result (EXACT text/behavior)	Test Value
1	Click on "Membership Report" or "Member Statistics".	Membership report loads.	-
2	Look for a breakdown of active members by membership type.	Report shows counts for each type: - Regular Member: (count) - Associate Member: (count) - Student Member: (count) - Total Active: sum of above	Types: Regular, Associate, Student
3	Verify the total equals the sum of individual type counts.	Total active members = Regular + Associate + Student counts.	-

PASS if: Active member counts by type are displayed and total is correct.

Purpose: Verify the report shows new members for different time periods.

Step	Action (EXACT clicks/typing)	Expected Result (EXACT text/behavior)	Test Value
1	Look for a "New Members" section or filter. Select time period: This Month.	Shows count (and optionally a list) of members who joined this month.	Period: This Month
2	Change time period to: This Quarter.	Count updates. Should be equal to or greater than the monthly count.	Period: This Quarter
3	Change time period to: This Year.	Count updates. Should be equal to or greater than the quarterly count.	Period: This Year

PASS if: New member counts are shown for month/quarter/year and are logically consistent (month ≤ quarter ≤ year).

Purpose: Verify a visual chart or trend line showing membership growth over time.

Step	Action (EXACT clicks/typing)	Expected Result (EXACT text/behavior)	Test Value
1	Look for a "Growth Trend" chart or graph on the membership report page.	A line chart or bar chart displays membership count over time (monthly or quarterly data points).	-
2	Hover over data points on the chart (if interactive).	Tooltip shows the exact count and period (e.g., "March 2026: 42 members").	-

SKIP if: No growth trend chart is available. Mark as NOT IMPLEMENTED.

Purpose: Identify members whose memberships are expiring soon.

Step	Action (EXACT clicks/typing)	Expected Result (EXACT text/behavior)	Test Value
1	Look for an "Expiring Memberships" section or filter. Select: Next 30 days.	Shows members expiring within 30 days. May be 0 if none are close to expiry.	Period: Next 30 days
2	Change to: Next 60 days.	Count updates (should be ≥ 30-day count).	Period: Next 60 days
3	Change to: Next 90 days.	Count updates (should be ≥ 60-day count).	Period: Next 90 days
4	If a list is shown, verify each entry includes: member name, membership type, and expiration date.	Each row shows the member's name, their membership type, and the exact expiration date.	-

PASS if: Expiring memberships report shows accurate counts for 30/60/90-day windows.

Purpose: Verify retention rate metric is displayed.

Step	Action (EXACT clicks/typing)	Expected Result (EXACT text/behavior)	Test Value
1	Look for a "Retention Rate" metric on the membership report page.	A percentage is displayed (e.g., "85% retention rate"). This represents the proportion of members who renewed their membership.	-
2	Check if the rate seems reasonable (between 0% and 100%).	The value is a valid percentage. It should not be negative or exceed 100%.	-

SKIP if: Retention rate metric is not available. Mark as NOT IMPLEMENTED.