Sales By Location Report
Purpose:
The Sales by Location Report displays sales figures by Location over a selected date range.
Accessing Sales By Location Report:
Reports >> Hireage and Sales Reports >> Sales By Location
Parameters/Filters:
Pickup Location | Report can be run for All Locations or a specific Pickup Location |
Region | Report can be run for all regions or a specific region. If both a Pickup Location and a Region are selected, then the Region will be applied. |
Brand | Report can be all for All Brands or a specific Brand |
Category | Report can be run for All Categories or a specific Category. |
Booking Status | The status of the reservations included in the report. The options are:
|
Date Type | This report can either be run where the date range applies to either the pickup date, drop off date, or the date the booking was entered. |
Date Range | The date range that will be used. This will apply to either the pickup date or the date entered, depending on the date type chosen. |
Example:
Location | The Pickup Location of the reservations included in the report. If you click on the red location name, you can see a listing of the reservations for this location. |
No Contracts | The total number of reservations with this pickup location that fall within the parameters for this report. |
Insurance Applied % | The percentage of bookings with this pickup location and have had an insurance option applied. |
No Days Hired | The total number of days hired for the reservations with this pickup location that fall within the parameters for this report. |
Average Length of Hire | The average length of hire for the reservations with this pickup location that fall within the parameters for this report. |
Adjusted Rate | The average daily rental rate for the reservations with this pickup location that fall within the parameters for this report. Adjusted Rate is Total Revenue divided by the No of Days Hired |
Rental Revenue | The total of the rental rates for reservations with this pickup location that fall within the parameters for this report. |
Extras Revenue | The total of the Extra Fees and Insurance against reservations with this pickup location that fall within the parameters for this report. |
Extras Revenue Average/Day | The average daily cost of extra fees for reservations in this report. This is the Extras Revenue divided by the No Days Hired. |
Total Revenue | The Total Cost of reservations with this pickup location that fall within the parameters for this report. |
LYTD | The total cost of the reservations with this pickup location against them for the same time period last year. For example if you run the report for a date range of 1/Apr/2020 - 1/Oct/2020, then the LYTD will be the total for the date range 1/Apr/2019 - 1/Oct/2019. |
% diff | This is a comparison between the Total Revenue amount and the LYTD amount. This allows you to see whether you have more or less sales than last year. If there is no value for the LYTD, then this amount will be 0.00%. If there is a negative amount in this field, then this means that the LYTD amount was larger than the Total Revenue. |
2YTD | The total cost of the reservations with this pickup location against them for the same time period 2 years ago. This allows you to see whether you have more or less sales than 2 years ago. For example if you run the report for a date range of 1/Apr/2020 - 1/Oct/2020, then the LYTD will be the total for the date range 1/Apr/2018 - 1/Oct/2018. |
% diff | The percentage difference between the Total Revenue amount and the 2YTD amount. If there is no value for the 2YTD, then this amount will be 0.00%. If there is a negative amount in this field, then this means that the 2YTD amount was larger than the Total Revenue. |
The screen below is an example when you click on the red Location to see a drill-down of the bookings.
Res | The reservation number for the booking. Clicking on the red reservation number will open the Booking Details screen. |
Source | The rental source associated with the booking. |
Campaign Code | The campaign code associated with the booking. |
| Agency | The name of the agency associated with the booking. |
Reference No | The reference number associated with the booking. |
Customer | The name of the customer associated with the booking. |
| Suburb | The suburb saved against the customer on the booking |
Country | The country saved against the customer on the booking. |
Pickup Loc | The pickup location of the booking. |
Pickup Date | The pickup date of the booking. |
Drop Off date | The drop off date of the booking. |
Booked By | The name of the operator who created the booking. |
No Days | The number of rental days within the booking. |
Rental Revenue | The total rental revenue for the booking, this is the rental rates. |
Extra Revenue | The total cost of any extras associated with the booking. |
Insurance Fee | The cost of the insurance option associated with the booking. |
Total Revenue | The total cost of the booking. |
Points to Note:
- The Report is based on Pickup Location (or Region) and may be filtered by `Date Booked` or `Pickup Date` or `Dropoff Date`.
- All bookings including those with a status of Reservation, Hired and Returned that meet the selection criteria are reported on.
- The report does not include Non Revenue or Maintenance bookings
- The Extra Revenues do not include Recovered Expenses or Bond fees.
- The Adjusted Rate is Total Revenue divided by the No of Days Hired
Printing/Exporting:
Click here for details on how to print or export a report from RCM
Relevant Links:
Important Articles
Related Articles
Operator Sales Report
Purpose: The Operator Sales Report displays reservations made by operators. This report is useful in tracking an operator’s bookings and may contribute to tracking KPI’s and individual sales targets. The report can be run for all operators, or ...CDW Sales Summary Report
Purpose: The CDW Sales Summary report will show a summarised listing of any insurance that has been sold for bookings that fall within the date range. This report allows you to keep a track of the insurance options sold by staff members allowing for ...Sales By Month Report
Purpose: The Sales By Month report allows you to see a high-level summary of sales on a monthly basis. It also compares the sales data to the previous two years, allowing you to easily see the sales trend. Accessing Sales By Month Report: Reports >> ...Quotation Sales Report
Purpose: The Quotation Sales Report shows the quotations that were booked or converted to bookings. It allows for an easy way to see who converted quotes into bookings. The report groups the returning information by the operator who converted the ...CDW Sales Details Report
Purpose: The CDW Sales Details report will list any insurance that has been sold for bookings that fall within the date range entered as the reporting period. This report allows you to keep a track of the insurance options sold by staff members ...