In This Section
Sales By Location Report
The Sales by Location Report displays
sales figures by booking source over a selected date range.
Back to Top
To Generate a Sales by Location
Report
1. On the Reports menu, click the Hireage
and Sales Reports tab.
2. Click Sales by Location Report (see
Fig. 294).
Fig. 294. Click Sales by Location
Report
3. On the Sales by Location Report Page
(see Fig. 295):
A. Select either a location or region. By
default, location is set to your default location. When generating a report, if
you have selected a region, Rental Car Manager will disregard the
location.
B. By default, booking status is set to
Hired (include Returned). This means that all reservations with status = Hired
and status = Returned will be included in the report. You may change the booking
status, if needed.
NOTE: For more details on booking
statuses, see the Reservations User Manual.
C. Pickup date range is set to the current
system date. You may change the date range, if needed.
Fig. 295. The Sales by Location Reports
Page
4. Click View to generate a report ordered by
location (see
Fig. 296).
Fig. 296. The Sales by Location
Report
Once you generate the report, you can
print it and export it to Excel. You can also drill down into the details of the
bookings for that vehicle category.
NOTE: Table 64 shows descriptions of each column found
on the Sales by Location Report.
Back to Top
To Print a Sales by Location
Report
1. Generate a Sales by Location report
(see To Generate a Sales by Location Report).
2. After generating the report, click
Print to display a printer-friendly version of the report in a separate browser
window (see Fig. 297).
Fig. 297. A Printer-Friendly Sales by
Location Report
3. Print the report using your browser's
Print feature.
Back to Top
To Export a Sales by Location Report to
Excel
1. Generate a Sales by Location report
(see To Generate a Sales by Location Report).
2. After generating the report, click
Excel.
3. You will be asked to either open or
save the Excel file (see Fig. 298). To open the file in MS Excel, click
Open. To save the file to your local drive, click Save.
Fig. 298. Click Either Open or
Save
4. If you choose to open the file in Excel
in Step 3, you can save the file by using Excel's Save As feature. If you choose
to save the file to your local drive, navigate to the location on your local
drive where you save the file and click the file to open it in Excel. Fig. 299 shows a sample Sales by Location report
exported to Excel.
Fig. 299. A Sales by Location Report
Exported to Excel
NOTE: Depending on the browser you are
using to access Rental Car Manager, you may be prevented from opening an Excel
file from the Internet on your computer. To resolve this problem, see the FAQ
section on the Rental Car Manager Help Center.
Table 64. The Sales by Location Report
Columns
|
Column Name
|
Description
|
|
Location
|
The location or branch name
|
|
No. of Contracts
|
The total number of contracts for a location
|
|
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
|
|
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
|
|
% Diff
|
The % change between the current year's total
revenue and last year's total revenue
|
Back to Top
Summary
This article details the Sales By Location
Report tab, where a report that displays
sales figures by booking source over a selected date range is generated.
The Sales By Location Report screen allows you to view, print,
or export to excel the Sales By Location
Report.
Back to Top
Categories 