Browse
 
Tools
Rss Categories

Forward Bookings Report

Reference Number: AA-00663 Views: 7323 Created: 2011-12-13 17:12 Last Updated: 2012-01-05 17:31 0 Rating/ Voters

In This Section

Forward Bookings Report

To Generate a Forward Bookings Report

To Print a Forward Bookings Report

To Export a Forward Bookings Report to Excel

Summary


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