Operating Control By Res Report
Purpose:
The Operating By Res report is similar in functionality to the standard Operating Control Report with the difference being that this report focuses on individual reservations rather than vehicles.
The report shows a breakdown of the revenue generated per reservation grouped by vehicle category. This gives you an overview of the revenue generated by each reservation and vehicle category for a selected date range, location, region, brand and category type. The Operating Control By Res report also shows daily averages for the selected period, for example net daily average and gross daily average. It also shows the net daily dollar average per vehicle category as well as the gross daily dollar average.
The net daily dollar average is computed by dividing the rental revenue over the number of days hired while the gross daily dollar average is computed by dividing the total rental revenue over the number of days hired.
Accessing Operating Control By Res Report:
Reports >> Monthly Financial Reports >> Operating Control Report >> Operating Control By Res
Parameters/Filters:
Pickup Location | This report can be run for All Locations or a specific location |
Region | This report can be run for All Regions or a specific region |
Brands | If branding has been turned on within the RCM system, this report can be run for All Brands or a specific brand |
| Category Type | This report can be run for All Category Types or a specific category type. |
Date Range | The date rang this report will be run for. |
Example:
Res | The reservation number included in this report. Clicking on the red reservation number will open the Booking Details screen. |
Category | The vehicle category assigned to the booking |
Model | The model of the vehicle assigned to the booking |
Rego#/Fleet# | The following information will appear in this field, the model, registration number and fleet number for the vehicle. |
No Days Rented | The number of days that this booking was rented during the reporting period. |
No Days Insurance Sold | The number of days that had insurance sold for this booking during the reporting period. |
Rental Revenue | The rental revenue for this booking during the reporting period. |
Insurance Revenue | The insurance revenue for this booking during the reporting period. |
Extras Revenue | The extras revenue for this booking during the reporting period. |
Total Revenue | The total revenue for this booking during the reporting period. |
DDA Nett | This amount is the daily value of the Rental Revenue. It is calculated by Rental Revenue divided by No Days Rented. |
DDA Insurance | This is the daily amount for the insurance. It is calculated by Insurance Revenue divided by No Days Rented. |
DDA Gross | This is the daily value for the total cost of the booking. It is calculated by Total Revenue divided by No Days Rented. |
Pickup Location Pickup Date Dropoff location Dropoff Date | Pickup and Dropoff details of the booking |
Reference Number | The reference number against the booking |
Kms Out Kms In | The kms out and in recorded against the booking |
Company | The Company name against the booking if any |
Customer | The Customer name against the booking |
| Status | The booking status |
Points to Note:
- Vehicles are only included in this report if they have bookings that fall within the reporting period
- Report values are calculated based on the No. of Contract days (Hired or Returned) in the Selected Date Range
- No. of Contract days are calculated based on the category rate type. if category rate type is 12 hours, you may see the No. Days Rented field contain a value of 1 more than the no. of days in the report period.
- If the No. Days Rented is more than the no. of days in the report period, you may have charged for more days, i.e., 2 bookings in one day or an early return. Also, if a booking has a change of vehicle, then the entire number of days for the booking will appear against the vehicle on this report.
- Extra Revenues do not include Recovered Expenses and Bond
- All Revenues include Country Sales Tax, not include State Sales Tax
- DDA Nett (Daily Dollar Average Nett) is calculated by Rental Revenue/Days
- DDA Gross (Daily Dollar Average Gross) is calculated by Total Revenue/Days
Printing/Exporting:
Click here for details on how to print or export a report from RCM