Revenue by Student Report : RollCall

Support Document for Revenue By Student Report

Report Name:

Revenue By Student Report

Overview:

The Revenue By Student Report provides detailed information about the revenue generated by each student within a specified date range. This report includes data such as the number of trips taken by each student and the total revenue generated from these trips. It is essential for understanding the contribution of individual students to the overall revenue and for managing transportation services effectively.

Report Type:

Financial Report

Key Information Provided:

Student's first and last name
Student number
Number of trips taken
Total revenue generated

How to Generate the Report/Filters:

Steps:

Access your school's RollCall Admin Console.
Select "Reports" from the navigation bar.
Select "Revenue By Student Report" from the dropdown or the report icons.
Apply relevant filters such as date range, bus, and student.
Click "Run Report."
Use the on-screen report tool or export the report to PDF or Excel.

Filter Information:

From Date/To Date: Specify the date range for which you need the report. For this report, the date range is from 05/07/2024 to 05/07/2024.
Bus: Select "ALL" to include all buses or specify individual buses.
Student: Select "ALL" to include all students or specify individual students.
Organisation: Select the organisation or school to which the report pertains. Ensures the data is relevant to your institution.

Understanding the Report:

Columns:

First Name: The first name of the student. Example: John.
Last Name: The last name of the student. Example: Doe.
Student Number: The unique identifier for the student. Example: 123456.
Number of Trips: The total number of trips taken by the student. Example: 5.
Total Revenue: The total revenue generated from the trips taken by the student. Example: $50.00.

Total Row:

Total: Aggregates the total number of trips and total revenue for all students within the specified date range. Example: 0 trips, $0.0 revenue.

Key Metrics:

Number of Trips: Tracks the total number of trips taken by each student.
Total Revenue: Monitors the total revenue generated from student trips.
Average Revenue per Trip: Provides insight into the average revenue generated per trip by each student.

Common Use Cases:

Revenue Tracking: Monitoring the revenue generated by individual students to understand their contribution to overall revenue.
Service Planning: Planning and adjusting transportation services based on the demand from students.
Financial Reporting: Including student revenue data in financial reports and analyses.

Tips for Interpretation:

Identify High Revenue Students: Focus on students who generate the most revenue to understand their travel patterns and preferences.
Monitor Trip Frequency: Track the frequency of trips taken by students to identify trends and make data-driven decisions.
Analyse Revenue Trends: Use the report to analyse revenue trends from students over time and adjust services accordingly.

Related Reports:

Overdue Balance Report: Provides detailed information on students with overdue balances.
Revenue By Casual Traveller Report: Offers insights into revenue generated by casual travellers.
Customer Statement Report: Summarises all financial transactions and balances for each customer.

Troubleshooting:

Missing Data: Ensure that the report is generated for the correct date range and filters are applied properly.
Incorrect Filters: Double-check the filters to ensure they align with your reporting needs.
Data Discrepancies: Verify data entries in the RollCall system for accuracy if discrepancies are found in the report.

Additional Resources:

(To be filled in by the support team)

This support document should help you understand and effectively utilise the Revenue By Student Report in your RollCall system. If you encounter any issues or have further questions, please contact our support team.