Browse
 
Tools
Rss Categories

Sales By Category Report

Reference Number: AA-00654 Views: 7037 Created: 2011-12-13 09:29 Last Updated: 2017-09-14 11:38 0 Rating/ Voters

In this section

Sales By Category Report

Generate a Sales By Category Report

Print a Sales By Category Report

Export a Sales By Category Report

Drill Down into the Sales Per Vehicle Category


Sales By Category Report

The Sales By Category Report displays sales figures by vehicle category over a selected date range.


Back to top


Generate a Sales By Category Report

1. Open the Sales By Category Report page (Reports > Hireage and Sales Reports > Sales By Category Report), see Fig. 1.

 


Fig. 1. The Sales By Category Report page

 

2. On the Sales By Category Report page (see Fig. 2):

A. Select either a location or region. If you have selected a region the selected location will be disregarded.


B. Select a brand, if a brand is selected only bookings made under that brand will be displayed. 


C. Select a booking status. By default, booking status is set to Hired (include Returned). This means that all reservations with a Hired or Returned status will be included in the report.

NOTE: For more details on booking statuses, see the Reservations User Manual. 


D. Select what the date range applies to (date entered, drop off date or pick up date). 


E. Set the date range to view bookings for.

 


Fig. 2. The Sales By Category Report options

 

3. Click "View" to generate a report ordered by category (see Fig. 3).

 


Fig. 3. Generated Sales By Category Report

 

NOTE: For more details on vehicle categories, see the Vehicle Maintenance User Manual.

 

Once you generate the report, you can export it as a PDF, an Excel document or display a print friendly version of the report. You can also drill down into the details of the bookings for that vehicle category by clicking the category name.

 

NOTE: Table 1 shows descriptions of each column found in the Sales By Category Report.


Back to top

 

Print a Sales By Category Report

1. Generate a Sales By Category Report (see Generate a Sales By Category Report).

 

2. After generating the report, click the printer icon to display a printer-friendly version of the report (see Fig. 4).

 


Fig. 4. Report formatted for printing

 

3. Print the report using your browser's built in print feature.


Back to top

 

Export a Sales By Category Report

1. Generate a Sales By Category Report (see Generate a Sales By Category Report).

 

2. After generating the report, click the Excel button to export the report as an Excel spreadsheet. The report can also be exported as a PDF document by clicking the PDF button (see Fig. 5).



Fig. 5. Export options 

 

Back to top


Drill Down into the Sales Per Vehicle Category

1. Generate a Sales By Category Report (see Generate a Sales By Category Report).

 

2. Click the name of the vehicle category (highlighted in red) to view the details of the bookings for that vehicle category (see Fig. 6). 

 


Fig. 6. View bookings for an individual category

 

Table 1. The Sales By Category Report columns

Report Column

Description

Category

The vehicle category description 

No. of Contracts 

The total number of contracts for a vehicle category

Insurance Applied %

No. of Contracts with Insurance / Total No. of Contracts

No. Of Days Hired

The total number of days hired for all contracts.

Average Length of Hire

No. of Days Hired / No. of Contracts

Adjusted Rate

Total Revenue / No. of Days Hired

Rental Revenue

Total No. of Days x Daily Rate

Insurance RevenueTotal revenue from insurance 

Extra Revenue

Total of all extra fees charged excluding Recovered Expenses and Bond Fees

Total Revenue

Rental Revenue + Extra Revenue

GST

The total tax charged, i.e. GST for Australia or the regional name for tax in a specific country

LYTD 

Last Year-to-Date Total Revenue

% diffPercentage difference 


Back to top