.png){kind=logo}
OR1 Report
| OR1 Report is related to TfNSW ODIN Reporting requirements. The report summarizes the ticket sold revenues of reporting routes grouping by ticket type, passenger type, and the number of sections monthly. Note: This report is available if your company has paid for the OR1 Report module. |
- Login to Transportme™ Operator Portal.
- Select Reports tab on the main menu.
- Select OR1 Report tab on the side menu
- Filter data before generating the report:
- Include Historical Data: select this option to be able to search the deleted data.
- All Route:
- Select this checkbox to run the report on all routes in the system.
- Deselect this checkbox to be able to filter data by Route Categories and Routes.
- Route Category (mandatory): one or more route categories can be picked.
- Routes can be picked from selected route categories dropdown list added.
- Driver Name: All Driver or a specific driver can be chosen to run the report.
- Date Range-From and Date Range-To (mandatory): select the duration you wanted to generate the data.
- Select Export ODIN Report button to save the report as a CSV on your local storage. Note: 10% GST is excluded from reporting tickets sales.
Example of OR1 Report result:
Data description:
- CONTRACT_CODE
- This column is empty, it is not extracted from the system. Operator may need to enter the contract code manually.
- REPORTING_PERIOD
- It is the MONTH(s) of reporting data range.
- Eg: Date Range is from 01/11/2022 to 07/11/2022 then the REPORTING_PERIOD is 2022-11; Date Range is from 12/10/2022 to 07/11/2022 then the REPORTING_PERIOD is 2022-10 and 2022-11.
- TICKET_TYPE
- TfNSW ticket type is defined when a new ticket type is created or you can also edit it later.
- This report runs on non daily ticket type. A ticket type can be defined as non daily if Is Daily attribute is not selected when a new ticket type is created or edit.
- CASH: if the TfNSW ticket type of ticket sold is Adult Pax or Concession Pax and using price per section.
- RED - Regional Excursion Daily tickets: if the TfNSW ticket type of ticket sold is PET/RED.
- SSTS: The School Student Transport Scheme - NSW Government. When the driver select the button + Pax Count on the driver app, it will be counted to this type.
- SCHOOL_TERM_PASS: if the TfNSW ticket type of ticket sold is School Term Pass.
- CASH_NOT_REPORTED_RR: if the ticket type is Non Fare Paying Pax.
- PATRONAGE_TYPE. There are 3 patronage types categorised from TfNSW ticket types of ticket sold:
- ADULT: is linked to Adult Pax ticket type for TfNSW.
- CONCESSION: is linked to Concession Pax, PET/RED, School Term Pass, and Red reboard ticket type for TfNSW.
- OTHER: is linked to Non Fare Paying Pax ticket type for TfNSW.
- SECTION:
- It is the number of sections of ticket sold.
- NOT_APPLICABLE: when the ticket sold but not using sections.
- TICKET_SALES_VALUE: the revenue grouped by reporting months, patronage type, ticket type and number of travelled sections.
