Reports Overview

Student Journey Reports

Bus Check Report

• Purpose: Track bus checks for child safety compliance (driver, supervisor, teacher).
• Filters: Date Range, Route, Route Group, Organisation
• Outputs: Date, Event Group, Bus, Bus Check, Driver, Supervisor Check, Teacher Check

Trip and Exception Detail Report

• Purpose: Provides a comprehensive view of student trips with all exception data (e.g. no card, non-allocated stops, etc.). Used to analyse patterns and investigate issues across routes or students.
• Filters: Date Range, Student, Bus, Exception Type
• Outputs: Date, Event Group, Bus, First Name, Last Name, Student Number, Campus Scan On Time, Scan On, Location, Scan Off Time, Scan Off Location, Transit Time, Exceptions, Travelled/Not Travelled, Stop Status, Allocated Stop AM, Allocated Stop PM, Not Allocated, No Card, Driver

Trip Details Report

• Purpose: Provides a clean, detailed view of trips and movements only (no exception analysis). Best used for answering “who travelled, when, and where”.
• Filters: Date Range, Student, Bus, Organisation
• Outputs: Date, Event Group, Bus, Student Info, Grade, Campus, Scan On/Off Times & Locations, Transit Time

Exception Summary Report

• Purpose: Compare exception frequency across routes.
• Filters: Date Range, Organisation
• Outputs: Exception Type, Bus, Event Group, Count

Stop Activity Report

• Purpose: Analyse stop usage and identify underutilised stops.
• Filters: Date Range, Stop, Organisation
• Outputs: Stop Details, Scan On/Off Counts, Usage %

Student & Parent Reports

Parent Report (Master Report)

• Purpose: View parent details, linked students, balances, and engagement.
• Filters: Parent Role, Student, Active Status, Association, Organisation
• Outputs:
  Parent Info, Student Info, Balance Fields, Booking/Payment Options, Engagement Data

Student Report

• Purpose: Master dataset of all student information.
• Filters: Active Status, Organisation
• Outputs: Student Details, Campus, Booking/Payment Info, Billing, Status

Student Code History Report

• Purpose: Track student card/code changes.
• Filters: Date Range, Student Name/Number, Organisation
• Outputs: Date, Student Info, Old Code, New Code

Financial Reports

Customer Statement Report

• Purpose: Full financial transaction history per student.
• Filters: Status, Date Range, Student, Organisation
• Outputs: Transaction Type, Status, Date, Amount, Balance, Notes, Gateway ID

Revenue Summary Report (Previously Revenue by Student)

• Purpose: Analyse revenue per student or route.
• Filters: Date Range, Bus, Student, Organisation
• Outputs: Student Info, Trip Count, Total Revenue

Transport Reports

Bus Stop Report

• Purpose: Confirm if buses are stopping at specific stops and duration.
• Filters: Date Range, Bus, Driver, Organisation
• Outputs: Stop, Entry/Exit Time, Duration

Bus Utilisation Report

• Purpose: Compare expected vs actual bus usage.
• Filters: Date Range, Utilisation Thresholds
• Outputs: Capacity, Expected vs Actual Travellers, Utilisation %

Campus KPI Report

• Purpose: Monitor on-time arrivals/departures at campus.
• Filters: Date Range, Campus, Bus Group, Bus, Driver, Organisation
• Outputs: Expected vs Actual Times, Variance, Driver

First Stop KPI Report

• Purpose: Measure punctuality at first stop (AM routes).
• Filters: Date Range, Bus, Driver, Organisation
• Outputs: Expected vs Actual Arrival/Departure Times

Transit Times KPI Report

• Purpose: Evaluate total route duration vs expected time.
• Filters: Date Range, Bus, Driver, Organisation
• Outputs: Estimated vs Actual Transit Time, Variance %

Student Stop Report

• Purpose: View which students are assigned to stops.
• Filters: Date Range, Student, Stop, Organisation
• Outputs: Student Info, Route, Stop, Booking Details

Student Transport Report

• Purpose: View future student bookings (routes and stops).
• Filters: Date Range, Student, Grade, Campus, Organisation
• Outputs: Student Info, AM/PM Routes and Stops