The Revenue Data Report gives detailed financial information that can be grouped and sorted in numerous ways. The Per Ride data this report provides can be extremely helpful in monitoring your transit operations revenues.
The Revenue Data report pulls in completely validated trips with completely validated Rides. The most important thing to consider when looking at the Revenue Data report is that it probably will not ever match your Ride Data and Ride Detail reports unless you never bill for No Shows. The Revenue Data report pulls in all billable Rides. In other words, you could have a billable No Show that shows up on the Revenue Data report but doesn’t show up on the Ride Data and Ride Detail Reports. These two reports show very detailed information such as passenger miles, passenger hours, pickup time and dropoff time, which would not pertain to a No Show. The Ride Status Report would show you the No Show because No Show is a Status. One final thing to note when looking at the Revenue Data Report is the possibility of a minimum mileage charge in the Account Master.
*If a Ride on a Validated Trip is marked as Not Validated from Daily Schedule or from Validation but the trip isn’t resaved, the Revenue Data report will still pull that Trip and all Rides into the report. If a Ride on a Validated Trip is marked as Not Validated in Validation, then saved, none of the Rides on the trip will show up on the Revenue Data Report*
Definitions:
Account (or other Group By option) = Account (or other Group By option)
Rides = Billable Rides
Units Pass Miles = Passenger Dropoff Odometer – Pickup Odometer from Rider Data
Pass Hours = Passenger Dropoff Time – Pickup Time from Rider Data
Wheelchair Revenue = Wheelchair charge from the Account X Number of Wheelchair Riders
Stretcher Revenue = Stretcher charge from the Account X Number of Stretchers
Invoice Revenue* = Total Revenue – Fare Collected
Revenue per Ride = Invoice Revenue*/Rides
Miles per Ride = Units Passenger Miles/Rides
Hours per Ride = Passenger Hours/Rides
Fare Collected = Fare Recorded in Rider Data
Total Revenue* = Invoice Revenue* + Fare Collected
Revenue per Ride = Total Revenue*/Rides
*Includes Amounts not shown = Wait, Escort, Extra, Maximum, Minimum, and No Show Charges from the Account Master.
Due to limited real estate on the report, we show you Wheelchair and Stretcher Revenue, and Fare Collected, but the charges mentioned above are all included in the Invoice Revenue, and subsequently the Total Revenue.