# Registration Fees Analytics - User Guide

## Overview
The Registration Fees Analytics page provides comprehensive insights into client registration fees, payment status, and collection performance.

## Accessing the Page
1. Navigate to the Reports Dashboard
2. Click on "Registration Fees" or "Registration Fees Analytics"
3. The page will load at: `/reports/registration-fees/`

## Page Features

### 1. Key Metrics (Top Row)
- **Total Registration Income**: Total amount collected from paid registration fees
- **Total Registrations**: Total number of client registrations (paid + pending)
- **Average Fee**: Average registration fee amount
- **Collection Rate**: Percentage of fees successfully collected
- **Monthly Growth**: Growth rate compared to previous period

### 2. Payment Status Breakdown
- **Paid Registrations**: Number and amount of paid fees
- **Pending Payments**: Number and amount of pending fees
- **Overdue Payments**: Number and amount of overdue fees
- **Waived Fees**: Number and amount of waived fees

### 3. Filters
Use the filter section to customize your view:

#### Period Filter
- Current Month
- Last Month
- Current Quarter
- Last Quarter
- Current Year
- All Time
- Custom Range

#### Date Range
- Start Date: Filter registrations from this date
- End Date: Filter registrations up to this date

#### Payment Status
- All Status: Show all registrations
- Paid: Show only paid fees
- Pending: Show only pending fees
- Overdue: Show only overdue fees
- Waived: Show only waived fees

### 4. Detailed Table
The table shows all registration fees with:
- **Client Details**: Name, phone number, ID number
- **Registration Date**: When the client was registered
- **Fee Amount**: Registration fee amount
- **Payment Status**: Badge showing paid/pending/overdue/waived
- **Payment Date**: When payment was made (if paid)
- **Payment Method**: How payment was made (M-Pesa, Cash, Bank Transfer)
- **Notes**: Additional information
- **Actions**: Buttons to record payment, view client, or print receipt

### 5. Summary Statistics
Three summary cards showing:
- **Collection Summary**: Fees collected, outstanding, and efficiency
- **Performance Metrics**: Growth trends and comparisons
- **Period Comparison**: Current vs previous period

## Using Filters

### Example 1: View Current Month Paid Fees
1. Select "Current Month" from Period dropdown
2. Select "Paid" from Payment Status dropdown
3. Click "Apply Filters"

### Example 2: View Custom Date Range
1. Select "Custom Range" from Period dropdown
2. Enter Start Date (e.g., 2025-01-01)
3. Enter End Date (e.g., 2025-01-31)
4. Click "Apply Filters"

### Example 3: View Pending Payments
1. Select "All Time" from Period dropdown
2. Select "Pending" from Payment Status dropdown
3. Click "Apply Filters"

## Exporting Data

### Export to Excel
1. Click the "Export Excel" button
2. File will download with all filtered data
3. Open in Excel or Google Sheets

### Export to PDF
1. Click the "Export PDF" button
2. PDF will download with charts and tables
3. Suitable for printing or sharing

## Understanding the Data

### Collection Rate
- Formula: (Paid Fees / Total Expected Fees) × 100
- Example: If 9 out of 12 fees are paid, collection rate is 75%

### Average Fee
- Formula: Total Paid Amount / Number of Paid Registrations
- Example: KSh 4,500 / 9 = KSh 500 average

### Monthly Growth
- Compares current period to previous period
- Positive percentage indicates growth
- Negative percentage indicates decline

## Common Tasks

### 1. Check Today's Collections
- Set Period to "Current Month"
- Set Payment Status to "Paid"
- Review the table for recent payments

### 2. Follow Up on Pending Payments
- Set Payment Status to "Pending"
- Review the list of clients
- Use phone numbers to contact clients
- Click "Record Payment" when payment is received

### 3. Generate Monthly Report
- Set Period to "Current Month"
- Review all metrics
- Click "Export PDF" for management report

### 4. Analyze Collection Performance
- Set Period to "Current Quarter"
- Review Collection Rate metric
- Compare with previous quarter
- Identify trends and patterns

## Tips for Best Results

1. **Regular Updates**: Ensure registration fees are recorded when clients register
2. **Accurate Data**: Verify payment methods and dates are correct
3. **Follow Up**: Use pending payments list for collection follow-ups
4. **Branch Filtering**: If using multiple branches, select appropriate branch
5. **Export Regularly**: Download reports for record-keeping

## Troubleshooting

### No Data Showing
- Check if any clients have registration fees set
- Verify branch filter is not excluding data
- Try "All Time" period to see all data

### Incorrect Totals
- Verify all payments are marked correctly
- Check for duplicate entries
- Ensure payment dates are accurate

### Filter Not Working
- Clear all filters and try again
- Refresh the page
- Check date format (YYYY-MM-DD)

## Current Data Summary
Based on the latest test:
- **Total Registrations**: 12 clients
- **Total Income**: KSh 4,500.00
- **Paid**: 9 clients (KSh 4,500.00)
- **Pending**: 3 clients (KSh 1,500.00)
- **Collection Rate**: 75.0%
- **Average Fee**: KSh 500.00

## Next Steps
1. Review the current data
2. Set up regular collection follow-ups
3. Export monthly reports for management
4. Monitor collection rate trends
5. Adjust registration fee amounts as needed

## Support
For issues or questions:
1. Check this user guide
2. Review the technical documentation
3. Contact system administrator
4. Check the test scripts for data verification

---

**Last Updated**: November 28, 2025
**Status**: ✅ Fully Functional
