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

TC-RPT-001: Financial Reports (Detailed)

Module: Reporting - Financial

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

Alternate Test User: treasurer@demo.membervu.com / Treasurer123! (Treasurer — Ana Reyes)

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". In the sidebar, click "Admin" then "Reports" (or "Reporting").	Reports page loads showing report options or dashboard.	-

Purpose: Verify the revenue report shows correct totals and payment breakdown.

Step	Action (EXACT clicks/typing)	Expected Result (EXACT text/behavior)	Test Value
1	Click on "Revenue Report" or "Financial Summary" (or select "Revenue" from a report type dropdown).	Revenue report page or section loads.	-
2	Set date range to "This Year" (or select from January 1 to today's date).	Report data updates for the selected range.	Date range: This Year
3	Check the report summary. Look for: - Total revenue amount - Payment count - Breakdown by payment channel	Report shows: - Total Revenue: a PHP amount (e.g., "PHP 150,000.00") - Payment Count: number of payments - Breakdown: channels such as GCash, Maya, Credit Card, OTC channels (7-Eleven, M Lhuillier, Cebuana, Palawan, Bayad)	Expected channels: GCASH, MAYA, CREDITCARD, OTC_7ELEVEN, OTC_MLHUILLIER, OTC_CEBUANA, OTC_PALAWAN, OTC_BAYAD
4	Verify the total matches the sum of individual channel amounts.	The total revenue equals the sum of all channel breakdowns.	-

PASS if: Revenue report shows total, count, and channel breakdown that sum correctly.

Purpose: Verify dues collection report filters by membership type.

Step	Action (EXACT clicks/typing)	Expected Result (EXACT text/behavior)	Test Value
1	Navigate to "Dues Collection" report (or filter the financial report by dues).	Dues collection report loads.	-
2	Filter by Membership Type: Regular Member.	Report shows only Regular Member dues.	Membership Type: Regular Member
3	Check the expected amount per member.	Regular membership dues rate is PHP 15,000. The total should be PHP 15,000 multiplied by the number of paid Regular members.	Rate: PHP 15,000 per Regular Member
4	Change filter to Associate Member.	Report updates. Associate dues rate is PHP 10,000.	Rate: PHP 10,000 per Associate Member
5	Change filter to Student Member.	Report updates. Student dues rate is PHP 5,000.	Rate: PHP 5,000 per Student Member

PASS if: Dues collection report correctly filters by membership type and shows accurate amounts.

Purpose: Verify outstanding (unpaid) invoices are correctly identified.

Step	Action (EXACT clicks/typing)	Expected Result (EXACT text/behavior)	Test Value
1	Navigate to "Outstanding Invoices" report (or filter invoices by status).	Outstanding invoices report loads.	-
2	Filter by status: ISSUED and OVERDUE.	Report shows invoices that are either ISSUED (not yet due) or OVERDUE (past due date).	Status: ISSUED + OVERDUE
3	Check the total outstanding amount and invoice count.	Total outstanding amount is displayed (e.g., "PHP 45,000.00"). Invoice count matches the number of rows.	-
4	Verify individual rows show member name, invoice number, amount, and due date.	Each row contains: member name, invoice #, amount (PHP), status badge, and due date.	-

PASS if: Outstanding invoices report shows correct count and total for ISSUED + OVERDUE invoices.

Purpose: Verify report data can be exported.

Step	Action (EXACT clicks/typing)	Expected Result (EXACT text/behavior)	Test Value
1	On any of the report views above, look for an "Export" / "Download CSV" button. Click it. (All exports are CSV only* — there is no native Excel/XLSX export; the CSV opens fine in Excel/Sheets.)*	A file download starts. The file is a `.csv` file (no `.xlsx`).	-
2	Open the downloaded file in a spreadsheet application (Excel, Google Sheets, etc.).	The file opens correctly. Data matches what was displayed on the report page: same columns, same rows, same totals.	-
3	Verify column headers match the report columns.	Headers include relevant fields like: Member Name, Invoice #, Amount, Status, Date, Payment Channel, etc.	-

PASS if: Report exports successfully and data matches the on-screen display.