In This Section
Forward Bookings Report
The Forward Bookings Report prints a
breakdown of forward bookings and compares these against the previous year. It
is selectable by pickup date range and includes an option for specifying booking
dates. For example you may wish to see the value of bookings over the next two
months that were booked in the first two weeks of the previous month given you
had a discount offer running in those two weeks.
The Forward bookings Report breaks down
revenues by
- Rental Revenue
- Extra Fees Revenue
- Insurance
Revenue
Back to Top
To Generate a Forward Bookings
Report
1. On the Reports menu, click the Hireage
and Sales Reports tab.
2. Click Forward Bookings Report (see
Fig. 306).
Fig. 306. Click Forward Bookings
Report
3. On the Forward Bookings Report Page
(see Fig. 307):
A. Select either a location or region. By
default, location is set to All Locations. When generating a report, if you have
selected a region, Rental Car Manager will disregard the location.
B. Pickup date range is set to the current
system date. You may change the date range, if needed.
C. Optionally, you may apply a booking
date range by selecting Apply Booking Date Range.
Fig. 307. The Forward Bookings Report
Page
4. Click View to generate a report ordered by
category. The order of the report is controlled by the 'Order By' field in the
Vehicle Categories page under the Vehicle Maintenance menu (see Fig. 308).
Fig. 308. The Forward Bookings
Report
NOTE: For more details on vehicle
categories, see the Vehicle Maintenance User Manual.
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 66 shows descriptions of each column found
on the Forward Bookings Report.
Back to Top
To Print a Forward Bookings
Report
1. Generate a Forward Bookings report (see To Generate a Forward Bookings Report).
2. After generating the report, click
Print to display a printer-friendly version of the report in a separate browser
window (see Fig. 309).
Fig. 309. A Printer-Friendly Forward
Bookings Report
3. Print the report using your browser's
Print feature.
Back to Top
To Export a Forward Bookings Report to
Excel
1. Generate a Forward Bookings report (see To Generate a Forward Bookings Report).
2. After generating the report, click
Excel.
3. You will be asked to either open or
save the Excel file (see Fig. 310). To open the file in MS Excel, click
Open. To save the file to your local drive, click Save.
Fig. 310. 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. 311 shows a sample Forward Bookings report
exported to Excel.
Fig. 311. A Forward Bookings 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 66. The Forward Bookings Report
Columns
|
Column Name
|
Description
|
|
Category
|
The vehicle category description
|
|
No. of Bookings (for a given date range from the
previous year)
|
The number of bookings for a given date range
last year
|
|
No. of Bookings (for a given date range during
the current year)
|
The number of bookings for a given date range
during the current year
|
|
Percentage Change
|
The percentage change in the number of bookings
between last year and this year
|
|
AVG Rental Duration Last Year
|
The average rental duration for last year
|
|
AVG Rental Duration This Year
|
The average rental duration for this year
|
|
Rental Revenue Last Year
|
Last year's rental revenue, excluding additional
fees such as insurance and extras
|
|
Rental Revenue This Year
|
This year's rental revenue, excluding additional
fees such as insurance and extras
|
|
AVG Rate Last Year
|
Last year's average rate for all bookings over
the reporting period
|
|
AVG Rate This Year
|
This year's average rate for all bookings over
the reporting perio
|
|
Extra Fees (Last Year)
|
Last year's extra fees totals, excluding
insurance
|
|
Extra Fees (This Year)
|
This year's extra fees totals, excluding
insurance
|
|
Insurance Fees (Last Year)
|
Last year's insurance fees totals
|
|
Insurance Fees (This Year)
|
This year's insurance fees totals
|
Back to Top
Summary
This article details the Forward Bookings
Report tab, where a report that prints a
breakdown of forward bookings and compares these against the previous year is generated.
The Forward Bookings Report screen allows you to view, print,
or export to excel the Forward Bookings Report.
Back to Top
Categories 